map_concat function

Applies to: Databricks SQL Databricks Runtime

Returns the union of all expr map expressions.

Syntax

map_concat([ expr1 [, ...] ])

Arguments

• exprN: A MAP expression. All exprN must share a least common type.

Returns

A MAP of the least common type of exprN.

If no argument is provided, an empty map.

Azure Databricks raises DUPLICATED_MAP_KEY if there is a key collision across input maps.

Common error conditions

• DUPLICATED_MAP_KEY

Examples

> SELECT map_concat(map(1, 'a', 2, 'b'), map(3, 'c'));
  {1 -> a, 2 -> b, 3 -> c}

> SELECT map_concat(map(1, 'a'), map(1, 'b'));
  Error: DUPLICATED_MAP_KEY

Related

• map function
• map_entries function
• map_filter function
• map_from_arrays function
• map_from_entries function
• map_keys function
• map_values function
• map_zip_with function
• SQL data type rules