PREHOOK: query: explain select p1.p_size, p2.p_size 
from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey 
  right outer join part p3 on p2.p_partkey = p3.p_partkey and 
              p1.p_size > 10
PREHOOK: type: QUERY
POSTHOOK: query: explain select p1.p_size, p2.p_size 
from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey 
  right outer join part p3 on p2.p_partkey = p3.p_partkey and 
              p1.p_size > 10
POSTHOOK: type: QUERY
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
      Map Operator Tree:
          TableScan
            alias: p1
            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: p_partkey (type: int), p_size (type: int)
              outputColumnNames: _col0, _col1
              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: int)
          TableScan
            alias: p1
            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (p_size > 10) (type: boolean)
              Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: p_partkey (type: int), p_size (type: int)
                outputColumnNames: _col0, _col1
                Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: _col0 (type: int)
                  sort order: +
                  Map-reduce partition columns: _col0 (type: int)
                  Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
                  value expressions: _col1 (type: int)
      Reduce Operator Tree:
        Join Operator
          condition map:
               Right Outer Join0 to 1
          keys:
            0 _col0 (type: int)
            1 _col0 (type: int)
          outputColumnNames: _col0, _col1, _col3
          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: _col3 (type: int), _col0 (type: int), _col1 (type: int)
            outputColumnNames: _col1, _col2, _col3
            Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                  serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe

  Stage: Stage-2
    Map Reduce
      Map Operator Tree:
          TableScan
            Reduce Output Operator
              key expressions: _col2 (type: int)
              sort order: +
              Map-reduce partition columns: _col2 (type: int)
              Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
              value expressions: _col1 (type: int), _col3 (type: int)
          TableScan
            alias: p1
            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: p_partkey (type: int)
              outputColumnNames: _col0
              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
      Reduce Operator Tree:
        Join Operator
          condition map:
               Right Outer Join0 to 1
          keys:
            0 _col2 (type: int)
            1 _col0 (type: int)
          outputColumnNames: _col1, _col3
          Statistics: Num rows: 30 Data size: 3807 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: _col1 (type: int), _col3 (type: int)
            outputColumnNames: _col0, _col1
            Statistics: Num rows: 30 Data size: 3807 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              Statistics: Num rows: 30 Data size: 3807 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: explain select p1.p_size, p2.p_size 
from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey 
  right outer join part p3 on p2.p_partkey = p3.p_partkey and 
              p1.p_size > 10 and p1.p_size > p2.p_size + 10
PREHOOK: type: QUERY
POSTHOOK: query: explain select p1.p_size, p2.p_size 
from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey 
  right outer join part p3 on p2.p_partkey = p3.p_partkey and 
              p1.p_size > 10 and p1.p_size > p2.p_size + 10
POSTHOOK: type: QUERY
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
      Map Operator Tree:
          TableScan
            alias: p1
            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: p_partkey (type: int), p_size (type: int)
              outputColumnNames: _col0, _col1
              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: int)
          TableScan
            alias: p1
            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (p_size > 10) (type: boolean)
              Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: p_partkey (type: int), p_size (type: int)
                outputColumnNames: _col0, _col1
                Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: _col0 (type: int)
                  sort order: +
                  Map-reduce partition columns: _col0 (type: int)
                  Statistics: Num rows: 8 Data size: 968 Basic stats: COMPLETE Column stats: NONE
                  value expressions: _col1 (type: int)
      Reduce Operator Tree:
        Join Operator
          condition map:
               Right Outer Join0 to 1
          keys:
            0 _col0 (type: int)
            1 _col0 (type: int)
          outputColumnNames: _col0, _col1, _col3
          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
          Filter Operator
            predicate: (_col3 > (_col1 + 10)) (type: boolean)
            Statistics: Num rows: 9 Data size: 1112 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col3 (type: int), _col0 (type: int), _col1 (type: int)
              outputColumnNames: _col1, _col2, _col3
              Statistics: Num rows: 9 Data size: 1112 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
                table:
                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                    serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe

  Stage: Stage-2
    Map Reduce
      Map Operator Tree:
          TableScan
            Reduce Output Operator
              key expressions: _col2 (type: int)
              sort order: +
              Map-reduce partition columns: _col2 (type: int)
              Statistics: Num rows: 9 Data size: 1112 Basic stats: COMPLETE Column stats: NONE
              value expressions: _col1 (type: int), _col3 (type: int)
          TableScan
            alias: p1
            Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: p_partkey (type: int)
              outputColumnNames: _col0
              Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
                Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
      Reduce Operator Tree:
        Join Operator
          condition map:
               Right Outer Join0 to 1
          keys:
            0 _col2 (type: int)
            1 _col0 (type: int)
          outputColumnNames: _col1, _col3
          Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: _col1 (type: int), _col3 (type: int)
            outputColumnNames: _col0, _col1
            Statistics: Num rows: 28 Data size: 3461 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              Statistics: Num rows: 28 Data size: 3461 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