Hello,
You can use the split(string, pattern) UDF, that returns an array.
You can compute this array in a subquery, and then assign a[0], a[1], a[2]
... to each column.
The split UDF will only be called once per row.
On Thu, Aug 24, 2017 at 12:11 AM, Deepak Khandelwal <
dkhandelwal@gmail.co
Can someone tell the best way to implement below in hive.
how can we take input from column c1 from tab Such that c1 has multiple
values delimited by pipe. Each of the delimited value from col c1 of table
t1 needs to be inserted into separate column in table t2.
I can write a UDF for this but th