# Presto 316 Documentation

## 12.29. Release 0.204

## General Changes

- Use distributed join if one side is naturally partitioned on join keys.
- Improve performance of correlated subqueries when filters from outer query can be propagated to the subquery.
- Improve performance for correlated subqueries that contain inequalities.
- Add support for all geometry types in `ST_Area()`.
- Add `ST_EnvelopeAsPts()` function.
- Add `to_big_endian_32()` and `from_big_endian_32()` functions.
- Add cast between `VARBINARY` type and `IPADDRESS` type.
- Make `lpad()` and `rpad()` functions support `VARBINARY` in addition to `VARCHAR`.
- Allow using arrays of mismatched lengths with `zip_with()`. The missing positions are filled with `NULL`.
- Track execution statistics of `AddExchanges` and `PredicatePushdown` optimizer rules.

## Event Listener Changes

- Add resource estimates to query events.

## Web UI Changes

- Fix kill query button.
- Display resource estimates in Web UI query details page.

## Resource Group Changes

- Fix unnecessary queuing in deployments where no resource group configuration was specified.

## Hive Connector Changes

- Fix over-estimation of memory usage for scan operators when reading ORC files.
- Fix memory accounting for sort buffer used for writing sorted bucketed tables.
- Disallow creating tables with unsupported partition types.
- Support overwriting partitions for insert queries. This behavior is controlled by session property `insert_existing_partitions_behavior`.
- Prevent the optimized ORC writer from writing excessively large stripes for highly compressed, dictionary encoded columns.
- Enable optimized Parquet reader and predicate pushdown by default.

## Cassandra Connector Changes

- Add support for reading from materialized views.
- Optimize partition list retrieval for Cassandra 2.2+.