aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/mergejoin_big_primary.sql
blob: a05dcc865ce67084d28800dd96191528f0fcd45f (plain) (blame)
1
2
3
4
5
6
7
8
9
10
PRAGMA DisableSimpleColumns;
use plato;
pragma yt.JoinMergeTablesLimit="10";
pragma yt.JoinAllowColumnRenames="true";
pragma yt.JoinMergeUseSmallAsPrimary="false";

-- Input2 is smaller than Input1
select * from Input1 as a join Input2 as b on a.k1 = b.k2
order by a.v1, b.v2;