yql/essentials/tests/sql/suites/join/mapjoin_with_anonymous.sql


1
2
3
4
5
6
7
8
9
10
11
12

/* postgres can not */
/* kikimr can not */
use plato;
pragma DisableSimpleColumns;

pragma yt.MapJoinLimit="1m";

insert into @tmp select * from Input where key > "100";
commit;

select * from Input as a
left join @tmp as b on a.key = b.key;