Skip to main content

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)