yt/yql/tests/sql/suites/lineage/window_yql_21344.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

PRAGMA config.flags('OptimizerFlags', 'PushdownFiltersOverWindow');
USE plato;

$C = (
SELECT
    key,
    value,
    ROW_NUMBER() OVER (PARTITION BY key ORDER BY value) AS grp
FROM Input
);

INSERT INTO Output
SELECT 
    c.*,
FROM $C AS c
WHERE
    value = "abc"
ORDER BY 
    value