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

# · text · 18 lines · 14 code · 4 blank · 0 comment · 0 complexity · 78a0079e836a6397e77b3997a8a794f2 MD5 · raw file 

    

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

  2. 

  3. 

  4. explain
    5. 

  5. SELECT sum(hash(subq.key, tab.value)) 
    6. 

  6. FROM 
    7. 

  7. (select a.key, a.value from src a where a.key > 10 ) subq 
    8. 

  8. JOIN src tab 
    9. 

  9. ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) 
    10. 

  10. where tab.value < 200;
    11. 

  11. 

  12. SELECT sum(hash(subq.key, tab.value)) 
    13. 

  13. FROM 
    14. 

  14. (select a.key, a.value from src a where a.key > 10 ) subq 
    15. 

  15. JOIN src tab 
    16. 

  16. ON (subq.key = tab.key and subq.key > 20 and subq.value = tab.value) 
    17. 

  17. where tab.value < 200;
    18.