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


1
2
3
4
5
6
7
8
9

PRAGMA DisableSimpleColumns;
PRAGMA FilterPushdownOverJoinOptionalSide;

use plato;
SELECT *
FROM Input2 AS a
LEFT JOIN Input3 AS b
ON a.value == b.value
WHERE b.value >= "ddd";