Release 345-e LTS (11 Nov 2020)#

Starburst Enterprise Presto 345-e is the followup release to the 344-e STS release and the 338-e LTS release:

The 345-e release includes all improvements from the following Presto project releases:

This release is a long term support (LTS) release and contains all improvements from the Starburst Enterprise releases since 338-e LTS:

Highlights from included STS releases since 338-e#

New and exclusive Starburst Greenplum connector
New and exclusive Starburst SAP HANA connector
Added the Starburst MemSQL connector with table statistics, aggregate pushdown and more features as an extension of the MemSQL connector
Added Kubernetes support with Helm charts as the preferred deployment
Improved policy management and added support for CREATE ROLE, DROP ROLE, SHOW GRANT and related statement for Ranger policy management with SQL
Added Dynamic filtering support for Oracle
Improved support for query pushdown in Oracle connector
Added behavior to avoid silently ignoring extra buckets in Hive connector
Expanded support for lazy dynamic filters
Reduced the size of the RPM archive from 2GB to approx. 800MB
Added support for access denial for system information with catalogs using the Hive connector
Improved timestamp handling in the Starburst IBM Db2 and Starburst Teradata connectors
Add dynamic filter file pruning and CTAS statement support for the Starburst Delta Lake connector
Numerous improvements for File-based system access control

SEP licensing changed to a finer-grained configuration for connectors. If you do not have a license, you lose access to some features with this upgrade:
- IBM Cloud Object Storage support for the Hive connector
- Generic JDBC connector
- Security features of the Starburst Kafka connector
Renamed Starburst Teradata direct connector and used property names
Removed the deprecated Java table operator from the Teradata Direct connector

Add write support for ORC ACID and INSERT ONLY Hive transactional tables
Support for Hive access control with Privacera Platform
Allow custom log path for the native table operator of the Teradata Direct connector
Add support for global access control with Privacera Platform
Fix incorrect correlation mapping

Allow using legacy Hive view translation logic for views containing CTEs by setting either hive.legacy-hive-view-translation configuration property or legacy-hive-view-translation to true
Add validation for bucketed query results in Hive connector
Add cache invalidation on CREATE TABLE events in Hive Metastore
Fix incorrect query results resulting from external data updates in Delta Lake connector
Fix SSL/SASL authentication support in Kafka connector

Remove the deprecated Kubernetes operator, users can use the supported Kubernetes support with Helm charts
Remove support for Mission Control for 345-e, users can update to 350-e LTS
Fix possible S3 connection leak on query failure

Hive connector: Respect partition filter for DELETE of ACID tables. Previously, the partition filter was ignored, resulting in the deletion of too many rows.
Add -XX:PerMethodRecompilationCutoff and -XX:PerBytecodeRecompilationCutoff as JVM safety configuration in RPM
Fix failure when subqueries contain EXCEPT or INTERSECT
Fix incorrect results when multiple similar subqueries contain UNION clauses that differ only in the ALL vs DISTINCT qualifier

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_time hidden column in Hive connector.
Fix incorrect “SHOW SCHEMA” results in Hive access control with the Privacera platform.

Mask value of teradata-parallel-direct.https.keystore.password in log file writing.
Fix inconsistent behavior for to_unixtime() with values of type timestamp(p).
Change return type of from_unixtime() and from_unixtime_nanos() to timestamp(p) with time zone.

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 incorrect results when accessing BigQuery records with wrong index in BigQuery connector.

Fix LIKE clause usage with char values.
Reject CTAS with skip_header_line_count > 0 in Hive connector.
Fix data corruption when performing UPDATE or INSERT on ORC ACID transactional table.
Fix column ordering bug in Delta Lake CTAS.
Fix DROP SCHEMA and DROP SCHEMA RESTRICT not 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.

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 TIME type.
Fix incorrect results for queries with a comparison between a VARCHAR column and a CHAR constant.
Fix query failure when inserting data into a Hive ACID table that is not explicitly bucketed.