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


1
2
3
4
5
6
7
8
9
10
11

/* syntax version 1 */
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 any Input1 as b on a.k2 = b.k1;