Release 0.164#
General#
- Fix correctness issue for queries that perform - DISTINCTand- LIMITon the results of a- JOIN.
- Fix correctness issue when casting between maps where the key or value is the - REALtype.
- Fix correctness issue in - min_by()and- max_by()when nulls are present in the comparison column.
- Fail queries when - FILTERclause 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 - TRYor 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 - 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 - VALIDATEmode for EXPLAIN.
Web UI#
- Add resource group to query detail page. 
Hive#
- 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.