Release 450 (19 Jun 2024)#

General#

  • Add support for specifying an Azure blob endpoint for accessing spooling in fault-tolerant execution with the exchange.azure.endpoint configuration property. (#22218)

  • Expose driver execution statistics via JMX. (#22427)

  • Improve performance of the first_value() and last_value() functions. (#22092)

  • Improve performance for large clusters under heavy workloads. (#22039)

  • Improve performance of queries with simple predicates. This optimization can be disabled using the experimental.columnar-filter-evaluation.enabled configuration property or the columnar_filter_evaluation_enabled session property. (#21375)

  • ⚠️ Breaking change: Improve performance of aggregations containing a DISTINCT clause, and replace the optimizer.mark-distinct-strategy and optimizer.optimize-mixed-distinct-aggregations configuration properties with the new optimizer.distinct-aggregations-strategy property. (#21907)

  • Improve performance of reading JSON files. (#22348)

  • Improve performance for the date_trunc(), date_add(), and date_diff() functions. (#22192)

  • Fix failure when loading the OpenLineage event listener. (#22228)

  • Fix potential incorrect results when metadata or table data in certain connectors is updated or deleted. (#22285)

Security#

  • Add support for using web identity exclusively for authentication when running on Amazon EKS with the legacy S3 file system enabled. This can be configured via the trino.s3.use-web-identity-token-credentials-provider property. (#22162)

  • Add support for exclusively using web identity for authentication when using Amazon EKS with IAM roles by setting the s3.use-web-identity-token-credentials-provider configuration property. (#22163)

JDBC driver#

  • Add support for the assumeNullCatalogMeansCurrent connection property. When enabled, a null value for the catalog parameter in DatabaseMetaData methods is assumed to mean the current catalog. If no current catalog is set, the behaviour is unmodified. (#20866)

BigQuery connector#

  • Add support for metadata caching when the bigquery.case-insensitive-name-matching configuration property is enabled. (#10740)

  • ⚠️ Breaking change: Automatically configure BigQuery scan parallelism, and remove the bigquery.parallelism configuration property. (#22279)

Cassandra connector#

  • Fix incorrect results when specifying a value for the cassandra.partition-size-for-batch-select configuration property. (#21940)

ClickHouse connector#

  • Improve performance of ORDER BY ... LIMIT on non-textual types by pushing execution down to the underlying database. (#22174)

Delta Lake connector#

  • Add support for concurrent UPDATE, MERGE, and DELETE queries. (#21727)

  • Add support for using table statistics with TIMESTAMP types. (#21878)

  • Add support for reading tables with type widening. (#21756)

  • Set the default value for the s3.max-connections configuration property to 500. (#22209)

  • Fix failure when reading a TIMESTAMP value after the year 9999. (#22184)

  • Fix failure when reading tables with the unsupported variant type. (#22310)

  • Add support for reading UniForm tables. (#22106)

Hive connector#

  • Add support for changing a column’s type from integer to varchar and decimal to varchar, respectively, in unpartitioned tables. (#22246, #22293)

  • Add support for changing a column’s type from double to varchar in unpartitioned tables using Parquet files. (#22277)

  • Add support for changing a column’s type from float to varchar. (#22291)

  • Set the default value for the s3.max-connections configuration property to 500. (#22209)

Hudi connector#

  • Set the default value for the s3.max-connections configuration property to 500. (#22209)

Iceberg connector#

  • Add support for the TRUNCATE statement. (#22340)

  • ⚠️ Breaking change: Add support for V2 of the Nessie REST API. Previous behavior can be restored by setting the iceberg.nessie-catalog.client-api-version configuration property to V1. (#22215)

  • Improve performance when reading by populating split_offsets in file metadata. (#9018)

  • Set the default value for the s3.max-connections configuration property to 500. (#22209)

  • Fix failure when reading Parquet files that don’t have field-id on structured types. (#22347)

MariaDB connector#

Memory connector#

  • Add support for the TRUNCATE statement. (#22337)

MySQL connector#

  • Improve performance of listing table columns. (#22241)

Pinot connector#

Redshift connector#

  • Improve performance of listing table columns. (#22241)

SingleStore connector#

  • Improve performance of listing table columns. (#22241)