The FLATTEN directive separates the elements in a repeated field into individual records. Use the FLATTEN directive for JSON arrays. To flatten RowType (Record) columnsa record column with nested value, use the FLATTEN-RECORD directive.
Note: In releases before CDAP 6.7.0, due to a bug, the FLATTEN directive worked with both JSON arrays and RowType (Record) columnsan array and a record column with nested values. Starting in CDAP 6.7.0, the FLATTEN directive only works with JSON arrays.
Syntax
| Code Block |
|---|
flatten :column [,:column]* |
...