Release 334 (29 May 2020)#
General#
Fix incorrect query results for certain queries involving comparisons of
real
anddouble
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()
andcurrent_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)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 oldhttp-server.authentication.allow-forwarded-https
anddispatcher.forwarded-header
configuration properties are no longer supported. (#3714)Add pluggable Certificate authenticator. (#3804)
JDBC driver#
Implement
toString()
forjava.sql.Array
results. (#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_time
hidden column frombigint
totimestamp 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
andhive.metastore.thrift.delegation-token.cache-maximum-size
configuration 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-matching
configuration property. (#3453)
SPI#
Allow a
SystemAccessControl
to provide anEventListener
. (#3629).