Category: Arrays
EXPLODE
EXPLODE turns an array into multiple rows, one row per element. It is the reverse of COLLECT.
Syntax
EXPLODE(array)AMC specifics
- Useful when a column holds several values as an array and they need to be counted or joined one by one.
- FLATTEN reduces nested arrays to a single level first.