Release 434-e STS (2 Feb 2024)#

Starburst Enterprise platform (SEP) 434-e is the follow up release to the 433-e version. It includes all improvements from the Trino 434 release.

This release is a short term support (STS) release.

Warning

This release contains a known issue that causes cluster startup to fail when Starburst Warp Speed is in use for Delta Lake or Iceberg catalogs while the cluster is secured with Apache Ranger. As a temporary fix to this problem, remove the hive.s3.iam-role catalog configuration property and replace it with the following catalog configuration properties, replacing xxx with the appropriate S3 IAM role contents:

fs.hadoop.enabled=false
fs.native-s3.enabled=true
s3.iam-role=arn:iam::xxx:role/xxx

This is a temporary workaround that is only necessary for 434-e. You must remove this workaround when upgrading from 434-e to future releases.

Breaking changes#

  • This release introduces some security fixes in Trino that restrict users’ ability to create new Iceberg materialized views with Glue while using the iceberg.security=system catalog configuration setting. Querying new Iceberg materialized views that fit this criteria fail and return a Materialized view does not have an owner error. See Using BIAC with Iceberg materialized views for steps to mitigate this issue.

  • The optimizer.mark-distinct-strategy configuration property has been removed. You must remove this property from the cluster configuration in favor of the optimizer.distinct-aggregations-strategy configuration property or the cluster fails to start.

  • The internal-communication.shared-secret, managed-statistics.http-client.key-store-path, and managed-statistics.http-client.key-store-password catalog configuration properties are no longer required to enable managed statistics for a catalog. You must remove these properties from your catalog configuration files or the cluster fails to start. The internal-communication.shared-secret property is still valid as a general configuration property and can remain in non-catalog configuration files.

General#

  • Added support for the queryText selector rule in resource groups to allow the use of a regular expression to match against the SQL query string.

  • Added vectorized predicate evaluation. To enable this feature, set the columnar-filter-evaluation.enabled property to true.

  • Improved the performance of Top-N pushdown queries.

  • Improved the performance of queries that use aggregation with a join.

  • Improved dynamic filters for queries that include a join.

  • Improved the performance of predicate pushdown queries that include a BETWEEN operator.

  • Improved the performance of queries that use multiple distinct aggregations.

  • Improved the performance of table scans with native decompression.

  • Improved the performance of queries that use aggregation on INT, SMALLINT, TINYINT, or DATE columns.

Security#

Delta Lake connector#

Elasticsearch connector#

Hive connector#

Kudu connector#

Snowflake connector#

Synapse connector#