Release 0.202

    • Fix map() to raise an error on duplicate keys rather than silently producing a corrupted map.

    • Fix to raise an error when input array contains a 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 line_locate_point(), , and geometry_invalid_reason() functions to not return values outside of the expected range.

    • Fix query failure in aggregation spilling ().

    • Remove support for SHOW PARTITIONS statement.

    • 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 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 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 .

    • 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 bing_tiles_around(), , ST_GeometryN(), and geospatial functions.

    • Add wilson_interval_lower() and functions.

    • Add IS DISTINCT FROM for json and ipaddress 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 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.

    • Make and PageIndexer supported interfaces.