File: lateral-view.txt

package info (click to toggle)
highlight.js 9.18.5%2Bdfsg1-2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, trixie
  • size: 6,672 kB
  • sloc: javascript: 40,928; python: 342; makefile: 160; sh: 11
file content (7 lines) | stat: -rw-r--r-- 214 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
 
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;