mergejoin_semi_to_inner.sql 249 B

12345678910
  1. /* syntax version 1 */
  2. use plato;
  3. pragma yt.JoinMergeTablesLimit="10";
  4. pragma yt.JoinMergeUnsortedFactor="0";
  5. pragma yt.JoinAllowColumnRenames="true";
  6. from Input1 as a
  7. left semi join Input2 as b on a.k1 = b.k2 and a.v1 = b.v2
  8. select * order by u1