Release 462-e LTS (27 November 2024)

Starburst Enterprise platform (SEP) 462-e LTS is the follow up release to the 458-e STS release and the 453-e LTS release.

This release is a promotion of the original 462-e STS release in November 2024 into a long term support (LTS) release.

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

• 454-e STS

• 458-e STS

It includes all improvements from the following Trino releases:

• Trino 454

• Trino 455

• Trino 456

• Trino 457

• Trino 458

• Trino 459

• Trino 460

• Trino 461

• Trino 462

Highlights since 453-e

• Added support for Workload management as a public preview.

• Added support for Azure Key Vault and Google Cloud Secret Manager as secrets configuration providers.

• Added support for the Iceberg connector when using AWS Lake Formation access control.

• Released Query result caching in general availability.

Breaking changes

• Legacy file system support for all catalogs has been disabled by default. You must activate the desired file system support with fs.native-azure.enabled,fs.native-gcs.enabled, fs.native-s3.enabled, or fs.hadoop.enabled in each catalog. Use the migration guides for Azure Storage, Google Cloud Storage, and S3 to assist if you have not switched from legacy support.

• Starburst Helm charts are no longer accessible through the ChartMuseum API. Instead, use the OCI API.

• Secrets configuration provider setup has been updated to use secrets.toml files. The configuration-provider.config-files property is no longer supported. You must update your configuration to use secrets.toml files.

• The query.low-memory-killer.delay configuration property has been removed. You must remove this property or the cluster fails to start.

• The following changes have been made to Ranger access control:

  The ranger-system-access-control value for access-control.name has been deprecated and renamed to legacy-ranger-system-access-control.

  The hive-based-ranger-system-access-control access control option has been renamed to hive-based-ranger.

  The ranger value for the hive.security and delta.security catalog configuration properties has been deprecated and renamed to hive.security=deprecated-ranger and delta.security=deprecated-ranger respectively.

  It is recommended that you migrate to the new configuration in anticipation of the removal of the deprecated properties.

• The CFT property S3PinToCurrentRegion is no longer supported.

• The following connectors have been removed:

  • Local file

  • Atop

  • Raptor

• The snowflake.database configuration property is now required if snowflake.database-prefix-for-schema.enabled is set to false, which is the default value. You must update existing Snowflake catalog configurations or the cluster fails to start.

462-e initial changes

General

• The Starburst Enterprise .rpm and .tar artifacts are now bundled with the Eclipse Temurin OpenJDK distribution from Adoptium, removing the requirement for a separate installation of Java for SEP.

• Released Query result caching in general availability.

• Added support for configuring a background job to delete expired result cache entries.

• Added support for user-assigned managed identities in Azure Kubernetes Service.

• Updated Schema discovery UI to show table format information prior to scanning.

• Fixed an issue that caused publishing data products to fail due to long SQL statements.

• Fixed an issue with changing resource group templates in Workload management.

Hive connector

• Added existing_directory parameter for the UNLOAD table function.

Iceberg connector

• Added support for roles and credential vending with AWS Lake Formation.

Oracle connector

• Added support for Oracle Wallet authentication.

Teradata connector

• Added support for CAST pushdowns of temporal types.

462-e.1 changes (27 November 2024)

• Added support for projection pushdown of upper, lower, trim, and substring functions in the Teradata connectors.

• Improved performance when using various string functions in queries involving joins.

• Updated Iceberg connector migration procedure to use nullable columns by default.

• Fixed issue that printed unprocessed user input in server error responses.

• Fixed missing security checks on SQL statements for schema discovery.

• Fixed insert of invalid time zone data for tables using the TIMESTAMP WITH TIME ZONE type

• Fixed incorrect results for queries filtering on partition columns when the NAME column mapping mode is used.

• Fixed Hive query failures using Hive impersonation with delegated authentication.

462-e.2 changes (13 Dec 2024)

• Updated query result caching to use session property managers to resolve session property defaults and ensure that they are consistently applied.

• Removed deprecated RubiX cache from SEP Helm chart.

• Fixed query failures on impersonated Hive during delegated authentication checks.

• Fixed incorrect column length of VARCHAR type in SingleStore version 8.

• Fixed incorrect results when reading array columns and bigquery.arrow-serialization.enabled is set to true.

• Fixed failure of S3 file listing of buckets that enforce requester pays.

• Fixed incorrect quoting of output values when the CSV_UNQUOTED or CSV_HEADER_UNQUOTED format is used.