/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 

    

  1. set hive.auto.convert.join = true;
    2. 

  2. 

  3. explain
    4. 

  4. SELECT sum(hash(src1.c1, src2.c4)) 
    5. 

  5. FROM
    6. 

  6. (SELECT src.key as c1, src.value as c2 from src) src1
    7. 

  7. JOIN
    8. 

  8. (SELECT src.key as c3, src.value as c4 from src) src2
    9. 

  9. ON src1.c1 = src2.c3 AND src1.c1 < 100;
    10. 

  10. 

  11. SELECT sum(hash(src1.c1, src2.c4)) 
    12. 

  12. FROM
    13. 

  13. (SELECT src.key as c1, src.value as c2 from src) src1
    14. 

  14. JOIN
    15. 

  15. (SELECT src.key as c3, src.value as c4 from src) src2
    16. 

  16. ON src1.c1 = src2.c3 AND src1.c1 < 100;
    17.