mapjoin_with_anonymous.sql 243 B

123456789101112
  1. /* postgres can not */
  2. /* kikimr can not */
  3. use plato;
  4. pragma DisableSimpleColumns;
  5. pragma yt.MapJoinLimit="1m";
  6. insert into @tmp select * from Input where key > "100";
  7. commit;
  8. select * from Input as a
  9. left join @tmp as b on a.key = b.key;