Release 333 (04 May 2020)#
General#
- Fix planning failure when lambda expressions are repeated in a query. (#3218) 
- Fix failure when input to - TRYis a constant- NULL. (#3408)
- Fix failure for SHOW CREATE TABLE for tables with row types that contain special characters. (#3380) 
- Fix failure when using - max_by()or- min_by()where the second argument is of type- varchar. (#3424)
- Fix rare failure due to an invalid size estimation for T-Digests. (#3625) 
- Do not require coordinator to have spill paths setup when spill is enabled. (#3407) 
- Improve performance when dynamic filtering is enabled. (#3413) 
- Improve performance of queries involving constant scalar subqueries (#3432) 
- Allow overriding the count of available workers used for query cost estimation via the - cost_estimation_worker_countsession property. (#2705)
- Add data integrity verification for Presto internal communication. This can be configured with the - exchange.data-integrity-verificationconfiguration property. (#3438)
- Add support for - LIKEpredicate to SHOW COLUMNS. (#2997)
- Add SHOW CREATE SCHEMA. (#3099) 
- Add - starts_with()function. (#3392)
Server#
- Require running on Java 11 or above. (#2799) 
Server RPM#
- Reduce size of RPM and disk usage after installation. (#3595) 
Security#
- Allow configuring trust certificate for LDAP password authenticator. (#3523) 
JDBC driver#
- Fix hangs on JDK 8u252 when using secure connections. (#3444) 
BigQuery connector#
Cassandra connector#
- Allow INSERT statement for table having hidden - idcolumn. (#3499)
- Add support for CREATE TABLE statement. (#3478) 
Elasticsearch connector#
- Fix failure when querying Elasticsearch 7.x clusters. (#3447) 
Hive connector#
- Fix incorrect query results when reading Parquet data with a - varcharcolumn predicate which is a comparison with a value containing non-ASCII characters. (#3517)
- Ensure cleanup of resources (file descriptors, sockets, temporary files, etc.) when an error occurs while writing an ORC file. (#3390) 
- Generate multiple splits for files in bucketed tables. (#3455) 
- Make file system caching honor Hadoop properties from - hive.config.resources. (#3557)
- Disallow enabling file system caching together with S3 security mapping or GCS access tokens. (#3571) 
- Disable file system caching parallel warmup by default. It is currently broken and should not be enabled. (#3591) 
- Include metrics from S3 Select in the S3 JMX metrics. (#3429) 
- Report timings for request retries in S3 JMX metrics. Previously, only the first request was reported. (#3429) 
- Add S3 JMX metric for client retry pause time (how long the thread was asleep between request retries in the client itself). (#3429) 
- Add support for SHOW CREATE SCHEMA. (#3099) 
- Add - hive.projection-pushdown-enabledconfiguration property and- projection_pushdown_enabledsession property. (#3490)
- Add support for connecting to the Thrift metastore using TLS. (#3440) 
MongoDB connector#
Other connectors#
These changes apply to the MemSQL, MySQL, PostgreSQL, Redshift, and SQL Server connectors.
- Export JMX statistics for various connector operations. (#3479).