FAQ
http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out b/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out
index 6e0ca32..e19d1de 100644
--- a/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out
+++ b/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out
@@ -4086,22 +4086,22 @@ STAGE PLANS:
              Filter Operator
                isSamplingPred: false
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: string)
                    mode: final
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 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: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
                      tag: 0
                      value expressions: _col1 (type: bigint)
                      auto parallelism: false
@@ -4112,22 +4112,22 @@ STAGE PLANS:
              Filter Operator
                isSamplingPred: false
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: string)
                    mode: final
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 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: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
                      tag: 1
                      value expressions: _col1 (type: bigint)
                      auto parallelism: false
@@ -4193,17 +4193,17 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col3
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: UDFToInteger(_col0) (type: int), UDFToInteger((_col1 + _col3)) (type: int)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
                GlobalTableId: 1
  #### A masked pattern was here ####
                NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
  #### A masked pattern was here ####
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
@@ -4399,22 +4399,22 @@ STAGE PLANS:
              Filter Operator
                isSamplingPred: false
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), val (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: string), _col1 (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: _col0 (type: string), _col1 (type: string)
                      sort order: ++
                      Map-reduce partition columns: rand() (type: double)
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                      tag: -1
                      value expressions: _col2 (type: bigint)
                      auto parallelism: false
@@ -4478,7 +4478,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: string), KEY._col1 (type: string)
            mode: partials
            outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              GlobalTableId: 0
@@ -4506,7 +4506,7 @@ STAGE PLANS:
                key expressions: _col0 (type: string), _col1 (type: string)
                sort order: ++
                Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                tag: -1
                value expressions: _col2 (type: bigint)
                auto parallelism: false
@@ -4542,7 +4542,7 @@ STAGE PLANS:
            keys: KEY._col0 (type: string), KEY._col1 (type: string)
            mode: final
            outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              GlobalTableId: 0
@@ -4571,22 +4571,22 @@ STAGE PLANS:
              Filter Operator
                isSamplingPred: false
                predicate: key is not null (type: boolean)
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                  Group By Operator
                    aggregations: count(1)
                    keys: _col0 (type: string)
                    mode: final
                    outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 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: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
                      tag: 0
                      value expressions: _col1 (type: bigint)
                      auto parallelism: false
@@ -4596,7 +4596,7 @@ STAGE PLANS:
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
                tag: 1
                value expressions: _col1 (type: string), _col2 (type: bigint)
                auto parallelism: false
@@ -4683,13 +4683,13 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              GlobalTableId: 0
  #### A masked pattern was here ####
              NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 13 Basic stats: COMPLETE Column stats: NONE
  #### A masked pattern was here ####
              table:
                  input format: org.apache.hadoop.mapred.TextInputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/having2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/having2.q.out b/ql/src/test/results/clientpositive/having2.q.out
index 4375019..65d97d0 100644
--- a/ql/src/test/results/clientpositive/having2.q.out
+++ b/ql/src/test/results/clientpositive/having2.q.out
@@ -290,16 +290,16 @@ 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), value (type: string)
                  outputColumnNames: _col0, _col1
- 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
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -309,17 +309,17 @@ STAGE PLANS:
              0 _col1 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col2, _col4
- 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: double), _col0 (type: double), _col4 (type: string)
              outputColumnNames: _col1, _col2, _col0, _col4
- 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: sum(_col2), avg(_col0), count(_col4)
                keys: _col1 (type: string)
                mode: hash
                outputColumnNames: _col0, _col1, _col2, _col3
- 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:
@@ -335,7 +335,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: double), _col2 (type: struct<count:bigint,sum:double,input:double>), _col3 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -343,17 +343,17 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1, _col2, _col3
- 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
            Filter Operator
              predicate: (((_col1 <= 4074689.000000041) and (_col2 <= 822.0)) and (_col3 > 4)) (type: boolean)
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: _col0 (type: string)
                outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -413,16 +413,16 @@ 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), value (type: string)
                  outputColumnNames: _col0, _col1
- 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
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -432,17 +432,17 @@ STAGE PLANS:
              0 _col1 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col2, _col4
- 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: double), _col0 (type: double), _col4 (type: string)
              outputColumnNames: _col1, _col2, _col0, _col4
- 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: sum(_col2), avg(_col0), count(_col4)
                keys: _col1 (type: string)
                mode: hash
                outputColumnNames: _col0, _col1, _col2, _col3
- 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:
@@ -458,7 +458,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: double), _col2 (type: struct<count:bigint,sum:double,input:double>), _col3 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -466,17 +466,17 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1, _col2, _col3
- 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
            Filter Operator
              predicate: (((_col1 <= 4074689.000000041) and (_col2 <= 822.0)) and (_col3 > 4)) (type: boolean)
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: _col0 (type: string)
                outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -536,16 +536,16 @@ 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), value (type: string)
                  outputColumnNames: _col0, _col1
- 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
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -555,17 +555,17 @@ STAGE PLANS:
              0 _col1 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1, _col2, _col4
- 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: double), _col0 (type: double), _col4 (type: string)
              outputColumnNames: _col1, _col2, _col0, _col4
- 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: sum(_col2), avg(_col0), count(_col4)
                keys: _col1 (type: string)
                mode: hash
                outputColumnNames: _col0, _col1, _col2, _col3
- 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:
@@ -581,7 +581,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: double), _col2 (type: struct<count:bigint,sum:double,input:double>), _col3 (type: bigint)
        Reduce Operator Tree:
          Group By Operator
@@ -589,17 +589,17 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1, _col2, _col3
- 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
            Filter Operator
              predicate: (((_col1 <= 4074689.000000041) and (_col2 <= 822.0)) and (_col3 > 4)) (type: boolean)
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: _col0 (type: string), _col0 (type: string)
                outputColumnNames: _col0, _col1
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 Basic stats: COMPLETE Column stats: NONE
                File Output Operator
                  compressed: false
- Statistics: Num rows: 5 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 106 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/identity_project_remove_skip.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out b/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out
index 168f9d0..1a4b764 100644
--- a/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out
+++ b/ql/src/test/results/clientpositive/identity_project_remove_skip.q.out
@@ -36,16 +36,16 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: ((key is not null and (value = 'val_105')) and (key = '105')) (type: boolean)
- Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
                Select Operator
- Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: '105' (type: string)
                    sort order: +
- Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Select Operator
- Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
              table:
@@ -142,7 +142,7 @@ STAGE PLANS:
                key expressions: '105' (type: string)
                sort order: +
                Map-reduce partition columns: '105' (type: string)
- Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
            TableScan
              Reduce Output Operator
                key expressions: '105' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out b/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
index 14e2505..be576b2 100644
--- a/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
+++ b/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
@@ -22,33 +22,33 @@ STAGE PLANS:
              alias: a
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and key is not null) (type: boolean)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 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: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: b
              Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 80.0)) and (UDFToDouble(key) < 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 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: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -57,10 +57,10 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
              table:
                  input format: org.apache.hadoop.mapred.TextInputFormat
                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -220,15 +220,15 @@ STAGE PLANS:
        Map Operator Tree:
            TableScan
              alias: default__src_src_index__
- filterExpr: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
+ filterExpr: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
              Filter Operator
- predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
+ predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint)
- outputColumnNames: _col1, _col2
+ outputColumnNames: _bucketname, _offset
                  Group By Operator
- aggregations: collect_set(_col2)
- keys: _col1 (type: string)
+ aggregations: collect_set(_offset)
+ keys: _bucketname (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1
                    Reduce Output Operator
@@ -260,20 +260,20 @@ STAGE PLANS:
        Map Operator Tree:
            TableScan
              alias: a
- filterExpr: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and key is not null) (type: boolean)
+ filterExpr: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and key is not null) (type: boolean)
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and key is not null) (type: boolean)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 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: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: b
@@ -281,16 +281,16 @@ STAGE PLANS:
              Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 80.0)) and (UDFToDouble(key) < 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 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: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -299,10 +299,10 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
              table:
                  input format: org.apache.hadoop.mapred.TextInputFormat
                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -318,10 +318,10 @@ STAGE PLANS:
                predicate: (((((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 80.0)) and (UDFToDouble(key) < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint)
- outputColumnNames: _col1, _col2
+ outputColumnNames: _bucketname, _offset
                  Group By Operator
- aggregations: collect_set(_col2)
- keys: _col1 (type: string)
+ aggregations: collect_set(_offset)
+ keys: _bucketname (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1
                    Reduce Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
index c39c272..3ca37b3 100644
--- a/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
+++ b/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
@@ -22,33 +22,33 @@ STAGE PLANS:
              alias: a
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and key is not null) (type: boolean)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 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: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: b
              Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 80.0)) and (UDFToDouble(key) < 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 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: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -57,10 +57,10 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
              table:
                  input format: org.apache.hadoop.mapred.TextInputFormat
                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -227,9 +227,9 @@ STAGE PLANS:
        Map Operator Tree:
            TableScan
              alias: default__src_src_index__
- filterExpr: ((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) (type: boolean)
+ filterExpr: ((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) (type: boolean)
              Filter Operator
- predicate: ((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) (type: boolean)
+ predicate: ((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offsets (type: array<bigint>)
                  outputColumnNames: _col0, _col1
@@ -260,20 +260,20 @@ STAGE PLANS:
        Map Operator Tree:
            TableScan
              alias: a
- filterExpr: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and key is not null) (type: boolean)
+ filterExpr: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and key is not null) (type: boolean)
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) > 70.0)) and (UDFToDouble(key) < 90.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 70.0)) and key is not null) (type: boolean)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 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: 3 Data size: 31 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col1 (type: string)
            TableScan
              alias: b
@@ -281,16 +281,16 @@ STAGE PLANS:
              Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (UDFToDouble(key) > 80.0)) and (UDFToDouble(key) < 100.0)) and key is not null) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string)
                  outputColumnNames: _col0
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 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: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -299,10 +299,10 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 13 Data size: 139 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 26 Data size: 279 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/index_auto_self_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_auto_self_join.q.out b/ql/src/test/results/clientpositive/index_auto_self_join.q.out
index e8c23dc..3cc1d7e 100644
--- a/ql/src/test/results/clientpositive/index_auto_self_join.q.out
+++ b/ql/src/test/results/clientpositive/index_auto_self_join.q.out
@@ -21,32 +21,32 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and value is not null) (type: boolean)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col1 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col0 (type: string)
            TableScan
              alias: a
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and value is not null) (type: boolean)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0)) and value is not null) (type: boolean)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col1 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col0 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -56,14 +56,14 @@ STAGE PLANS:
              0 _col1 (type: string)
              1 _col1 (type: string)
            outputColumnNames: _col0, _col2
- Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: string), _col2 (type: string)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
- Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -137,10 +137,10 @@ STAGE PLANS:
                predicate: (((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint)
- outputColumnNames: _col1, _col2
+ outputColumnNames: _bucketname, _offset
                  Group By Operator
- aggregations: collect_set(_col2)
- keys: _col1 (type: string)
+ aggregations: collect_set(_offset)
+ keys: _bucketname (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1
                    Reduce Output Operator
@@ -176,33 +176,33 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and value is not null) (type: boolean)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col1 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col0 (type: string)
            TableScan
              alias: a
- filterExpr: (((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and value is not null) (type: boolean)
+ filterExpr: (((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0)) and value is not null) (type: boolean)
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and value is not null) (type: boolean)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0)) and value is not null) (type: boolean)
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: key (type: string), value (type: string)
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col1 (type: string)
                    sort order: +
                    Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col0 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -212,14 +212,14 @@ STAGE PLANS:
              0 _col1 (type: string)
              1 _col1 (type: string)
            outputColumnNames: _col0, _col2
- Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
            Select Operator
              expressions: _col0 (type: string), _col2 (type: string)
              outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
              File Output Operator
                compressed: false
- Statistics: Num rows: 30 Data size: 326 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -230,15 +230,15 @@ STAGE PLANS:
        Map Operator Tree:
            TableScan
              alias: default__src_src_index__
- filterExpr: (((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
+ filterExpr: (((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
              Filter Operator
- predicate: (((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
+ predicate: (((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint)
- outputColumnNames: _col1, _col2
+ outputColumnNames: _bucketname, _offset
                  Group By Operator
- aggregations: collect_set(_col2)
- keys: _col1 (type: string)
+ aggregations: collect_set(_offset)
+ keys: _bucketname (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1
                    Reduce Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/index_bitmap3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_bitmap3.q.out b/ql/src/test/results/clientpositive/index_bitmap3.q.out
index 93b4db0..a8eecb5 100644
--- a/ql/src/test/results/clientpositive/index_bitmap3.q.out
+++ b/ql/src/test/results/clientpositive/index_bitmap3.q.out
@@ -115,33 +115,33 @@ STAGE PLANS:
              alias: default__src_src1_index__
              Statistics: Num rows: 500 Data size: 46311 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((UDFToDouble(key) = 0.0) and _bucketname is not null) and _offset is not null) (type: boolean)
- Statistics: Num rows: 63 Data size: 5835 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((UDFToDouble(key) = 0.0) and _offset is not null) and _bucketname is not null) (type: boolean)
+ Statistics: Num rows: 250 Data size: 23155 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint), _bitmaps (type: array<bigint>)
                  outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 63 Data size: 5835 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23155 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string), _col1 (type: bigint)
                    sort order: ++
                    Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
- Statistics: Num rows: 63 Data size: 5835 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23155 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col2 (type: array<bigint>)
            TableScan
              alias: default__src_src2_index__
              Statistics: Num rows: 500 Data size: 48311 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((value = 'val_0') and _bucketname is not null) and _offset is not null) (type: boolean)
- Statistics: Num rows: 63 Data size: 6087 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((value = 'val_0') and _offset is not null) and _bucketname is not null) (type: boolean)
+ Statistics: Num rows: 250 Data size: 24155 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint), _bitmaps (type: array<bigint>)
                  outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 63 Data size: 6087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 24155 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string), _col1 (type: bigint)
                    sort order: ++
                    Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
- Statistics: Num rows: 63 Data size: 6087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 24155 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col2 (type: array<bigint>)
        Reduce Operator Tree:
          Join Operator
@@ -151,20 +151,20 @@ STAGE PLANS:
              0 _col0 (type: string), _col1 (type: bigint)
              1 _col0 (type: string), _col1 (type: bigint)
            outputColumnNames: _col0, _col1, _col2, _col5
- Statistics: Num rows: 69 Data size: 6418 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 25470 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (not EWAH_BITMAP_EMPTY(EWAH_BITMAP_AND(_col2,_col5))) (type: boolean)
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: _col0 (type: string), _col1 (type: bigint)
                outputColumnNames: _col0, _col1
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
                Group By Operator
                  aggregations: collect_set(_col1)
                  keys: _col0 (type: string)
                  mode: hash
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    table:
@@ -180,7 +180,7 @@ STAGE PLANS:
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: array<bigint>)
        Reduce Operator Tree:
          Group By Operator
@@ -188,10 +188,10 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 17 Data size: 1581 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 69 Data size: 6390 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 17 Data size: 1581 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 69 Data size: 6390 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/index_bitmap_auto.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_bitmap_auto.q.out b/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
index 0668bf7..d1fd59c 100644
--- a/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
+++ b/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
@@ -134,33 +134,33 @@ STAGE PLANS:
              alias: default__src_src1_index__
              Statistics: Num rows: 500 Data size: 46311 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((UDFToDouble(key) = 0.0) and _bucketname is not null) and _offset is not null) (type: boolean)
- Statistics: Num rows: 63 Data size: 5835 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((UDFToDouble(key) = 0.0) and _offset is not null) and _bucketname is not null) (type: boolean)
+ Statistics: Num rows: 250 Data size: 23155 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint), _bitmaps (type: array<bigint>)
                  outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 63 Data size: 5835 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23155 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string), _col1 (type: bigint)
                    sort order: ++
                    Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
- Statistics: Num rows: 63 Data size: 5835 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23155 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col2 (type: array<bigint>)
            TableScan
              alias: default__src_src2_index__
              Statistics: Num rows: 500 Data size: 48311 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: (((value = 'val_0') and _bucketname is not null) and _offset is not null) (type: boolean)
- Statistics: Num rows: 63 Data size: 6087 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((value = 'val_0') and _offset is not null) and _bucketname is not null) (type: boolean)
+ Statistics: Num rows: 250 Data size: 24155 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint), _bitmaps (type: array<bigint>)
                  outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 63 Data size: 6087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 24155 Basic stats: COMPLETE Column stats: NONE
                  Reduce Output Operator
                    key expressions: _col0 (type: string), _col1 (type: bigint)
                    sort order: ++
                    Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
- Statistics: Num rows: 63 Data size: 6087 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 24155 Basic stats: COMPLETE Column stats: NONE
                    value expressions: _col2 (type: array<bigint>)
        Reduce Operator Tree:
          Join Operator
@@ -170,20 +170,20 @@ STAGE PLANS:
              0 _col0 (type: string), _col1 (type: bigint)
              1 _col0 (type: string), _col1 (type: bigint)
            outputColumnNames: _col0, _col1, _col2, _col5
- Statistics: Num rows: 69 Data size: 6418 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 25470 Basic stats: COMPLETE Column stats: NONE
            Filter Operator
              predicate: (not EWAH_BITMAP_EMPTY(EWAH_BITMAP_AND(_col2,_col5))) (type: boolean)
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: _col0 (type: string), _col1 (type: bigint)
                outputColumnNames: _col0, _col1
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
                Group By Operator
                  aggregations: collect_set(_col1)
                  keys: _col0 (type: string)
                  mode: hash
                  outputColumnNames: _col0, _col1
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
                    table:
@@ -199,7 +199,7 @@ STAGE PLANS:
                key expressions: _col0 (type: string)
                sort order: +
                Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 35 Data size: 3255 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 138 Data size: 12781 Basic stats: COMPLETE Column stats: NONE
                value expressions: _col1 (type: array<bigint>)
        Reduce Operator Tree:
          Group By Operator
@@ -207,10 +207,10 @@ STAGE PLANS:
            keys: KEY._col0 (type: string)
            mode: mergepartial
            outputColumnNames: _col0, _col1
- Statistics: Num rows: 17 Data size: 1581 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 69 Data size: 6390 Basic stats: COMPLETE Column stats: NONE
            File Output Operator
              compressed: false
- Statistics: Num rows: 17 Data size: 1581 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 69 Data size: 6390 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/index_bitmap_auto_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out b/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
index 3df629e..a8fe502 100644
--- a/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
@@ -70,10 +70,10 @@ STAGE PLANS:
                predicate: ((UDFToDouble(key) = 86.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint)
- outputColumnNames: _col1, _col2
+ outputColumnNames: _bucketname, _offset
                  Group By Operator
- aggregations: collect_set(_col2)
- keys: _col1 (type: string)
+ aggregations: collect_set(_offset)
+ keys: _bucketname (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1
                    Reduce Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/index_bitmap_compression.q.out b/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
index 37a2944..d1b46d0 100644
--- a/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
+++ b/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
@@ -44,10 +44,10 @@ STAGE PLANS:
                predicate: (((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean)
                Select Operator
                  expressions: _bucketname (type: string), _offset (type: bigint)
- outputColumnNames: _col1, _col2
+ outputColumnNames: _bucketname, _offset
                  Group By Operator
- aggregations: collect_set(_col2)
- keys: _col1 (type: string)
+ aggregations: collect_set(_offset)
+ keys: _bucketname (type: string)
                    mode: hash
                    outputColumnNames: _col0, _col1
                    Reduce Output Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out b/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
index 660f6bf..61a5fa4 100644
--- a/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
+++ b/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
@@ -245,29 +245,29 @@ STAGE PLANS:
                  outputColumnNames: _col0, _col1
                  Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                  Filter Operator
- predicate: UDFToDouble(_col1) is not null (type: boolean)
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ predicate: (_col1 is not null and UDFToDouble(_col1) is not null) (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                    Reduce Output Operator
                      key expressions: UDFToDouble(_col1) (type: double)
                      sort order: +
                      Map-reduce partition columns: UDFToDouble(_col1) (type: double)
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                      value expressions: _col0 (type: string), _col1 (type: bigint)
            TableScan
              alias: src
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
- predicate: UDFToDouble(value) is not null (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ predicate: (value is not null and UDFToDouble(value) is not null) (type: boolean)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: value (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: UDFToDouble(_col0) (type: double)
                    sort order: +
                    Map-reduce partition columns: UDFToDouble(_col0) (type: double)
- 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:
@@ -276,10 +276,10 @@ STAGE PLANS:
              0 UDFToDouble(_col1) (type: double)
              1 UDFToDouble(_col0) (type: double)
            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
- 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
@@ -391,7 +391,7 @@ 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
                Sorted Merge Bucket Map Join Operator
                  condition map:
                       Inner Join 0 to 1
@@ -541,7 +541,7 @@ 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
                Sorted Merge Bucket Map 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/innerjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/innerjoin.q.out b/ql/src/test/results/clientpositive/innerjoin.q.out
index 092065d..c70544f 100644
--- a/ql/src/test/results/clientpositive/innerjoin.q.out
+++ b/ql/src/test/results/clientpositive/innerjoin.q.out
@@ -32,31 +32,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: src1
              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), value (type: string)
                  outputColumnNames: _col0, _col1
- 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
                    value expressions: _col1 (type: string)
        Reduce Operator Tree:
          Join Operator
@@ -66,14 +66,14 @@ STAGE PLANS:
              0 _col0 (type: string)
              1 _col0 (type: string)
            outputColumnNames: _col0, _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: UDFToInteger(_col0) (type: int), _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
- 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/input39.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/input39.q.out b/ql/src/test/results/clientpositive/input39.q.out
index 66d8573..9e8e4f9 100644
--- a/ql/src/test/results/clientpositive/input39.q.out
+++ b/ql/src/test/results/clientpositive/input39.q.out
@@ -76,23 +76,23 @@ STAGE PLANS:
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean)
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: key (type: string)
                  sort order: +
                  Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
            TableScan
              alias: t2
              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean)
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                Reduce Output Operator
                  key expressions: key (type: string)
                  sort order: +
                  Map-reduce partition columns: key (type: string)
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
        Reduce Operator Tree:
          Join Operator
            condition map:
@@ -100,7 +100,7 @@ STAGE PLANS:
            keys:
              0 key (type: string)
              1 key (type: string)
- Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
            Group By Operator
              aggregations: count(1)
              mode: hash

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/input_part9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/input_part9.q.out b/ql/src/test/results/clientpositive/input_part9.q.out
index d95fee4..0fbdb89 100644
--- a/ql/src/test/results/clientpositive/input_part9.q.out
+++ b/ql/src/test/results/clientpositive/input_part9.q.out
@@ -141,11 +141,11 @@ STAGE PLANS:
            Filter Operator
              isSamplingPred: false
              predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
              Select Operator
                expressions: key (type: string), value (type: string), '2008-04-08' (type: string), hr (type: string)
                outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
                ListSink

  PREHOOK: query: SELECT x.* FROM SRCPART x WHERE key IS NOT NULL AND ds = '2008-04-08'

http://git-wip-us.apache.org/repos/asf/hive/blob/d8ee05ae/ql/src/test/results/clientpositive/input_testxpath2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/input_testxpath2.q.out b/ql/src/test/results/clientpositive/input_testxpath2.q.out
index 67e270f..a0baccf 100644
--- a/ql/src/test/results/clientpositive/input_testxpath2.q.out
+++ b/ql/src/test/results/clientpositive/input_testxpath2.q.out
@@ -33,14 +33,14 @@ STAGE PLANS:
              Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
              Filter Operator
                predicate: (lint is not null and mstringstring is not null) (type: boolean)
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
                Select Operator
                  expressions: size(lint) (type: int), size(lintstring) (type: int), size(mstringstring) (type: int)
                  outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
                  File Output Operator
                    compressed: false
- Statistics: Num rows: 3 Data size: 837 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 11 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
                    table:
                        input format: org.apache.hadoop.mapred.TextInputFormat
                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 92 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