blob: fee55752f0fff97f3352d52ce86d201d5d533e6c [file] [log] [blame]
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.map.aggr=true;
set hive.groupby.skewindata=false;
explain
select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999;
select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999;
set hive.map.aggr=false;
set hive.groupby.skewindata=false;
explain
select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999;
select count(1), count(distinct x.value), count(distinct substr(x.value, 5)) from src x where x.key = 9999;