SELECT master_child.col1 AS master_id, child_table.child_id FROM VALUES ( 1 , ARRAY(1,2,3)), (2, ARRAY(4,5,6)) AS master_child LATERAL VIEW EXPLODE(master_child.col2) child_table AS child_id;