Release 0.214

    • Fix memory leak related to query tracking in coordinator that was introduced in Release 0.213.

    • Fix planning failures when lambdas are used in join filter expression.

    • Improve error message when an invalid comparator is provided to the function.

    • Improve performance of lookup operations on map data types.

    • Fix issue where queries containing distributed ORDER BY and aggregation could sometimes fail to make progress when data was spilled.

    • Make top N row number optimization work in some cases when columns are pruned.

    • Add session property and configuration property optimizer.optimize-top-n-row-number to toggle the top N row number optimization.

    • Add ngrams() function to generate N-grams from an array.

    • Add type and associated Quantile Digest Functions.

    Security Changes

    • Add functionality to refresh the configuration of file-based access controllers. The refresh interval can be set using the security.refresh-period configuration property.
    • Clear update count after calling Statement.getMoreResults().

    Web UI Changes

    • Show query warnings on the query detail page.

    • Allow selecting non-default sort orders in query list view.

    • Prevent ORC writer from writing stripes larger than the maximum configured size.

    • Add hive.s3.upload-acl-type configuration property to specify the type of ACL to use while uploading files to S3.

    • Add support for retrying on metastore connection errors.

    Verifier Changes

    • Handle SQL execution timeouts while rewriting queries.