12.103. 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.

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).