presto-docs/src/main/sphinx/release/release-0.201.rst
IS NOT DISTINCT FROM semantics rather than equality
semantics. This fixes incorrect results and degraded performance when grouping on NaN
floating point values, and adds support for grouping on structural types that contain nulls.ORDER BY query.deprecated.legacy-system-pool-enabled config option.!row_number followed by a
filter on the row numbers generated.ORDER BY followed by a LIMIT.prefer-partial-aggregation to allow users to disable partial
aggregations for queries that do not benefit.current_user (see :doc:/functions/session)./security/built-in-system-access-control for enforcing matches
between authentication credentials and a chosen username to allow more fine-grained
control and ability to define superuser-like credentials.hive.orc.writer.stripe-min-rows
with stripe minimum data size hive.orc.writer.stripe-min-size.hive.orc.writer.validate to switch to a
sampling percentage hive.orc.writer.validation-percentage.map or array.SHOW PARTITIONS and the $partitions table for tables that have null partition
values.