blob: c8ea1a1ef833c272d37381ec394097f4f96b8ab9 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
PRAGMA DisableSimpleColumns;
PRAGMA DisablePullUpFlatMapOverJoin;
use plato;
pragma yt.MapJoinLimit="1m";
from (select k1, v1 || u1 as v1 from Input1) as a
left semi join (select k2, u2 || v2 as u2 from Input2) as b on a.k1 = b.k2
select *
order by a.k1,a.v1;
|
