PageRenderTime 20ms CodeModel.GetById 15ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 31 lines | 20 code | 11 blank | 0 comment | 0 complexity | 576442fad3580af1b56978234d0bc576 MD5 | raw file
 1set hive.map.aggr=true;
 2set hive.groupby.skewindata=true;
 3
 4explain
 5select count(1), count(distinct x.value) from src x where x.key = 9999;
 6
 7select count(1), count(distinct x.value) from src x where x.key = 9999;
 8
 9set hive.map.aggr=true;
10set hive.groupby.skewindata=false;
11
12explain
13select count(1), count(distinct x.value) from src x where x.key = 9999;
14
15select count(1), count(distinct x.value) from src x where x.key = 9999;
16
17set hive.map.aggr=false;
18set hive.groupby.skewindata=true;
19
20explain
21select count(1), count(distinct x.value) from src x where x.key = 9999;
22
23select count(1), count(distinct x.value) from src x where x.key = 9999;
24
25set hive.map.aggr=false;
26set hive.groupby.skewindata=false;
27
28explain
29select count(1), count(distinct x.value) from src x where x.key = 9999;
30
31select count(1), count(distinct x.value) from src x where x.key = 9999;