=============
Release 0.164
=============

General Changes
---------------

* Fix correctness issue for queries that perform ``DISTINCT`` and ``LIMIT`` on the results of a ``JOIN``.
* Fix correctness issue when casting between maps where the key or value is the ``REAL`` type.
* Fix correctness issue in :func:`min_by` and :func:`max_by` when nulls are present in the comparison column.
* Fail queries when ``FILTER`` clause is specified for scalar functions.
* Fix planning failure for certain correlated subqueries that contain aggregations.
* Fix planning failure when arguments to selective aggregates are derived from other selective aggregates.
* Fix boolean expression optimization bug that can cause long planning times, planning failures and coordinator instability.
* Fix query failure when ``TRY`` or lambda expression with the exact same body is repeated in an expression.
* Fix split source resource leak in coordinator that can occur when a query fails.
* Improve :func:`array_join` performance.
* Improve error message for map subscript operator when key is not present in the map.
* Improve client error message for invalid session.
* Add ``VALIDATE`` mode for :doc:`/sql/explain`.

Web UI Changes
--------------

* Add resource group to query detail page.

Hive Changes
------------

* Fix handling of ORC files containing extremely large metadata.
* Fix failure when creating views in file based metastore.
* Improve performance for queries that read bucketed tables by optimizing scheduling.