PageRenderTime 21ms CodeModel.GetById 16ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

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