ql/src/test/queries/clientpositive/nullgroup2.q

--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.map.aggr=true;
set hive.groupby.skewindata=true;

explain
select x.key, count(1) from src x where x.key > 9999 group by x.key;

select x.key, count(1) from src x where x.key > 9999 group by x.key;

set hive.map.aggr=true;
set hive.groupby.skewindata=false;

explain
select x.key, count(1) from src x where x.key > 9999 group by x.key;

select x.key, count(1) from src x where x.key > 9999 group by x.key;

set hive.map.aggr=false;
set hive.groupby.skewindata=true;

explain
select x.key, count(1) from src x where x.key > 9999 group by x.key;

select x.key, count(1) from src x where x.key > 9999 group by x.key;

set hive.map.aggr=false;
set hive.groupby.skewindata=false;

explain
select x.key, count(1) from src x where x.key > 9999 group by x.key;

select x.key, count(1) from src x where x.key > 9999 group by x.key;