Release 0.154#
General#
Fix planning issue that could cause
JOINqueries involving functions that return null on non-null input to produce incorrect results.Fix regression that would cause certain queries involving uncorrelated subqueries in
INpredicates to fail during planning.Fix potential “Input symbols do not match output symbols” error when writing to bucketed tables.
Fix potential “Requested array size exceeds VM limit” error that triggers the JVM’s
OutOfMemoryErrorhandling.Improve performance of window functions with identical partitioning and ordering but different frame specifications.
Add
code-cache-collection-thresholdconfig which controls when Presto will attempt to force collection of the JVM code cache and reduce the default threshold to40%.Add support for using
LIKEwith CREATE TABLE.Add support for
DESCRIBE INPUTto describe the requirements for the input parameters to a prepared statement.
Hive#
Fix handling of metastore cache TTL. With the introduction of the per-transaction cache, the cache timeout was reset after each access, which means cache entries might never expire.