ContextQMD
Back to Trino

Release 0.147

docs/src/main/sphinx/release/release-0.147.md

4802.4 KB
Original Source

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 {doc}/sql/show-create-view and {doc}/sql/show-create-table.
  • Add support for column aliases in WITH clause.
  • Support LIKE clause for {doc}/sql/show-catalogs and {doc}/sql/show-schemas.
  • Add support for INTERSECT.
  • Add support for casting row types.
  • Add {func}sequence function.
  • Add {func}sign function.
  • Add {func}flatten function.
  • Add experimental implementation of {doc}resource groups </admin/resource-groups>.
  • Add localfile 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 {func}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

  • 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

  • Fix error code 6 when 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 AS fails.
  • Add support for varchar(n).