Allow users to create views for their own use when they do not have permission
to grant others access to the underlying tables or views. To enable this,
creation permission is now only checked at query time, not at creation time,
and the query time check is skipped if the user is the owner of the view.
Add support for ORDERBY clause in aggregations for queries that use grouping sets.
Add support for yielding when unspilling an aggregation.
Expand grouped execution support to GROUPBY and UNIONALL, making it possible
to execute aggregations with less peak memory usage.
Change the signature of round(x,d) and truncate(x,d) functions so that
d is of type INTEGER. Previously, d could be of type BIGINT.
This behavior can be restored with the deprecated.legacy-round-n-bigint config option
or the legacy_round_n_bigint session property.
Accessing anonymous row fields via .field0, .field1, etc., is no longer allowed.
This behavior can be restored with the deprecated.legacy-row-field-ordinal-access
config option or the legacy_row_field_ordinal_access session property.
Fix ORC writer failure when writing NULL values into columns of type ROW, MAP, or ARRAY.
Fix ORC writers incorrectly writing non-null values as NULL for all types.
Support reading Hive partitions that have a different bucket count than the table,
as long as the ratio is a power of two (1:2^n or 2^n:1).
Add support for the skip.header.line.count table property.
Prevent reading from tables with the skip.footer.line.count table property.
Partitioned tables now have a hidden system table that contains the partition values.
A table named example will have a partitions table named example$partitions.
This provides the same functionality and data as SHOWPARTITIONS.
Partition name listings, both via the $partitions table and using
SHOWPARTITIONS, are no longer subject to the limit defined by the
hive.max-partitions-per-scan config option.
Allow marking partitions as offline via the presto_offline partition property.