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.endpointconfiguration 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.enabledconfiguration property or the- columnar_filter_evaluation_enabledsession property. (#21375)
- ⚠️ Improve performance of aggregations containing a - DISTINCTclause, and replace the- optimizer.mark-distinct-strategyand- optimizer.optimize-mixed-distinct-aggregationsconfiguration properties with the new- optimizer.distinct-aggregations-strategyproperty. (#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-providerproperty. (#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-providerconfiguration property. (#22163)
JDBC driver#
- Add support for the - assumeNullCatalogMeansCurrentconnection property. When enabled, a- nullvalue for the- catalogparameter in- DatabaseMetaDatamethods is assumed to mean the current catalog. If no current catalog is set, the behaviour is unmodified. (#20866)
BigQuery connector#
Cassandra connector#
- Fix incorrect results when specifying a value for the - cassandra.partition-size-for-batch-selectconfiguration property. (#21940)
ClickHouse connector#
- Improve performance of - ORDER BY ... LIMITon non-textual types by pushing execution down to the underlying database. (#22174)
Delta Lake connector#
- Add support for concurrent - UPDATE,- MERGE, and- DELETEqueries. (#21727)
- Add support for using table statistics with - TIMESTAMPtypes. (#21878)
- Add support for reading tables with type widening. (#21756) 
- Set the default value for the - s3.max-connectionsconfiguration property to 500. (#22209)
- Fix failure when reading a - TIMESTAMPvalue after the year 9999. (#22184)
- Fix failure when reading tables with the unsupported - varianttype. (#22310)
Hive connector#
- Add support for changing a column’s type from - integerto- varcharand- decimalto- varchar, respectively, in unpartitioned tables. (#22246, #22293)
- Add support for changing a column’s type from - doubleto- varcharin unpartitioned tables using Parquet files. (#22277)
- Add support for changing a column’s type from - floatto- varchar. (#22291)
- Set the default value for the - s3.max-connectionsconfiguration property to 500. (#22209)
Hudi connector#
- Set the default value for the - s3.max-connectionsconfiguration property to 500. (#22209)
Iceberg connector#
- Add support for the - TRUNCATEstatement. (#22340)
- ⚠️ Add support for V2 of the Nessie REST API. Previous behavior can be restored by setting the - iceberg.nessie-catalog.client-api-versionconfiguration property to- V1. (#22215)
- Improve performance when reading by populating - split_offsetsin file metadata. (#9018)
- Set the default value for the - s3.max-connectionsconfiguration property to 500. (#22209)
- Fix failure when reading Parquet files that don’t have - field-idon structured types. (#22347)
MariaDB connector#
- Add support for fault-tolerant execution. (#22328) 
- Improve performance of listing table columns. (#22241) 
Memory connector#
- Add support for the - TRUNCATEstatement. (#22337)
MySQL connector#
- Improve performance of listing table columns. (#22241) 
Pinot connector#
- Add support for the - enableNullHandlingquery option. (#22214)
- Fix failure when using dynamic tables. (#22301) 
Redshift connector#
- Improve performance of listing table columns. (#22241) 
SingleStore connector#
- Improve performance of listing table columns. (#22241)