11.28. Release 0.202

General Changes

  • Fix correctness issue for queries involving aggregations over the result of an outer join (#10592).
  • Fix map() to raise an error on duplicate keys rather than silently producing a corrupted map.
  • Fix map_from_entries() to raise an error when input array contains a null entry.
  • Fix out-of-memory error for bucketed execution by scheduling new splits on the same worker asthe recently finished one.
  • Fix query failure when performing a GROUP BY on json or ipaddress types.
  • Fix correctness issue in line_locate_point(), ST_IsValid(), and geometry_invalid_reason()functions to not return values outside of the expected range.
  • Fix failure in geometry_to_bing_tiles() and ST_NumPoints() functions whenprocessing geometry collections.
  • Fix query failure in aggregation spilling (#10587).
  • Remove support for SHOW PARTITIONS statement.
  • Improve support for correlated subqueries containing equality predicates.
  • Improve performance of correlated EXISTS subqueries.
  • Limit the number of grouping sets in a GROUP BY clause.The default limit is 2048 and can be set via the analyzer.max-grouping-setsconfiguration property or the max_grouping_sets session property.
  • Allow coercion between row types regardless of field names.Previously, a row type is coercible to another only if the field name in the source typematches the target type, or when target type has anonymous field name.
  • Increase default value for experimental.filter-and-project-min-output-page-size to 500kB.
  • Improve performance of equals operator on array(bigint) and array(double) types.
  • Respect X-Forwarded-Proto header in client protocol responses.
  • Add support for column-level access control.Connectors have not yet been updated to take advantage of this support.
  • Add support for correlated subqueries with correlated OR predicates.
  • Add multimap_from_entries() function.
  • Add bing_tiles_around(), ST_NumGeometries(), ST_GeometryN(), and ST_ConvexHull() geospatial functions.
  • Add wilson_interval_lower() and wilson_interval_upper() functions.
  • Add IS DISTINCT FROM for json and ipaddress type.

Hive Changes

  • Fix optimized ORC writer encoding of TIMESTAMP before 1970-01-01. Previously, thewritten value was off by one second.
  • Fix query failure when a Hive bucket has no splits. This commonly happens when apredicate filters some buckets out entirely.
  • Remove the hive.bucket-writing config property.
  • Add support for creating and writing bucketed sorted tables. The list ofsorting columns may be specified using the sorted_by table property.Writing to sorted tables can be disabled using the hive.sorted-writingconfig property or the sorted_writing_enabled session property. Themaximum number of temporary files for can be controlled using thehive.max-sort-files-per-bucket property.
  • Collect and store basic table statistics (rowCount, fileCount, rawDataSize,totalSize) when writing.
  • Add hive.orc.tiny-stripe-threshold config property and orc_tiny_stripe_thresholdsession property to control the stripe/file size threshold when ORC reader decides toread multiple consecutive stripes or entire fires at once. Previously, this featurepiggybacks on other properties.

CLI Changes

  • Add peak memory usage to —debug output.

SPI Changes

  • Make PageSorter and PageIndexer supported interfaces.