Skip to main content

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 NULL elements. (#16140)

Security​

  • Deprecate using groups with OAuth 2.0 authentication, and rename the http-server.authentication.oauth2.groups-field configuration property to deprecated.http-server.authentication.oauth2.groups-field. (#15669)

CLI​

  • Add AUTO output format which switches from ALIGNED to VERTICAL if the output doesn't fit the current terminal. (#12208)
  • Add --pager and --history-file options to match the existing TRINO_PAGER and TRINO_HISTORY_FILE environmental variables. Also allow setting these options in a configuration file. (#16151)

BigQuery connector​

  • Add support for writing decimal types to BigQuery. (#16145)

Delta Lake connector​

  • Rename the connector to delta_lake. The old name delta-lake is now deprecated and will be removed in a future release. (#13931)
  • Add support for creating tables with the Trino change_data_feed_enabled table 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_enabled catalog session property or the parquet.optimized-nested-reader.enabled catalog configuration property. (#16177)
  • Retry dropping Delta tables registered in the Glue catalog to avoid failures due to concurrent modifications. (#13199)
  • Allow updating the reader_version and writer_version table properties. (#15932)
  • Fix inaccurate change data feed entries for MERGE queries. (#16127)
  • Fix performance regression when writing to partitioned tables if table statistics are absent. (#16152)

Hive connector​

  • Remove support for the deprecated hive-hadoop2 connector name, requiring the connector.name property 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 $files system tables. (#15991)
  • Require the iceberg.jdbc-catalog.driver-class configuration 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​

SingleStore connector​

  • Remove support for the deprecated memsql connector name, requiring the connector.name property to be set to singlestore. (#16180)

SQL Server connector​

  • Add support for pushing down =, <> and IN predicates 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-thrift is now deprecated and will be removed in a future release. (#13931)