/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;