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
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)#
Include bucket id for correct delete operations on ORC ACID tables in Hive connector.
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.