Skip to content

Instantly share code, notes, and snippets.

@2bethere

2bethere/explain.txt

Created June 28, 2017 00:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 2bethere/bd8fe015c45506ead9060a72c47aee41 to your computer and use it in GitHub Desktop.
Save 2bethere/bd8fe015c45506ead9060a72c47aee41 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain.txt
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| Explain |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| Plan not optimized by CBO. |
| |
| Vertex dependency in root stage |
| Reducer 2 <- Map 1 (SIMPLE_EDGE) |
| |
| Stage-0 |
| Fetch Operator |
| limit:-1 |
| Stage-1 |
| Reducer 2 |
| File Output Operator [FS_255] |
| compressed:false |
| Statistics:Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| 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"} |
| Group By Operator [GBY_253] |
| | aggregations:["count(VALUE._col0)"] |
| | keys:KEY._col0 (type: int) |
| | outputColumnNames:["_col0","_col1"] |
| | Statistics:Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| |<-Map 1 [SIMPLE_EDGE] vectorized |
| Reduce Output Operator [RS_252] |
| key expressions:_col0 (type: int) |
| Map-reduce partition columns:_col0 (type: int) |
| sort order:+ |
| Statistics:Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions:_col1 (type: bigint) |
| Group By Operator [OP_258] |
| aggregations:["count()"] |
| keys:year (type: int) |
| outputColumnNames:["_col0","_col1"] |
| Statistics:Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator [FIL_257] |
| predicate:(year > 2008) (type: boolean) |
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| TableScan [TS_248] |
| alias:flights |
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment