PREHOOK: query: CREATE TABLE myinput1_n9(key int, value int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@myinput1_n9
POSTHOOK: query: CREATE TABLE myinput1_n9(key int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@myinput1_n9
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in8.txt' INTO TABLE myinput1_n9
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@myinput1_n9
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in8.txt' INTO TABLE myinput1_n9
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@myinput1_n9
PREHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
#### A masked pattern was here ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: a
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: key (type: int)
                    null sort order: z
                    sort order: +
                    Map-reduce partition columns: key (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    value expressions: value (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Map 3 
            Map Operator Tree:
                TableScan
                  alias: b
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: value (type: int)
                    null sort order: z
                    sort order: +
                    Map-reduce partition columns: value (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    value expressions: key (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 key (type: int)
                  1 value (type: int)
                nullSafes: [true]
                outputColumnNames: _col0, _col1, _col5, _col6
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int)
                  outputColumnNames: _col0, _col1, _col2, _col3
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

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

PREHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10
100	100	100	100
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key=c.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
#### A masked pattern was here ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE)
        Reducer 3 <- Map 1 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: a
                  filterExpr: key is not null (type: boolean)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
                    predicate: key is not null (type: boolean)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      null sort order: z
                      sort order: +
                      Map-reduce partition columns: key (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                      value expressions: value (type: int)
                    Reduce Output Operator
                      key expressions: key (type: int)
                      null sort order: z
                      sort order: +
                      Map-reduce partition columns: key (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                      value expressions: value (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Map 4 
            Map Operator Tree:
                TableScan
                  alias: b
                  filterExpr: value is not null (type: boolean)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
                    predicate: value is not null (type: boolean)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: value (type: int)
                      null sort order: z
                      sort order: +
                      Map-reduce partition columns: value (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                      value expressions: key (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 key (type: int)
                  1 value (type: int)
                nullSafes: [true]
                outputColumnNames: _col0, _col1, _col5, _col6
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: _col0 (type: int)
                  null sort order: z
                  sort order: +
                  Map-reduce partition columns: _col0 (type: int)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  value expressions: _col1 (type: int), _col5 (type: int), _col6 (type: int)
        Reducer 3 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 _col0 (type: int)
                  1 key (type: int)
                outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int)
                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

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

PREHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key=c.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key=c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10	10	NULL
100	100	100	100	100	100
PREHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key<=>c.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key<=>c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
#### A masked pattern was here ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE)
        Reducer 3 <- Map 1 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: a
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: key (type: int)
                    null sort order: z
                    sort order: +
                    Map-reduce partition columns: key (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    value expressions: value (type: int)
                  Reduce Output Operator
                    key expressions: key (type: int)
                    null sort order: z
                    sort order: +
                    Map-reduce partition columns: key (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    value expressions: value (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Map 4 
            Map Operator Tree:
                TableScan
                  alias: b
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: value (type: int)
                    null sort order: z
                    sort order: +
                    Map-reduce partition columns: value (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    value expressions: key (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 key (type: int)
                  1 value (type: int)
                nullSafes: [true]
                outputColumnNames: _col0, _col1, _col5, _col6
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: _col0 (type: int)
                  null sort order: z
                  sort order: +
                  Map-reduce partition columns: _col0 (type: int)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  value expressions: _col1 (type: int), _col5 (type: int), _col6 (type: int)
        Reducer 3 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 _col0 (type: int)
                  1 key (type: int)
                nullSafes: [true]
                outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int)
                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

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

PREHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key<=>c.key
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value join myinput1_n9 c on a.key<=>c.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10	10	NULL
100	100	100	100	100	100
NULL	10	10	NULL	NULL	10
NULL	10	10	NULL	NULL	35
NULL	10	10	NULL	NULL	NULL
NULL	10	48	NULL	NULL	10
NULL	10	48	NULL	NULL	35
NULL	10	48	NULL	NULL	NULL
NULL	10	NULL	NULL	NULL	10
NULL	10	NULL	NULL	NULL	35
NULL	10	NULL	NULL	NULL	NULL
NULL	35	10	NULL	NULL	10
NULL	35	10	NULL	NULL	35
NULL	35	10	NULL	NULL	NULL
NULL	35	48	NULL	NULL	10
NULL	35	48	NULL	NULL	35
NULL	35	48	NULL	NULL	NULL
NULL	35	NULL	NULL	NULL	10
NULL	35	NULL	NULL	NULL	35
NULL	35	NULL	NULL	NULL	NULL
NULL	NULL	10	NULL	NULL	10
NULL	NULL	10	NULL	NULL	35
NULL	NULL	10	NULL	NULL	NULL
NULL	NULL	48	NULL	NULL	10
NULL	NULL	48	NULL	NULL	35
NULL	NULL	48	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	10
NULL	NULL	NULL	NULL	NULL	35
NULL	NULL	NULL	NULL	NULL	NULL
PREHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value=b.key join myinput1_n9 c on a.key<=>c.key AND a.value=c.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value=b.key join myinput1_n9 c on a.key<=>c.key AND a.value=c.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
#### A masked pattern was here ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE)
        Reducer 3 <- Map 1 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: a
                  filterExpr: value is not null (type: boolean)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
                    predicate: value is not null (type: boolean)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int), value (type: int)
                      null sort order: zz
                      sort order: ++
                      Map-reduce partition columns: key (type: int), value (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int), value (type: int)
                      null sort order: zz
                      sort order: ++
                      Map-reduce partition columns: key (type: int), value (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Map 4 
            Map Operator Tree:
                TableScan
                  alias: b
                  filterExpr: key is not null (type: boolean)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
                    predicate: key is not null (type: boolean)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: value (type: int), key (type: int)
                      null sort order: zz
                      sort order: ++
                      Map-reduce partition columns: value (type: int), key (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 key (type: int), value (type: int)
                  1 value (type: int), key (type: int)
                nullSafes: [true, false]
                outputColumnNames: _col0, _col1, _col5, _col6
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: _col0 (type: int), _col1 (type: int)
                  null sort order: zz
                  sort order: ++
                  Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  value expressions: _col5 (type: int), _col6 (type: int)
        Reducer 3 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 _col0 (type: int), _col1 (type: int)
                  1 key (type: int), value (type: int)
                nullSafes: [true, false]
                outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int)
                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

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

PREHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value=b.key join myinput1_n9 c on a.key<=>c.key AND a.value=c.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value=b.key join myinput1_n9 c on a.key<=>c.key AND a.value=c.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
100	100	100	100	100	100
NULL	10	10	NULL	NULL	10
PREHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value<=>b.key join myinput1_n9 c on a.key<=>c.key AND a.value<=>c.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value<=>b.key join myinput1_n9 c on a.key<=>c.key AND a.value<=>c.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
#### A masked pattern was here ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE)
        Reducer 3 <- Map 1 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: a
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: key (type: int), value (type: int)
                    null sort order: zz
                    sort order: ++
                    Map-reduce partition columns: key (type: int), value (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: key (type: int), value (type: int)
                    null sort order: zz
                    sort order: ++
                    Map-reduce partition columns: key (type: int), value (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Map 4 
            Map Operator Tree:
                TableScan
                  alias: b
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: value (type: int), key (type: int)
                    null sort order: zz
                    sort order: ++
                    Map-reduce partition columns: value (type: int), key (type: int)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 key (type: int), value (type: int)
                  1 value (type: int), key (type: int)
                nullSafes: [true, true]
                outputColumnNames: _col0, _col1, _col5, _col6
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: _col0 (type: int), _col1 (type: int)
                  null sort order: zz
                  sort order: ++
                  Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  value expressions: _col5 (type: int), _col6 (type: int)
        Reducer 3 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 _col0 (type: int), _col1 (type: int)
                  1 key (type: int), value (type: int)
                nullSafes: [true, true]
                outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int), _col6 (type: int), _col10 (type: int), _col11 (type: int)
                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

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

PREHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value<=>b.key join myinput1_n9 c on a.key<=>c.key AND a.value<=>c.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.value<=>b.key join myinput1_n9 c on a.key<=>c.key AND a.value<=>c.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10	10	NULL
100	100	100	100	100	100
NULL	10	10	NULL	NULL	10
NULL	NULL	NULL	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM myinput1_n9 a LEFT OUTER JOIN myinput1_n9 b ON a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM myinput1_n9 a LEFT OUTER JOIN myinput1_n9 b ON a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10
100	100	100	100
48	NULL	NULL	NULL
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM myinput1_n9 a RIGHT OUTER JOIN myinput1_n9 b ON a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM myinput1_n9 a RIGHT OUTER JOIN myinput1_n9 b ON a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10
100	100	100	100
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT * FROM myinput1_n9 a FULL OUTER JOIN myinput1_n9 b ON a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM myinput1_n9 a FULL OUTER JOIN myinput1_n9 b ON a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10
100	100	100	100
48	NULL	NULL	NULL
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1_n9 a JOIN myinput1_n9 b ON a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM myinput1_n9 a JOIN myinput1_n9 b ON a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10
100	100	100	100
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1_n9 a JOIN myinput1_n9 b ON a.key<=>b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM myinput1_n9 a JOIN myinput1_n9 b ON a.key<=>b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
10	NULL	NULL	10
100	100	100	100
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: CREATE TABLE smb_input_n1(key int, value int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@smb_input_n1
POSTHOOK: query: CREATE TABLE smb_input_n1(key int, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input_n1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in4.txt' into table smb_input_n1
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@smb_input_n1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in4.txt' into table smb_input_n1
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input_n1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in5.txt' into table smb_input_n1
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@smb_input_n1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in5.txt' into table smb_input_n1
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input_n1
PREHOOK: query: CREATE TABLE smb_input1_n4(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@smb_input1_n4
POSTHOOK: query: CREATE TABLE smb_input1_n4(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input1_n4
PREHOOK: query: CREATE TABLE smb_input2_n4(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@smb_input2_n4
POSTHOOK: query: CREATE TABLE smb_input2_n4(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input2_n4
PREHOOK: query: from smb_input_n1
insert overwrite table smb_input1_n4 select *
insert overwrite table smb_input2_n4 select *
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input_n1
PREHOOK: Output: default@smb_input1_n4
PREHOOK: Output: default@smb_input2_n4
POSTHOOK: query: from smb_input_n1
insert overwrite table smb_input1_n4 select *
insert overwrite table smb_input2_n4 select *
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input_n1
POSTHOOK: Output: default@smb_input1_n4
POSTHOOK: Output: default@smb_input2_n4
POSTHOOK: Lineage: smb_input1_n4.key SIMPLE [(smb_input_n1)smb_input_n1.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: smb_input1_n4.value SIMPLE [(smb_input_n1)smb_input_n1.FieldSchema(name:value, type:int, comment:null), ]
POSTHOOK: Lineage: smb_input2_n4.key SIMPLE [(smb_input_n1)smb_input_n1.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: smb_input2_n4.value SIMPLE [(smb_input_n1)smb_input_n1.FieldSchema(name:value, type:int, comment:null), ]
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a JOIN smb_input1_n4 b ON a.key <=> b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a JOIN smb_input1_n4 b ON a.key <=> b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	1000
10	100	10	1000
10	1000	10	100
10	1000	10	100
10	1000	10	1000
100	100	100	100
12	100	12	100
12	100	12	NULL
12	NULL	12	100
12	NULL	12	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	NULL	10050
NULL	10050	NULL	35
NULL	10050	NULL	NULL
NULL	35	NULL	10050
NULL	35	NULL	35
NULL	35	NULL	NULL
NULL	NULL	NULL	10050
NULL	NULL	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a JOIN smb_input1_n4 b ON a.key <=> b.key AND a.value <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a JOIN smb_input1_n4 b ON a.key <=> b.key AND a.value <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	1000	10	1000
100	100	100	100
12	100	12	100
12	NULL	12	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	NULL	10050
NULL	35	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a RIGHT OUTER JOIN smb_input1_n4 b ON a.key <=> b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a RIGHT OUTER JOIN smb_input1_n4 b ON a.key <=> b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	1000
10	100	10	1000
10	1000	10	100
10	1000	10	100
10	1000	10	1000
100	100	100	100
12	100	12	100
12	100	12	NULL
12	NULL	12	100
12	NULL	12	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	NULL	10050
NULL	10050	NULL	35
NULL	10050	NULL	NULL
NULL	35	NULL	10050
NULL	35	NULL	35
NULL	35	NULL	NULL
NULL	NULL	NULL	10050
NULL	NULL	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a JOIN smb_input1_n4 b ON a.key <=> b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a JOIN smb_input1_n4 b ON a.key <=> b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	1000
10	100	10	1000
10	1000	10	100
10	1000	10	100
10	1000	10	1000
100	100	100	100
12	100	12	100
12	100	12	NULL
12	NULL	12	100
12	NULL	12	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	NULL	10050
NULL	10050	NULL	35
NULL	10050	NULL	NULL
NULL	35	NULL	10050
NULL	35	NULL	35
NULL	35	NULL	NULL
NULL	NULL	NULL	10050
NULL	NULL	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a LEFT OUTER JOIN smb_input1_n4 b ON a.key <=> b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a LEFT OUTER JOIN smb_input1_n4 b ON a.key <=> b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	1000
10	100	10	1000
10	1000	10	100
10	1000	10	100
10	1000	10	1000
100	100	100	100
12	100	12	100
12	100	12	NULL
12	NULL	12	100
12	NULL	12	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	NULL	10050
NULL	10050	NULL	35
NULL	10050	NULL	NULL
NULL	35	NULL	10050
NULL	35	NULL	35
NULL	35	NULL	NULL
NULL	NULL	NULL	10050
NULL	NULL	NULL	35
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a JOIN smb_input2_n4 b ON a.key <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a JOIN smb_input2_n4 b ON a.key <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
35	10035	NULL	35
NULL	10050	12	NULL
NULL	10050	NULL	NULL
NULL	35	12	NULL
NULL	35	NULL	NULL
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a JOIN smb_input2_n4 b ON a.key <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a JOIN smb_input2_n4 b ON a.key <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
35	10035	NULL	35
NULL	10050	12	NULL
NULL	10050	NULL	NULL
NULL	35	12	NULL
NULL	35	NULL	NULL
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a LEFT OUTER JOIN smb_input2_n4 b ON a.key <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input1_n4 a LEFT OUTER JOIN smb_input2_n4 b ON a.key <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
10	100	NULL	NULL
10	100	NULL	NULL
10	1000	NULL	NULL
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
12	100	NULL	NULL
12	NULL	NULL	NULL
15	10015	NULL	NULL
20	10020	NULL	NULL
25	10025	NULL	NULL
30	10030	NULL	NULL
35	10035	NULL	35
40	10040	NULL	NULL
40	10040	NULL	NULL
5	10005	NULL	NULL
50	10050	NULL	NULL
50	10050	NULL	NULL
50	10050	NULL	NULL
60	10040	NULL	NULL
60	10040	NULL	NULL
70	10040	NULL	NULL
70	10040	NULL	NULL
80	10040	NULL	NULL
80	10040	NULL	NULL
NULL	10050	12	NULL
NULL	10050	NULL	NULL
NULL	35	12	NULL
NULL	35	NULL	NULL
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a RIGHT OUTER JOIN smb_input2_n4 b ON a.key <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input1_n4
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input1_n4 a RIGHT OUTER JOIN smb_input2_n4 b ON a.key <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input1_n4
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
35	10035	NULL	35
NULL	10050	12	NULL
NULL	10050	NULL	NULL
NULL	35	12	NULL
NULL	35	NULL	NULL
NULL	NULL	10	1000
NULL	NULL	12	NULL
NULL	NULL	15	10015
NULL	NULL	20	10020
NULL	NULL	25	10025
NULL	NULL	30	10030
NULL	NULL	35	10035
NULL	NULL	40	10040
NULL	NULL	40	10040
NULL	NULL	5	10005
NULL	NULL	50	10050
NULL	NULL	50	10050
NULL	NULL	50	10050
NULL	NULL	60	10040
NULL	NULL	60	10040
NULL	NULL	70	10040
NULL	NULL	70	10040
NULL	NULL	80	10040
NULL	NULL	80	10040
NULL	NULL	NULL	10050
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2_n4 a JOIN smb_input2_n4 b ON a.value <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2_n4 a JOIN smb_input2_n4 b ON a.value <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	100	100
10	100	100	100
10	100	12	100
10	100	12	100
10	1000	10	1000
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
12	100	10	100
12	100	10	100
12	100	100	100
12	100	12	100
12	NULL	12	NULL
12	NULL	NULL	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	NULL	10050
50	10050	NULL	10050
50	10050	NULL	10050
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	NULL	10050
NULL	35	NULL	35
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2_n4 a RIGHT OUTER JOIN smb_input2_n4 b ON a.value <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(a) */ * FROM smb_input2_n4 a RIGHT OUTER JOIN smb_input2_n4 b ON a.value <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	100	100
10	100	100	100
10	100	12	100
10	100	12	100
10	1000	10	1000
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
12	100	10	100
12	100	10	100
12	100	100	100
12	100	12	100
12	NULL	12	NULL
12	NULL	NULL	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	NULL	10050
50	10050	NULL	10050
50	10050	NULL	10050
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	NULL	10050
NULL	35	NULL	35
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2_n4 a JOIN smb_input2_n4 b ON a.value <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2_n4 a JOIN smb_input2_n4 b ON a.value <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	100	100
10	100	100	100
10	100	12	100
10	100	12	100
10	1000	10	1000
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
12	100	10	100
12	100	10	100
12	100	100	100
12	100	12	100
12	NULL	12	NULL
12	NULL	NULL	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	NULL	10050
50	10050	NULL	10050
50	10050	NULL	10050
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	NULL	10050
NULL	35	NULL	35
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2_n4 a LEFT OUTER JOIN smb_input2_n4 b ON a.value <=> b.value
PREHOOK: type: QUERY
PREHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
POSTHOOK: query: SELECT /*+ MAPJOIN(b) */ * FROM smb_input2_n4 a LEFT OUTER JOIN smb_input2_n4 b ON a.value <=> b.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@smb_input2_n4
#### A masked pattern was here ####
10	100	10	100
10	100	10	100
10	100	10	100
10	100	10	100
10	100	100	100
10	100	100	100
10	100	12	100
10	100	12	100
10	1000	10	1000
100	100	10	100
100	100	10	100
100	100	100	100
100	100	12	100
12	100	10	100
12	100	10	100
12	100	100	100
12	100	12	100
12	NULL	12	NULL
12	NULL	NULL	NULL
15	10015	15	10015
20	10020	20	10020
25	10025	25	10025
30	10030	30	10030
35	10035	35	10035
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	40	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	60	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	70	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
40	10040	80	10040
5	10005	5	10005
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	50	10050
50	10050	NULL	10050
50	10050	NULL	10050
50	10050	NULL	10050
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	40	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	60	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	70	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
60	10040	80	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	40	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	60	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	70	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
70	10040	80	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	40	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	60	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	70	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
80	10040	80	10040
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	50	10050
NULL	10050	NULL	10050
NULL	35	NULL	35
NULL	NULL	12	NULL
NULL	NULL	NULL	NULL
PREHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.key is NULL
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: explain select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.key is NULL
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Tez
#### A masked pattern was here ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: a
                  filterExpr: key is null (type: boolean)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
                    predicate: key is null (type: boolean)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: null (type: int)
                      null sort order: z
                      sort order: +
                      Map-reduce partition columns: null (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                      value expressions: value (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Map 3 
            Map Operator Tree:
                TableScan
                  alias: b
                  filterExpr: value is null (type: boolean)
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
                    predicate: value is null (type: boolean)
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: null (type: int)
                      null sort order: z
                      sort order: +
                      Map-reduce partition columns: null (type: int)
                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                      value expressions: key (type: int)
            Execution mode: vectorized, llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Merge Join Operator
                condition map:
                     Inner Join 0 to 1
                keys:
                  0 null (type: int)
                  1 null (type: int)
                nullSafes: [true]
                outputColumnNames: _col1, _col5
                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: null (type: int), _col1 (type: int), _col5 (type: int), null (type: int)
                  outputColumnNames: _col0, _col1, _col2, _col3
                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

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

PREHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.key is NULL
PREHOOK: type: QUERY
PREHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from myinput1_n9 a join myinput1_n9 b on a.key<=>b.value AND a.key is NULL
POSTHOOK: type: QUERY
POSTHOOK: Input: default@myinput1_n9
#### A masked pattern was here ####
NULL	10	10	NULL
NULL	10	48	NULL
NULL	10	NULL	NULL
NULL	35	10	NULL
NULL	35	48	NULL
NULL	35	NULL	NULL
NULL	NULL	10	NULL
NULL	NULL	48	NULL
NULL	NULL	NULL	NULL