Release 0.86#
General#
- Add support for inequality - INNER JOINwhen each term of the condition refers to only one side of the join.
- Add - ntile()function.
- Add - map()function to create a map from arrays of keys and values.
- Add - min_by()aggregation function.
- Add support for concatenating arrays with the - ||operator.
- Add support for - =and- !=to- JSONtype.
- Improve error message when - DISTINCTis applied to types that are not comparable.
- Perform type validation for - INexpression where the right-hand side is a subquery expression.
- Improve error message when - ORDER BY ... LIMITquery exceeds its maximum memory allocation.
- Improve error message when types that are not orderable are used in an - ORDER BYclause.
- Improve error message when the types of the columns for subqueries of a - UNIONquery don’t match.
- Fix a regression where queries could be expired too soon on a highly loaded cluster. 
- Fix scheduling issue for queries involving tables from information_schema, which could result in inconsistent metadata. 
- Fix an issue with - min_by()and- max_by()that could result in an error when used with a variable-length type (e.g.,- VARCHAR) in a- GROUP BYquery.
- Fix rendering of array attributes in JMX connector. 
- Input rows/bytes are now tracked properly for - JOINqueries.
- Fix case-sensitivity issue when resolving names of constant table expressions. 
- Fix unnesting arrays and maps that contain the - ROWtype.