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


1
2
3
4
5
6
7
8
9
10

PRAGMA DisableSimpleColumns;

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

-- tables should be swapped (Input1 is bigger)
select * from Input2 as a
inner join Input1 as b on a.k2 = b.k1 and a.v2 = b.v1;