Release Notes 2021.2.1

The 2021.2.1 release notes were released on 15/12/2021 and describes the following:

New Features

The 2021.2.1 Release Notes include the following new features:

CREATE TABLE

SQream now supports duplicating the column structure of an existing table using the LIKE clause.

For more information, see Duplicating the Column Structure of an Existing Table.

PERCENTILE FUNCTIONS

SQream now supports the following aggregation functions:

• PERCENTILE_CONT

• PERCENTILE_DISC

• MODE

REGEX REPLACE

SQream now supports the REGEXP_REPLACE function for finding and replacing text column substrings.

For more information, see REGEX_REPLACE.

Delete Optimization

The DELETE statement can now delete values that contain multi-table conditions.

For more information, see Deleting Values that Contain Multi-Table Conditions.

For more information, see REGEX_REPLACE.

Performance Enhancements

The Performance Enhancements section is not relevant to Version 2021.2.1.

Resolved Issues

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

SQ No.	Description
SQ-8267	A method has been provided for including the GROUP BY and DISTINCT COUNT statements.

Known Issues

The Known Issues section is not relevant to 2021.2.1.

Naming Convention Modifications

The Naming Convention Modifications section is not relevant to Version 2021.2.1.

End of Support

The End of Support section is not relevant to Version 2021.2.1.

Deprecated Features

The Deprecated Components section is not relevant to Version 2021.2.1.