summaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/combine/empty_both.yql
blob: a0fe0c53a927bff59cce57796034e871dd6c3b1b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
$f = ($key, $leftList, $rightList) -> {return <|k:$key, v:ListZipAll($leftList, $rightList)|>;};

$a = ListCreate(Struct<key: Int32, subkey: Int32, value: String>);

$b = ListCreate(Struct<key: Int32, subkey: Int32, value: String>);

COMBINE AS_TABLE($a) as A
    PRESORT A.key
WITH AS_TABLE($b) as B
    PRESORT B.key
ON A.key = B.key
USING $f(TableRow(), TableRow())