23.31. Release 0.171

General Changes

  • Fix planning regression for queries that compute a mix of distinct and non-distinct aggregations.
  • Fix casting from certain complex types to JSON when source type contains JSON or DECIMAL.
  • Fix issue for data definition queries that prevented firing completion events or purging them from the coordinator’s memory.
  • Add support for capture in lambda expressions.
  • Add support for ARRAY and ROW type as the compared value in min_by() and max_by().
  • Add support for CHAR(n) data type to common string functions.
  • Add codepoint(), skewness() and kurtosis() functions.
  • Improve validation of resource group configuration.
  • Fail queries when casting unsupported types to JSON; see JSON Functions and Operators for supported types.

Web UI Changes

  • Fix the threads UI (/ui/thread).

Hive Changes

  • Fix issue where some files are not deleted on cancellation of INSERT or CREATE queries.
  • Allow writing to non-managed (external) Hive tables. This is disabled by default but can be enabled via the hive.non-managed-table-writes-enabled configuration option.