Release 0.174#
General#
Fix correctness issue for correlated subqueries containing a
LIMIT
clause.Fix query failure when
reduce()
function is used with lambda expressions containingarray_sort()
,shuffle()
,reverse()
,array_intersect()
,arrays_overlap()
,concat()
(for arrays) ormap_concat()
.Fix a bug that causes underestimation of the amount of memory used by
max_by()
,min_by()
,max()
,min()
, andarbitrary()
aggregations over varchar/varbinary columns.Fix a memory leak in the coordinator that causes long-running queries in highly loaded clusters to consume unnecessary memory.
Improve performance of aggregate window functions.
Improve parallelism of queries involving
GROUPING SETS
,CUBE
orROLLUP
.Improve parallelism of
UNION
queries.Filter and projection operations are now always processed columnar if possible, and Presto will automatically take advantage of dictionary encodings where effective. The
processing_optimization
session property andoptimizer.processing-optimization
configuration option have been removed.Add support for escaped unicode sequences in string literals.
Add SHOW GRANTS and
information_schema.table_privileges
table.
Hive#
Change default value of
hive.metastore-cache-ttl
andhive.metastore-refresh-interval
to 0 to disable cross-transaction metadata caching.
Web UI#
Fix ES6 compatibility issue with older browsers.
Display buffered bytes for every stage in the live plan UI.
SPI#
Add support for retrieving table grants.
Rename SPI access control check from
checkCanShowTables
tocheckCanShowTablesMetadata
, which is used for both SHOW TABLES and SHOW GRANTS.