FAQ
http://git-wip-us.apache.org/repos/asf/hive/blob/4d592303/ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out b/ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out
index 9f40f9e..6e4971d 100644
--- a/ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out
+++ b/ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out
@@ -435,42 +435,42 @@ STAGE PLANS:
                        outputColumnNames: _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                        Select Operator
                          expressions: _col1 (type: string)
                          outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: string)
                            sort order: +
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
                    alias: b
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key < 15) (type: boolean)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                      Group By Operator
                        keys: key (type: int), key (type: int)
                        mode: hash
                        outputColumnNames: _col0, _col1
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col1 (type: int)
                          sort order: +
                          Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
          Reducer 2
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -616,24 +616,24 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: t3
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key > 5) (type: boolean)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int)
                        outputColumnNames: _col0
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                        Group By Operator
                          keys: _col0 (type: int)
                          mode: hash
                          outputColumnNames: _col0
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 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: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
          Map 2
              Map Operator Tree:
                  TableScan
@@ -651,24 +651,24 @@ STAGE PLANS:
                        outputColumnNames: _col1
                        input vertices:
                          1 Map 1
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                        Select Operator
                          expressions: _col1 (type: string)
                          outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: string)
                            sort order: +
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -902,10 +902,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -915,11 +915,11 @@ STAGE PLANS:
                        outputColumnNames: _col0
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -947,10 +947,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1121,15 +1121,15 @@ STAGE PLANS:
                        input vertices:
                          1 Map 3
                          2 Map 4
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                        Select Operator
                          expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string)
                          outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: int), _col1 (type: string)
                            sort order: ++
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                            value expressions: _col2 (type: int), _col3 (type: string)
          Map 3
              Map Operator Tree:
@@ -1149,33 +1149,33 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: c
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int)
                        outputColumnNames: key
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                        Group By Operator
                          keys: key (type: int)
                          mode: hash
                          outputColumnNames: _col0
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 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: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
          Reducer 2
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: int), VALUE._col1 (type: string)
                  outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1233,10 +1233,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 2 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 558 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -1246,11 +1246,11 @@ STAGE PLANS:
                        outputColumnNames: _col0, _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int), _col1 (type: string)
                          sort order: ++
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -1278,10 +1278,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1337,10 +1337,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -1353,11 +1353,11 @@ STAGE PLANS:
                        input vertices:
                          1 Map 3
                          2 Map 4
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -1407,10 +1407,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1468,7 +1468,7 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Map Join Operator
                      condition map:
                           Left Outer Join0 to 1
@@ -1481,11 +1481,11 @@ STAGE PLANS:
                      input vertices:
                        1 Map 3
                        2 Map 4
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: int)
                        sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -1520,10 +1520,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1603,12 +1603,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: b
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 5
              Map Operator Tree:
                  TableScan
@@ -1639,20 +1639,20 @@ STAGE PLANS:
                    1 key (type: int)
                    2 _col0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1725,12 +1725,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 4
              Map Operator Tree:
                  TableScan
@@ -1771,20 +1771,20 @@ STAGE PLANS:
                    1 _col0 (type: int)
                    2 key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1857,12 +1857,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 4
              Map Operator Tree:
                  TableScan
@@ -1903,20 +1903,20 @@ STAGE PLANS:
                    1 _col0 (type: int)
                    2 key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1991,12 +1991,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 4
              Map Operator Tree:
                  TableScan
@@ -2037,20 +2037,20 @@ STAGE PLANS:
                    1 _col0 (type: int)
                    2 key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2136,10 +2136,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 358 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -2149,7 +2149,7 @@ STAGE PLANS:
                        outputColumnNames: _col0, _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                        Map Join Operator
                          condition map:
                               Left Outer Join0 to 1
@@ -2159,11 +2159,11 @@ STAGE PLANS:
                          outputColumnNames: _col0
                          input vertices:
                            1 Map 4
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: int)
                            sort order: +
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -2201,10 +2201,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2282,14 +2282,14 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: ((key > 100) and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 119 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int), value (type: string)
                        outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 119 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE
                        Map Join Operator
                          condition map:
                               Left Semi Join 0 to 1
@@ -2666,43 +2666,43 @@ STAGE PLANS:
                        outputColumnNames: _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Select Operator
                          expressions: _col1 (type: string)
                          outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: string)
                            sort order: +
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
                    alias: b
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key < 15) (type: boolean)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                      Group By Operator
                        keys: key (type: int), key (type: int)
                        mode: hash
                        outputColumnNames: _col0, _col1
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col1 (type: int)
                          sort order: +
                          Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
          Reducer 2
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2849,24 +2849,24 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: t3
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key > 5) (type: boolean)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int)
                        outputColumnNames: _col0
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                        Group By Operator
                          keys: _col0 (type: int)
                          mode: hash
                          outputColumnNames: _col0
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 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: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
          Map 2
              Map Operator Tree:
                  TableScan
@@ -2884,25 +2884,25 @@ STAGE PLANS:
                        outputColumnNames: _col1
                        input vertices:
                          1 Map 1
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Select Operator
                          expressions: _col1 (type: string)
                          outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: string)
                            sort order: +
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3138,10 +3138,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -3151,12 +3151,12 @@ STAGE PLANS:
                        outputColumnNames: _col0
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -3184,10 +3184,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3359,16 +3359,16 @@ STAGE PLANS:
                        input vertices:
                          1 Map 3
                          2 Map 4
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Select Operator
                          expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string)
                          outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: int), _col1 (type: string)
                            sort order: ++
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                            value expressions: _col2 (type: int), _col3 (type: string)
          Map 3
              Map Operator Tree:
@@ -3388,33 +3388,33 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: c
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int)
                        outputColumnNames: key
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                        Group By Operator
                          keys: key (type: int)
                          mode: hash
                          outputColumnNames: _col0
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 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: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
          Reducer 2
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: int), VALUE._col1 (type: string)
                  outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3472,10 +3472,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 2 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 558 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -3485,12 +3485,12 @@ STAGE PLANS:
                        outputColumnNames: _col0, _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Reduce Output Operator
                          key expressions: _col0 (type: int), _col1 (type: string)
                          sort order: ++
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -3518,10 +3518,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3577,10 +3577,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -3593,12 +3593,12 @@ STAGE PLANS:
                        input vertices:
                          1 Map 3
                          2 Map 4
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -3648,10 +3648,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3709,7 +3709,7 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Map Join Operator
                      condition map:
                           Left Outer Join0 to 1
@@ -3722,12 +3722,12 @@ STAGE PLANS:
                      input vertices:
                        1 Map 3
                        2 Map 4
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                      HybridGraceHashJoin: true
                      Reduce Output Operator
                        key expressions: _col0 (type: int)
                        sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -3762,10 +3762,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3845,12 +3845,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: b
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 5
              Map Operator Tree:
                  TableScan
@@ -3881,20 +3881,20 @@ STAGE PLANS:
                    1 key (type: int)
                    2 _col0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3967,12 +3967,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 4
              Map Operator Tree:
                  TableScan
@@ -4013,20 +4013,20 @@ STAGE PLANS:
                    1 _col0 (type: int)
                    2 key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4099,12 +4099,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 4
              Map Operator Tree:
                  TableScan
@@ -4145,20 +4145,20 @@ STAGE PLANS:
                    1 _col0 (type: int)
                    2 key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4233,12 +4233,12 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: key (type: int)
                      sort order: +
                      Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
          Map 4
              Map Operator Tree:
                  TableScan
@@ -4279,20 +4279,20 @@ STAGE PLANS:
                    1 _col0 (type: int)
                    2 key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: int)
                    sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4378,10 +4378,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 358 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -4391,7 +4391,7 @@ STAGE PLANS:
                        outputColumnNames: _col0, _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                        HybridGraceHashJoin: true
                        Map Join Operator
                          condition map:
@@ -4402,12 +4402,12 @@ STAGE PLANS:
                          outputColumnNames: _col0
                          input vertices:
                            1 Map 4
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
                          HybridGraceHashJoin: true
                          Reduce Output Operator
                            key expressions: _col0 (type: int)
                            sort order: +
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
          Map 3
              Map Operator Tree:
                  TableScan
@@ -4445,10 +4445,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 1237 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -4526,14 +4526,14 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: ((key > 100) and value is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 119 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int), value (type: string)
                        outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 119 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 372 Basic stats: COMPLETE Column stats: NONE
                        Map Join Operator
                          condition map:
                               Left Semi Join 0 to 1
@@ -4917,44 +4917,44 @@ STAGE PLANS:
                        outputColumnNames: _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                        Select Operator
                          expressions: _col1 (type: string)
                          outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: string)
                            sort order: +
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Map 3
              Map Operator Tree:
                  TableScan
                    alias: b
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key < 15) (type: boolean)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                      Group By Operator
                        keys: key (type: int), key (type: int)
                        mode: hash
                        outputColumnNames: _col0, _col1
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col1 (type: int)
                          sort order: +
                          Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Reducer 2
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -5104,24 +5104,24 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: t3
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key > 5) (type: boolean)
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int)
                        outputColumnNames: _col0
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
                        Group By Operator
                          keys: _col0 (type: int)
                          mode: hash
                          outputColumnNames: _col0
- Statistics: Num rows: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 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: 59 Data size: 236 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 651 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Map 2
              Map Operator Tree:
@@ -5140,25 +5140,25 @@ STAGE PLANS:
                        outputColumnNames: _col1
                        input vertices:
                          1 Map 1
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                        Select Operator
                          expressions: _col1 (type: string)
                          outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: string)
                            sort order: +
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Reducer 3
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 64 Data size: 259 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 716 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -5399,10 +5399,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -5412,11 +5412,11 @@ STAGE PLANS:
                        outputColumnNames: _col0
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Map 3
              Map Operator Tree:
@@ -5446,10 +5446,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 99 Data size: 396 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 1125 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -5624,15 +5624,15 @@ STAGE PLANS:
                        input vertices:
                          1 Map 3
                          2 Map 4
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                        Select Operator
                          expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string)
                          outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                          Reduce Output Operator
                            key expressions: _col0 (type: int), _col1 (type: string)
                            sort order: ++
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                            value expressions: _col2 (type: int), _col3 (type: string)
              Execution mode: vectorized
          Map 3
@@ -5654,34 +5654,34 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: c
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Select Operator
                        expressions: key (type: int)
                        outputColumnNames: key
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                        Group By Operator
                          keys: key (type: int)
                          mode: hash
                          outputColumnNames: _col0
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 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: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Reducer 2
              Reduce Operator Tree:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string), VALUE._col0 (type: int), VALUE._col1 (type: string)
                  outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -5740,10 +5740,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 6 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 2 Data size: 238 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 558 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -5753,11 +5753,11 @@ STAGE PLANS:
                        outputColumnNames: _col0, _col1
                        input vertices:
                          1 Map 3
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int), _col1 (type: string)
                          sort order: ++
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Map 3
              Map Operator Tree:
@@ -5787,10 +5787,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 3 Data size: 306 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 613 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -5847,10 +5847,10 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Filter Operator
                      predicate: key is not null (type: boolean)
- Statistics: Num rows: 90 Data size: 360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 1023 Basic stats: COMPLETE Column stats: NONE
                      Map Join Operator
                        condition map:
                             Left Semi Join 0 to 1
@@ -5863,11 +5863,11 @@ STAGE PLANS:
                        input vertices:
                          1 Map 3
                          2 Map 4
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Map 3
              Map Operator Tree:
@@ -5920,10 +5920,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 198 Data size: 792 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 2250 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -5982,7 +5982,7 @@ STAGE PLANS:
              Map Operator Tree:
                  TableScan
                    alias: a
- Statistics: Num rows: 179 Data size: 716 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 22 Data size: 2046 Basic stats: COMPLETE Column stats: NONE
                    Map Join Operator
                      condition map:
                           Left Outer Join0 to 1
@@ -5995,11 +5995,11 @@ STAGE PLANS:
                      input vertices:
                        1 Map 3
                        2 Map 4
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: int)
                        sort order: +
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 48 Data size: 4501 Basic stats: COMPLETE Column stats: NONE
              Execution mode: vectorized
          Map 3
              Map Operator Tree:
@@ -6037,10 +6037,10 @@ STAGE PLANS:
                Select Operator
                  expressions: KEY.reducesinkkey0 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 393 Data size: 1575 Basic stats: COMPLETE Column stats: NONE
+

<TRUNCATED>

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 9 | next ›
Discussion Overview
groupcommits @
categorieshive, hadoop
postedJun 7, '15 at 6:38p
activeJun 9, '15 at 8:30p
posts9
users1
websitehive.apache.org

1 user in discussion

Vgumashta: 9 posts

People

Translate

site design / logo © 2021 Grokbase