hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xu...@apache.org
Subject svn commit: r1633210 [8/14] - in /hive/branches/spark/ql/src: java/org/apache/hadoop/hive/ql/optimizer/ test/results/clientpositive/spark/
Date Mon, 20 Oct 2014 19:46:17 GMT
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out?rev=1633210&r1=1633209&r2=1633210&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out
(original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out
Mon Oct 20 19:46:13 2014
@@ -76,6 +76,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: src_10
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
                     table:
@@ -91,16 +92,21 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col1
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           File Output Operator
                             compressed: false
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -109,15 +115,20 @@ STAGE PLANS:
                     Select Operator
                       expressions: array((key + 1),(key + 2)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col1
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             File Output Operator
                               compressed: false
+                              Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                               table:
                                   input format: org.apache.hadoop.mapred.TextInputFormat
                                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -161,16 +172,21 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col1
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           File Output Operator
                             compressed: false
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -179,15 +195,20 @@ STAGE PLANS:
                     Select Operator
                       expressions: array((key + 3),(key + 4)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col1
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             File Output Operator
                               compressed: false
+                              Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                               table:
                                   input format: org.apache.hadoop.mapred.TextInputFormat
                                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -309,6 +330,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: src_10
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
                     table:
@@ -326,43 +348,55 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           Group By Operator
                             aggregations: sum(_col5)
                             keys: _col0 (type: string)
                             mode: hash
                             outputColumnNames: _col0, _col1
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: string)
                               sort order: +
                               Map-reduce partition columns: _col0 (type: string)
+                              Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                               value expressions: _col1 (type: double)
                     Select Operator
                       expressions: array((key + 1),(key + 2)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col5
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             Group By Operator
                               aggregations: sum(_col5)
                               keys: _col0 (type: string)
                               mode: hash
                               outputColumnNames: _col0, _col1
+                              Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: string)
                                 sort order: +
                                 Map-reduce partition columns: _col0 (type: string)
+                                Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                                 value expressions: _col1 (type: double)
         Reducer 4 
             Reduce Operator Tree:
@@ -371,11 +405,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -421,43 +458,55 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           Group By Operator
                             aggregations: sum(_col5)
                             keys: _col0 (type: string)
                             mode: hash
                             outputColumnNames: _col0, _col1
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: string)
                               sort order: +
                               Map-reduce partition columns: _col0 (type: string)
+                              Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                               value expressions: _col1 (type: double)
                     Select Operator
                       expressions: array((key + 3),(key + 4)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col5
+                            Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                             Group By Operator
                               aggregations: sum(_col5)
                               keys: _col0 (type: string)
                               mode: hash
                               outputColumnNames: _col0, _col1
+                              Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: string)
                                 sort order: +
                                 Map-reduce partition columns: _col0 (type: string)
+                                Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE
Column stats: NONE
                                 value expressions: _col1 (type: double)
         Reducer 5 
             Reduce Operator Tree:
@@ -466,11 +515,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -576,6 +628,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: src_10
+                  Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                   File Output Operator
                     compressed: false
                     table:
@@ -593,43 +646,55 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Group By Operator
                             aggregations: sum(_col5)
                             keys: _col0 (type: string)
                             mode: hash
                             outputColumnNames: _col0, _col1
+                            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: string)
                               sort order: +
                               Map-reduce partition columns: _col0 (type: string)
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                               value expressions: _col1 (type: double)
                     Select Operator
                       expressions: array((key + 1),(key + 2)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col5
+                            Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                             Group By Operator
                               aggregations: sum(_col5)
                               keys: _col0 (type: string)
                               mode: hash
                               outputColumnNames: _col0, _col1
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: string)
                                 sort order: +
                                 Map-reduce partition columns: _col0 (type: string)
+                                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                                 value expressions: _col1 (type: double)
         Reducer 4 
             Reduce Operator Tree:
@@ -638,11 +703,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -702,29 +770,37 @@ STAGE PLANS:
                 TableScan
                   Filter Operator
                     predicate: ((key > 200) or (key < 200)) (type: boolean)
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     Select Operator
                       expressions: key (type: string), value (type: string)
                       outputColumnNames: key, value
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       Reduce Output Operator
                         key expressions: key (type: string)
                         sort order: +
                         Map-reduce partition columns: key (type: string)
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                         value expressions: value (type: string)
         Reducer 5 
             Reduce Operator Tree:
               Forward
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Filter Operator
                   predicate: (KEY._col0 > 200) (type: boolean)
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Group By Operator
                     aggregations: count(VALUE._col0)
                     keys: KEY._col0 (type: string)
                     mode: complete
                     outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     Select Operator
                       expressions: _col0 (type: string), _col1 (type: bigint)
                       outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       File Output Operator
                         compressed: false
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -732,16 +808,20 @@ STAGE PLANS:
                             name: default.src_lv2
                 Filter Operator
                   predicate: (KEY._col0 < 200) (type: boolean)
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Group By Operator
                     aggregations: count(VALUE._col0)
                     keys: KEY._col0 (type: string)
                     mode: complete
                     outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     Select Operator
                       expressions: _col0 (type: string), _col1 (type: bigint)
                       outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       File Output Operator
                         compressed: false
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -867,6 +947,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: src_10
+                  Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                   File Output Operator
                     compressed: false
                     table:
@@ -884,42 +965,54 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                         Select Operator
                           expressions: _col5 (type: double), _col0 (type: string)
                           outputColumnNames: _col5, _col0
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Group By Operator
                             aggregations: sum(DISTINCT _col0)
                             keys: _col5 (type: double), _col0 (type: string)
                             mode: hash
                             outputColumnNames: _col0, _col1, _col2
+                            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: double), _col1 (type: string)
                               sort order: ++
                               Map-reduce partition columns: _col0 (type: double)
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                     Select Operator
                       expressions: array((key + 1),(key + 2)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Select Operator
                             expressions: _col5 (type: double), _col0 (type: string)
                             outputColumnNames: _col5, _col0
+                            Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                             Group By Operator
                               aggregations: sum(DISTINCT _col0)
                               keys: _col5 (type: double), _col0 (type: string)
                               mode: hash
                               outputColumnNames: _col0, _col1, _col2
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: double), _col1 (type: string)
                                 sort order: ++
                                 Map-reduce partition columns: _col0 (type: double)
+                                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
         Reducer 5 
             Reduce Operator Tree:
               Group By Operator
@@ -927,11 +1020,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: double)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: double), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -990,42 +1086,54 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                         Select Operator
                           expressions: _col5 (type: double), _col0 (type: string)
                           outputColumnNames: _col5, _col0
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Group By Operator
                             aggregations: sum(DISTINCT _col0)
                             keys: _col5 (type: double), _col0 (type: string)
                             mode: hash
                             outputColumnNames: _col0, _col1, _col2
+                            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: double), _col1 (type: string)
                               sort order: ++
                               Map-reduce partition columns: _col0 (type: double)
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                     Select Operator
                       expressions: array((key + 3),(key + 4)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Select Operator
                             expressions: _col5 (type: double), _col0 (type: string)
                             outputColumnNames: _col5, _col0
+                            Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                             Group By Operator
                               aggregations: sum(DISTINCT _col0)
                               keys: _col5 (type: double), _col0 (type: string)
                               mode: hash
                               outputColumnNames: _col0, _col1, _col2
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: double), _col1 (type: string)
                                 sort order: ++
                                 Map-reduce partition columns: _col0 (type: double)
+                                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
         Reducer 6 
             Reduce Operator Tree:
               Group By Operator
@@ -1033,11 +1141,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: double)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: double), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1056,15 +1167,18 @@ STAGE PLANS:
                   Select Operator
                     expressions: value (type: string), key (type: string)
                     outputColumnNames: value, key
+                    Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                     Group By Operator
                       aggregations: sum(DISTINCT key)
                       keys: value (type: string), key (type: string)
                       mode: hash
                       outputColumnNames: _col0, _col1, _col2
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       Reduce Output Operator
                         key expressions: _col0 (type: string), _col1 (type: string)
                         sort order: ++
                         Map-reduce partition columns: _col0 (type: string)
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
         Reducer 7 
             Reduce Operator Tree:
               Group By Operator
@@ -1072,11 +1186,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1232,6 +1349,7 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: src_10
+                  Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                   File Output Operator
                     compressed: false
                     table:
@@ -1249,42 +1367,54 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Group By Operator
                             aggregations: sum(DISTINCT _col5)
                             keys: _col0 (type: string), _col5 (type: double)
                             mode: hash
                             outputColumnNames: _col0, _col1, _col2
+                            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: string), _col1 (type: double)
                               sort order: ++
                               Map-reduce partition columns: _col0 (type: string)
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                     Select Operator
                       expressions: array((key + 1),(key + 2)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col5
+                            Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                             Group By Operator
                               aggregations: sum(DISTINCT _col5)
                               keys: _col0 (type: string), _col5 (type: double)
                               mode: hash
                               outputColumnNames: _col0, _col1, _col2
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: string), _col1 (type: double)
                                 sort order: ++
                                 Map-reduce partition columns: _col0 (type: string)
+                                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
         Reducer 5 
             Reduce Operator Tree:
               Group By Operator
@@ -1292,11 +1422,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1368,42 +1501,54 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   Lateral View Forward
+                    Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats:
NONE
                     Select Operator
                       expressions: key (type: string)
                       outputColumnNames: key
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       Lateral View Join Operator
                         outputColumnNames: _col0, _col5
+                        Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                         Select Operator
                           expressions: _col0 (type: string), _col5 (type: double)
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Group By Operator
                             aggregations: sum(DISTINCT _col5)
                             keys: _col0 (type: string), _col5 (type: double)
                             mode: hash
                             outputColumnNames: _col0, _col1, _col2
+                            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                             Reduce Output Operator
                               key expressions: _col0 (type: string), _col1 (type: double)
                               sort order: ++
                               Map-reduce partition columns: _col0 (type: string)
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                     Select Operator
                       expressions: array((key + 3),(key + 4)) (type: array<double>)
                       outputColumnNames: _col0
+                      Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                       UDTF Operator
+                        Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column
stats: NONE
                         function name: explode
                         Lateral View Join Operator
                           outputColumnNames: _col0, _col5
+                          Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                           Select Operator
                             expressions: _col0 (type: string), _col5 (type: double)
                             outputColumnNames: _col0, _col5
+                            Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column
stats: NONE
                             Group By Operator
                               aggregations: sum(DISTINCT _col5)
                               keys: _col0 (type: string), _col5 (type: double)
                               mode: hash
                               outputColumnNames: _col0, _col1, _col2
+                              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
                               Reduce Output Operator
                                 key expressions: _col0 (type: string), _col1 (type: double)
                                 sort order: ++
                                 Map-reduce partition columns: _col0 (type: string)
+                                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column
stats: NONE
         Reducer 6 
             Reduce Operator Tree:
               Group By Operator
@@ -1411,11 +1556,14 @@ STAGE PLANS:
                 keys: KEY._col0 (type: string)
                 mode: mergepartial
                 outputColumnNames: _col0, _col1
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Select Operator
                   expressions: _col0 (type: string), _col1 (type: double)
                   outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   File Output Operator
                     compressed: false
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1433,28 +1581,36 @@ STAGE PLANS:
                 TableScan
                   Filter Operator
                     predicate: ((key > 200) or (key < 200)) (type: boolean)
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     Select Operator
                       expressions: key (type: string), value (type: string)
                       outputColumnNames: key, value
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       Reduce Output Operator
                         key expressions: value (type: string), key (type: string)
                         sort order: ++
                         Map-reduce partition columns: value (type: string)
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
         Reducer 7 
             Reduce Operator Tree:
               Forward
+                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                 Filter Operator
                   predicate: (KEY._col1:0._col0 > 200) (type: boolean)
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Group By Operator
                     aggregations: sum(DISTINCT KEY._col1:0._col0)
                     keys: KEY._col0 (type: string)
                     mode: complete
                     outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     Select Operator
                       expressions: _col0 (type: string), _col1 (type: double)
                       outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       File Output Operator
                         compressed: false
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1462,16 +1618,20 @@ STAGE PLANS:
                             name: default.src_lv3
                 Filter Operator
                   predicate: (KEY._col1:0._col0 < 200) (type: boolean)
+                  Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Group By Operator
                     aggregations: sum(DISTINCT KEY._col1:0._col0)
                     keys: KEY._col0 (type: string)
                     mode: complete
                     outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                     Select Operator
                       expressions: _col0 (type: string), _col1 (type: double)
                       outputColumnNames: _col0, _col1
+                      Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                       File Output Operator
                         compressed: false
+                        Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat



Mime
View raw message