============= Release 0.162

.. warning::

The :func:`!xxhash64` function introduced in this release will return a
varbinary instead of a bigint in the next release.

General Changes

• Fix correctness issue when the type of the value in the IN predicate does not match the type of the elements in the subquery.
• Fix correctness issue when the value on the left-hand side of an IN expression or a quantified comparison is NULL.
• Fix correctness issue when the subquery of a quantified comparison produces no rows.
• Fix correctness issue due to improper inlining of TRY arguments.
• Fix correctness issue when the right side of a JOIN produces a very large number of rows.
• Fix correctness issue for expressions with multiple nested AND and OR conditions.
• Improve performance of window functions with similar PARTITION BY clauses.
• Improve performance of certain multi-way JOINs by automatically choosing the best evaluation order. This feature is turned off by default and can be enabled via the reorder-joins config option or reorder_joins session property.
• Add :func:!xxhash64 and :func:!to_big_endian_64 functions.
• Add aggregated operator statistics to final query statistics.
• Allow specifying column comments for :doc:/sql/create-table.

Hive Changes

• Fix performance regression when querying Hive tables with large numbers of partitions.

SPI Changes

• Connectors can now return optional output metadata for write operations.
• Add ability for event listeners to get connector-specific output metadata.
• Add client-supplied payload field X-Presto-Client-Info to EventListener.