starjoin_unused_keys.sql 262 B

12345678910111213
  1. /* syntax version 1 */
  2. use plato;
  3. pragma yt.JoinEnableStarJoin="true";
  4. select
  5. v3
  6. from any Input1 as a
  7. join any Input2 as b on (a.k1 = b.k2 and a.v1 = b.v2)
  8. join any Input3 as c on (a.k1 = c.k3 and a.v1 = c.v3)
  9. join Input4 as d on (a.k1 = d.k4)
  10. order by v3;