Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1 Plan not optimized by CBO.
- 2
- 3 Vertex dependency in root stage
- 4 Reducer 2 <- Map 1 (SIMPLE_EDGE)
- 5
- 6 Stage-3
- 7 Stats-Aggr Operator
- 8 Stage-0
- 9 Move Operator
- 10 partition:{"task_id":"0"}
- 11 table:{"name:":"default.result_table","input format:":"org.apache.hadoop.hive.ql.io.orc.OrcInputFormat","output format:":"org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat","serde:":"org.apache.hadoop.hive.ql.io.orc.OrcSerde"}
- 12 Stage-2
- 13 Dependency Collection{}
- 14 Stage-1
- 15 Reducer 2
- 16 File Output Operator [FS_2126]
- 17 compressed:false
- 18 Statistics:Num rows: 100 Data size: 203200 Basic stats: COMPLETE Column stats: NONE
- 19 table:{"name:":"default.result_table","input format:":"org.apache.hadoop.hive.ql.io.orc.OrcInputFormat","output format:":"org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat","serde:":"org.apache.hadoop.hive.ql.io.orc.OrcSerde"}
- 20 Limit [LIM_2125]
- 21 Number of rows:100
- 22 Statistics:Num rows: 100 Data size: 203200 Basic stats: COMPLETE Column stats: NONE
- 23 Select Operator [SEL_2124]
- 24 | outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col30","_col31","_col32","_col33","_col34","_col35","_col36","_col37","_col38","_col39","_col40","_col41","_col42","_col43","_col44"]
- 25 | Statistics:Num rows: 100 Data size: 203200 Basic stats: COMPLETE Column stats: NONE
- 26 |<-Map 1 [SIMPLE_EDGE] vectorized
- 27 Reduce Output Operator [RS_2131]
- 28 sort order:
- 29 Statistics:Num rows: 100 Data size: 203200 Basic stats: COMPLETE Column stats: NONE
- 30 value expressions:_col0 (type: string), _col1 (type: string), _col2 (type: int), _col3 (type: int), _col4 (type: bigint), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: tinyint), _col9 (type: tinyint), _col10 (type: string), _col11 (type: bigint), _col12 (type: bigint), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: bigint), _col17 (type: string), _col18 (type: string), _col19 (type: string), _col20 (type: smallint), _col21 (type: string), _col22 (type: string), _col23 (type: string), _col24 (type: string), _col25 (type: int), _col26 (type: bigint), _col27 (type: tinyint), _col28 (type: int), _col29 (type: bigint), _col30 (type: tinyint), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: int), _col36 (type: bigint), _col37 (type: tinyint), _col38 (type: int), _col39 (type: bigint), _col40 (type: tinyint), _col41 (type: string), _col42 (type: int), _col43 (type: string)
- 31 Limit [LIM_2130]
- 32 Number of rows:100
- 33 Statistics:Num rows: 100 Data size: 203200 Basic stats: COMPLETE Column stats: NONE
- 34 Select Operator [OP_2129]
- 35 outputColumnNames:["_col0","_col1","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col2","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col3","_col30","_col31","_col32","_col33","_col34","_col35","_col36","_col37","_col38","_col39","_col4","_col40","_col41","_col42","_col43","_col5","_col6","_col7","_col8","_col9"]
- 36 Statistics:Num rows: 195399 Data size: 397050775 Basic stats: COMPLETE Column stats: NONE
- 37 Filter Operator [FIL_2128]
- 38 predicate:(in_info_directory_number = 79214105938) (type: boolean)
- 39 Statistics:Num rows: 195399 Data size: 397050775 Basic stats: COMPLETE Column stats: NONE
- 40 TableScan [TS_2119]
- 41 alias:data_table
- 42 Statistics:Num rows: 390798 Data size: 794101550 Basic stats: COMPLETE Column stats: NONE
Advertisement
Add Comment
Please, Sign In to add comment
