lookupjoin_not_selected.sql 205 B

123456789
  1. PRAGMA DisableSimpleColumns;
  2. use plato;
  3. pragma yt.LookupJoinLimit="64k";
  4. pragma yt.LookupJoinMaxRows="100";
  5. -- no lookup join in this case
  6. select * from Input1 as a
  7. left join Input2 as b on a.k1 = b.k2;