| PREHOOK: query: CREATE TABLE test_table1_n10 (key INT, value STRING) |
| CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@test_table1_n10 |
| POSTHOOK: query: CREATE TABLE test_table1_n10 (key INT, value STRING) |
| CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@test_table1_n10 |
| PREHOOK: query: CREATE TABLE test_table2_n10 (key INT, value STRING) |
| CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@test_table2_n10 |
| POSTHOOK: query: CREATE TABLE test_table2_n10 (key INT, value STRING) |
| CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@test_table2_n10 |
| PREHOOK: query: FROM src |
| INSERT OVERWRITE TABLE test_table1_n10 SELECT * |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Output: default@test_table1_n10 |
| POSTHOOK: query: FROM src |
| INSERT OVERWRITE TABLE test_table1_n10 SELECT * |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: default@test_table1_n10 |
| POSTHOOK: Lineage: test_table1_n10.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: test_table1_n10.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| Stage-2 depends on stages: Stage-0 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Map Reduce |
| Map Operator Tree: |
| TableScan |
| alias: test_table1_n10 |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: key (type: int), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| name: default.test_table2_n10 |
| Execution mode: vectorized |
| |
| Stage: Stage-0 |
| Move Operator |
| tables: |
| replace: true |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| name: default.test_table2_n10 |
| |
| Stage: Stage-2 |
| Stats Work |
| Basic Stats Work: |
| Column Stats Desc: |
| Columns: key, value |
| Column Types: int, string |
| Table: default.test_table2_n10 |
| |
| PREHOOK: query: INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table1_n10 |
| PREHOOK: Output: default@test_table2_n10 |
| POSTHOOK: query: INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table1_n10 |
| POSTHOOK: Output: default@test_table2_n10 |
| POSTHOOK: Lineage: test_table2_n10.key SIMPLE [(test_table1_n10)test_table1_n10.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: test_table2_n10.value SIMPLE [(test_table1_n10)test_table1_n10.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: select count(*) from test_table1_n10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table1_n10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| 500 |
| PREHOOK: query: select count(*) from test_table1_n10 tablesample (bucket 2 out of 2) s |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table1_n10 tablesample (bucket 2 out of 2) s |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| 257 |
| PREHOOK: query: select count(*) from test_table2_n10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table2_n10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| 500 |
| PREHOOK: query: select count(*) from test_table2_n10 tablesample (bucket 2 out of 2) s |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table2_n10 tablesample (bucket 2 out of 2) s |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| 257 |
| PREHOOK: query: drop table test_table1_n10 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@test_table1_n10 |
| PREHOOK: Output: default@test_table1_n10 |
| POSTHOOK: query: drop table test_table1_n10 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@test_table1_n10 |
| POSTHOOK: Output: default@test_table1_n10 |
| PREHOOK: query: drop table test_table2_n10 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@test_table2_n10 |
| PREHOOK: Output: default@test_table2_n10 |
| POSTHOOK: query: drop table test_table2_n10 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@test_table2_n10 |
| POSTHOOK: Output: default@test_table2_n10 |
| PREHOOK: query: CREATE TABLE test_table1_n10 (key INT, value STRING) |
| CLUSTERED BY (key) INTO 2 BUCKETS |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@test_table1_n10 |
| POSTHOOK: query: CREATE TABLE test_table1_n10 (key INT, value STRING) |
| CLUSTERED BY (key) INTO 2 BUCKETS |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@test_table1_n10 |
| PREHOOK: query: CREATE TABLE test_table2_n10 (key INT, value STRING) |
| CLUSTERED BY (key) INTO 2 BUCKETS |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@test_table2_n10 |
| POSTHOOK: query: CREATE TABLE test_table2_n10 (key INT, value STRING) |
| CLUSTERED BY (key) INTO 2 BUCKETS |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@test_table2_n10 |
| PREHOOK: query: FROM src |
| INSERT OVERWRITE TABLE test_table1_n10 SELECT * |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Output: default@test_table1_n10 |
| POSTHOOK: query: FROM src |
| INSERT OVERWRITE TABLE test_table1_n10 SELECT * |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: default@test_table1_n10 |
| POSTHOOK: Lineage: test_table1_n10.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: test_table1_n10.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| Stage-2 depends on stages: Stage-0 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Map Reduce |
| Map Operator Tree: |
| TableScan |
| alias: test_table1_n10 |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: key (type: int), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| name: default.test_table2_n10 |
| Execution mode: vectorized |
| |
| Stage: Stage-0 |
| Move Operator |
| tables: |
| replace: true |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| name: default.test_table2_n10 |
| |
| Stage: Stage-2 |
| Stats Work |
| Basic Stats Work: |
| Column Stats Desc: |
| Columns: key, value |
| Column Types: int, string |
| Table: default.test_table2_n10 |
| |
| PREHOOK: query: INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table1_n10 |
| PREHOOK: Output: default@test_table2_n10 |
| POSTHOOK: query: INSERT OVERWRITE TABLE test_table2_n10 |
| SELECT * FROM test_table1_n10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table1_n10 |
| POSTHOOK: Output: default@test_table2_n10 |
| POSTHOOK: Lineage: test_table2_n10.key SIMPLE [(test_table1_n10)test_table1_n10.FieldSchema(name:key, type:int, comment:null), ] |
| POSTHOOK: Lineage: test_table2_n10.value SIMPLE [(test_table1_n10)test_table1_n10.FieldSchema(name:value, type:string, comment:null), ] |
| PREHOOK: query: select count(*) from test_table1_n10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table1_n10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| 500 |
| PREHOOK: query: select count(*) from test_table1_n10 tablesample (bucket 2 out of 2) s |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table1_n10 tablesample (bucket 2 out of 2) s |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table1_n10 |
| #### A masked pattern was here #### |
| 257 |
| PREHOOK: query: select count(*) from test_table2_n10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table2_n10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| 500 |
| PREHOOK: query: select count(*) from test_table2_n10 tablesample (bucket 2 out of 2) s |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from test_table2_n10 tablesample (bucket 2 out of 2) s |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@test_table2_n10 |
| #### A masked pattern was here #### |
| 257 |