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 todeprecated.http-server.authentication.oauth2.groups-field
. (#15669)
CLI#
Add
AUTO
output format which switches fromALIGNED
toVERTICAL
if the output doesn’t fit the current terminal. (#12208)Add
--pager
and--history-file
options to match the existingTRINO_PAGER
andTRINO_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 namedelta-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 theparquet.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
andwriter_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 theconnector.name
property to be set tohive
. (#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#
Add Ignite connector. (#8098)
SingleStore connector#
Remove support for the deprecated
memsql
connector name, requiring theconnector.name
property to be set tosinglestore
. (#16180)
SQL Server connector#
Add support for pushing down
=
,<>
andIN
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 nametrino-thrift
is now deprecated and will be removed in a future release. (#13931)