12.62. Release 0.174

General Changes

  • Fix correctness issue for correlated subqueries containing a LIMIT clause.
  • Fix query failure when reduce() function is used with lambda expressionscontaining array_sort(), shuffle(), reverse(), array_intersect(),arrays_overlap(), concat() (for arrays) or map_concat().
  • Fix a bug that causes underestimation of the amount of memory used by max_by(),min_by(), max(), min(), and arbitrary() aggregations overvarchar/varbinary columns.
  • Fix a memory leak in the coordinator that causes long-running queries in highly loadedclusters to consume unnecessary memory.
  • Improve performance of aggregate window functions.
  • Improve parallelism of queries involving GROUPING SETS, CUBE or ROLLUP.
  • Improve parallelism of UNION queries.
  • Filter and projection operations are now always processed columnar if possible, and Prestowill automatically take advantage of dictionary encodings where effective.The processing_optimization session property and optimizer.processing-optimizationconfiguration option have been removed.
  • Add support for escaped unicode sequences in string literals.
  • Add SHOW GRANTS and information_schema.table_privileges table.

Hive Changes

  • Change default value of hive.metastore-cache-ttl and hive.metastore-refresh-interval to 0to disable cross-transaction metadata caching.

Web UI changes

  • Fix ES6 compatibility issue with older browsers.
  • Display buffered bytes for every stage in the live plan UI.

SPI changes

  • Add support for retrieving table grants.
  • Rename SPI access control check from checkCanShowTables to checkCanShowTablesMetadata,which is used for both SHOW TABLES and SHOW GRANTS.