Re: One column into multiple column.

2017-08-24 Thread Furcy Pin
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

One column into multiple column.

2017-08-23 Thread Deepak Khandelwal
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