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

# · text · 19 lines · 15 code · 4 blank · 0 comment · 0 complexity · 39f6a63c2ea1903f738679e16f764ded MD5 · raw file 

    

  1. set hive.map.aggr=false;
    2. 

  2. set hive.groupby.skewindata=false;
    3. 

  3. 

  4. CREATE TABLE dest1(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE;
    5. 

  5. 

  6. EXPLAIN EXTENDED
    7. 

  7. FROM srcpart src
    8. 

  8. INSERT OVERWRITE TABLE dest1 
    9. 

  9. SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) 
    10. 

  10. WHERE src.ds = '2008-04-08'
    11. 

  11. GROUP BY substr(src.key,1,1);
    12. 

  12. 

  13. FROM srcpart src
    14. 

  14. INSERT OVERWRITE TABLE dest1 
    15. 

  15. SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(src.key,1,1),sum(substr(src.value,5))) 
    16. 

  16. WHERE src.ds = '2008-04-08'
    17. 

  17. GROUP BY substr(src.key,1,1);
    18. 

  18. 

  19. SELECT dest1.* FROM dest1;
    20.