PageRenderTime 62ms CodeModel.GetById 30ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 25 lines | 20 code | 5 blank | 0 comment | 0 complexity | a2c774d01347d43593a1dcc7160643aa MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. 

  2. 

  3. set hive.auto.convert.join = true;
    4. 

  4. 

  5. 

  6. explain
    7. 

  7. SELECT sum(hash(src1.c1, src2.c4)) 
    8. 

  8. FROM
    9. 

  9. (SELECT src.key as c1, src.value as c2 from src) src1
    10. 

  10. JOIN
    11. 

  11. (SELECT src.key as c3, src.value as c4 from src) src2
    12. 

  12. ON src1.c1 = src2.c3 AND src1.c1 < 100
    13. 

  13. JOIN
    14. 

  14. (SELECT src.key as c5, src.value as c6 from src) src3
    15. 

  15. ON src1.c1 = src3.c5 AND src3.c5 < 80;
    16. 

  16. 

  17. SELECT sum(hash(src1.c1, src2.c4)) 
    18. 

  18. FROM
    19. 

  19. (SELECT src.key as c1, src.value as c2 from src) src1
    20. 

  20. JOIN
    21. 

  21. (SELECT src.key as c3, src.value as c4 from src) src2
    22. 

  22. ON src1.c1 = src2.c3 AND src1.c1 < 100
    23. 

  23. JOIN
    24. 

  24. (SELECT src.key as c5, src.value as c6 from src) src3
    25. 

  25. ON src1.c1 = src3.c5 AND src3.c5 < 80;
    26. 

  26.