Release 369 (24 Jan 2022)#
General#
- Add support for - Pacific/Kantontime zone. (#10679)
- Display - Physical input read timeusing 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-byand- spill-window-operator. (#10591)
- Remove distinction between system and user memory to simplify cluster configuration. The configuration property - query.max-total-memory-per-nodeis removed. Use- query.max-memory-per-nodeinstead. (#10574)
- Use formatting specified in the SQL standard when casting - doubleand- realvalues to- varchartype. (#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-policyconfiguration property or the- retry_policysession 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 - phasedexecution policy. (#10656)
- Catch overflow in decimal multiplication. (#10732) 
- Fix - UnsupportedOperationExceptionin- max_byand- min_byaggregation. (#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#
BigQuery connector#
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 - ipv4and- ipv6types to Trino- ipaddresstype. (#7098)
- Allow mapping ClickHouse - fixedstringor- stringas Trino- varcharvia the- map_string_as_varcharsession property. (#10601)
- Disable - avgpushdown on- decimaltypes to avoid incorrect results. (#10650)
- Fix spurious errors when metadata cache is enabled. (#10544, #10512) 
Druid connector#
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 SCHEMAwhen 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 - $propertiessystem table which can be queried to inspect Iceberg table properties. (#10480)
- Add support for - ALTER TABLE .. EXECUTE OPTIMIZEstatement. (#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 SCHEMAwhen 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#
Oracle connector#
Phoenix connector#
Pinot connector#
- Add support for basic authentication. (#9531) 
PostgreSQL connector#
- Add support for renaming schemas. (#8939) 
- Fix spurious errors when metadata cache is enabled. (#10544, #10512) 
Redshift connector#
- Add support for renaming schemas. (#8939) 
- Fix spurious errors when metadata cache is enabled. (#10544, #10512) 
SingleStore (MemSQL) connector#
SQL Server connector#
SPI#
- Remove support for the - ConnectorMetadata.getTableLayout()API. (#781)