hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vg...@apache.org
Subject [40/51] [partial] hive git commit: HIVE-16811 : Estimate statistics in absence of stats (Vineet Garg, reviewed by Ashutosh Chauhan)
Date Sat, 02 Sep 2017 05:09:12 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
index e4fed11..13eecea 100644
--- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
@@ -107,19 +107,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -127,14 +127,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -144,16 +144,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col4
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col4) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 88 Data size: 16723 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -163,10 +163,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -286,19 +286,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 20 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 20 Data size: 3900 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 20 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 19 Data size: 3705 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 20 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 19 Data size: 3705 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: 20 Data size: 300 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 19 Data size: 3705 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -306,14 +306,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -323,16 +323,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col4
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col4) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 88 Data size: 16723 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -342,10 +342,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -489,19 +489,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -509,14 +509,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 168 Data size: 2816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 168 Data size: 31740 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 168 Data size: 2816 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 160 Data size: 30228 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 168 Data size: 2816 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 160 Data size: 30228 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -526,16 +526,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col4
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 184 Data size: 3097 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 176 Data size: 33250 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col4) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 184 Data size: 3097 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 176 Data size: 33250 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: 184 Data size: 3097 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 176 Data size: 33250 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -545,10 +545,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 184 Data size: 3097 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 176 Data size: 33250 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 184 Data size: 3097 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 176 Data size: 33250 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -698,19 +698,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table1
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -718,14 +718,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table2
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -735,16 +735,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col3
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col3) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 88 Data size: 16723 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -754,10 +754,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -889,19 +889,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table1
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), concat(value, value) (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -909,14 +909,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table2
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), concat(value, value) (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -926,16 +926,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col3
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col3) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 88 Data size: 16723 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -945,10 +945,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1080,19 +1080,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table1
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -1100,14 +1100,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table2
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 80 Data size: 15203 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -1117,16 +1117,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col3
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: (_col0 + _col0) (type: int), concat(_col1, _col3) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 88 Data size: 16723 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -1136,10 +1136,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 88 Data size: 16723 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 88 Data size: 16723 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/8f7c5788/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
index 67e925a..9959ba4 100644
--- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
@@ -85,19 +85,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -105,14 +105,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -122,16 +122,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), _col1 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: +-
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -141,10 +141,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -271,19 +271,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -291,14 +291,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -308,16 +308,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), _col1 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: +-
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -327,10 +327,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -457,19 +457,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -477,14 +477,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -494,16 +494,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col1 (type: int), _col0 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: +-
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -513,10 +513,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -578,19 +578,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -598,14 +598,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -615,16 +615,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col1 (type: int), _col0 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: +-
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -634,10 +634,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -705,19 +705,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -725,14 +725,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -742,16 +742,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), _col1 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: +-
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -761,10 +761,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -909,19 +909,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -929,14 +929,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -946,16 +946,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), _col1 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: +-
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -965,10 +965,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1123,19 +1123,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int), _col1 (type: int)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                        Statistics: Num rows: 10 Data size: 171 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 2011 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -1143,14 +1143,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 16531 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (key is not null and key2 is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), key2 (type: int), value (type: string)
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 84 Data size: 1651 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 76 Data size: 14956 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -1160,16 +1160,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col2, _col6
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), _col1 (type: int), concat(_col2, _col6) (type: string)
                           outputColumnNames: _col0, _col1, _col2
-                          Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                           Reduce Output Operator
                             key expressions: _col0 (type: int), _col1 (type: int)
                             sort order: --
                             Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
-                            Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col2 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -1179,10 +1179,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 83 Data size: 16451 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1816 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 83 Data size: 16451 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/8f7c5788/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
index 8691d0d..62ed4c8 100644
--- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
@@ -85,19 +85,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (((key = 0) or (key = 5)) and key is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -105,14 +105,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (((key = 0) or (key = 5)) and key is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 6 Data size: 1140 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 6 Data size: 1140 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -122,16 +122,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col4
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col4) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 11 Data size: 2145 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -141,10 +141,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -268,19 +268,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table1
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (((key = 0) or (key = 5)) and key is not null) (type: boolean)
-                    Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -288,14 +288,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table2
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: (((key = 0) or (key = 5)) and key is not null) (type: boolean)
-                    Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 6 Data size: 1140 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 6 Data size: 1140 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -305,16 +305,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col3
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col3) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 11 Data size: 2145 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: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -324,10 +324,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 92 Data size: 1548 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -457,19 +457,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table1
-                  Statistics: Num rows: 10 Data size: 150 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: ((key < 8) and ((key = 0) or (key = 5))) (type: boolean)
-                    Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1950 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: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 10 Data size: 1950 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -477,14 +477,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: test_table2
-                  Statistics: Num rows: 84 Data size: 1408 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 84 Data size: 15964 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: ((key < 8) and ((key = 0) or (key = 5))) (type: boolean)
-                    Statistics: Num rows: 28 Data size: 469 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 10 Data size: 1900 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 28 Data size: 469 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 10 Data size: 1900 Basic stats: COMPLETE Column stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -494,16 +494,16 @@ STAGE PLANS:
                         outputColumnNames: _col0, _col1, _col3
                         input vertices:
                           0 Map 1
-                        Statistics: Num rows: 30 Data size: 515 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                         Select Operator
                           expressions: _col0 (type: int), concat(_col1, _col3) (type: string)
                           outputColumnNames: _col0, _col1
-                          Statistics: Num rows: 30 Data size: 515 Basic stats: COMPLETE Column stats: NONE
+                          Statistics: Num rows: 11 Data size: 2145 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: 30 Data size: 515 Basic stats: COMPLETE Column stats: NONE
+                            Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                             value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -513,10 +513,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 30 Data size: 515 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 11 Data size: 2145 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 30 Data size: 515 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 2145 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/8f7c5788/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
index 6d941fd..434f739 100644
--- a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out
@@ -130,19 +130,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: calendar
-                  Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: year (type: int)
                     outputColumnNames: year
-                    Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
                     Group By Operator
                       aggregations: max(year)
                       mode: hash
                       outputColumnNames: _col0
-                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col0 (type: int)
             Execution mode: llap
             LLAP IO: no inputs
@@ -153,10 +153,10 @@ STAGE PLANS:
                 aggregations: max(VALUE._col0)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -707,19 +707,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: calendarp
-                  Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: year (type: int)
                     outputColumnNames: year
-                    Statistics: Num rows: 3 Data size: 36 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: NONE
                     Group By Operator
                       aggregations: max(year)
                       mode: hash
                       outputColumnNames: _col0
-                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col0 (type: int)
             Execution mode: llap
             LLAP IO: no inputs
@@ -730,10 +730,10 @@ STAGE PLANS:
                 aggregations: max(VALUE._col0)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat


Mime
View raw message