PREHOOK: query: EXPLAIN
SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL value) c1) (TOK_SELEXPR (TOK_TABLE_OR_COL key) c2)))) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL c1))) (TOK_WHERE (< (TOK_TABLE_OR_COL c2) 100))))

STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Alias -> Map Operator Tree:
        x:src 
          TableScan
            alias: src
            Filter Operator
              predicate:
                  expr: (key < 100)
                  type: boolean
              Select Operator
                expressions:
                      expr: value
                      type: string
                      expr: key
                      type: string
                outputColumnNames: _col0, _col1
                Filter Operator
                  predicate:
                      expr: (_col1 < 100)
                      type: boolean
                  Select Operator
                    expressions:
                          expr: _col0
                          type: string
                    outputColumnNames: _col0
                    File Output Operator
                      compressed: false
                      GlobalTableId: 0
                      table:
                          input format: org.apache.hadoop.mapred.TextInputFormat
                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

  Stage: Stage-0
    Fetch Operator
      limit: -1


PREHOOK: query: SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/991930201/10000
POSTHOOK: query: SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/991930201/10000
val_86
val_27
val_98
val_66
val_37
val_15
val_82
val_17
val_0
val_57
val_20
val_92
val_47
val_72
val_4
val_35
val_54
val_51
val_65
val_83
val_12
val_67
val_84
val_58
val_8
val_24
val_42
val_0
val_96
val_26
val_51
val_43
val_95
val_98
val_85
val_77
val_0
val_87
val_15
val_72
val_90
val_19
val_10
val_5
val_58
val_35
val_95
val_11
val_34
val_42
val_78
val_76
val_41
val_30
val_64
val_76
val_74
val_69
val_33
val_70
val_5
val_2
val_35
val_80
val_44
val_53
val_90
val_12
val_5
val_70
val_24
val_70
val_83
val_26
val_67
val_18
val_9
val_18
val_97
val_84
val_28
val_37
val_90
val_97