Release 411 (29 Mar 2023)#
General#
- Add spilled data size to query statistics. (#16442) 
- Add - quantile_at_value()function. (#16736)
- Add support for a - GRACE PERIODclause in the- CREATE MATERIALIZED VIEWtask. For backwards compatibility, the existing materialized views are interpreted as having a- GRACE PERIODof zero, however, new materialized views have an unlimited grace period by default. This is a backwards incompatible change, and the previous behavior can be restored with the- legacy.materialized-view-grace-periodconfiguration property or the- legacy_materialized_view_grace_periodsession property. (#15842)
- Fix potential incorrect query stats when tasks are waiting on running drivers to fully terminate. (#15478) 
- Add support for specifying the number of nodes that will write data during - INSERT,- CREATE TABLE ... AS SELECT, or- EXECUTEqueries with the- query.max-writer-tasks-countconfiguration property. (#16238)
- Improve performance of queries that contain predicates involving the - yearfunction. (#14078)
- Improve performance of queries that contain a - sumaggregation. (#16624)
- Improve performance of - filterfunction on arrays. (#16681)
- Reduce redundant data exchanges for queries with multiple aggregations. (#16328) 
- Fix incorrect query results when using - keyvalue()methods in the JSON path. (#16482)
- Fix potential incorrect results in queries involving joins and a non-deterministic value. (#16512) 
- Fix potential query failure when exchange compression is enabled. (#16541) 
- Fix query failure when calling a function with a large number of parameters. (#15979) 
BigQuery connector#
- Fix failure of aggregation queries when executed against a materialized view, external table, or snapshot table. (#15546) 
Delta Lake connector#
- Add support for inserting into tables that have simple invariants. (#16136) 
- Add generated column expressions to the - Extracolumn in the results of- DESCRIBEand- SHOW COLUMNS. (#16631)
- Expand the - flush_metadata_cachetable procedure to also flush the internal caches of table snapshots and active data files. (#16466)
- Collect statistics for newly-created columns. (#16109) 
- Remove the - $datasystem table. (#16650)
- Fix query failure when evaluating a - WHEREclause on a partition column. (#16388)
Druid connector#
- Fix failure when the query passed to the - querytable function contains a column alias. (#16225)
Elasticsearch connector#
- Remove the deprecated pass-through query, which has been replaced with the - raw_querytable function. (#13050)
Hive connector#
- Add a native OpenX JSON file format reader and writer. These can be disabled with the - openx_json_native_reader_enabledand- openx_json_native_writer_enabledsession properties or the- openx-json.native-reader.enabledand- openx-json.native-writer.enabledconfiguration properties. (#16073)
- Add support for implicit coercions between - chartypes of different lengths. (#16402)
- Improve performance of queries with joins where both sides of a join have keys with the same table bucketing definition. (#16381) 
- Improve query planning performance for queries scanning tables with a large number of columns. (#16203) 
- Improve scan performance for - COUNT(*)queries on row-oriented formats. (#16595)
- Ensure the value of the - hive.metastore-stats-cache-ttlconfiguration property always is greater than or equal to the value specified in the- hive.metastore-cache-ttlconfiguration property. (#16625)
- Skip listing Glue metastore tables with invalid column types. (#16677) 
- Fix query failure when a file that is using a text file format with a single header row that is large enough to be split into multiple files. (#16492) 
- Fix potential query failure when Kerberos is enabled and the query execution takes longer than a Kerberos ticket’s lifetime. (#16680) 
Hudi connector#
- Add a - $timelinesystem table which can be queried to inspect the Hudi table timeline. (#16149)
Iceberg connector#
- Add a - migrateprocedure that converts a Hive table to an Iceberg table. (#13196)
- Add support for materialized views with a freshness grace period. (#15842) 
- Add a - $refssystem table which can be queried to inspect snapshot references. (#15649)
- Add support for creation of materialized views partitioned with a temporal partitioning function on a - timestamp with time zonecolumn. (#16637)
- Improve performance of queries run after data was written by Trino. (#15441) 
- Remove the - $datasystem table. (#16650)
- Fix failure when the - $filessystem table contains non-null values in the- key_metadata,- split_offsets, and- equality_idscolumns. (#16473)
- Fix failure when partitioned column names contain uppercase characters. (#16622) 
Ignite connector#
MariaDB connector#
- Fix failure when the query passed to the - querytable function contains a column alias. (#16225)
MongoDB connector#
- Fix incorrect results when the query passed to the MongoDB - querytable function contains helper functions such as- ISODate. (#16626)
MySQL connector#
- Fix failure when the query passed to the - querytable function contains a column alias. (#16225)
Oracle connector#
- Improve performance of queries when the network latency between Trino and Oracle is high, or when selecting a small number of columns. (#16644) 
PostgreSQL connector#
- Improve performance of queries when the network latency between Trino and PostgreSQL is high, or when selecting a small number of columns. (#16644) 
Redshift connector#
- Improve performance of queries when the network latency between Trino and Redshift is high, or when selecting a small number of columns. (#16644) 
SingleStore connector#
- Fix failure when the query passed to the - querytable function contains a column alias. (#16225)
SQL Server connector#
- Add support for executing stored procedures using the - proceduretable function. (#16696)