Release 445 (17 Apr 2024)#
General#
- Add support for large constant arrays. (#21566) 
- Add the - query.dispatcher-query-pool-sizeconfiguration property to prevent the coordinator from hanging when too many queries are being executed at once. (#20817)
- Improve performance of queries selecting only catalog, schema, and name from the - system.metadata.materialized_viewstable. (#21448)
- ⚠️ Remove the deprecated - legacy.materialized-view-grace-periodconfiguration property. (#21474)
- Increase the number of columns supported by - MERGEqueries before failing with a- MethodTooLargeExceptionerror. (#21299)
- Fix potential query hang when there is an error processing data. (#21397) 
- Fix possible worker crashes when running aggregation queries due to out-of-memory error. (#21425) 
- Fix incorrect results when performing aggregations over null values. (#21457) 
- Fix failure for queries containing expressions involving types that do not support the - =operator (e.g.,- HyperLogLog,- Geometry, etc.). (#21508)
- Fix incorrect results for distinct count aggregations over a constant value. (#18562) 
- Fix sporadic query failure when filesystem caching is enabled. (#21342) 
- Fix unexpected failure for join queries containing predicates that might raise an error for some inputs. (#21521) 
BigQuery connector#
Delta Lake connector#
- Add support for time travel queries. (#21052) 
- Add support for the - REPLACEmodifier as part of a- CREATE TABLEstatement. (#13180) (#19991)
Hive connector#
- Add support for creating views with custom properties. (#21401) 
- Add support for writing Bloom filters in Parquet files. (#20662) 
- ⚠️ Remove the deprecated - PARTITION_COLUMNand- PARTITION_VALUEarguments from the- flush_metadata_cacheprocedure in favor of- PARTITION_COLUMNSand- PARTITION_VALUES. (#21410)
Iceberg connector#
- Deprecate the - iceberg.materialized-views.hide-storage-tableconfiguration property. (#21485)
MongoDB connector#
- Add support for dynamic filtering. (#21355) 
MySQL connector#
- Improve performance of queries with - timestamp(n)values. (#21244)
PostgreSQL connector#
- Improve performance of queries with - timestamp(n)values. (#21244)
Redis connector#
- Upgrade minimum required Redis version to 5.0.14 or later. (#21455) 
Snowflake connector#
- Add support for pushing down execution of the - variance,- var_pop,- var_samp,- covar_pop,- covar_samp,- corr,- regr_intercept, and- regr_slopefunctions to the underlying database. (#21384)