Skip to content

Instantly share code, notes, and snippets.

@wyukawa
Created May 20, 2012 07:01
Show Gist options
  • Save wyukawa/2757110 to your computer and use it in GitHub Desktop.
Save wyukawa/2757110 to your computer and use it in GitHub Desktop.
insert selectした場合のexplain実行結果
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME hoge))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME piyo))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
Stage-4
Stage-0 depends on stages: Stage-4, Stage-3
Stage-2 depends on stages: Stage-0
Stage-3
STAGE PLANS:
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
hoge
TableScan
alias: hoge
Select Operator
expressions:
expr: aaa
type: string
outputColumnNames: _col0
File Output Operator
compressed: false
GlobalTableId: 1
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.piyo
Stage: Stage-5
Conditional Operator
Stage: Stage-4
Move Operator
files:
hdfs directory: true
destination: file:/tmp/hive-wyukawa/hive_2012-05-20_15-42-48_828_2277773137428089858/-ext-10000
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.piyo
Stage: Stage-2
Stats-Aggr Operator
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
file:/tmp/hive-wyukawa/hive_2012-05-20_15-42-48_828_2277773137428089858/-ext-10002
File Output Operator
compressed: false
GlobalTableId: 0
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.piyo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment