yql/essentials/tests/sql/suites/join/lookupjoin_not_selected.sql


1
2
3
4
5
6
7
8
9

PRAGMA DisableSimpleColumns;

use plato;
pragma yt.LookupJoinLimit="64k";
pragma yt.LookupJoinMaxRows="100";

-- no lookup join in this case
select * from Input1 as a
left join Input2 as b on a.k1 = b.k2;