PREHOOK: query: -- Taken from groupby2.q
CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest_g2
POSTHOOK: query: -- Taken from groupby2.q
CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_g2
PREHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@src_temp
POSTHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_temp
PREHOOK: query: FROM src_temp
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src_temp.key,1,1), count(DISTINCT substr(src_temp.value,5)), concat(substr(src_temp.key,1,1),sum(substr(src_temp.value,5))) GROUP BY substr(src_temp.key,1,1)
PREHOOK: type: QUERY
PREHOOK: Input: default@src_temp
PREHOOK: Output: default@dest_g2
POSTHOOK: query: FROM src_temp
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src_temp.key,1,1), count(DISTINCT substr(src_temp.value,5)), concat(substr(src_temp.key,1,1),sum(substr(src_temp.value,5))) GROUP BY substr(src_temp.key,1,1)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_temp
POSTHOOK: Output: default@dest_g2
POSTHOOK: Lineage: dest_g2.c1 EXPRESSION [(src_temp)src_temp.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: dest_g2.c2 EXPRESSION [(src_temp)src_temp.FieldSchema(name:key, type:string, comment:null), (src_temp)src_temp.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: dest_g2.key EXPRESSION [(src_temp)src_temp.FieldSchema(name:key, type:string, comment:null), ]
PREHOOK: query: SELECT dest_g2.* FROM dest_g2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_g2
#### A masked pattern was here ####
POSTHOOK: query: SELECT dest_g2.* FROM dest_g2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_g2
#### A masked pattern was here ####
0	1	00.0
1	71	116414.0
2	69	225571.0
3	62	332004.0
4	74	452763.0
5	6	5397.0
6	5	6398.0
7	6	7735.0
8	8	8762.0
9	7	91047.0
PREHOOK: query: DROP TABLE dest_g2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dest_g2
PREHOOK: Output: default@dest_g2
POSTHOOK: query: DROP TABLE dest_g2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@dest_g2
POSTHOOK: Output: default@dest_g2
PREHOOK: query: DROP TABLE src_temp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_temp
PREHOOK: Output: default@src_temp
POSTHOOK: query: DROP TABLE src_temp
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@src_temp
POSTHOOK: Output: default@src_temp