Release 0.156#
Warning
Query may incorrectly produce NULL when no row qualifies for the aggregation
if the optimize_mixed_distinct_aggregations session property or
the optimizer.optimize-mixed-distinct-aggregations config option is enabled.
General#
- Fix potential correctness issue in queries that contain correlated scalar aggregation subqueries. 
- Fix query failure when using - AT TIME ZONEin- VALUESlist.
- Add support for quantified comparison predicates: - ALL,- ANY, and- SOME.
- Add support for ARRAY and ROW that contain - NULLin- checksum()aggregation.
- Add support for filtered aggregations. Example: - SELECT sum(a) FILTER (WHERE b > 0) FROM ...
- Add a variant of - from_unixtime()function that takes a timezone argument.
- Improve performance of - GROUP BYqueries that compute a mix of distinct and non-distinct aggregations. This optimization can be turned on by setting the- optimizer.optimize-mixed-distinct-aggregationsconfiguration option or via the- optimize_mixed_distinct_aggregationssession property.
- Change default task concurrency to 16. 
Hive#
- Add support for legacy RCFile header version in new RCFile reader. 
Redis#
- Support - iso8601data format for the- hashrow decoder.
SPI#
- Make - ConnectorPageSink#finish()asynchronous.
Note
These are backwards incompatible changes with the previous SPI. If you have written a plugin, you will need to update your code before deploying this release.