Release 370-e LTS (17 Feb 2022)

Starburst Enterprise platform (SEP) 370-e is the follow up release to the 369-e STS release and the 364-e LTS release.

This release is a long term support (LTS) release.

The 370-e release includes all improvements from the following Trino project releases:

• Trino 370

• Trino 369

• Trino 368

• Trino 367

• Trino 366

• Trino 365

It contains all improvements from the Starburst Enterprise releases since 364-e LTS:

• 369-e STS

• 368-e STS

• 367-e STS

• 365-e STS

Highlights since 364-e

• Revamp of the Starburst Enterprise web UI, including Query editor and Insights.

• Add Data products.

Breaking changes since 364-e

• Remove distinction between system and user memory. This simplifies cluster configuration. The configuration property query.max-total-memory-per-node is removed, query.max-memory-per-node should be used instead.

• Remove unnecessary spilling configuration properties spill-order-by and spill-window-operator.

• Remove catalog configuration property allow-drop-table from the following connectors:

  • Starburst IBM DB2 connector

  • Starburst Generic JDBC connector

  • Starburst Greenplum connector

  • Starburst Netezza connector

  • Starburst SAP HANA connector

  • Starburst Snowflake connector

  • Starburst Stargate

  • Starburst Synapse connector

  • Starburst Teradata connectors

  • Starburst Vertica connector

  • Many Trino-based connectors and their Starburst extensions

370-e initial changes

General

• Use UBI8 minimal base image for the Cache Service Docker image.

Security

• Add built-in access control.

Redshift connector

• Add support for timestampz and timestamp with time zone Redshift data types.

370-e.1 changes (23 Feb 2022)

• Fix data corruption when multiple queries DELETE from, INSERT into, or UPDATE a Delta Lake table.

• Fix incorrect date result the value is <= 1582-10-14 in MySQL, SingleStore, and PostgreSQL connectors.

• Migrate Docker image for Starburst Cache Service to UBI8 minimal base image.

• Fix IndexOutOfBoundsException with accelerated parquet reader.

• Improve query performance by removing redundant predicates above table scan.

• Added separate properties for built-in access control to set authorized users and groups.

• Fix potential query failures for queries writing data to tables backed by S3 in Hive and Iceberg connectors.

• Fix problem when memory wasn’t always released after query completion.

• Fix performance regression in internal communication authentication processing.

• Fix failure when casting to decimal(38, 38)

370-e.2 changes (18 Mar 2022)

• Fix query failures due to exhausted file system resources after DELETE or UPDATE.

• Fix issue where the length of log file names grow indefinitely upon log rotation.

• Add INT to BIGINT coercion in accelerated Parquet reader in Hive, Delta Lake, and Iceberg connectors.

• Fix failure reading timestamp data with accelerated Parquet reader.

• Accept only lowercase letters for role names in built-in access control to ensure SQL compatibility.

• Fix metastore impersonation for Avro tables.

• Fix a bug that occurred when Parquet file schema and Trino table definition did not match.

370-e.3 changes (25 Apr 2022)

• Fix CVE-2022-23848 in Alluxio client.

• Fix RPM to include MapR Hive libraries.

• Fix failure of the sync_partition_metadata procedure when partition names differ from partition paths on the file system.

• Fix query failure when selecting partition when the name corresponds with a reserved keyword.

• Fix performance regression for GROUP BY queries.

• Fix built-in access control (BIAC) UI to support large amounts of schemas, tables, and columns during privilege creation.

• Fix certain queries failing due to dictionary compacting error.

• Fix performance regression when planning large IN lists.

• Fix bug in accelerated parquet reader.

• Fix failure reading timestamp data with accelerated parquet reader.

• Fix Delta Lake queries with predicates that are not expressible by tuple domain for nullable partition columns.