star_join_inners_premap.sql 335 B

12345678910111213
  1. /* syntax version 1 */
  2. use plato;
  3. pragma yt.JoinEnableStarJoin="true";
  4. pragma DisablePullUpFlatMapOverJoin;
  5. $a = select k1,v1,u1, 1 as t1 from Input1;
  6. $c = select k3,v3,u3, 3 as t3 from Input3;
  7. from any Input2 as b
  8. join any $a as a on b.k2 = a.k1 and a.v1 = b.v2
  9. join any $c as c on a.k1 = c.k3 and c.v3 = a.v1
  10. select * order by u1