Release 438-e STS (25 Mar 2024)#

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

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

Breaking changes#

  • As of SEP 438-e, Starburst Warp Speed uses a new file system caching mechanism. To use Starburst Warp Speed, you must add the --enable-preview flag to your jvm.config configuration. Additionally, the following catalog configuration properties have been removed:

    • warp-speed.workerdb.db.path

    • warp-speed.file-system-reserve-percentage

    • warp-speed.call-home.enable

    You must remove these configuration properties from your cluster configuration or the cluster fails to start.

  • The Starburst Elasticsearch connector no longer supports Elasticsearch version 6.x or OpenSearch 1.x. Update Elasticsearch to version 7.x or 8.x to continue using the connector. To connect to OpenSearch, use the OpenSearch connector.

  • SEP now requires JDK 21 to run. See the Java runtime environment requirements for more information.

General#

  • Added support for larger dynamic filters.

  • Added resource group ID to query information in the Starburst Enterprise web UI.

  • Removed the Snowflake distributed connector in favor of the improved Snowflake parallel connector.

  • Deprecated the starburst.dataframe-api-enabled configuration property and replaced with the dataframe-api-enabled configuration property.

  • Fixed incorrect behavior of SQL routines with a single IF/ELSE condition.

  • Fixed a bug in a database migration script for Oracle that caused the coordinator to fail on start-up, in certain cases, when using Oracle as the database in SEP’s backend service.

  • Fixed issue that caused problems with pushdown on one catalog to prevent tables or materialized views from being listed for other catalogs.

  • Fixed a bug in the Atlas CLI that caused registering a catalog to fail if any schema or table names in the catalog contained special characters.

Security#

DB2#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Delta Lake connector#

  • Added support for Apache Ozone as an object storage extension.

Greenplum connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Hive connector#

  • Added support for Apache Ozone as an object storage extension.

  • Added support for changing a column’s type from VARCHAR to FLOAT, DOUBLE, or CHAR.

  • Fixed a bug where column statistics created in SEP would not be visible in Hive when using CDP 7.

Iceberg connector#

  • Added support for Apache Ozone as an object storage extension.

  • Fixed error that caused query failure when writing ORC files.

Netezza#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Redshift connector#

  • Added support for predicate pushdown of expressions IS/NOT NULL, NOT, OR, LIKE, and LIKE used with the ESCAPE clause.

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

SAP HANA connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Snowflake connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

SQL Server connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Stargate connector#

  • Added support for join pushdown across catalogs when using password authentication, with the exception of Kerberos.

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Synapse connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Teradata connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.

Vertica connector#

  • Added support for join pushdown with selected expressions, such as VARCHAR equality.