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 ZONE
inVALUES
list.Add support for quantified comparison predicates:
ALL
,ANY
, andSOME
.Add support for ARRAY and ROW that contain
NULL
inchecksum()
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 BY
queries that compute a mix of distinct and non-distinct aggregations. This optimization can be turned on by setting theoptimizer.optimize-mixed-distinct-aggregations
configuration option or via theoptimize_mixed_distinct_aggregations
session property.Change default task concurrency to 16.
Hive Changes¶
Add support for legacy RCFile header version in new RCFile reader.
Redis Changes¶
Support
iso8601
data format for thehash
row 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.