12.96. 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 Changes#
- Fix potential correctness issue in queries that contain correlated scalar aggregation subqueries.
- Fix query failure when using
AT TIME ZONEinVALUESlist. - Add support for quantified comparison predicates:
ALL,ANY, andSOME. - Add support for ARRAY and ROW that contain
NULLinchecksum()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 theoptimizer.optimize-mixed-distinct-aggregationsconfiguration option or via theoptimize_mixed_distinct_aggregationssession property. - Change default task concurrency to 16.
Hive Changes#
- Add support for legacy RCFile header version in new RCFile reader.
Redis Changes#
- Support
iso8601data format for thehashrow decoder.
SPI Changes#
- 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.