ARRAY Functions

All functions in the ARRAY category.

Function	Description
`ALL_FUNC`	Returns true if all elements in the boolean array are true.
`ANY_FUNC`	Returns true if any element in the boolean array is true.
`ARRAYS_OVERLAP`	Returns true if any elements are common between the two arrays.
`ARRAY_AVG`	Returns the arithmetic mean (average) of all numeric elements in an array.
`ARRAY_CONCAT_FUNC`	Concatenates multiple arrays into a single combined array with optional deduplication.
`ARRAY_DISTINCT`	Returns an array with distinct elements, sorted in ascending order.
`ARRAY_EXCEPT`	Returns the difference of two arrays using set semantics.
`ARRAY_HISTOGRAM`	Returns a frequency histogram of values in an array as an array of value-count pairs.
`ARRAY_INTERSECT`	Returns the intersection of two arrays using set semantics.
`ARRAY_JOIN`	Joins the elements of an array into a single string using a specified delimiter.
`ARRAY_LOOKUP`	Returns the value corresponding to a lookup key using parallel key-value arrays.
`ARRAY_MAX`	Returns the largest value in an array using natural ordering.
`ARRAY_MIN`	Returns the smallest value in an array using natural ordering.
`ARRAY_NOT`	Returns an array with inverted boolean values (logical NOT applied to each element).
`ARRAY_POSITION`	Returns the 1-based position of the first occurrence of an element in an array.
`ARRAY_REMOVE`	Returns an array with all occurrences of the specified element removed.
`ARRAY_REVERSE`	Returns the reverse of an array.
`ARRAY_SORT`	Returns the sorted version of an array.
`ARRAY_SUM`	Returns the sum of all numeric elements in an array.
`ARRAY_UNION`	Returns the union of two arrays, eliminating duplicate elements.
`ARRAY_UNIQUE`	Returns an array with unique elements, removing all duplicates.
`CARDINALITY`	Returns the number of elements in an array.
`CONTAINS`	Returns true if the array contains the specified element.
`CONTAINS_SEQUENCE`	Returns true if the array contains the specified sequence as a contiguous subsequence.
`COSINE_SIMILARITY`	Calculates the cosine similarity between two arrays.
`DOT_PRODUCT`	Calculates the dot product of two arrays.
`ELEMENTS_AT_KEY`	Returns multiple elements at the given key from the given index, array or array of rows.
`ELEMENTS_AT_POS`	Returns the elements at multiple specified positions in an array.
`ELEMENT_AT_KEY`	Returns one element at the given key from the given index, array or array of rows.
`ELEMENT_AT_POS`	Returns the element at the specified position in an array.
`EUCLIDEAN_DISTANCE`	Calculates the Euclidean distance between two arrays.
`FLATTEN_FUNC`	Flattens a nested array structure into a single-level array.
`NONE_FUNC`	Returns true if no elements in the boolean array are true.
`NORMALIZE`	Normalizes a numeric array by dividing each element by the sum of all elements.
`REPEAT`	Creates an array by repeating an element a specified number of times.
`SEQUENCE`	Generates an array containing a sequence of numbers from start to stop with optional step.
`SLICE`	Returns a slice of an array with optional step parameter.
`SLICE_END`	Returns a slice of an array using SQL-like start:end:step semantics.

Summary

Functions in ARRAY: 38

This documentation is automatically generated from the FeatureMesh registry.

Suggest changes to this page

Last update at: 2025/10/13 10:23:46