hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From w...@apache.org
Subject [44/74] [abbrv] [partial] hive git commit: HIVE-16811 : Estimate statistics in absence of stats (Vineet Garg, reviewed by Ashutosh Chauhan)
Date Fri, 08 Sep 2017 06:35:36 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
index 5913768..1c6ab8c 100644
--- a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out
@@ -63,22 +63,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -91,11 +91,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -104,13 +104,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -191,22 +191,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -219,11 +219,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -232,13 +232,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -292,22 +292,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: length(key) (type: int)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: _col0 (type: int)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -320,13 +320,13 @@ STAGE PLANS:
                 keys: KEY._col0 (type: int)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -373,22 +373,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: abs(length(key)) (type: int)
                     outputColumnNames: _col0
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: _col0 (type: int)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -401,13 +401,13 @@ STAGE PLANS:
                 keys: KEY._col0 (type: int)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -455,22 +455,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -483,11 +483,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -496,13 +496,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -557,22 +557,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: value (type: string)
                     outputColumnNames: value
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: value (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -585,11 +585,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -598,13 +598,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -658,22 +658,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1000 Data size: 185608 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: 1000 Data size: 18624 Basic stats: COMPLETE
Column stats: NONE
+                        Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE
Column stats: NONE
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
             LLAP IO: no inputs
@@ -685,10 +685,10 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column
stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1043,22 +1043,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 1000 Data size: 18624 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1000 Data size: 185608 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: 1000 Data size: 18624 Basic stats: COMPLETE
Column stats: NONE
+                        Statistics: Num rows: 1000 Data size: 185608 Basic stats: COMPLETE
Column stats: NONE
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
             LLAP IO: no inputs
@@ -1070,10 +1070,10 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92804 Basic stats: COMPLETE Column
stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1158,23 +1158,23 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       bucketGroup: true
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -1187,11 +1187,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -1200,13 +1200,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1261,22 +1261,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: value (type: string)
                     outputColumnNames: value
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: value (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -1289,11 +1289,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -1302,13 +1302,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1464,23 +1464,23 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string)
                     outputColumnNames: key
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       bucketGroup: true
                       keys: key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 92896 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: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 92896 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col1 (type: bigint)
             Execution mode: llap
@@ -1493,11 +1493,11 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column
stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -1506,13 +1506,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 46448 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 1850 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1567,22 +1567,22 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: clustergroupby
-                  Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column
stats: NONE
                   Select Operator
                     expressions: key (type: string), value (type: string)
                     outputColumnNames: key, value
-                    Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: count()
                       keys: key (type: string), value (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1, _col2
-                      Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: string), _col1 (type: string)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: string), _col1 (type:
string)
-                        Statistics: Num rows: 500 Data size: 9312 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 500 Data size: 180480 Basic stats: COMPLETE
Column stats: NONE
                         TopN Hash Memory Usage: 0.1
                         value expressions: _col2 (type: bigint)
             Execution mode: llap
@@ -1595,15 +1595,15 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string), KEY._col1 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: _col0 (type: string), _col2 (type: bigint)
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                  Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column
stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: string)
                     sort order: +
-                    Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column
stats: NONE
                     TopN Hash Memory Usage: 0.1
                     value expressions: _col1 (type: bigint)
         Reducer 3 
@@ -1612,13 +1612,13 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 4656 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 250 Data size: 90240 Basic stats: COMPLETE Column stats:
NONE
                 Limit
                   Number of rows: 10
-                  Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 10 Data size: 3600 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 10 Data size: 180 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 10 Data size: 3600 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat


Mime
View raw message