Explode array with position

Supported in: Batch, Streaming

Explode array into a row per value as a struct containing the element's relative position in the array and the element itself.

Expression categories: Array

Declared arguments

  • Array - Array of values to explode.
    Expression<Array<T>>
  • optional Keep empty / null arrays - If true, empty arrays and nulls will be kept as nulls in the output, otherwise they will be filtered.
    Literal<Boolean>

Type variable bounds: T accepts AnyType

Output type: Struct<Optional[position], Optional[element]>