lookupjoin_bug8533.sql 250 B

1234567891011
  1. /* syntax version 1 */
  2. PRAGMA DisableSimpleColumns;
  3. use plato;
  4. pragma yt.LookupJoinLimit="64k";
  5. pragma yt.LookupJoinMaxRows="100";
  6. -- tables should be swapped (Input1 is bigger)
  7. select * from Input2 as a
  8. inner join any Input1 as b on a.k2 = b.k1;