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


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

USE plato;

$sub = (
    select key
    from Input where value = 'abc'
);

insert into Output
    select
       value, $sub as s
    from Input
    order by value