Release 0.147

    • Fix incorrect formatting of dates and timestamps before year 1680.

    • Fix handling of syntax errors when parsing .

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

    • Support LIKE clause for SHOW CATALOGS and .

    • Add support for INTERSECT.

    • Add sequence() function.

    • Add function.

    • Add flatten() function.

    • Add experimental implementation of .

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

    • Generalize the intra-node parallel execution system to work with all query stages. The task.concurrency configuration property replaces the old 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 NoClassDefFoundError for 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).

    • Fix error code 6 when reading data from Kafka.

    • Add support for varchar(n).

    • Add support for varchar(n).

    • Add support for varchar(n).