SELECT t1.col as num, t2.col as ans FROM ( SELECT seq, col FROM table LATERAL VIEW posexplode(split('1,4', ',')) rec as seq, col ) t1 JOIN ( SELECT seq, col FROM table LATERAL VIEW posexplode(split('2,5', ',')) rec as seq, col ) t2 ON t1.seq = t2.seq