FAQ
http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/correlationoptimizer7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer7.q.out b/ql/src/test/results/clientpositive/correlationoptimizer7.q.out
index 6514c4a..cd6f1e1 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer7.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer7.q.out
@@ -39,11 +39,11 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -57,11 +57,11 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -69,18 +69,18 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                    Group By Operator
                      aggregations: count(1)
                      keys: _col0 (type: string)
                      mode: hash
                      outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: string)
                        sort order: +
                        Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                        value expressions: _col1 (type: bigint)
        Local Work:
          Map Reduce Local Work
@@ -90,7 +90,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -111,11 +111,11 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -132,10 +132,10 @@ STAGE PLANS:
                  0 _col0 (type: string)
                  1 _col0 (type: string)
                outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
- Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -219,11 +219,11 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -237,27 +237,27 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: x
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -265,32 +265,32 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                    Group By Operator
                      aggregations: count(1)
                      keys: _col0 (type: string)
                      mode: hash
                      outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: string)
                        sort order: +
                        Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                        value expressions: _col1 (type: bigint)
        Local Work:
          Map Reduce Local Work
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 288 Data size: 3020 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 575 Data size: 6034 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              aggregations: count(VALUE._col0)
              keys: KEY._col0 (type: string)
              mode: mergepartial
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 144 Data size: 1510 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 287 Data size: 3011 Basic stats: COMPLETE Column stats: NONE
              Mux Operator
- Statistics: Num rows: 432 Data size: 4530 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 862 Data size: 9045 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -307,7 +307,7 @@ STAGE PLANS:
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
            Mux Operator
- Statistics: Num rows: 432 Data size: 4530 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 862 Data size: 9045 Basic stats: COMPLETE Column stats: NONE
              Join Operator
                condition map:
                     Inner Join 0 to 1
@@ -414,11 +414,11 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -432,11 +432,11 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -444,18 +444,18 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                    Group By Operator
                      aggregations: count(1)
                      keys: _col0 (type: string)
                      mode: hash
                      outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: string)
                        sort order: +
                        Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                        value expressions: _col1 (type: bigint)
        Local Work:
          Map Reduce Local Work
@@ -465,7 +465,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -486,11 +486,11 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -507,10 +507,10 @@ STAGE PLANS:
                  0 _col0 (type: string)
                  1 _col0 (type: string)
                outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
- Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -594,11 +594,11 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -612,27 +612,27 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: x
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -640,32 +640,32 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                    Group By Operator
                      aggregations: count(1)
                      keys: _col0 (type: string)
                      mode: hash
                      outputColumnNames: _col0, _col1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: string)
                        sort order: +
                        Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                        value expressions: _col1 (type: bigint)
        Local Work:
          Map Reduce Local Work
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 288 Data size: 3020 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 575 Data size: 6034 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              aggregations: count(VALUE._col0)
              keys: KEY._col0 (type: string)
              mode: mergepartial
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 144 Data size: 1510 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 287 Data size: 3011 Basic stats: COMPLETE Column stats: NONE
              Mux Operator
- Statistics: Num rows: 432 Data size: 4530 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 862 Data size: 9045 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -682,7 +682,7 @@ STAGE PLANS:
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
            Mux Operator
- Statistics: Num rows: 432 Data size: 4530 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 862 Data size: 9045 Basic stats: COMPLETE Column stats: NONE
              Join Operator
                condition map:
                     Inner Join 0 to 1

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
index 97b79e2..368a114 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer8.q.out
@@ -104,16 +104,16 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((UDFToDouble(key) < 20.0) or (UDFToDouble(key) > 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -291,30 +291,30 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((UDFToDouble(key) < 20.0) or (UDFToDouble(key) > 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 340 Data size: 3587 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 348 Data size: 3648 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              aggregations: count(VALUE._col0)
              keys: KEY._col0 (type: string)
              mode: mergepartial
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 170 Data size: 1793 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 174 Data size: 1824 Basic stats: COMPLETE Column stats: NONE
              Union
- Statistics: Num rows: 340 Data size: 3586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 348 Data size: 3648 Basic stats: COMPLETE Column stats: NONE
                Mux Operator
- Statistics: Num rows: 680 Data size: 7173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 696 Data size: 7296 Basic stats: COMPLETE Column stats: NONE
                  Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -339,11 +339,11 @@ STAGE PLANS:
              keys: KEY._col0 (type: string)
              mode: mergepartial
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 170 Data size: 1793 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 174 Data size: 1824 Basic stats: COMPLETE Column stats: NONE
              Union
- Statistics: Num rows: 340 Data size: 3586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 348 Data size: 3648 Basic stats: COMPLETE Column stats: NONE
                Mux Operator
- Statistics: Num rows: 680 Data size: 7173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 696 Data size: 7296 Basic stats: COMPLETE Column stats: NONE
                  Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -364,7 +364,7 @@ STAGE PLANS:
                            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
            Mux Operator
- Statistics: Num rows: 680 Data size: 7173 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 696 Data size: 7296 Basic stats: COMPLETE Column stats: NONE
              Join Operator
                condition map:
                     Inner Join 0 to 1
@@ -964,16 +964,16 @@ STAGE PLANS:
              Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((UDFToDouble(key) < 20.0) or (UDFToDouble(key) > 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 8 Data size: 61 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 16 Data size: 122 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
index 6b88aac..d32003d 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer9.q.out
@@ -55,22 +55,22 @@ STAGE PLANS:
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((c1 < 120) and (c1 > 100)) and c1 is not null) (type: boolean)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c1 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int)
                    mode: hash
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 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: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -78,7 +78,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: int)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 625 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -94,14 +94,14 @@ STAGE PLANS:
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 28 Data size: 625 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: bigint)
            TableScan
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 28 Data size: 625 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Join Operator
@@ -111,14 +111,14 @@ STAGE PLANS:
              0 _col0 (type: int)
              1 _col0 (type: int)
            outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 30 Data size: 687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 62 Data size: 1400 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: int), _col2 (type: int), _col1 (type: bigint), _col3 (type: bigint)
              outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 30 Data size: 687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 62 Data size: 1400 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
- Statistics: Num rows: 30 Data size: 687 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 62 Data size: 1400 Basic stats: COMPLETE Column stats: NONE
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -132,22 +132,22 @@ STAGE PLANS:
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((c2 > 100) and (c2 < 120)) and c2 is not null) (type: boolean)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c2 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int)
                    mode: hash
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 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: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -155,7 +155,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: int)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 625 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -227,56 +227,56 @@ STAGE PLANS:
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((c1 < 120) and (c1 > 100)) and c1 is not null) (type: boolean)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c1 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int)
                    mode: hash
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 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: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col1 (type: bigint)
            TableScan
              alias: x
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((c2 > 100) and (c2 < 120)) and c2 is not null) (type: boolean)
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c2 (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int)
                    mode: hash
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 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: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              aggregations: count(VALUE._col0)
              keys: KEY._col0 (type: int)
              mode: mergepartial
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
              Mux Operator
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -301,9 +301,9 @@ STAGE PLANS:
              keys: KEY._col0 (type: int)
              mode: mergepartial
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
              Mux Operator
- Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -387,23 +387,23 @@ STAGE PLANS:
              alias: x
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: ((c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((c1 < 120) and c3 is not null) and c1 is not null) (type: boolean)
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c1 (type: int), c3 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int), _col1 (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: _col0 (type: int), _col1 (type: string)
                      sort order: ++
                      Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col2 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -411,7 +411,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: int), KEY._col1 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 85 Data size: 1898 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -427,14 +427,14 @@ STAGE PLANS:
                key expressions: _col0 (type: int), _col1 (type: string)
                sort order: ++
                Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 85 Data size: 1898 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col2 (type: bigint)
            TableScan
              Reduce Output Operator
                key expressions: _col0 (type: int), _col1 (type: string)
                sort order: ++
                Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 14 Data size: 312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col2 (type: bigint)
        Reduce Operator Tree:
          Join Operator
@@ -444,14 +444,14 @@ STAGE PLANS:
              0 _col0 (type: int), _col1 (type: string)
              1 _col0 (type: int), _col1 (type: string)
            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 93 Data size: 2087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: int), _col1 (type: string), _col3 (type: int), _col4 (type: string), _col2 (type: bigint), _col5 (type: bigint)
              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 93 Data size: 2087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
- Statistics: Num rows: 93 Data size: 2087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 188 Data size: 4200 Basic stats: COMPLETE Column stats: NONE
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -464,23 +464,23 @@ STAGE PLANS:
              alias: x
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: ((((c2 > 100) and (c1 < 120)) and c1 is not null) and c3 is not null) (type: boolean)
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((c2 > 100) and (c1 < 120)) and c3 is not null) and c1 is not null) (type: boolean)
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c1 (type: int), c3 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int), _col1 (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: _col0 (type: int), _col1 (type: string)
                      sort order: ++
                      Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col2 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -488,7 +488,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: int), KEY._col1 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 14 Data size: 312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 1273 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -557,57 +557,57 @@ STAGE PLANS:
              alias: x
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: ((c1 < 120) and c3 is not null) (type: boolean)
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((c1 < 120) and c3 is not null) and c1 is not null) (type: boolean)
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c1 (type: int), c3 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int), _col1 (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: _col0 (type: int), _col1 (type: string)
                      sort order: ++
                      Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 171 Data size: 3819 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 342 Data size: 7639 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col2 (type: bigint)
            TableScan
              alias: x
              Statistics: Num rows: 1028 Data size: 22964 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: ((((c2 > 100) and (c1 < 120)) and c1 is not null) and c3 is not null) (type: boolean)
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((c2 > 100) and (c1 < 120)) and c3 is not null) and c1 is not null) (type: boolean)
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: c1 (type: int), c3 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: int), _col1 (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: _col0 (type: int), _col1 (type: string)
                      sort order: ++
                      Map-reduce partition columns: _col0 (type: int), _col1 (type: string)
- Statistics: Num rows: 29 Data size: 647 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 114 Data size: 2546 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col2 (type: bigint)
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 200 Data size: 4466 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 456 Data size: 10185 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              aggregations: count(VALUE._col0)
              keys: KEY._col0 (type: int), KEY._col1 (type: string)
              mode: mergepartial
              outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 100 Data size: 2233 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
              Mux Operator
- Statistics: Num rows: 200 Data size: 4466 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 456 Data size: 10184 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -632,9 +632,9 @@ STAGE PLANS:
              keys: KEY._col0 (type: int), KEY._col1 (type: string)
              mode: mergepartial
              outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 100 Data size: 2233 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 228 Data size: 5092 Basic stats: COMPLETE Column stats: NONE
              Mux Operator
- Statistics: Num rows: 200 Data size: 4466 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 456 Data size: 10184 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/cross_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cross_join.q.out b/ql/src/test/results/clientpositive/cross_join.q.out
index c543007..f36496e 100644
--- a/ql/src/test/results/clientpositive/cross_join.q.out
+++ b/ql/src/test/results/clientpositive/cross_join.q.out
@@ -131,31 +131,31 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: src
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -164,10 +164,10 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
              table:
                  input format: org.apache.hadoop.mapred.TextInputFormat
                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -328,11 +328,11 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -346,11 +346,11 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -358,10 +358,10 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                    File Output Operator
                      compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
                      table:
                          input format: org.apache.hadoop.mapred.TextInputFormat
                          output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/cross_product_check_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cross_product_check_1.q.out b/ql/src/test/results/clientpositive/cross_product_check_1.q.out
index f0fdfd3..e7d6900 100644
--- a/ql/src/test/results/clientpositive/cross_product_check_1.q.out
+++ b/ql/src/test/results/clientpositive/cross_product_check_1.q.out
@@ -86,7 +86,7 @@ STAGE PLANS:
        Processor Tree:
          ListSink

-Warning: Shuffle Join JOIN[14][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Stage-2:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[16][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Stage-2:MAPRED' is a cross product
  PREHOOK: query: explain select * from B d1 join B d2 on d1.key = d2.key join A
  PREHOOK: type: QUERY
  POSTHOOK: query: explain select * from B d1 join B d2 on d1.key = d2.key join A
@@ -105,32 +105,32 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: d1
              Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -140,7 +140,7 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -154,7 +154,7 @@ STAGE PLANS:
            TableScan
              Reduce Output Operator
                sort order:
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
            TableScan
              alias: a
@@ -190,7 +190,7 @@ STAGE PLANS:
        Processor Tree:
          ListSink

-Warning: Shuffle Join JOIN[20][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[21][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-1:MAPRED' is a cross product
  PREHOOK: query: explain select * from A join
           (select d1.key
            from B d1 join B d2 on d1.key = d2.key
@@ -216,31 +216,31 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: d1
              Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -249,12 +249,12 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              keys: _col0 (type: string)
              mode: hash
              outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
                table:
@@ -270,13 +270,13 @@ STAGE PLANS:
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Group By Operator
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -301,7 +301,7 @@ STAGE PLANS:
            TableScan
              Reduce Output Operator
                sort order:
- Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col0 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -446,7 +446,7 @@ STAGE PLANS:
        Processor Tree:
          ListSink

-Warning: Shuffle Join JOIN[24][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-2:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-2:MAPRED' is a cross product
  PREHOOK: query: explain select * from
  (select A.key from A group by key) ss join
  (select d1.key from B d1 join B d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1
@@ -507,7 +507,7 @@ STAGE PLANS:
            TableScan
              Reduce Output Operator
                sort order:
- Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col0 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -534,31 +534,31 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: d1
              Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -567,12 +567,12 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              keys: _col0 (type: string)
              mode: hash
              outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
                table:
@@ -588,13 +588,13 @@ STAGE PLANS:
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 114 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Group By Operator
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 22 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 51 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/cross_product_check_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cross_product_check_2.q.out b/ql/src/test/results/clientpositive/cross_product_check_2.q.out
index 57d1498..df438c9 100644
--- a/ql/src/test/results/clientpositive/cross_product_check_2.q.out
+++ b/ql/src/test/results/clientpositive/cross_product_check_2.q.out
@@ -93,7 +93,7 @@ STAGE PLANS:
        Processor Tree:
          ListSink

-Warning: Map Join MAPJOIN[22][bigTable=?] in task 'Stage-5:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[24][bigTable=?] in task 'Stage-5:MAPRED' is a cross product
  PREHOOK: query: explain select * from B d1 join B d2 on d1.key = d2.key join A
  PREHOOK: type: QUERY
  POSTHOOK: query: explain select * from B d1 join B d2 on d1.key = d2.key join A
@@ -120,11 +120,11 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -150,11 +150,11 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -162,7 +162,7 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
                    Map Join Operator
                      condition map:
                           Inner Join 0 to 1
@@ -187,7 +187,7 @@ STAGE PLANS:
        Processor Tree:
          ListSink

-Warning: Map Join MAPJOIN[30][bigTable=?] in task 'Stage-5:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[31][bigTable=?] in task 'Stage-5:MAPRED' is a cross product
  PREHOOK: query: explain select * from A join
           (select d1.key
            from B d1 join B d2 on d1.key = d2.key
@@ -219,11 +219,11 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -237,11 +237,11 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -249,17 +249,17 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
                    Group By Operator
                      keys: _col0 (type: string)
                      mode: hash
                      outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: string)
                        sort order: +
                        Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
        Local Work:
          Map Reduce Local Work
        Reduce Operator Tree:
@@ -267,7 +267,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 47 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -446,9 +446,9 @@ STAGE PLANS:
        Processor Tree:
          ListSink

-Warning: Map Join MAPJOIN[49][bigTable=?] in task 'Stage-7:MAPRED' is a cross product
-Warning: Map Join MAPJOIN[42][bigTable=?] in task 'Stage-6:MAPRED' is a cross product
-Warning: Shuffle Join JOIN[24][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-2:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[50][bigTable=?] in task 'Stage-7:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[43][bigTable=?] in task 'Stage-6:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Stage-2:MAPRED' is a cross product
  PREHOOK: query: explain select * from
  (select A.key from A group by key) ss join
  (select d1.key from B d1 join B d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1
@@ -589,7 +589,7 @@ STAGE PLANS:
            TableScan
              Reduce Output Operator
                sort order:
- Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 47 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col0 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -621,11 +621,11 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: string)
@@ -639,11 +639,11 @@ STAGE PLANS:
              Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 48 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 96 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -651,17 +651,17 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
                    Group By Operator
                      keys: _col0 (type: string)
                      mode: hash
                      outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
                      Reduce Output Operator
                        key expressions: _col0 (type: string)
                        sort order: +
                        Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 105 Basic stats: COMPLETE Column stats: NONE
        Local Work:
          Map Reduce Local Work
        Reduce Operator Tree:
@@ -669,7 +669,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 47 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 77 of 102 | next ›
Discussion Overview
groupcommits @
categorieshive, hadoop
postedDec 12, '15 at 6:54a
activeDec 15, '15 at 12:39a
posts102
users1
websitehive.apache.org

1 user in discussion

Jpullokk: 102 posts

People

Translate

site design / logo © 2021 Grokbase