Release 334 (29 May 2020)#
General#
- Fix incorrect query results for certain queries involving comparisons of - realand- doubletypes when values include negative zero. (#3745)
- Fix failure when querying an empty table with late materialization enabled. (#3577) 
- Fix failure when the inputs to - UNNESTare repeated. (#3587)
- Fix failure when an aggregation is used in the arguments to - format(). (#3829)
- Fix - localtime()and- current_time()for session zones with DST or with historical offset changes in legacy (default) timestamp semantics. (#3846, #3850)
- Fix dynamic filter failures in complex spatial join queries. (#3694) 
- Improve performance of queries involving - row_number(). (#3614)
- Improve performance of queries containing - LIKEpredicate. (#3618)
- Improve query performance when dynamic filtering is enabled. (#3632) 
- Improve performance for queries that read fields from nested structures. (#2672) 
- Add variant of - random()function that produces a number in the provided range. (#1848)
- Add Oracle connector. (#1959) 
- Add Pinot connector. (#2028) 
- Add Prometheus connector. (#2321) 
- Add support for standards compliant (RFC 7239) HTTP forwarded headers. Processing of HTTP forwarded headers is now controlled by the - http-server.process-forwardedconfiguration property, and the old- http-server.authentication.allow-forwarded-httpsand- dispatcher.forwarded-headerconfiguration properties are no longer supported. (#3714)
- Add pluggable Certificate authenticator. (#3804) 
JDBC driver#
- Implement - toString()for- java.sql.Arrayresults. (#3803)
CLI#
- Improve rendering of elapsed time for short queries. (#3311) 
Web UI#
JDBC driver#
- Improve performance of - DatabaseMetaData.getColumns()when the parameters contain unescaped- %or- _. (#1620)
Elasticsearch connector#
Hive connector#
- Fix matching bucket filenames without leading zeros. (#3702) 
- Fix creation of external tables using - CREATE TABLE AS. Previously, the tables were created as managed and with the default location. (#3755)
- Fix incorrect table statistics for newly created external tables. (#3819) 
- Prevent Presto from starting when cache fails to initialize. (#3749) 
- Fix race condition that could cause caching to be permanently disabled. (#3729, #3810) 
- Fix malformed reads when asynchronous read mode for caching is enabled. (#3772) 
- Fix eviction of cached data while still under size eviction threshold. (#3772) 
- Improve performance when creating unpartitioned external tables over large data sets. (#3624) 
- Leverage Parquet file statistics when reading decimal columns. (#3581) 
- Change type of - $file_modified_timehidden column from- bigintto- timestamp with timezone type. (#3611)
- Add caching support for HDFS and Azure file systems. (#3772) 
- Fix S3 connection pool depletion when asynchronous read mode for caching is enabled. (#3772) 
- Disable caching on coordinator by default. (#3820) 
- Use asynchronous read mode for caching by default. (#3799) 
- Cache delegation token for Hive thrift metastore. This can be configured with the - hive.metastore.thrift.delegation-token.cache-ttland- hive.metastore.thrift.delegation-token.cache-maximum-sizeconfiguration properties. (#3771)
MemSQL connector#
- Include SingleStore connector in the server tarball and RPM. (#3743) 
MongoDB connector#
- Support case insensitive database and collection names. This can be enabled with the - mongodb.case-insensitive-name-matchingconfiguration property. (#3453)
SPI#
- Allow a - SystemAccessControlto provide an- EventListener. (#3629).