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 ... View more