File: lateral-view.expect.txt

package info (click to toggle)
highlight.js 10.7.3%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 8,332 kB
  • sloc: javascript: 41,059; makefile: 157; python: 29; sh: 20
file content (7 lines) | stat: -rw-r--r-- 854 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
 
<span class="hljs-keyword">SELECT</span> 
    master_child.col1 <span class="hljs-keyword">AS</span> master_id, 
    child_table.child_id 
<span class="hljs-keyword">FROM</span> <span class="hljs-keyword">VALUES</span> 
    ( <span class="hljs-number">1</span> , <span class="hljs-built_in">ARRAY</span>(<span class="hljs-number">1</span>,<span class="hljs-number">2</span>,<span class="hljs-number">3</span>)), 
    (<span class="hljs-number">2</span>, <span class="hljs-built_in">ARRAY</span>(<span class="hljs-number">4</span>,<span class="hljs-number">5</span>,<span class="hljs-number">6</span>)) <span class="hljs-keyword">AS</span> master_child 
<span class="hljs-keyword">LATERAL</span> <span class="hljs-keyword">VIEW</span> <span class="hljs-keyword">EXPLODE</span>(master_child.col2) child_table <span class="hljs-keyword">AS</span> child_id;