Release 383 (1 Jun 2022)#

Warning

This release has a regression that may cause queries to fail.

General#

  • Introduce json_exists, json_query, and json_value JSON functions. (#9081)

  • Add AWS IAM role support for exchange spooling on S3. (#12444)

  • Improve query performance by reducing worker-to-worker communication overhead. (#11289)

  • Improve performance and reduce memory usage of queries that contain aggregations. (#12336)

  • Improve performance of correlated queries involving distinct aggregations. (#12564)

Web UI#

  • Clarify format of cumulative user memory on query details page. (#12596)

Accumulo connector#

  • Fail creating a new table if a table comment is specified. Previously, the comment was ignored. (#12452)

BigQuery connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

Cassandra connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

ClickHouse connector#

  • Fix incorrect results for certain aggregation queries when aggregations are pushed down to the underlying database. (#12598)

Delta Lake connector#

  • Add support for table comments during table creation.. (#12452)

  • Fix incorrect table already exists error caused by a client timeout when creating a new table. (#12300)

  • Fail creating a new table if a column comment is specified. Previously, the comment was ignored. (#12574)

Iceberg connector#

  • Add support for v2 tables for the optimize table procedure. (#12351)

  • Rename hive.target-max-file-size to iceberg.target-max-file-size and hive.delete-schema-locations-fallback to iceberg.delete-schema-locations-fallback. (#12330)

Kudu connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

MariaDB connector#

  • Fix incorrect results for certain queries involving aggregations that are pushed down to the underlying database. (#12598)

  • Fail creating a new table if a column comment is specified. Previously, the comment was ignored. (#12574)

Memory connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

MySQL connector#

  • Fix incorrect results for certain aggregation queries when aggregations are pushed down to the underlying database. (#12598)

  • Fail creating a new table if a column comment is specified. Previously, the comment was ignored. (#12574)

Oracle connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

  • Fix incorrect results for certain aggregation queries when aggregations are pushed down to the underlying database. (#12598)

Phoenix connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

PostgreSQL connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

  • Fix incorrect results for certain aggregation queries when aggregations are pushed down to the underlying database. (#12598)

Raptor connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

Redshift connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

SingleStore (MemSQL) connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

  • Fix incorrect results for certain aggregation queries when aggregations are pushed down to the underlying database. (#12598)

SQL Server connector#

  • Fail creating a new table if a table comment or a column comment is specified. Previously, the comment was ignored. (#12452, #12574)

  • Fix incorrect results for certain aggregation queries when aggregations are pushed down to the underlying database. (#12598)

SPI#

  • Allow limiting access to functions based on whether they are scalar, aggregation, window, or table functions. (#12544)