PageRenderTime 14ms CodeModel.GetById 12ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 18 lines | 13 code | 5 blank | 0 comment | 0 complexity | a5c1ecde7aab0cdc7d02ea3a7996778d MD5 | raw file
 1set hive.map.aggr=false;
 2set hive.groupby.skewindata=true;
 3
 4CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE;
 5
 6EXPLAIN
 7INSERT OVERWRITE TABLE dest1 
 8SELECT src.key, sum(substr(src.value,5)) 
 9FROM src
10GROUP BY src.key;
11
12INSERT OVERWRITE TABLE dest1 
13SELECT src.key, sum(substr(src.value,5)) 
14FROM src
15GROUP BY src.key;
16
17SELECT dest1.* FROM dest1;
18