v.1.1.54362New Feature

Added New Array and Collection Functions

Official CH changelog text
Added functions: arrayAny, arrayAll, hasAny, hasAll, arrayIntersect, arrayResize.
Introduced new array functions: arrayAny, arrayAll, hasAny, hasAll, arrayIntersect, and arrayResize to enhance array operations in ClickHouse.

Why it matters

These functions provide more expressive and convenient ways to perform common array operations such as checking if any or all elements match a condition, verifying the presence of elements in arrays, finding the intersection between arrays, and resizing arrays. This extends ClickHouse's capability to manipulate array data efficiently and succinctly.

How to use it

Use these new functions in your SQL queries where array manipulations are needed. For example:

SELECT arrayAny(x -> x > 5, my_array) FROM table;
SELECT arrayIntersect(array1, array2) FROM table;
SELECT arrayResize(my_array, 10) FROM table;

They can be called directly in SELECT statements or other SQL clauses as needed.
PreviousNext