Release Notes 2021.1.1

The 2021.1.1 release notes were released on 7/27/2021 and describe the following:

New Features

The 2021.1.1 Release Notes include the following new features:

Complete Ranking Function Support

SQream now supports the following new ranking functions:

Function

Return Type

Description

first_value

Same type as value

Returns the value in the first row of a window.

last_value

Same type as value

Returns the value in the last row of a window.

nth_value

Same type as value

Returns the value in a specified (n) row of a window. if the specified row does not exist, this function returns NULL.

dense_rank

bigint

Returns the rank of the current row with no gaps.

percent_rank

double

Returns the relative rank of the current row.

cume_dist

double

Returns the cumulative distribution of rows.

ntile(buckets)

integer

Returns an integer ranging between 1 and the argument value, dividing the partitions as equally as possible.

For more information, navigate to Windows Functions and scroll to the Ranking Functions table.

Resolved Issues

The following list describes the resolved issues:

  • SQream did not support exporting and reading Int64 columns as bigint in Parquet. This was fixed.

  • The Decimal column was not supported when inserting data from Parquet files. This was fixed.

  • Values in Parquet Numeric columns were not being converted correctly. This was fixed.

  • Converting string data type to datetime was not working correctly. This was fixed.

  • Casting datetime to text truncated the time. This was fixed.