ARRAY_AGGREGATE
Learn how to use the ARRAY_AGGREGATE array function in PlaidCloud Lakehouse. Aggregates elements in the array with an aggregate function. Includes syntax...
Array Functions
This section provides reference information for the array functions in PlaidCloud Lakehouse.
ARRAY_APPEND
Learn how to use the ARRAY_APPEND array function in PlaidCloud Lakehouse. Prepends an element to the array. Full syntax and usage reference.
ARRAY_APPLY
Learn how to use ARRAY_APPLY in PlaidCloud Lakehouse. Alias for the ARRAY_TRANSFORM array function. Includes detailed syntax, examples, and usage reference.
ARRAY_CONCAT
Learn how to use the ARRAY_CONCAT array function in PlaidCloud Lakehouse. Concats two arrays. Includes detailed syntax, examples, and usage reference.
ARRAY_CONTAINS
Learn how to use ARRAY_CONTAINS in PlaidCloud Lakehouse. Alias for the CONTAINS array function. Includes detailed syntax, examples, and usage reference.
ARRAY_DISTINCT
Learn how to use the ARRAY_DISTINCT array function in PlaidCloud Lakehouse. Removes all duplicates and NULLs from the array without preserving the original...
ARRAY_FILTER
Learn how to use the ARRAY_FILTER array function in PlaidCloud Lakehouse. Constructs an array from those elements of the input array for which the lambda...
ARRAY_FLATTEN
Learn how to use the ARRAY_FLATTEN array function in PlaidCloud Lakehouse. Flattens nested arrays, converting them into a single-level array.
ARRAY_GET
Learn how to use ARRAY_GET in PlaidCloud Lakehouse. Alias for the GET array function. Includes detailed syntax, examples, and usage reference.
ARRAY_INDEXOF
Learn how to use the ARRAY_INDEXOF array function in PlaidCloud Lakehouse. Returns the index(1-based) of an element if the array contains the element.
ARRAY_LENGTH
Learn how to use the ARRAY_LENGTH array function in PlaidCloud Lakehouse. Returns the length of an array. Includes usage and syntax details.
ARRAY_PREPEND
Learn how to use the ARRAY_PREPEND array function in PlaidCloud Lakehouse. Prepends an element to the array. Full syntax and usage reference.
ARRAY_REDUCE
Learn how to use the ARRAY_REDUCE array function in PlaidCloud Lakehouse. Applies iteratively the lambda function to the elements of the array, so as to...
ARRAY_REMOVE_FIRST
Learn how to use the ARRAY_REMOVE_FIRST array function in PlaidCloud Lakehouse. Removes the first element from the array. Includes syntax and examples.
ARRAY_REMOVE_LAST
Learn how to use the ARRAY_REMOVE_LAST array function in PlaidCloud Lakehouse. Removes the last element from the array. Includes syntax and examples.
ARRAY_SIZE
Learn how to use ARRAY_SIZE in PlaidCloud Lakehouse. Alias for the ARRAY_LENGTH array function. Includes detailed syntax, examples, and usage reference.
ARRAY_SLICE
Learn how to use ARRAY_SLICE in PlaidCloud Lakehouse. Alias for the SLICE array function. Includes detailed syntax, examples, and usage reference.
ARRAY_SORT
Learn how to use the ARRAY_SORT array function in PlaidCloud Lakehouse. Sorts elements in the array in ascending order. Includes syntax and examples.
ARRAY_TO_STRING
Learn how to use the ARRAY_TO_STRING array function in PlaidCloud Lakehouse. Concatenates elements of an array into a single string, using a specified...
ARRAY_TRANSFORM
Learn how to use the ARRAY_TRANSFORM array function in PlaidCloud Lakehouse. Returns an array that is the result of applying the lambda function to each...
ARRAY_UNIQUE
Learn how to use the ARRAY_UNIQUE array function in PlaidCloud Lakehouse. Counts unique elements in the array (except NULL). Includes syntax and examples.
ARRAYS_ZIP
Learn how to use the ARRAYS_ZIP array function in PlaidCloud Lakehouse. Merges multiple arrays into a single array tuple. Includes syntax and examples.
CONTAINS
Learn how to use the CONTAINS array function in PlaidCloud Lakehouse. Checks if the array contains a specific element. Includes syntax and examples.
GET
Learn how to use the GET array function in PlaidCloud Lakehouse. Returns an element from an array by index (1-based). Includes syntax and examples.
RANGE
Learn how to use the RANGE array function in PlaidCloud Lakehouse. Returns an array collected by [start, end). Includes syntax and examples.
SLICE
Learn how to use the SLICE array function in PlaidCloud Lakehouse. Extracts a slice from the array by index (1-based). Includes syntax and examples.
UNNEST
Learn how to use the UNNEST array function in PlaidCloud Lakehouse. Unnests the array and returns the set of elements. Includes syntax and examples.