Release 408 (23 Feb 2023)#
General#
- Add physical input read time to query statistics and the output of - EXPLAIN ANALYZE. (#16190)
- Fix query failure for queries involving joins or aggregations with a structural type that contains - NULLelements. (#16140)
Security#
- Deprecate using groups with OAuth 2.0 authentication, and rename the - http-server.authentication.oauth2.groups-fieldconfiguration property to- deprecated.http-server.authentication.oauth2.groups-field. (#15669)
CLI#
- Add - AUTOoutput format which switches from- ALIGNEDto- VERTICALif the output doesn’t fit the current terminal. (#12208)
- Add - --pagerand- --history-fileoptions to match the existing- TRINO_PAGERand- TRINO_HISTORY_FILEenvironmental variables. Also allow setting these options in a configuration file. (#16151)
BigQuery connector#
- Add support for writing - decimaltypes to BigQuery. (#16145)
Delta Lake connector#
- Rename the connector to - delta_lake. The old name- delta-lakeis now deprecated and will be removed in a future release. (#13931)
- Add support for creating tables with the Trino - change_data_feed_enabledtable property. (#16129)
- Improve query performance on tables that Trino has written to with - INSERT. (#16026)
- Improve performance of reading structural types from Parquet files. This optimization can be disabled with the - parquet_optimized_nested_reader_enabledcatalog session property or the- parquet.optimized-nested-reader.enabledcatalog configuration property. (#16177)
- Retry dropping Delta tables registered in the Glue catalog to avoid failures due to concurrent modifications. (#13199) 
- Allow updating the - reader_versionand- writer_versiontable properties. (#15932)
- Fix inaccurate change data feed entries for - MERGEqueries. (#16127)
- Fix performance regression when writing to partitioned tables if table statistics are absent. (#16152) 
Hive connector#
- Remove support for the deprecated - hive-hadoop2connector name, requiring the- connector.nameproperty to be set to- hive. (#16166)
- Retry dropping Delta tables registered in the Glue catalog to avoid failures due to concurrent modifications. (#13199) 
- Fix performance regression when writing to partitioned tables if table statistics are absent. (#16152) 
Iceberg connector#
- Reduce memory usage when reading - $filessystem tables. (#15991)
- Require the - iceberg.jdbc-catalog.driver-classconfiguration property to be set to prevent a “driver not found” error after initialization. (#16196)
- Fix performance regression when writing to partitioned tables if table statistics are absent. (#16152) 
Ignite connector#
- Add Ignite connector. (#8098) 
SingleStore connector#
- Remove support for the deprecated - memsqlconnector name, requiring the- connector.nameproperty to be set to- singlestore. (#16180)
SQL Server connector#
- Add support for pushing down - =,- <>and- INpredicates over text columns if the column uses a case-sensitive collation within SQL Server. (#15714)
Thrift connector#
- Rename the connector to - trino_thrift. The old name- trino-thriftis now deprecated and will be removed in a future release. (#13931)