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

# · text · 24 lines · 18 code · 6 blank · 0 comment · 0 complexity · 31216f6baa61d6e6595941b014e81004 MD5 · raw file 

    

  1. EXPLAIN
    2. 

  2. SELECT /*+MAPJOIN(a)*/ 
    3. 

  3. TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
    4. 

  4. FROM src a join src b
    5. 

  5. on a.key = b.key;
    6. 

  6. 

  7. 

  8. SELECT /*+MAPJOIN(a)*/ 
    9. 

  9. TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
    10. 

  10. FROM src a join src b
    11. 

  11. on a.key = b.key;
    12. 

  12. 

  13. 

  14. EXPLAIN
    15. 

  15. SELECT /*+STREAMTABLE(a)*/ 
    16. 

  16. TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
    17. 

  17. FROM src a join src b
    18. 

  18. on a.key = b.key;
    19. 

  19. 

  20. 

  21. SELECT /*+STREAMTABLE(a)*/ 
    22. 

  22. TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
    23. 

  23. FROM src a join src b
    24. 

  24. on a.key = b.key;
    25.