Release 334 (29 May 2020)#

General#

  • Fix incorrect query results for certain queries involving comparisons of real and double types when values include negative zero. (#3745)

  • Fix failure when querying an empty table with late materialization enabled. (#3577)

  • Fix failure when the inputs to UNNEST are 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 LIKE predicate. (#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)

  • Show distributed plan by default in EXPLAIN. (#3724)

  • 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-forwarded configuration property, and the old http-server.authentication.allow-forwarded-https and dispatcher.forwarded-header configuration properties are no longer supported. (#3714)

  • Add pluggable Certificate authenticator. (#3804)

JDBC driver#

  • Implement toString() for java.sql.Array results. (#3803)

CLI#

  • Improve rendering of elapsed time for short queries. (#3311)

Web UI#

  • Add fixed, certificate, JWT, and Kerberos to UI authentication. (#3433)

  • Show join distribution type in Live Plan. (#1323)

JDBC driver#

  • Improve performance of DatabaseMetaData.getColumns() when the parameters contain unescaped % or _. (#1620)

Elasticsearch connector#

  • Fix failure when executing SHOW CREATE TABLE. (#3718)

  • Improve performance for count(*) queries. (#3512)

  • Add support for raw Elasticsearch queries. (#3735)

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_time hidden column from bigint to 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-ttl and hive.metastore.thrift.delegation-token.cache-maximum-size configuration properties. (#3771)

MemSQL connector#

MongoDB connector#

  • Support case insensitive database and collection names. This can be enabled with the mongodb.case-insensitive-name-matching configuration property. (#3453)

SPI#

  • Allow a SystemAccessControl to provide an EventListener. (#3629).