Release Notes 4.16

The 4.16 release notes were released on January 1st, 2026

Compatibility Matrix

System Requirement

Details

Supported OS

RHEL 8.9 / 8.10 / 9.5 / 9.6

supported Nvidia driver

CUDA version 12.3.2 / 12.6.1 / 13.0

Storage version

100

New Features

► Full nvcomp support.

► MCP interface support - allows you to query your data using natural language, using Claude as LLM. Please see MCP documentation.

► Add ANY syntax to Saved Query parameters should allow a dynamic IN list (SQ-22008). Please see Saved Query.

► Add support for casting TEXT_TO_ARRAY. Please see casting TEXT_TO_ARRAY.

► 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

The Node.JS connector does not support ARRAY data types.

Version 4.16 resolved Issues

SQ No.

Description

SQ-20089

Fixed issue with handling non-capturing group for REGEXP_SUBSTR and REGEXP_INSTR functions

SQ-20671

Window function over Parquet array data type is now supported

SQ-20732

Reduce compression size of ingested Parquet files

SQ-20894

Arrays are not supported within UDF - fix the error message accordingly

SQ-21028

Error when running ORDER BY with window function on a Datetime2 column

SQ-21157

Pivot function - performance improvements

SQ-21474

Fix the server status output on all available services

SQ-21482

Data sorting query failed in particular circumstances

SQ-21490

Improve metadata performance

SQ-21515

Expose schema information in UI Studio

SQ-20560

maxColSizeOnDiskMB suggested size increase is incorrect

SQ-20588

Resolve cudaErrorIllegalAddress error

SQ-21594

Improve Saved Query runtime

SQ-21742

Views with special characters failing Recompilation and Cleanup operations

SQ-21781

Improve compilation runtime

SQ-21805

DELETE WHERE EXISTS failed when adding external condition

SQ-21847

DELETE with JOIN table and WHERE EXISTS fails when adding condition outside of DELETE

SQ-21886

Enhance multiple ORC files load

SQ-21952

Improved stability of FileReaper mechanism

SQ-21991

List User Permission view

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

  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.