Hadoop/Hive - Split a single row into multiple rows

Try this wording

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

hadoop split hive

SELECT ID1, new_Subs_clmnFROM tableName lateral view explode(split(Subs,',')) Subs AS new_Sub_clmn;

I was initially confused with the names used, sharing the above query thinking it would be of help.

CodeHunter