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


1
2
3
4
5
6
7
8
9
10
11

USE plato;

INSERT INTO Output
SELECT * FROM (
    SELECT
        [key, key] as key2,
        value
    FROM Input
    WHERE value > ''
) FLATTEN LIST BY key2