Release Notes 4.15

The 4.15 release notes were released on October 19, 2025

Compatibility Matrix

System Requirement

Details

Supported OS

RHEL 8.9 / 8.10 / 9.0

supported Nvidia driver

CUDA version 12.3.2 / 12.6.1 / 13.0

Storage version

65

New Features

► RHEL 9 Support: Full support has been added for running on Red Hat Enterprise Linux 9 (RHEL 9).

► SSL Port Control (SQ-21125): Added a configuration option to disable the SSL port functionality within the server picker feature.

Known Issues

Percentile is not supported for Window Functions

Version 4.15 resolved Issues

SQ No.

Description

SQ-19587, SQ-20891

Improved support for foreign tables

SQ-20689

Enhanced performance for catalog queries

SQ-20830

Service “compiling” is displayed as a service name during the compilation phase

SQ-20890

Added more logs visibility to the cleanup_extents process

SQ-20898

Made the internal permission keys representation more efficient

SQ-20927

Optimized memory usage when loading parquet files

SQ-20961

Stability improvements in queries using UNNEST

SQ-21081

Improved the mechanism for running Delete …. where exists ….

SQ-20997

Improved performance for PIVOT queries

SQ-21067

Fixed a compression related bug that sometimes caused data ingestion query to fail

SQ-21076

Improved performance of “unnest” function

SQ-21121

Enhanced visibility of queries using window functions

Deprecation

► Flag maxBlobSizeNetworkInsert depracted

  • Instead use maxBlobSize

► Column DDL permission

Column DDL permission is now deprecated as its functionality is fully included within the table DDL permission. Upon upgrading to this version, all existing column DDL permissions will be automatically revoked. If you are upgrading from a release using the old behavior, please contact SQream support prior to performing the upgrade.

► Haskell CLI

Starting October 2024, support for the Haskell CLI is discontinued, and it is replaced by the Multi Platform CLI that is compatible with the Haskell CLI with the added value of Table-View and cross platform compatibility.

► CentOS Linux 7.x

  • As of June 2024, CentOS Linux 7.x has reached its End of Life and is no longer supported by SQreamDB.

► DateTime2 Alias

As of April 2025, the alias DateTime2 for the DateTime Data Type has been deprecated to simplify our data model and make way for the introduction of a new data type named DateTime2.

Upgrading to Version 4.15

  1. Generate a back-up of the metadata by running the following command:

    select backup_metadata('out_path');

    Tip

    SQreamDB recommends storing the generated back-up locally in case needed.

    SQreamDB runs the Garbage Collector and creates a clean backup tarball package.

  2. Shut down all SQreamDB services.

  3. Copy the recently created back-up file.

  4. Replace your current metadata with the metadata you stored in the back-up file.

  5. Navigate to the new SQreamDB package bin folder.

  6. Run the following command:

    ./upgrade_storage <levelDB path>

Note

Upgrading from a major version to another major version requires you to follow the Upgrade Storage step. This is described in Step 7 of the Upgrading SQreamDB Version procedure.