hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [28/39] hive git commit: HIVE-12181 : Change hive.stats.fetch.column.stats value to true for MiniTezCliDriver (Ashutosh Chauhan via Jesus Camacho Rodriguez)
Date Wed, 10 Aug 2016 16:33:07 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/17ddc9a1/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 fe89d81..de4e5f9 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
@@ -56,10 +56,10 @@ Stage-3
               Map 1
               File Output Operator [FS_3]
                 table:{"name:":"default.src_orc_merge_test_part"}
-                Select Operator [SEL_1] (rows=500 width=10)
+                Select Operator [SEL_1] (rows=500 width=95)
                   Output:["_col0","_col1"]
-                  TableScan [TS_0] (rows=500 width=10)
-                    default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+                  TableScan [TS_0] (rows=500 width=178)
+                    default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
 
 PREHOOK: query: insert overwrite table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src
 PREHOOK: type: QUERY
@@ -91,20 +91,20 @@ Stage-3
               Reducer 2
               File Output Operator [FS_7]
                 table:{"name:":"default.src_orc_merge_test_part"}
-                Select Operator [SEL_6] (rows=100 width=10)
+                Select Operator [SEL_6] (rows=100 width=95)
                   Output:["_col0","_col1"]
-                  Limit [LIM_5] (rows=100 width=10)
+                  Limit [LIM_5] (rows=100 width=178)
                     Number of rows:100
-                    Select Operator [SEL_4] (rows=100 width=10)
+                    Select Operator [SEL_4] (rows=100 width=178)
                       Output:["_col0","_col1"]
                     <-Map 1 [SIMPLE_EDGE]
                       SHUFFLE [RS_3]
-                        Limit [LIM_2] (rows=100 width=10)
+                        Limit [LIM_2] (rows=100 width=178)
                           Number of rows:100
-                          Select Operator [SEL_1] (rows=500 width=10)
+                          Select Operator [SEL_1] (rows=500 width=178)
                             Output:["_col0","_col1"]
-                            TableScan [TS_0] (rows=500 width=10)
-                              default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+                            TableScan [TS_0] (rows=500 width=178)
+                              default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
 
 PREHOOK: query: explain select count(1) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
 PREHOOK: type: QUERY
@@ -127,9 +127,9 @@ Stage-0
           SHUFFLE [RS_5]
             Group By Operator [GBY_4] (rows=1 width=8)
               Output:["_col0"],aggregations:["count(1)"]
-              Select Operator [SEL_2] (rows=500 width=94)
-                TableScan [TS_0] (rows=500 width=94)
-                  default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE
+              Select Operator [SEL_2] (rows=500 width=102)
+                TableScan [TS_0] (rows=500 width=102)
+                  default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:COMPLETE
 
 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
@@ -152,9 +152,9 @@ Stage-0
           SHUFFLE [RS_5]
             Group By Operator [GBY_4] (rows=1 width=16)
               Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
-              Select Operator [SEL_2] (rows=500 width=94)
+              Select Operator [SEL_2] (rows=500 width=102)
                 Output:["_col0","_col1"]
-                TableScan [TS_0] (rows=500 width=94)
+                TableScan [TS_0] (rows=500 width=102)
                   default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
 
 PREHOOK: query: alter table src_orc_merge_test_part partition (ds='2012-01-03', ts='2012-01-03+14:46:31') concatenate
@@ -186,9 +186,9 @@ Stage-0
           SHUFFLE [RS_5]
             Group By Operator [GBY_4] (rows=1 width=8)
               Output:["_col0"],aggregations:["count(1)"]
-              Select Operator [SEL_2] (rows=500 width=94)
-                TableScan [TS_0] (rows=500 width=94)
-                  default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE
+              Select Operator [SEL_2] (rows=500 width=102)
+                TableScan [TS_0] (rows=500 width=102)
+                  default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:COMPLETE
 
 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
@@ -211,9 +211,9 @@ Stage-0
           SHUFFLE [RS_5]
             Group By Operator [GBY_4] (rows=1 width=16)
               Output:["_col0","_col1"],aggregations:["sum(_col0)","sum(_col1)"]
-              Select Operator [SEL_2] (rows=500 width=94)
+              Select Operator [SEL_2] (rows=500 width=102)
                 Output:["_col0","_col1"]
-                TableScan [TS_0] (rows=500 width=94)
+                TableScan [TS_0] (rows=500 width=102)
                   default@src_orc_merge_test_part,src_orc_merge_test_part,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
 
 PREHOOK: query: drop table src_orc_merge_test_part
@@ -264,26 +264,26 @@ Stage-0
           SHUFFLE [RS_14]
             Group By Operator [GBY_13] (rows=1 width=8)
               Output:["_col0"],aggregations:["sum(hash(_col0,_col1,_col2,_col3))"]
-              Select Operator [SEL_11] (rows=27556 width=22)
+              Select Operator [SEL_11] (rows=27556 width=356)
                 Output:["_col0","_col1","_col2","_col3"]
               <-Map 1 [SIMPLE_EDGE]
                 SHUFFLE [RS_10]
-                  Map Join Operator [MAPJOIN_20] (rows=27556 width=22)
+                  Map Join Operator [MAPJOIN_20] (rows=27556 width=356)
                     Conds:(Inner),Output:["_col0","_col1","_col2","_col3"]
                   <-Map 4 [BROADCAST_EDGE]
                     BROADCAST [RS_7]
-                      Select Operator [SEL_5] (rows=166 width=10)
+                      Select Operator [SEL_5] (rows=166 width=178)
                         Output:["_col0","_col1"]
-                        Filter Operator [FIL_19] (rows=166 width=10)
+                        Filter Operator [FIL_19] (rows=166 width=178)
                           predicate:(key < 10)
-                          TableScan [TS_3] (rows=500 width=10)
-                            default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
-                  <-Select Operator [SEL_2] (rows=166 width=10)
+                          TableScan [TS_3] (rows=500 width=178)
+                            default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
+                  <-Select Operator [SEL_2] (rows=166 width=178)
                       Output:["_col0","_col1"]
-                      Filter Operator [FIL_18] (rows=166 width=10)
+                      Filter Operator [FIL_18] (rows=166 width=178)
                         predicate:(key < 10)
-                        TableScan [TS_0] (rows=500 width=10)
-                          default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+                        TableScan [TS_0] (rows=500 width=178)
+                          default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
 
 PREHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1 group by c_float, cbo_t1.c_int, key
 PREHOOK: type: QUERY
@@ -300,19 +300,19 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_7]
-        Select Operator [SEL_5] (rows=10 width=97)
+        Select Operator [SEL_5] (rows=10 width=21)
           Output:["_col0","_col1","_col2"]
-          Group By Operator [GBY_4] (rows=10 width=101)
+          Group By Operator [GBY_4] (rows=10 width=21)
             Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
           <-Map 1 [SIMPLE_EDGE]
             SHUFFLE [RS_3]
               PartitionCols:_col0, _col1, _col2
-              Group By Operator [GBY_2] (rows=10 width=101)
+              Group By Operator [GBY_2] (rows=20 width=21)
                 Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                Select Operator [SEL_1] (rows=20 width=88)
+                Select Operator [SEL_1] (rows=20 width=21)
                   Output:["key","c_int","c_float"]
-                  TableScan [TS_0] (rows=20 width=88)
-                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                  TableScan [TS_0] (rows=20 width=21)
+                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select x, y, count(*) from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float, cbo_t1.c_int, key) R group by y, x
 PREHOOK: type: QUERY
@@ -330,28 +330,28 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_12]
-        Select Operator [SEL_11] (rows=5 width=20)
+        Select Operator [SEL_11] (rows=5 width=21)
           Output:["_col0","_col1","_col2"]
-          Group By Operator [GBY_10] (rows=5 width=20)
+          Group By Operator [GBY_10] (rows=5 width=21)
             Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
           <-Reducer 2 [SIMPLE_EDGE]
             SHUFFLE [RS_9]
               PartitionCols:_col0, _col1
-              Group By Operator [GBY_8] (rows=5 width=20)
+              Group By Operator [GBY_8] (rows=10 width=21)
                 Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col0, _col1
-                Select Operator [SEL_5] (rows=10 width=101)
+                Select Operator [SEL_5] (rows=10 width=21)
                   Output:["_col0","_col1"]
-                  Group By Operator [GBY_4] (rows=10 width=101)
+                  Group By Operator [GBY_4] (rows=10 width=21)
                     Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                   <-Map 1 [SIMPLE_EDGE]
                     SHUFFLE [RS_3]
                       PartitionCols:_col0, _col1, _col2
-                      Group By Operator [GBY_2] (rows=10 width=101)
+                      Group By Operator [GBY_2] (rows=20 width=21)
                         Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                        Select Operator [SEL_1] (rows=20 width=88)
+                        Select Operator [SEL_1] (rows=20 width=21)
                           Output:["key","c_int","c_float"]
-                          TableScan [TS_0] (rows=20 width=88)
-                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                          TableScan [TS_0] (rows=20 width=21)
+                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key order by a) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c
 PREHOOK: type: QUERY
@@ -375,24 +375,24 @@ Stage-0
     Stage-1
       Reducer 7
       File Output Operator [FS_42]
-        Select Operator [SEL_41] (rows=1 width=20)
+        Select Operator [SEL_41] (rows=6 width=87)
           Output:["_col0","_col1","_col2"]
         <-Reducer 6 [SIMPLE_EDGE]
           SHUFFLE [RS_40]
-            Select Operator [SEL_38] (rows=1 width=20)
+            Select Operator [SEL_38] (rows=6 width=87)
               Output:["_col0","_col1","_col2"]
-              Group By Operator [GBY_37] (rows=1 width=20)
+              Group By Operator [GBY_37] (rows=6 width=87)
                 Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
               <-Reducer 5 [SIMPLE_EDGE]
                 SHUFFLE [RS_36]
                   PartitionCols:_col0, _col1
-                  Group By Operator [GBY_35] (rows=1 width=20)
+                  Group By Operator [GBY_35] (rows=12 width=87)
                     Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col2, _col6
-                    Select Operator [SEL_34] (rows=3 width=16)
+                    Select Operator [SEL_34] (rows=12 width=87)
                       Output:["_col2","_col6"]
-                      Filter Operator [FIL_33] (rows=3 width=16)
+                      Filter Operator [FIL_33] (rows=12 width=87)
                         predicate:((_col1 > 0) or (_col6 >= 0))
-                        Merge Join Operator [MERGEJOIN_52] (rows=3 width=16)
+                        Merge Join Operator [MERGEJOIN_52] (rows=19 width=87)
                           Conds:RS_30._col0=RS_31._col0(Inner),Output:["_col1","_col2","_col6"]
                         <-Map 11 [SIMPLE_EDGE]
                           SHUFFLE [RS_31]
@@ -406,52 +406,52 @@ Stage-0
                         <-Reducer 4 [SIMPLE_EDGE]
                           SHUFFLE [RS_30]
                             PartitionCols:_col0
-                            Select Operator [SEL_26] (rows=1 width=101)
+                            Select Operator [SEL_26] (rows=1 width=23)
                               Output:["_col0","_col1","_col2"]
-                              Filter Operator [FIL_25] (rows=1 width=101)
+                              Filter Operator [FIL_25] (rows=1 width=23)
                                 predicate:((_col1 + _col4) >= 0)
-                                Merge Join Operator [MERGEJOIN_51] (rows=1 width=101)
+                                Merge Join Operator [MERGEJOIN_51] (rows=2 width=23)
                                   Conds:RS_22._col0=RS_23._col0(Inner),Output:["_col0","_col1","_col2","_col4"]
                                 <-Reducer 10 [SIMPLE_EDGE]
                                   SHUFFLE [RS_23]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_20] (rows=1 width=89)
+                                    Select Operator [SEL_20] (rows=2 width=21)
                                       Output:["_col0","_col1"]
                                     <-Reducer 9 [SIMPLE_EDGE]
                                       SHUFFLE [RS_19]
-                                        Select Operator [SEL_17] (rows=1 width=105)
+                                        Select Operator [SEL_17] (rows=2 width=21)
                                           Output:["_col0","_col1","_col2","_col3"]
-                                          Group By Operator [GBY_16] (rows=1 width=101)
+                                          Group By Operator [GBY_16] (rows=2 width=21)
                                             Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                           <-Map 8 [SIMPLE_EDGE]
                                             SHUFFLE [RS_15]
                                               PartitionCols:_col0, _col1, _col2
-                                              Group By Operator [GBY_14] (rows=2 width=101)
+                                              Group By Operator [GBY_14] (rows=4 width=21)
                                                 Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                                Filter Operator [FIL_49] (rows=5 width=93)
+                                                Filter Operator [FIL_49] (rows=4 width=21)
                                                   predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                                                  TableScan [TS_11] (rows=20 width=88)
-                                                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                                  TableScan [TS_11] (rows=20 width=21)
+                                                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                                 <-Reducer 3 [SIMPLE_EDGE]
                                   SHUFFLE [RS_22]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_9] (rows=1 width=97)
+                                    Select Operator [SEL_9] (rows=2 width=21)
                                       Output:["_col0","_col1","_col2"]
                                     <-Reducer 2 [SIMPLE_EDGE]
                                       SHUFFLE [RS_8]
-                                        Select Operator [SEL_6] (rows=1 width=97)
+                                        Select Operator [SEL_6] (rows=2 width=21)
                                           Output:["_col0","_col1","_col2"]
-                                          Group By Operator [GBY_5] (rows=1 width=101)
+                                          Group By Operator [GBY_5] (rows=2 width=21)
                                             Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                           <-Map 1 [SIMPLE_EDGE]
                                             SHUFFLE [RS_4]
                                               PartitionCols:_col0, _col1, _col2
-                                              Group By Operator [GBY_3] (rows=2 width=101)
+                                              Group By Operator [GBY_3] (rows=4 width=21)
                                                 Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                                Filter Operator [FIL_48] (rows=5 width=93)
+                                                Filter Operator [FIL_48] (rows=4 width=21)
                                                   predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                                                  TableScan [TS_0] (rows=20 width=88)
-                                                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                                  TableScan [TS_0] (rows=20 width=21)
+                                                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)  group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b % c asc, b desc) cbo_t1 left outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key  having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p left outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c  having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0  order by cbo_t3.c_int % c asc, cbo_t3.c_int desc
 PREHOOK: type: QUERY
@@ -474,22 +474,22 @@ Stage-0
     Stage-1
       Reducer 7
       File Output Operator [FS_39]
-        Select Operator [SEL_38] (rows=1 width=20)
+        Select Operator [SEL_38] (rows=1 width=87)
           Output:["_col0","_col1","_col2"]
         <-Reducer 6 [SIMPLE_EDGE]
           SHUFFLE [RS_37]
-            Group By Operator [GBY_34] (rows=1 width=20)
+            Group By Operator [GBY_34] (rows=1 width=87)
               Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
             <-Reducer 5 [SIMPLE_EDGE]
               SHUFFLE [RS_33]
                 PartitionCols:_col0, _col1
-                Group By Operator [GBY_32] (rows=1 width=20)
+                Group By Operator [GBY_32] (rows=2 width=87)
                   Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col6, _col2
-                  Select Operator [SEL_31] (rows=1 width=16)
+                  Select Operator [SEL_31] (rows=2 width=87)
                     Output:["_col6","_col2"]
-                    Filter Operator [FIL_30] (rows=1 width=16)
+                    Filter Operator [FIL_30] (rows=2 width=87)
                       predicate:(((_col1 > 0) or (_col6 >= 0)) and ((_col6 >= 1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))
-                      Merge Join Operator [MERGEJOIN_48] (rows=3 width=16)
+                      Merge Join Operator [MERGEJOIN_48] (rows=19 width=87)
                         Conds:RS_27._col0=RS_28._col0(Inner),Output:["_col1","_col2","_col6"]
                       <-Map 10 [SIMPLE_EDGE]
                         SHUFFLE [RS_28]
@@ -503,48 +503,48 @@ Stage-0
                       <-Reducer 4 [SIMPLE_EDGE]
                         SHUFFLE [RS_27]
                           PartitionCols:_col0
-                          Select Operator [SEL_23] (rows=1 width=101)
+                          Select Operator [SEL_23] (rows=1 width=23)
                             Output:["_col0","_col1","_col2"]
-                            Filter Operator [FIL_22] (rows=1 width=101)
+                            Filter Operator [FIL_22] (rows=1 width=23)
                               predicate:((_col1 + _col4) >= 0)
-                              Merge Join Operator [MERGEJOIN_47] (rows=1 width=101)
+                              Merge Join Operator [MERGEJOIN_47] (rows=1 width=23)
                                 Conds:RS_19._col0=RS_20._col0(Left Outer),Output:["_col0","_col1","_col2","_col4"]
                               <-Reducer 3 [SIMPLE_EDGE]
                                 SHUFFLE [RS_19]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_9] (rows=1 width=97)
+                                  Select Operator [SEL_9] (rows=1 width=21)
                                     Output:["_col0","_col1","_col2"]
                                   <-Reducer 2 [SIMPLE_EDGE]
                                     SHUFFLE [RS_8]
-                                      Select Operator [SEL_6] (rows=1 width=105)
+                                      Select Operator [SEL_6] (rows=1 width=21)
                                         Output:["_col0","_col1","_col2","_col3"]
-                                        Group By Operator [GBY_5] (rows=1 width=101)
+                                        Group By Operator [GBY_5] (rows=1 width=21)
                                           Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                         <-Map 1 [SIMPLE_EDGE]
                                           SHUFFLE [RS_4]
                                             PartitionCols:_col0, _col1, _col2
-                                            Group By Operator [GBY_3] (rows=1 width=101)
+                                            Group By Operator [GBY_3] (rows=1 width=21)
                                               Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                              Filter Operator [FIL_44] (rows=1 width=93)
+                                              Filter Operator [FIL_44] (rows=1 width=21)
                                                 predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
-                                                TableScan [TS_0] (rows=20 width=88)
-                                                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                                TableScan [TS_0] (rows=20 width=21)
+                                                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                               <-Reducer 9 [SIMPLE_EDGE]
                                 SHUFFLE [RS_20]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_17] (rows=1 width=89)
+                                  Select Operator [SEL_17] (rows=1 width=21)
                                     Output:["_col0","_col1"]
-                                    Group By Operator [GBY_16] (rows=1 width=93)
+                                    Group By Operator [GBY_16] (rows=1 width=21)
                                       Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
                                     <-Map 8 [SIMPLE_EDGE]
                                       SHUFFLE [RS_15]
                                         PartitionCols:_col0, _col1, _col2
-                                        Group By Operator [GBY_14] (rows=1 width=93)
+                                        Group By Operator [GBY_14] (rows=1 width=21)
                                           Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
-                                          Filter Operator [FIL_45] (rows=1 width=93)
+                                          Filter Operator [FIL_45] (rows=1 width=21)
                                             predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
-                                            TableScan [TS_11] (rows=20 width=88)
-                                              default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                            TableScan [TS_11] (rows=20 width=21)
+                                              default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)  group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by b+c, a desc) cbo_t1 right outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 2) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c
 PREHOOK: type: QUERY
@@ -565,20 +565,20 @@ Stage-0
     Stage-1
       Reducer 5
       File Output Operator [FS_31]
-        Select Operator [SEL_30] (rows=1 width=20)
+        Select Operator [SEL_30] (rows=4 width=84)
           Output:["_col0","_col1","_col2"]
-          Group By Operator [GBY_29] (rows=1 width=20)
+          Group By Operator [GBY_29] (rows=4 width=84)
             Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
           <-Reducer 4 [SIMPLE_EDGE]
             SHUFFLE [RS_28]
               PartitionCols:_col0, _col1
-              Group By Operator [GBY_27] (rows=1 width=20)
+              Group By Operator [GBY_27] (rows=8 width=84)
                 Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col2, _col6
-                Select Operator [SEL_26] (rows=1 width=20)
+                Select Operator [SEL_26] (rows=8 width=84)
                   Output:["_col2","_col6"]
-                  Filter Operator [FIL_25] (rows=1 width=20)
+                  Filter Operator [FIL_25] (rows=8 width=84)
                     predicate:(((_col1 + _col4) >= 2) and ((_col1 > 0) or (_col6 >= 0)))
-                    Merge Join Operator [MERGEJOIN_36] (rows=4 width=20)
+                    Merge Join Operator [MERGEJOIN_36] (rows=44 width=84)
                       Conds:RS_21._col0=RS_22._col0(Right Outer),RS_21._col0=RS_23._col0(Right Outer),Output:["_col1","_col2","_col4","_col6"]
                     <-Map 8 [SIMPLE_EDGE]
                       SHUFFLE [RS_23]
@@ -590,39 +590,39 @@ Stage-0
                     <-Reducer 3 [SIMPLE_EDGE]
                       SHUFFLE [RS_21]
                         PartitionCols:_col0
-                        Select Operator [SEL_9] (rows=1 width=97)
+                        Select Operator [SEL_9] (rows=1 width=21)
                           Output:["_col0","_col1","_col2"]
                         <-Reducer 2 [SIMPLE_EDGE]
                           SHUFFLE [RS_8]
-                            Select Operator [SEL_6] (rows=1 width=105)
+                            Select Operator [SEL_6] (rows=1 width=21)
                               Output:["_col0","_col1","_col2","_col3"]
-                              Group By Operator [GBY_5] (rows=1 width=101)
+                              Group By Operator [GBY_5] (rows=1 width=21)
                                 Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                               <-Map 1 [SIMPLE_EDGE]
                                 SHUFFLE [RS_4]
                                   PartitionCols:_col0, _col1, _col2
-                                  Group By Operator [GBY_3] (rows=1 width=101)
+                                  Group By Operator [GBY_3] (rows=1 width=21)
                                     Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                    Filter Operator [FIL_34] (rows=1 width=93)
+                                    Filter Operator [FIL_34] (rows=1 width=21)
                                       predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0))
-                                      TableScan [TS_0] (rows=20 width=88)
-                                        default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                      TableScan [TS_0] (rows=20 width=21)
+                                        default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                     <-Reducer 7 [SIMPLE_EDGE]
                       SHUFFLE [RS_22]
                         PartitionCols:_col0
-                        Select Operator [SEL_17] (rows=1 width=89)
+                        Select Operator [SEL_17] (rows=1 width=21)
                           Output:["_col0","_col1"]
-                          Group By Operator [GBY_16] (rows=1 width=93)
+                          Group By Operator [GBY_16] (rows=1 width=21)
                             Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
                           <-Map 6 [SIMPLE_EDGE]
                             SHUFFLE [RS_15]
                               PartitionCols:_col0, _col1, _col2
-                              Group By Operator [GBY_14] (rows=1 width=93)
+                              Group By Operator [GBY_14] (rows=1 width=21)
                                 Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
-                                Filter Operator [FIL_35] (rows=1 width=93)
+                                Filter Operator [FIL_35] (rows=1 width=21)
                                   predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0))
-                                  TableScan [TS_11] (rows=20 width=88)
-                                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                  TableScan [TS_11] (rows=20 width=21)
+                                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)  group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by c+a desc) cbo_t1 full outer join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0 order by p+q desc, r asc) cbo_t2 on cbo_t1.a=p full outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by cbo_t3.c_int
 PREHOOK: type: QUERY
@@ -645,22 +645,22 @@ Stage-0
     Stage-1
       Reducer 6
       File Output Operator [FS_37]
-        Select Operator [SEL_36] (rows=1 width=20)
+        Select Operator [SEL_36] (rows=1 width=84)
           Output:["_col0","_col1","_col2"]
         <-Reducer 5 [SIMPLE_EDGE]
           SHUFFLE [RS_35]
-            Group By Operator [GBY_33] (rows=1 width=20)
+            Group By Operator [GBY_33] (rows=1 width=84)
               Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
             <-Reducer 4 [SIMPLE_EDGE]
               SHUFFLE [RS_32]
                 PartitionCols:_col0, _col1
-                Group By Operator [GBY_31] (rows=1 width=20)
+                Group By Operator [GBY_31] (rows=1 width=84)
                   Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col6, _col2
-                  Select Operator [SEL_30] (rows=1 width=20)
+                  Select Operator [SEL_30] (rows=1 width=84)
                     Output:["_col6","_col2"]
-                    Filter Operator [FIL_29] (rows=1 width=20)
+                    Filter Operator [FIL_29] (rows=1 width=84)
                       predicate:(((_col1 + _col4) >= 0) and ((_col1 > 0) or (_col6 >= 0)) and ((_col6 >= 1) or (_col2 >= 1)) and ((UDFToLong(_col6) + _col2) >= 0))
-                      Merge Join Operator [MERGEJOIN_42] (rows=4 width=20)
+                      Merge Join Operator [MERGEJOIN_42] (rows=44 width=84)
                         Conds:RS_25._col0=RS_26._col0(Outer),RS_25._col0=RS_27._col0(Right Outer),Output:["_col1","_col2","_col4","_col6"]
                       <-Map 10 [SIMPLE_EDGE]
                         SHUFFLE [RS_27]
@@ -674,43 +674,43 @@ Stage-0
                       <-Reducer 3 [SIMPLE_EDGE]
                         SHUFFLE [RS_25]
                           PartitionCols:_col0
-                          Select Operator [SEL_9] (rows=1 width=97)
+                          Select Operator [SEL_9] (rows=1 width=21)
                             Output:["_col0","_col1","_col2"]
                           <-Reducer 2 [SIMPLE_EDGE]
                             SHUFFLE [RS_8]
-                              Select Operator [SEL_6] (rows=1 width=105)
+                              Select Operator [SEL_6] (rows=1 width=21)
                                 Output:["_col0","_col1","_col2","_col3"]
-                                Group By Operator [GBY_5] (rows=1 width=101)
+                                Group By Operator [GBY_5] (rows=1 width=21)
                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                 <-Map 1 [SIMPLE_EDGE]
                                   SHUFFLE [RS_4]
                                     PartitionCols:_col0, _col1, _col2
-                                    Group By Operator [GBY_3] (rows=1 width=101)
+                                    Group By Operator [GBY_3] (rows=1 width=21)
                                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                      Filter Operator [FIL_39] (rows=1 width=93)
+                                      Filter Operator [FIL_39] (rows=1 width=21)
                                         predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0))
-                                        TableScan [TS_0] (rows=20 width=88)
-                                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                        TableScan [TS_0] (rows=20 width=21)
+                                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                       <-Reducer 9 [SIMPLE_EDGE]
                         SHUFFLE [RS_26]
                           PartitionCols:_col0
-                          Select Operator [SEL_20] (rows=1 width=89)
+                          Select Operator [SEL_20] (rows=1 width=21)
                             Output:["_col0","_col1"]
                           <-Reducer 8 [SIMPLE_EDGE]
                             SHUFFLE [RS_19]
-                              Select Operator [SEL_17] (rows=1 width=105)
+                              Select Operator [SEL_17] (rows=1 width=21)
                                 Output:["_col0","_col1","_col2","_col3"]
-                                Group By Operator [GBY_16] (rows=1 width=101)
+                                Group By Operator [GBY_16] (rows=1 width=21)
                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                 <-Map 7 [SIMPLE_EDGE]
                                   SHUFFLE [RS_15]
                                     PartitionCols:_col0, _col1, _col2
-                                    Group By Operator [GBY_14] (rows=1 width=101)
+                                    Group By Operator [GBY_14] (rows=1 width=21)
                                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                      Filter Operator [FIL_40] (rows=1 width=93)
+                                      Filter Operator [FIL_40] (rows=1 width=21)
                                         predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0))
-                                        TableScan [TS_11] (rows=20 width=88)
-                                          default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                        TableScan [TS_11] (rows=20 width=21)
+                                          default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)  group by c_float, cbo_t1.c_int, key having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c
 PREHOOK: type: QUERY
@@ -731,20 +731,20 @@ Stage-0
     Stage-1
       Reducer 5
       File Output Operator [FS_33]
-        Select Operator [SEL_32] (rows=1 width=20)
+        Select Operator [SEL_32] (rows=6 width=87)
           Output:["_col0","_col1","_col2"]
-          Group By Operator [GBY_31] (rows=1 width=20)
+          Group By Operator [GBY_31] (rows=6 width=87)
             Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
           <-Reducer 4 [SIMPLE_EDGE]
             SHUFFLE [RS_30]
               PartitionCols:_col0, _col1
-              Group By Operator [GBY_29] (rows=1 width=20)
+              Group By Operator [GBY_29] (rows=12 width=87)
                 Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col2, _col6
-                Select Operator [SEL_28] (rows=3 width=16)
+                Select Operator [SEL_28] (rows=12 width=87)
                   Output:["_col2","_col6"]
-                  Filter Operator [FIL_27] (rows=3 width=16)
+                  Filter Operator [FIL_27] (rows=12 width=87)
                     predicate:((_col1 > 0) or (_col6 >= 0))
-                    Merge Join Operator [MERGEJOIN_43] (rows=3 width=16)
+                    Merge Join Operator [MERGEJOIN_43] (rows=19 width=87)
                       Conds:RS_24._col0=RS_25._col0(Inner),Output:["_col1","_col2","_col6"]
                     <-Map 8 [SIMPLE_EDGE]
                       SHUFFLE [RS_25]
@@ -758,44 +758,44 @@ Stage-0
                     <-Reducer 3 [SIMPLE_EDGE]
                       SHUFFLE [RS_24]
                         PartitionCols:_col0
-                        Select Operator [SEL_20] (rows=1 width=101)
+                        Select Operator [SEL_20] (rows=1 width=23)
                           Output:["_col0","_col1","_col2"]
-                          Filter Operator [FIL_19] (rows=1 width=101)
+                          Filter Operator [FIL_19] (rows=1 width=23)
                             predicate:((_col1 + _col4) >= 0)
-                            Merge Join Operator [MERGEJOIN_42] (rows=1 width=101)
+                            Merge Join Operator [MERGEJOIN_42] (rows=1 width=23)
                               Conds:RS_16._col0=RS_17._col0(Inner),Output:["_col0","_col1","_col2","_col4"]
                             <-Reducer 2 [SIMPLE_EDGE]
                               SHUFFLE [RS_16]
                                 PartitionCols:_col0
-                                Select Operator [SEL_6] (rows=1 width=97)
+                                Select Operator [SEL_6] (rows=1 width=21)
                                   Output:["_col0","_col1","_col2"]
-                                  Group By Operator [GBY_5] (rows=1 width=101)
+                                  Group By Operator [GBY_5] (rows=1 width=21)
                                     Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                   <-Map 1 [SIMPLE_EDGE]
                                     SHUFFLE [RS_4]
                                       PartitionCols:_col0, _col1, _col2
-                                      Group By Operator [GBY_3] (rows=1 width=101)
+                                      Group By Operator [GBY_3] (rows=1 width=21)
                                         Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                        Filter Operator [FIL_39] (rows=1 width=93)
+                                        Filter Operator [FIL_39] (rows=1 width=21)
                                           predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
-                                          TableScan [TS_0] (rows=20 width=88)
-                                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                          TableScan [TS_0] (rows=20 width=21)
+                                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                             <-Reducer 7 [SIMPLE_EDGE]
                               SHUFFLE [RS_17]
                                 PartitionCols:_col0
-                                Select Operator [SEL_14] (rows=1 width=89)
+                                Select Operator [SEL_14] (rows=1 width=21)
                                   Output:["_col0","_col1"]
-                                  Group By Operator [GBY_13] (rows=1 width=93)
+                                  Group By Operator [GBY_13] (rows=1 width=21)
                                     Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
                                   <-Map 6 [SIMPLE_EDGE]
                                     SHUFFLE [RS_12]
                                       PartitionCols:_col0, _col1, _col2
-                                      Group By Operator [GBY_11] (rows=1 width=93)
+                                      Group By Operator [GBY_11] (rows=1 width=21)
                                         Output:["_col0","_col1","_col2"],keys:key, c_int, c_float
-                                        Filter Operator [FIL_40] (rows=1 width=93)
+                                        Filter Operator [FIL_40] (rows=1 width=21)
                                           predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)) and (c_float > 0) and ((c_int >= 1) or (c_float >= 1)) and ((UDFToFloat(c_int) + c_float) >= 0.0) and key is not null)
-                                          TableScan [TS_8] (rows=20 width=88)
-                                            default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                          TableScan [TS_8] (rows=20 width=21)
+                                            default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select unionsrc.key FROM (select 'tst1' as key, count(1) as value from src) unionsrc
 PREHOOK: type: QUERY
@@ -998,17 +998,17 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_10]
-        Merge Join Operator [MERGEJOIN_15] (rows=18 width=85)
+        Merge Join Operator [MERGEJOIN_15] (rows=6 width=23)
           Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0"]
         <-Map 1 [SIMPLE_EDGE]
           SHUFFLE [RS_6]
             PartitionCols:_col0
-            Select Operator [SEL_2] (rows=6 width=85)
+            Select Operator [SEL_2] (rows=6 width=21)
               Output:["_col0"]
-              Filter Operator [FIL_13] (rows=6 width=85)
+              Filter Operator [FIL_13] (rows=6 width=21)
                 predicate:(UDFToDouble(key) >= 1.0)
-                TableScan [TS_0] (rows=20 width=80)
-                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
+                TableScan [TS_0] (rows=20 width=21)
+                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key"]
         <-Map 3 [SIMPLE_EDGE]
           SHUFFLE [RS_7]
             PartitionCols:_col0
@@ -1034,24 +1034,24 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=100 width=8)
+        Select Operator [SEL_7] (rows=22 width=21)
           Output:["_col0","_col1"]
-          Merge Join Operator [MERGEJOIN_11] (rows=100 width=8)
+          Merge Join Operator [MERGEJOIN_11] (rows=22 width=21)
             Conds:RS_4._col0=RS_5._col0(Left Outer),Output:["_col1","_col3"]
           <-Map 1 [SIMPLE_EDGE]
             SHUFFLE [RS_4]
               PartitionCols:_col0
-              Select Operator [SEL_1] (rows=20 width=84)
+              Select Operator [SEL_1] (rows=20 width=21)
                 Output:["_col0","_col1"]
-                TableScan [TS_0] (rows=20 width=84)
-                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                TableScan [TS_0] (rows=20 width=21)
+                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
           <-Map 3 [SIMPLE_EDGE]
             SHUFFLE [RS_5]
               PartitionCols:_col0
-              Select Operator [SEL_3] (rows=20 width=84)
+              Select Operator [SEL_3] (rows=20 width=21)
                 Output:["_col0","_col1"]
-                TableScan [TS_2] (rows=20 width=84)
-                  default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                TableScan [TS_2] (rows=20 width=21)
+                  default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
 
 PREHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join  cbo_t2 on cbo_t1.key=cbo_t2.key
 PREHOOK: type: QUERY
@@ -1068,24 +1068,24 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=100 width=8)
+        Select Operator [SEL_7] (rows=22 width=21)
           Output:["_col0","_col1"]
-          Merge Join Operator [MERGEJOIN_9] (rows=100 width=8)
+          Merge Join Operator [MERGEJOIN_9] (rows=22 width=21)
             Conds:RS_4._col0=RS_5._col0(Outer),Output:["_col1","_col3"]
           <-Map 1 [SIMPLE_EDGE]
             SHUFFLE [RS_4]
               PartitionCols:_col0
-              Select Operator [SEL_1] (rows=20 width=84)
+              Select Operator [SEL_1] (rows=20 width=21)
                 Output:["_col0","_col1"]
-                TableScan [TS_0] (rows=20 width=84)
-                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                TableScan [TS_0] (rows=20 width=21)
+                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
           <-Map 3 [SIMPLE_EDGE]
             SHUFFLE [RS_5]
               PartitionCols:_col0
-              Select Operator [SEL_3] (rows=20 width=84)
+              Select Operator [SEL_3] (rows=20 width=21)
                 Output:["_col0","_col1"]
-                TableScan [TS_2] (rows=20 width=84)
-                  default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                TableScan [TS_2] (rows=20 width=21)
+                  default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
 
 PREHOOK: query: explain select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
 PREHOOK: type: QUERY
@@ -1102,28 +1102,28 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_14]
-        Select Operator [SEL_13] (rows=291 width=101)
+        Select Operator [SEL_13] (rows=44 width=21)
           Output:["_col0","_col1","_col2","_col3","_col4"]
-          Merge Join Operator [MERGEJOIN_24] (rows=291 width=101)
-            Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col4","_col5","_col6"]
+          Merge Join Operator [MERGEJOIN_24] (rows=44 width=21)
+            Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"]
           <-Map 1 [SIMPLE_EDGE]
             SHUFFLE [RS_9]
               PartitionCols:_col0
-              Select Operator [SEL_2] (rows=18 width=87)
+              Select Operator [SEL_2] (rows=20 width=21)
                 Output:["_col0","_col1","_col2"]
-                Filter Operator [FIL_21] (rows=18 width=87)
+                Filter Operator [FIL_21] (rows=20 width=21)
                   predicate:key is not null
-                  TableScan [TS_0] (rows=20 width=88)
-                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                  TableScan [TS_0] (rows=20 width=21)
+                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
           <-Map 3 [SIMPLE_EDGE]
             SHUFFLE [RS_10]
               PartitionCols:_col0
-              Select Operator [SEL_5] (rows=18 width=84)
+              Select Operator [SEL_5] (rows=20 width=21)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_22] (rows=18 width=84)
+                Filter Operator [FIL_22] (rows=20 width=21)
                   predicate:key is not null
-                  TableScan [TS_3] (rows=20 width=84)
-                    default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                  TableScan [TS_3] (rows=20 width=21)
+                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
           <-Map 4 [SIMPLE_EDGE]
             SHUFFLE [RS_11]
               PartitionCols:_col0
@@ -1132,7 +1132,7 @@ Stage-0
                 Filter Operator [FIL_23] (rows=18 width=84)
                   predicate:key is not null
                   TableScan [TS_6] (rows=20 width=84)
-                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                    default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
 
 PREHOOK: query: explain select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c from cbo_t3)cbo_t3 on cbo_t1.key=a
 PREHOOK: type: QUERY
@@ -1149,37 +1149,35 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_14]
-        Select Operator [SEL_13] (rows=291 width=178)
-          Output:["_col0","_col1","_col2","_col3"]
-          Merge Join Operator [MERGEJOIN_24] (rows=291 width=178)
-            Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col0","_col1","_col3","_col4"]
-          <-Map 1 [SIMPLE_EDGE]
-            SHUFFLE [RS_9]
-              PartitionCols:_col0
-              Select Operator [SEL_2] (rows=18 width=84)
-                Output:["_col0","_col1"]
-                Filter Operator [FIL_21] (rows=18 width=84)
-                  predicate:key is not null
-                  TableScan [TS_0] (rows=20 width=84)
-                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
-          <-Map 3 [SIMPLE_EDGE]
-            SHUFFLE [RS_10]
-              PartitionCols:_col0
-              Select Operator [SEL_5] (rows=18 width=80)
-                Output:["_col0"]
-                Filter Operator [FIL_22] (rows=18 width=80)
-                  predicate:key is not null
-                  TableScan [TS_3] (rows=20 width=80)
-                    default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
-          <-Map 4 [SIMPLE_EDGE]
-            SHUFFLE [RS_11]
-              PartitionCols:_col0
-              Select Operator [SEL_8] (rows=18 width=84)
-                Output:["_col0","_col1"]
-                Filter Operator [FIL_23] (rows=18 width=84)
-                  predicate:key is not null
-                  TableScan [TS_6] (rows=20 width=84)
-                    default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+        Merge Join Operator [MERGEJOIN_24] (rows=44 width=21)
+          Conds:RS_9._col0=RS_10._col0(Inner),RS_9._col0=RS_11._col0(Inner),Output:["_col0","_col1","_col2","_col3"]
+        <-Map 1 [SIMPLE_EDGE]
+          SHUFFLE [RS_9]
+            PartitionCols:_col0
+            Select Operator [SEL_2] (rows=20 width=21)
+              Output:["_col0","_col1"]
+              Filter Operator [FIL_21] (rows=20 width=21)
+                predicate:key is not null
+                TableScan [TS_0] (rows=20 width=21)
+                  default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
+        <-Map 3 [SIMPLE_EDGE]
+          SHUFFLE [RS_10]
+            PartitionCols:_col0
+            Select Operator [SEL_5] (rows=20 width=21)
+              Output:["_col0","_col1"]
+              Filter Operator [FIL_22] (rows=20 width=21)
+                predicate:key is not null
+                TableScan [TS_3] (rows=20 width=21)
+                  default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
+        <-Map 4 [SIMPLE_EDGE]
+          SHUFFLE [RS_11]
+            PartitionCols:_col0
+            Select Operator [SEL_8] (rows=18 width=80)
+              Output:["_col0"]
+              Filter Operator [FIL_23] (rows=18 width=80)
+                predicate:key is not null
+                TableScan [TS_6] (rows=20 width=80)
+                  default@cbo_t3,cbo_t3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
 
 PREHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1  where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 full outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2  where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where  (q + 1 = 2) and (R.b > 0 or c_int >= 0)
 PREHOOK: type: QUERY
@@ -1197,11 +1195,11 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_19]
-        Select Operator [SEL_18] (rows=36 width=101)
+        Select Operator [SEL_18] (rows=12 width=87)
           Output:["_col0","_col1","_col2","_col3","_col4"]
-          Filter Operator [FIL_17] (rows=36 width=101)
+          Filter Operator [FIL_17] (rows=12 width=87)
             predicate:((_col1 > 0) or (_col6 >= 0))
-            Merge Join Operator [MERGEJOIN_28] (rows=36 width=101)
+            Merge Join Operator [MERGEJOIN_28] (rows=19 width=87)
               Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col6"]
             <-Map 5 [SIMPLE_EDGE]
               SHUFFLE [RS_15]
@@ -1215,28 +1213,28 @@ Stage-0
             <-Reducer 2 [SIMPLE_EDGE]
               SHUFFLE [RS_14]
                 PartitionCols:_col0
-                Filter Operator [FIL_9] (rows=10 width=182)
+                Filter Operator [FIL_9] (rows=1 width=23)
                   predicate:(((_col1 + _col4) = 2) and ((_col4 + 1) = 2))
-                  Merge Join Operator [MERGEJOIN_27] (rows=40 width=182)
+                  Merge Join Operator [MERGEJOIN_27] (rows=6 width=23)
                     Conds:RS_6._col0=RS_7._col0(Left Outer),Output:["_col0","_col1","_col2","_col3","_col4"]
                   <-Map 1 [SIMPLE_EDGE]
                     SHUFFLE [RS_6]
                       PartitionCols:_col0
-                      Select Operator [SEL_2] (rows=9 width=93)
+                      Select Operator [SEL_2] (rows=6 width=21)
                         Output:["_col0","_col1","_col2"]
-                        Filter Operator [FIL_24] (rows=9 width=93)
+                        Filter Operator [FIL_24] (rows=6 width=21)
                           predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                          TableScan [TS_0] (rows=20 width=88)
-                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                          TableScan [TS_0] (rows=20 width=21)
+                            default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                   <-Map 4 [SIMPLE_EDGE]
                     SHUFFLE [RS_7]
                       PartitionCols:_col0
-                      Select Operator [SEL_5] (rows=9 width=89)
+                      Select Operator [SEL_5] (rows=6 width=21)
                         Output:["_col0","_col1"]
-                        Filter Operator [FIL_25] (rows=9 width=93)
+                        Filter Operator [FIL_25] (rows=6 width=21)
                           predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                          TableScan [TS_3] (rows=20 width=88)
-                            default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                          TableScan [TS_3] (rows=20 width=21)
+                            default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c, cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1  where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 right outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2  where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where  (q + 1 = 2) and (R.b > 0 or c_int >= 0)
 PREHOOK: type: QUERY
@@ -1253,30 +1251,30 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_14]
-        Select Operator [SEL_13] (rows=50 width=101)
+        Select Operator [SEL_13] (rows=7 width=84)
           Output:["_col0","_col1","_col2","_col3","_col4"]
-          Filter Operator [FIL_12] (rows=50 width=101)
+          Filter Operator [FIL_12] (rows=7 width=84)
             predicate:(((_col1 + _col4) = 2) and ((_col1 > 0) or (_col6 >= 0)) and ((_col4 + 1) = 2))
-            Merge Join Operator [MERGEJOIN_19] (rows=200 width=101)
+            Merge Join Operator [MERGEJOIN_19] (rows=44 width=84)
               Conds:RS_8._col0=RS_9._col0(Right Outer),RS_8._col0=RS_10._col0(Right Outer),Output:["_col1","_col2","_col3","_col4","_col6"]
             <-Map 1 [SIMPLE_EDGE]
               SHUFFLE [RS_8]
                 PartitionCols:_col0
-                Select Operator [SEL_2] (rows=10 width=93)
+                Select Operator [SEL_2] (rows=6 width=21)
                   Output:["_col0","_col1","_col2"]
-                  Filter Operator [FIL_17] (rows=10 width=93)
+                  Filter Operator [FIL_17] (rows=6 width=21)
                     predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)))
-                    TableScan [TS_0] (rows=20 width=88)
-                      default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                    TableScan [TS_0] (rows=20 width=21)
+                      default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
             <-Map 3 [SIMPLE_EDGE]
               SHUFFLE [RS_9]
                 PartitionCols:_col0
-                Select Operator [SEL_5] (rows=10 width=89)
+                Select Operator [SEL_5] (rows=6 width=21)
                   Output:["_col0","_col1"]
-                  Filter Operator [FIL_18] (rows=10 width=93)
+                  Filter Operator [FIL_18] (rows=6 width=21)
                     predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)))
-                    TableScan [TS_3] (rows=20 width=88)
-                      default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                    TableScan [TS_3] (rows=20 width=21)
+                      default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
             <-Map 4 [SIMPLE_EDGE]
               SHUFFLE [RS_10]
                 PartitionCols:_col0
@@ -1301,25 +1299,25 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_10]
-        Limit [LIM_9] (rows=1 width=97)
+        Limit [LIM_9] (rows=1 width=21)
           Number of rows:1
-          Select Operator [SEL_8] (rows=10 width=97)
+          Select Operator [SEL_8] (rows=10 width=21)
             Output:["_col0","_col1","_col2"]
           <-Reducer 2 [SIMPLE_EDGE]
             SHUFFLE [RS_7]
-              Select Operator [SEL_5] (rows=10 width=97)
+              Select Operator [SEL_5] (rows=10 width=21)
                 Output:["_col0","_col1","_col2"]
-                Group By Operator [GBY_4] (rows=10 width=101)
+                Group By Operator [GBY_4] (rows=10 width=21)
                   Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                 <-Map 1 [SIMPLE_EDGE]
                   SHUFFLE [RS_3]
                     PartitionCols:_col0, _col1, _col2
-                    Group By Operator [GBY_2] (rows=10 width=101)
+                    Group By Operator [GBY_2] (rows=20 width=21)
                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                      Select Operator [SEL_1] (rows=20 width=88)
+                      Select Operator [SEL_1] (rows=20 width=21)
                         Output:["key","c_int","c_float"]
-                        TableScan [TS_0] (rows=20 width=88)
-                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                        TableScan [TS_0] (rows=20 width=21)
+                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select x, y, count(*) from (select key, (c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float, cbo_t1.c_int, key) R group by y, x order by x,y limit 1
 PREHOOK: type: QUERY
@@ -1338,32 +1336,32 @@ Stage-0
     Stage-1
       Reducer 4
       File Output Operator [FS_15]
-        Limit [LIM_14] (rows=1 width=20)
+        Limit [LIM_14] (rows=1 width=21)
           Number of rows:1
-          Select Operator [SEL_13] (rows=5 width=20)
+          Select Operator [SEL_13] (rows=5 width=21)
             Output:["_col0","_col1","_col2"]
           <-Reducer 3 [SIMPLE_EDGE]
             SHUFFLE [RS_12]
-              Group By Operator [GBY_10] (rows=5 width=20)
+              Group By Operator [GBY_10] (rows=5 width=21)
                 Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
               <-Reducer 2 [SIMPLE_EDGE]
                 SHUFFLE [RS_9]
                   PartitionCols:_col0, _col1
-                  Group By Operator [GBY_8] (rows=5 width=20)
+                  Group By Operator [GBY_8] (rows=10 width=21)
                     Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
-                    Select Operator [SEL_5] (rows=10 width=101)
+                    Select Operator [SEL_5] (rows=10 width=21)
                       Output:["_col0","_col1"]
-                      Group By Operator [GBY_4] (rows=10 width=101)
+                      Group By Operator [GBY_4] (rows=10 width=21)
                         Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                       <-Map 1 [SIMPLE_EDGE]
                         SHUFFLE [RS_3]
                           PartitionCols:_col0, _col1, _col2
-                          Group By Operator [GBY_2] (rows=10 width=101)
+                          Group By Operator [GBY_2] (rows=20 width=21)
                             Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                            Select Operator [SEL_1] (rows=20 width=88)
+                            Select Operator [SEL_1] (rows=20 width=21)
                               Output:["key","c_int","c_float"]
-                              TableScan [TS_0] (rows=20 width=88)
-                                default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                              TableScan [TS_0] (rows=20 width=21)
+                                default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select key from(select key from (select key from cbo_t1 limit 5)cbo_t2  limit 5)cbo_t3  limit 5
 PREHOOK: type: QUERY
@@ -1381,28 +1379,28 @@ Stage-0
     Stage-1
       Reducer 3
       File Output Operator [FS_13]
-        Limit [LIM_12] (rows=5 width=85)
+        Limit [LIM_12] (rows=5 width=21)
           Number of rows:5
-          Limit [LIM_10] (rows=5 width=85)
+          Limit [LIM_10] (rows=5 width=21)
             Number of rows:5
-            Select Operator [SEL_9] (rows=5 width=85)
+            Select Operator [SEL_9] (rows=5 width=21)
               Output:["_col0"]
             <-Reducer 2 [SIMPLE_EDGE]
               SHUFFLE [RS_8]
-                Limit [LIM_7] (rows=5 width=85)
+                Limit [LIM_7] (rows=5 width=21)
                   Number of rows:5
-                  Limit [LIM_5] (rows=5 width=85)
+                  Limit [LIM_5] (rows=5 width=21)
                     Number of rows:5
-                    Select Operator [SEL_4] (rows=5 width=85)
+                    Select Operator [SEL_4] (rows=5 width=21)
                       Output:["_col0"]
                     <-Map 1 [SIMPLE_EDGE]
                       SHUFFLE [RS_3]
-                        Limit [LIM_2] (rows=5 width=85)
+                        Limit [LIM_2] (rows=5 width=21)
                           Number of rows:5
-                          Select Operator [SEL_1] (rows=20 width=80)
+                          Select Operator [SEL_1] (rows=20 width=21)
                             Output:["_col0"]
-                            TableScan [TS_0] (rows=20 width=80)
-                              default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
+                            TableScan [TS_0] (rows=20 width=21)
+                              default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key"]
 
 PREHOOK: query: explain select key, c_int from(select key, c_int from (select key, c_int from cbo_t1 order by c_int limit 5)cbo_t1  order by c_int limit 5)cbo_t2  order by c_int limit 5
 PREHOOK: type: QUERY
@@ -1421,28 +1419,28 @@ Stage-0
     Stage-1
       Reducer 4
       File Output Operator [FS_13]
-        Limit [LIM_12] (rows=5 width=89)
+        Limit [LIM_12] (rows=5 width=21)
           Number of rows:5
-          Select Operator [SEL_11] (rows=5 width=89)
+          Select Operator [SEL_11] (rows=5 width=21)
             Output:["_col0","_col1"]
           <-Reducer 3 [SIMPLE_EDGE]
             SHUFFLE [RS_10]
-              Limit [LIM_8] (rows=5 width=89)
+              Limit [LIM_8] (rows=5 width=21)
                 Number of rows:5
-                Select Operator [SEL_7] (rows=5 width=89)
+                Select Operator [SEL_7] (rows=5 width=21)
                   Output:["_col0","_col1"]
                 <-Reducer 2 [SIMPLE_EDGE]
                   SHUFFLE [RS_6]
-                    Limit [LIM_4] (rows=5 width=89)
+                    Limit [LIM_4] (rows=5 width=21)
                       Number of rows:5
-                      Select Operator [SEL_3] (rows=20 width=84)
+                      Select Operator [SEL_3] (rows=20 width=21)
                         Output:["_col0","_col1"]
                       <-Map 1 [SIMPLE_EDGE]
                         SHUFFLE [RS_2]
-                          Select Operator [SEL_1] (rows=20 width=84)
+                          Select Operator [SEL_1] (rows=20 width=21)
                             Output:["_col0","_col1"]
-                            TableScan [TS_0] (rows=20 width=84)
-                              default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int"]
+                            TableScan [TS_0] (rows=20 width=21)
+                              default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int"]
 
 PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key order by a limit 5) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)  group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc limit 5) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c limit 5
 PREHOOK: type: QUERY
@@ -1466,26 +1464,26 @@ Stage-0
     Stage-1
       Reducer 7
       File Output Operator [FS_49]
-        Limit [LIM_48] (rows=1 width=20)
+        Limit [LIM_48] (rows=5 width=87)
           Number of rows:5
-          Select Operator [SEL_47] (rows=1 width=20)
+          Select Operator [SEL_47] (rows=6 width=87)
             Output:["_col0","_col1","_col2"]
           <-Reducer 6 [SIMPLE_EDGE]
             SHUFFLE [RS_46]
-              Select Operator [SEL_44] (rows=1 width=20)
+              Select Operator [SEL_44] (rows=6 width=87)
                 Output:["_col0","_col1","_col2"]
-                Group By Operator [GBY_43] (rows=1 width=20)
+                Group By Operator [GBY_43] (rows=6 width=87)
                   Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
                 <-Reducer 5 [SIMPLE_EDGE]
                   SHUFFLE [RS_42]
                     PartitionCols:_col0, _col1
-                    Group By Operator [GBY_41] (rows=1 width=20)
+                    Group By Operator [GBY_41] (rows=12 width=87)
                       Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col2, _col6
-                      Select Operator [SEL_40] (rows=3 width=16)
+                      Select Operator [SEL_40] (rows=12 width=87)
                         Output:["_col2","_col6"]
-                        Filter Operator [FIL_39] (rows=3 width=16)
+                        Filter Operator [FIL_39] (rows=12 width=87)
                           predicate:((_col1 > 0) or (_col6 >= 0))
-                          Merge Join Operator [MERGEJOIN_61] (rows=3 width=16)
+                          Merge Join Operator [MERGEJOIN_61] (rows=19 width=87)
                             Conds:RS_36._col0=RS_37._col0(Inner),Output:["_col1","_col2","_col6"]
                           <-Map 11 [SIMPLE_EDGE]
                             SHUFFLE [RS_37]
@@ -1499,60 +1497,60 @@ Stage-0
                           <-Reducer 4 [SIMPLE_EDGE]
                             SHUFFLE [RS_36]
                               PartitionCols:_col0
-                              Select Operator [SEL_32] (rows=1 width=101)
+                              Select Operator [SEL_32] (rows=1 width=23)
                                 Output:["_col0","_col1","_col2"]
-                                Filter Operator [FIL_31] (rows=1 width=101)
+                                Filter Operator [FIL_31] (rows=1 width=23)
                                   predicate:((_col1 + _col4) >= 0)
-                                  Merge Join Operator [MERGEJOIN_60] (rows=2 width=101)
+                                  Merge Join Operator [MERGEJOIN_60] (rows=2 width=23)
                                     Conds:RS_28._col0=RS_29._col0(Inner),Output:["_col0","_col1","_col2","_col4"]
                                   <-Reducer 10 [SIMPLE_EDGE]
                                     SHUFFLE [RS_29]
                                       PartitionCols:_col0
-                                      Filter Operator [FIL_26] (rows=2 width=105)
+                                      Filter Operator [FIL_26] (rows=2 width=21)
                                         predicate:_col0 is not null
-                                        Limit [LIM_24] (rows=3 width=105)
+                                        Limit [LIM_24] (rows=2 width=21)
                                           Number of rows:5
-                                          Select Operator [SEL_23] (rows=3 width=105)
+                                          Select Operator [SEL_23] (rows=2 width=21)
                                             Output:["_col0","_col1"]
                                           <-Reducer 9 [SIMPLE_EDGE]
                                             SHUFFLE [RS_22]
-                                              Select Operator [SEL_20] (rows=3 width=105)
+                                              Select Operator [SEL_20] (rows=2 width=21)
                                                 Output:["_col0","_col1","_col2","_col3"]
-                                                Group By Operator [GBY_19] (rows=3 width=101)
+                                                Group By Operator [GBY_19] (rows=2 width=21)
                                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                                 <-Map 8 [SIMPLE_EDGE]
                                                   SHUFFLE [RS_18]
                                                     PartitionCols:_col0, _col1, _col2
-                                                    Group By Operator [GBY_17] (rows=3 width=101)
+                                                    Group By Operator [GBY_17] (rows=4 width=21)
                                                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                                      Filter Operator [FIL_58] (rows=6 width=93)
+                                                      Filter Operator [FIL_58] (rows=4 width=21)
                                                         predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)))
-                                                        TableScan [TS_14] (rows=20 width=88)
-                                                          default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                                        TableScan [TS_14] (rows=20 width=21)
+                                                          default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
                                   <-Reducer 3 [SIMPLE_EDGE]
                                     SHUFFLE [RS_28]
                                       PartitionCols:_col0
-                                      Filter Operator [FIL_12] (rows=2 width=97)
+                                      Filter Operator [FIL_12] (rows=2 width=21)
                                         predicate:_col0 is not null
-                                        Limit [LIM_10] (rows=3 width=97)
+                                        Limit [LIM_10] (rows=2 width=21)
                                           Number of rows:5
-                                          Select Operator [SEL_9] (rows=3 width=97)
+                                          Select Operator [SEL_9] (rows=2 width=21)
                                             Output:["_col0","_col1","_col2"]
                                           <-Reducer 2 [SIMPLE_EDGE]
                                             SHUFFLE [RS_8]
-                                              Select Operator [SEL_6] (rows=3 width=97)
+                                              Select Operator [SEL_6] (rows=2 width=21)
                                                 Output:["_col0","_col1","_col2"]
-                                                Group By Operator [GBY_5] (rows=3 width=101)
+                                                Group By Operator [GBY_5] (rows=2 width=21)
                                                   Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2
                                                 <-Map 1 [SIMPLE_EDGE]
                                                   SHUFFLE [RS_4]
                                                     PartitionCols:_col0, _col1, _col2
-                                                    Group By Operator [GBY_3] (rows=3 width=101)
+                                                    Group By Operator [GBY_3] (rows=4 width=21)
                                                       Output:["_col0","_col1","_col2","_col3"],aggregations:["sum(c_int)"],keys:key, c_int, c_float
-                                                      Filter Operator [FIL_56] (rows=6 width=93)
+                                                      Filter Operator [FIL_56] (rows=4 width=21)
                                                         predicate:(((c_int + 1) >= 0) and ((c_int > 0) or (c_float >= 0)))
-                                                        TableScan [TS_0] (rows=20 width=88)
-                                                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                                                        TableScan [TS_0] (rows=20 width=21)
+                                                          default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
 
 PREHOOK: query: explain select cbo_t1.c_int           from cbo_t1 left semi join   cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)
 PREHOOK: type: QUERY
@@ -1569,30 +1567,30 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_12]
-        Select Operator [SEL_11] (rows=9 width=4)
+        Select Operator [SEL_11] (rows=22 width=21)
           Output:["_col0"]
-          Merge Join Operator [MERGEJOIN_17] (rows=9 width=4)
+          Merge Join Operator [MERGEJOIN_17] (rows=22 width=21)
             Conds:RS_8._col0=RS_9._col0(Left Semi),Output:["_col1"]
           <-Map 1 [SIMPLE_EDGE]
             SHUFFLE [RS_8]
               PartitionCols:_col0
-              Select Operator [SEL_2] (rows=9 width=93)
+              Select Operator [SEL_2] (rows=6 width=21)
                 Output:["_col0","_col1"]
-                Filter Operator [FIL_15] (rows=9 width=93)
+                Filter Operator [FIL_15] (rows=6 width=21)
                   predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                  TableScan [TS_0] (rows=20 width=88)
-                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                  TableScan [TS_0] (rows=20 width=21)
+                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
           <-Map 3 [SIMPLE_EDGE]
             SHUFFLE [RS_9]
               PartitionCols:_col0
-              Group By Operator [GBY_7] (rows=5 width=85)
+              Group By Operator [GBY_7] (rows=20 width=21)
                 Output:["_col0"],keys:_col0
-                Select Operator [SEL_5] (rows=18 width=80)
+                Select Operator [SEL_5] (rows=20 width=21)
                   Output:["_col0"]
-                  Filter Operator [FIL_16] (rows=18 width=80)
+                  Filter Operator [FIL_16] (rows=20 width=21)
                     predicate:key is not null
-                    TableScan [TS_3] (rows=20 width=80)
-                      default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key"]
+                    TableScan [TS_3] (rows=20 width=21)
+                      default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key"]
 
 PREHOOK: query: explain select * from (select c, b, a from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1  where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 left semi join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2  where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 == 2) and (b > 0 or c >= 0)) R where  (b + 1 = 2) and (R.b > 0 or c >= 0)
 PREHOOK: type: QUERY
@@ -1609,30 +1607,30 @@ Stage-0
     Stage-1
       Reducer 2
       File Output Operator [FS_18]
-        Select Operator [SEL_17] (rows=16 width=93)
+        Select Operator [SEL_17] (rows=13 width=21)
           Output:["_col0","_col1","_col2"]
-          Merge Join Operator [MERGEJOIN_28] (rows=16 width=93)
+          Merge Join Operator [MERGEJOIN_28] (rows=13 width=21)
             Conds:RS_13._col0=RS_14._col0(Left Semi),RS_13._col0=RS_15._col0(Left Semi),Output:["_col0","_col1","_col2"]
           <-Map 1 [SIMPLE_EDGE]
             SHUFFLE [RS_13]
               PartitionCols:_col0
-              Select Operator [SEL_2] (rows=9 width=93)
+              Select Operator [SEL_2] (rows=6 width=21)
                 Output:["_col0","_col1","_col2"]
-                Filter Operator [FIL_25] (rows=9 width=93)
+                Filter Operator [FIL_25] (rows=6 width=21)
                   predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                  TableScan [TS_0] (rows=20 width=88)
-                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                  TableScan [TS_0] (rows=20 width=21)
+                    default@cbo_t1,cbo_t1,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
           <-Map 3 [SIMPLE_EDGE]
             SHUFFLE [RS_14]
               PartitionCols:_col0
-              Group By Operator [GBY_10] (rows=3 width=85)
+              Group By Operator [GBY_10] (rows=6 width=21)
                 Output:["_col0"],keys:_col0
-                Select Operator [SEL_5] (rows=9 width=85)
+                Select Operator [SEL_5] (rows=6 width=21)
                   Output:["_col0"]
-                  Filter Operator [FIL_26] (rows=9 width=93)
+                  Filter Operator [FIL_26] (rows=6 width=21)
                     predicate:(((c_int + 1) = 2) and ((c_int > 0) or (c_float >= 0)) and key is not null)
-                    TableScan [TS_3] (rows=20 width=88)
-                      default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:COMPLETE,Output:["key","c_int","c_float"]
+                    TableScan [TS_3] (rows=20 width=21)
+                      default@cbo_t2,cbo_t2,Tbl:COMPLETE,Col:NONE,Output:["key","c_int","c_float"]
           <-Map 4 [SIMPLE_EDGE]
             SHUFFLE [RS_15]
               PartitionCols:_col0
@@ -1666,20 +1664,20 @@ Stage-0
     Stage-1
       Reducer 6
       File Output Operator [FS_41]
-        Select Operator [SEL_40] (rows=1 width=101)
+        Select Operator [SEL_40] (rows=3 width=93)
           Output:["_col0","_col1","_col2"]
         <-Reducer 5 [SIMPLE_EDGE]
           SHUFFLE [RS_39]
-            Select Operator [SEL_38] (rows=1 width=101)
+            Select Operator [SEL_38] (rows=3 width=93)
               Output:["_col0","_col1","_col2"]
-              Group By Operator [GBY_37] (rows=1 width=101)
+              Group By Operator [GBY_37] (rows=3 width=93)
                 Output:["_col0","_col1","_col2"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1
               <-Reducer 4 [SIMPLE_EDGE]
                 SHUFFLE [RS_36]
                   PartitionCols:_col0, _col1
-                  Group By Operator [GBY_35] (rows=1 width=101)
+                  Group By Operator [GBY_35] (rows=6 width=93)
                     Output:["_col0","_col1","_col2"],aggregations:["count()"],keys:_col1, _col0
-                    Merge Join Operator [MERGEJOIN_51] (rows=1 width=93)
+                    Merge Join Operator [MERGEJOIN_51] (rows=6 width=93)
                       Conds:RS_30._col0=RS_31._col0(Left Semi),RS_30._col0=RS_32._col0(Left Semi),Output:["_col0","_col1"]
                     <-Map 10 [SIMPLE_EDGE]
                       SHUFFLE [RS_32]
@@ -1695,49 +1693,49 @@ Stage-0
                     <-Reducer 3 [SIMPLE_EDGE]
                       SHUFFLE [RS_30]
                         PartitionCols:_col0
-                        Select Operator [SEL_10] (rows=1 width=93)
+                        Select Operator [SEL_10] (rows=1 width=21)
                      

<TRUNCATED>

Mime
View raw message