PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@T1
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
PREHOOK: type: LOAD
PREHOOK: Output: default@t1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@t1
PREHOOK: query: SELECT key, val, GROUPING__ID from T1 group by key, val with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, val, GROUPING__ID from T1 group by key, val with cube
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
#### A masked pattern was here ####
NULL	NULL	0
NULL	11	2
NULL	12	2
NULL	13	2
NULL	17	2
NULL	18	2
NULL	28	2
1	NULL	1
1	11	3
2	NULL	1
2	12	3
3	NULL	1
3	13	3
7	NULL	1
7	17	3
8	NULL	1
8	18	3
8	28	3
PREHOOK: query: SELECT GROUPING__ID, key, val from T1 group by key, val with rollup
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
POSTHOOK: query: SELECT GROUPING__ID, key, val from T1 group by key, val with rollup
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
#### A masked pattern was here ####
0	NULL	NULL
1	1	NULL
3	1	11
1	2	NULL
3	2	12
1	3	NULL
3	3	13
1	7	NULL
3	7	17
1	8	NULL
3	8	18
3	8	28
PREHOOK: query: SELECT key, val, GROUPING__ID, CASE WHEN GROUPING__ID == 0 THEN "0" WHEN GROUPING__ID == 1 THEN "1" WHEN GROUPING__ID == 2 THEN "2" WHEN GROUPING__ID == 3 THEN "3" ELSE "nothing" END from T1 group by key, val with cube
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
#### A masked pattern was here ####
POSTHOOK: query: SELECT key, val, GROUPING__ID, CASE WHEN GROUPING__ID == 0 THEN "0" WHEN GROUPING__ID == 1 THEN "1" WHEN GROUPING__ID == 2 THEN "2" WHEN GROUPING__ID == 3 THEN "3" ELSE "nothing" END from T1 group by key, val with cube
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
#### A masked pattern was here ####
NULL	NULL	0	0
NULL	11	2	2
NULL	12	2	2
NULL	13	2	2
NULL	17	2	2
NULL	18	2	2
NULL	28	2	2
1	NULL	1	1
1	11	3	3
2	NULL	1	1
2	12	3	3
3	NULL	1	1
3	13	3	3
7	NULL	1	1
7	17	3	3
8	NULL	1	1
8	18	3	3
8	28	3	3