| ABSTRACT SYNTAX TREE: |
| (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_FUNCTION TOK_INT '')))))) |
| |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-2 depends on stages: Stage-1 |
| Stage-0 depends on stages: Stage-2 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Map Reduce |
| Alias -> Map Operator Tree: |
| src |
| Reduce Output Operator |
| # partition fields: -1 |
| tag: -1 |
| value expressions: |
| expr: UDFToInteger('') |
| type: int |
| Reduce Operator Tree: |
| Group By Operator |
| |
| expr: max(VALUE.0) |
| expr: avg(VALUE.0) |
| expr: count(VALUE.0) |
| expr: sum(VALUE.0) |
| expr: min(VALUE.0) |
| mode: partial1 |
| File Output Operator |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat |
| |
| Stage: Stage-2 |
| Map Reduce |
| Alias -> Map Operator Tree: |
| /tmp/hive-njain/159338588/98912587.10001 |
| Reduce Output Operator |
| # partition fields: 0 |
| tag: -1 |
| value expressions: |
| expr: 0 |
| type: string |
| expr: 1 |
| type: string |
| expr: 2 |
| type: string |
| expr: 3 |
| type: string |
| expr: 4 |
| type: string |
| Reduce Operator Tree: |
| Group By Operator |
| |
| expr: max(VALUE.0) |
| expr: avg(VALUE.1) |
| expr: count(VALUE.2) |
| expr: sum(VALUE.3) |
| expr: min(VALUE.4) |
| mode: partial2 |
| Select Operator |
| expressions: |
| expr: 2 |
| type: string |
| expr: 3 |
| type: string |
| expr: 1 |
| type: string |
| expr: 4 |
| type: string |
| expr: 0 |
| type: string |
| File Output Operator |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat |
| serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe |
| name: dest1 |
| |
| Stage: Stage-0 |
| Move Operator |
| tables: |
| replace: |
| table: |
| input format: org.apache.hadoop.mapred.TextInputFormat |
| output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat |
| serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe |
| name: dest1 |
| |
| |
| 0 NULL NULL NULL NULL |