mergejoin_big_primary_unique.sql 302 B

123456789
  1. PRAGMA DisableSimpleColumns;
  2. use plato;
  3. pragma yt.JoinMergeTablesLimit="10";
  4. pragma yt.JoinAllowColumnRenames="true";
  5. pragma yt.JoinMergeUseSmallAsPrimary="false";
  6. -- Input2 is smaller than Input1, but Input1 has unique keys
  7. select * from Input1 as a join Input2 as b on a.k1 = b.k2 and a.v1 = b.v2;