Map Functions

This section provides reference information for the map functions in PlaidCloud Lakehouse.


MAP_CAT

Learn how to use the MAP_CAT map function in PlaidCloud Lakehouse. Returns the concatenatation of two MAPs. Full syntax and usage reference.

MAP_CONTAINS_KEY

Learn how to use the MAP_CONTAINS_KEY map function in PlaidCloud Lakehouse. Determines whether the specified MAP contains the specified key.

MAP_DELETE

Learn how to use the MAP_DELETE map function in PlaidCloud Lakehouse. Returns an existing MAP with one or more keys removed. Includes syntax and examples.

MAP_FILTER

Learn how to use the MAP_FILTER map function in PlaidCloud Lakehouse. Filters key-value pairs from a map using a lambda expression to define the condition.

MAP_INSERT

Learn how to use the MAP_INSERT map function in PlaidCloud Lakehouse. Returns a new MAP consisting of the input MAP with a new key-value pair inserted (an...

MAP_KEYS

Learn how to use the MAP_KEYS map function in PlaidCloud Lakehouse. Returns the keys in a map. Includes detailed syntax, examples, and usage reference.

MAP_PICK

Learn how to use the MAP_PICK map function in PlaidCloud Lakehouse. Returns a new MAP containing the specified key-value pairs from an existing MAP.

MAP_SIZE

Learn how to use the MAP_SIZE map function in PlaidCloud Lakehouse. Returns the size of a MAP. Includes detailed syntax, examples, and usage reference.

MAP_TRANSFORM_KEYS

Learn how to use the MAP_TRANSFORM_KEYS map function in PlaidCloud Lakehouse. Applies a transformation to each key in a map using a lambda expression.

MAP_TRANSFORM_VALUES

Learn how to use the MAP_TRANSFORM_VALUES map function in PlaidCloud Lakehouse. Applies a transformation to each value in a map using a lambda expression.

MAP_VALUES

Learn how to use the MAP_VALUES map function in PlaidCloud Lakehouse. Returns the values in a map. Includes detailed syntax, examples, and usage reference.