# Release 383 (1 June 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#

• 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)

• 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)