Release 0.147#
General#
- 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 - WITHclause.
- Support - LIKEclause 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-aggregationsconfig option and- task_intermediate_aggregationsession 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.concurrencyconfiguration property replaces the old- task.join-concurrencyand- task.default-concurrencyoptions. Similarly, the- task_concurrencysession property replaces the- task_join_concurrency,- task_hash_build_concurrency, and- task_aggregation_concurrencyproperties.
Hive#
- Fix reading symlinks when the target is in a different HDFS instance. 
- Fix - NoClassDefFoundErrorfor- SubnetUtilsin 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_byto- bucketed_by.
- Add support for - varchar(n).
Kafka#
- Fix - error code 6when reading data from Kafka.
- Add support for - varchar(n).
Redis#
- Add support for - varchar(n).
MySQL and PostgreSQL#
- Cleanup temporary data when a - CREATE TABLE ASfails.
- Add support for - varchar(n).