ποΈ 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.
