ποΈ 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
Returns the average of all elements in an ARRAY, ignoring NULL values.
ποΈ 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...
ποΈ 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_max
Returns the maximum value among all elements in an ARRAY.
ποΈ array_min
Returns the minimum value among all elements in an ARRAY.
ποΈ 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.
