Release Notes 4.9

The 4.9 release notes were released on Novemebr 28th, 2024

Compatibility Matrix

System Requirement

Details

Supported OS

RHEL 8.9

supported Nvidia driver

CUDA version 12.x

Storage version

57

Driver compatibility

  • JDBC 5.4.1

  • ODBC 4.4.4

  • NodeJS 4.2.4

  • .NET 5.0.0

  • Pysqream 5.3.0

  • SQLAlchemy 1.4

  • Spark 5.0.0

  • SQLoader As A Service 8.3

New Features and Enhancements

This release does not include any new features or enhancements

Known Issues

Percentile is not supported for Window Functions

Version 4.9 resolved Issues

SQ No.

Description

SQ-19055

Illegal memory access was encountered error

SQ-19053

Workers connectivity issues

SQ-19051

Compression related metadata issue

SQ-18745

Cannot grant select to a role on a table

SQ-16877

Query run time is longer than expected

Deprecations

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 compatability.

CentOS Linux 7.x

  • As of June 2024, CentOS Linux 7.x will reach its End of Life and will not be supported by SQreamDB. This announcement provides a one-year advance notice for our users to plan for this change. We recommend users to explore migration or upgrade options to maintain ongoing support and security beyond this date.

  • REHL 8.x is now officially supported.

Upgrading to Version 4.9

  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.