FAQ
http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/correlationoptimizer3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer3.q.out b/ql/src/test/results/clientpositive/correlationoptimizer3.q.out
index 8510b50..0c1c97c 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer3.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer3.q.out
@@ -43,31 +43,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: x
              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)
        Reduce Operator Tree:
          Join Operator
@@ -77,11 +77,11 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col1, _col2
- 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
            Select Operator
              expressions: _col1 (type: string), _col2 (type: string)
              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
              File Output Operator
                compressed: false
                table:
@@ -97,14 +97,14 @@ STAGE PLANS:
                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: string)
            TableScan
              Reduce Output Operator
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- 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
                value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Join Operator
@@ -114,11 +114,11 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: hash(_col0) (type: int), hash(_col3) (type: int), hash(_col1) (type: int)
              outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
              Group By Operator
                aggregations: sum(_col0), sum(_col1), sum(_col2)
                mode: hash
@@ -161,31 +161,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: x
              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
                  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
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -194,17 +194,17 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _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
            Select Operator
              expressions: _col1 (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
                File Output Operator
                  compressed: false
                  table:
@@ -220,7 +220,7 @@ STAGE PLANS:
                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)
        Reduce Operator Tree:
          Group By Operator
@@ -228,7 +228,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:
@@ -289,65 +289,65 @@ 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: x
              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: y
              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: x
              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
                  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
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 526 Data size: 5510 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1050 Data size: 11006 Basic stats: COMPLETE Column stats: NONE
            Join Operator
              condition map:
                   Inner Join 0 to 1
@@ -517,11 +517,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)
@@ -532,11 +532,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)
@@ -550,11 +550,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
@@ -562,27 +562,27 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col1, _col2
- 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
                    Select Operator
                      expressions: _col1 (type: string), _col2 (type: string)
                      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: string)
            TableScan
              alias: y
              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
@@ -590,30 +590,30 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _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
                    Select Operator
                      expressions: _col1 (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: 550 Data size: 5842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
            Mux Operator
- Statistics: Num rows: 825 Data size: 8763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1650 Data size: 17529 Basic stats: COMPLETE Column stats: NONE
              Join Operator
                condition map:
                     Inner Join 0 to 1
@@ -642,9 +642,9 @@ STAGE PLANS:
              keys: KEY._col0 (type: string)
              mode: mergepartial
              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
              Mux Operator
- Statistics: Num rows: 825 Data size: 8763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1650 Data size: 17529 Basic stats: COMPLETE Column stats: NONE
                Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -747,31 +747,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: x
              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)
        Reduce Operator Tree:
          Join Operator
@@ -781,11 +781,11 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col1, _col2
- 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
            Select Operator
              expressions: _col1 (type: string), _col2 (type: string)
              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
              File Output Operator
                compressed: false
                table:
@@ -801,14 +801,14 @@ STAGE PLANS:
                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: string)
            TableScan
              Reduce Output Operator
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- 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
                value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Join Operator
@@ -818,11 +818,11 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col1, _col2, _col3
- Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: hash(_col2) (type: int), hash(_col3) (type: int), hash(_col1) (type: int)
              outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
              Group By Operator
                aggregations: sum(_col0), sum(_col1), sum(_col2)
                mode: hash
@@ -865,31 +865,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: x
              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
                  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
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -898,17 +898,17 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _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
            Select Operator
              expressions: _col1 (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
                File Output Operator
                  compressed: false
                  table:
@@ -924,7 +924,7 @@ STAGE PLANS:
                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)
        Reduce Operator Tree:
          Group By Operator
@@ -932,7 +932,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:
@@ -993,65 +993,65 @@ 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: x
              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: y
              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: x
              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
                  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
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 526 Data size: 5510 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1050 Data size: 11006 Basic stats: COMPLETE Column stats: NONE
            Join Operator
              condition map:
                   Inner Join 0 to 1
@@ -1221,11 +1221,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)
@@ -1236,11 +1236,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)
@@ -1254,11 +1254,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
@@ -1266,27 +1266,27 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _col1, _col2
- 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
                    Select Operator
                      expressions: _col1 (type: string), _col2 (type: string)
                      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: string)
            TableScan
              alias: y
              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
@@ -1294,30 +1294,30 @@ STAGE PLANS:
                      0 _col0 (type: string)
                      1 _col0 (type: string)
                    outputColumnNames: _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
                    Select Operator
                      expressions: _col1 (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: 550 Data size: 5842 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
            Mux Operator
- Statistics: Num rows: 825 Data size: 8763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1650 Data size: 17529 Basic stats: COMPLETE Column stats: NONE
              Join Operator
                condition map:
                     Inner Join 0 to 1
@@ -1346,9 +1346,9 @@ STAGE PLANS:
              keys: KEY._col0 (type: string)
              mode: mergepartial
              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
              Mux Operator
- Statistics: Num rows: 825 Data size: 8763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1650 Data size: 17529 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/correlationoptimizer4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer4.q.out b/ql/src/test/results/clientpositive/correlationoptimizer4.q.out
index 2138e6f..6ab55fe 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer4.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer4.q.out
@@ -81,46 +81,46 @@ STAGE PLANS:
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 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: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: y
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 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: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: z
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 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: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -131,17 +131,17 @@ STAGE PLANS:
              1 _col0 (type: int)
              2 _col0 (type: int)
            outputColumnNames: _col1
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col1 (type: int)
              outputColumnNames: _col0
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
              Group By Operator
                aggregations: count(1)
                keys: _col0 (type: int)
                mode: hash
                outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
                  table:
@@ -157,7 +157,7 @@ STAGE PLANS:
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -165,11 +165,11 @@ STAGE PLANS:
            keys: KEY._col0 (type: int)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: hash(_col0) (type: int), hash(_col1) (type: int)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Group By Operator
                aggregations: sum(_col0), sum(_col1)
                mode: hash
@@ -255,49 +255,49 @@ STAGE PLANS:
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 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: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: y
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 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: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: z
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 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: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 12 Data size: 51 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 21 Data size: 90 Basic stats: COMPLETE Column stats: NONE
            Join Operator
              condition map:
                   Inner Join 0 to 1
@@ -420,11 +420,11 @@ STAGE PLANS:
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: int)
@@ -436,11 +436,11 @@ STAGE PLANS:
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: int)
@@ -455,11 +455,11 @@ STAGE PLANS:
              Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 4 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -469,22 +469,22 @@ STAGE PLANS:
                      1 _col0 (type: int)
                      2 _col0 (type: int)
                    outputColumnNames: _col1
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
                    Select Operator
                      expressions: _col1 (type: int)
                      outputColumnNames: _col0
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
                      Group By Operator
                        aggregations: count(1)
                        keys: _col0 (type: int)
                        mode: hash
                        outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
                        Reduce Output Operator
                          key expressions: _col0 (type: int)
                          sort order: +
                          Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 8 Data size: 37 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
                          value expressions: _col1 (type: bigint)
        Local Work:
          Map Reduce Local Work
@@ -494,11 +494,11 @@ STAGE PLANS:
            keys: KEY._col0 (type: int)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: hash(_col0) (type: int), hash(_col1) (type: int)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 18 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
              Group By Operator
                aggregations: sum(_col0), sum(_col1)
                mode: hash

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/correlationoptimizer5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out
index d33ca0f..f8a53a0 100644
--- a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out
+++ b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out
@@ -124,31 +124,31 @@ STAGE PLANS:
              Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 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: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: y
              Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 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: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -157,7 +157,7 @@ STAGE PLANS:
              0 _col0 (type: int)
              1 _col0 (type: int)
            outputColumnNames: _col0
- Statistics: Num rows: 799 Data size: 3198 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -173,13 +173,13 @@ STAGE PLANS:
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 799 Data size: 3198 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
            TableScan
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 29 Data size: 118 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 237 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -189,14 +189,14 @@ STAGE PLANS:
              0 _col0 (type: int)
              1 _col0 (type: int)
            outputColumnNames: _col0, _col2
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: int), _col2 (type: string)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -224,31 +224,31 @@ STAGE PLANS:
              Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 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: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: n
              Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int), val (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 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: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -258,11 +258,11 @@ STAGE PLANS:
              0 _col0 (type: int)
              1 _col0 (type: int)
            outputColumnNames: _col0, _col2
- Statistics: Num rows: 29 Data size: 118 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 237 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: int), _col2 (type: string)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 118 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 237 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
                table:
@@ -330,65 +330,65 @@ STAGE PLANS:
              Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 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: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: y
              Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 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: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: m
              Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 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: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: n
              Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int), val (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 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: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Demux Operator
- Statistics: Num rows: 1479 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2956 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
            Join Operator
              condition map:
                   Inner Join 0 to 1
@@ -543,11 +543,11 @@ STAGE PLANS:
              Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 724 Data size: 2897 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: int)
@@ -561,11 +561,11 @@ STAGE PLANS:
              Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 727 Data size: 2908 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -573,7 +573,7 @@ STAGE PLANS:
                      0 _col0 (type: int)
                      1 _col0 (type: int)
                    outputColumnNames: _col0
- Statistics: Num rows: 799 Data size: 3198 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
                    File Output Operator
                      compressed: false
                      table:
@@ -611,14 +611,14 @@ STAGE PLANS:
                  0 _col0 (type: int)
                  1 _col0 (type: int)
                outputColumnNames: _col0, _col2
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col2 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -665,14 +665,14 @@ STAGE PLANS:
                  0 _col0 (type: int)
                  1 _col0 (type: int)
                outputColumnNames: _col0, _col2
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _col0 (type: int), _col2 (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -689,13 +689,13 @@ STAGE PLANS:
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 799 Data size: 3198 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
            TableScan
              Reduce Output Operator
                key expressions: _col0 (type: int)
                sort order: +
                Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 29 Data size: 118 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 237 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -705,14 +705,14 @@ STAGE PLANS:
              0 _col0 (type: int)
              1 _col0 (type: int)
            outputColumnNames: _col0, _col2
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: int), _col2 (type: string)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
- Statistics: Num rows: 878 Data size: 3517 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -732,11 +732,11 @@ STAGE PLANS:
              Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int)
                  outputColumnNames: _col0
- Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
                  HashTable Sink Operator
                    keys:
                      0 _col0 (type: int)
@@ -750,11 +750,11 @@ STAGE PLANS:
              Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: int), val (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 140 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
                  Map Join Operator
                    condition map:
                         Inner Join 0 to 1
@@ -762,11 +762,11 @@ STAGE PLANS:
                      0 _col0 (type: int)
                      1 _col0 (type: int)
                    outputColumnNames: _col0, _col2
- Statistics: Num rows: 29 Data size: 118 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 237 Basic stats: COMPLETE Column stats: NONE
                    Select Operator
                      expressions: _col0 (type: int), _col2 (type: string)
                      outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 118 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 59 Data size: 237 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 | 100 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