Release 412 (5 Apr 2023)#

General#

  • Add support for aggregate functions and parameters as arguments for the json_object() and json_array() functions. (#16489, #16523, #16525)

  • Expose optimizer rule execution statistics in query statistics. The number of rules for which statistics are collected can be limited with the query.reported-rule-stats-limit configuration property. (#2578)

  • Add the exclude_columns() table function. (#16584)

  • Allow disabling the use of the cost-based optimizer to determine partitioning of a stage with the optimizer.use-cost-based-partitioningconfiguration property or the use_cost_based_partitioning session property. (#16781)

  • Improve performance of queries involving table functions with table arguments. (#16012)

  • Improve latency for small queries when fault-tolerant execution is enabled. (#16103)

  • Fix failure when querying a nested field of a row type in queries involving ORDER BY ... LIMIT. (#16768)

JDBC driver#

  • Allow configuring a custom DNS resolver. (#16647)

ClickHouse connector#

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to ClickHouse. (#16452)

Delta Lake connector#

  • Add support for arithmetic binary expressions in table check constraints. (#16721)

  • Improve performance of queries that only read partition columns. (#16788)

Hive connector#

  • Fix query failure when bucketing or sorting column names are registered in a metastore in uppercase. (#16796)

  • Fix query failure when reading transactional tables with locations containing hidden directories. (#16773)

Iceberg connector#

  • Fix incorrect results for the migrate procedure when the table location contains a hidden directory. (#16779)

Ignite connector#

  • Add support for ALTER TABLE ... ADD COLUMN. (#16755)

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation to Ignite. (#16452)

MariaDB connector#

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to MariaDB. (#16452)

MySQL connector#

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to MySQL. (#16452)

Oracle connector#

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to Oracle. (#16452)

PostgreSQL connector#

  • Add support for table comments. (#16135)

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to PostgreSQL. (#16452)

Redshift connector#

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to Redshift. (#16452)

SQL Server connector#

  • Improve performance of queries involving sum(DISTINCT ...) by pushing computation down to SQL Server. (#16452)

SPI#

  • Allow table functions to return anonymous columns. (#16584)