mergejoin_big_primary.sql 278 B

12345678910
  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
  7. select * from Input1 as a join Input2 as b on a.k1 = b.k2
  8. order by a.v1, b.v2;