# Presto 316 Documentation

## 12.1. Release 316

## General Changes

- Fix `date_format` function failure when format string contains non-ASCII characters. (#1056)
- Improve performance of queries using `UNNEST`. (#901)
- Improve error message when statement parsing fails. (#1042)

## CLI Changes

- Fix refresh of completion cache when catalog or schema is changed. (#1016)
- Allow reading password from console when stdout is a pipe. (#982)

## Hive Connector Changes

- Acquire S3 credentials from the default AWS locations if not configured explicitly. (#741)
- Only allow using roles and grants with SQL standard based authorization. (#972)
- Add support for `CSV` file format. (#920)
- Support reading from and writing to Hadoop encryption zones (Hadoop KMS). (#997)
- Collect column statistics on write by default. This can be disabled using the `hive.collect-column-statistics-on-write` configuration property or the `collect_column_statistics_on_write` session property. (#981)
- Eliminate unused idle threads when using the metastore cache. (#1061)

## PostgreSQL Connector Changes

- Add support for columns of type `UUID`. (#1011)
- Export JMX statistics for various JDBC and connector operations. (#906).

## MySQL Connector Changes

- Export JMX statistics for various JDBC and connector operations. (#906).

## Redshift Connector Changes

- Export JMX statistics for various JDBC and connector operations. (#906).

## SQL Server Connector Changes

- Export JMX statistics for various JDBC and connector operations. (#906).

## TPC-H Connector Changes

- Fix `SHOW TABLES` failure when used with a hidden schema. (#1005)

## TPC-DS Connector Changes

- Fix `SHOW TABLES` failure when used with a hidden schema. (#1005)

## SPI Changes

- Add support for pushing simple column and row field reference expressions into connectors via the `ConnectorMetadata.applyProjection()` method. (#676)