Release 392 (3 Aug 2022)#

General#

Add support for dynamic filtering when task-based fault-tolerant execution is enabled. (#9935)
Add support for correlated sub-queries in DELETE queries. (#9447)
Fix potential query failure in certain complex queries with multiple joins and aggregations. (#13315)

Add the assumeLiteralUnderscoreInMetadataCallsForNonConformingClients configuration property as a replacement for assumeLiteralNamesInMetadataCallsForNonConformingClients, which is deprecated and planned to be removed in a future release. (#12761)

Add support for using a randomized location when creating a table, so that future table renames or drops do not interfere with new tables created with the same name. This can be disabled by setting the delta.unique-table-location configuration property to false. (#12980)
Add delta.metadata.live-files.cache-ttl configuration property for the caching duration of active data files. (#13316)
Retain metadata properties and column metadata after schema changes. (#13368, #13418)
Prevent writing to a table with NOT NULL or column invariants columns. (#13353)
Fix incorrect min and max column statistics when writing NULL values. (#13389)

Add support for timestamp(p) predicate pushdown. (#8404)
Report the total time spent reading data from the data source. (#13132)
Change mapping for the Druid float type to the Trino real type instead of the double type. (#13412)

Add support for short timezone IDs when translating Hive views. For example, JST now works as an alias for Asia/Tokyo. (#13179)
Add support for Amazon S3 Select pushdown for JSON files. (#13354)

Add support for hidden $file_modified_time columns. (#13082)
Add support for the Avro file format. (#12125)
Add support for filtering splits based on $path column predicates. (#12785)
Improve query performance for tables with updated or deleted rows. (#13092)
Improve performance of the expire_snapshots command for tables with many snapshots. (#13399)
Use unique table locations by default. This can be disabled by setting the iceberg.unique-table-location configuration property to false. (#12941)
Use the correct table schema when reading a past version of a table. (#12786)
Return the $path column without encoding when the path contains double slashes on S3. (#13012)
Fix failure when inserting into a Parquet table with columns that have quotation marks in their names. (#13074)

Report the total time spent reading data from the data source. (#13132)
Change mapping for the MySQL enum type to the Trino varchar type instead of the char type. (#13303)
Fix failure when reading table statistics while the information_schema.column_statistics table doesn’t exist. (#13323)

Redact the values of pinot.grpc.tls.keystore-password and pinot.grpc.tls.truststore-password in the server log. (#13422)

Report the total time spent reading data from the data source. (#13132)
Improve performance of queries with an IN expression within a complex expression. (#13136)