aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/premap_map_cross.sql
blob: 75ec5b34cfab57e108b1b60b19e651ff48c62f5e (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, Just(1) as u1 from Input1) as a
cross join (select k2, v2, Just(2) as u2 from Input2) as b
select *
order by a.k1,b.k2,a.v1,b.v2;