premap_map_cross.sql 264 B

123456789
  1. PRAGMA DisableSimpleColumns;
  2. PRAGMA DisablePullUpFlatMapOverJoin;
  3. use plato;
  4. pragma yt.MapJoinLimit="1m";
  5. from (select k1, v1, Just(1) as u1 from Input1) as a
  6. cross join (select k2, v2, Just(2) as u2 from Input2) as b
  7. select *
  8. order by a.k1,b.k2,a.v1,b.v2;