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

# · text · 27 lines · 24 code · 3 blank · 0 comment · 0 complexity · 6fe1df8169dcef0401e6d3391f5400c5 MD5 · raw file 

    

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

  2. 

  3. EXPLAIN
    4. 

  4. SELECT *
    5. 

  5. FROM srcpart a JOIN srcpart b
    6. 

  6. ON a.key = b.key
    7. 

  7. WHERE a.ds = '2008-04-08' AND
    8. 

  8.       b.ds = '2008-04-08' AND
    9. 

  9.       CASE a.key
    10. 

  10.         WHEN '27' THEN TRUE
    11. 

  11.         WHEN '38' THEN FALSE
    12. 

  12.         ELSE NULL
    13. 

  13.        END
    14. 

  14. ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr;
    15. 

  15. 

  16. SELECT *
    17. 

  17. FROM srcpart a JOIN srcpart b
    18. 

  18. ON a.key = b.key
    19. 

  19. WHERE a.ds = '2008-04-08' AND
    20. 

  20.       b.ds = '2008-04-08' AND
    21. 

  21.       CASE a.key
    22. 

  22.         WHEN '27' THEN TRUE
    23. 

  23.         WHEN '38' THEN FALSE
    24. 

  24.         ELSE NULL
    25. 

  25.        END
    26. 

  26. ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr;
    27.