13.50. Release 0.202

    • Fix correctness issue for queries involving aggregations over the result of an outer join (#10592).
    • Fix 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 as the recently finished one.
    • Fix query failure when performing a GROUP BY on json or ipaddress types.
    • Fix correctness issue in , ST_IsValid(), and functions to not return values outside of the expected range.
    • 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-sets configuration property or the 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 type matches 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 function.
    • Add bing_tiles_around(), , ST_GeometryN(), and geospatial functions.
    • Add wilson_interval_lower() and functions.
    • Add IS DISTINCT FROM for json and type.
    • Fix optimized ORC writer encoding of TIMESTAMP before 1970-01-01. Previously, the written value was off by one second.
    • Fix query failure when a Hive bucket has no splits. This commonly happens when a predicate filters some buckets out entirely.
    • Remove the hive.bucket-writing config property.
    • Add support for creating and writing bucketed sorted tables. The list of sorting columns may be specified using the sorted_by table property. Writing to sorted tables can be disabled using the hive.sorted-writing config property or the sorted_writing_enabled session property. The maximum number of temporary files for can be controlled using the hive.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_threshold session property to control the stripe/file size threshold when ORC reader decides to read multiple consecutive stripes or entire fires at once. Previously, this feature piggybacks on other properties.
    • Make PageSorter and supported interfaces.