PREHOOK: query: EXPLAIN
SELECT src1.key, src1.key + 1, src2.value
       FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 86
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT src1.key, src1.key + 1, src2.value
       FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 86
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: src2
            Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: ((key = 86) and key is not null) (type: boolean)
              Statistics: Num rows: 14 Data size: 1453 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: '86' (type: string)
                sort order: +
                Statistics: Num rows: 14 Data size: 1453 Basic stats: COMPLETE Column stats: NONE
                value expressions: value (type: string)
          TableScan
            alias: src1
            Statistics: Num rows: 2906 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: ((key = 86) and key is not null) (type: boolean)
              Statistics: Num rows: 727 Data size: 1454 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: '86' (type: string)
                sort order: +
                Statistics: Num rows: 727 Data size: 1454 Basic stats: COMPLETE Column stats: NONE
      Reduce Operator Tree:
        Join Operator
          condition map:
               Inner Join 0 to 1
          condition expressions:
            0 
            1 {VALUE._col0}
          outputColumnNames: _col6
          Statistics: Num rows: 799 Data size: 1599 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: '86' (type: string), 87.0 (type: double), _col6 (type: string)
            outputColumnNames: _col0, _col1, _col2
            Statistics: Num rows: 799 Data size: 1599 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              Statistics: Num rows: 799 Data size: 1599 Basic stats: COMPLETE Column stats: NONE
              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

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

PREHOOK: query: SELECT src1.key, src1.key + 1, src2.value
       FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 86
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT src1.key, src1.key + 1, src2.value
       FROM src src1 join src src2 ON src1.key = src2.key AND src1.key = 86
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
86	87.0	val_86