Release 364-e LTS (16 Nov 2021)#

Starburst Enterprise platform (SEP) 364-e is the follow up release to the 363-e STS release and the 360-e LTS release.

This release is a long term support (LTS) release.

The 364-e release includes all improvements from the following Trino project releases:

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

Highlights since 360-e#

Breaking changes since 360-e#

None.

364-e initial changes#

The following changes from 364-e.0, 364-e.1, and 364-e.2 are all part of the first public release.

General#

Starburst Insights#

Security#

  • Update to Privacera Platform version 4.7.0.3

Oracle connector#

  • Improved the JDBC driver’s support for credential pass-through with the extraCredentials parameter

Delta Lake connector#

  • Add the ability to redirect queries against information_schema.columns from Hive to Delta Lake.

  • Add native support for VACUUM system call.

  • Improve JOIN selectivity.

  • Improve performance of accelerated Parquet reader.

  • Stop DROP SCHEMA from deleting schema data in Delta Lake.

  • Fix bug in UPDATE to allow subqueries in SET assignments.

Hive connector#

364-e.3 changes (26 Nov 2021)#

  • Fix SEP Privacera integration

  • Fix handling of GRANT OPTION in Sentry

  • Add switch for Ranger check when setting session properties

  • Fix incorrect DST result from Redshift TIMESTAMP type

  • Fix queries containing DOUBLE data type

  • Fix query failure when listing tables in BigQuery

  • Fix reading of null values for dictionary encoded parquet data

  • Fix query failure in accelerated Parquet reading of short decimals stored in byte arrays of length 16

364-e.4 changes (17 Dec 2021)#

  • Fix deletion without predicate from a transactional table that has original uncompacted files.

  • Fix failure when a schema is dropped during listing tables from BigQuery.

  • Fix connection leak for INSERT, UPDATE, and DELETE operations in the Delta Lake connector.

  • Fix predicate pushdown with expressions using REAL types for MySQL, SingleStore and ClickHouse connectors.

  • Fix treatment of date values before 1582-10-14 in the Greenplum connector.

  • Remove unused log4j dependency from SEP to avoid false alarms about Log4Shell.

  • Upgrade log4j in Ranger Admin to version 2.16.0 to mitigate Log4Shell.

  • Fix handling of GRANT OPTION in Sentry.

  • Fix internal error for queries that contain join with UNION ALL on the right side.

  • Disable support for ALTER VIEW ... SET AUTHORIZATION statement.

  • Improve completeness of displayed information in query history in Insights.

364-e.5 changes (23 Feb 2022)#

  • Fix data corruption when multiple queries DELETE from, INSERT into, or UPDATE a Delta Lake table.

  • Fix incorrect date result the value is <= 1582-10-14 in MySQL, SingleStore, and PostgreSQL connectors.

  • Migrate Docker image for Starburst Cache Service to UBI8 minimal base image.

  • Fix IndexOutOfBoundsException with accelerated parquet reader.

  • Fix duplicated binding error when using JWT and OAuth2 authentication methods simultaneously.

  • Fix an issue with query history not loading details for certain queries.

  • Fix query producing incorrect values (NULL) when data is present in Teradata connector.

364-e.6 changes (18 Mar 2022)#

  • Fix query failures due to exhausted file system resources after DELETE or UPDATE.

  • Fix a bug that occurred when parquet file schema and Trino table definition did not match.

364-e.7 changes (25 Apr 2022)#

  • Fix CVE-2022-23848 in Alluxio client.

  • Fix RPM to include MapR Hive. libraries.

  • Fix failure of the sync_partition_metadata procedure when partition names differ from partition paths on the file system.

  • Fix query failure when selecting partition when the name corresponds with a reserved keyword.

  • Fix SHOW TABLES failure when hive.hide-delta-lake-tables is enabled, and the Glue metastore contains metadata about the table without properties.

364-e.8 changes (20 May 2022)#

  • Ignore non-redirected, non-Delta Lake tables or views when querying information_schema.columns.

  • Add support to the Hive connector for date type partition names with timestamp formatting.

364-e.9 changes (9 Jun 2022)#

  • Fix typo in the configuration property name to remove an unsupported underscore and replace it with the appropriate dash DELEGATED-OAUTH2.

  • Fix sync_partition_metadata procedure failure when table has a large number of partitions.

  • Fix incorrect results for queries where aggregation is pushed down for a remote database to execute and the aggregation function result is not needed to evaluate the query. Applies to the ClickHouse, MariaDB, MySQL, Oracle, SQL Server, PostgreSQL, and SingleStore connectors.

364-e.10 changes (1 Jul 2022)#

  • Avoid errors when attempting to query tables that exist in multiple Snowflake databases with role impersonation enabled. The errors were a result of multiple tables matching the same schema/table name.

364-e.11 changes (1 Aug 2022)#

Important: In this release, we’ve patched a bug that causes the potential for incorrect results from certain queries that have had joins reordered in specific ways, in combination with certain data. A small percentage of queries are affected, but due to the complexity of the conditions that trigger the bug, it is not possible to predict which queries will be affected and thus we recommend that _all_ customers upgrade all clusters.

  • Fix incorrect results for certain join queries containing filters involving explicit or implicit casts.

  • Add Varbinary handling to Kafka Protobuf deserializer.

  • Fix incorrect query results when reading a Delta Lake table with a cached representation of its active data files that are outdated.

  • Fix certain complex queries that involve joins and aggregations.

  • Fix incorrect results when using the Glue metastore and queries contain IS NULL with additional filters. Applicable to Hive, Iceberg, and Delta connectors.

  • Fix incorrect pushdown of expression below join.

364-e.12 was skipped.

364-e.13 changes (9 Sep 2022)#

  • Fix writing incorrect results in the Delta Lake connector when the order of partition columns is different from the order in the table definition

  • Fix incorrect table already exists error in the Delta Lake connector caused by a client timeout when creating a new table.

364-e.14 changes (26 Sep 2022)#

  • Fix bug that prevented cluster metrics for Insights from being persisted.

  • Fix query failure when renaming or dropping columns that should be quoted. Applies to the ClickHouse, MariaDB, MySQL, Oracle, Phoenix, PostgreSQL, Redshift, SingleStore, and SQL Server connectors.

  • Fix query failure when adding a column that shoud be quoted. Applies to the Phoenix connector.

  • Fix query failure when adding a column with a column comment that has special characters which require it to be escaped. Applies to the ClickHouse connector.

  • Fix query failure when creating a table with a table or column comment that has special characters which require it to be escaped. Applies to the ClickHouse, MariaDB, and MySQL connectors.

  • Fix query failure when setting a table comment that has special characters which require it to be escaped. Applies to the ClickHouse, MariaDB, and MySQL connectors.

  • Fix query failure when setting a column comment that has special characters which require it to be escaped. Applies to the ClickHouse, Oracle, PostgreSQL, and Redshift connectors.

364-e.15 changes (06 Oct 2022)#

  • Fix potential SQL injection when querying BigQuery tables.

  • Fix inability to set the AWS STS endpoint and region when using a Glue metastore. Applies to the Delta, Hive, and Iceberg connectors.

364-e.16 was skipped.

364-e.17 changes (27 Oct 2022)#

  • Prevent coordinator out-of-memory failure when querying a large number of tables in a short period of time. Applies to the Delta Lake connector.

  • Fix error when using PREPARE with DROP VIEW where the view name is quoted.

  • Fix network issues during the data transfer for tables with a large number of columns. Applies to the Teradata Direct connector.

364-e.18 changes (17 Nov 2022)#

  • Fix failure for certain queries involving join operations over partitioned tables.

  • Fix potential query failure or incorrect results when reading from a table with the avro.schema.literal Hive table property set. Applies to the Hive connector.

  • Fix possible query failures for certain queries with join pushdown enabled on the Teradata Direct connector.