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

# · text · 17 lines · 11 code · 6 blank · 0 comment · 0 complexity · 189b71860b03c409206ce0466d1b7a06 MD5 · raw file 

    

  1. CREATE TABLE dest_j1(key STRING, value STRING, val2 STRING) STORED AS TEXTFILE;
    2. 

  2. 

  3. EXPLAIN EXTENDED
    4. 

  4. INSERT OVERWRITE TABLE dest_j1
    5. 

  5. SELECT /*+ MAPJOIN(x) */ x.key, z.value, y.value
    6. 

  6. FROM src1 x JOIN src y ON (x.key = y.key) 
    7. 

  7. JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
    8. 

  8. 

  9. INSERT OVERWRITE TABLE dest_j1
    10. 

  10. SELECT /*+ MAPJOIN(x) */ x.key, z.value, y.value
    11. 

  11. FROM src1 x JOIN src y ON (x.key = y.key) 
    12. 

  12. JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
    13. 

  13. 

  14. select * from dest_j1 x order by x.key;
    15.