Output
The returned rows consist of a fixed set of columns:
+-----+------+------+-------+-------+------+
| SEQ | KEY | PATH | INDEX | VALUE | THIS |
|-----+------+------+-------+-------+------|
SEQ
A unique sequence number associated with the input record; the sequence is not guaranteed to be gap-free or ordered in any particular way.
KEY
For maps or objects, this column contains the key to the exploded value.
PATH
The path to the element within a data structure that needs to be flattened.
INDEX
The index of the element, if it is an array; otherwise NULL.
VALUE
The value of the element of the flattened array/object.
THIS
The element being flattened (useful in recursive flattening).
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Kate0204
Highly Voted 2 years, 2 months agoPrasantSadangi
Most Recent 4 months, 3 weeks ago_yyukta
11 months, 3 weeks agoMultiCloudIronMan
1 year, 10 months agomiadiesel
2 years, 1 month ago