Skip to main content

Release 454 (15 Aug 2024)

General​

  • Add support for retrieving lightweight query information from the /v1/query endpoint with the pruned 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)
  • ⚠️ Breaking change: 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 to array, map, or row. (#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 UDFs have been referenced by a query. (#20843)

JDBC driver​

  • Add support for the NO_GENERATED_KEYS option in the Connection.prepareStatement method. (#22100)
  • Fix the Trino username incorrectly defaulting to the name of the user running the Trino process when no username is specified. (#22901)

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)
  • ⚠️ Breaking change: Rename metastore OpenTelemetry attributes from trino.hive.* to trino.metastore.*. (#22866)
  • Add support for adjusting UTC-adjusted INT64 timestamps to the timezone specified in the hive.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​

  • Add S3 security mapping for the native S3 filesystem. (#22559)
  • ⚠️ Breaking change: Rename metastore OpenTelemetry attributes from trino.hive.* to trino.metastore.*. (#22866)

Iceberg connector​

  • Add S3 security mapping for the native S3 filesystem. (#22559)
  • Add support for changing a column's type from tinyint or smallint to integer. (#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 to false. (#22739)
  • ⚠️ Breaking change: Rename metastore OpenTelemetry attributes from trino.hive.* to trino.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 and cosine_distance functions on vector 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)