| PREHOOK: query: CREATE TABLE dest_g2_n0(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@dest_g2_n0 |
| POSTHOOK: query: CREATE TABLE dest_g2_n0(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@dest_g2_n0 |
| 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 |
| POSTHOOK: Lineage: src_temp.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: src_temp.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: FROM src_temp |
| INSERT OVERWRITE TABLE dest_g2_n0 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_n0 |
| POSTHOOK: query: FROM src_temp |
| INSERT OVERWRITE TABLE dest_g2_n0 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_n0 |
| POSTHOOK: Lineage: dest_g2_n0.c1 EXPRESSION [(src_temp)src_temp.FieldSchema(name:value, type:string, comment:null), ] |
| POSTHOOK: Lineage: dest_g2_n0.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_n0.key EXPRESSION [(src_temp)src_temp.FieldSchema(name:key, type:string, comment:null), ] |
| PREHOOK: query: SELECT dest_g2_n0.* FROM dest_g2_n0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@dest_g2_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT dest_g2_n0.* FROM dest_g2_n0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@dest_g2_n0 |
| #### 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_n0 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@dest_g2_n0 |
| PREHOOK: Output: default@dest_g2_n0 |
| POSTHOOK: query: DROP TABLE dest_g2_n0 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@dest_g2_n0 |
| POSTHOOK: Output: default@dest_g2_n0 |
| 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 |