blob: 79ac40541696f0a2597d81e0f4090e72bf7bf2de (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
PRAGMA DisableSimpleColumns;
use plato;
pragma yt.JoinMergeTablesLimit="10";
pragma yt.JoinAllowColumnRenames="true";
pragma yt.JoinMergeUseSmallAsPrimary="false";
-- Input2 is smaller than Input1, but Input1 has unique keys
select * from Input1 as a join Input2 as b on a.k1 = b.k2 and a.v1 = b.v2;
|
