Release Notes 4.12
The 4.12 release notes were released on July 3rd, 2025
Compatibility Matrix
System Requirement |
Details |
---|---|
Supported OS |
RHEL 8.9 |
supported Nvidia driver |
CUDA version 12.3.2 |
Storage version |
62 |
New Features and Enhancements
► Metadata partitioning significantly reduces statement execution time when metadata contains millions of keys by intelligently leveraging previously created metadata partitions for efficient data skipping.
► New SQL syntax for PUT, GET, and REMOVE statements empowers users to directly write and read files to and from the SQDB cluster, leveraging its robust access control system.
► We’ve upgraded our platform to Java 17, delivering enhanced performance and the latest security features.
► The PIVOT functionality has been updated to support multi-column pivoting.
Known Issues
Percentile is not supported for Window Functions
Version 4.12 resolved Issues
SQ No. |
Description |
---|---|
SQ-19639 |
Consistency check does not recognize arrays. |
SQ-19869 |
Queries with numerous STDDEV aggregations are experiencing long compilation time. |
SQ-19879 |
Default permissions for saved queries are not automatically created upon new database creation. |
SQ-20146 |
The |
SQ-20400 |
Compiler throws an error when performing a join on encrypted columns. |
Deprecation
► 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
Effective April 2025, we’ve deprecated the alias ‘’DateTime2’’ for the ‘’DateTime’’ data type. This change streamlines our data model and prepares for the introduction of a new, distinct ‘’DateTime2’’ data type in the future.
Upgrading to Version 4.12
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.
Shut down all SQreamDB services.
Copy the recently created back-up file.
Replace your current metadata with the metadata you stored in the back-up file.
Navigate to the new SQreamDB package bin folder.
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.
Note
Column DDL permission is now deprecated as its functionality is fully included within the table DDL permission. For more info please refer to Deprecation