Release Notes 2022.1.4

The 2022.1.4 release notes were released on 10/11/2022 and describe the following:

Version Content

The 2022.1.4 Release Notes describes the following:

  • Security enhancement - Disable Python UDFs by default.

Storage Version

The storage version presently in effect is version 42.

Known Issues

No relevant Known Issues.

Resolved Issues

The following table lists the issues that were resolved in Version 2022.1.4:

SQ No.



Alter default permissions to grant update results in error


A correlated subquery is blocked when having ‘not exist’ where clause in update query

SQ-11686, SQ-11584

CUDA malloc error


Group by clause error


When executing copy from a parquet file that contain date values earlier than 1970, values are changed to 1970.

Operations and Configuration Changes

No configuration changes were made.

Naming Changes

No relevant naming changes were made.

Deprecated Features

SQream is declaring end of support of VARCHAR data type, the decision resulted by SQream’s effort to enhance its core functionalities and with respect to ever changing echo system requirements.

VARCHAR is no longer supported for new customers - effective from Version 2022.1.3 (September 2022).

TEXT data type is replacing VARCHAR - SQream will maintain VARCHAR data type support until 09/30/2023.

End of Support

No End of Support changes were made.

Upgrading to v2022.1.4

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

    $ select backup_metadata('out_path');


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

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

  2. Shut down all SQream services.

  3. Extract 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 SQream package bin folder.

  6. Run the following command:

    $ ./upgrade_storage <levelDB path>


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 SQream Version procedure.