Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive transpose concatenated data in columns to rows

avatar
New Contributor

I am new to hive and I need some help to transpose concatenated data in columns to rows. My hive table consists of subset of columns which contains concatenated values delimited by pipe or comma. I want to transpose it to rows using explode lateral view.

Input table

column1, column2, column3, column4

id1, Delta|Alpha|Beta, Source|Varied|Volume, AppData

Output table

column1, column2, column3, column4

id1, Delta, Source, AppData

id1, Alpha, Varied, AppData

id1, Beta, Volume, AppData

1 ACCEPTED SOLUTION

avatar
Super Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
4 REPLIES 4

avatar
Super Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
New Contributor

@Ed Berezitsky Thank you, this worked.

avatar
Super Collaborator

@Dhanya Kumar Heballi Shivamurthy, please accept the answer to close the thread.

avatar
New Contributor

1)does a cross -join happen between c21 and c32?

2)why did you use select 100?

3)What is owner?