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

set hive.mapred.mode=nonstrict;
set hive.exec.reducers.max = 10;
set hive.map.groupby.sorted=true;

-- SORT_QUERY_RESULTS

CREATE TABLE T1_n61(key STRING, val STRING) PARTITIONED BY (ds string);

CREATE TABLE outputTbl1_n15(key int, cnt int);

-- The plan should not be converted to a map-side group since no partition is being accessed
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1_n15
SELECT key, count(1) FROM T1_n61 where ds = '1' GROUP BY key;

INSERT OVERWRITE TABLE outputTbl1_n15
SELECT key, count(1) FROM T1_n61 where ds = '1' GROUP BY key;

SELECT * FROM outputTbl1_n15;

LOAD DATA LOCAL INPATH '../../data/files/bucket_files/000000_0' INTO TABLE T1_n61  PARTITION (ds='2');

-- The plan should not be converted to a map-side group since no partition is being accessed
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1_n15
SELECT key, count(1) FROM T1_n61 where ds = '1' GROUP BY key;

INSERT OVERWRITE TABLE outputTbl1_n15
SELECT key, count(1) FROM T1_n61 where ds = '1' GROUP BY key;

SELECT * FROM outputTbl1_n15;

-- The plan should not be converted to a map-side group since the partition being accessed
-- is neither bucketed not sorted
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1_n15
SELECT key, count(1) FROM T1_n61 where ds = '2' GROUP BY key;

INSERT OVERWRITE TABLE outputTbl1_n15
SELECT key, count(1) FROM T1_n61 where ds = '2' GROUP BY key;

SELECT * FROM outputTbl1_n15;