Skip to main content

EXPLODE

Expand array fields into separate rows.

Syntax​

EXPLODE assignmentClause

Parameters​

  • assignmentClause - Either an assignment (identifier = expression) or an expression that evaluates to an array field

Description​

The EXPLODE command transforms rows containing array fields into multiple rows, with each element of the array becoming a separate row. Each array element becomes a new row with all other fields from the original row preserved in each generated output row.

When you use assignment syntax (identifier = expression), the exploded values are placed in the specified field name. Without assignment syntax, the exploded values replace the original array field.

  • ROWS - Injects rows into a pipeline (similar row generation behavior)