CARDINALITY
Learn how to use the CARDINALITY map function in PlaidCloud Lakehouse. Returns the number of key-value pairs in a map - see syntax, examples, and output.
Map Functions
This section provides reference information for the map functions in PlaidCloud Lakehouse.
DISTINCT_MAP_KEYS
Learn how to use the DISTINCT_MAP_KEYS map function in PlaidCloud Lakehouse. Returns the distinct keys from a map - see syntax, examples, and output.
ELEMENT_AT
Learn how to use the ELEMENT_AT map function in PlaidCloud Lakehouse. Returns the value associated with a specified key in a map - with syntax and examples.
MAP_APPLY
Learn how to use the MAP_APPLY map function in PlaidCloud Lakehouse. Applies a lambda expression to each key-value pair in a map - with syntax and examples.
MAP_CONCAT
Learn how to use the MAP_CONCAT map function in PlaidCloud Lakehouse. Concatenates multiple maps into a single map - see syntax, examples, and output.
MAP_FILTER
Learn how to use the MAP_FILTER map function in PlaidCloud Lakehouse. Filters key-value pairs in a map using a lambda expression - with syntax and examples.
MAP_FROM_ARRAYS
Learn how to use the MAP_FROM_ARRAYS map function in PlaidCloud Lakehouse. Creates a map from an array of keys and an array of values.
MAP_KEYS
Learn how to use the MAP_KEYS map function in PlaidCloud Lakehouse. Returns all keys from a map as an array - see syntax, examples, and output.
MAP_SIZE
Learn how to use the MAP_SIZE map function in PlaidCloud Lakehouse. Returns the number of key-value pairs in a map - see syntax, examples, and output.
MAP_VALUES
Learn how to use the MAP_VALUES map function in PlaidCloud Lakehouse. Returns all values from a map as an array - see syntax, examples, and output.
TRANSFORM_KEYS
Learn how to use the TRANSFORM_KEYS map function in PlaidCloud Lakehouse. Applies a lambda expression to transform the keys of a map - with syntax and examples.
TRANSFORM_VALUES
Learn how to use the TRANSFORM_VALUES map function in PlaidCloud Lakehouse. Applies a lambda expression to transform the values of a map.