PageRenderTime 5ms CodeModel.GetById 2ms app.highlight 0ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 12 lines | 8 code | 4 blank | 0 comment | 0 complexity | 345e6a62d57c90fd13beea008a24cda3 MD5 | raw file
 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;