# Presto 316 Documentation

## 12.69. Release 0.164

## General Changes

- Fix correctness issue for queries that perform `DISTINCT` and `LIMIT` on the results of a `JOIN`.
- Fix correctness issue when casting between maps where the key or value is the `REAL` type.
- Fix correctness issue in `min_by()` and `max_by()` when nulls are present in the comparison column.
- Fail queries when `FILTER` clause is specified for scalar functions.
- Fix planning failure for certain correlated subqueries that contain aggregations.
- Fix planning failure when arguments to selective aggregates are derived from other selective aggregates.
- Fix boolean expression optimization bug that can cause long planning times, planning failures and coordinator instability.
- Fix query failure when `TRY` or lambda expression with the exact same body is repeated in an expression.
- Fix split source resource leak in coordinator that can occur when a query fails.
- Improve `array_join()` performance.
- Improve error message for map subscript operator when key is not present in the map.
- Improve client error message for invalid session.
- Add `VALIDATE` mode for EXPLAIN.

## Web UI Changes

- Add resource group to query detail page.

## Hive Changes

- Fix handling of ORC files containing extremely large metadata.
- Fix failure when creating views in file based metastore.
- Improve performance for queries that read bucketed tables by optimizing scheduling.