Release Notes 2021.2

The 2021.2 release notes were released on 13/9/2021.

New Features 

The 2021.2 Release Notes include the following new features:

New Driver Compatibility 

The 2021.2 release supports the following drivers:

JDBC - new driver version (JDBC 4.5) with important bug fixes.
ODBC - ODBC 4.1.1. available on request.
NodeJS - all versions starting with NodeJS 4.0. SQream recommends the latest version (NodeJS 4.2.4).
Dot Net - SQream recommends version version 3.02 (compatible with DotNet version 48).
Pysqream - pysqream 3.1.2

Centralized Configuration System 

SQream now uses a new configuration system based on centralized configuration accessible from SQream Studio.

For more information, see the following:

Configuration - describes how to configure your instance of SQream from a centralized location.
SQream Studio 5.4.3 - configure your instance of SQream from Studio.

Qualifying Schemas Without Providing an Alias 

When running queries, SQream now supports qualifying schemas without providing an alias.

For more information, see SQream Studio 5.4.3.

Double-Quotations Supported When Importing and Exporting CSVs 

When importing and exporting CSVs, SQream now supports using quotation characters other than double quotation marks (").

For more information, see the following:

Note the following:

Leaving <x> unspecified uses the default value of standard double quotations ”.
The quotation character must be a single, 1-byte printable ASCII character. The same octal syntax of the copy command can be used.
The quote character cannot be contained in the field delimiter, record delimiter, or null marker.
Double-quotations can be customized when the csv_fdw value is used with the COPY FROM and CREATE FOREIGN TABLE statements.

The default escape character always matches the quote character, and can be overridden by using the ESCAPE = {'\\' | E'\XXX') syntax as shown in the following examples:

copy t from wrapper csv_fdw options (location = '/tmp/file.csv', escape='\\');

copy t from wrapper csv_fdw options (location = '/tmp/file.csv', escape=E'\017');

copy t to wrapper csv_fdw options (location = '/tmp/file.csv', escape='\\');

For more information, see the following statements:

Performance Enhancements 

In Version 2021.2, an advanced smart spooling mechanism splits spool memory based on required CP usage.

Resolved Issues 

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

SQ No.	Description
SQ-8294	Quote qualifiers were not present in exported file, preventing it from being reloaded.
SQ-8288	Saved `TEXT` query parameters were not supported.
SQ-8266	A data loading issue occurred related to column order.

Known Issues 

The Known Issues section is not relevant to Version 2021.2.

Naming Convention Modifications 

The Naming Convention Modifications describes SQream features, such as data types or statements, that have been renamed.

NVARCHAR Data Type Renamed TEXT

The NVARCHAR data type has been renamed TEXT.

For more information on the TEXT data type, see String (TEXT)

$ cat /etc/sqream/sqream1_config.json |grep cluster
$ ./upgrade_storage <cluster path>

For more information on upgrading your SQream version, see Upgrading SQream Version.

Upgrading Your Client Drivers 

For more information on the client drivers for version 2021.2, see Client Drivers for 2021.2.

Configuring Your Instance of SQream 

A new configuration method is used starting with Version 2021.2.

For more information about configuring your instance of SQream, see Client Drivers for 2021.2.