CREATE TABLE T1(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;

SELECT * FROM T1;

SELECT a, b, count(*) from T1 group by a, b with cube;

SELECT a, b, count(*) FROM T1 GROUP BY a, b  GROUPING SETS (a, (a, b), b, ());

SELECT a, b, count(*) FROM T1 GROUP BY a, b GROUPING SETS (a, (a, b));

SELECT a FROM T1 GROUP BY a, b, c GROUPING SETS (a, b, c);

SELECT a FROM T1 GROUP BY a GROUPING SETS ((a), (a));

SELECT a + b, count(*) FROM T1 GROUP BY a + b GROUPING SETS (a+b);