Release 475 (23 Apr 2025)#

General#

  • Add support for the CORRESPONDING clause in set operations. (#25260)

  • Add support for the AUTO grouping set that includes all non-aggregated columns in the SELECT clause. (#18390)

  • Publish additional metrics for input tables in event listener. (#25475)

  • Expose dynamic filter statistics in the QueryCompletedEvent. (#25575)

  • Improve scalability of inline data encoding in the spooling client protocol. (#25439)

  • Improve performance of queries involving the exclude_columns table function. (#25117)

  • Disallow dropping the system catalog. (#24745)

  • Fix occasional query failures when adaptive planning is enabled. (#25411)

  • Fix incorrect results when using window functions with DISTINCT. (#25434)

  • Fix query failures with EXCEEDED_LOCAL_MEMORY_LIMIT errors due to incorrect memory accounting. (#25600)

  • Properly handle inline session properties for EXPLAIN queries. (#25496)

Security#

  • Fix incorrect access denial for access control with impersonation when access is granted via the role. (#25166)

JDBC driver#

  • Avoid query cancellation when the client is fetching results. (#25267)

CLI#

  • Avoid query cancellation when the client is fetching results. (#25267)

Clickhouse connector#

  • Add support for Clickhouse’s bool type. (#25130)

BigQuery connector#

  • Add support for limiting the max parallelism with the bigquery.max-parallelism configuration property. (#25422)

  • Fix queries getting stuck when reading large tables. (#25423)

Delta Lake connector#

  • Allow cross-region data retrieval when using the S3 native filesystem. (#25200)

  • Add support for all storage classes when using the S3 native filesystem for writes. (#25435)

  • Improve performance when filtering on $path, $file_modified_time or $file_size columns. (#25369)

  • Improve performance of scans on Delta Lake tables with v2 checkpoints. (#25469)

Hive connector#

  • Allow cross-region data retrieval when using the S3 native filesystem. (#25200)

  • Add support for all storage classes when using the S3 native filesystem for writes. (#25435)

  • Add support for showing column comments on Hive views. (#23845)

  • Add support for multiple predicates on partition projection columns with injected types. (#17641)

  • Fix potential failures or incorrect results when querying partitioned tables using the OpenX JSON SerDe. (#25444)

  • Ensure Hive metastore locks are released if a failure occurs during lock acquisition. (#25380)

  • Rename hive.s3.storage-class-filter to hive.s3-glacier-filter to better reflect its purpose. (#25633)

  • Fix incorrect results when reading timestamp values with leading or trailing spaces using the Regex and OpenX JSON table deserializers. (#25442)

  • Fix potential performance regression when reading ORC data. (#25617)

Iceberg connector#

  • Allow cross-region data retrieval when using the S3 native filesystem. (#25200)

  • Add support for all storage classes when using the S3 native filesystem for writes. (#25435)

  • Add system.iceberg_tables system table to allow listing only Iceberg tables. (#25136)

  • Add support for IAM role authentication with the REST catalog. (#25002)

  • Fix potential failure when queries modify a table concurrently. (#25445)

  • Add support for returning column statistics for new columns in $partitions system table. (#25532)

  • Improve the optimize_manifests procedure to produce better organized manifests. (#25378)

  • Clean up old snapshots when refreshing a materialized view. (#25343)

  • Set Glue catalog ID when hive.metastore.glue.catalogid is configured. (#25511)

  • Fix failure when executing migrate on tables partitioned on columns with special characters. (#25228)

  • Fix OPTIMIZE failures due to commit conflicts with certain DELETE queries. (#25584)

  • Fix failure when analyzing a table without any snapshots. (#25563)

Memory connector#

  • Fix incorrect memory usage accounting for truncated tables. (#25564)

MySQL connector#

  • Add support for creating tables with a primary key. (#24930)

PostgreSQL connector#

  • Add support for MERGE when retry_policy is set to TASK. (#24467)

  • Add support for array(uuid) type. (#25557)

SQL Server connector#

  • Fix incorrect results for queries involving LIKE on columns with case-insensitive collations. (#25488)

SPI#

  • Remove the LazyBlock class. (#25255)