late_mergejoin_on_empty.sql 299 B

12345678
  1. use plato;
  2. PRAGMA DisableSimpleColumns;
  3. pragma yt.JoinMergeTablesLimit="100";
  4. select * from
  5. (select * from Input where key < "020") as a
  6. left only join (select subkey from Input where key < "010") as b on a.subkey = b.subkey
  7. join /*+ merge() */ (select key, value from Input) as c on a.key = c.key