Presto 0.141t Documentation

17.40. Release 0.104

17.40. 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.