Release 0.154
General Changes
- 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 Changes
- 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.
