Release 0.164
General Changes
- Fix correctness issue for queries that perform
DISTINCTandLIMITon the results of aJOIN. - 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 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.
