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

set hive.explain.user=false;
SET hive.vectorized.execution.enabled=true;
SET hive.vectorized.execution.reduce.enabled=true;
set hive.fetch.task.conversion=none;
set hive.cli.print.header=true;
set hive.mapred.mode=nonstrict;
set hive.merge.mapfiles = false;
set hive.merge.mapredfiles = false;
-- Set merging to false above to make the explain more readable

CREATE TABLE T1_text_n1(a STRING, b STRING, c STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS TEXTFILE; 

LOAD DATA LOCAL INPATH '../../data/files/grouping_sets.txt' INTO TABLE T1_text_n1;

CREATE TABLE T1_n33 STORED AS ORC AS SELECT * FROM T1_text_n1;

-- SORT_QUERY_RESULTS

-- This tests that cubes and rollups work fine where the source is a sub-query
EXPLAIN VECTORIZATION DETAIL
SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube;

EXPLAIN VECTORIZATION DETAIL
SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by cube(a, b);

SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube;

set hive.new.job.grouping.set.cardinality=2;

-- Since 4 grouping sets would be generated for the cube, an additional MR job should be created
EXPLAIN VECTORIZATION DETAIL
SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube;

SELECT a, b, count(*) FROM
(SELECT a, b, count(1) from T1_n33 group by a, b) subq1 group by a, b with cube;