Release 350-e LTS (3 Feb 2021)#
Starburst Enterprise platform (SEP) 350-e is the follow up release to the 348-e version. It includes all improvements from the following Presto project releases:
This release is a long term support (LTS) release.
The 350-e release includes all improvements from the following Presto project releases:
Highlights since 345-e#
Cost-based optimizations for
Improve performance of queries with uncorrelated
Significant improvements of the Redshift connector
Table and column statistics
Type mapping improvements
Support for Amazon’s Redshift JDBC driver 2.0
Expanded feature set of the SAP HANA connector
Time column predicate pushdown
Table and column statistics
Fixes for calculation views
Support for dynamic filtering in the generic JDBC connector
Delta Lake support for access control with Ranger policies
Add support for OAuth2 authentication for Web UI
Improved support for picosecond precision in time and timestamp data types
Breaking changes since 345-e#
Require a minimum Java version of 11.0.7 to mitigate Java issue JDK-8206955.
Redshift connector changed to use the Redshift JDBC driver, users need to update the
connection-urlin all catalog files
Use consistent NaN behavior for
max_by(). NaN is only returned when it is the only value, except for null which are ignored for aggregation functions.
Remove configuration properties
Removed legacy Kubernetes operator, replaced by the Helm-based Kubernetes support since 338-e
350-e initial changes#
The following changes from 350-e.0 and 350-e.1 are all part of the first public release.
Add Mission Control web application for cluster and data source management
Add Starburst Insights web application for cluster and query reporting
Add cache service for table scan redirections
Improve performance of queries using the
Improve performance of certain queries using
IS NOT DISTINCT FROMas a join condition, when dynamic filtering is enabled”
GRANT OPTIONuse with Sentry privileges
Support reading nanosecond precision timestamp values in Hive map, array, and struct (row)
Add encoder and decoder for protobuf messages
Add support for OAuth 2.0 authentication using client credentials
Support TLS/SSL secured access to the schema registry
Add support for table statistics
Add user impersonation support
Update to use Redshift JDBC driver
SAP HANA connector#
Extend support for views, including SAP HANA calculation views
Add new connector to connect to other remote SEP clusters - Starburst Stargate.
350-e.2 changes (18 Feb 2021)#
Fix possible S3 connection leak on query failure
Disable Hive metastore caching on workers
Support non-lowercase partition columns in the Delta Lake connector
Fix for Map fields cannot be repeated from Protobuf reader in the Kafka connector
350-e.3 changes (26 Feb 2021)#
Add Synapse connector to installation binaries
Fix serialization for timestamps with precision higher than three in the MySQL, SQL Server, and SingleStore (MemSQL) connector
Fix problems with reading data from Kafka schema registry table
350-e.5 changes (12 Mar 2021)#
Fix possible S3 connection leaks when using AVRO table format
Fix potential compiler failure when constructing an array with more than 128 elements
CREATE TABLE ASwith
NULLpartition keys in Delta Lake
Allow configuring process environment variables, including secrets, through
/etc/presto/env.shwith RPM-based installation
Fix removal of expired cached tables
Fix possible S3 connection leaks when using AVRO table format.
350-e.6 changes (19 Mar 2021)#
Hive connector: Respect partition filter for
DELETEof ACID tables. Previously, the partition filter was ignored, resulting in the deletion of too many rows.
-XX:PerBytecodeRecompilationCutoffas JVM safety configuration in RPM
Fix failure when subqueries contain
Fix incorrect results when multiple similar subqueries contain
UNIONclauses that differ only in the
350-e.7 changes (8 Apr 2021)#
Fix privilege checks in Ranger global access control for queries that do not read any columns, such as
SELECT count(*) FROM <table>.
Fix incorrect results when querying the
$file_modified_timehidden column in Hive connector.
Fix incorrect “SHOW SCHEMA” results in Hive access control with the Privacera platform.
350-e.8 changes (14 May 2021)#
Mask value of
teradata-parallel-direct.https.keystore.passwordin log file writing.
Fix inconsistent behavior for
to_unixtime()with values of type
Add support for epoch milliseconds exposed as String in the Elasticsearch connector.
Support Databricks replace table with schema change in Delta Lake connector.
Validate ORC ACID version base on data file metadata as a fallback.
350-e.9 was skipped.
350-e.10 changes (14 Jun 2021)#
Correct how delete markers are interpreted for ORC ACID tables in Hive connector, so SEP is not filtering out extraneous rows for certain tables.
Fix query failure when reading from a non-ORC insert-only transactional table in Hive connector.
Fix incorrect results when accessing BigQuery records with wrong index in BigQuery connector.
Fix query failures when accessing the
information_schematable in Delta Lake connector.
350-e.11 changes (23 Jun 2021)#
Delta Lake connector: Fix query failure after table location changed in the metastore.
350-e.12 changes (18 Aug 2021)#
LIKEclause usage with char values.
Reject CTAS with
skip_header_line_count > 0in Hive connector.
Fix data corruption when performing
INSERTon ORC ACID transactional table.
Fix column ordering bug in Delta Lake CTAS.
DROP SCHEMA RESTRICTnot to drop then schema if it is not empty in MySQL connector.
Fix incorrect pushdown of range predicates on char and varchar columns for JDBC connectors where the remote database is case-insensitive or follows a different sort ordering for letters from Trino (MySQL, SingleStore, SQL Server, PostgreSQL, Greenplum).
Properly handle number values with negative scale in Teradata.
350-e.13 was skipped.
350-e.14 changes (7 Sep 2021)#
Fix invalid result when two decimals are added together. This happened in certain queries where decimals had different precision.
Fix incorrect result when using the BigQuery
Fix incorrect results for queries with a comparison between a
VARCHARcolumn and a
Fix query failure when inserting data into a Hive ACID table that is not explicitly bucketed.