ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME cmnt))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x1) VAL001) (TOK_SELEXPR (TOK_TABLE_OR_COL x2) VAL002) (TOK_SELEXPR (TOK_TABLE_OR_COL x3) VAL003) (TOK_SELEXPR (TOK_TABLE_OR_COL x4) VAL004) (TOK_SELEXPR (TOK_TABLE_OR_COL y) VAL005)))) obj1_3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)))) v3) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME cmnt))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x1) VAL001) (TOK_SELEXPR (TOK_TABLE_OR_COL x2) VAL002) (TOK_SELEXPR (TOK_TABLE_OR_COL x3) VAL003) (TOK_SELEXPR (TOK_TABLE_OR_COL x4) VAL004) (TOK_SELEXPR (TOK_TABLE_OR_COL y) VAL005)))) obj1_3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)))) v1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count) c) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL VAL001)) mu1) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL VAL002)) mu2) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL VAL003)) mu3) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL VAL004)) mu4) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_TABLE_OR_COL VAL005)) mu5) (TOK_SELEXPR (TOK_FUNCTION stddev_pop (TOK_TABLE_OR_COL VAL001)) sd1) (TOK_SELEXPR (TOK_FUNCTION stddev_pop (TOK_TABLE_OR_COL VAL002)) sd2) (TOK_SELEXPR (TOK_FUNCTION stddev_pop (TOK_TABLE_OR_COL VAL003)) sd3) (TOK_SELEXPR (TOK_FUNCTION stddev_pop (TOK_TABLE_OR_COL VAL004)) sd4) (TOK_SELEXPR (TOK_FUNCTION stddev_pop (TOK_TABLE_OR_COL VAL005)) sd5)))) v2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST v2))) (TOK_SELEXPR (/ (* (- (TOK_TABLE_OR_COL VAL001) (TOK_TABLE_OR_COL mu1)) 1) (TOK_TABLE_OR_COL sd1)) VAL001) (TOK_SELEXPR (/ (* (- (TOK_TABLE_OR_COL VAL002) (TOK_TABLE_OR_COL mu2)) 1) (TOK_TABLE_OR_COL sd2)) VAL002) (TOK_SELEXPR (/ (* (- (TOK_TABLE_OR_COL VAL003) (TOK_TABLE_OR_COL mu3)) 1) (TOK_TABLE_OR_COL sd3)) VAL003) (TOK_SELEXPR (/ (* (- (TOK_TABLE_OR_COL VAL004) (TOK_TABLE_OR_COL mu4)) 1) (TOK_TABLE_OR_COL sd4)) VAL004) (TOK_SELEXPR (/ (* (- (TOK_TABLE_OR_COL VAL005) (TOK_TABLE_OR_COL mu5)) 1) (TOK_TABLE_OR_COL sd5)) VAL005)))) obj1_7)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL VAL001) x1) (TOK_SELEXPR (TOK_TABLE_OR_COL VAL002) x2) (TOK_SELEXPR (TOK_TABLE_OR_COL VAL003) x3) (TOK_SELEXPR (TOK_TABLE_OR_COL VAL004) x4) (TOK_SELEXPR (TOK_TABLE_OR_COL VAL005) y)))) obj1_6)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)))) STAGE DEPENDENCIES: Stage-2 is a root stage Stage-4 depends on stages: Stage-2 Stage-3 depends on stages: Stage-4 Stage-0 is a root stage STAGE PLANS: Stage: Stage-2 Map Reduce Alias -> Map Operator Tree: obj1_6:obj1_7:v2:v1:obj1_3:cmnt TableScan alias: cmnt Select Operator expressions: expr: x1 type: int expr: x2 type: int expr: x3 type: int expr: x4 type: int expr: y type: double outputColumnNames: _col0, _col1, _col2, _col3, _col4 Group By Operator aggregations: expr: count() expr: avg(_col0) expr: avg(_col1) expr: avg(_col2) expr: avg(_col3) expr: avg(_col4) expr: stddev_pop(_col0) expr: stddev_pop(_col1) expr: stddev_pop(_col2) expr: stddev_pop(_col3) expr: stddev_pop(_col4) bucketGroup: false mode: hash outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Reduce Output Operator sort order: tag: -1 value expressions: expr: _col0 type: bigint expr: _col1 type: struct expr: _col2 type: struct expr: _col3 type: struct expr: _col4 type: struct expr: _col5 type: struct expr: _col6 type: struct expr: _col7 type: struct expr: _col8 type: struct expr: _col9 type: struct expr: _col10 type: struct Reduce Operator Tree: Group By Operator aggregations: expr: count(VALUE._col0) expr: avg(VALUE._col1) expr: avg(VALUE._col2) expr: avg(VALUE._col3) expr: avg(VALUE._col4) expr: avg(VALUE._col5) expr: stddev_pop(VALUE._col6) expr: stddev_pop(VALUE._col7) expr: stddev_pop(VALUE._col8) expr: stddev_pop(VALUE._col9) expr: stddev_pop(VALUE._col10) bucketGroup: false mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Select Operator expressions: expr: _col1 type: double expr: _col10 type: double expr: _col2 type: double expr: _col3 type: double expr: _col4 type: double expr: _col5 type: double expr: _col6 type: double expr: _col7 type: double expr: _col8 type: double expr: _col9 type: double outputColumnNames: _col1, _col10, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9 File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Stage: Stage-4 Map Reduce Local Work Alias -> Map Local Tables: obj1_6:obj1_7:v3:obj1_3:cmnt Fetch Operator limit: -1 Alias -> Map Local Operator Tree: obj1_6:obj1_7:v3:obj1_3:cmnt TableScan alias: cmnt Select Operator expressions: expr: x1 type: int expr: x2 type: int expr: x3 type: int expr: x4 type: int expr: y type: double outputColumnNames: _col0, _col1, _col2, _col3, _col4 HashTable Sink Operator condition expressions: 0 1 {_col1} {_col10} {_col2} {_col3} {_col4} {_col5} {_col6} {_col7} {_col8} {_col9} handleSkewJoin: false keys: 0 [] 1 [] Position of Big Table: 1 Stage: Stage-3 Map Reduce Alias -> Map Operator Tree: $INTNAME Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 1 {_col1} {_col10} {_col2} {_col3} {_col4} {_col5} {_col6} {_col7} {_col8} {_col9} handleSkewJoin: false keys: 0 [] 1 [] outputColumnNames: _col6, _col15, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14 Position of Big Table: 1 Select Operator expressions: expr: (((_col0 - _col6) * 1) / _col11) type: double expr: (((_col1 - _col7) * 1) / _col12) type: double expr: (((_col2 - _col8) * 1) / _col13) type: double expr: (((_col3 - _col9) * 1) / _col14) type: double expr: (((_col4 - _col10) * 1) / _col15) type: double outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Local Work: Map Reduce Local Work Stage: Stage-0 Fetch Operator limit: -1