20.156. Release 0.104

General Changes

  • Handle thread interruption in StatementClient.

  • Fix CLI hang when server becomes unreachable during a query.

  • Add covar_pop(), covar_samp(), corr(), regr_slope(), and regr_intercept() functions.

  • Fix potential deadlock in cluster memory manager.

  • Add a visualization of query execution timeline.

  • Allow mixed case in input to from_hex().

  • Display “BLOCKED” state in web UI.

  • Reduce CPU usage in coordinator.

  • Fix excess object retention in workers due to long running queries.

  • Reduce memory usage of array_distinct().

  • Add optimizer for projection push down which can improve the performance of certain query shapes.

  • Improve query performance by storing pre-partitioned pages.

  • Support TIMESTAMP for first_value(), last_value(), nth_value(), lead() and lag().

Hive Changes

  • Upgrade to Parquet 1.6.0.

  • Collect request time and retry statistics in PrestoS3FileSystem.

  • Fix retry attempt counting for S3.