Release 440 (8 Mar 2024)#
General#
- Add Snowflake connector. (#17909) 
- Add support for sub-queries inside - UNNESTclauses. (#17953)
- Improve performance of - arrays_overlap(). (#20900)
- Export JMX statistics for resource groups by default. This can be disabled with the - jmxExportresource group property. (#20810)
- Fix query failure when a check constraint is null. (#20906) 
- Fix query failure for aggregations over - CASEexpressions when the input evaluation could throw an error. (#20652)
- Fix incorrect behavior of the else clause in a SQL routines with a single if/end condition. (#20926) 
- Fix the - ALTER TABLE EXECUTE optimizequeries failing due to exceeding the open writer limit. (#20871)
- Fix certain - INSERTand- CREATE TABLE AS .. SELECTqueries failing due to exceeding the of open writer limit on partitioned tables. (#20871)
- Fix “multiple entries with same key” query failure for queries with joins on partitioned tables. (#20917) 
- Fix incorrect results when using - GRANT,- DENY, and- REVOKEclauses on views and materialized views. (#20812)
Security#
- Add support for row filtering and column masking in Open Policy Agent access control. (#20921) 
Web UI#
- Fix error when using authentication tokens larger than 4 kB. (#20787) 
Delta Lake connector#
- Add support for concurrent - INSERTqueries. (#18506)
- Improve latency for queries with file system caching enabled. (#20851) 
- Improve latency for queries on tables with checkpoints. (#20901) 
- Fix query failure due to “corrupted statistics” when reading Parquet files with a predicate on a long decimal column. (#20981) 
Hive connector#
- Add support for bearer token authentication for a Thrift metastore connection. (#20371) 
- Add support for commenting on partitioned columns in the Thrift metastore. (#20264) 
- Add support for changing a column’s type from - varcharto- float. (#20719)
- Add support for changing a column’s type from - varcharto- char. (#20723)
- Add support for changing a column’s type from - varcharto- boolean. (#20741)
- Add support for configuring a - regionand- endpointfor S3 security mapping. (#18838)
- Improve performance when reading JSON files. (#19396) 
- Fix incorrect truncation when decoding - varchar(n)and- char(n)in- TEXTFILEand- SEQUENCEFILEformats. (#20731)
- Fix query failure when - hive.file-status-cache-tablesis enabled for a table and new manifest files have been added but not cached yet. (#20344)
- Fix error when trying to - INSERTinto a transactional table that does not have partitions. (#19407)
- Fix query failure due to “corrupted statistics” when reading Parquet files with a predicate on a long decimal column. (#20981) 
Hudi connector#
- Fix query failure due to “corrupted statistics” when reading Parquet files with a predicate on a long decimal column. (#20981) 
Iceberg connector#
Warning
This release has a major regression which is fixed in Trino 442.
- Improve latency of queries when file system caching is enabled. (#20803) 
- Disallow setting the materialized view owner when using system security with the Glue catalog. (#20647) 
- Rename the - orc.bloom.filter.columnsand- orc.bloom.filter.fpptable properties to- write.orc.bloom.filter.columnsand- write.orc.bloom.filter.fpp, respectively. (#20432)
- Fix query failure due to “corrupted statistics” when reading Parquet files with a predicate on a long decimal column. (#20981)