lookupjoin_unused_keys.sql 215 B

12345678910111213
  1. /* syntax version 1 */
  2. use plato;
  3. pragma yt.LookupJoinLimit="64k";
  4. pragma yt.LookupJoinMaxRows="100";
  5. select
  6. v3
  7. from Input1 as a
  8. join Input2 as b on (a.k1 = b.k2)
  9. join Input3 as c on (a.k1 = c.k3)
  10. order by v3;