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


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

USE plato;

$key = select min(key) from Input;
$value = select min(value) from Input;

INSERT INTO Output
SELECT * FROM (
    SELECT $key as key
    UNION ALL
    SELECT $value as val
)
WHERE key > '';