Release 429-e LTS (29 Nov 2023)#
Starburst Enterprise platform (SEP) 429-e LTS is the follow up release to the 429-e STS release and the 423-e LTS release.
This release is a promotion of the original 429-e STS release in November 2023 into a long term support (LTS) release.
The 429-e release includes all improvements from the following Trino releases:
It contains all improvements from the Starburst Enterprise releases since 423-e LTS:
Highlights since 423-e#
Added support for PyStarburst.
Added read-only public preview support for Unity Catalog as a metastore.
Added support for credential vending for reading AWS Lake Formation tables.
Added support for CREATE OR REPLACE TABLE statements in Delta Lake.
Added predicate pushdown support to the MongoDB connector.
The SEP backend service has been updated to require PostgreSQL 12.0+ when using PostgreSQL as the underlying RDBMS.
TIMESTAMPtype mapping between MySQL and Trino is no longer
TIMESTAMP. The new conversion is MySQL
TIMESTAMP WITH TIMEZONE. Depending on the query, mapping from MySQL
TIMESTAMPmay result in an error message.
Privileged access to the attached storage on nodes is no longer required for Starburst Warp Speed cluster configuration in Helm deployments. Existing cluster configurations must be updated, with EKS deployments requiring the addition of a boostrap script. Review and follow the considerations for your platform in the Starburst Warp Speed documentation.
deprecated.hive.metastore.glue-read-properties-based-column-statisticsHive Metastore configuration property and underlying functionality has been removed. You must remove this configuration property or the cluster fails to start.
The updated base Docker image for SEP no longer includes
grep, and other popular command line tools. Starburst recommends using an init container with a base image that includes your needed command line tools. Guidance on using init containers and selecting suitable base images can be found in our init container documentation.
autoConfigureproperty was added to the Starburst Warp Speed Helm chart which defaults to
false. Starburst Warp Speed deployments on AKS and GKE upgrading from 426-e that have already been reconfigured to use the filesystem instead of privileged mode must set this property to
trueor the filesystem is not created. Review and follow the migration guide for detailed instructions for your cloud platform.
SEP 427-e uses a base system image that does not contain a system-wide trust store. Trusted, self-signed certificates must now be added to the Java distribution CA certificates located under
parse-decimal-literals-as-doubleconfiguration property has been removed. Clusters that use this property must have it removed from configuration or the cluster does not start.
The following deprecated task writer configuration properties have been removed:
task.writer-count, replaced by
task.partitioned-writer-count, replaced by
task.scale-writers.max-writer-count, replaced by
writer-min-size, replaced by
You must remove these properties from the cluster configuration and replace them with these replacement properties, or the cluster does not start.
The Snowflake distributed connector is now deprecated and is planned to be removed in a future SEP release, in favor of the improved Snowflake parallel connector. Existing catalogs that use the Snowflake distributed connector must be migrated to the Snowflake parallel connector.
The RPM package
servicedaemon script is now deprecated and is planned to be removed in a future SEP release. Configurations that rely on this script must be updated to use the
systemctldaemon script instead.
As of the 429-e release, table functions such as
queryare qualified with the
system.builtinschema. This change results in
Access Deniederrors in circumstances where a role was granted a privilege to execute table functions not qualified under a schema. Permissions for these roles must now be updated accordingly to execute table functions when qualified with an appropriate schema.
429-e initial changes#
Added support for publishing data products that contain decimal literals.
Updated usage metrics to upload data collected between previous upload and the coordinator shutdown or restart.
Fixed issue that prevented the Run and troubleshoot option in the query editor from working when built-in access control is enabled.
Added support for flushing the filesystem cache for tables with the
Delta Lake connector#
Added support for CREATE OR REPLACE TABLE statements.
Added predicate pushdown support.
Updated connectors to use fully parallel mode by default for more query shapes.
SQL Server connector#
sqlserver.database-prefix-for-schema.enabledcatalog configuration property that allows SQL Server catalogs to access multiple databases.
429-e.0 changes (29 Nov 2023)#
Improved support for concurrent updates of table statistics in Glue.
Added masking for additional sensitive values in log files.
Added casting of
charfields, if necessary, to
varchartype in Hive view translations.
Added support for
RENAME TABLEwhen the
snowflake.database-prefix-for-schema.enabledproperty is set to
Fixed incorrect results for queries involving an aggregation in a correlated subquery.
Fixed incorrect results for queries involving
ORDER BYand window functions with ordered frames.
Fixed launcher start command not working with default directories.
Fixed possible JVM crash when reading short decimal columns in parquet files created by Impala. Applies to the Hive, Hudi, Delta, and Iceberg connectors.
Fixed incorrect results when a query contains several
NOT INpredicates in MongoDB catalogs.