Release 454 (15 Aug 2024)#
General#
Add support for retrieving lightweight query information from the
/v1/query
endpoint with thepruned
query parameter. (#20843)Add support for providing configuration for a secrets provider in a
secrets.toml
file in the main Trino configuration directory. (#22633)Add support for an event listener plugin that publishes events to Kafka. (#22426)
Add temporary support for restoring unsafe pushdown behavior removed in version 445. This can be enabled with the
optimizer.allow-unsafe-pushdown
configuration property. When this mode is enabled, certain queries containing expressions that may fail for some inputs may fail at runtime. (#22987)Improve performance of queries with multiple aggregations involving
DISTINCT
. (#22355)⚠️ Improve query concurrency when memory is low by removing the
query.low-memory-killer.delay
configuration property. (#22936)Avoid retrying failed filesystem operations when they will always fail. (#22678)
Fix failure for queries involving
json_parse()
and a cast toarray
,map
, orrow
. (#22840)Fix query failure when file-based network topology is configured with the
node-scheduler.network-topology.file
configuration property. (#18793)
Web UI#
Add information about which tables and routines have been referenced by a query. (#20843)
JDBC driver#
BigQuery connector#
Add support for the
execute
procedure. (#22692)
Delta Lake connector#
Hive connector#
Add support for using the
hive.metastore-refresh-interval
configuration property when using Glue v2 Hive metastore. (#22706)Add S3 security mapping for the native S3 filesystem. (#22559)
⚠️ Rename metastore OpenTelemetry attributes from
trino.hive.*
totrino.metastore.*
. (#22866)Add support for adjusting UTC-adjusted
INT64
timestamps to the timezone specified in thehive.parquet.time-zone
property when reading Parquet files. (#22577)Fix potential query failure caused by incorrect bucket column validation. (#22261)
Fix error when reading
INT96
timestamps in Parquet files generated by AWS Wrangler. (#22854)
Hudi connector#
Iceberg connector#
Add S3 security mapping for the native S3 filesystem. (#22559)
Add support for changing a column’s type from
tinyint
orsmallint
tointeger
. (#19971)Improve query planning performance by caching Iceberg metadata files on the coordinator. This behavior can be disabled by setting the new
iceberg.metadata-cache.enabled
configuration property tofalse
. (#22739)⚠️ Rename metastore OpenTelemetry attributes from
trino.hive.*
totrino.metastore.*
. (#22866)
Memory connector#
Fix incorrect results after truncating tables. (#22665)
Oracle connector#
Add support for specifying the JDBC fetch size with the
oracle.fetch-size
configuration property. (#22670)
PostgreSQL connector#
Add support for specifying the JDBC fetch size with the
postgresql.fetch-size
configuration property. (#22670)Improve performance when using the
euclidean_distance
andcosine_distance
functions onvector
types. (#22618)Improve performance when a query contains
-dot_product
projections. (#23015)Fix failure when a user-defined type name contains uppercase characters. (#22848)
Redshift connector#
Add support for specifying the JDBC fetch size with the
redshift.fetch-size
configuration property. (#22670)