1#@!#!123s

: / home / tattooscyy / api / vendor / scrivo / highlight.php / test / markup / sql /

Filename : lateral-view.txt

back

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;