# Presto 316 Documentation

## 12.90. Release 0.147

## General Changes

- Fix race condition that can cause queries that process data from non-columnar data sources to fail.
- Fix incorrect formatting of dates and timestamps before year 1680.
- Fix handling of syntax errors when parsing `EXTRACT`.
- Fix potential scheduling deadlock for connectors that expose node-partitioned data.
- Fix performance regression that increased planning time.
- Fix incorrect results for grouping sets for some queries with filters.
- Add SHOW CREATE VIEW and SHOW CREATE TABLE.
- Add support for column aliases in `WITH` clause.
- Support `LIKE` clause for SHOW CATALOGS and SHOW SCHEMAS.
- Add support for `INTERSECT`.
- Add support for casting row types.
- Add `sequence()` function.
- Add `sign()` function.
- Add `flatten()` function.
- Add experimental implementation of resource groups.
- Add Local File Connector.
- Remove experimental intermediate aggregation optimizer. The `optimizer.use-intermediate-aggregations` config option and `task_intermediate_aggregation` session property are no longer supported.
- Add support for colocated joins for connectors that expose node-partitioned data.
- Improve the performance of `array_intersect()`.
- Generalize the intra-node parallel execution system to work with all query stages. The `task.concurrency` configuration property replaces the old `task.join-concurrency` and `task.default-concurrency` options. Similarly, the `task_concurrency` session property replaces the `task_join_concurrency`, `task_hash_build_concurrency`, and `task_aggregation_concurrency` properties.

## Hive Changes

- Fix reading symlinks when the target is in a different HDFS instance.
- Fix `NoClassDefFoundError` for `SubnetUtils` in HDFS client.
- Fix error when reading from Hive tables with inconsistent bucketing metadata.
- Correctly report read bytes when reading Parquet data.
- Include path in unrecoverable S3 exception messages.
- When replacing an existing Presto view, update the view data in the Hive metastore rather than dropping and recreating it.
- Rename table property `clustered_by` to `bucketed_by`.
- Add support for `varchar(n)`.

## Kafka Changes

- Fix `error code 6` when reading data from Kafka.
- Add support for `varchar(n)`.

## Redis Changes

- Add support for `varchar(n)`.

## MySQL and PostgreSQL Changes

- Cleanup temporary data when a `CREATE TABLE AS` fails.
- Add support for `varchar(n)`.