Explode map

Supported in: Batch, Streaming

Explode map into a row per key, value pair.

Expression categories: Map

Declared arguments

• Expression - The map to explode.
  Expression<Map<TKey, TValue>>

Type variable bounds: TKey accepts AnyType**TValue accepts AnyType

Output type: Struct<Optional[key], Optional[value]>

Examples

Example 1: Base case

Argument values:

• Expression: map

Given input table:

Expected output table: | map | | ----- | | {
 key -> 1,
 value -> val1,
} | | {
 key -> 2,
 value -> val2,
} | | {
 key -> 3,
 value -> val3,
} | | {
 key -> 4,
 value -> val4,
} |

---

Example 2: Edge case

Argument values:

• Expression: map

Given input table:

Expected output table: | map | | ----- | | {
 key -> k1,
 value -> q1,
} |

---

Example 3: Edge case

Argument values:

• Expression: map

Given input table:

Expected output table: | map | | ----- |

---