Release Notes 2020.3.1
The 2020.3.1 release notes were released on October 8, 2020 and describe the following:
The following list describes the new features:
- TEXT data type:
Full support for
MAXaggregate functions on
Support Text-type as window partition keys (e.g., select distinct name, max(id) over (partition by name) from
Support Text-type fields in windows order by keys.
Support join on
TEXTcolumns (such as
t1.x = t2.ywhere
yare columns of type
Complete the implementation of
TEXTcolumns (previously limited to prefix and suffix).
Support for cast fromm
New string function -
REPEATfor repeating a string value for a specified number of times.
DECIMAL ORCcolumns to SQream’s floating-point types.
LIKEon non-literal patterns (such as columns and complex expressions).
Catch OS signals and save the signal along with the stack trace in the SQream debug log.
Support equijoin conditions on columns with different types (such as
DUMP_DATABASE_DDLnow includes foreign tables in the output.
New utility function -
The following list describes the performance enhancements:
Introduced the “MetaData on Demand” feature which results in signicant proformance improvements.
Implemented regex functions (
TEXTcolumns on GPU.
The following list describes the resolved issues:
Multiple distinct aggregates no longer need to be used with developerMode flag.
In some scenarios, the
connection_id valuesare incorrectly recorded as
-1in the log.
NOT RLIKEis not supported for
TEXTin the compiler.
date/datetimereturns an error when the
No known issues and limitations.
Versions are available for IBM POWER9, RedHat (CentOS) 7, Ubuntu 18.04, and other OSs via Docker.
Contact your account manager to get the latest release of SQream.