Skip to main content

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)