Array Functions (Lakehouse v2)
This section provides reference information for the array functions in PlaidCloud Lakehouse.
Functions
Section titled “Functions”- ALL_MATCH
- ANY_MATCH
- ARRAY_AGG
- ARRAY_APPEND
- ARRAY_AVG
- ARRAY_CONCAT
- ARRAY_CONTAINS_ALL
- ARRAY_CONTAINS_SEQ
- ARRAY_CONTAINS
- ARRAY_CUM_SUM
- ARRAY_DIFFERENCE
- ARRAY_DISTINCT
- ARRAY_FILTER
- ARRAY_FLATTEN
- ARRAY_GENERATE
- ARRAY_INTERSECT
- ARRAY_JOIN
- ARRAY_LENGTH
- ARRAY_MAP
- ARRAY_MAX
- ARRAY_MIN
- ARRAY_POSITION
- ARRAY_REMOVE
- ARRAY_REPEAT
- ARRAY_SLICE
- ARRAY_SORT
- ARRAY_SORTBY
- ARRAY_SUM
- ARRAY_TO_BITMAP
- ARRAY_TOP_N
- ARRAY_UNIQUE_AGG
- ARRAYS_OVERLAP
- ARRAYS_ZIP
- CARDINALITY
- ELEMENT_AT
- REVERSE
- UNNEST