Sample Header Ad - 728x90

Can I assign an index to an exploded array?

1 vote
0 answers
97 views
I'm doing a LATERAL EXPLODE on an array in Hive, is there a way of reliably assigning a row number based on the array element? It looks like calling row_number() on the results of the LATERAL EXPLODE works, but I don't know if that is dependable. It does seem to be in practice. We're doing this now and have never encountered a case where the elements have been enumerated incorrectly.
Asked by PhilHibbs (539 rep)
May 5, 2020, 10:18 AM
Last activity: Jun 8, 2020, 11:57 AM