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

 1set hive.map.aggr=false;
 2set hive.groupby.skewindata=false;
 3set mapred.reduce.tasks=31;
 4
 5CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE;
 6
 7EXPLAIN
 8FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key;
 9
10FROM src INSERT OVERWRITE TABLE dest_g1 SELECT src.key, sum(substr(src.value,5)) GROUP BY src.key;
11
12SELECT dest_g1.* FROM dest_g1;