blob: 1cb847dd290beef3d0b2ab9cea6e70142d3cb811 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
/* syntax version 1 */
/* postgres can not */
USE plato;
pragma yt.JoinMergeTablesLimit="100";
pragma yt.JoinMergeForce;
insert into @t1
select (1, 1u) as k1, 100u as v1;
insert into @t2
select (1u, 1) as k2, 100 as v2;
commit;
select * from @t1 as a join @t2 as b on a.k1 = b.k2 and a.v1 = b.v2;
|
