11.77. Release 0.154

General Changes

  • Fix planning issue that could cause JOIN queries involving functionsthat return null on non-null input to produce incorrect results.
  • Fix regression that would cause certain queries involving uncorrelatedsubqueries in IN predicates 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” errorthat triggers the JVM’s OutOfMemoryError handling.
  • Improve performance of window functions with identical partitioning andordering but different frame specifications.
  • Add code-cache-collection-threshold config which controls when Prestowill attempt to force collection of the JVM code cache and reduce thedefault threshold to 40%.
  • Add support for using LIKE with CREATE TABLE.
  • Add support for DESCRIBE INPUT to describe the requirements forthe input parameters to a prepared statement.

Hive Changes

  • Fix handling of metastore cache TTL. With the introduction of theper-transaction cache, the cache timeout was reset after each access,which means cache entries might never expire.