yql/essentials/tests/sql/suites/lineage/join_as_struct.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

INSERT INTO plato.Output
SELECT * FROM (
SELECT x,y FROM (
SELECT
    key, <|a:key,b:value|> as x
FROM plato.Input
) as a 
JOIN (
SELECT
    key, <|c:key,d:value|> as y
FROM plato.Input
) as b
ON a.key = b.key
)
flatten columns