# Presto 316 Documentation

## 12.66. Release 0.167

## General Changes

- Fix planning failure when a window function depends on the output of another window function.
- Fix planning failure for certain aggregation with both `DISTINCT` and `GROUP BY`.
- Fix incorrect aggregation of operator summary statistics.
- Fix a join issue that could cause joins that produce and filter many rows to monopolize worker threads, even after the query has finished.
- Expand plan predicate pushdown capabilities involving implicitly coerced types.
- Short-circuit inner and right join when right side is empty.
- Optimize constant patterns for `LIKE` predicates that use an escape character.
- Validate escape sequences in `LIKE` predicates per the SQL standard.
- Reduce memory usage of `min_by()` and `max_by()`.
- Add `transform_keys()`, `transform_values()` and `zip_with()` lambda functions.
- Add `levenshtein_distance()` function.
- Add JMX stat for the elapsed time of the longest currently active split.
- Add JMX stats for compiler caches.
- Raise required Java version to 8u92.

## Security Changes

- The `http.server.authentication.enabled` config option that previously enabled Kerberos has been replaced with `http-server.authentication.type=KERBEROS`.
- Add support for LDAP Authentication using username and password.
- Add a read-only System Access Control named `read-only`.
- Allow access controls to filter the results of listing catalogs, schemas and tables.
- Add access control checks for SHOW SCHEMAS and SHOW TABLES.

## Web UI Changes

- Add operator-level performance analysis.
- Improve visibility of blocked and reserved query states.
- Lots of minor improvements.

## JDBC Driver Changes

- Allow escaping in `DatabaseMetaData` patterns.

## Hive Changes

- Fix write operations for `ViewFileSystem` by using a relative location.
- Remove support for the `hive-cdh4` and `hive-hadoop1` connectors which support CDH 4 and Hadoop 1.x, respectively.
- Remove the `hive-cdh5` connector as an alias for `hive-hadoop2`.
- Remove support for the legacy S3 block-based file system.
- Add support for KMS-managed keys for S3 server-side encryption.

## Cassandra Changes

- Add support for Cassandra 3.x by removing the deprecated Thrift interface used to connect to Cassandra. The following config options are now defunct and must be removed: `cassandra.thrift-port`, `cassandra.thrift-connection-factory-class`, `cassandra.transport-factory-options` and `cassandra.partitioner`.

## SPI Changes

- Add methods to `SystemAccessControl` and `ConnectorAccessControl` to filter the list of catalogs, schemas and tables.
- Add access control checks for SHOW SCHEMAS and SHOW TABLES.
- Add `beginQuery` and `cleanupQuery` notifications to `ConnectorMetadata`.