# Presto 316 Documentation

## 12.47. Release 0.186

Warning

This release has a stability issue that may cause query failures in large deployments due to HTTP requests timing out.

## General Changes

- Fix excessive GC overhead caused by map to map cast.
- Fix implicit coercions for `ROW` types, allowing operations between compatible types such as `ROW(INTEGER)` and `ROW(BIGINT)`.
- Fix issue that may cause queries containing expensive functions, such as regular expressions, to continue using CPU resources even after they are killed.
- Fix performance issue caused by redundant casts.
- Fix `json_parse()` to not ignore trailing characters. Previously, input such as `[1,2]abc` would successfully parse as `[1,2]`.
- Fix leak in running query counter for failed queries. The counter would increment but never decrement for queries that failed before starting.
- Reduce coordinator HTTP thread usage for queries that are queued or waiting for data.
- Reduce memory usage when building data of `VARCHAR` or `VARBINARY` types.
- Estimate memory usage for `GROUP BY` more precisely to avoid out of memory errors.
- Add queued time and elapsed time to the client protocol.
- Add `query_max_execution_time` session property and `query.max-execution-time` config property. Queries will be aborted after they execute for more than the specified duration.
- Add `inverse_normal_cdf()` function.
- Add Geospatial Functions including functions for processing Bing tiles.
- Add Spill to Disk for joins.
- Add Redshift Connector.

## Resource Groups Changes

- Query Queues are deprecated in favor of Resource Groups and will be removed in a future release.
- Rename the `maxRunning` property to `hardConcurrencyLimit`. The old property name is deprecated and will be removed in a future release.
- Fail on unknown property names when loading the JSON config file.

## JDBC Driver Changes

- Allow specifying an empty password.
- Add `getQueuedTimeMillis()` and `getElapsedTimeMillis()` to `QueryStats`.

## Hive Changes

- Fix `FileSystem closed` errors when using Kerberos authentication.
- Add support for path style access to the S3 file system. This can be enabled by setting the `hive.s3.path-style-access=true` config property.

## SPI Changes

- Add an `ignoreExisting` flag to `ConnectorMetadata::createTable()`.
- Remove the `getTotalBytes()` method from `RecordCursor` and `ConnectorPageSource`.

Note

These are backwards incompatible changes with the previous SPI. If you have written a connector, you will need to update your code before deploying this release.