MAP_CAT

Returns the concatenatation of two MAPs.

SQL Syntax

MAP_CAT( <map1>, <map2> )

Arguments

ArgumentsDescription
<map1>The source MAP.
<map2>The MAP to be appended to map1.

:::note

  • If both map1 and map2 have a value with the same key, then the output map contains the value from map2.
  • If either argument is NULL, the function returns NULL without reporting any error. :::

Return Type

Map.

SQL Examples

SELECT MAP_CAT({'a':1,'b':2,'c':3}, {'c':5,'d':6});
┌─────────────────────────────────────────────┐
│ map_cat({'a':1,'b':2,'c':3}, {'c':5,'d':6}) │
├─────────────────────────────────────────────┤
│ {'a':1,'b':2,'c':5,'d':6}                   │
└─────────────────────────────────────────────┘