# Presto 316 Documentation

## 12.140. 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.