STAGE DEPENDENCIES:
  Stage-4 is a root stage
  Stage-3 depends on stages: Stage-4
  Stage-0 depends on stages: Stage-3

STAGE PLANS:
  Stage: Stage-4
    Map Reduce Local Work
      Alias -> Map Local Tables:
        b
          Fetch Operator
            limit: -1
      Alias -> Map Local Operator Tree:
        b
          TableScan
            alias: b
            Statistics: Num rows: 244733 Data size: 14341046 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: key is not null (type: boolean)
              Statistics: Num rows: 122367 Data size: 7170552 Basic stats: COMPLETE Column stats: NONE
              HashTable Sink Operator
                condition expressions:
                  0 {value1} {value2} {key}
                  1 {key} {value}
                keys:
                  0 key (type: int)
                  1 key (type: int)

  Stage: Stage-3
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: cd
            Statistics: Num rows: 2193447 Data size: 81699101 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: key is not null (type: boolean)
              Statistics: Num rows: 1096724 Data size: 40849569 Basic stats: COMPLETE Column stats: NONE
              Map Join Operator
                condition map:
                     Inner Join 0 to 1
                condition expressions:
                  0 {value1} {value2} {key}
                  1 {key} {value}
                keys:
                  0 key (type: int)
                  1 key (type: int)
                outputColumnNames: _col0, _col1, _col4
                Statistics: Num rows: 1206396 Data size: 44934526 Basic stats: COMPLETE Column stats: NONE
                Filter Operator
                  predicate: _col2 BETWEEN _col15 AND _col16 (type: boolean)
                  Statistics: Num rows: 603198 Data size: 22467263 Basic stats: COMPLETE Column stats: NONE
                  Select Operator
                    expressions: _col0 (type: int), _col1 (type: int), _col4 (type: int)
                    outputColumnNames: _col0, _col1, _col4
                    Statistics: Num rows: 603198 Data size: 22467263 Basic stats: COMPLETE Column stats: NONE
                    File Output Operator
                      compressed: true
                      Statistics: Num rows: 603198 Data size: 22467263 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
      Local Work:
        Map Reduce Local Work

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