Hadoop Hive How to split a single row into multiple rows

Question

I have a row with comma separated values. Now I want to create multiple rows for these values. How can I do this?

Answer 1

Try this

SELECT ID1, Sub
FROM tableName lateral view explode(split(Subs,',')) Subs AS Sub  

Comments

what is SUBs and Sub?

Can u use actual column names

---

Example.

ID1    Subs
1     11, 22
2     22, 33

Now You want to split this table.

ID1   Sub
1     11
2     22

SELECT ID1, Sub
FROM tableName lateral view explode(split(Subs,',')) Subs AS Sub 

Now, it may clear your doubt.