Release 369 (24 Jan 2022)#

General#

  • Add support for Pacific/Kanton time zone. (#10679)

  • Display Physical input read time using most succinct time unit in EXPLAIN ANALYZE VERBOSE. (#10576)

  • Fine tune request retry mechanism in HTTP event listener. (#10566)

  • Add support for using PostgreSQL and Oracle as backend database for resource groups. (#9812)

  • Remove unnecessary spilling configuration properties spill-order-by and spill-window-operator. (#10591)

  • Remove distinction between system and user memory to simplify cluster configuration. The configuration property query.max-total-memory-per-node is removed. Use query.max-memory-per-node instead. (#10574)

  • Use formatting specified in the SQL standard when casting double and real values to varchar type. (#552)

  • Add support for ALTER MATERIALIZED VIEW ... SET PROPERTIES. (#9613)

  • Add experimental implementation of task level retries. This can be enabled by setting the retry-policy configuration property or the retry_policy session property to task. (#9818)

  • Improve query wall time by splitting workload between nodes in a more balanced way. Previous workload balancing policy can be restored via node-scheduler.splits-balancing-policy=node. (#10660)

  • Prevent hanging query execution on failures with phased execution policy. (#10656)

  • Catch overflow in decimal multiplication. (#10732)

  • Fix UnsupportedOperationException in max_by and min_by aggregation. (#10599)

  • Fix incorrect results or failure when casting date to varchar(n) type. (#552)

  • Fix issue where the length of log file names grow indefinitely upon log rotation. (#10738)

Security#

  • Allow extracting groups from OAuth2 claims from http-server.authentication.oauth2.groups-field. (#10262)

JDBC driver#

  • Fix memory leak when using DatabaseMetaData. (#10584, #10632)

BigQuery connector#

  • Remove bigquery.case-insensitive-name-matching.cache-ttl configuration option. It was previously ignored. (#10697)

  • Fix query failure when reading columns with numeric or bignumeric type. (#10564)

ClickHouse connector#

  • Upgrade minimum required version to 21.3. (#10703)

  • Add support for renaming schemas. (#10558)

  • Add support for setting column comments. (#10641)

  • Map ClickHouse ipv4 and ipv6 types to Trino ipaddress type. (#7098)

  • Allow mapping ClickHouse fixedstring or string as Trino varchar via the map_string_as_varchar session property. (#10601)

  • Disable avg pushdown on decimal types to avoid incorrect results. (#10650)

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

Druid connector#

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

Hive connector#

  • Add support for writing Bloom filters in ORC files. (#3939)

  • Allow flushing the metadata cache for specific schemas, tables, or partitions with the flush_metadata_cache system procedure. (#10385)

  • Add support for long lived AWS Security Token Service (STS) credentials for authentication with Glue catalog. (#10735)

  • Ensure transaction locks in the Hive Metastore are released in case of query failure when querying Hive ACID tables. (#10401)

  • Disallow reading from Iceberg tables when redirects from Hive to Iceberg are not enabled. (#8693, #10441)

  • Improve performance of queries using range predicates when reading ORC files with Bloom filters. (#4108)

  • Support writing Parquet files greater than 2GB. (#10722)

  • Fix spurious errors when metadata cache is enabled. (#10646, #10512)

  • Prevent data loss during DROP SCHEMA when the schema location contains files that are not part of existing tables. (#10485)

  • Fix inserting into transactional table when task_writer_count > 1. (#9149)

  • Fix possible data corruption when writing data to S3 with streaming enabled. (#10710)

Iceberg connector#

  • Add $properties system table which can be queried to inspect Iceberg table properties. (#10480)

  • Add support for ALTER TABLE .. EXECUTE OPTIMIZE statement. (#10497)

  • Respect Iceberg column metrics mode when writing. (#9938)

  • Add support for long lived AWS Security Token Service (STS) credentials for authentication with Glue catalog. (#10735)

  • Improve performance of queries using range predicates when reading ORC files with Bloom filters. (#4108)

  • Improve select query planning performance after write operations from Trino. (#9340)

  • Ensure table statistics are accumulated in a deterministic way from Iceberg column metrics. (#9716)

  • Prevent data loss during DROP SCHEMA when the schema location contains files that are not part of existing tables. (#10485)

  • Support writing Parquet files greater than 2GB. (#10722)

  • Fix materialized view refresh when view a query references the same table multiple times. (#10570)

  • Fix possible data corruption when writing data to S3 with streaming enabled. (#10710)

MySQL connector#

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

Oracle connector#

  • Map Oracle date to Trino timestamp(0) type. (#10626)

  • Fix performance regression of predicate pushdown on indexed date columns. (#10626)

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

Phoenix connector#

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

Pinot connector#

  • Add support for basic authentication. (#9531)

PostgreSQL connector#

Redshift connector#

SingleStore (MemSQL) connector#

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

SQL Server connector#

  • Fix spurious errors when metadata cache is enabled. (#10544, #10512)

SPI#

  • Remove support for the ConnectorMetadata.getTableLayout() API. (#781)