Release 447 (8 May 2024)#
General#
- Add support for SHOW CREATE FUNCTION. (#21809) 
- Add support for the - bitwise_xor_agg()aggregation function. (#21436)
- Improve performance of - ORDER BYqueries with- LIMITon 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)
CLI#
- Fix incorrect error location markers for SQL routines causing CLI to print exceptions. (#21357) 
Delta Lake connector#
Hive connector#
- Add support for metastore caching on tables that have not been analyzed, which can be enabled with the - hive.metastore-cache.cache-missing-statsand- hive.metastore-cache.cache-missing-partitionsconfiguration properties. (#21822)
- Fix under-accounting of memory usage when writing strings to Parquet files. (#21745) 
- Fix failure when translating Hive views that contain - EXISTSclauses. (#21829)
Hudi connector#
- Fix under-accounting of memory usage when writing strings to Parquet files. (#21745) 
Iceberg connector#
- Fix under-accounting of memory usage when writing strings to Parquet files. (#21745) 
Phoenix connector#
Pinot connector#
- Add support for specifying an explicit broker URL with the - pinot.broker-urlconfiguration property. (#17791)