13.100. Release 0.147

    • 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 .
    • 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 support for casting row types.
    • 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 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 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).
    • Cleanup temporary data when a CREATE TABLE AS fails.
    • Add support for varchar(n).