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

SET hive.vectorized.execution.enabled=true;
SET hive.vectorized.execution.reduce.enabled=true;
set hive.mapred.mode=nonstrict;
set hive.exec.reducers.max = 1;
set hive.map.groupby.sorted=true;

-- SORT_QUERY_RESULTS

CREATE TABLE T1_n137(key STRING, val STRING) PARTITIONED BY (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS;

-- perform an insert to make sure there are 2 files
INSERT OVERWRITE TABLE T1_n137 PARTITION (ds='1')
SELECT * from src where key < 10;

-- The plan is optimized to perform partial aggregation on the mapper
EXPLAIN VECTORIZATION DETAIL
select count(distinct key) from T1_n137;
select count(distinct key) from T1_n137;

-- The plan is optimized to perform partial aggregation on the mapper
EXPLAIN VECTORIZATION DETAIL
select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137;
select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137;

-- The plan is not changed in the presence of a grouping key
EXPLAIN VECTORIZATION DETAIL
select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key;
select count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key;

-- The plan is not changed in the presence of a grouping key
EXPLAIN VECTORIZATION DETAIL
select key, count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key;
select key, count(distinct key), count(1), count(key), sum(distinct key) from T1_n137 group by key;

-- The plan is not changed in the presence of a grouping key expression
EXPLAIN VECTORIZATION DETAIL
select count(distinct key+key) from T1_n137;
select count(distinct key+key) from T1_n137;

EXPLAIN VECTORIZATION DETAIL
select count(distinct 1) from T1_n137;
select count(distinct 1) from T1_n137;

set hive.map.aggr=false;

-- no plan change if map aggr is turned off
EXPLAIN VECTORIZATION DETAIL
select count(distinct key) from T1_n137;
select count(distinct key) from T1_n137;