hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xu...@apache.org
Subject [13/84] [abbrv] hive git commit: HIVE-8769 : Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) (Pengcheng Xiong via Ashutosh Chauhan)
Date Fri, 29 May 2015 04:46:52 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/d823fc80/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
index b684858..dadcec1 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
@@ -237,10 +237,10 @@ Stage-0
                      outputColumnNames:["_col0"]
                      Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
                      Select Operator [SEL_2]
-                        Statistics:Num rows: 0 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
+                        Statistics:Num rows: 1 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
                         TableScan [TS_0]
                            alias:src_orc_merge_test_part
-                           Statistics:Num rows: 0 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
+                           Statistics:Num rows: 1 Data size: 2527 Basic stats: PARTIAL Column stats: NONE
 PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
 PREHOOK: type: QUERY
 POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
@@ -504,45 +504,45 @@ Stage-0
          Reducer 4
          File Output Operator [FS_47]
             compressed:false
-            Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Select Operator [SEL_46]
             |  outputColumnNames:["_col0","_col1","_col2"]
-            |  Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+            |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Reducer 3 [SIMPLE_EDGE]
                Reduce Output Operator [RS_45]
                   key expressions:(UDFToLong(_col0) + _col1) (type: bigint), _col1 (type: bigint)
                   sort order:-+
-                  Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+                  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   value expressions:_col0 (type: int), _col2 (type: bigint)
                   Group By Operator [GBY_43]
                   |  aggregations:["count(VALUE._col0)"]
                   |  keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
                   |  outputColumnNames:["_col0","_col1","_col2"]
-                  |  Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+                  |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   |<-Reducer 2 [SIMPLE_EDGE]
                      Reduce Output Operator [RS_42]
                         key expressions:_col0 (type: int), _col1 (type: bigint)
                         Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
                         sort order:++
-                        Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                        Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                         value expressions:_col2 (type: bigint)
                         Group By Operator [GBY_41]
                            aggregations:["count()"]
                            keys:_col0 (type: int), _col1 (type: bigint)
                            outputColumnNames:["_col0","_col1","_col2"]
-                           Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                           Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                            Select Operator [SEL_37]
                               outputColumnNames:["_col0","_col1"]
-                              Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                              Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
                               Filter Operator [FIL_53]
                                  predicate:((_col3 > 0) or (_col1 >= 0)) (type: boolean)
-                                 Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                                 Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
                                  Merge Join Operator [MERGEJOIN_59]
                                  |  condition map:[{"":"Inner Join 0 to 1"}]
                                  |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                  |  outputColumnNames:["_col1","_col3","_col4"]
-                                 |  Statistics:Num rows: 19 Data size: 1566 Basic stats: COMPLETE Column stats: NONE
+                                 |  Statistics:Num rows: 3 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
                                  |<-Map 1 [SIMPLE_EDGE]
                                  |  Reduce Output Operator [RS_33]
                                  |     key expressions:_col0 (type: string)
@@ -564,14 +564,14 @@ Stage-0
                                        key expressions:_col0 (type: string)
                                        Map-reduce partition columns:_col0 (type: string)
                                        sort order:+
-                                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                        value expressions:_col1 (type: int), _col2 (type: bigint)
                                        Select Operator [SEL_29]
                                           outputColumnNames:["_col0","_col1","_col2"]
-                                          Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                           Filter Operator [FIL_55]
                                              predicate:((_col3 + _col1) >= 0) (type: boolean)
-                                             Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                              Merge Join Operator [MERGEJOIN_58]
                                              |  condition map:[{"":"Inner Join 0 to 1"}]
                                              |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
@@ -689,45 +689,45 @@ Stage-0
          Reducer 6
          File Output Operator [FS_42]
             compressed:false
-            Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Select Operator [SEL_41]
             |  outputColumnNames:["_col0","_col1","_col2"]
-            |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+            |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Reducer 5 [SIMPLE_EDGE]
                Reduce Output Operator [RS_40]
                   key expressions:(UDFToLong(_col0) % _col1) (type: bigint), _col0 (type: int)
                   sort order:+-
-                  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   value expressions:_col1 (type: bigint), _col2 (type: bigint)
                   Group By Operator [GBY_38]
                   |  aggregations:["count(VALUE._col0)"]
                   |  keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
                   |  outputColumnNames:["_col0","_col1","_col2"]
-                  |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                  |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   |<-Reducer 4 [SIMPLE_EDGE]
                      Reduce Output Operator [RS_37]
                         key expressions:_col0 (type: int), _col1 (type: bigint)
                         Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
                         sort order:++
-                        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                        Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                         value expressions:_col2 (type: bigint)
                         Group By Operator [GBY_36]
                            aggregations:["count()"]
                            keys:_col0 (type: int), _col1 (type: bigint)
                            outputColumnNames:["_col0","_col1","_col2"]
-                           Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                           Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                            Select Operator [SEL_34]
                               outputColumnNames:["_col0","_col1"]
-                              Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                              Statistics:Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
                               Filter Operator [FIL_33]
                                  predicate:(((_col1 > 0) or (_col6 >= 0)) and (((_col6 >= 1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))) (type: boolean)
-                                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                 Statistics:Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
                                  Merge Join Operator [MERGEJOIN_52]
                                  |  condition map:[{"":"Inner Join 0 to 1"}]
                                  |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                  |  outputColumnNames:["_col1","_col2","_col6"]
-                                 |  Statistics:Num rows: 5 Data size: 391 Basic stats: COMPLETE Column stats: NONE
+                                 |  Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
                                  |<-Map 10 [SIMPLE_EDGE]
                                  |  Reduce Output Operator [RS_31]
                                  |     key expressions:_col0 (type: string)
@@ -749,49 +749,49 @@ Stage-0
                                        key expressions:_col0 (type: string)
                                        Map-reduce partition columns:_col0 (type: string)
                                        sort order:+
-                                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                       Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                        value expressions:_col1 (type: int), _col2 (type: bigint)
                                        Select Operator [SEL_22]
                                           outputColumnNames:["_col0","_col1","_col2"]
-                                          Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                          Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                           Filter Operator [FIL_47]
                                              predicate:((_col3 + _col1) >= 0) (type: boolean)
-                                             Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                             Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                              Merge Join Operator [MERGEJOIN_51]
                                              |  condition map:[{"":"Right Outer Join0 to 1"}]
                                              |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                              |  outputColumnNames:["_col1","_col2","_col3","_col4"]
-                                             |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                             |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                              |<-Reducer 2 [SIMPLE_EDGE]
                                              |  Reduce Output Operator [RS_19]
                                              |     key expressions:_col0 (type: string)
                                              |     Map-reduce partition columns:_col0 (type: string)
                                              |     sort order:+
-                                             |     Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |     Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                              |     value expressions:_col1 (type: int)
                                              |     Select Operator [SEL_7]
                                              |        outputColumnNames:["_col0","_col1"]
-                                             |        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |        Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                              |        Group By Operator [GBY_6]
                                              |        |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                              |        |  outputColumnNames:["_col0","_col1","_col2"]
-                                             |        |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |        |  Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                              |        |<-Map 1 [SIMPLE_EDGE]
                                              |           Reduce Output Operator [RS_5]
                                              |              key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                              |              Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                              |              sort order:+++
-                                             |              Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |              Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                              |              Group By Operator [GBY_4]
                                              |                 keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                              |                 outputColumnNames:["_col0","_col1","_col2"]
-                                             |                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |                 Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                              |                 Select Operator [SEL_2]
                                              |                    outputColumnNames:["_col0","_col1","_col2"]
-                                             |                    Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |                    Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                              |                    Filter Operator [FIL_48]
                                              |                       predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
-                                             |                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             |                       Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                              |                       TableScan [TS_0]
                                              |                          alias:cbo_t2
                                              |                          Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -800,43 +800,43 @@ Stage-0
                                                    key expressions:_col0 (type: string)
                                                    Map-reduce partition columns:_col0 (type: string)
                                                    sort order:+
-                                                   Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                   Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                                    value expressions:_col1 (type: int), _col2 (type: bigint)
                                                    Select Operator [SEL_17]
                                                    |  outputColumnNames:["_col0","_col1","_col2"]
-                                                   |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                   |  Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                                    |<-Reducer 8 [SIMPLE_EDGE]
                                                       Reduce Output Operator [RS_16]
                                                          key expressions:_col3 (type: bigint), _col1 (type: int)
                                                          sort order:+-
-                                                         Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                         Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                                          value expressions:_col0 (type: string), _col2 (type: bigint)
                                                          Select Operator [SEL_15]
                                                             outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                            Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                            Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                                             Group By Operator [GBY_14]
                                                             |  aggregations:["sum(VALUE._col0)"]
                                                             |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                                             |  outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                            |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                            |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                             |<-Map 7 [SIMPLE_EDGE]
                                                                Reduce Output Operator [RS_13]
                                                                   key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                                   Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                                   sort order:+++
-                                                                  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                                   value expressions:_col3 (type: bigint)
                                                                   Group By Operator [GBY_12]
                                                                      aggregations:["sum(_col1)"]
                                                                      keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                                      outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                                     Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                     Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                                      Select Operator [SEL_10]
                                                                         outputColumnNames:["_col0","_col1","_col2"]
-                                                                        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                        Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                         Filter Operator [FIL_49]
                                                                            predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
-                                                                           Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                           Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                            TableScan [TS_8]
                                                                               alias:cbo_t1
                                                                               Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -861,36 +861,36 @@ Stage-0
          Reducer 5
          File Output Operator [FS_35]
             compressed:false
-            Statistics:Num rows: 2 Data size: 160 Basic stats: COMPLETE Column stats: NONE
+            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Group By Operator [GBY_33]
             |  aggregations:["count(VALUE._col0)"]
             |  keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
             |  outputColumnNames:["_col0","_col1","_col2"]
-            |  Statistics:Num rows: 2 Data size: 160 Basic stats: COMPLETE Column stats: NONE
+            |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Reducer 4 [SIMPLE_EDGE]
                Reduce Output Operator [RS_32]
                   key expressions:_col0 (type: int), _col1 (type: bigint)
                   Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
                   sort order:++
-                  Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+                  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   value expressions:_col2 (type: bigint)
                   Group By Operator [GBY_31]
                      aggregations:["count()"]
                      keys:_col0 (type: int), _col1 (type: bigint)
                      outputColumnNames:["_col0","_col1","_col2"]
-                     Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+                     Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                      Select Operator [SEL_29]
                         outputColumnNames:["_col0","_col1"]
-                        Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+                        Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                         Filter Operator [FIL_39]
                            predicate:(((_col1 + _col4) >= 2) and ((_col1 > 0) or (_col6 >= 0))) (type: boolean)
-                           Statistics:Num rows: 4 Data size: 320 Basic stats: COMPLETE Column stats: NONE
+                           Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                            Merge Join Operator [MERGEJOIN_44]
                            |  condition map:[{"":"Right Outer Join0 to 1"}]
                            |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                            |  outputColumnNames:["_col1","_col2","_col4","_col6"]
-                           |  Statistics:Num rows: 22 Data size: 1762 Basic stats: COMPLETE Column stats: NONE
+                           |  Statistics:Num rows: 4 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE
                            |<-Map 9 [SIMPLE_EDGE]
                            |  Reduce Output Operator [RS_26]
                            |     key expressions:_col0 (type: string)
@@ -909,46 +909,46 @@ Stage-0
                                  key expressions:_col0 (type: string)
                                  Map-reduce partition columns:_col0 (type: string)
                                  sort order:+
-                                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                 Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                  value expressions:_col1 (type: int), _col2 (type: bigint), _col4 (type: int)
                                  Select Operator [SEL_22]
                                     outputColumnNames:["_col0","_col1","_col2","_col4"]
-                                    Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                    Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                     Merge Join Operator [MERGEJOIN_43]
                                     |  condition map:[{"":"Left Outer Join0 to 1"}]
                                     |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                     |  outputColumnNames:["_col1","_col2","_col3","_col4"]
-                                    |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                    |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                     |<-Reducer 2 [SIMPLE_EDGE]
                                     |  Reduce Output Operator [RS_19]
                                     |     key expressions:_col0 (type: string)
                                     |     Map-reduce partition columns:_col0 (type: string)
                                     |     sort order:+
-                                    |     Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |     Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                     |     value expressions:_col1 (type: int)
                                     |     Select Operator [SEL_7]
                                     |        outputColumnNames:["_col0","_col1"]
-                                    |        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |        Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                     |        Group By Operator [GBY_6]
                                     |        |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                     |        |  outputColumnNames:["_col0","_col1","_col2"]
-                                    |        |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |        |  Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                     |        |<-Map 1 [SIMPLE_EDGE]
                                     |           Reduce Output Operator [RS_5]
                                     |              key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                     |              Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                     |              sort order:+++
-                                    |              Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |              Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                     |              Group By Operator [GBY_4]
                                     |                 keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                     |                 outputColumnNames:["_col0","_col1","_col2"]
-                                    |                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |                 Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                     |                 Select Operator [SEL_2]
                                     |                    outputColumnNames:["_col0","_col1","_col2"]
-                                    |                    Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |                    Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                     |                    Filter Operator [FIL_41]
                                     |                       predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
-                                    |                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                    |                       Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                     |                       TableScan [TS_0]
                                     |                          alias:cbo_t2
                                     |                          Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -957,43 +957,43 @@ Stage-0
                                           key expressions:_col0 (type: string)
                                           Map-reduce partition columns:_col0 (type: string)
                                           sort order:+
-                                          Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                           value expressions:_col1 (type: int), _col2 (type: bigint)
                                           Select Operator [SEL_17]
                                           |  outputColumnNames:["_col0","_col1","_col2"]
-                                          |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |  Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                           |<-Reducer 7 [SIMPLE_EDGE]
                                              Reduce Output Operator [RS_16]
                                                 key expressions:_col3 (type: bigint), _col0 (type: string)
                                                 sort order:+-
-                                                Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                                 value expressions:_col1 (type: int), _col2 (type: bigint)
                                                 Select Operator [SEL_15]
                                                    outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                   Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                   Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                                    Group By Operator [GBY_14]
                                                    |  aggregations:["sum(VALUE._col0)"]
                                                    |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                                    |  outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                   |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                   |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                    |<-Map 6 [SIMPLE_EDGE]
                                                       Reduce Output Operator [RS_13]
                                                          key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                          Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                          sort order:+++
-                                                         Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                         Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                          value expressions:_col3 (type: bigint)
                                                          Group By Operator [GBY_12]
                                                             aggregations:["sum(_col1)"]
                                                             keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                             outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                            Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                            Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                             Select Operator [SEL_10]
                                                                outputColumnNames:["_col0","_col1","_col2"]
-                                                               Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                               Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                Filter Operator [FIL_42]
                                                                   predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
-                                                                  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                  Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                   TableScan [TS_8]
                                                                      alias:cbo_t1
                                                                      Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1020,45 +1020,45 @@ Stage-0
          Reducer 7
          File Output Operator [FS_41]
             compressed:false
-            Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Select Operator [SEL_40]
             |  outputColumnNames:["_col0","_col1","_col2"]
-            |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+            |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Reducer 6 [SIMPLE_EDGE]
                Reduce Output Operator [RS_39]
                   key expressions:_col0 (type: int)
                   sort order:+
-                  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   value expressions:_col1 (type: bigint), _col2 (type: bigint)
                   Group By Operator [GBY_37]
                   |  aggregations:["count(VALUE._col0)"]
                   |  keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
                   |  outputColumnNames:["_col0","_col1","_col2"]
-                  |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                  |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   |<-Reducer 5 [SIMPLE_EDGE]
                      Reduce Output Operator [RS_36]
                         key expressions:_col0 (type: int), _col1 (type: bigint)
                         Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
                         sort order:++
-                        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                        Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                         value expressions:_col2 (type: bigint)
                         Group By Operator [GBY_35]
                            aggregations:["count()"]
                            keys:_col0 (type: int), _col1 (type: bigint)
                            outputColumnNames:["_col0","_col1","_col2"]
-                           Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                           Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                            Select Operator [SEL_33]
                               outputColumnNames:["_col0","_col1"]
-                              Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                              Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                               Filter Operator [FIL_44]
                                  predicate:(((((_col1 + _col4) >= 0) and ((_col1 > 0) or (_col6 >= 0))) and ((_col6 >= 1) or (_col2 >= 1))) and ((UDFToLong(_col6) + _col2) >= 0)) (type: boolean)
-                                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                 Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                                  Merge Join Operator [MERGEJOIN_50]
                                  |  condition map:[{"":"Right Outer Join0 to 1"}]
                                  |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                  |  outputColumnNames:["_col1","_col2","_col4","_col6"]
-                                 |  Statistics:Num rows: 6 Data size: 489 Basic stats: COMPLETE Column stats: NONE
+                                 |  Statistics:Num rows: 3 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE
                                  |<-Map 11 [SIMPLE_EDGE]
                                  |  Reduce Output Operator [RS_30]
                                  |     key expressions:_col0 (type: string)
@@ -1080,58 +1080,58 @@ Stage-0
                                        key expressions:_col0 (type: string)
                                        Map-reduce partition columns:_col0 (type: string)
                                        sort order:+
-                                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                       Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                        value expressions:_col1 (type: int), _col2 (type: bigint), _col4 (type: int)
                                        Select Operator [SEL_25]
                                           outputColumnNames:["_col0","_col1","_col2","_col4"]
-                                          Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                          Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                           Merge Join Operator [MERGEJOIN_49]
                                           |  condition map:[{"":"Outer Join 0 to 1"}]
                                           |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                           |  outputColumnNames:["_col1","_col2","_col3","_col4"]
-                                          |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                          |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                           |<-Reducer 10 [SIMPLE_EDGE]
                                           |  Reduce Output Operator [RS_23]
                                           |     key expressions:_col0 (type: string)
                                           |     Map-reduce partition columns:_col0 (type: string)
                                           |     sort order:+
-                                          |     Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |     Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                           |     value expressions:_col1 (type: int), _col2 (type: bigint)
                                           |     Select Operator [SEL_20]
                                           |     |  outputColumnNames:["_col0","_col1","_col2"]
-                                          |     |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |     |  Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                           |     |<-Reducer 9 [SIMPLE_EDGE]
                                           |        Reduce Output Operator [RS_19]
                                           |           key expressions:_col3 (type: double)
                                           |           sort order:-
-                                          |           Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |           Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                           |           value expressions:_col0 (type: string), _col1 (type: int), _col2 (type: bigint)
                                           |           Select Operator [SEL_18]
                                           |              outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                          |              Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |              Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                           |              Group By Operator [GBY_17]
                                           |              |  aggregations:["sum(VALUE._col0)"]
                                           |              |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                           |              |  outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                          |              |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |              |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                           |              |<-Map 8 [SIMPLE_EDGE]
                                           |                 Reduce Output Operator [RS_16]
                                           |                    key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                           |                    Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                           |                    sort order:+++
-                                          |                    Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |                    Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                           |                    value expressions:_col3 (type: bigint)
                                           |                    Group By Operator [GBY_15]
                                           |                       aggregations:["sum(_col1)"]
                                           |                       keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                           |                       outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                          |                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |                       Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                           |                       Select Operator [SEL_13]
                                           |                          outputColumnNames:["_col0","_col1","_col2"]
-                                          |                          Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |                          Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                           |                          Filter Operator [FIL_47]
                                           |                             predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
-                                          |                             Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                          |                             Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                           |                             TableScan [TS_11]
                                           |                                alias:cbo_t1
                                           |                                Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1140,43 +1140,43 @@ Stage-0
                                                 key expressions:_col0 (type: string)
                                                 Map-reduce partition columns:_col0 (type: string)
                                                 sort order:+
-                                                Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                                 value expressions:_col1 (type: int)
                                                 Select Operator [SEL_9]
                                                 |  outputColumnNames:["_col0","_col1"]
-                                                |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                |  Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                                 |<-Reducer 2 [SIMPLE_EDGE]
                                                    Reduce Output Operator [RS_8]
                                                       key expressions:_col3 (type: double), _col2 (type: bigint)
                                                       sort order:-+
-                                                      Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                      Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                                       value expressions:_col0 (type: string), _col1 (type: int)
                                                       Select Operator [SEL_7]
                                                          outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                         Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                         Statistics:Num rows: 1 Data size: 105 Basic stats: COMPLETE Column stats: COMPLETE
                                                          Group By Operator [GBY_6]
                                                          |  aggregations:["sum(VALUE._col0)"]
                                                          |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                                          |  outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                         |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                         |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                          |<-Map 1 [SIMPLE_EDGE]
                                                             Reduce Output Operator [RS_5]
                                                                key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                                Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                                sort order:+++
-                                                               Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                               Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                                value expressions:_col3 (type: bigint)
                                                                Group By Operator [GBY_4]
                                                                   aggregations:["sum(_col1)"]
                                                                   keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                                   outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                                  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                                   Select Operator [SEL_2]
                                                                      outputColumnNames:["_col0","_col1","_col2"]
-                                                                     Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                     Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                      Filter Operator [FIL_46]
                                                                         predicate:((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) (type: boolean)
-                                                                        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                                        Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                         TableScan [TS_0]
                                                                            alias:cbo_t2
                                                                            Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1200,36 +1200,36 @@ Stage-0
          Reducer 3
          File Output Operator [FS_39]
             compressed:false
-            Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Group By Operator [GBY_37]
             |  aggregations:["count(VALUE._col0)"]
             |  keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
             |  outputColumnNames:["_col0","_col1","_col2"]
-            |  Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+            |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Reducer 2 [SIMPLE_EDGE]
                Reduce Output Operator [RS_36]
                   key expressions:_col0 (type: int), _col1 (type: bigint)
                   Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
                   sort order:++
-                  Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                   value expressions:_col2 (type: bigint)
                   Group By Operator [GBY_35]
                      aggregations:["count()"]
                      keys:_col0 (type: int), _col1 (type: bigint)
                      outputColumnNames:["_col0","_col1","_col2"]
-                     Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                     Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                      Select Operator [SEL_31]
                         outputColumnNames:["_col0","_col1"]
-                        Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                        Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
                         Filter Operator [FIL_45]
                            predicate:((_col3 > 0) or (_col1 >= 0)) (type: boolean)
-                           Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                           Statistics:Num rows: 2 Data size: 32 Basic stats: COMPLETE Column stats: COMPLETE
                            Merge Join Operator [MERGEJOIN_51]
                            |  condition map:[{"":"Inner Join 0 to 1"}]
                            |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                            |  outputColumnNames:["_col1","_col3","_col4"]
-                           |  Statistics:Num rows: 19 Data size: 1566 Basic stats: COMPLETE Column stats: NONE
+                           |  Statistics:Num rows: 3 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE
                            |<-Map 1 [SIMPLE_EDGE]
                            |  Reduce Output Operator [RS_27]
                            |     key expressions:_col0 (type: string)
@@ -1251,49 +1251,49 @@ Stage-0
                                  key expressions:_col0 (type: string)
                                  Map-reduce partition columns:_col0 (type: string)
                                  sort order:+
-                                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                 Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                  value expressions:_col1 (type: int), _col2 (type: bigint)
                                  Select Operator [SEL_23]
                                     outputColumnNames:["_col0","_col1","_col2"]
-                                    Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                    Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                     Filter Operator [FIL_47]
                                        predicate:((_col3 + _col1) >= 0) (type: boolean)
-                                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                       Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                        Merge Join Operator [MERGEJOIN_50]
                                        |  condition map:[{"":"Inner Join 0 to 1"}]
                                        |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                                        |  outputColumnNames:["_col1","_col2","_col3","_col4"]
-                                       |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+                                       |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                        |<-Reducer 5 [SIMPLE_EDGE]
                                        |  Reduce Output Operator [RS_19]
                                        |     key expressions:_col0 (type: string)
                                        |     Map-reduce partition columns:_col0 (type: string)
                                        |     sort order:+
-                                       |     Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |     Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                        |     value expressions:_col1 (type: int)
                                        |     Select Operator [SEL_9]
                                        |        outputColumnNames:["_col0","_col1"]
-                                       |        Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |        Statistics:Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE
                                        |        Group By Operator [GBY_8]
                                        |        |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                        |        |  outputColumnNames:["_col0","_col1","_col2"]
-                                       |        |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |        |  Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                        |        |<-Map 4 [SIMPLE_EDGE]
                                        |           Reduce Output Operator [RS_7]
                                        |              key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                        |              Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                        |              sort order:+++
-                                       |              Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |              Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                        |              Group By Operator [GBY_6]
                                        |                 keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                        |                 outputColumnNames:["_col0","_col1","_col2"]
-                                       |                 Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |                 Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                        |                 Select Operator [SEL_4]
                                        |                    outputColumnNames:["_col0","_col1","_col2"]
-                                       |                    Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |                    Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                        |                    Filter Operator [FIL_48]
                                        |                       predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
-                                       |                       Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                       |                       Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                        |                       TableScan [TS_2]
                                        |                          alias:cbo_t2
                                        |                          Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1302,34 +1302,34 @@ Stage-0
                                              key expressions:_col0 (type: string)
                                              Map-reduce partition columns:_col0 (type: string)
                                              sort order:+
-                                             Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                             Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                              value expressions:_col1 (type: int), _col2 (type: bigint)
                                              Select Operator [SEL_17]
                                                 outputColumnNames:["_col0","_col1","_col2"]
-                                                Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                Statistics:Num rows: 1 Data size: 97 Basic stats: COMPLETE Column stats: COMPLETE
                                                 Group By Operator [GBY_16]
                                                 |  aggregations:["sum(VALUE._col0)"]
                                                 |  keys:KEY._col0 (type: float), KEY._col1 (type: int), KEY._col2 (type: string)
                                                 |  outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                |  Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                |  Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                 |<-Map 7 [SIMPLE_EDGE]
                                                    Reduce Output Operator [RS_15]
                                                       key expressions:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                       Map-reduce partition columns:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                       sort order:+++
-                                                      Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                      Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                       value expressions:_col3 (type: bigint)
                                                       Group By Operator [GBY_14]
                                                          aggregations:["sum(_col1)"]
                                                          keys:_col0 (type: float), _col1 (type: int), _col2 (type: string)
                                                          outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                         Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                         Statistics:Num rows: 1 Data size: 101 Basic stats: COMPLETE Column stats: COMPLETE
                                                          Select Operator [SEL_12]
                                                             outputColumnNames:["_col0","_col1","_col2"]
-                                                            Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                            Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                             Filter Operator [FIL_49]
                                                                predicate:(((((((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0.0))) and (c_float > 0.0)) and ((c_int >= 1) or (c_float >= 1.0))) and ((UDFToFloat(c_int) + c_float) >= 0.0)) and key is not null) (type: boolean)
-                                                               Statistics:Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+                                                               Statistics:Num rows: 1 Data size: 93 Basic stats: COMPLETE Column stats: COMPLETE
                                                                TableScan [TS_10]
                                                                   alias:cbo_t1
                                                                   Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1399,21 +1399,24 @@ Stage-0
          Reducer 4
          File Output Operator [FS_29]
             compressed:false
-            Statistics:Num rows: 3 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+            Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Select Operator [SEL_28]
             |  outputColumnNames:["_col0"]
-            |  Statistics:Num rows: 3 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+            |  Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Union 3 [SIMPLE_EDGE]
                |<-Reducer 2 [CONTAINS]
                |  Reduce Output Operator [RS_27]
                |     key expressions:_col0 (type: string)
                |     sort order:+
+               |     Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
                |     Select Operator [SEL_6]
                |        outputColumnNames:["_col0"]
+               |        Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
                |        Group By Operator [GBY_5]
                |        |  aggregations:["count(VALUE._col0)"]
                |        |  outputColumnNames:["_col0"]
+               |        |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                |        |<-Map 1 [SIMPLE_EDGE]
                |           Reduce Output Operator [RS_4]
                |              sort order:
@@ -1433,11 +1436,14 @@ Stage-0
                |  Reduce Output Operator [RS_27]
                |     key expressions:_col0 (type: string)
                |     sort order:+
+               |     Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
                |     Select Operator [SEL_14]
                |        outputColumnNames:["_col0"]
+               |        Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
                |        Group By Operator [GBY_13]
                |        |  aggregations:["count(VALUE._col0)"]
                |        |  outputColumnNames:["_col0"]
+               |        |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                |        |<-Map 5 [SIMPLE_EDGE]
                |           Reduce Output Operator [RS_12]
                |              sort order:
@@ -1457,11 +1463,14 @@ Stage-0
                   Reduce Output Operator [RS_27]
                      key expressions:_col0 (type: string)
                      sort order:+
+                     Statistics:Num rows: 3 Data size: 261 Basic stats: COMPLETE Column stats: COMPLETE
                      Select Operator [SEL_24]
                         outputColumnNames:["_col0"]
+                        Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
                         Group By Operator [GBY_23]
                         |  aggregations:["count(VALUE._col0)"]
                         |  outputColumnNames:["_col0"]
+                        |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                         |<-Map 7 [SIMPLE_EDGE]
                            Reduce Output Operator [RS_22]
                               sort order:
@@ -1505,38 +1514,42 @@ Stage-0
          Reducer 5
          File Output Operator [FS_34]
             compressed:false
-            Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+            Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Select Operator [SEL_33]
             |  outputColumnNames:["_col0","_col1"]
-            |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+            |  Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
             |<-Reducer 4 [SIMPLE_EDGE]
                Reduce Output Operator [RS_32]
                   key expressions:_col0 (type: string)
                   sort order:+
-                  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+                  Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                   value expressions:_col1 (type: bigint)
                   Group By Operator [GBY_30]
                   |  aggregations:["count(VALUE._col0)"]
                   |  keys:KEY._col0 (type: string)
                   |  outputColumnNames:["_col0","_col1"]
-                  |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+                  |  Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                   |<-Union 3 [SIMPLE_EDGE]
                      |<-Reducer 2 [CONTAINS]
                      |  Reduce Output Operator [RS_29]
                      |     key expressions:_col0 (type: string)
                      |     Map-reduce partition columns:_col0 (type: string)
                      |     sort order:+
+                     |     Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                      |     value expressions:_col1 (type: bigint)
                      |     Group By Operator [GBY_28]
                      |        aggregations:["count(1)"]
                      |        keys:_col0 (type: string)
                      |        outputColumnNames:["_col0","_col1"]
+                     |        Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                      |        Select Operator [SEL_6]
                      |           outputColumnNames:["_col0"]
+                     |           Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
                      |           Group By Operator [GBY_5]
                      |           |  aggregations:["count(VALUE._col0)"]
                      |           |  outputColumnNames:["_col0"]
+                     |           |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                      |           |<-Map 1 [SIMPLE_EDGE]
                      |              Reduce Output Operator [RS_4]
                      |                 sort order:
@@ -1557,16 +1570,20 @@ Stage-0
                      |     key expressions:_col0 (type: string)
                      |     Map-reduce partition columns:_col0 (type: string)
                      |     sort order:+
+                     |     Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                      |     value expressions:_col1 (type: bigint)
                      |     Group By Operator [GBY_28]
                      |        aggregations:["count(1)"]
                      |        keys:_col0 (type: string)
                      |        outputColumnNames:["_col0","_col1"]
+                     |        Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                      |        Select Operator [SEL_14]
                      |           outputColumnNames:["_col0"]
+                     |           Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
                      |           Group By Operator [GBY_13]
                      |           |  aggregations:["count(VALUE._col0)"]
                      |           |  outputColumnNames:["_col0"]
+                     |           |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                      |           |<-Map 6 [SIMPLE_EDGE]
                      |              Reduce Output Operator [RS_12]
                      |                 sort order:
@@ -1587,16 +1604,20 @@ Stage-0
                            key expressions:_col0 (type: string)
                            Map-reduce partition columns:_col0 (type: string)
                            sort order:+
+                           Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                            value expressions:_col1 (type: bigint)
                            Group By Operator [GBY_28]
                               aggregations:["count(1)"]
                               keys:_col0 (type: string)
                               outputColumnNames:["_col0","_col1"]
+                              Statistics:Num rows: 1 Data size: 95 Basic stats: COMPLETE Column stats: COMPLETE
                               Select Operator [SEL_24]
                                  outputColumnNames:["_col0"]
+                                 Statistics:Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
                                  Group By Operator [GBY_23]
                                  |  aggregations:["count(VALUE._col0)"]
                                  |  outputColumnNames:["_col0"]
+                                 |  Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                                  |<-Map 8 [SIMPLE_EDGE]
                                     Reduce Output Operator [RS_22]
                                        sort order:
@@ -1933,19 +1954,19 @@ Stage-0
          Reducer 3
          File Output Operator [FS_20]
             compressed:false
-            Statistics:Num rows: 8 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+            Statistics:Num rows: 8 Data size: 808 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Select Operator [SEL_19]
                outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
-               Statistics:Num rows: 8 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+               Statistics:Num rows: 8 Data size: 808 Basic stats: COMPLETE Column stats: COMPLETE
                Filter Operator [FIL_18]
                   predicate:((_col1 > 0) or (_col6 >= 0)) (type: boolean)
-                  Statistics:Num rows: 8 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+                  Statistics:Num rows: 8 Data size: 808 Basic stats: COMPLETE Column stats: COMPLETE
                   Merge Join Operator [MERGEJOIN_29]
                   |  condition map:[{"":"Inner Join 0 to 1"}]
                   |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
                   |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6"]
-                  |  Statistics:Num rows: 14 Data size: 168 Basic stats: COMPLETE Column stats: COMPLETE
+                  |  Statistics:Num rows: 14 Data size: 1414 Basic stats: COMPLETE Column stats: COMPLETE
                   |<-Map 5 [SIMPLE_EDGE]
                   |  Reduce Output Operator [RS_16]
                   |     key expressions:_col0 (type: string)
@@ -2292,26 +2313,26 @@ Stage-0
          Reducer 4
          File Output Operator [FS_13]
             compressed:false
-            Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+            Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Limit [LIM_12]
                Number of rows:5
-               Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+               Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
                Select Operator [SEL_11]
                |  outputColumnNames:["_col0","_col1"]
-               |  Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+               |  Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
                |<-Reducer 3 [SIMPLE_EDGE]
                   Reduce Output Operator [RS_10]
                      key expressions:_col1 (type: int)
                      sort order:+
-                     Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+                     Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
                      value expressions:_col0 (type: string)
                      Limit [LIM_8]
                         Number of rows:5
-                        Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+                        Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
                         Select Operator [SEL_7]
                         |  outputColumnNames:["_col0","_col1"]
-                        |  Statistics:Num rows: 5 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+                        |  Statistics:Num rows: 5 Data size: 356 Basic stats: COMPLETE Column stats: COMPLETE
                         |<-Reducer 2 [SIMPLE_EDGE]
                            Reduce Output Operator [RS_6]
                               key expressions:_col1 (type: int)
@@ -2359,48 +2380,48 @@ Stage-0
          Reducer 4
          File Output Operator [FS_50]
             compressed:false
-            Statistics:Num rows: 5 Data size: 410 Basic stats: COMPLETE Column stats: NONE
+            Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
             table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"}
             Limit [LIM_49]
                Number of rows:5
-               Statistics:Num rows: 5 Data size: 410 Basic stats: COMPLETE Column stats: NONE
+               Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                Select Operator [SEL_48]
                |  outputColumnNames:["_col0","_col1","_col2"]
-               |  Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+               |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                |<-Reducer 3 [SIMPLE_EDGE]
                   Reduce Output Operator [RS_47]
                      key expressions:(UDFToLong(_col0) + _col1) (type: bigint), _col1 (type: bigint)
                      sort order:-+
-                     Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+                     Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                      value expressions:_col0 (type: int), _col2 (type: bigint)
                      Group By Operator [GBY_45]
                      |  aggregations:["count(VALUE._col0)"]
                      |  keys:KEY._col0 (type: int), KEY._col1 (type: bigint)
                      |  outputColumnNames:["_col0","_col1","_col2"]
-                     |  Statistics:Num rows: 6 Data size: 494 Basic stats: COMPLETE Column stats: NONE
+                     |  Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                      |<-Reducer 2 [SIMPLE_EDGE]
                         Reduce Output Operator [RS_44]
                            key expressions:_col0 (type: int), _col1 (type: bigint)
                            Map-reduce partition columns:_col0 (type: int), _col1 (type: bigint)
                            sort order:++
-                           Statistics:Num rows: 12 Data size: 989 Basic stats: COMPLETE Column stats: NONE
+                           Statistics:Num rows: 1 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE
                            value expressions:_col2 (type: bigint)
                            Group By Operator [GBY_43]
                               aggregations:["count()"]
                               keys:_col0 (type: int), _col1 (typ

<TRUNCATED>

Mime
View raw message