hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vg...@apache.org
Subject [39/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:11 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out b/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
index c56c818..4cdb4861 100644
--- a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
@@ -185,14 +185,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -203,14 +203,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: val (type: string)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -273,14 +273,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -291,14 +291,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -387,38 +387,38 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 184 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: 30 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
             Execution mode: llap
             LLAP IO: no inputs
         Map 3 
             Map Operator Tree:
                 TableScan
                   alias: t2
-                  Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: string)
                         sort order: +
                         Map-reduce partition columns: _col0 (type: string)
-                        Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
             Execution mode: llap
             LLAP IO: no inputs
         Reducer 2 
@@ -431,10 +431,10 @@ STAGE PLANS:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
                 outputColumnNames: _col0
-                Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -518,19 +518,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: ((UDFToDouble(val) = 3.0) and key is not null) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string), val (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 368 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: 30 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -538,19 +538,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t2
-                  Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: ((UDFToDouble(val) = 3.0) and key is not null) (type: boolean)
-                    Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string), val (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 736 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: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -564,10 +564,10 @@ STAGE PLANS:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -620,38 +620,38 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: ((UDFToDouble(key) = 5.0) and val is not null) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: val (type: string)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 368 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: 30 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
             Execution mode: llap
             LLAP IO: no inputs
         Map 3 
             Map Operator Tree:
                 TableScan
                   alias: t2
-                  Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: ((UDFToDouble(key) = 6.0) and val is not null) (type: boolean)
-                    Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: val (type: string)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 2 Data size: 736 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: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
             Execution mode: llap
             LLAP IO: no inputs
         Reducer 2 
@@ -664,10 +664,10 @@ STAGE PLANS:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
                 outputColumnNames: _col0
-                Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -733,58 +733,58 @@ STAGE PLANS:
         Map 1 
             Map Operator Tree:
                 TableScan
-                  alias: t1
-                  Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  alias: t2
+                  Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 5 Data size: 920 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: 30 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
             Execution mode: llap
             LLAP IO: no inputs
         Map 4 
             Map Operator Tree:
                 TableScan
-                  alias: t2
-                  Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                  alias: t1
+                  Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: string)
                         sort order: +
                         Map-reduce partition columns: _col0 (type: string)
-                        Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
             Execution mode: llap
             LLAP IO: no inputs
         Map 5 
             Map Operator Tree:
                 TableScan
                   alias: t3
-                  Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
                     Select Operator
                       expressions: key (type: string), val (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: string)
                         sort order: +
                         Map-reduce partition columns: _col0 (type: string)
-                        Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
                         value expressions: _col1 (type: string)
             Execution mode: llap
             LLAP IO: no inputs
@@ -797,13 +797,17 @@ STAGE PLANS:
                 keys:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
-                outputColumnNames: _col0
-                Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
-                Reduce Output Operator
-                  key expressions: _col0 (type: string)
-                  sort order: +
-                  Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+                outputColumnNames: _col1
+                Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
+                Select Operator
+                  expressions: _col1 (type: string)
+                  outputColumnNames: _col0
+                  Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
+                  Reduce Output Operator
+                    key expressions: _col0 (type: string)
+                    sort order: +
+                    Map-reduce partition columns: _col0 (type: string)
+                    Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
         Reducer 3 
             Execution mode: llap
             Reduce Operator Tree:
@@ -814,10 +818,10 @@ STAGE PLANS:
                   0 _col0 (type: string)
                   1 _col0 (type: string)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 5 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 5 Data size: 1113 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 5 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 1113 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -850,10 +854,10 @@ PREHOOK: Input: default@t1
 PREHOOK: Input: default@t2
 PREHOOK: Input: default@t3
 #### A masked pattern was here ####
-Table:default@t1
+Table:default@t2
 Columns:key
 
-Table:default@t2
+Table:default@t1
 Columns:key
 
 Table:default@t3

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
index 75d8946..c397f80 100644
--- a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
@@ -73,22 +73,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: s
-                  Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 29 Data size: 10672 Basic stats: COMPLETE Column stats: NONE
                   Statistics Aggregation Key Prefix: default.s/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string)
                     outputColumnNames: key, value
-                    Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 29 Data size: 10672 Basic stats: COMPLETE Column stats: NONE
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         null sort order: 
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
                         tag: -1
                         value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
                         auto parallelism: false
@@ -151,13 +151,13 @@ STAGE PLANS:
                 aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 1248 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: 880 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -332,13 +332,13 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: spart
-                  Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+                  Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
                   Statistics Aggregation Key Prefix: default.spart/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
                     outputColumnNames: key, value, ds, hr
-                    Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+                    Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       keys: ds (type: string), hr (type: string)
@@ -749,13 +749,13 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: spart
-                  Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+                  Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
                   Statistics Aggregation Key Prefix: default.spart/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
                     outputColumnNames: key, value, ds, hr
-                    Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+                    Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       keys: ds (type: string), hr (type: string)
@@ -1166,13 +1166,13 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: spart
-                  Statistics: Num rows: 29 Data size: 11148 Basic stats: COMPLETE Column stats: PARTIAL
+                  Statistics: Num rows: 29 Data size: 21820 Basic stats: COMPLETE Column stats: PARTIAL
                   Statistics Aggregation Key Prefix: default.spart/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string), ds (type: string)
                     outputColumnNames: key, value, ds
-                    Statistics: Num rows: 29 Data size: 11148 Basic stats: COMPLETE Column stats: PARTIAL
+                    Statistics: Num rows: 29 Data size: 21820 Basic stats: COMPLETE Column stats: PARTIAL
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       keys: ds (type: string), '11' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
index c84a37d..c719976 100644
--- a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
@@ -74,22 +74,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: s
-                  Statistics: Num rows: 1 Data size: 170 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                   Statistics Aggregation Key Prefix: default.s/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string)
                     outputColumnNames: key, value
-                    Statistics: Num rows: 1 Data size: 170 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
                       Reduce Output Operator
                         null sort order: 
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+                        Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
                         tag: -1
                         value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
                         auto parallelism: false
@@ -154,13 +154,13 @@ STAGE PLANS:
                 aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1 Data size: 1248 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: 880 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
 #### A masked pattern was here ####
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -329,13 +329,13 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: spart
-                  Statistics: Num rows: 2 Data size: 1076 Basic stats: COMPLETE Column stats: PARTIAL
+                  Statistics: Num rows: 2 Data size: 1812 Basic stats: COMPLETE Column stats: PARTIAL
                   Statistics Aggregation Key Prefix: default.spart/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
                     outputColumnNames: key, value, ds, hr
-                    Statistics: Num rows: 2 Data size: 1076 Basic stats: COMPLETE Column stats: PARTIAL
+                    Statistics: Num rows: 2 Data size: 1812 Basic stats: COMPLETE Column stats: PARTIAL
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       keys: ds (type: string), hr (type: string)
@@ -734,13 +734,13 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: spart
-                  Statistics: Num rows: 1 Data size: 354 Basic stats: COMPLETE Column stats: PARTIAL
+                  Statistics: Num rows: 1 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
                   Statistics Aggregation Key Prefix: default.spart/
                   GatherStats: true
                   Select Operator
                     expressions: key (type: string), value (type: string), ds (type: string)
                     outputColumnNames: key, value, ds
-                    Statistics: Num rows: 1 Data size: 354 Basic stats: COMPLETE Column stats: PARTIAL
+                    Statistics: Num rows: 1 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
                     Group By Operator
                       aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
                       keys: ds (type: string), '11' (type: string)

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
index 8f51db3..a147d15 100644
--- a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
+++ b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
@@ -52,34 +52,34 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_17]
-        Merge Join Operator [MERGEJOIN_21] (rows=1 width=0)
+        Merge Join Operator [MERGEJOIN_21] (rows=1 width=4)
           Conds:RS_13._col0=RS_14._col0(Left Outer),Output:["_col0"]
         <-Map 1 [SIMPLE_EDGE] llap
           SHUFFLE [RS_13]
             PartitionCols:_col0
-            Select Operator [SEL_1] (rows=1 width=0)
+            Select Operator [SEL_1] (rows=1 width=4)
               Output:["_col0"]
-              TableScan [TS_0] (rows=1 width=0)
-                default@tb1,a,Tbl:PARTIAL,Col:NONE,Output:["id"]
+              TableScan [TS_0] (rows=1 width=4)
+                default@tb1,a,Tbl:COMPLETE,Col:NONE,Output:["id"]
         <-Reducer 5 [SIMPLE_EDGE] llap
           SHUFFLE [RS_14]
             PartitionCols:_col0
-            Limit [LIM_11] (rows=1 width=0)
+            Limit [LIM_11] (rows=1 width=8)
               Number of rows:1
-              Select Operator [SEL_10] (rows=1 width=0)
+              Select Operator [SEL_10] (rows=1 width=8)
                 Output:["_col0"]
               <-Union 4 [CUSTOM_SIMPLE_EDGE]
                 <-Map 3 [CONTAINS] llap
                   Reduce Output Operator [RS_9]
-                    Limit [LIM_8] (rows=1 width=0)
+                    Limit [LIM_8] (rows=1 width=4)
                       Number of rows:1
-                      Select Operator [SEL_3] (rows=1 width=0)
+                      Select Operator [SEL_3] (rows=1 width=4)
                         Output:["_col0"]
-                        TableScan [TS_2] (rows=1 width=0)
+                        TableScan [TS_2] (rows=1 width=4)
                           Output:["id"]
                 <-Map 6 [CONTAINS] llap
                   Reduce Output Operator [RS_9]
-                    Limit [LIM_8] (rows=1 width=0)
+                    Limit [LIM_8] (rows=1 width=4)
                       Number of rows:1
                       Select Operator [SEL_5] (rows=1 width=0)
                         Output:["_col0"]

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
index 4bdb186..935a8b4 100644
--- a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
@@ -62,29 +62,29 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_12]
-        Select Operator [SEL_11] (rows=5 width=22)
+        Select Operator [SEL_11] (rows=5 width=413)
           Output:["_col0","_col1","_col2"]
-          Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+          Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
             Conds:RS_8._col3=RS_9._col0(Left Semi),Output:["_col0","_col2"]
           <-Map 1 [SIMPLE_EDGE] llap
             SHUFFLE [RS_8]
               PartitionCols:_col3
-              Select Operator [SEL_2] (rows=5 width=20)
+              Select Operator [SEL_2] (rows=5 width=376)
                 Output:["_col0","_col2","_col3"]
-                Filter Operator [FIL_15] (rows=5 width=20)
+                Filter Operator [FIL_15] (rows=5 width=376)
                   predicate:((val = 't1val01') and dimid is not null)
-                  TableScan [TS_0] (rows=10 width=20)
+                  TableScan [TS_0] (rows=10 width=376)
                     default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
           <-Map 3 [SIMPLE_EDGE] llap
             SHUFFLE [RS_9]
               PartitionCols:_col0
-              Group By Operator [GBY_7] (rows=5 width=3)
+              Group By Operator [GBY_7] (rows=5 width=4)
                 Output:["_col0"],keys:_col0
-                Select Operator [SEL_5] (rows=5 width=3)
+                Select Operator [SEL_5] (rows=5 width=4)
                   Output:["_col0"]
-                  Filter Operator [FIL_16] (rows=5 width=3)
+                  Filter Operator [FIL_16] (rows=5 width=4)
                     predicate:id is not null
-                    TableScan [TS_3] (rows=5 width=3)
+                    TableScan [TS_3] (rows=5 width=4)
                       default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01'
@@ -116,43 +116,43 @@ Stage-0
     Stage-1
       Reducer 3 llap
       File Output Operator [FS_18]
-        Select Operator [SEL_17] (rows=5 width=24)
+        Select Operator [SEL_17] (rows=5 width=232)
           Output:["_col0","_col1","_col2"]
-          Merge Join Operator [MERGEJOIN_28] (rows=5 width=24)
+          Merge Join Operator [MERGEJOIN_28] (rows=5 width=232)
             Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col0","_col4"]
           <-Map 5 [SIMPLE_EDGE] llap
             SHUFFLE [RS_15]
               PartitionCols:_col0
-              Select Operator [SEL_8] (rows=3 width=10)
+              Select Operator [SEL_8] (rows=3 width=188)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_26] (rows=3 width=10)
+                Filter Operator [FIL_26] (rows=3 width=188)
                   predicate:id is not null
-                  TableScan [TS_6] (rows=3 width=10)
+                  TableScan [TS_6] (rows=3 width=188)
                     default@table2,table2,Tbl:COMPLETE,Col:NONE,Output:["id","val2"]
           <-Reducer 2 [SIMPLE_EDGE] llap
             SHUFFLE [RS_14]
               PartitionCols:_col0
-              Merge Join Operator [MERGEJOIN_27] (rows=5 width=22)
+              Merge Join Operator [MERGEJOIN_27] (rows=5 width=211)
                 Conds:RS_11._col2=RS_12._col0(Left Semi),Output:["_col0"]
               <-Map 1 [SIMPLE_EDGE] llap
                 SHUFFLE [RS_11]
                   PartitionCols:_col2
-                  Select Operator [SEL_2] (rows=5 width=20)
+                  Select Operator [SEL_2] (rows=5 width=192)
                     Output:["_col0","_col2"]
-                    Filter Operator [FIL_24] (rows=5 width=20)
+                    Filter Operator [FIL_24] (rows=5 width=192)
                       predicate:((val = 't1val01') and id is not null and dimid is not null)
-                      TableScan [TS_0] (rows=10 width=20)
+                      TableScan [TS_0] (rows=10 width=192)
                         default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","dimid"]
               <-Map 4 [SIMPLE_EDGE] llap
                 SHUFFLE [RS_12]
                   PartitionCols:_col0
-                  Group By Operator [GBY_10] (rows=5 width=3)
+                  Group By Operator [GBY_10] (rows=5 width=4)
                     Output:["_col0"],keys:_col0
-                    Select Operator [SEL_5] (rows=5 width=3)
+                    Select Operator [SEL_5] (rows=5 width=4)
                       Output:["_col0"]
-                      Filter Operator [FIL_25] (rows=5 width=3)
+                      Filter Operator [FIL_25] (rows=5 width=4)
                         predicate:id is not null
-                        TableScan [TS_3] (rows=5 width=3)
+                        TableScan [TS_3] (rows=5 width=4)
                           default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table2.val2 from table1 inner join table2 on table1.val = 't1val01' and table1.id = table2.id left semi join table3 on table1.dimid = table3.id
@@ -186,43 +186,43 @@ Stage-0
     Stage-1
       Reducer 3 llap
       File Output Operator [FS_18]
-        Select Operator [SEL_17] (rows=5 width=24)
+        Select Operator [SEL_17] (rows=5 width=232)
           Output:["_col0","_col1","_col2"]
-          Merge Join Operator [MERGEJOIN_28] (rows=5 width=24)
+          Merge Join Operator [MERGEJOIN_28] (rows=5 width=232)
             Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col0","_col4"]
           <-Map 5 [SIMPLE_EDGE] llap
             SHUFFLE [RS_15]
               PartitionCols:_col0
-              Select Operator [SEL_8] (rows=3 width=10)
+              Select Operator [SEL_8] (rows=3 width=188)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_26] (rows=3 width=10)
+                Filter Operator [FIL_26] (rows=3 width=188)
                   predicate:id is not null
-                  TableScan [TS_6] (rows=3 width=10)
+                  TableScan [TS_6] (rows=3 width=188)
                     default@table2,table2,Tbl:COMPLETE,Col:NONE,Output:["id","val2"]
           <-Reducer 2 [SIMPLE_EDGE] llap
             SHUFFLE [RS_14]
               PartitionCols:_col0
-              Merge Join Operator [MERGEJOIN_27] (rows=5 width=22)
+              Merge Join Operator [MERGEJOIN_27] (rows=5 width=211)
                 Conds:RS_11._col2=RS_12._col0(Left Semi),Output:["_col0"]
               <-Map 1 [SIMPLE_EDGE] llap
                 SHUFFLE [RS_11]
                   PartitionCols:_col2
-                  Select Operator [SEL_2] (rows=5 width=20)
+                  Select Operator [SEL_2] (rows=5 width=192)
                     Output:["_col0","_col2"]
-                    Filter Operator [FIL_24] (rows=5 width=20)
+                    Filter Operator [FIL_24] (rows=5 width=192)
                       predicate:((val = 't1val01') and dimid is not null and id is not null)
-                      TableScan [TS_0] (rows=10 width=20)
+                      TableScan [TS_0] (rows=10 width=192)
                         default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","dimid"]
               <-Map 4 [SIMPLE_EDGE] llap
                 SHUFFLE [RS_12]
                   PartitionCols:_col0
-                  Group By Operator [GBY_10] (rows=5 width=3)
+                  Group By Operator [GBY_10] (rows=5 width=4)
                     Output:["_col0"],keys:_col0
-                    Select Operator [SEL_5] (rows=5 width=3)
+                    Select Operator [SEL_5] (rows=5 width=4)
                       Output:["_col0"]
-                      Filter Operator [FIL_25] (rows=5 width=3)
+                      Filter Operator [FIL_25] (rows=5 width=4)
                         predicate:id is not null
-                        TableScan [TS_3] (rows=5 width=3)
+                        TableScan [TS_3] (rows=5 width=4)
                           default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table2.val2 from table1 left semi join table3 on table1.dimid = table3.id inner join table2 on table1.val = 't1val01' and table1.id = table2.id
@@ -255,27 +255,27 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_12]
-        Merge Join Operator [MERGEJOIN_17] (rows=2 width=3)
+        Merge Join Operator [MERGEJOIN_17] (rows=5 width=4)
           Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
         <-Map 1 [SIMPLE_EDGE] llap
           SHUFFLE [RS_8]
             PartitionCols:100, true
-            Select Operator [SEL_2] (rows=1 width=20)
+            Select Operator [SEL_2] (rows=1 width=372)
               Output:["_col0","_col1","_col2"]
-              Filter Operator [FIL_15] (rows=1 width=20)
+              Filter Operator [FIL_15] (rows=1 width=372)
                 predicate:false
-                TableScan [TS_0] (rows=10 width=20)
+                TableScan [TS_0] (rows=10 width=372)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1"]
         <-Map 3 [SIMPLE_EDGE] llap
           SHUFFLE [RS_9]
             PartitionCols:_col0, _col1
-            Group By Operator [GBY_7] (rows=2 width=3)
+            Group By Operator [GBY_7] (rows=5 width=4)
               Output:["_col0","_col1"],keys:_col0, _col1
-              Select Operator [SEL_5] (rows=2 width=3)
+              Select Operator [SEL_5] (rows=5 width=4)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_16] (rows=2 width=3)
+                Filter Operator [FIL_16] (rows=5 width=4)
                   predicate:(id = 100)
-                  TableScan [TS_3] (rows=5 width=3)
+                  TableScan [TS_3] (rows=5 width=4)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid <> 100
@@ -303,27 +303,27 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_12]
-        Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+        Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
           Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
         <-Map 1 [SIMPLE_EDGE] llap
           SHUFFLE [RS_8]
             PartitionCols:100, true
-            Select Operator [SEL_2] (rows=5 width=20)
+            Select Operator [SEL_2] (rows=5 width=376)
               Output:["_col0","_col1","_col2"]
-              Filter Operator [FIL_15] (rows=5 width=20)
+              Filter Operator [FIL_15] (rows=5 width=376)
                 predicate:(dimid = 100)
-                TableScan [TS_0] (rows=10 width=20)
+                TableScan [TS_0] (rows=10 width=376)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
         <-Map 3 [SIMPLE_EDGE] llap
           SHUFFLE [RS_9]
             PartitionCols:_col0, _col1
-            Group By Operator [GBY_7] (rows=2 width=3)
+            Group By Operator [GBY_7] (rows=5 width=4)
               Output:["_col0","_col1"],keys:_col0, _col1
-              Select Operator [SEL_5] (rows=2 width=3)
+              Select Operator [SEL_5] (rows=5 width=4)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_16] (rows=2 width=3)
+                Filter Operator [FIL_16] (rows=5 width=4)
                   predicate:(id = 100)
-                  TableScan [TS_3] (rows=5 width=3)
+                  TableScan [TS_3] (rows=5 width=4)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid  IN (100,200)
@@ -353,27 +353,27 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_12]
-        Merge Join Operator [MERGEJOIN_17] (rows=2 width=3)
+        Merge Join Operator [MERGEJOIN_17] (rows=5 width=4)
           Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
         <-Map 1 [SIMPLE_EDGE] llap
           SHUFFLE [RS_8]
             PartitionCols:100, true
-            Select Operator [SEL_2] (rows=1 width=20)
+            Select Operator [SEL_2] (rows=1 width=372)
               Output:["_col0","_col1","_col2"]
-              Filter Operator [FIL_15] (rows=1 width=20)
+              Filter Operator [FIL_15] (rows=1 width=372)
                 predicate:false
-                TableScan [TS_0] (rows=10 width=20)
+                TableScan [TS_0] (rows=10 width=372)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1"]
         <-Map 3 [SIMPLE_EDGE] llap
           SHUFFLE [RS_9]
             PartitionCols:_col0, _col1
-            Group By Operator [GBY_7] (rows=2 width=3)
+            Group By Operator [GBY_7] (rows=5 width=4)
               Output:["_col0","_col1"],keys:_col0, _col1
-              Select Operator [SEL_5] (rows=2 width=3)
+              Select Operator [SEL_5] (rows=5 width=4)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_16] (rows=2 width=3)
+                Filter Operator [FIL_16] (rows=5 width=4)
                   predicate:(id = 100)
-                  TableScan [TS_3] (rows=5 width=3)
+                  TableScan [TS_3] (rows=5 width=4)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid  = 200
@@ -401,27 +401,27 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_12]
-        Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+        Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
           Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
         <-Map 1 [SIMPLE_EDGE] llap
           SHUFFLE [RS_8]
             PartitionCols:100, true
-            Select Operator [SEL_2] (rows=5 width=20)
+            Select Operator [SEL_2] (rows=5 width=376)
               Output:["_col0","_col1","_col2"]
-              Filter Operator [FIL_15] (rows=5 width=20)
+              Filter Operator [FIL_15] (rows=5 width=376)
                 predicate:(dimid = 100)
-                TableScan [TS_0] (rows=10 width=20)
+                TableScan [TS_0] (rows=10 width=376)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
         <-Map 3 [SIMPLE_EDGE] llap
           SHUFFLE [RS_9]
             PartitionCols:_col0, _col1
-            Group By Operator [GBY_7] (rows=2 width=3)
+            Group By Operator [GBY_7] (rows=5 width=4)
               Output:["_col0","_col1"],keys:_col0, _col1
-              Select Operator [SEL_5] (rows=2 width=3)
+              Select Operator [SEL_5] (rows=5 width=4)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_16] (rows=2 width=3)
+                Filter Operator [FIL_16] (rows=5 width=4)
                   predicate:(id = 100)
-                  TableScan [TS_3] (rows=5 width=3)
+                  TableScan [TS_3] (rows=5 width=4)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid  = 100
@@ -451,27 +451,27 @@ Stage-0
     Stage-1
       Reducer 2 llap
       File Output Operator [FS_12]
-        Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+        Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
           Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
         <-Map 1 [SIMPLE_EDGE] llap
           SHUFFLE [RS_8]
             PartitionCols:100, true
-            Select Operator [SEL_2] (rows=5 width=20)
+            Select Operator [SEL_2] (rows=5 width=376)
               Output:["_col0","_col1","_col2"]
-              Filter Operator [FIL_15] (rows=5 width=20)
+              Filter Operator [FIL_15] (rows=5 width=376)
                 predicate:(dimid = 100)
-                TableScan [TS_0] (rows=10 width=20)
+                TableScan [TS_0] (rows=10 width=376)
                   default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
         <-Map 3 [SIMPLE_EDGE] llap
           SHUFFLE [RS_9]
             PartitionCols:_col0, _col1
-            Group By Operator [GBY_7] (rows=2 width=3)
+            Group By Operator [GBY_7] (rows=5 width=4)
               Output:["_col0","_col1"],keys:_col0, _col1
-              Select Operator [SEL_5] (rows=2 width=3)
+              Select Operator [SEL_5] (rows=5 width=4)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_16] (rows=2 width=3)
+                Filter Operator [FIL_16] (rows=5 width=4)
                   predicate:(id = 100)
-                  TableScan [TS_3] (rows=5 width=3)
+                  TableScan [TS_3] (rows=5 width=4)
                     default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
 
 PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100


Mime
View raw message