ekuiper-new/docs/en_US/sqls/functions/array_functions.md

Array Functions

Array functions manipulate arrays or return information about arrays.

CARDINALITY

cardinality(array)

The number of members in the array. The null value will return 0.

ARRAY_POSITION

array_position(array, value)

Return a 0-based index of the first occurrence of val if it is found within an array. If val does not exist within the array, it returns -1.

ELEMENT_AT

element_at(array, index)

Returns element of the array at index val. If val < 0, this function accesses elements from the last to the first.

ARRAY_CONTAINS

array_contains(array, value)

Returns true if array contains the element.

ARRAY_CREATE

array_create(value1, ......)

Construct an array from literals.

ARRAY_REMOVE

array_remove(array, value)

Returns the array with all occurrences of value removed.

ARRAY_LAST_POSITION

array_last_position(array, val)

Return a 0-based index of the last occurrence of val if it is found within the array. If val does not exist within the array, it returns -1.

ARRAY_CONTAINS_ANY

array_contains_any(array1, array2)

Returns true if array1 and array2 have any elements in common.

ARRAY_INTERSECT

array_intersect(array1, array2)

Returns an intersection of the two arrays, with all duplicates removed.

ARRAY_UNION

array_union(array1, array2)

Returns a union of the two arrays, with all duplicates removed.

ARRAY_MAX

array_max(array)

Returns an element which is greater than or equal to all other elements of the array. The null element will be ignored.

ARRAY_MIN

array_min(array)

Returns an element which is less than or equal to all other elements of the array. The null element will be ignored.

ARRAY_EXCEPT

array_except(array1, array2)

Returns an array of elements that are in array1 but not in array2, without duplicates.

REPEAT

repeat(string, count)

Constructs an array of val repeated count times.

SEQUENCE

sequence(start, stop, step)

Returns an array of integers from start to stop, incrementing by step.

ARRAY_CARDINALITY

array_cardinality(array)

Return the number of elements in the array. The null value will be ignored.

ARRAY_FLATTEN

array_flatten(array)

Return a flattened array, i.e., expand the array elements in the array.

For example, if the input is [[1, 4], [2, 3]], then the output is [1, 4, 2, 3].

ARRAY_DISTINCT

array_distinct(array)

Return a distinct array, i.e., remove the duplicate elements in the array.

ARRAY_MAP

array_map(function_name, array)

Return a new array by applying a function to each element of the array.

ARRAY_JOIN

array_join(array, delimiter, null_replacement)

Return a string that concatenates all elements of the array and uses the delimiter and an optional string to replace null values.

For example, if the input is [1, 2, 3], delimiter is set to comma, then the output is "1,2,3".

ARRAY_SHUFFLE

array_shuffle(array)

Return a shuffled array, i.e., randomly shuffle the elements in the array.

ARRAY_CONCAT

array_concat(array1, array2, ...)

Returns the concatenation of the input arrays, this function does not modify the existing arrays, but returns new one.

ARRAY_SORT

array_sort(array)

Returns a sorted copy of the input array.

array_sort([3, 2, "b", "a"])

Result:

[2, 3, "a", "b"]