Release 419 (5 Jun 2023)#

General#

Add the array_histogram() function to find the number of occurrences of the unique elements in an array. (#14725)
Improve planning performance for queries involving joins. (#17458)
Fix query failure when the server JSON response exceeds the 5MB limit for string values. (#17557)

Allow uppercase or mixed case values for the web-ui.authentication.type configuration property. (#17334)

Support the id and name mapping modes when adding new columns. (#17236)
Improve performance of reading Parquet files. (#17612)
Improve performance when writing Parquet files with structural data types. (#17665)
Properly display the schema, table name, and location of tables being inserted into in the output of EXPLAIN queries. (#17590)
Fix query failure when writing to a file location with a trailing / in its name. (#17552)

Add support for reading ORC files with shorthand timezone ids in the Stripe footer metadata. You can set the hive.orc.read-legacy-short-zone-id configuration property to true to enable this behavior. (#12303)
Improve performance of reading ORC files with Bloom filter indexes. (#17530)
Improve performance of reading Parquet files. (#17612)
Improve optimized Parquet writer performance for structural data types. (#17665)
Fix query failure for tables with file paths that contain non-alphanumeric characters. (#17621)

Improve performance of reading Parquet files. (#17612)
Improve performance when writing Parquet files with structural data types. (#17665)

Add support for the Nessie catalog. (#11701)
Disallow use of the migrate table procedure on Hive tables with array, map and row types. Previously, this returned incorrect results after the migration. (#17587)
Improve performance of reading ORC files with Bloom filter indexes. (#17530)
Improve performance of reading Parquet files. (#17612)
Improve performance when writing Parquet files with structural data types. (#17665)
Improve performance of reading table statistics. (#16745)