INFO : Executing command(queryId=hive_20190517103737_06e8d2e6-d560-4f09-b91e-e1f4d5ff759e): explain insert overwrite table hbase_table_1 select a.key, b.value from hbase_table_1 a join hbase_table_1 b on a.key=b.key INFO : Starting task [Stage-4:EXPLAIN] in serial mode INFO : Completed executing command(queryId=hive_20190517103737_06e8d2e6-d560-4f09-b91e-e1f4d5ff759e); Time taken: 0.01 seconds INFO : OK +----------------------------------------------------+--+ | Explain | +----------------------------------------------------+--+ | STAGE DEPENDENCIES: | | Stage-3 is a root stage | | Stage-2 depends on stages: Stage-3 | | | | STAGE PLANS: | | Stage: Stage-3 | | Map Reduce Local Work | | Alias -> Map Local Tables: | | a | | Fetch Operator | | limit: -1 | | Alias -> Map Local Operator Tree: | | a | | TableScan | | alias: a | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | Filter Operator | | predicate: key is not null (type: boolean) | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | HashTable Sink Operator | | keys: | | 0 key (type: int) | | 1 key (type: int) | | | | Stage: Stage-2 | | Map Reduce | | Map Operator Tree: | | TableScan | | alias: b | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | Filter Operator | | predicate: key is not null (type: boolean) | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | Map Join Operator | | condition map: | | Inner Join 0 to 1 | | keys: | | 0 key (type: int) | | 1 key (type: int) | | outputColumnNames: _col0, _col6 | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | Select Operator | | expressions: _col0 (type: int), _col6 (type: string) | | outputColumnNames: _col0, _col1 | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | File Output Operator | | compressed: false | | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE | | table: | | input format: org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat | | output format: org.apache.hadoop.hive.hbase.HiveHBaseTableOutputFormat | | serde: org.apache.hadoop.hive.hbase.HBaseSerDe | | name: default.hbase_table_1 | | Local Work: | | Map Reduce Local Work | | | +----------------------------------------------------+--+ 56 rows selected (0.431 seconds)