11.75. Release 0.156

Warning

Query may incorrectly produce NULL when no row qualifies for the aggregationif the optimize_mixed_distinct_aggregations session property orthe 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 in VALUES list.
  • 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 BY queries that compute a mix of distinctand non-distinct aggregations. This optimization can be turned on by settingthe optimizer.optimize-mixed-distinct-aggregations configuration option orvia the optimize_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 the hash 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 codebefore deploying this release.