12.138. Release 0.109

General Changes

  • Add slice(), md5(), array_min() and array_max() functions.
  • Fix bug that could cause queries submitted soon after startup to hang forever.
  • Fix bug that could cause JOIN queries to hang forever, if the right side ofthe JOIN had too little data or skewed data.
  • Improve index join planning heuristics to favor streaming execution.
  • Improve validation of date/time literals.
  • Produce RPM package for Presto server.
  • Always redistribute data when writing tables to avoid skew. This canbe disabled by setting the session property redistribute_writesor the config property redistribute-writes to false.

Remove “Big Query” Support

The experimental support for big queries has been removed in favor ofthe new resource manager which can be enabled via theexperimental.cluster-memory-manager-enabled config option.The experimental_big_query session property and the following configoptions are no longer supported: experimental.big-query-initial-hash-partitions,experimental.max-concurrent-big-queries and experimental.max-queued-big-queries.