hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [02/15] hive git commit: HIVE-13542 : Missing stats for tables in TPCDS performance regression suite (Hari Subramaniyan via Ashutosh Chauhan)
Date Fri, 06 May 2016 20:55:54 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query89.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query89.q.out b/ql/src/test/results/clientpositive/perf/query89.q.out
index de91d9b..8e6cc49 100644
--- a/ql/src/test/results/clientpositive/perf/query89.q.out
+++ b/ql/src/test/results/clientpositive/perf/query89.q.out
@@ -68,38 +68,38 @@ Stage-0
     Stage-1
       Reducer 7
       File Output Operator [FS_36]
-        Limit [LIM_35] (rows=100 width=1436)
+        Limit [LIM_35] (rows=100 width=88)
           Number of rows:100
-          Select Operator [SEL_34] (rows=51243 width=1436)
+          Select Operator [SEL_34] (rows=127775039 width=88)
             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
           <-Reducer 6 [SIMPLE_EDGE]
             SHUFFLE [RS_33]
-              Select Operator [SEL_30] (rows=51243 width=1436)
+              Select Operator [SEL_30] (rows=127775039 width=88)
                 Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
-                Filter Operator [FIL_46] (rows=51243 width=1436)
+                Filter Operator [FIL_46] (rows=127775039 width=88)
                   predicate:(UDFToDouble(CASE WHEN ((avg_window_0 <> 0)) THEN ((abs((_col6 - avg_window_0)) / avg_window_0)) ELSE (null) END) > 0.1)
-                  Select Operator [SEL_29] (rows=153730 width=1436)
+                  Select Operator [SEL_29] (rows=383325119 width=88)
                     Output:["avg_window_0","_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                    PTF Operator [PTF_28] (rows=153730 width=1436)
+                    PTF Operator [PTF_28] (rows=383325119 width=88)
                       Function definitions:[{},{"name:":"windowingtablefunction","order by:":"_col0 ASC NULLS FIRST, _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST","partition by:":"_col0, _col2, _col3, _col4"}]
-                      Select Operator [SEL_27] (rows=153730 width=1436)
+                      Select Operator [SEL_27] (rows=383325119 width=88)
                         Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
                       <-Reducer 5 [SIMPLE_EDGE]
                         SHUFFLE [RS_26]
                           PartitionCols:_col0, _col2, _col3, _col4
-                          Select Operator [SEL_25] (rows=153730 width=1436)
+                          Select Operator [SEL_25] (rows=383325119 width=88)
                             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                            Group By Operator [GBY_24] (rows=153730 width=1436)
+                            Group By Operator [GBY_24] (rows=383325119 width=88)
                               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5
                             <-Reducer 4 [SIMPLE_EDGE]
                               SHUFFLE [RS_23]
                                 PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5
-                                Group By Operator [GBY_22] (rows=307461 width=1436)
-                                  Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col7)"],keys:_col1, _col2, _col3, _col10, _col12, _col13
-                                  Select Operator [SEL_21] (rows=307461 width=1436)
-                                    Output:["_col1","_col2","_col3","_col10","_col12","_col13","_col7"]
-                                    Merge Join Operator [MERGEJOIN_53] (rows=307461 width=1436)
-                                      Conds:RS_18._col6=RS_19._col0(Inner),Output:["_col1","_col2","_col3","_col7","_col10","_col12","_col13"]
+                                Group By Operator [GBY_22] (rows=766650239 width=88)
+                                  Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"],aggregations:["sum(_col3)"],keys:_col5, _col6, _col7, _col10, _col12, _col13
+                                  Select Operator [SEL_21] (rows=766650239 width=88)
+                                    Output:["_col5","_col6","_col7","_col10","_col12","_col13","_col3"]
+                                    Merge Join Operator [MERGEJOIN_53] (rows=766650239 width=88)
+                                      Conds:RS_18._col2=RS_19._col0(Inner),Output:["_col3","_col5","_col6","_col7","_col10","_col12","_col13"]
                                     <-Map 10 [SIMPLE_EDGE]
                                       SHUFFLE [RS_19]
                                         PartitionCols:_col0
@@ -111,9 +111,9 @@ Stage-0
                                               default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_store_name","s_company_name"]
                                     <-Reducer 3 [SIMPLE_EDGE]
                                       SHUFFLE [RS_18]
-                                        PartitionCols:_col6
-                                        Merge Join Operator [MERGEJOIN_52] (rows=279510 width=1436)
-                                          Conds:RS_15._col4=RS_16._col0(Inner),Output:["_col1","_col2","_col3","_col6","_col7","_col10"]
+                                        PartitionCols:_col2
+                                        Merge Join Operator [MERGEJOIN_52] (rows=696954748 width=88)
+                                          Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col2","_col3","_col5","_col6","_col7","_col10"]
                                         <-Map 9 [SIMPLE_EDGE]
                                           SHUFFLE [RS_16]
                                             PartitionCols:_col0
@@ -125,25 +125,25 @@ Stage-0
                                                   default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                                         <-Reducer 2 [SIMPLE_EDGE]
                                           SHUFFLE [RS_15]
-                                            PartitionCols:_col4
-                                            Merge Join Operator [MERGEJOIN_51] (rows=254100 width=1436)
-                                              Conds:RS_12._col0=RS_13._col1(Inner),Output:["_col1","_col2","_col3","_col4","_col6","_col7"]
+                                            PartitionCols:_col0
+                                            Merge Join Operator [MERGEJOIN_51] (rows=633595212 width=88)
+                                              Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col0","_col2","_col3","_col5","_col6","_col7"]
                                             <-Map 1 [SIMPLE_EDGE]
                                               SHUFFLE [RS_12]
-                                                PartitionCols:_col0
-                                                Select Operator [SEL_2] (rows=231000 width=1436)
+                                                PartitionCols:_col1
+                                                Select Operator [SEL_2] (rows=575995635 width=88)
                                                   Output:["_col0","_col1","_col2","_col3"]
-                                                  Filter Operator [FIL_47] (rows=231000 width=1436)
-                                                    predicate:(((i_category) IN ('Home', 'Books', 'Electronics') or (i_category) IN ('Shoes', 'Jewelry', 'Men')) and ((i_class) IN ('wallpaper', 'parenting', 'musical') or (i_class) IN ('womens', 'birdal', 'pants')) and (((i_category) IN ('Home', 'Books', 'Electronics') and (i_class) IN ('wallpaper', 'parenting', 'musical')) or ((i_category) IN ('Shoes', 'Jewelry', 'Men') and (i_class) IN ('womens', 'birdal', 'pants'))) and i_item_sk is not null)
-                                                    TableScan [TS_0] (rows=462000 width=1436)
-                                                      default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand","i_class","i_category"]
+                                                  Filter Operator [FIL_47] (rows=575995635 width=88)
+                                                    predicate:(ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
+                                                    TableScan [TS_0] (rows=575995635 width=88)
+                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_store_sk","ss_sales_price"]
                                             <-Map 8 [SIMPLE_EDGE]
                                               SHUFFLE [RS_13]
-                                                PartitionCols:_col1
-                                                Select Operator [SEL_5] (rows=1 width=0)
+                                                PartitionCols:_col0
+                                                Select Operator [SEL_5] (rows=231000 width=1436)
                                                   Output:["_col0","_col1","_col2","_col3"]
-                                                  Filter Operator [FIL_48] (rows=1 width=0)
-                                                    predicate:(ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
-                                                    TableScan [TS_3] (rows=1 width=0)
-                                                      default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_store_sk","ss_sales_price"]
+                                                  Filter Operator [FIL_48] (rows=231000 width=1436)
+                                                    predicate:(((i_category) IN ('Home', 'Books', 'Electronics') or (i_category) IN ('Shoes', 'Jewelry', 'Men')) and ((i_class) IN ('wallpaper', 'parenting', 'musical') or (i_class) IN ('womens', 'birdal', 'pants')) and (((i_category) IN ('Home', 'Books', 'Electronics') and (i_class) IN ('wallpaper', 'parenting', 'musical')) or ((i_category) IN ('Shoes', 'Jewelry', 'Men') and (i_class) IN ('womens', 'birdal', 'pants'))) and i_item_sk is not null)
+                                                    TableScan [TS_3] (rows=462000 width=1436)
+                                                      default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand","i_class","i_category"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query90.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query90.q.out b/ql/src/test/results/clientpositive/perf/query90.q.out
index 62c8df6..eea2a06 100644
--- a/ql/src/test/results/clientpositive/perf/query90.q.out
+++ b/ql/src/test/results/clientpositive/perf/query90.q.out
@@ -41,22 +41,22 @@ Stage-0
                       SHUFFLE [RS_49]
                         Group By Operator [GBY_48] (rows=1 width=8)
                           Output:["_col0"],aggregations:["count()"]
-                          Merge Join Operator [MERGEJOIN_92] (rows=52272 width=471)
-                            Conds:RS_44._col2=RS_45._col0(Inner)
+                          Merge Join Operator [MERGEJOIN_92] (rows=191667562 width=135)
+                            Conds:RS_44._col1=RS_45._col0(Inner)
                           <-Map 18 [SIMPLE_EDGE]
                             SHUFFLE [RS_45]
                               PartitionCols:_col0
-                              Select Operator [SEL_37] (rows=2301 width=585)
+                              Select Operator [SEL_37] (rows=3600 width=107)
                                 Output:["_col0"]
-                                Filter Operator [FIL_86] (rows=2301 width=585)
-                                  predicate:(wp_char_count BETWEEN 5000 AND 5200 and wp_web_page_sk is not null)
-                                  TableScan [TS_35] (rows=4602 width=585)
-                                    default@web_page,web_page,Tbl:COMPLETE,Col:NONE,Output:["wp_web_page_sk","wp_char_count"]
+                                Filter Operator [FIL_86] (rows=3600 width=107)
+                                  predicate:((hd_dep_count = 8) and hd_demo_sk is not null)
+                                  TableScan [TS_35] (rows=7200 width=107)
+                                    default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
                           <-Reducer 13 [SIMPLE_EDGE]
                             SHUFFLE [RS_44]
-                              PartitionCols:_col2
-                              Merge Join Operator [MERGEJOIN_91] (rows=47520 width=471)
-                                Conds:RS_41._col0=RS_42._col0(Inner),Output:["_col2"]
+                              PartitionCols:_col1
+                              Merge Join Operator [MERGEJOIN_91] (rows=174243235 width=135)
+                                Conds:RS_41._col0=RS_42._col0(Inner),Output:["_col1"]
                               <-Map 17 [SIMPLE_EDGE]
                                 SHUFFLE [RS_42]
                                   PartitionCols:_col0
@@ -69,26 +69,26 @@ Stage-0
                               <-Reducer 12 [SIMPLE_EDGE]
                                 SHUFFLE [RS_41]
                                   PartitionCols:_col0
-                                  Merge Join Operator [MERGEJOIN_90] (rows=3960 width=107)
-                                    Conds:RS_38._col1=RS_39._col0(Inner),Output:["_col0","_col2"]
+                                  Merge Join Operator [MERGEJOIN_90] (rows=158402938 width=135)
+                                    Conds:RS_38._col2=RS_39._col0(Inner),Output:["_col0","_col1"]
                                   <-Map 11 [SIMPLE_EDGE]
                                     SHUFFLE [RS_38]
-                                      PartitionCols:_col1
-                                      Select Operator [SEL_28] (rows=1 width=0)
+                                      PartitionCols:_col2
+                                      Select Operator [SEL_28] (rows=144002668 width=135)
                                         Output:["_col0","_col1","_col2"]
-                                        Filter Operator [FIL_83] (rows=1 width=0)
+                                        Filter Operator [FIL_83] (rows=144002668 width=135)
                                           predicate:(ws_ship_hdemo_sk is not null and ws_sold_time_sk is not null and ws_web_page_sk is not null)
-                                          TableScan [TS_26] (rows=1 width=0)
-                                            default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"]
+                                          TableScan [TS_26] (rows=144002668 width=135)
+                                            default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"]
                                   <-Map 16 [SIMPLE_EDGE]
                                     SHUFFLE [RS_39]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_31] (rows=3600 width=107)
+                                      Select Operator [SEL_31] (rows=2301 width=585)
                                         Output:["_col0"]
-                                        Filter Operator [FIL_84] (rows=3600 width=107)
-                                          predicate:((hd_dep_count = 8) and hd_demo_sk is not null)
-                                          TableScan [TS_29] (rows=7200 width=107)
-                                            default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
+                                        Filter Operator [FIL_84] (rows=2301 width=585)
+                                          predicate:(wp_char_count BETWEEN 5000 AND 5200 and wp_web_page_sk is not null)
+                                          TableScan [TS_29] (rows=4602 width=585)
+                                            default@web_page,web_page,Tbl:COMPLETE,Col:NONE,Output:["wp_web_page_sk","wp_char_count"]
                 <-Reducer 5 [SIMPLE_EDGE]
                   SHUFFLE [RS_53]
                     Group By Operator [GBY_24] (rows=1 width=8)
@@ -97,22 +97,22 @@ Stage-0
                       SHUFFLE [RS_23]
                         Group By Operator [GBY_22] (rows=1 width=8)
                           Output:["_col0"],aggregations:["count()"]
-                          Merge Join Operator [MERGEJOIN_89] (rows=52272 width=471)
-                            Conds:RS_18._col2=RS_19._col0(Inner)
+                          Merge Join Operator [MERGEJOIN_89] (rows=191667562 width=135)
+                            Conds:RS_18._col1=RS_19._col0(Inner)
                           <-Map 10 [SIMPLE_EDGE]
                             SHUFFLE [RS_19]
                               PartitionCols:_col0
-                              Select Operator [SEL_11] (rows=2301 width=585)
+                              Select Operator [SEL_11] (rows=3600 width=107)
                                 Output:["_col0"]
-                                Filter Operator [FIL_82] (rows=2301 width=585)
-                                  predicate:(wp_char_count BETWEEN 5000 AND 5200 and wp_web_page_sk is not null)
-                                  TableScan [TS_9] (rows=4602 width=585)
-                                    default@web_page,web_page,Tbl:COMPLETE,Col:NONE,Output:["wp_web_page_sk","wp_char_count"]
+                                Filter Operator [FIL_82] (rows=3600 width=107)
+                                  predicate:((hd_dep_count = 8) and hd_demo_sk is not null)
+                                  TableScan [TS_9] (rows=7200 width=107)
+                                    default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
                           <-Reducer 3 [SIMPLE_EDGE]
                             SHUFFLE [RS_18]
-                              PartitionCols:_col2
-                              Merge Join Operator [MERGEJOIN_88] (rows=47520 width=471)
-                                Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col2"]
+                              PartitionCols:_col1
+                              Merge Join Operator [MERGEJOIN_88] (rows=174243235 width=135)
+                                Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col1"]
                               <-Map 9 [SIMPLE_EDGE]
                                 SHUFFLE [RS_16]
                                   PartitionCols:_col0
@@ -125,24 +125,24 @@ Stage-0
                               <-Reducer 2 [SIMPLE_EDGE]
                                 SHUFFLE [RS_15]
                                   PartitionCols:_col0
-                                  Merge Join Operator [MERGEJOIN_87] (rows=3960 width=107)
-                                    Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col0","_col2"]
+                                  Merge Join Operator [MERGEJOIN_87] (rows=158402938 width=135)
+                                    Conds:RS_12._col2=RS_13._col0(Inner),Output:["_col0","_col1"]
                                   <-Map 1 [SIMPLE_EDGE]
                                     SHUFFLE [RS_12]
-                                      PartitionCols:_col1
-                                      Select Operator [SEL_2] (rows=1 width=0)
+                                      PartitionCols:_col2
+                                      Select Operator [SEL_2] (rows=144002668 width=135)
                                         Output:["_col0","_col1","_col2"]
-                                        Filter Operator [FIL_79] (rows=1 width=0)
+                                        Filter Operator [FIL_79] (rows=144002668 width=135)
                                           predicate:(ws_ship_hdemo_sk is not null and ws_sold_time_sk is not null and ws_web_page_sk is not null)
-                                          TableScan [TS_0] (rows=1 width=0)
-                                            default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"]
+                                          TableScan [TS_0] (rows=144002668 width=135)
+                                            default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_time_sk","ws_ship_hdemo_sk","ws_web_page_sk"]
                                   <-Map 8 [SIMPLE_EDGE]
                                     SHUFFLE [RS_13]
                                       PartitionCols:_col0
-                                      Select Operator [SEL_5] (rows=3600 width=107)
+                                      Select Operator [SEL_5] (rows=2301 width=585)
                                         Output:["_col0"]
-                                        Filter Operator [FIL_80] (rows=3600 width=107)
-                                          predicate:((hd_dep_count = 8) and hd_demo_sk is not null)
-                                          TableScan [TS_3] (rows=7200 width=107)
-                                            default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
+                                        Filter Operator [FIL_80] (rows=2301 width=585)
+                                          predicate:(wp_char_count BETWEEN 5000 AND 5200 and wp_web_page_sk is not null)
+                                          TableScan [TS_3] (rows=4602 width=585)
+                                            default@web_page,web_page,Tbl:COMPLETE,Col:NONE,Output:["wp_web_page_sk","wp_char_count"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query91.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query91.q.out b/ql/src/test/results/clientpositive/perf/query91.q.out
index 4725646..fa9165f 100644
--- a/ql/src/test/results/clientpositive/perf/query91.q.out
+++ b/ql/src/test/results/clientpositive/perf/query91.q.out
@@ -5,124 +5,126 @@ POSTHOOK: type: QUERY
 Plan optimized by CBO.
 
 Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 10 (SIMPLE_EDGE)
-Reducer 3 <- Map 11 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
-Reducer 4 <- Map 12 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
-Reducer 5 <- Map 13 (SIMPLE_EDGE), Reducer 4 (SIMPLE_EDGE)
-Reducer 6 <- Map 14 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE)
-Reducer 7 <- Map 15 (SIMPLE_EDGE), Reducer 6 (SIMPLE_EDGE)
-Reducer 8 <- Reducer 7 (SIMPLE_EDGE)
-Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
+Reducer 10 <- Map 12 (SIMPLE_EDGE), Map 9 (SIMPLE_EDGE)
+Reducer 11 <- Map 13 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 8 (SIMPLE_EDGE)
+Reducer 3 <- Reducer 11 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
+Reducer 4 <- Map 14 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Map 15 (SIMPLE_EDGE), Reducer 4 (SIMPLE_EDGE)
+Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
+Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
 
 Stage-0
   Fetch Operator
     limit:-1
     Stage-1
-      Reducer 9
-      File Output Operator [FS_46]
-        Select Operator [SEL_45] (rows=58564004 width=860)
+      Reducer 7
+      File Output Operator [FS_47]
+        Select Operator [SEL_46] (rows=58564004 width=860)
           Output:["_col0","_col1","_col2","_col3"]
-        <-Reducer 8 [SIMPLE_EDGE]
-          SHUFFLE [RS_44]
-            Select Operator [SEL_43] (rows=58564004 width=860)
+        <-Reducer 6 [SIMPLE_EDGE]
+          SHUFFLE [RS_45]
+            Select Operator [SEL_44] (rows=58564004 width=860)
               Output:["_col0","_col1","_col2","_col3"]
-              Group By Operator [GBY_42] (rows=58564004 width=860)
+              Group By Operator [GBY_43] (rows=58564004 width=860)
                 Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4
-              <-Reducer 7 [SIMPLE_EDGE]
-                SHUFFLE [RS_41]
+              <-Reducer 5 [SIMPLE_EDGE]
+                SHUFFLE [RS_42]
                   PartitionCols:_col0, _col1, _col2, _col3, _col4
-                  Group By Operator [GBY_40] (rows=117128008 width=860)
-                    Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col7)"],keys:_col1, _col2, _col3, _col18, _col19
-                    Select Operator [SEL_39] (rows=117128008 width=860)
-                      Output:["_col1","_col2","_col3","_col18","_col19","_col7"]
-                      Merge Join Operator [MERGEJOIN_86] (rows=117128008 width=860)
-                        Conds:RS_36._col13=RS_37._col0(Inner),Output:["_col1","_col2","_col3","_col7","_col18","_col19"]
+                  Group By Operator [GBY_41] (rows=117128008 width=860)
+                    Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col9)"],keys:_col14, _col15, _col16, _col20, _col21
+                    Select Operator [SEL_40] (rows=117128008 width=860)
+                      Output:["_col14","_col15","_col16","_col20","_col21","_col9"]
+                      Merge Join Operator [MERGEJOIN_85] (rows=117128008 width=860)
+                        Conds:RS_37._col1=RS_38._col0(Inner),Output:["_col9","_col14","_col15","_col16","_col20","_col21"]
                       <-Map 15 [SIMPLE_EDGE]
-                        SHUFFLE [RS_37]
+                        SHUFFLE [RS_38]
                           PartitionCols:_col0
-                          Select Operator [SEL_20] (rows=3600 width=107)
-                            Output:["_col0"]
-                            Filter Operator [FIL_80] (rows=3600 width=107)
-                              predicate:((hd_buy_potential like '0-500%') and hd_demo_sk is not null)
-                              TableScan [TS_18] (rows=7200 width=107)
-                                default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_buy_potential"]
-                      <-Reducer 6 [SIMPLE_EDGE]
-                        SHUFFLE [RS_36]
-                          PartitionCols:_col13
-                          Merge Join Operator [MERGEJOIN_85] (rows=106480005 width=860)
-                            Conds:RS_33._col12=RS_34._col0(Inner),Output:["_col1","_col2","_col3","_col7","_col13","_col18","_col19"]
+                          Select Operator [SEL_27] (rows=790 width=204)
+                            Output:["_col0","_col1","_col2"]
+                            Filter Operator [FIL_79] (rows=790 width=204)
+                              predicate:(((cd_marital_status = 'M') or (cd_marital_status = 'W')) and ((cd_education_status = 'Unknown') or (cd_education_status = 'Advanced Degree')) and (((cd_marital_status = 'M') and (cd_education_status = 'Unknown')) or ((cd_marital_status = 'W') and (cd_education_status = 'Advanced Degree'))) and cd_demo_sk is not null)
+                              TableScan [TS_25] (rows=1583 width=204)
+                                default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status","cd_education_status"]
+                      <-Reducer 4 [SIMPLE_EDGE]
+                        SHUFFLE [RS_37]
+                          PartitionCols:_col1
+                          Merge Join Operator [MERGEJOIN_84] (rows=106480005 width=860)
+                            Conds:RS_34._col2=RS_35._col0(Inner),Output:["_col1","_col9","_col14","_col15","_col16"]
                           <-Map 14 [SIMPLE_EDGE]
-                            SHUFFLE [RS_34]
+                            SHUFFLE [RS_35]
                               PartitionCols:_col0
-                              Select Operator [SEL_17] (rows=9900 width=362)
-                                Output:["_col0","_col1","_col2"]
-                                Filter Operator [FIL_79] (rows=9900 width=362)
-                                  predicate:(((cd_marital_status = 'M') or (cd_marital_status = 'W')) and ((cd_education_status = 'Unknown') or (cd_education_status = 'Advanced Degree')) and (((cd_marital_status = 'M') and (cd_education_status = 'Unknown')) or ((cd_marital_status = 'W') and (cd_education_status = 'Advanced Degree'))) and cd_demo_sk is not null)
-                                  TableScan [TS_15] (rows=19800 width=362)
-                                    default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status","cd_education_status"]
-                          <-Reducer 5 [SIMPLE_EDGE]
-                            SHUFFLE [RS_33]
-                              PartitionCols:_col12
-                              Merge Join Operator [MERGEJOIN_84] (rows=96800003 width=860)
-                                Conds:RS_30._col14=RS_31._col0(Inner),Output:["_col1","_col2","_col3","_col7","_col12","_col13"]
-                              <-Map 13 [SIMPLE_EDGE]
+                              Select Operator [SEL_24] (rows=3600 width=107)
+                                Output:["_col0"]
+                                Filter Operator [FIL_78] (rows=3600 width=107)
+                                  predicate:((hd_buy_potential like '0-500%') and hd_demo_sk is not null)
+                                  TableScan [TS_22] (rows=7200 width=107)
+                                    default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_buy_potential"]
+                          <-Reducer 3 [SIMPLE_EDGE]
+                            SHUFFLE [RS_34]
+                              PartitionCols:_col2
+                              Merge Join Operator [MERGEJOIN_83] (rows=96800003 width=860)
+                                Conds:RS_31._col0=RS_32._col1(Inner),Output:["_col1","_col2","_col9","_col14","_col15","_col16"]
+                              <-Reducer 11 [SIMPLE_EDGE]
+                                SHUFFLE [RS_32]
+                                  PartitionCols:_col1
+                                  Select Operator [SEL_21] (rows=34846646 width=106)
+                                    Output:["_col1","_col10","_col3","_col8","_col9"]
+                                    Merge Join Operator [MERGEJOIN_82] (rows=34846646 width=106)
+                                      Conds:RS_18._col2=RS_19._col0(Inner),Output:["_col1","_col3","_col8","_col9","_col10"]
+                                    <-Map 13 [SIMPLE_EDGE]
+                                      SHUFFLE [RS_19]
+                                        PartitionCols:_col0
+                                        Select Operator [SEL_14] (rows=60 width=2045)
+                                          Output:["_col0","_col1","_col2","_col3"]
+                                          Filter Operator [FIL_77] (rows=60 width=2045)
+                                            predicate:cc_call_center_sk is not null
+                                            TableScan [TS_12] (rows=60 width=2045)
+                                              default@call_center,call_center,Tbl:COMPLETE,Col:NONE,Output:["cc_call_center_sk","cc_call_center_id","cc_name","cc_manager"]
+                                    <-Reducer 10 [SIMPLE_EDGE]
+                                      SHUFFLE [RS_18]
+                                        PartitionCols:_col2
+                                        Merge Join Operator [MERGEJOIN_81] (rows=31678769 width=106)
+                                          Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col1","_col2","_col3"]
+                                        <-Map 12 [SIMPLE_EDGE]
+                                          SHUFFLE [RS_16]
+                                            PartitionCols:_col0
+                                            Select Operator [SEL_11] (rows=18262 width=1119)
+                                              Output:["_col0"]
+                                              Filter Operator [FIL_76] (rows=18262 width=1119)
+                                                predicate:((d_year = 1999) and (d_moy = 11) and d_date_sk is not null)
+                                                TableScan [TS_9] (rows=73049 width=1119)
+                                                  default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
+                                        <-Map 9 [SIMPLE_EDGE]
+                                          SHUFFLE [RS_15]
+                                            PartitionCols:_col0
+                                            Select Operator [SEL_8] (rows=28798881 width=106)
+                                              Output:["_col0","_col1","_col2","_col3"]
+                                              Filter Operator [FIL_75] (rows=28798881 width=106)
+                                                predicate:(cr_call_center_sk is not null and cr_returned_date_sk is not null and cr_returning_customer_sk is not null)
+                                                TableScan [TS_6] (rows=28798881 width=106)
+                                                  default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:NONE,Output:["cr_returned_date_sk","cr_returning_customer_sk","cr_call_center_sk","cr_net_loss"]
+                              <-Reducer 2 [SIMPLE_EDGE]
                                 SHUFFLE [RS_31]
                                   PartitionCols:_col0
-                                  Select Operator [SEL_14] (rows=20000000 width=1014)
-                                    Output:["_col0"]
-                                    Filter Operator [FIL_78] (rows=20000000 width=1014)
-                                      predicate:((ca_gmt_offset = -7) and ca_address_sk is not null)
-                                      TableScan [TS_12] (rows=40000000 width=1014)
-                                        default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_gmt_offset"]
-                              <-Reducer 4 [SIMPLE_EDGE]
-                                SHUFFLE [RS_30]
-                                  PartitionCols:_col14
-                                  Merge Join Operator [MERGEJOIN_83] (rows=88000001 width=860)
-                                    Conds:RS_27._col5=RS_28._col0(Inner),Output:["_col1","_col2","_col3","_col7","_col12","_col13","_col14"]
-                                  <-Map 12 [SIMPLE_EDGE]
+                                  Merge Join Operator [MERGEJOIN_80] (rows=88000001 width=860)
+                                    Conds:RS_28._col3=RS_29._col0(Inner),Output:["_col0","_col1","_col2"]
+                                  <-Map 1 [SIMPLE_EDGE]
                                     SHUFFLE [RS_28]
-                                      PartitionCols:_col0
-                                      Select Operator [SEL_11] (rows=80000000 width=860)
+                                      PartitionCols:_col3
+                                      Select Operator [SEL_2] (rows=80000000 width=860)
                                         Output:["_col0","_col1","_col2","_col3"]
-                                        Filter Operator [FIL_77] (rows=80000000 width=860)
+                                        Filter Operator [FIL_73] (rows=80000000 width=860)
                                           predicate:(c_customer_sk is not null and c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_current_hdemo_sk is not null)
-                                          TableScan [TS_9] (rows=80000000 width=860)
+                                          TableScan [TS_0] (rows=80000000 width=860)
                                             default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_cdemo_sk","c_current_hdemo_sk","c_current_addr_sk"]
-                                  <-Reducer 3 [SIMPLE_EDGE]
-                                    SHUFFLE [RS_27]
-                                      PartitionCols:_col5
-                                      Merge Join Operator [MERGEJOIN_82] (rows=20088 width=1119)
-                                        Conds:RS_24._col4=RS_25._col0(Inner),Output:["_col1","_col2","_col3","_col5","_col7"]
-                                      <-Map 11 [SIMPLE_EDGE]
-                                        SHUFFLE [RS_25]
-                                          PartitionCols:_col0
-                                          Select Operator [SEL_8] (rows=18262 width=1119)
-                                            Output:["_col0"]
-                                            Filter Operator [FIL_76] (rows=18262 width=1119)
-                                              predicate:((d_year = 1999) and (d_moy = 11) and d_date_sk is not null)
-                                              TableScan [TS_6] (rows=73049 width=1119)
-                                                default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
-                                      <-Reducer 2 [SIMPLE_EDGE]
-                                        SHUFFLE [RS_24]
-                                          PartitionCols:_col4
-                                          Merge Join Operator [MERGEJOIN_81] (rows=66 width=2045)
-                                            Conds:RS_21._col0=RS_22._col2(Inner),Output:["_col1","_col2","_col3","_col4","_col5","_col7"]
-                                          <-Map 1 [SIMPLE_EDGE]
-                                            SHUFFLE [RS_21]
-                                              PartitionCols:_col0
-                                              Select Operator [SEL_2] (rows=60 width=2045)
-                                                Output:["_col0","_col1","_col2","_col3"]
-                                                Filter Operator [FIL_74] (rows=60 width=2045)
-                                                  predicate:cc_call_center_sk is not null
-                                                  TableScan [TS_0] (rows=60 width=2045)
-                                                    default@call_center,call_center,Tbl:COMPLETE,Col:NONE,Output:["cc_call_center_sk","cc_call_center_id","cc_name","cc_manager"]
-                                          <-Map 10 [SIMPLE_EDGE]
-                                            SHUFFLE [RS_22]
-                                              PartitionCols:_col2
-                                              Select Operator [SEL_5] (rows=1 width=0)
-                                                Output:["_col0","_col1","_col2","_col3"]
-                                                Filter Operator [FIL_75] (rows=1 width=0)
-                                                  predicate:(cr_call_center_sk is not null and cr_returned_date_sk is not null and cr_returning_customer_sk is not null)
-                                                  TableScan [TS_3] (rows=1 width=0)
-                                                    default@catalog_returns,catalog_returns,Tbl:PARTIAL,Col:NONE,Output:["cr_returned_date_sk","cr_returning_customer_sk","cr_call_center_sk","cr_net_loss"]
+                                  <-Map 8 [SIMPLE_EDGE]
+                                    SHUFFLE [RS_29]
+                                      PartitionCols:_col0
+                                      Select Operator [SEL_5] (rows=20000000 width=1014)
+                                        Output:["_col0"]
+                                        Filter Operator [FIL_74] (rows=20000000 width=1014)
+                                          predicate:((ca_gmt_offset = -7) and ca_address_sk is not null)
+                                          TableScan [TS_3] (rows=40000000 width=1014)
+                                            default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_gmt_offset"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query92.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query92.q.out b/ql/src/test/results/clientpositive/perf/query92.q.out
index 3a1d03d..f8186f5 100644
--- a/ql/src/test/results/clientpositive/perf/query92.q.out
+++ b/ql/src/test/results/clientpositive/perf/query92.q.out
@@ -24,33 +24,33 @@ Stage-0
           SHUFFLE [RS_34]
             Group By Operator [GBY_33] (rows=1 width=24)
               Output:["_col0","_col1","_col2"],aggregations:["sum(_col0)","sum(_col1)","sum(_col2)"]
-              Select Operator [SEL_31] (rows=4909 width=1119)
+              Select Operator [SEL_31] (rows=348477374 width=88)
                 Output:["_col0","_col1","_col2"]
-                Merge Join Operator [MERGEJOIN_48] (rows=4909 width=1119)
+                Merge Join Operator [MERGEJOIN_48] (rows=348477374 width=88)
                   Conds:RS_28._col0, _col1=RS_29._col0, _col1(Outer),Output:["_col0","_col2"]
                 <-Reducer 3 [SIMPLE_EDGE]
                   SHUFFLE [RS_28]
                     PartitionCols:_col0, _col1
-                    Select Operator [SEL_13] (rows=4463 width=1119)
+                    Select Operator [SEL_13] (rows=316797606 width=88)
                       Output:["_col0","_col1"]
-                      Group By Operator [GBY_12] (rows=4463 width=1119)
+                      Group By Operator [GBY_12] (rows=316797606 width=88)
                         Output:["_col0","_col1"],keys:KEY._col0, KEY._col1
                       <-Reducer 2 [SIMPLE_EDGE]
                         SHUFFLE [RS_11]
                           PartitionCols:_col0, _col1
-                          Group By Operator [GBY_10] (rows=8927 width=1119)
+                          Group By Operator [GBY_10] (rows=633595212 width=88)
                             Output:["_col0","_col1"],keys:_col1, _col2
-                            Merge Join Operator [MERGEJOIN_46] (rows=8927 width=1119)
+                            Merge Join Operator [MERGEJOIN_46] (rows=633595212 width=88)
                               Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col1","_col2"]
                             <-Map 1 [SIMPLE_EDGE]
                               SHUFFLE [RS_6]
                                 PartitionCols:_col0
-                                Select Operator [SEL_2] (rows=1 width=0)
+                                Select Operator [SEL_2] (rows=575995635 width=88)
                                   Output:["_col0","_col1","_col2"]
-                                  Filter Operator [FIL_42] (rows=1 width=0)
+                                  Filter Operator [FIL_42] (rows=575995635 width=88)
                                     predicate:ss_sold_date_sk is not null
-                                    TableScan [TS_0] (rows=1 width=0)
-                                      default@store_sales,ss,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk"]
+                                    TableScan [TS_0] (rows=575995635 width=88)
+                                      default@store_sales,ss,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk"]
                             <-Map 6 [SIMPLE_EDGE]
                               SHUFFLE [RS_7]
                                 PartitionCols:_col0
@@ -63,14 +63,14 @@ Stage-0
                 <-Reducer 9 [SIMPLE_EDGE]
                   SHUFFLE [RS_29]
                     PartitionCols:_col0, _col1
-                    Group By Operator [GBY_26] (rows=4463 width=1119)
+                    Group By Operator [GBY_26] (rows=158394413 width=135)
                       Output:["_col0","_col1"],keys:KEY._col0, KEY._col1
                     <-Reducer 8 [SIMPLE_EDGE]
                       SHUFFLE [RS_25]
                         PartitionCols:_col0, _col1
-                        Group By Operator [GBY_24] (rows=8927 width=1119)
+                        Group By Operator [GBY_24] (rows=316788826 width=135)
                           Output:["_col0","_col1"],keys:_col1, _col2
-                          Merge Join Operator [MERGEJOIN_47] (rows=8927 width=1119)
+                          Merge Join Operator [MERGEJOIN_47] (rows=316788826 width=135)
                             Conds:RS_20._col0=RS_21._col0(Inner),Output:["_col1","_col2"]
                           <-Map 10 [SIMPLE_EDGE]
                             SHUFFLE [RS_21]
@@ -84,10 +84,10 @@ Stage-0
                           <-Map 7 [SIMPLE_EDGE]
                             SHUFFLE [RS_20]
                               PartitionCols:_col0
-                              Select Operator [SEL_16] (rows=1 width=0)
+                              Select Operator [SEL_16] (rows=287989836 width=135)
                                 Output:["_col0","_col1","_col2"]
-                                Filter Operator [FIL_44] (rows=1 width=0)
+                                Filter Operator [FIL_44] (rows=287989836 width=135)
                                   predicate:cs_sold_date_sk is not null
-                                  TableScan [TS_14] (rows=1 width=0)
-                                    default@catalog_sales,cs,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk"]
+                                  TableScan [TS_14] (rows=287989836 width=135)
+                                    default@catalog_sales,cs,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query93.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query93.q.out b/ql/src/test/results/clientpositive/perf/query93.q.out
index 87d6c26..f28ba41 100644
--- a/ql/src/test/results/clientpositive/perf/query93.q.out
+++ b/ql/src/test/results/clientpositive/perf/query93.q.out
@@ -16,53 +16,53 @@ Stage-0
     Stage-1
       Reducer 5
       File Output Operator [FS_24]
-        Limit [LIM_23] (rows=19 width=203)
+        Limit [LIM_23] (rows=100 width=88)
           Number of rows:100
-          Select Operator [SEL_22] (rows=19 width=203)
+          Select Operator [SEL_22] (rows=316797606 width=88)
             Output:["_col0","_col1"]
           <-Reducer 4 [SIMPLE_EDGE]
             SHUFFLE [RS_21]
-              Group By Operator [GBY_19] (rows=19 width=203)
+              Group By Operator [GBY_19] (rows=316797606 width=88)
                 Output:["_col0","_col1"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0
               <-Reducer 3 [SIMPLE_EDGE]
                 SHUFFLE [RS_18]
                   PartitionCols:_col0
-                  Group By Operator [GBY_17] (rows=39 width=203)
+                  Group By Operator [GBY_17] (rows=633595212 width=88)
                     Output:["_col0","_col1"],aggregations:["sum(_col1)"],keys:_col0
-                    Select Operator [SEL_15] (rows=39 width=203)
+                    Select Operator [SEL_15] (rows=633595212 width=88)
                       Output:["_col0","_col1"]
-                      Merge Join Operator [MERGEJOIN_34] (rows=39 width=203)
-                        Conds:RS_12._col6=RS_13._col0(Inner),Output:["_col1","_col3","_col4","_col8"]
+                      Merge Join Operator [MERGEJOIN_34] (rows=633595212 width=88)
+                        Conds:RS_12._col0, _col2=RS_13._col0, _col2(Inner),Output:["_col3","_col7","_col9","_col10"]
                       <-Map 7 [SIMPLE_EDGE]
                         SHUFFLE [RS_13]
-                          PartitionCols:_col0
-                          Select Operator [SEL_8] (rows=36 width=200)
-                            Output:["_col0"]
-                            Filter Operator [FIL_32] (rows=36 width=200)
-                              predicate:((r_reason_desc = 'Did not like the warranty') and r_reason_sk is not null)
-                              TableScan [TS_6] (rows=72 width=200)
-                                default@reason,reason,Tbl:COMPLETE,Col:NONE,Output:["r_reason_sk","r_reason_desc"]
+                          PartitionCols:_col0, _col2
+                          Select Operator [SEL_8] (rows=575995635 width=88)
+                            Output:["_col0","_col1","_col2","_col3","_col4"]
+                            Filter Operator [FIL_32] (rows=575995635 width=88)
+                              predicate:(ss_item_sk is not null and ss_ticket_number is not null)
+                              TableScan [TS_6] (rows=575995635 width=88)
+                                default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_item_sk","ss_customer_sk","ss_ticket_number","ss_quantity","ss_sales_price"]
                       <-Reducer 2 [SIMPLE_EDGE]
                         SHUFFLE [RS_12]
-                          PartitionCols:_col6
-                          Merge Join Operator [MERGEJOIN_33] (rows=1 width=0)
-                            Conds:RS_9._col0, _col2=RS_10._col0, _col2(Inner),Output:["_col1","_col3","_col4","_col6","_col8"]
+                          PartitionCols:_col0, _col2
+                          Merge Join Operator [MERGEJOIN_33] (rows=63350266 width=77)
+                            Conds:RS_9._col1=RS_10._col0(Inner),Output:["_col0","_col2","_col3"]
                           <-Map 1 [SIMPLE_EDGE]
                             SHUFFLE [RS_9]
-                              PartitionCols:_col0, _col2
-                              Select Operator [SEL_2] (rows=1 width=0)
-                                Output:["_col0","_col1","_col2","_col3","_col4"]
-                                Filter Operator [FIL_30] (rows=1 width=0)
-                                  predicate:(ss_item_sk is not null and ss_ticket_number is not null)
-                                  TableScan [TS_0] (rows=1 width=0)
-                                    default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_item_sk","ss_customer_sk","ss_ticket_number","ss_quantity","ss_sales_price"]
-                          <-Map 6 [SIMPLE_EDGE]
-                            SHUFFLE [RS_10]
-                              PartitionCols:_col0, _col2
-                              Select Operator [SEL_5] (rows=1 width=0)
+                              PartitionCols:_col1
+                              Select Operator [SEL_2] (rows=57591150 width=77)
                                 Output:["_col0","_col1","_col2","_col3"]
-                                Filter Operator [FIL_31] (rows=1 width=0)
+                                Filter Operator [FIL_30] (rows=57591150 width=77)
                                   predicate:(sr_reason_sk is not null and sr_item_sk is not null and sr_ticket_number is not null)
-                                  TableScan [TS_3] (rows=1 width=0)
-                                    default@store_returns,store_returns,Tbl:PARTIAL,Col:NONE,Output:["sr_item_sk","sr_reason_sk","sr_ticket_number","sr_return_quantity"]
+                                  TableScan [TS_0] (rows=57591150 width=77)
+                                    default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_item_sk","sr_reason_sk","sr_ticket_number","sr_return_quantity"]
+                          <-Map 6 [SIMPLE_EDGE]
+                            SHUFFLE [RS_10]
+                              PartitionCols:_col0
+                              Select Operator [SEL_5] (rows=36 width=200)
+                                Output:["_col0"]
+                                Filter Operator [FIL_31] (rows=36 width=200)
+                                  predicate:((r_reason_desc = 'Did not like the warranty') and r_reason_sk is not null)
+                                  TableScan [TS_3] (rows=72 width=200)
+                                    default@reason,reason,Tbl:COMPLETE,Col:NONE,Output:["r_reason_sk","r_reason_desc"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query94.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query94.q.out b/ql/src/test/results/clientpositive/perf/query94.q.out
index 8ac8cc2..95d4981 100644
--- a/ql/src/test/results/clientpositive/perf/query94.q.out
+++ b/ql/src/test/results/clientpositive/perf/query94.q.out
@@ -18,113 +18,113 @@ Stage-0
     limit:100
     Stage-1
       Reducer 7
-      File Output Operator [FS_50]
-        Limit [LIM_49] (rows=1 width=344)
+      File Output Operator [FS_51]
+        Limit [LIM_50] (rows=1 width=344)
           Number of rows:100
-          Group By Operator [GBY_47] (rows=1 width=344)
+          Group By Operator [GBY_48] (rows=1 width=344)
             Output:["_col0","_col1","_col2"],aggregations:["count(DISTINCT KEY._col0:0._col0)","sum(VALUE._col1)","sum(VALUE._col2)"]
           <-Reducer 6 [SIMPLE_EDGE]
-            SHUFFLE [RS_46]
-              Group By Operator [GBY_45] (rows=14641000 width=1014)
+            SHUFFLE [RS_47]
+              Group By Operator [GBY_46] (rows=127554770 width=135)
                 Output:["_col0","_col1","_col2","_col3"],aggregations:["count(DISTINCT _col3)","sum(_col4)","sum(_col5)"],keys:_col3
-                Select Operator [SEL_44] (rows=14641000 width=1014)
+                Select Operator [SEL_45] (rows=127554770 width=135)
                   Output:["_col3","_col4","_col5"]
-                  Filter Operator [FIL_43] (rows=14641000 width=1014)
+                  Filter Operator [FIL_44] (rows=127554770 width=135)
                     predicate:_col12 is null
-                    Merge Join Operator [MERGEJOIN_84] (rows=29282000 width=1014)
+                    Merge Join Operator [MERGEJOIN_85] (rows=255109540 width=135)
                       Conds:RS_40._col3=RS_41._col0(Left Outer),Output:["_col3","_col4","_col5","_col12"]
                     <-Map 14 [SIMPLE_EDGE]
                       SHUFFLE [RS_41]
                         PartitionCols:_col0
-                        Select Operator [SEL_25] (rows=1 width=0)
+                        Select Operator [SEL_25] (rows=14398467 width=92)
                           Output:["_col0"]
-                          Filter Operator [FIL_78] (rows=1 width=0)
+                          Filter Operator [FIL_79] (rows=14398467 width=92)
                             predicate:wr_order_number is not null
-                            TableScan [TS_23] (rows=1 width=0)
-                              default@web_returns,wr1,Tbl:PARTIAL,Col:NONE,Output:["wr_order_number"]
+                            TableScan [TS_23] (rows=14398467 width=92)
+                              default@web_returns,wr1,Tbl:COMPLETE,Col:NONE,Output:["wr_order_number"]
                     <-Reducer 5 [SIMPLE_EDGE]
                       SHUFFLE [RS_40]
                         PartitionCols:_col3
-                        Merge Join Operator [MERGEJOIN_83] (rows=26620000 width=1014)
-                          Conds:RS_37._col0=RS_38._col0(Inner),Output:["_col3","_col4","_col5"]
+                        Merge Join Operator [MERGEJOIN_84] (rows=231917759 width=135)
+                          Conds:RS_37._col2=RS_38._col0(Inner),Output:["_col3","_col4","_col5"]
                         <-Map 13 [SIMPLE_EDGE]
                           SHUFFLE [RS_38]
                             PartitionCols:_col0
-                            Select Operator [SEL_22] (rows=36524 width=1119)
+                            Select Operator [SEL_22] (rows=42 width=1850)
                               Output:["_col0"]
-                              Filter Operator [FIL_77] (rows=36524 width=1119)
-                                predicate:(d_date BETWEEN '1999-05-01' AND '1999-07-01' and d_date_sk is not null)
-                                TableScan [TS_20] (rows=73049 width=1119)
-                                  default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
+                              Filter Operator [FIL_78] (rows=42 width=1850)
+                                predicate:((web_company_name = 'pri') and web_site_sk is not null)
+                                TableScan [TS_20] (rows=84 width=1850)
+                                  default@web_site,s,Tbl:COMPLETE,Col:NONE,Output:["web_site_sk","web_company_name"]
                         <-Reducer 4 [SIMPLE_EDGE]
                           SHUFFLE [RS_37]
-                            PartitionCols:_col0
-                            Merge Join Operator [MERGEJOIN_82] (rows=24200000 width=1014)
-                              Conds:RS_34._col2=RS_35._col0(Inner),Output:["_col0","_col3","_col4","_col5"]
+                            PartitionCols:_col2
+                            Merge Join Operator [MERGEJOIN_83] (rows=210834322 width=135)
+                              Conds:RS_34._col1=RS_35._col0(Inner),Output:["_col2","_col3","_col4","_col5"]
                             <-Map 12 [SIMPLE_EDGE]
                               SHUFFLE [RS_35]
                                 PartitionCols:_col0
-                                Select Operator [SEL_19] (rows=42 width=1850)
+                                Select Operator [SEL_19] (rows=20000000 width=1014)
                                   Output:["_col0"]
-                                  Filter Operator [FIL_76] (rows=42 width=1850)
-                                    predicate:((web_company_name = 'pri') and web_site_sk is not null)
-                                    TableScan [TS_17] (rows=84 width=1850)
-                                      default@web_site,s,Tbl:COMPLETE,Col:NONE,Output:["web_site_sk","web_company_name"]
+                                  Filter Operator [FIL_77] (rows=20000000 width=1014)
+                                    predicate:((ca_state = 'TX') and ca_address_sk is not null)
+                                    TableScan [TS_17] (rows=40000000 width=1014)
+                                      default@customer_address,ca,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state"]
                             <-Reducer 3 [SIMPLE_EDGE]
                               SHUFFLE [RS_34]
-                                PartitionCols:_col2
-                                Merge Join Operator [MERGEJOIN_81] (rows=22000000 width=1014)
-                                  Conds:RS_31._col1=RS_32._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
+                                PartitionCols:_col1
+                                Merge Join Operator [MERGEJOIN_82] (rows=191667562 width=135)
+                                  Conds:RS_31._col0=RS_32._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col5"]
                                 <-Map 11 [SIMPLE_EDGE]
                                   SHUFFLE [RS_32]
                                     PartitionCols:_col0
-                                    Select Operator [SEL_16] (rows=20000000 width=1014)
+                                    Select Operator [SEL_16] (rows=36524 width=1119)
                                       Output:["_col0"]
-                                      Filter Operator [FIL_75] (rows=20000000 width=1014)
-                                        predicate:((ca_state = 'TX') and ca_address_sk is not null)
-                                        TableScan [TS_14] (rows=40000000 width=1014)
-                                          default@customer_address,ca,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state"]
+                                      Filter Operator [FIL_76] (rows=36524 width=1119)
+                                        predicate:(d_date BETWEEN '1999-05-01' AND '1999-07-01' and d_date_sk is not null)
+                                        TableScan [TS_14] (rows=73049 width=1119)
+                                          default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
                                 <-Reducer 2 [SIMPLE_EDGE]
                                   SHUFFLE [RS_31]
-                                    PartitionCols:_col1
-                                    Merge Join Operator [MERGEJOIN_80] (rows=1 width=0)
+                                    PartitionCols:_col0
+                                    Merge Join Operator [MERGEJOIN_81] (rows=174243235 width=135)
                                       Conds:RS_28._col3=RS_29._col0(Left Semi),Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
                                     <-Map 1 [SIMPLE_EDGE]
                                       SHUFFLE [RS_28]
                                         PartitionCols:_col3
-                                        Select Operator [SEL_2] (rows=1 width=0)
+                                        Select Operator [SEL_2] (rows=144002668 width=135)
                                           Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                                          Filter Operator [FIL_72] (rows=1 width=0)
+                                          Filter Operator [FIL_73] (rows=144002668 width=135)
                                             predicate:(ws_ship_addr_sk is not null and ws_web_site_sk is not null and ws_ship_date_sk is not null and ws_order_number is not null)
-                                            TableScan [TS_0] (rows=1 width=0)
-                                              default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_ship_date_sk","ws_ship_addr_sk","ws_web_site_sk","ws_order_number","ws_ext_ship_cost","ws_net_profit"]
+                                            TableScan [TS_0] (rows=144002668 width=135)
+                                              default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_ship_date_sk","ws_ship_addr_sk","ws_web_site_sk","ws_order_number","ws_ext_ship_cost","ws_net_profit"]
                                     <-Reducer 9 [SIMPLE_EDGE]
                                       SHUFFLE [RS_29]
                                         PartitionCols:_col0
-                                        Group By Operator [GBY_27] (rows=1 width=0)
+                                        Group By Operator [GBY_27] (rows=158402938 width=135)
                                           Output:["_col0"],keys:_col0
-                                          Select Operator [SEL_13] (rows=1 width=0)
+                                          Select Operator [SEL_13] (rows=158402938 width=135)
                                             Output:["_col0"]
-                                            Filter Operator [FIL_12] (rows=1 width=0)
+                                            Filter Operator [FIL_12] (rows=158402938 width=135)
                                               predicate:(_col0 <> _col2)
-                                              Merge Join Operator [MERGEJOIN_79] (rows=1 width=0)
+                                              Merge Join Operator [MERGEJOIN_80] (rows=158402938 width=135)
                                                 Conds:RS_9._col1=RS_10._col1(Inner),Output:["_col0","_col1","_col2"]
                                               <-Map 10 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_10]
                                                   PartitionCols:_col1
-                                                  Select Operator [SEL_8] (rows=1 width=0)
+                                                  Select Operator [SEL_8] (rows=144002668 width=135)
                                                     Output:["_col0","_col1"]
-                                                    Filter Operator [FIL_74] (rows=1 width=0)
+                                                    Filter Operator [FIL_75] (rows=144002668 width=135)
                                                       predicate:ws_order_number is not null
-                                                      TableScan [TS_6] (rows=1 width=0)
-                                                        default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
+                                                      TableScan [TS_6] (rows=144002668 width=135)
+                                                        default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
                                               <-Map 8 [SIMPLE_EDGE]
                                                 SHUFFLE [RS_9]
                                                   PartitionCols:_col1
-                                                  Select Operator [SEL_5] (rows=1 width=0)
+                                                  Select Operator [SEL_5] (rows=144002668 width=135)
                                                     Output:["_col0","_col1"]
-                                                    Filter Operator [FIL_73] (rows=1 width=0)
+                                                    Filter Operator [FIL_74] (rows=144002668 width=135)
                                                       predicate:ws_order_number is not null
-                                                      TableScan [TS_3] (rows=1 width=0)
-                                                        default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
+                                                      TableScan [TS_3] (rows=144002668 width=135)
+                                                        default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query95.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query95.q.out b/ql/src/test/results/clientpositive/perf/query95.q.out
index 534e910..4af7e29 100644
--- a/ql/src/test/results/clientpositive/perf/query95.q.out
+++ b/ql/src/test/results/clientpositive/perf/query95.q.out
@@ -5,9 +5,9 @@ POSTHOOK: type: QUERY
 Plan optimized by CBO.
 
 Vertex dependency in root stage
-Reducer 11 <- Map 10 (SIMPLE_EDGE), Reducer 13 (SIMPLE_EDGE)
-Reducer 13 <- Map 12 (SIMPLE_EDGE), Map 14 (SIMPLE_EDGE)
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 11 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
+Reducer 11 <- Map 10 (SIMPLE_EDGE), Map 13 (SIMPLE_EDGE)
+Reducer 12 <- Map 14 (SIMPLE_EDGE), Reducer 11 (SIMPLE_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 12 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
 Reducer 3 <- Map 15 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
 Reducer 4 <- Map 16 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
 Reducer 5 <- Map 17 (SIMPLE_EDGE), Reducer 4 (SIMPLE_EDGE)
@@ -24,131 +24,133 @@ Stage-0
           Output:["_col0","_col1","_col2"],aggregations:["count(DISTINCT KEY._col0:0._col0)","sum(VALUE._col1)","sum(VALUE._col2)"]
         <-Reducer 5 [SIMPLE_EDGE]
           SHUFFLE [RS_60]
-            Group By Operator [GBY_59] (rows=26620000 width=1014)
+            Group By Operator [GBY_59] (rows=510219083 width=135)
               Output:["_col0","_col1","_col2","_col3"],aggregations:["count(DISTINCT _col3)","sum(_col4)","sum(_col5)"],keys:_col3
-              Merge Join Operator [MERGEJOIN_122] (rows=26620000 width=1014)
-                Conds:RS_55._col0=RS_56._col0(Inner),Output:["_col3","_col4","_col5"]
+              Merge Join Operator [MERGEJOIN_122] (rows=510219083 width=135)
+                Conds:RS_55._col2=RS_56._col0(Inner),Output:["_col3","_col4","_col5"]
               <-Map 17 [SIMPLE_EDGE]
                 SHUFFLE [RS_56]
                   PartitionCols:_col0
-                  Select Operator [SEL_40] (rows=36524 width=1119)
+                  Select Operator [SEL_40] (rows=42 width=1850)
                     Output:["_col0"]
-                    Filter Operator [FIL_115] (rows=36524 width=1119)
-                      predicate:(d_date BETWEEN '2002-05-01' AND '2002-06-30' and d_date_sk is not null)
-                      TableScan [TS_38] (rows=73049 width=1119)
-                        default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
+                    Filter Operator [FIL_115] (rows=42 width=1850)
+                      predicate:((web_company_name = 'pri') and web_site_sk is not null)
+                      TableScan [TS_38] (rows=84 width=1850)
+                        default@web_site,s,Tbl:COMPLETE,Col:NONE,Output:["web_site_sk","web_company_name"]
               <-Reducer 4 [SIMPLE_EDGE]
                 SHUFFLE [RS_55]
-                  PartitionCols:_col0
-                  Merge Join Operator [MERGEJOIN_121] (rows=24200000 width=1014)
-                    Conds:RS_52._col2=RS_53._col0(Inner),Output:["_col0","_col3","_col4","_col5"]
+                  PartitionCols:_col2
+                  Merge Join Operator [MERGEJOIN_121] (rows=463835520 width=135)
+                    Conds:RS_52._col1=RS_53._col0(Inner),Output:["_col2","_col3","_col4","_col5"]
                   <-Map 16 [SIMPLE_EDGE]
                     SHUFFLE [RS_53]
                       PartitionCols:_col0
-                      Select Operator [SEL_37] (rows=42 width=1850)
+                      Select Operator [SEL_37] (rows=20000000 width=1014)
                         Output:["_col0"]
-                        Filter Operator [FIL_114] (rows=42 width=1850)
-                          predicate:((web_company_name = 'pri') and web_site_sk is not null)
-                          TableScan [TS_35] (rows=84 width=1850)
-                            default@web_site,s,Tbl:COMPLETE,Col:NONE,Output:["web_site_sk","web_company_name"]
+                        Filter Operator [FIL_114] (rows=20000000 width=1014)
+                          predicate:((ca_state = 'GA') and ca_address_sk is not null)
+                          TableScan [TS_35] (rows=40000000 width=1014)
+                            default@customer_address,ca,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state"]
                   <-Reducer 3 [SIMPLE_EDGE]
                     SHUFFLE [RS_52]
-                      PartitionCols:_col2
-                      Merge Join Operator [MERGEJOIN_120] (rows=22000000 width=1014)
-                        Conds:RS_49._col1=RS_50._col0(Inner),Output:["_col0","_col2","_col3","_col4","_col5"]
+                      PartitionCols:_col1
+                      Merge Join Operator [MERGEJOIN_120] (rows=421668646 width=135)
+                        Conds:RS_49._col0=RS_50._col0(Inner),Output:["_col1","_col2","_col3","_col4","_col5"]
                       <-Map 15 [SIMPLE_EDGE]
                         SHUFFLE [RS_50]
                           PartitionCols:_col0
-                          Select Operator [SEL_34] (rows=20000000 width=1014)
+                          Select Operator [SEL_34] (rows=36524 width=1119)
                             Output:["_col0"]
-                            Filter Operator [FIL_113] (rows=20000000 width=1014)
-                              predicate:((ca_state = 'GA') and ca_address_sk is not null)
-                              TableScan [TS_32] (rows=40000000 width=1014)
-                                default@customer_address,ca,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state"]
+                            Filter Operator [FIL_113] (rows=36524 width=1119)
+                              predicate:(d_date BETWEEN '2002-05-01' AND '2002-06-30' and d_date_sk is not null)
+                              TableScan [TS_32] (rows=73049 width=1119)
+                                default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]
                       <-Reducer 2 [SIMPLE_EDGE]
                         SHUFFLE [RS_49]
-                          PartitionCols:_col1
-                          Merge Join Operator [MERGEJOIN_119] (rows=2 width=0)
+                          PartitionCols:_col0
+                          Merge Join Operator [MERGEJOIN_119] (rows=383335125 width=135)
                             Conds:RS_45._col3=RS_46._col0(Left Semi),RS_45._col3=RS_47._col0(Left Semi),Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
                           <-Map 1 [SIMPLE_EDGE]
                             SHUFFLE [RS_45]
                               PartitionCols:_col3
-                              Select Operator [SEL_2] (rows=1 width=0)
+                              Select Operator [SEL_2] (rows=144002668 width=135)
                                 Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                                Filter Operator [FIL_107] (rows=1 width=0)
+                                Filter Operator [FIL_107] (rows=144002668 width=135)
                                   predicate:(ws_ship_addr_sk is not null and ws_web_site_sk is not null and ws_ship_date_sk is not null and ws_order_number is not null)
-                                  TableScan [TS_0] (rows=1 width=0)
-                                    default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_ship_date_sk","ws_ship_addr_sk","ws_web_site_sk","ws_order_number","ws_ext_ship_cost","ws_net_profit"]
-                          <-Reducer 11 [SIMPLE_EDGE]
+                                  TableScan [TS_0] (rows=144002668 width=135)
+                                    default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_ship_date_sk","ws_ship_addr_sk","ws_web_site_sk","ws_order_number","ws_ext_ship_cost","ws_net_profit"]
+                          <-Reducer 12 [SIMPLE_EDGE]
                             SHUFFLE [RS_47]
                               PartitionCols:_col0
-                              Group By Operator [GBY_44] (rows=1 width=0)
+                              Group By Operator [GBY_44] (rows=174243235 width=135)
                                 Output:["_col0"],keys:_col0
-                                Merge Join Operator [MERGEJOIN_118] (rows=1 width=0)
-                                  Conds:RS_28._col0=RS_29._col0(Inner),Output:["_col0"]
-                                <-Map 10 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_28]
-                                    PartitionCols:_col0
-                                    Select Operator [SEL_16] (rows=1 width=0)
-                                      Output:["_col0"]
-                                      Filter Operator [FIL_110] (rows=1 width=0)
-                                        predicate:wr_order_number is not null
-                                        TableScan [TS_14] (rows=1 width=0)
-                                          default@web_returns,wr,Tbl:PARTIAL,Col:NONE,Output:["wr_order_number"]
-                                <-Reducer 13 [SIMPLE_EDGE]
-                                  SHUFFLE [RS_29]
-                                    PartitionCols:_col0
-                                    Select Operator [SEL_27] (rows=1 width=0)
-                                      Output:["_col0"]
-                                      Filter Operator [FIL_26] (rows=1 width=0)
-                                        predicate:(_col0 <> _col2)
-                                        Merge Join Operator [MERGEJOIN_117] (rows=1 width=0)
-                                          Conds:RS_23._col1=RS_24._col1(Inner),Output:["_col0","_col1","_col2"]
-                                        <-Map 12 [SIMPLE_EDGE]
-                                          SHUFFLE [RS_23]
-                                            PartitionCols:_col1
-                                            Select Operator [SEL_19] (rows=1 width=0)
-                                              Output:["_col0","_col1"]
-                                              Filter Operator [FIL_111] (rows=1 width=0)
-                                                predicate:ws_order_number is not null
-                                                TableScan [TS_17] (rows=1 width=0)
-                                                  default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
-                                        <-Map 14 [SIMPLE_EDGE]
-                                          SHUFFLE [RS_24]
-                                            PartitionCols:_col1
-                                            Select Operator [SEL_22] (rows=1 width=0)
-                                              Output:["_col0","_col1"]
-                                              Filter Operator [FIL_112] (rows=1 width=0)
-                                                predicate:ws_order_number is not null
-                                                TableScan [TS_20] (rows=1 width=0)
-                                                  default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
+                                Select Operator [SEL_31] (rows=174243235 width=135)
+                                  Output:["_col0"]
+                                  Merge Join Operator [MERGEJOIN_118] (rows=174243235 width=135)
+                                    Conds:RS_28._col0=RS_29._col0(Inner),Output:["_col1"]
+                                  <-Map 14 [SIMPLE_EDGE]
+                                    SHUFFLE [RS_29]
+                                      PartitionCols:_col0
+                                      Select Operator [SEL_27] (rows=14398467 width=92)
+                                        Output:["_col0"]
+                                        Filter Operator [FIL_112] (rows=14398467 width=92)
+                                          predicate:wr_order_number is not null
+                                          TableScan [TS_25] (rows=14398467 width=92)
+                                            default@web_returns,wr,Tbl:COMPLETE,Col:NONE,Output:["wr_order_number"]
+                                  <-Reducer 11 [SIMPLE_EDGE]
+                                    SHUFFLE [RS_28]
+                                      PartitionCols:_col0
+                                      Select Operator [SEL_24] (rows=158402938 width=135)
+                                        Output:["_col0"]
+                                        Filter Operator [FIL_23] (rows=158402938 width=135)
+                                          predicate:(_col0 <> _col2)
+                                          Merge Join Operator [MERGEJOIN_117] (rows=158402938 width=135)
+                                            Conds:RS_20._col1=RS_21._col1(Inner),Output:["_col0","_col1","_col2"]
+                                          <-Map 10 [SIMPLE_EDGE]
+                                            SHUFFLE [RS_20]
+                                              PartitionCols:_col1
+                                              Select Operator [SEL_16] (rows=144002668 width=135)
+                                                Output:["_col0","_col1"]
+                                                Filter Operator [FIL_110] (rows=144002668 width=135)
+                                                  predicate:ws_order_number is not null
+                                                  TableScan [TS_14] (rows=144002668 width=135)
+                                                    default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
+                                          <-Map 13 [SIMPLE_EDGE]
+                                            SHUFFLE [RS_21]
+                                              PartitionCols:_col1
+                                              Select Operator [SEL_19] (rows=144002668 width=135)
+                                                Output:["_col0","_col1"]
+                                                Filter Operator [FIL_111] (rows=144002668 width=135)
+                                                  predicate:ws_order_number is not null
+                                                  TableScan [TS_17] (rows=144002668 width=135)
+                                                    default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
                           <-Reducer 8 [SIMPLE_EDGE]
                             SHUFFLE [RS_46]
                               PartitionCols:_col0
-                              Group By Operator [GBY_42] (rows=1 width=0)
+                              Group By Operator [GBY_42] (rows=158402938 width=135)
                                 Output:["_col0"],keys:_col0
-                                Select Operator [SEL_13] (rows=1 width=0)
+                                Select Operator [SEL_13] (rows=158402938 width=135)
                                   Output:["_col0"]
-                                  Filter Operator [FIL_12] (rows=1 width=0)
+                                  Filter Operator [FIL_12] (rows=158402938 width=135)
                                     predicate:(_col0 <> _col2)
-                                    Merge Join Operator [MERGEJOIN_116] (rows=1 width=0)
+                                    Merge Join Operator [MERGEJOIN_116] (rows=158402938 width=135)
                                       Conds:RS_9._col1=RS_10._col1(Inner),Output:["_col0","_col1","_col2"]
                                     <-Map 7 [SIMPLE_EDGE]
                                       SHUFFLE [RS_9]
                                         PartitionCols:_col1
-                                        Select Operator [SEL_5] (rows=1 width=0)
+                                        Select Operator [SEL_5] (rows=144002668 width=135)
                                           Output:["_col0","_col1"]
-                                          Filter Operator [FIL_108] (rows=1 width=0)
+                                          Filter Operator [FIL_108] (rows=144002668 width=135)
                                             predicate:ws_order_number is not null
-                                            TableScan [TS_3] (rows=1 width=0)
-                                              default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
+                                            TableScan [TS_3] (rows=144002668 width=135)
+                                              default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
                                     <-Map 9 [SIMPLE_EDGE]
                                       SHUFFLE [RS_10]
                                         PartitionCols:_col1
-                                        Select Operator [SEL_8] (rows=1 width=0)
+                                        Select Operator [SEL_8] (rows=144002668 width=135)
                                           Output:["_col0","_col1"]
-                                          Filter Operator [FIL_109] (rows=1 width=0)
+                                          Filter Operator [FIL_109] (rows=144002668 width=135)
                                             predicate:ws_order_number is not null
-                                            TableScan [TS_6] (rows=1 width=0)
-                                              default@web_sales,ws1,Tbl:PARTIAL,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
+                                            TableScan [TS_6] (rows=144002668 width=135)
+                                              default@web_sales,ws1,Tbl:COMPLETE,Col:NONE,Output:["ws_warehouse_sk","ws_order_number"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query96.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query96.q.out b/ql/src/test/results/clientpositive/perf/query96.q.out
index b3a9652..8ffcbcb 100644
--- a/ql/src/test/results/clientpositive/perf/query96.q.out
+++ b/ql/src/test/results/clientpositive/perf/query96.q.out
@@ -29,7 +29,7 @@ Stage-0
                 SHUFFLE [RS_23]
                   Group By Operator [GBY_22] (rows=1 width=8)
                     Output:["_col0"],aggregations:["count()"]
-                    Merge Join Operator [MERGEJOIN_45] (rows=17424 width=471)
+                    Merge Join Operator [MERGEJOIN_45] (rows=766650239 width=88)
                       Conds:RS_18._col2=RS_19._col0(Inner)
                     <-Map 9 [SIMPLE_EDGE]
                       SHUFFLE [RS_19]
@@ -43,38 +43,38 @@ Stage-0
                     <-Reducer 3 [SIMPLE_EDGE]
                       SHUFFLE [RS_18]
                         PartitionCols:_col2
-                        Merge Join Operator [MERGEJOIN_44] (rows=15840 width=471)
-                          Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col2"]
+                        Merge Join Operator [MERGEJOIN_44] (rows=696954748 width=88)
+                          Conds:RS_15._col1=RS_16._col0(Inner),Output:["_col2"]
                         <-Map 8 [SIMPLE_EDGE]
                           SHUFFLE [RS_16]
                             PartitionCols:_col0
-                            Select Operator [SEL_8] (rows=14400 width=471)
+                            Select Operator [SEL_8] (rows=3600 width=107)
                               Output:["_col0"]
-                              Filter Operator [FIL_41] (rows=14400 width=471)
-                                predicate:((t_hour = 8) and (t_minute >= 30) and t_time_sk is not null)
-                                TableScan [TS_6] (rows=86400 width=471)
-                                  default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_hour","t_minute"]
+                              Filter Operator [FIL_41] (rows=3600 width=107)
+                                predicate:((hd_dep_count = 5) and hd_demo_sk is not null)
+                                TableScan [TS_6] (rows=7200 width=107)
+                                  default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
                         <-Reducer 2 [SIMPLE_EDGE]
                           SHUFFLE [RS_15]
-                            PartitionCols:_col0
-                            Merge Join Operator [MERGEJOIN_43] (rows=3960 width=107)
-                              Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col0","_col2"]
+                            PartitionCols:_col1
+                            Merge Join Operator [MERGEJOIN_43] (rows=633595212 width=88)
+                              Conds:RS_12._col0=RS_13._col0(Inner),Output:["_col1","_col2"]
                             <-Map 1 [SIMPLE_EDGE]
                               SHUFFLE [RS_12]
-                                PartitionCols:_col1
-                                Select Operator [SEL_2] (rows=1 width=0)
+                                PartitionCols:_col0
+                                Select Operator [SEL_2] (rows=575995635 width=88)
                                   Output:["_col0","_col1","_col2"]
-                                  Filter Operator [FIL_39] (rows=1 width=0)
+                                  Filter Operator [FIL_39] (rows=575995635 width=88)
                                     predicate:(ss_hdemo_sk is not null and ss_sold_time_sk is not null and ss_store_sk is not null)
-                                    TableScan [TS_0] (rows=1 width=0)
-                                      default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_time_sk","ss_hdemo_sk","ss_store_sk"]
+                                    TableScan [TS_0] (rows=575995635 width=88)
+                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_time_sk","ss_hdemo_sk","ss_store_sk"]
                             <-Map 7 [SIMPLE_EDGE]
                               SHUFFLE [RS_13]
                                 PartitionCols:_col0
-                                Select Operator [SEL_5] (rows=3600 width=107)
+                                Select Operator [SEL_5] (rows=14400 width=471)
                                   Output:["_col0"]
-                                  Filter Operator [FIL_40] (rows=3600 width=107)
-                                    predicate:((hd_dep_count = 5) and hd_demo_sk is not null)
-                                    TableScan [TS_3] (rows=7200 width=107)
-                                      default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
+                                  Filter Operator [FIL_40] (rows=14400 width=471)
+                                    predicate:((t_hour = 8) and (t_minute >= 30) and t_time_sk is not null)
+                                    TableScan [TS_3] (rows=86400 width=471)
+                                      default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_hour","t_minute"]
 


Mime
View raw message