Release 476-e STS (8 Aug 2025)#

Starburst Enterprise platform (SEP) 476-e is the follow up SEP release to 475-e. It includes all improvements from the following Trino releases:

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

Breaking changes#

The query.max-written-data-size query management property has been renamed to query.max-write-physical-size. Update your configuration files to use the new property name or the cluster fails to start.
JDK 24 is required to run Trino. Update your runtime environment to use JDK 24 or later or Trino fails to start.
The --sun-misc-unsafe-memory-access=allow JVM option is required when running Trino with the BigQuery or Snowflake connectors. Add this option to your Trino JVM configuration to ensure proper connector operation.
The kafka-event-listener.client-config-overrides configuration property has been removed. To configure the Kafka client for the event listener, specify the configuration in a separate file and set the kafka-event-listener.config.resources property to the path of that file.
The Kudu catalog configuration property kudu.schema-emulation.enabled has been removed and replaced with the new property kudu.schema-emulation.type. If your configuration relied on the old property, you must update your catalog configuration to use kudu.schema-emulation.type. See Kudu configuration properties for more information about allowed values for kudu.schema-emulation.type.
The hive.file-status-cache-tables.excluded configuration property has been renamed to hive.file-status-cache.excluded-tables. Update your configuration files to use the new property name or the cluster fails to start.

Updated the default value of the max_import_duration property for materialized views from 30m to 120m.
Updated the default refresh interval for data product materialized views from 60m to 125m.
Improved execution speed for queries that include joins and aggregations.

Added support for allowing the role receiving a location privilege grant to grant the privilege to others in built-in access control.
Updated built-in access control to include ownership information when querying the schemas_authorization, tables_authorization, and functions_authorization metadata tables in the system.metadata schema.

Fixed an issue that prevented querying Delta Lake tables with timestamp_ntz columns in Unity Catalog.

Added support for view refresh using the ALTER VIEW ... REFRESH statement.
Fixed an issue that prevented the connector from accessing metadata tables when AWS Lake Formation access control was enabled enabled.
Fixed an issue where SELECT * queries failed when AWS Lake Formation access control was enabled, the user lacked SELECT permissions on all columns, and hide_inaccessible_columns=true.
Fixed incorrect DATE values when reading Parquet files written by Hive in legacy calendar mode for dates prior to 1970-01-01. SEP now detects and converts these legacy calendar dates to proleptic Gregorian calendar.

Added support for branching.
Added support for the optimize_position_deletes table procedure.
Added support for copy-on-write mode when using the merge_mode table property.
Added support for AWS Glue v2 to Iceberg. You can enable it using the iceberg.catalog.type=glue_v2 configuration property.
Added support for specifying the time zone to apply when reading from Iceberg tables with the iceberg.time-zone configuration property.
Improved query planning performance for materialized views by parallelizing base table freshness retrieval.
Fixed an issue where data maintenance jobs could target non-Iceberg catalogs.
Fixed an issue that prevented the connector from accessing metadata tables when AWS Lake Formation access control was enabled.
Fixed an issue where SELECT * queries failed when AWS Lake Formation access control was enabled, the user lacked SELECT permissions on all columns, and hide_inaccessible_columns=true.

Added support for schema emulation when Kudu is integrated with the Hive metastore. See Kudu configuration properties for information on configuring schema emulation.