PageRenderTime 19ms CodeModel.GetById 13ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 36 lines | 27 code | 9 blank | 0 comment | 0 complexity | 522e03cac18486963ee05fdc8e8f277e MD5 | raw file
 1set hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;
 2set mapred.min.split.size=256;
 3set mapred.min.split.size.per.node=256;
 4set mapred.min.split.size.per.rack=256;
 5set mapred.max.split.size=256;
 6set hive.exec.dynamic.partition=true;
 7set hive.exec.dynamic.partition.mode=nonstrict;
 8set mapred.cache.shared.enabled=false;
 9set hive.merge.smallfiles.avgsize=0;
10
11create table combine2(key string) partitioned by (value string);
12
13insert overwrite table combine2 partition(value) 
14select * from (
15   select key, value from src where key < 10
16   union all 
17   select key, '|' as value from src where key = 11
18   union all
19   select key, '2010-04-21 09:45:00' value from src where key = 19) s;
20
21show partitions combine2;
22
23explain
24select key, value from combine2 where value is not null order by key;
25
26select key, value from combine2 where value is not null order by key;
27
28explain extended
29select count(1) from combine2 where value is not null;
30
31select count(1) from combine2 where value is not null;
32
33explain
34select ds, count(1) from srcpart where ds is not null group by ds;
35
36select ds, count(1) from srcpart where ds is not null group by ds;