Release 354-e STS (25 Mar 2021)#

Starburst Enterprise platform (SEP) 354-e is the follow up release to the 350-e version. It includes all improvements from the following Trino project releases:

This release is a short term support (STS) release.

Breaking changes#

This SEP release is the first release using the renamed upstream project — Trino (formerly PrestoSQL). As a result, a number of binaries, paths, properties, and other aspects now use the new name. Many of these updates cause breaking changes.

Note

Review the migration guide for important instructions and further details about the changes in this SEP release.

Other breaking changes:

  • Removed legacy Kubernetes operator, replaced by the Kubernetes Helm-based support since 338-e

  • Removed support for presto-admin, replaced by Starburst Admin

  • Rename of Kafka connector configuration properties

  • Branding updates for AWS and CFT tooling include property and filename changes that break compatibility

  • Branding updates for Kubernetes tooling include many changes that break compatibility

  • Rename of the Starburst Ranger plugin, used for global access control, requires special upgrade procedure steps

General#

  • Allow configuring process environment variables, including secrets, through /etc/starburst/env.sh with RPM-based installation

  • Improvements to split generation and scheduling through node-scheduler.include-coordinator

  • Add usage metrics support to Insights

Performance#

  • Cache service

    • Allow embedded mode for running cache service on coordinator

    • Support bucketing and sorting in cached tables

    • Support incremental caching for new table rows

    • CLI support for incremental updates and expiration of incrementally imported cached tables

Security#

  • Support UPDATE statements with the Ranger and Privacera plugins used for both global and Hive connector access control

DB2 connector#

  • Reduce the number of opened JDBC connections during planning

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

  • Add support for password credential pass-through

Delta Lake connector#

  • Fix CREATE TABLE AS with NULL partition keys

  • Add support for multi-part checkpoints

Generic JDBC connector#

  • Reduce the number of opened JDBC connections during planning

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Greenplum connector#

  • Expand aggregate function pushdown

  • Reduce the number of opened JDBC connections during planning

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Hive connector#

Kafka connector#

  • Support TLS/SSL authentication for schema registry access

  • Support basic authentication for schema registry access

  • Improve TLS/SSL configuration

  • Add password authentication support

  • Clean up authentication configuration properties to be consistent with other connectors; verify your configuration against the documentation to adapt to the breaking changes

Oracle connector#

  • Expand aggregate function pushdown

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Redshift connector#

  • Expand aggregate function pushdown

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

  • Add support for password credential pass-through

SAP HANA connector#

  • Reduce the number of opened JDBC connections during planning

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

SingleStore (MemSQL) connector#

  • Expand aggregate function pushdown

  • Reduce the number of opened JDBC connections during planning

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Snowflake connector#

  • Expand aggregate function pushdown

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

SQL Server connector#

  • Add override-catalog session property to access multiple SQL Server databases using a single catalog.

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Starburst Remote connector#

  • Add Kerberos authentication support

  • Add user impersonation support

  • Improve TLS/SSL configuration

  • Reduce the number of opened JDBC connections during planning

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Synapse connector#

  • Expand aggregate function pushdown

  • Add support for DATETIME2 data type

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching

Teradata connector#

  • Fix support for zero values in NUMBER types for the Teradata direct connector

  • Add LOCKING ROW FOR ACCESS modifier for SELECT queries by default

  • Reduce the number of opened JDBC connections during planning

  • Throw access denied error when user has no access to a table for SHOW CREATE TABLE and SHOW COLUMNS queries.

  • Provide statistics for simple Teradata views, that are supported by Teradata HELP STATISTICS, see: https://docs.teradata.com/r/scPHvjfglIlB8F70YliLAw/9y~Y3X6ukH0HEEIkjgqi3Q).

  • Cancel Teradata JDBC query when SEP query is cancelled or aborted

  • Invalidate cached table statistics when table data is changed through SEP

  • Removed statistics.cache-ttl and statistics.cache-missing configuration properties for table statistics caching