yt/yql/tests/sql/suites/join/pullup_extra_columns.yql


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

use plato;

pragma yt.MapJoinLimit="1m";


$t1 = select k1, v1 from Input1;
$t2 = select k2, v2, u2 as renamed from Input2;

select
     a.*,
     b.v2,
from $t1 as a left join any $t2 as b on a.k1 = b.k2;