hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kgyrtk...@apache.org
Subject [14/37] hive git commit: HIVE-18149: Stats: rownum estimation from datasize underestimates in most cases (Zoltan Haindrich, reviewed by Ashutosh Chauhan)
Date Wed, 20 Dec 2017 10:40:15 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
index ed7c5bf..da419fe 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out
@@ -65,10 +65,10 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
                            Inner Join 0 to 1
@@ -76,14 +76,14 @@ STAGE PLANS:
                         0 key (type: int)
                         1 key (type: int)
                       outputColumnNames: _col0, _col1, _col5, _col6
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       Select Operator
                         expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                         outputColumnNames: _col0, _col1, _col2, _col3
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         File Output Operator
                           compressed: false
-                          Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                          Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                           table:
                               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -126,7 +126,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Left Outer Join 0 to 1
@@ -134,14 +134,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -187,7 +187,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Right Outer Join 0 to 1
@@ -195,14 +195,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -249,7 +249,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Outer Join 0 to 1
@@ -257,14 +257,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -314,10 +314,10 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column
stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
                            Inner Join 0 to 1
@@ -325,14 +325,14 @@ STAGE PLANS:
                         0 key (type: int)
                         1 key (type: int)
                       outputColumnNames: _col0, _col1, _col5, _col6
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       Select Operator
                         expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                         outputColumnNames: _col0, _col1, _col2, _col3
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         File Output Operator
                           compressed: false
-                          Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                          Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                           table:
                               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -375,7 +375,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Left Outer Join 0 to 1
@@ -383,14 +383,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -436,7 +436,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Right Outer Join 0 to 1
@@ -444,14 +444,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -498,7 +498,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Outer Join 0 to 1
@@ -506,14 +506,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2288 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2288 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/e26b9325/ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out
index 8237bed..e9e837f 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out
@@ -72,54 +72,54 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (key = 5) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column
stats: NONE
         Map 4 
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (5 = key) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
         Map 5 
             Map Operator Tree:
                 TableScan
                   alias: c
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (key = 5) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
         Map 7 
             Map Operator Tree:
                 TableScan
                   alias: d
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (5 = key) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
                       Reduce Output Operator
                         sort order: 
-                        Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
         Reducer 2 
             Reduce Operator Tree:
               Join Operator
@@ -128,10 +128,10 @@ STAGE PLANS:
                 keys:
                   0 
                   1 
-                Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 4141 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   sort order: 
-                  Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4141 Basic stats: COMPLETE Column stats:
NONE
         Reducer 3 
             Reduce Operator Tree:
               Join Operator
@@ -140,14 +140,14 @@ STAGE PLANS:
                 keys:
                   0 
                   1 
-                Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 8423 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: 5 (type: int), 5 (type: int)
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 8423 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 8423 Basic stats: COMPLETE Column
stats: NONE
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -160,10 +160,10 @@ STAGE PLANS:
                 keys:
                   0 
                   1 
-                Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 4281 Basic stats: COMPLETE Column stats:
NONE
                 Reduce Output Operator
                   sort order: 
-                  Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 4281 Basic stats: COMPLETE Column stats:
NONE
 
   Stage: Stage-0
     Fetch Operator
@@ -195,12 +195,12 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (5 = key) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                       Spark HashTable Sink Operator
                         keys:
                           0 
@@ -216,12 +216,12 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (key = 5) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 208 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2080 Basic stats: COMPLETE Column
stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -230,7 +230,7 @@ STAGE PLANS:
                           1 
                         input vertices:
                           1 Map 2
-                        Statistics: Num rows: 1 Data size: 415 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 4141 Basic stats: COMPLETE Column
stats: NONE
                         Spark HashTable Sink Operator
                           keys:
                             0 
@@ -241,12 +241,12 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: c
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (key = 5) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                       Spark HashTable Sink Operator
                         keys:
                           0 
@@ -262,12 +262,12 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: d
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: (5 = key) (type: boolean)
-                    Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
-                      Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
                       Map Join Operator
                         condition map:
                              Inner Join 0 to 1
@@ -276,7 +276,7 @@ STAGE PLANS:
                           1 
                         input vertices:
                           0 Map 3
-                        Statistics: Num rows: 1 Data size: 429 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 4281 Basic stats: COMPLETE Column
stats: NONE
                         Map Join Operator
                           condition map:
                                Inner Join 0 to 1
@@ -285,14 +285,14 @@ STAGE PLANS:
                             1 
                           input vertices:
                             0 Map 1
-                          Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE Column
stats: NONE
+                          Statistics: Num rows: 1 Data size: 8423 Basic stats: COMPLETE Column
stats: NONE
                           Select Operator
                             expressions: 5 (type: int), 5 (type: int)
                             outputColumnNames: _col0, _col1
-                            Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE
Column stats: NONE
+                            Statistics: Num rows: 1 Data size: 8423 Basic stats: COMPLETE
Column stats: NONE
                             File Output Operator
                               compressed: false
-                              Statistics: Num rows: 1 Data size: 845 Basic stats: COMPLETE
Column stats: NONE
+                              Statistics: Num rows: 1 Data size: 8423 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/e26b9325/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out b/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
index c63ff7f..9362085 100644
--- a/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
+++ b/ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out
@@ -65,10 +65,10 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column
stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
                            Inner Join 0 to 1
@@ -76,14 +76,14 @@ STAGE PLANS:
                         0 key (type: int)
                         1 key (type: int)
                       outputColumnNames: _col0, _col1, _col5, _col6
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       Select Operator
                         expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                         outputColumnNames: _col0, _col1, _col2, _col3
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         File Output Operator
                           compressed: false
-                          Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                          Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                           table:
                               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -126,7 +126,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Left Outer Join 0 to 1
@@ -134,14 +134,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -186,7 +186,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Right Outer Join 0 to 1
@@ -194,14 +194,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -248,7 +248,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 222 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2220 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Outer Join 0 to 1
@@ -256,14 +256,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -312,10 +312,10 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column
stats: NONE
                     Sorted Merge Bucket Map Join Operator
                       condition map:
                            Inner Join 0 to 1
@@ -323,14 +323,14 @@ STAGE PLANS:
                         0 key (type: int)
                         1 key (type: int)
                       outputColumnNames: _col0, _col1, _col5, _col6
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       Select Operator
                         expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                         outputColumnNames: _col0, _col1, _col2, _col3
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         File Output Operator
                           compressed: false
-                          Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                          Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                           table:
                               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -373,7 +373,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Left Outer Join 0 to 1
@@ -381,14 +381,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -433,7 +433,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Right Outer Join 0 to 1
@@ -441,14 +441,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -495,7 +495,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 1 Data size: 206 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 2060 Basic stats: COMPLETE Column stats:
NONE
                   Sorted Merge Bucket Map Join Operator
                     condition map:
                          Outer Join 0 to 1
@@ -503,14 +503,14 @@ STAGE PLANS:
                       0 key (type: int)
                       1 key (type: int)
                     outputColumnNames: _col0, _col1, _col5, _col6
-                    Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                     Select Operator
                       expressions: _col0 (type: int), _col1 (type: string), _col5 (type:
int), _col6 (type: string)
                       outputColumnNames: _col0, _col1, _col2, _col3
-                      Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 2266 Basic stats: COMPLETE Column
stats: NONE
                       File Output Operator
                         compressed: false
-                        Statistics: Num rows: 1 Data size: 226 Basic stats: COMPLETE Column
stats: NONE
+                        Statistics: Num rows: 1 Data size: 2266 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