yt/yql/tests/sql/suites/join/left_join_right_pushdown_null.yql


1
2
3
4
5
6
7

PRAGMA FilterPushdownOverJoinOptionalSide;

SELECT t1.Key1, t1.Key2, t1.Fk1, t1.Value, t2.Key, t2.Value FROM plato.Input1 AS t1
LEFT JOIN plato.Input2 AS t2
ON t1.Fk1 = t2.Key
WHERE t2.Value IS NULL
ORDER BY t1.Key1, t1.Key2;