Release 447 (8 May 2024)#

General#

Add support for SHOW CREATE FUNCTION. (#21809)
Add support for the bitwise_xor_agg() aggregation function. (#21436)
⚠️ Breaking change: Require JDK 22 to run Trino, including updated JVM config.(#20980)
Improve performance of ORDER BY queries with LIMIT on large data sets. (#21761)
Improve performance of queries containing the rank() or row_number() window functions. (#21639)
Improve performance of correlated queries with EXISTS. (#21422)
Fix potential failure for expressions involving try_cast(parse_json(...)). (#21877)

Fix incorrect error location markers for SQL routines causing CLI to print exceptions. (#21357)

Add support for concurrent DELETE and TRUNCATE queries. (#18521)
Fix under-accounting of memory usage when writing strings to Parquet files. (#21745)

Add support for metastore caching on tables that have not been analyzed, which can be enabled with the hive.metastore-cache.cache-missing-stats and hive.metastore-cache.cache-missing-partitions configuration properties. (#21822)
Fix under-accounting of memory usage when writing strings to Parquet files. (#21745)
Fix failure when translating Hive views that contain EXISTS clauses. (#21829)

Fix under-accounting of memory usage when writing strings to Parquet files. (#21745)

Fix under-accounting of memory usage when writing strings to Parquet files. (#21745)

⚠️ Breaking change: Remove support for Phoenix versions 5.1.x and earlier. (#21569)

Add support for specifying an explicit broker URL with the pinot.broker-url configuration property. (#17791)

⚠️ Breaking change: Remove deprecated legacy type mapping and the associated redshift.use-legacy-type-mapping configuration property. (#21855)