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 yourjvm.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 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.
If you are using Oracle as the externally-managed database for the Backend service and upgrading to this version from SEP version 435-e or earlier, you must take additional steps prior to upgrading SEP. Contact Starburst Support for assistance.
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 thedataframe-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#
Added support for delegated Kerberos authentication in the Starburst Enterprise web UI.
Added location privilege support for built-in access control.
Added AWS Lake Formation configuration properties to allow setting an endpoint and AWS region.
Added support for fine-grained access permissions for write operations with Starburst Immuta.
Added support for Immuta’s Universal Audit Model (UAM).
Updated the built-in access control REST API to allow granting roles
CREATE
permissions on views and materialized views in a schema where the role does not have theCREATE
privilege for tables.Fixed a bug in built-in access control that caused
SET ROLE NONE
to behave likeSET ROLE ALL
when using the CLI client.Fixed a bug that caused some built-in access control grants to make all tables or all schemas in a catalog visible in the
information
schema.Fixed access issue with security
DEFINER
views when both materialized views and HMS impersonation are enabled.
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 the UNLOAD pre-built table function.
Added support for Apache Ozone as an object storage extension.
Added support for changing a column’s type from
VARCHAR
toFLOAT
,DOUBLE
, orCHAR
.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
, andLIKE
used with theESCAPE
character.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.