aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/lookupjoin_semi_1o2o.sql
blob: 79093ae0fbdea1ec1b0f4286d2d3e8197672c1c4 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
PRAGMA DisableSimpleColumns;

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

-- prefix of sort keys
select * from Input1 as a
left semi join Input2 as b on a.k1 = b.k2
order by a.k1;