hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vg...@apache.org
Subject [10/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:08:42 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/sqlmerge.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/sqlmerge.q.out b/ql/src/test/results/clientpositive/llap/sqlmerge.q.out
index 562d444..61349f8 100644
--- a/ql/src/test/results/clientpositive/llap/sqlmerge.q.out
+++ b/ql/src/test/results/clientpositive/llap/sqlmerge.q.out
@@ -52,12 +52,12 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Reduce Output Operator
                     key expressions: a (type: int)
                     sort order: +
                     Map-reduce partition columns: a (type: int)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     value expressions: ROW__ID (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
             Execution mode: llap
             LLAP IO: may be used (ACID table)
@@ -65,12 +65,12 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: s
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                   Reduce Output Operator
                     key expressions: a (type: int)
                     sort order: +
                     Map-reduce partition columns: a (type: int)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                     value expressions: b (type: int)
             Execution mode: llap
             LLAP IO: all inputs
@@ -84,62 +84,62 @@ STAGE PLANS:
                   0 a (type: int)
                   1 a (type: int)
                 outputColumnNames: _col0, _col4, _col5, _col6
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 Filter Operator
                   predicate: ((_col5 > 8) and (_col0 = _col5)) (type: boolean)
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: _col4 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                       sort order: +
                       Map-reduce partition columns: UDFToInteger(_col0) (type: int)
-                      Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 Filter Operator
                   predicate: ((_col5 <= 8) and (_col0 = _col5)) (type: boolean)
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: _col4 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>),
_col0 (type: int)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                       sort order: +
                       Map-reduce partition columns: UDFToInteger(_col0) (type: int)
-                      Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                       value expressions: _col1 (type: int)
                 Filter Operator
                   predicate: (_col0 = _col5) (type: boolean)
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: _col4 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                     outputColumnNames: _col4
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     Group By Operator
                       aggregations: count()
                       keys: _col4 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                         sort order: +
                         Map-reduce partition columns: _col0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
-                        Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column
stats: NONE
                         value expressions: _col1 (type: bigint)
                 Filter Operator
                   predicate: _col0 is null (type: boolean)
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: _col5 (type: int), _col6 (type: int)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       sort order: 
                       Map-reduce partition columns: _col0 (type: int)
-                      Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                       value expressions: _col0 (type: int), _col1 (type: int)
         Reducer 3 
             Execution mode: llap
@@ -147,10 +147,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                 outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                       output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -163,10 +163,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>),
VALUE._col0 (type: int), 7 (type: int)
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                       output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -181,17 +181,17 @@ STAGE PLANS:
                 keys: KEY._col0 (type: struct<transactionid:bigint,bucketid:int,rowid:bigint>)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 Filter Operator
                   predicate: (_col1 > 1) (type: boolean)
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: cardinality_violation(_col0) (type: int)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -203,10 +203,10 @@ STAGE PLANS:
               Select Operator
                 expressions: VALUE._col0 (type: int), VALUE._col1 (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                       output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -294,24 +294,24 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Reduce Output Operator
                     key expressions: a (type: int)
                     sort order: +
                     Map-reduce partition columns: a (type: int)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
             Execution mode: llap
             LLAP IO: may be used (ACID table)
         Map 4 
             Map Operator Tree:
                 TableScan
                   alias: s
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                   Reduce Output Operator
                     key expressions: a (type: int)
                     sort order: +
                     Map-reduce partition columns: a (type: int)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                     value expressions: b (type: int)
             Execution mode: llap
             LLAP IO: all inputs
@@ -325,18 +325,18 @@ STAGE PLANS:
                   0 a (type: int)
                   1 a (type: int)
                 outputColumnNames: _col0, _col5, _col6
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 Filter Operator
                   predicate: _col0 is null (type: boolean)
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: _col5 (type: int), _col6 (type: int)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       sort order: 
                       Map-reduce partition columns: _col0 (type: int)
-                      Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                       value expressions: _col0 (type: int), _col1 (type: int)
         Reducer 3 
             Execution mode: llap
@@ -344,10 +344,10 @@ STAGE PLANS:
               Select Operator
                 expressions: VALUE._col0 (type: int), VALUE._col1 (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                       output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/stats11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/stats11.q.out b/ql/src/test/results/clientpositive/llap/stats11.q.out
index 48d76cf..387a454 100644
--- a/ql/src/test/results/clientpositive/llap/stats11.q.out
+++ b/ql/src/test/results/clientpositive/llap/stats11.q.out
@@ -320,22 +320,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 26 Data size: 4888 Basic stats: COMPLETE Column stats:
NONE
                   GatherStats: false
                   Filter Operator
                     isSamplingPred: false
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int)
                         null sort order: a
                         sort order: +
                         Map-reduce partition columns: _col0 (type: int)
-                        Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column
stats: NONE
                         tag: 0
                         value expressions: _col1 (type: string)
                         auto parallelism: true
@@ -396,22 +396,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column
stats: NONE
                   GatherStats: false
                   Filter Operator
                     isSamplingPred: false
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int)
                         null sort order: a
                         sort order: +
                         Map-reduce partition columns: _col0 (type: int)
-                        Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column
stats: NONE
                         tag: 1
                         value expressions: _col1 (type: string)
                         auto parallelism: true
@@ -482,17 +482,17 @@ STAGE PLANS:
                   1 _col0 (type: int)
                 outputColumnNames: _col0, _col1, _col3
                 Position of Big Table: 1
-                Statistics: Num rows: 60 Data size: 6877 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: UDFToString(_col0) (type: string), _col1 (type: string), _col3
(type: string)
                   outputColumnNames: _col0, _col1, _col2
-                  Statistics: Num rows: 60 Data size: 6877 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column
stats: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
-                    Statistics: Num rows: 60 Data size: 6877 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column
stats: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
@@ -686,22 +686,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 26 Data size: 4888 Basic stats: COMPLETE Column stats:
NONE
                   GatherStats: false
                   Filter Operator
                     isSamplingPred: false
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int)
                         null sort order: a
                         sort order: +
                         Map-reduce partition columns: _col0 (type: int)
-                        Statistics: Num rows: 26 Data size: 2750 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 25 Data size: 4700 Basic stats: COMPLETE Column
stats: NONE
                         tag: 0
                         value expressions: _col1 (type: string)
                         auto parallelism: true
@@ -762,22 +762,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 55 Data size: 15964 Basic stats: COMPLETE Column
stats: NONE
                   GatherStats: false
                   Filter Operator
                     isSamplingPred: false
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: key (type: int), value (type: string)
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int)
                         null sort order: a
                         sort order: +
                         Map-reduce partition columns: _col0 (type: int)
-                        Statistics: Num rows: 55 Data size: 6252 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 53 Data size: 15383 Basic stats: COMPLETE Column
stats: NONE
                         tag: 1
                         value expressions: _col1 (type: string)
                         auto parallelism: true
@@ -848,17 +848,17 @@ STAGE PLANS:
                   1 _col0 (type: int)
                 outputColumnNames: _col0, _col1, _col3
                 Position of Big Table: 1
-                Statistics: Num rows: 60 Data size: 6877 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: UDFToString(_col0) (type: string), _col1 (type: string), _col3
(type: string)
                   outputColumnNames: _col0, _col1, _col2
-                  Statistics: Num rows: 60 Data size: 6877 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column
stats: NONE
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
 #### A masked pattern was here ####
                     NumFilesPerFileSink: 1
-                    Statistics: Num rows: 60 Data size: 6877 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 58 Data size: 16921 Basic stats: COMPLETE Column
stats: NONE
 #### A masked pattern was here ####
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/stats_only_null.q.out b/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
index ed87791..f25f9d5 100644
--- a/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
+++ b/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
@@ -88,19 +88,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: stats_null
-                  Statistics: Num rows: 10 Data size: 120 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: a (type: double), b (type: int), c (type: string), d (type:
smallint)
                     outputColumnNames: a, b, c, d
-                    Statistics: Num rows: 10 Data size: 120 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count(), count(a), count(b), count(c), count(d)
                       mode: hash
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                      Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column
stats: NONE
                         value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2
(type: bigint), _col3 (type: bigint), _col4 (type: bigint)
             Execution mode: llap
             LLAP IO: no inputs
@@ -111,10 +111,10 @@ STAGE PLANS:
                 aggregations: count(VALUE._col0), count(VALUE._col1), count(VALUE._col2),
count(VALUE._col3), count(VALUE._col4)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -148,19 +148,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: stats_null_part
-                  Statistics: Num rows: 10 Data size: 200 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 2120 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: a (type: double), b (type: int), c (type: string), d (type:
smallint)
                     outputColumnNames: a, b, c, d
-                    Statistics: Num rows: 10 Data size: 200 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 2120 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count(), count(a), count(b), count(c), count(d)
                       mode: hash
                       outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                      Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column
stats: NONE
                         value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2
(type: bigint), _col3 (type: bigint), _col4 (type: bigint)
             Execution mode: llap
             LLAP IO: no inputs
@@ -171,10 +171,10 @@ STAGE PLANS:
                 aggregations: count(VALUE._col0), count(VALUE._col1), count(VALUE._col2),
count(VALUE._col3), count(VALUE._col4)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4
-                Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 240 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/subquery_exists.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_exists.q.out b/ql/src/test/results/clientpositive/llap/subquery_exists.q.out
index 2f6fd02..840ecd4 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_exists.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_exists.q.out
@@ -970,14 +970,14 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t
-                  Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: i (type: int)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       sort order: 
-                      Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                      Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                       value expressions: _col0 (type: int)
             Execution mode: llap
             LLAP IO: no inputs
@@ -1012,10 +1012,10 @@ STAGE PLANS:
                   0 
                   1 
                 outputColumnNames: _col0
-                Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 26 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/subquery_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_in.q.out b/ql/src/test/results/clientpositive/llap/subquery_in.q.out
index 2c763b3..03819ef 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_in.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_in.q.out
@@ -5103,19 +5103,19 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t
-                  Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: i is not null (type: boolean)
-                    Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: i (type: int)
                       outputColumnNames: _col0
-                      Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                      Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                       Reduce Output Operator
                         key expressions: UDFToLong(_col0) (type: bigint)
                         sort order: +
                         Map-reduce partition columns: UDFToLong(_col0) (type: bigint)
-                        Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
                         value expressions: _col0 (type: int)
             Execution mode: llap
             LLAP IO: no inputs
@@ -5147,10 +5147,10 @@ STAGE PLANS:
                   0 UDFToLong(_col0) (type: bigint)
                   1 _col0 (type: bigint)
                 outputColumnNames: _col0
-                Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 2 Data size: 2 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 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
@@ -5311,16 +5311,16 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: t
-                  Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: i (type: int), j (type: int)
                     outputColumnNames: _col0, _col1
-                    Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       key expressions: UDFToLong(_col0) (type: bigint), _col1 (type: int)
                       sort order: ++
                       Map-reduce partition columns: UDFToLong(_col0) (type: bigint), _col1
(type: int)
-                      Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats:
NONE
+                      Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: _col0 (type: int)
             Execution mode: llap
             LLAP IO: no inputs
@@ -5328,21 +5328,21 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: tt
-                  Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: j is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                     Group By Operator
                       aggregations: sum(i)
                       keys: j (type: int)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: int)
                         sort order: +
                         Map-reduce partition columns: _col0 (type: int)
-                        Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
             LLAP IO: no inputs
@@ -5356,10 +5356,10 @@ STAGE PLANS:
                   0 UDFToLong(_col0) (type: bigint), _col1 (type: int)
                   1 _col0 (type: bigint), _col1 (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 2 Data size: 17 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: 17 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -5372,16 +5372,16 @@ STAGE PLANS:
                 keys: KEY._col0 (type: int)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: _col1 (type: bigint), _col0 (type: int)
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: bigint), _col1 (type: int)
                     sort order: ++
                     Map-reduce partition columns: _col0 (type: bigint), _col1 (type: int)
-                    Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats:
NONE
 
   Stage: Stage-0
     Fetch Operator


Mime
View raw message