blob: 73171384f03a4e3927dc15a848f983826e7fd06c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
use plato;
pragma yt.MapJoinLimit="1m";
$t1 = AsList(
AsStruct(Just(1) AS Key),
AsStruct(Just(2) AS Key),
AsStruct(Just(3) AS Key));
$t2 = AsList(
AsStruct(Just(Just(2)) AS Key),
AsStruct(Just(Just(3)) AS Key),
AsStruct(Just(Just(4)) AS Key),
AsStruct(Just(Just(5)) AS Key),
AsStruct(Just(Just(6)) AS Key));
insert into @t1 select * from as_table($t1);
insert into @t2 select * from as_table($t2);
commit;
select *
from @t1 as a join @t2 as b using(Key);
|
