all_match
Returns whether all elements of an array match the given predicate.
any_match
Returns whether any elements of an array match the given predicate.
array_agg
Aggregates values (including `NULL`) in a column into an array (multiple rows to one row), and optionally order the elements by specific columns.
array_append
Adds a new element to the end of the array.
array_avg
Calculates the average value of all data in an ARRAY and return this result.
array_concat
Concatenates multiple arrays into one array that contains all the elements in the arrays.
array_contains
Checks whether the array contains a certain element.
array_contains_all
Checks whether `arr1` contains all the elements of `arr2`, that is, whether `arr2` is a subset of `arr1`.
array_contains_seq
Checks whether all the elements of array2 appear in array1 in the same exact order.
array_cum_sum
Returns the cumulative sums of elements in an array.
array_difference
Calculates the difference between every two neighboring elements of an array by subtracting each element from its following element and returns an array that consists of the differences.
array_distinct
Removes duplicate elements from an array.
array_filter
Returns values from an array that matches the given filter.
array_flatten
`array_flatten` flattens one layer of nested arrays.
array_generate
Returns an array of distinct values within the range specified by `start` and `end`, with an increment of `step`.
array_intersect
Returns an array of the elements in the intersection of one or more arrays.
array_join
Concatenates the elements of an array into a string.
array_length
Returns the number of elements in an array.
array_map
array_map() is a higher-order SQL function that can take lambda functions as arguments.It applies the lambda function to the input arrays and returns a new array.
array_max
Obtains the maximum value of all data in an ARRAY and return this result.
array_min
Obtains the minimum value of all data in an ARRAY and return this result.
array_position
Obtains the position of an element in an array.
array_remove
Removes an element from an array.
array_repeat
`array_repeat` returns an array containing a given element repeated a specified number of times.
array_slice
Returns a slice of an array.
array_sort
Sorts the elements of an array in ascending order.
array_sortby
Sorts elements in an array according to the ascending order of elements in another array or array converted from a lambda expression.
array_sum
Sums all the elements in an array.
array_to_bitmap
Converts an array into BITMAP values.
array_top_n
Sorts the elements of a given array in their natural descending order, and returns the top-n elements in an array.
array_unique_agg
Aggregates distinct values (including `NULL`) in an ARRAY column into an array (from multiple rows to one row).
arrays_overlap
Checks whether the intersection of two arrays is empty.
arrays_zip
Merges the given arrays by index into an array of structs in which the n-th struct contains n-th values of all input arrays.
cardinality
Returns the number of elements in an array.
element_at
Returns the element at the specified position (index) from a given array.
reverse
Reverses a string or array.
unnest
UNNEST is a table function that takes an array and converts elements in that array into multiple rows of a table.