# Presto 316 Documentation

## 12.25. Release 0.208

Warning

This release has the potential for data loss in the Hive connector when writing bucketed sorted tables.

## General Changes

- Fix an issue with memory accounting that would lead to garbage collection pauses and out of memory exceptions.
- Fix an issue that produces incorrect results when `push_aggregation_through_join` is enabled (#10724).
- Preserve field names when unnesting columns of type `ROW`.
- Make the cluster out of memory killer more resilient to memory accounting leaks. Previously, memory accounting leaks on the workers could effectively disable the out of memory killer.
- Improve planning time for queries over tables with high column count.
- Add a limit on the number of stages in a query. The default is `100` and can be changed with the `query.max-stage-count` configuration property and the `query_max_stage_count` session property.
- Add `spooky_hash_v2_32()` and `spooky_hash_v2_64()` functions.
- Add a cluster memory leak detector that logs queries that have possibly accounted for memory usage incorrectly on workers. This is a tool to for debugging internal errors.
- Add support for correlated subqueries requiring coercions.
- Add experimental support for running on Linux ppc64le.

## CLI Changes

- Fix creation of the history file when it does not exist.
- Add `PRESTO_HISTORY_FILE` environment variable to override location of history file.

## Hive Connector Changes

- Remove size limit for writing bucketed sorted tables.
- Support writer scaling for Parquet.
- Improve stripe size estimation for the optimized ORC writer. This reduces the number of cases where tiny ORC stripes will be written.
- Provide the actual size of CHAR, VARCHAR, and VARBINARY columns to the cost based optimizer.
- Collect column level statistics when writing tables. This is disabled by default, and can be enabled by setting the `hive.collect-column-statistics-on-write` property.

## Thrift Connector Changes

- Include error message from remote server in query failure message.