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

# · text · 24 lines · 22 code · 2 blank · 0 comment · 0 complexity · d8f1c9fc9490d6b60fa46ae643db8dcd MD5 · raw file 

    

  1. set hive.optimize.ppd=true;
    2. 

  2. 

  3. EXPLAIN
    4. 

  4. SELECT src1.c1, src2.c4 
    5. 

  5. FROM
    6. 

  6. (SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
    7. 

  7. JOIN
    8. 

  8. (SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2
    9. 

  9. ON src1.c1 = src2.c3 AND src1.c1 < '400'
    10. 

  10. JOIN
    11. 

  11. (SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3
    12. 

  12. ON src1.c2 = src3.c6
    13. 

  13. WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13);
    14. 

  14. 

  15. SELECT src1.c1, src2.c4 
    16. 

  16. FROM
    17. 

  17. (SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1
    18. 

  18. JOIN
    19. 

  19. (SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2
    20. 

  20. ON src1.c1 = src2.c3 AND src1.c1 < '400'
    21. 

  21. JOIN
    22. 

  22. (SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3
    23. 

  23. ON src1.c2 = src3.c6
    24. 

  24. WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13);
    25.