PageRenderTime 41ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/auto_join11.q

#
text | 16 lines | 14 code | 2 blank | 0 comment | 0 complexity | c9bf320ad0f4ad61e5e46ca52dd3a797 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. set hive.auto.convert.join = true;
  2. explain
  3. SELECT sum(hash(src1.c1, src2.c4))
  4. FROM
  5. (SELECT src.key as c1, src.value as c2 from src) src1
  6. JOIN
  7. (SELECT src.key as c3, src.value as c4 from src) src2
  8. ON src1.c1 = src2.c3 AND src1.c1 < 100;
  9. SELECT sum(hash(src1.c1, src2.c4))
  10. FROM
  11. (SELECT src.key as c1, src.value as c2 from src) src1
  12. JOIN
  13. (SELECT src.key as c3, src.value as c4 from src) src2
  14. ON src1.c1 = src2.c3 AND src1.c1 < 100;