hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [08/10] hive git commit: HIVE-12968 : genNotNullFilterForJoinSourcePlan: needs to merge predicates into the multi-AND (Gopal V, Ashutosh Chauhan via Jesus Camacho Rodriguez)
Date Sat, 09 Apr 2016 21:33:42 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query27.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query27.q.out b/ql/src/test/results/clientpositive/perf/query27.q.out
index 3a32d7b..865d62c 100644
--- a/ql/src/test/results/clientpositive/perf/query27.q.out
+++ b/ql/src/test/results/clientpositive/perf/query27.q.out
@@ -85,7 +85,7 @@ Stage-0
                                         Select Operator [SEL_2] (rows=1 width=0)
                                           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
                                           Filter Operator [FIL_50] (rows=1 width=0)
-                                            predicate:(((ss_cdemo_sk is not null and ss_sold_date_sk is not null) and ss_store_sk is not null) and ss_item_sk is not null)
+                                            predicate:(ss_cdemo_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null and ss_item_sk is not null)
                                             TableScan [TS_0] (rows=1 width=0)
                                               default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_cdemo_sk","ss_store_sk","ss_quantity","ss_list_price","ss_sales_price","ss_coupon_amt"]
                                     <-Map 8 [SIMPLE_EDGE]
@@ -94,7 +94,7 @@ Stage-0
                                         Select Operator [SEL_5] (rows=2475 width=362)
                                           Output:["_col0"]
                                           Filter Operator [FIL_51] (rows=2475 width=362)
-                                            predicate:((((cd_gender = 'F') and (cd_marital_status = 'D')) and (cd_education_status = 'Unknown')) and cd_demo_sk is not null)
+                                            predicate:((cd_gender = 'F') and (cd_marital_status = 'D') and (cd_education_status = 'Unknown') and cd_demo_sk is not null)
                                             TableScan [TS_3] (rows=19800 width=362)
                                               default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_gender","cd_marital_status","cd_education_status"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query29.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query29.q.out b/ql/src/test/results/clientpositive/perf/query29.q.out
index 299f16e..0f4116a 100644
--- a/ql/src/test/results/clientpositive/perf/query29.q.out
+++ b/ql/src/test/results/clientpositive/perf/query29.q.out
@@ -88,7 +88,7 @@ Stage-0
                                         Select Operator [SEL_14] (rows=18262 width=1119)
                                           Output:["_col0"]
                                           Filter Operator [FIL_93] (rows=18262 width=1119)
-                                            predicate:((d_moy BETWEEN 2 AND 5 and (d_year = 2000)) and d_date_sk is not null)
+                                            predicate:(d_moy BETWEEN 2 AND 5 and (d_year = 2000) and d_date_sk is not null)
                                             TableScan [TS_12] (rows=73049 width=1119)
                                               default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                                     <-Reducer 4 [SIMPLE_EDGE]
@@ -102,7 +102,7 @@ Stage-0
                                             Select Operator [SEL_11] (rows=18262 width=1119)
                                               Output:["_col0"]
                                               Filter Operator [FIL_92] (rows=18262 width=1119)
-                                                predicate:(((d_moy = 2) and (d_year = 2000)) and d_date_sk is not null)
+                                                predicate:((d_moy = 2) and (d_year = 2000) and d_date_sk is not null)
                                                 TableScan [TS_9] (rows=73049 width=1119)
                                                   default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                                         <-Reducer 3 [SIMPLE_EDGE]
@@ -116,7 +116,7 @@ Stage-0
                                                 Select Operator [SEL_8] (rows=1 width=0)
                                                   Output:["_col0","_col1","_col2","_col3"]
                                                   Filter Operator [FIL_91] (rows=1 width=0)
-                                                    predicate:((cs_bill_customer_sk is not null and cs_item_sk is not null) and cs_sold_date_sk is not null)
+                                                    predicate:(cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
                                                     TableScan [TS_6] (rows=1 width=0)
                                                       default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk","cs_quantity"]
                                             <-Reducer 2 [SIMPLE_EDGE]
@@ -130,7 +130,7 @@ Stage-0
                                                     Select Operator [SEL_2] (rows=1 width=0)
                                                       Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
                                                       Filter Operator [FIL_89] (rows=1 width=0)
-                                                        predicate:((((ss_item_sk is not null and ss_customer_sk is not null) and ss_ticket_number is not null) and ss_sold_date_sk is not null) and ss_store_sk is not null)
+                                                        predicate:(ss_item_sk is not null and ss_customer_sk is not null and ss_ticket_number is not null and ss_sold_date_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_date_sk","ss_item_sk","ss_customer_sk","ss_store_sk","ss_ticket_number","ss_quantity"]
                                                 <-Map 11 [SIMPLE_EDGE]
@@ -139,7 +139,7 @@ Stage-0
                                                     Select Operator [SEL_5] (rows=1 width=0)
                                                       Output:["_col0","_col1","_col2","_col3","_col4"]
                                                       Filter Operator [FIL_90] (rows=1 width=0)
-                                                        predicate:(((sr_item_sk is not null and sr_customer_sk is not null) and sr_ticket_number is not null) and sr_returned_date_sk is not null)
+                                                        predicate:(sr_item_sk is not null and sr_customer_sk is not null and sr_ticket_number is not null and sr_returned_date_sk is not null)
                                                         TableScan [TS_3] (rows=1 width=0)
                                                           default@store_returns,store_returns,Tbl:PARTIAL,Col:NONE,Output:["sr_returned_date_sk","sr_item_sk","sr_customer_sk","sr_ticket_number","sr_return_quantity"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query31.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query31.q.out b/ql/src/test/results/clientpositive/perf/query31.q.out
index a3c47a5..3cb7079 100644
--- a/ql/src/test/results/clientpositive/perf/query31.q.out
+++ b/ql/src/test/results/clientpositive/perf/query31.q.out
@@ -88,7 +88,7 @@ Stage-0
                                       Select Operator [SEL_118] (rows=18262 width=1119)
                                         Output:["_col0"]
                                         Filter Operator [FIL_266] (rows=18262 width=1119)
-                                          predicate:(((d_qoy = 3) and (d_year = 1998)) and d_date_sk is not null)
+                                          predicate:((d_qoy = 3) and (d_year = 1998) and d_date_sk is not null)
                                           TableScan [TS_116] (rows=73049 width=1119)
                                             default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_qoy"]
                 <-Reducer 5 [SIMPLE_EDGE]
@@ -145,7 +145,7 @@ Stage-0
                                               Select Operator [SEL_26] (rows=18262 width=1119)
                                                 Output:["_col0"]
                                                 Filter Operator [FIL_254] (rows=18262 width=1119)
-                                                  predicate:(((d_qoy = 2) and (d_year = 1998)) and d_date_sk is not null)
+                                                  predicate:((d_qoy = 2) and (d_year = 1998) and d_date_sk is not null)
                                                   TableScan [TS_24] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_qoy"]
                         <-Reducer 19 [SIMPLE_EDGE]
@@ -193,7 +193,7 @@ Stage-0
                                               Select Operator [SEL_47] (rows=18262 width=1119)
                                                 Output:["_col0"]
                                                 Filter Operator [FIL_257] (rows=18262 width=1119)
-                                                  predicate:(((d_qoy = 3) and (d_year = 1998)) and d_date_sk is not null)
+                                                  predicate:((d_qoy = 3) and (d_year = 1998) and d_date_sk is not null)
                                                   TableScan [TS_45] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_qoy"]
                         <-Reducer 25 [SIMPLE_EDGE]
@@ -241,7 +241,7 @@ Stage-0
                                               Select Operator [SEL_68] (rows=18262 width=1119)
                                                 Output:["_col0"]
                                                 Filter Operator [FIL_260] (rows=18262 width=1119)
-                                                  predicate:(((d_qoy = 1) and (d_year = 1998)) and d_date_sk is not null)
+                                                  predicate:((d_qoy = 1) and (d_year = 1998) and d_date_sk is not null)
                                                   TableScan [TS_66] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_qoy"]
                         <-Reducer 31 [SIMPLE_EDGE]
@@ -289,7 +289,7 @@ Stage-0
                                               Select Operator [SEL_89] (rows=18262 width=1119)
                                                 Output:["_col0"]
                                                 Filter Operator [FIL_263] (rows=18262 width=1119)
-                                                  predicate:(((d_qoy = 2) and (d_year = 1998)) and d_date_sk is not null)
+                                                  predicate:((d_qoy = 2) and (d_year = 1998) and d_date_sk is not null)
                                                   TableScan [TS_87] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_qoy"]
                         <-Reducer 4 [SIMPLE_EDGE]
@@ -337,7 +337,7 @@ Stage-0
                                               Select Operator [SEL_5] (rows=18262 width=1119)
                                                 Output:["_col0"]
                                                 Filter Operator [FIL_251] (rows=18262 width=1119)
-                                                  predicate:(((d_qoy = 1) and (d_year = 1998)) and d_date_sk is not null)
+                                                  predicate:((d_qoy = 1) and (d_year = 1998) and d_date_sk is not null)
                                                   TableScan [TS_3] (rows=73049 width=1119)
                                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_qoy"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query34.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query34.q.out b/ql/src/test/results/clientpositive/perf/query34.q.out
index a08c3ff..0586813 100644
--- a/ql/src/test/results/clientpositive/perf/query34.q.out
+++ b/ql/src/test/results/clientpositive/perf/query34.q.out
@@ -57,7 +57,7 @@ Stage-0
                                 Select Operator [SEL_11] (rows=1200 width=107)
                                   Output:["_col0"]
                                   Filter Operator [FIL_55] (rows=1200 width=107)
-                                    predicate:(((((hd_buy_potential = '1001-5000') or (hd_buy_potential = '5001-10000')) and (hd_vehicle_count > 0)) and CASE WHEN ((hd_vehicle_count > 0)) THEN (((UDFToDouble(hd_dep_count) / UDFToDouble(hd_vehicle_count)) > 1.2)) ELSE (null) END) and hd_demo_sk is not null)
+                                    predicate:(((hd_buy_potential = '1001-5000') or (hd_buy_potential = '5001-10000')) and (hd_vehicle_count > 0) and CASE WHEN ((hd_vehicle_count > 0)) THEN (((UDFToDouble(hd_dep_count) / UDFToDouble(hd_vehicle_count)) > 1.2)) ELSE (null) END 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_buy_potential","hd_dep_count","hd_vehicle_count"]
                             <-Reducer 3 [SIMPLE_EDGE]
@@ -85,7 +85,7 @@ Stage-0
                                         Select Operator [SEL_2] (rows=1 width=0)
                                           Output:["_col0","_col1","_col2","_col3","_col4"]
                                           Filter Operator [FIL_52] (rows=1 width=0)
-                                            predicate:(((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_hdemo_sk is not null) and ss_customer_sk is not null)
+                                            predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_hdemo_sk is not null and ss_customer_sk is not null)
                                             TableScan [TS_0] (rows=1 width=0)
                                               default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_hdemo_sk","ss_store_sk","ss_ticket_number"]
                                     <-Map 8 [SIMPLE_EDGE]
@@ -94,7 +94,7 @@ Stage-0
                                         Select Operator [SEL_5] (rows=36524 width=1119)
                                           Output:["_col0"]
                                           Filter Operator [FIL_53] (rows=36524 width=1119)
-                                            predicate:(((d_year) IN (1998, 1999, 2000) and (d_dom BETWEEN 1 AND 3 or d_dom BETWEEN 25 AND 28)) and d_date_sk is not null)
+                                            predicate:((d_year) IN (1998, 1999, 2000) and (d_dom BETWEEN 1 AND 3 or d_dom BETWEEN 25 AND 28) and d_date_sk is not null)
                                             TableScan [TS_3] (rows=73049 width=1119)
                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query39.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query39.q.out b/ql/src/test/results/clientpositive/perf/query39.q.out
index fb77c7e..52c6b7c 100644
--- a/ql/src/test/results/clientpositive/perf/query39.q.out
+++ b/ql/src/test/results/clientpositive/perf/query39.q.out
@@ -56,7 +56,7 @@ Stage-0
                                     Select Operator [SEL_39] (rows=18262 width=1119)
                                       Output:["_col0"]
                                       Filter Operator [FIL_96] (rows=18262 width=1119)
-                                        predicate:(((d_year = 1999) and (d_moy = 4)) and d_date_sk is not null)
+                                        predicate:((d_year = 1999) and (d_moy = 4) and d_date_sk is not null)
                                         TableScan [TS_37] (rows=73049 width=1119)
                                           default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                                 <-Reducer 13 [SIMPLE_EDGE]
@@ -84,7 +84,7 @@ Stage-0
                                             Select Operator [SEL_30] (rows=1 width=0)
                                               Output:["_col0","_col1","_col2","_col3"]
                                               Filter Operator [FIL_93] (rows=1 width=0)
-                                                predicate:((inv_item_sk is not null and inv_warehouse_sk is not null) and inv_date_sk is not null)
+                                                predicate:(inv_item_sk is not null and inv_warehouse_sk is not null and inv_date_sk is not null)
                                                 TableScan [TS_28] (rows=1 width=0)
                                                   default@inventory,inventory,Tbl:PARTIAL,Col:NONE,Output:["inv_date_sk","inv_item_sk","inv_warehouse_sk","inv_quantity_on_hand"]
                                         <-Map 16 [SIMPLE_EDGE]
@@ -122,7 +122,7 @@ Stage-0
                                     Select Operator [SEL_11] (rows=18262 width=1119)
                                       Output:["_col0"]
                                       Filter Operator [FIL_92] (rows=18262 width=1119)
-                                        predicate:(((d_year = 1999) and (d_moy = 3)) and d_date_sk is not null)
+                                        predicate:((d_year = 1999) and (d_moy = 3) 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"]
                                 <-Reducer 3 [SIMPLE_EDGE]
@@ -150,7 +150,7 @@ Stage-0
                                             Select Operator [SEL_2] (rows=1 width=0)
                                               Output:["_col0","_col1","_col2","_col3"]
                                               Filter Operator [FIL_89] (rows=1 width=0)
-                                                predicate:((inv_item_sk is not null and inv_warehouse_sk is not null) and inv_date_sk is not null)
+                                                predicate:(inv_item_sk is not null and inv_warehouse_sk is not null and inv_date_sk is not null)
                                                 TableScan [TS_0] (rows=1 width=0)
                                                   default@inventory,inventory,Tbl:PARTIAL,Col:NONE,Output:["inv_date_sk","inv_item_sk","inv_warehouse_sk","inv_quantity_on_hand"]
                                         <-Map 8 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query40.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query40.q.out b/ql/src/test/results/clientpositive/perf/query40.q.out
index 5e2ad72..34ceb71 100644
--- a/ql/src/test/results/clientpositive/perf/query40.q.out
+++ b/ql/src/test/results/clientpositive/perf/query40.q.out
@@ -83,7 +83,7 @@ Stage-0
                                       Select Operator [SEL_2] (rows=1 width=0)
                                         Output:["_col0","_col1","_col2","_col3","_col4"]
                                         Filter Operator [FIL_50] (rows=1 width=0)
-                                          predicate:((cs_warehouse_sk is not null and cs_item_sk is not null) and cs_sold_date_sk is not null)
+                                          predicate:(cs_warehouse_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
                                           TableScan [TS_0] (rows=1 width=0)
                                             default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_warehouse_sk","cs_item_sk","cs_order_number","cs_sales_price"]
                                   <-Map 8 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query42.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query42.q.out b/ql/src/test/results/clientpositive/perf/query42.q.out
index 28d11df..1640d4e 100644
--- a/ql/src/test/results/clientpositive/perf/query42.q.out
+++ b/ql/src/test/results/clientpositive/perf/query42.q.out
@@ -55,7 +55,7 @@ Stage-0
                                 Select Operator [SEL_2] (rows=18262 width=1119)
                                   Output:["_col0"]
                                   Filter Operator [FIL_30] (rows=18262 width=1119)
-                                    predicate:(((d_moy = 12) and (d_year = 1998)) and d_date_sk is not null)
+                                    predicate:((d_moy = 12) and (d_year = 1998) and d_date_sk is not null)
                                     TableScan [TS_0] (rows=73049 width=1119)
                                       default@date_dim,dt,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                             <-Map 6 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query45.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query45.q.out b/ql/src/test/results/clientpositive/perf/query45.q.out
index 2985ba9..17bc5ee 100644
--- a/ql/src/test/results/clientpositive/perf/query45.q.out
+++ b/ql/src/test/results/clientpositive/perf/query45.q.out
@@ -74,7 +74,7 @@ Stage-0
                                 Select Operator [SEL_11] (rows=18262 width=1119)
                                   Output:["_col0"]
                                   Filter Operator [FIL_65] (rows=18262 width=1119)
-                                    predicate:(((d_qoy = 2) and (d_year = 2000)) and d_date_sk is not null)
+                                    predicate:((d_qoy = 2) and (d_year = 2000) 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_qoy"]
                             <-Reducer 3 [SIMPLE_EDGE]
@@ -102,7 +102,7 @@ Stage-0
                                         Select Operator [SEL_2] (rows=1 width=0)
                                           Output:["_col0","_col1","_col2","_col3"]
                                           Filter Operator [FIL_62] (rows=1 width=0)
-                                            predicate:((ws_bill_customer_sk is not null and ws_sold_date_sk is not null) and ws_item_sk is not null)
+                                            predicate:(ws_bill_customer_sk is not null and ws_sold_date_sk is not null and ws_item_sk is not null)
                                             TableScan [TS_0] (rows=1 width=0)
                                               default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_bill_customer_sk","ws_sales_price"]
                                     <-Map 8 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query46.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query46.q.out b/ql/src/test/results/clientpositive/perf/query46.q.out
index 62d7e21..2bd87aa 100644
--- a/ql/src/test/results/clientpositive/perf/query46.q.out
+++ b/ql/src/test/results/clientpositive/perf/query46.q.out
@@ -119,7 +119,7 @@ Stage-0
                                                     Select Operator [SEL_2] (rows=1 width=0)
                                                       Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
                                                       Filter Operator [FIL_78] (rows=1 width=0)
-                                                        predicate:((((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_hdemo_sk is not null) and ss_addr_sk is not null) and ss_customer_sk is not null)
+                                                        predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_hdemo_sk is not null and ss_addr_sk is not null and ss_customer_sk is not null)
                                                         TableScan [TS_0] (rows=1 width=0)
                                                           default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_ticket_number","ss_coupon_amt","ss_net_profit"]
                                                 <-Map 10 [SIMPLE_EDGE]
@@ -128,7 +128,7 @@ Stage-0
                                                     Select Operator [SEL_5] (rows=18262 width=1119)
                                                       Output:["_col0"]
                                                       Filter Operator [FIL_79] (rows=18262 width=1119)
-                                                        predicate:(((d_dow) IN (6, 0) and (d_year) IN (1998, 1999, 2000)) and d_date_sk is not null)
+                                                        predicate:((d_dow) IN (6, 0) and (d_year) IN (1998, 1999, 2000) and d_date_sk is not null)
                                                         TableScan [TS_3] (rows=73049 width=1119)
                                                           default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dow"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query48.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query48.q.out b/ql/src/test/results/clientpositive/perf/query48.q.out
index d536bb5..d93fc07 100644
--- a/ql/src/test/results/clientpositive/perf/query48.q.out
+++ b/ql/src/test/results/clientpositive/perf/query48.q.out
@@ -49,7 +49,7 @@ Stage-0
                           Select Operator [SEL_11] (rows=10000000 width=1014)
                             Output:["_col0","_col1"]
                             Filter Operator [FIL_52] (rows=10000000 width=1014)
-                              predicate:(((ca_state) IN ('KY', 'GA', 'NM', 'MT', 'OR', 'IN', 'WI', 'MO', 'WV') and (ca_country = 'United States')) and ca_address_sk is not null)
+                              predicate:((ca_state) IN ('KY', 'GA', 'NM', 'MT', 'OR', 'IN', 'WI', 'MO', 'WV') and (ca_country = 'United States') and ca_address_sk is not null)
                               TableScan [TS_9] (rows=40000000 width=1014)
                                 default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state","ca_country"]
                       <-Reducer 3 [SIMPLE_EDGE]
@@ -63,7 +63,7 @@ Stage-0
                               Select Operator [SEL_8] (rows=4950 width=362)
                                 Output:["_col0"]
                                 Filter Operator [FIL_51] (rows=4950 width=362)
-                                  predicate:(((cd_marital_status = 'M') and (cd_education_status = '4 yr Degree')) and cd_demo_sk is not null)
+                                  predicate:((cd_marital_status = 'M') and (cd_education_status = '4 yr Degree') and cd_demo_sk is not null)
                                   TableScan [TS_6] (rows=19800 width=362)
                                     default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status","cd_education_status"]
                           <-Reducer 2 [SIMPLE_EDGE]
@@ -77,7 +77,7 @@ Stage-0
                                   Select Operator [SEL_2] (rows=1 width=0)
                                     Output:["_col0","_col1","_col2","_col3","_col4","_col6"]
                                     Filter Operator [FIL_49] (rows=1 width=0)
-                                      predicate:((((((ss_sales_price BETWEEN 100.0 AND 150.0 or ss_sales_price BETWEEN 50.0 AND 100.0 or ss_sales_price BETWEEN 150.0 AND 200.0) and (ss_net_profit BETWEEN 0 AND 2000 or ss_net_profit BETWEEN 150 AND 3000 or ss_net_profit BETWEEN 50 AND 25000)) and ss_store_sk is not null) and ss_cdemo_sk is not null) and ss_addr_sk is not null) and ss_sold_date_sk is not null)
+                                      predicate:((ss_sales_price BETWEEN 100.0 AND 150.0 or ss_sales_price BETWEEN 50.0 AND 100.0 or ss_sales_price BETWEEN 150.0 AND 200.0) and (ss_net_profit BETWEEN 0 AND 2000 or ss_net_profit BETWEEN 150 AND 3000 or ss_net_profit BETWEEN 50 AND 25000) and ss_store_sk is not null and ss_cdemo_sk is not null and ss_addr_sk is not null and ss_sold_date_sk is not null)
                                       TableScan [TS_0] (rows=1 width=0)
                                         default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_cdemo_sk","ss_addr_sk","ss_store_sk","ss_quantity","ss_sales_price","ss_net_profit"]
                               <-Map 7 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query50.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query50.q.out b/ql/src/test/results/clientpositive/perf/query50.q.out
index 4445e98..e6ba451 100644
--- a/ql/src/test/results/clientpositive/perf/query50.q.out
+++ b/ql/src/test/results/clientpositive/perf/query50.q.out
@@ -153,7 +153,7 @@ Stage-0
                           Select Operator [SEL_14] (rows=18262 width=1119)
                             Output:["_col0"]
                             Filter Operator [FIL_55] (rows=18262 width=1119)
-                              predicate:(((d_year = 2000) and (d_moy = 9)) and d_date_sk is not null)
+                              predicate:((d_year = 2000) and (d_moy = 9) and d_date_sk is not null)
                               TableScan [TS_12] (rows=73049 width=1119)
                                 default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                       <-Reducer 4 [SIMPLE_EDGE]
@@ -195,7 +195,7 @@ Stage-0
                                       Select Operator [SEL_2] (rows=1 width=0)
                                         Output:["_col0","_col1","_col2","_col3","_col4"]
                                         Filter Operator [FIL_51] (rows=1 width=0)
-                                          predicate:((((ss_item_sk is not null and ss_customer_sk is not null) and ss_ticket_number is not null) and ss_store_sk is not null) and ss_sold_date_sk is not null)
+                                          predicate:(ss_item_sk is not null and ss_customer_sk is not null and ss_ticket_number is not null and ss_store_sk is not null and ss_sold_date_sk is not null)
                                           TableScan [TS_0] (rows=1 width=0)
                                             default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk","ss_store_sk","ss_ticket_number"]
                                   <-Map 8 [SIMPLE_EDGE]
@@ -204,7 +204,7 @@ Stage-0
                                       Select Operator [SEL_5] (rows=1 width=0)
                                         Output:["_col0","_col1","_col2","_col3"]
                                         Filter Operator [FIL_52] (rows=1 width=0)
-                                          predicate:(((sr_item_sk is not null and sr_customer_sk is not null) and sr_ticket_number is not null) and sr_returned_date_sk is not null)
+                                          predicate:(sr_item_sk is not null and sr_customer_sk is not null and sr_ticket_number is not null and sr_returned_date_sk is not null)
                                           TableScan [TS_3] (rows=1 width=0)
                                             default@store_returns,store_returns,Tbl:PARTIAL,Col:NONE,Output:["sr_returned_date_sk","sr_item_sk","sr_customer_sk","sr_ticket_number"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query52.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query52.q.out b/ql/src/test/results/clientpositive/perf/query52.q.out
index f5bc52b..7bf7317 100644
--- a/ql/src/test/results/clientpositive/perf/query52.q.out
+++ b/ql/src/test/results/clientpositive/perf/query52.q.out
@@ -55,7 +55,7 @@ Stage-0
                                 Select Operator [SEL_2] (rows=18262 width=1119)
                                   Output:["_col0"]
                                   Filter Operator [FIL_30] (rows=18262 width=1119)
-                                    predicate:(((d_moy = 12) and (d_year = 1998)) and d_date_sk is not null)
+                                    predicate:((d_moy = 12) and (d_year = 1998) and d_date_sk is not null)
                                     TableScan [TS_0] (rows=73049 width=1119)
                                       default@date_dim,dt,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                             <-Map 6 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query54.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query54.q.out b/ql/src/test/results/clientpositive/perf/query54.q.out
index 9a0e9b4..3edf749 100644
--- a/ql/src/test/results/clientpositive/perf/query54.q.out
+++ b/ql/src/test/results/clientpositive/perf/query54.q.out
@@ -85,7 +85,7 @@ Stage-0
                                           Select Operator [SEL_36] (rows=40000000 width=1014)
                                             Output:["_col0","_col1","_col2"]
                                             Filter Operator [FIL_117] (rows=40000000 width=1014)
-                                              predicate:((ca_address_sk is not null and ca_county is not null) and ca_state is not null)
+                                              predicate:(ca_address_sk is not null and ca_county is not null and ca_state is not null)
                                               TableScan [TS_34] (rows=40000000 width=1014)
                                                 default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_county","ca_state"]
                                       <-Reducer 7 [SIMPLE_EDGE]
@@ -134,7 +134,7 @@ Stage-0
                                                             Select Operator [SEL_13] (rows=18262 width=1119)
                                                               Output:["_col0"]
                                                               Filter Operator [FIL_114] (rows=18262 width=1119)
-                                                                predicate:(((d_moy = 3) and (d_year = 2000)) and d_date_sk is not null)
+                                                                predicate:((d_moy = 3) and (d_year = 2000) and d_date_sk is not null)
                                                                 TableScan [TS_11] (rows=73049 width=1119)
                                                                   default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                                                         <-Reducer 3 [SIMPLE_EDGE]
@@ -148,7 +148,7 @@ Stage-0
                                                                 Select Operator [SEL_10] (rows=115500 width=1436)
                                                                   Output:["_col0"]
                                                                   Filter Operator [FIL_113] (rows=115500 width=1436)
-                                                                    predicate:(((i_category = 'Jewelry') and (i_class = 'football')) and i_item_sk is not null)
+                                                                    predicate:((i_category = 'Jewelry') and (i_class = 'football') and i_item_sk is not null)
                                                                     TableScan [TS_8] (rows=462000 width=1436)
                                                                       default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_class","i_category"]
                                                             <-Union 2 [SIMPLE_EDGE]
@@ -158,7 +158,7 @@ Stage-0
                                                                   Select Operator [SEL_2] (rows=1 width=0)
                                                                     Output:["_col0","_col1","_col2"]
                                                                     Filter Operator [FIL_111] (rows=1 width=0)
-                                                                      predicate:((cs_item_sk is not null and cs_sold_date_sk is not null) and cs_bill_customer_sk is not null)
+                                                                      predicate:(cs_item_sk is not null and cs_sold_date_sk is not null and cs_bill_customer_sk is not null)
                                                                       TableScan [TS_0] (rows=1 width=0)
                                                                         Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk"]
                                                               <-Map 14 [CONTAINS]
@@ -167,7 +167,7 @@ Stage-0
                                                                   Select Operator [SEL_5] (rows=1 width=0)
                                                                     Output:["_col0","_col1","_col2"]
                                                                     Filter Operator [FIL_112] (rows=1 width=0)
-                                                                      predicate:((ws_item_sk is not null and ws_sold_date_sk is not null) and ws_bill_customer_sk is not null)
+                                                                      predicate:(ws_item_sk is not null and ws_sold_date_sk is not null and ws_bill_customer_sk is not null)
                                                                       TableScan [TS_3] (rows=1 width=0)
                                                                         Output:["ws_sold_date_sk","ws_item_sk","ws_bill_customer_sk"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query55.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query55.q.out b/ql/src/test/results/clientpositive/perf/query55.q.out
index 91d0c72..a9044c1 100644
--- a/ql/src/test/results/clientpositive/perf/query55.q.out
+++ b/ql/src/test/results/clientpositive/perf/query55.q.out
@@ -53,7 +53,7 @@ Stage-0
                               Select Operator [SEL_2] (rows=18262 width=1119)
                                 Output:["_col0"]
                                 Filter Operator [FIL_30] (rows=18262 width=1119)
-                                  predicate:(((d_moy = 12) and (d_year = 2001)) and d_date_sk is not null)
+                                  predicate:((d_moy = 12) and (d_year = 2001) and d_date_sk is not null)
                                   TableScan [TS_0] (rows=73049 width=1119)
                                     default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                           <-Map 6 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query64.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query64.q.out b/ql/src/test/results/clientpositive/perf/query64.q.out
index dddcc80..ff81523 100644
--- a/ql/src/test/results/clientpositive/perf/query64.q.out
+++ b/ql/src/test/results/clientpositive/perf/query64.q.out
@@ -84,7 +84,7 @@ Stage-0
                                   Select Operator [SEL_76] (rows=57750 width=1436)
                                     Output:["_col0","_col3"]
                                     Filter Operator [FIL_660] (rows=57750 width=1436)
-                                      predicate:((((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND 45) and i_current_price BETWEEN 36 AND 50) and i_item_sk is not null)
+                                      predicate:((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND 45 and i_current_price BETWEEN 36 AND 50 and i_item_sk is not null)
                                       TableScan [TS_74] (rows=462000 width=1436)
                                         default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_current_price","i_color","i_product_name"]
                               <-Reducer 16 [SIMPLE_EDGE]
@@ -228,7 +228,7 @@ Stage-0
                                                                               Select Operator [SEL_20] (rows=1704 width=1910)
                                                                                 Output:["_col0","_col1","_col2"]
                                                                                 Filter Operator [FIL_650] (rows=1704 width=1910)
-                                                                                  predicate:((s_store_sk is not null and s_store_name is not null) and s_zip is not null)
+                                                                                  predicate:(s_store_sk is not null and s_store_name is not null and s_zip is not null)
                                                                                   TableScan [TS_18] (rows=1704 width=1910)
                                                                                     default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_store_name","s_zip"]
                                                                           <-Reducer 6 [SIMPLE_EDGE]
@@ -284,7 +284,7 @@ Stage-0
                                                                                               Select Operator [SEL_8] (rows=80000000 width=860)
                                                                                                 Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
                                                                                                 Filter Operator [FIL_646] (rows=80000000 width=860)
-                                                                                                  predicate:(((((c_customer_sk is not null and c_first_sales_date_sk is not null) and c_first_shipto_date_sk is not null) and c_current_cdemo_sk is not null) and c_current_hdemo_sk is not null) and c_current_addr_sk is not null)
+                                                                                                  predicate:(c_customer_sk is not null and c_first_sales_date_sk is not null and c_first_shipto_date_sk is not null and c_current_cdemo_sk is not null and c_current_hdemo_sk is not null and c_current_addr_sk is not null)
                                                                                                   TableScan [TS_6] (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","c_first_shipto_date_sk","c_first_sales_date_sk"]
                                                                                           <-Reducer 2 [SIMPLE_EDGE]
@@ -298,7 +298,7 @@ Stage-0
                                                                                                   Select Operator [SEL_2] (rows=1 width=0)
                                                                                                     Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
                                                                                                     Filter Operator [FIL_644] (rows=1 width=0)
-                                                                                                      predicate:((((((((ss_item_sk is not null and ss_ticket_number is not null) and ss_customer_sk is not null) and ss_sold_date_sk is not null) and ss_store_sk is not null) and ss_cdemo_sk is not null) and ss_promo_sk is not null) and ss_hdemo_sk is not null) and ss_addr_sk is not null)
+                                                                                                      predicate:(ss_item_sk is not null and ss_ticket_number is not null and ss_customer_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null and ss_cdemo_sk is not null and ss_promo_sk is not null and ss_hdemo_sk is not null and ss_addr_sk is not null)
                                                                                                       TableScan [TS_0] (rows=1 width=0)
                                                                                                         default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk","ss_cdemo_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_promo_sk","ss_ticket_number","ss_wholesale_cost","ss_list_price","ss_coupon_amt"]
                                                                                               <-Map 21 [SIMPLE_EDGE]
@@ -368,7 +368,7 @@ Stage-0
                                   Select Operator [SEL_200] (rows=57750 width=1436)
                                     Output:["_col0","_col3"]
                                     Filter Operator [FIL_679] (rows=57750 width=1436)
-                                      predicate:((((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND 45) and i_current_price BETWEEN 36 AND 50) and i_item_sk is not null)
+                                      predicate:((i_color) IN ('maroon', 'burnished', 'dim', 'steel', 'navajo', 'chocolate') and i_current_price BETWEEN 35 AND 45 and i_current_price BETWEEN 36 AND 50 and i_item_sk is not null)
                                       TableScan [TS_198] (rows=462000 width=1436)
                                         default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_current_price","i_color","i_product_name"]
                               <-Reducer 56 [SIMPLE_EDGE]
@@ -512,7 +512,7 @@ Stage-0
                                                                               Select Operator [SEL_144] (rows=1704 width=1910)
                                                                                 Output:["_col0","_col1","_col2"]
                                                                                 Filter Operator [FIL_669] (rows=1704 width=1910)
-                                                                                  predicate:((s_store_sk is not null and s_store_name is not null) and s_zip is not null)
+                                                                                  predicate:(s_store_sk is not null and s_store_name is not null and s_zip is not null)
                                                                                   TableScan [TS_142] (rows=1704 width=1910)
                                                                                     default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_store_name","s_zip"]
                                                                           <-Reducer 46 [SIMPLE_EDGE]
@@ -568,7 +568,7 @@ Stage-0
                                                                                               Select Operator [SEL_132] (rows=80000000 width=860)
                                                                                                 Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
                                                                                                 Filter Operator [FIL_665] (rows=80000000 width=860)
-                                                                                                  predicate:(((((c_customer_sk is not null and c_first_sales_date_sk is not null) and c_first_shipto_date_sk is not null) and c_current_cdemo_sk is not null) and c_current_hdemo_sk is not null) and c_current_addr_sk is not null)
+                                                                                                  predicate:(c_customer_sk is not null and c_first_sales_date_sk is not null and c_first_shipto_date_sk is not null and c_current_cdemo_sk is not null and c_current_hdemo_sk is not null and c_current_addr_sk is not null)
                                                                                                   TableScan [TS_130] (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","c_first_shipto_date_sk","c_first_sales_date_sk"]
                                                                                           <-Reducer 42 [SIMPLE_EDGE]
@@ -582,7 +582,7 @@ Stage-0
                                                                                                   Select Operator [SEL_126] (rows=1 width=0)
                                                                                                     Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
                                                                                                     Filter Operator [FIL_663] (rows=1 width=0)
-                                                                                                      predicate:((((((((ss_item_sk is not null and ss_ticket_number is not null) and ss_customer_sk is not null) and ss_sold_date_sk is not null) and ss_store_sk is not null) and ss_cdemo_sk is not null) and ss_promo_sk is not null) and ss_hdemo_sk is not null) and ss_addr_sk is not null)
+                                                                                                      predicate:(ss_item_sk is not null and ss_ticket_number is not null and ss_customer_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null and ss_cdemo_sk is not null and ss_promo_sk is not null and ss_hdemo_sk is not null and ss_addr_sk is not null)
                                                                                                       TableScan [TS_124] (rows=1 width=0)
                                                                                                         default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk","ss_cdemo_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_promo_sk","ss_ticket_number","ss_wholesale_cost","ss_list_price","ss_coupon_amt"]
                                                                                               <-Map 59 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query65.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query65.q.out b/ql/src/test/results/clientpositive/perf/query65.q.out
index 37bb1b3..9673373 100644
--- a/ql/src/test/results/clientpositive/perf/query65.q.out
+++ b/ql/src/test/results/clientpositive/perf/query65.q.out
@@ -125,7 +125,7 @@ Stage-0
                                   Select Operator [SEL_27] (rows=1 width=0)
                                     Output:["_col0","_col1","_col2","_col3"]
                                     Filter Operator [FIL_68] (rows=1 width=0)
-                                      predicate:((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_item_sk is not null)
+                                      predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_item_sk is not null)
                                       TableScan [TS_25] (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"]
                               <-Map 14 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query66.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query66.q.out b/ql/src/test/results/clientpositive/perf/query66.q.out
index 4127631..d698602 100644
--- a/ql/src/test/results/clientpositive/perf/query66.q.out
+++ b/ql/src/test/results/clientpositive/perf/query66.q.out
@@ -535,7 +535,7 @@ Stage-0
                                                   Select Operator [SEL_35] (rows=1 width=0)
                                                     Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
                                                     Filter Operator [FIL_110] (rows=1 width=0)
-                                                      predicate:(((cs_warehouse_sk is not null and cs_sold_date_sk is not null) and cs_sold_time_sk is not null) and cs_ship_mode_sk is not null)
+                                                      predicate:(cs_warehouse_sk is not null and cs_sold_date_sk is not null and cs_sold_time_sk is not null and cs_ship_mode_sk is not null)
                                                       TableScan [TS_33] (rows=1 width=0)
                                                         default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_sold_time_sk","cs_ship_mode_sk","cs_warehouse_sk","cs_quantity","cs_ext_sales_price","cs_net_paid_inc_ship_tax"]
                                               <-Map 20 [SIMPLE_EDGE]
@@ -615,7 +615,7 @@ Stage-0
                                                   Select Operator [SEL_2] (rows=1 width=0)
                                                     Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
                                                     Filter Operator [FIL_105] (rows=1 width=0)
-                                                      predicate:(((ws_warehouse_sk is not null and ws_sold_date_sk is not null) and ws_sold_time_sk is not null) and ws_ship_mode_sk is not null)
+                                                      predicate:(ws_warehouse_sk is not null and ws_sold_date_sk is not null and ws_sold_time_sk is not null and ws_ship_mode_sk is not null)
                                                       TableScan [TS_0] (rows=1 width=0)
                                                         default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_date_sk","ws_sold_time_sk","ws_ship_mode_sk","ws_warehouse_sk","ws_quantity","ws_sales_price","ws_net_paid_inc_tax"]
                                               <-Map 10 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query67.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query67.q.out b/ql/src/test/results/clientpositive/perf/query67.q.out
index 83dab38..4a1e7a6 100644
--- a/ql/src/test/results/clientpositive/perf/query67.q.out
+++ b/ql/src/test/results/clientpositive/perf/query67.q.out
@@ -164,7 +164,7 @@ Stage-0
                                               Select Operator [SEL_2] (rows=1 width=0)
                                                 Output:["_col0","_col1","_col2","_col3","_col4"]
                                                 Filter Operator [FIL_48] (rows=1 width=0)
-                                                  predicate:((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_item_sk is not null)
+                                                  predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_item_sk is not null)
                                                   TableScan [TS_0] (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_quantity","ss_sales_price"]
                                           <-Map 8 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query68.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query68.q.out b/ql/src/test/results/clientpositive/perf/query68.q.out
index 38e4644..df253ae 100644
--- a/ql/src/test/results/clientpositive/perf/query68.q.out
+++ b/ql/src/test/results/clientpositive/perf/query68.q.out
@@ -119,7 +119,7 @@ Stage-0
                                                     Select Operator [SEL_2] (rows=1 width=0)
                                                       Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
                                                       Filter Operator [FIL_78] (rows=1 width=0)
-                                                        predicate:((((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_hdemo_sk is not null) and ss_addr_sk is not null) and ss_customer_sk is not null)
+                                                        predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_hdemo_sk is not null and ss_addr_sk is not null and ss_customer_sk is not null)
                                                         TableScan [TS_0] (rows=1 width=0)
                                                           default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_ticket_number","ss_ext_sales_price","ss_ext_list_price","ss_ext_tax"]
                                                 <-Map 10 [SIMPLE_EDGE]
@@ -128,7 +128,7 @@ Stage-0
                                                     Select Operator [SEL_5] (rows=18262 width=1119)
                                                       Output:["_col0"]
                                                       Filter Operator [FIL_79] (rows=18262 width=1119)
-                                                        predicate:(((d_year) IN (1998, 1999, 2000) and d_dom BETWEEN 1 AND 2) and d_date_sk is not null)
+                                                        predicate:((d_year) IN (1998, 1999, 2000) and d_dom BETWEEN 1 AND 2 and d_date_sk is not null)
                                                         TableScan [TS_3] (rows=73049 width=1119)
                                                           default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query7.q.out b/ql/src/test/results/clientpositive/perf/query7.q.out
index b5a8254..be336ac 100644
--- a/ql/src/test/results/clientpositive/perf/query7.q.out
+++ b/ql/src/test/results/clientpositive/perf/query7.q.out
@@ -83,7 +83,7 @@ Stage-0
                                       Select Operator [SEL_2] (rows=1 width=0)
                                         Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
                                         Filter Operator [FIL_50] (rows=1 width=0)
-                                          predicate:(((ss_cdemo_sk is not null and ss_sold_date_sk is not null) and ss_item_sk is not null) and ss_promo_sk is not null)
+                                          predicate:(ss_cdemo_sk is not null and ss_sold_date_sk is not null and ss_item_sk is not null and ss_promo_sk is not null)
                                           TableScan [TS_0] (rows=1 width=0)
                                             default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_cdemo_sk","ss_promo_sk","ss_quantity","ss_list_price","ss_sales_price","ss_coupon_amt"]
                                   <-Map 8 [SIMPLE_EDGE]
@@ -92,7 +92,7 @@ Stage-0
                                       Select Operator [SEL_5] (rows=2475 width=362)
                                         Output:["_col0"]
                                         Filter Operator [FIL_51] (rows=2475 width=362)
-                                          predicate:((((cd_gender = 'F') and (cd_marital_status = 'W')) and (cd_education_status = 'Primary')) and cd_demo_sk is not null)
+                                          predicate:((cd_gender = 'F') and (cd_marital_status = 'W') and (cd_education_status = 'Primary') and cd_demo_sk is not null)
                                           TableScan [TS_3] (rows=19800 width=362)
                                             default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_gender","cd_marital_status","cd_education_status"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query71.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query71.q.out b/ql/src/test/results/clientpositive/perf/query71.q.out
index 504705b..190dc22 100644
--- a/ql/src/test/results/clientpositive/perf/query71.q.out
+++ b/ql/src/test/results/clientpositive/perf/query71.q.out
@@ -71,7 +71,7 @@ Stage-0
                                     Select Operator [SEL_15] (rows=1 width=0)
                                       Output:["_col0","_col1","_col2","_col3"]
                                       Filter Operator [FIL_78] (rows=1 width=0)
-                                        predicate:((cs_sold_date_sk is not null and cs_item_sk is not null) and cs_sold_time_sk is not null)
+                                        predicate:(cs_sold_date_sk is not null and cs_item_sk is not null and cs_sold_time_sk is not null)
                                         TableScan [TS_13] (rows=1 width=0)
                                           default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_sold_time_sk","cs_item_sk","cs_ext_sales_price"]
                                 <-Map 12 [SIMPLE_EDGE]
@@ -80,7 +80,7 @@ Stage-0
                                     Select Operator [SEL_18] (rows=18262 width=1119)
                                       Output:["_col0"]
                                       Filter Operator [FIL_79] (rows=18262 width=1119)
-                                        predicate:(((d_moy = 12) and (d_year = 2001)) and d_date_sk is not null)
+                                        predicate:((d_moy = 12) and (d_year = 2001) and d_date_sk is not null)
                                         TableScan [TS_16] (rows=73049 width=1119)
                                           default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                           <-Reducer 14 [CONTAINS]
@@ -96,7 +96,7 @@ Stage-0
                                     Select Operator [SEL_27] (rows=1 width=0)
                                       Output:["_col0","_col1","_col2","_col3"]
                                       Filter Operator [FIL_80] (rows=1 width=0)
-                                        predicate:((ss_sold_date_sk is not null and ss_item_sk is not null) and ss_sold_time_sk is not null)
+                                        predicate:(ss_sold_date_sk is not null and ss_item_sk is not null and ss_sold_time_sk is not null)
                                         TableScan [TS_25] (rows=1 width=0)
                                           default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_sold_time_sk","ss_item_sk","ss_ext_sales_price"]
                                 <-Map 15 [SIMPLE_EDGE]
@@ -105,7 +105,7 @@ Stage-0
                                     Select Operator [SEL_30] (rows=18262 width=1119)
                                       Output:["_col0"]
                                       Filter Operator [FIL_81] (rows=18262 width=1119)
-                                        predicate:(((d_moy = 12) and (d_year = 2001)) and d_date_sk is not null)
+                                        predicate:((d_moy = 12) and (d_year = 2001) and d_date_sk is not null)
                                         TableScan [TS_28] (rows=73049 width=1119)
                                           default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
                           <-Reducer 7 [CONTAINS]
@@ -121,7 +121,7 @@ Stage-0
                                     Select Operator [SEL_5] (rows=1 width=0)
                                       Output:["_col0","_col1","_col2","_col3"]
                                       Filter Operator [FIL_76] (rows=1 width=0)
-                                        predicate:((ws_sold_date_sk is not null and ws_item_sk is not null) and ws_sold_time_sk is not null)
+                                        predicate:(ws_sold_date_sk is not null and ws_item_sk is not null and ws_sold_time_sk is not null)
                                         TableScan [TS_3] (rows=1 width=0)
                                           default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_date_sk","ws_sold_time_sk","ws_item_sk","ws_ext_sales_price"]
                                 <-Map 9 [SIMPLE_EDGE]
@@ -130,7 +130,7 @@ Stage-0
                                     Select Operator [SEL_8] (rows=18262 width=1119)
                                       Output:["_col0"]
                                       Filter Operator [FIL_77] (rows=18262 width=1119)
-                                        predicate:(((d_moy = 12) and (d_year = 2001)) and d_date_sk is not null)
+                                        predicate:((d_moy = 12) and (d_year = 2001) 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"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query72.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query72.q.out b/ql/src/test/results/clientpositive/perf/query72.q.out
index 6d8bd36..5c35a17 100644
--- a/ql/src/test/results/clientpositive/perf/query72.q.out
+++ b/ql/src/test/results/clientpositive/perf/query72.q.out
@@ -105,7 +105,7 @@ Stage-0
                                               Select Operator [SEL_25] (rows=36524 width=1119)
                                                 Output:["_col0","_col1","_col2"]
                                                 Filter Operator [FIL_128] (rows=36524 width=1119)
-                                                  predicate:(((d_year = 2001) and d_date_sk is not null) and d_week_seq is not null)
+                                                  predicate:((d_year = 2001) and d_date_sk is not null and d_week_seq is not null)
                                                   TableScan [TS_23] (rows=73049 width=1119)
                                                     default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_week_seq","d_year"]
                                           <-Reducer 6 [SIMPLE_EDGE]
@@ -179,7 +179,7 @@ Stage-0
                                                                       Select Operator [SEL_2] (rows=1 width=0)
                                                                         Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
                                                                         Filter Operator [FIL_122] (rows=1 width=0)
-                                                                          predicate:((((cs_item_sk is not null and cs_bill_cdemo_sk is not null) and cs_bill_hdemo_sk is not null) and cs_sold_date_sk is not null) and cs_ship_date_sk is not null)
+                                                                          predicate:(cs_item_sk is not null and cs_bill_cdemo_sk is not null and cs_bill_hdemo_sk is not null and cs_sold_date_sk is not null and cs_ship_date_sk is not null)
                                                                           TableScan [TS_0] (rows=1 width=0)
                                                                             default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_ship_date_sk","cs_bill_cdemo_sk","cs_bill_hdemo_sk","cs_item_sk","cs_promo_sk","cs_order_number","cs_quantity"]
                                                                   <-Map 14 [SIMPLE_EDGE]
@@ -188,7 +188,7 @@ Stage-0
                                                                       Select Operator [SEL_5] (rows=1 width=0)
                                                                         Output:["_col0","_col1","_col2","_col3"]
                                                                         Filter Operator [FIL_123] (rows=1 width=0)
-                                                                          predicate:((inv_item_sk is not null and inv_warehouse_sk is not null) and inv_date_sk is not null)
+                                                                          predicate:(inv_item_sk is not null and inv_warehouse_sk is not null and inv_date_sk is not null)
                                                                           TableScan [TS_3] (rows=1 width=0)
                                                                             default@inventory,inventory,Tbl:PARTIAL,Col:NONE,Output:["inv_date_sk","inv_item_sk","inv_warehouse_sk","inv_quantity_on_hand"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query73.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query73.q.out b/ql/src/test/results/clientpositive/perf/query73.q.out
index cf3a75e..cb22c8a 100644
--- a/ql/src/test/results/clientpositive/perf/query73.q.out
+++ b/ql/src/test/results/clientpositive/perf/query73.q.out
@@ -57,7 +57,7 @@ Stage-0
                                 Select Operator [SEL_11] (rows=1200 width=107)
                                   Output:["_col0"]
                                   Filter Operator [FIL_55] (rows=1200 width=107)
-                                    predicate:(((((hd_buy_potential = '1001-5000') or (hd_buy_potential = '5001-10000')) and (hd_vehicle_count > 0)) and CASE WHEN ((hd_vehicle_count > 0)) THEN (((UDFToDouble(hd_dep_count) / UDFToDouble(hd_vehicle_count)) > 1.0)) ELSE (null) END) and hd_demo_sk is not null)
+                                    predicate:(((hd_buy_potential = '1001-5000') or (hd_buy_potential = '5001-10000')) and (hd_vehicle_count > 0) and CASE WHEN ((hd_vehicle_count > 0)) THEN (((UDFToDouble(hd_dep_count) / UDFToDouble(hd_vehicle_count)) > 1.0)) ELSE (null) END 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_buy_potential","hd_dep_count","hd_vehicle_count"]
                             <-Reducer 3 [SIMPLE_EDGE]
@@ -85,7 +85,7 @@ Stage-0
                                         Select Operator [SEL_2] (rows=1 width=0)
                                           Output:["_col0","_col1","_col2","_col3","_col4"]
                                           Filter Operator [FIL_52] (rows=1 width=0)
-                                            predicate:(((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_hdemo_sk is not null) and ss_customer_sk is not null)
+                                            predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_hdemo_sk is not null and ss_customer_sk is not null)
                                             TableScan [TS_0] (rows=1 width=0)
                                               default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_hdemo_sk","ss_store_sk","ss_ticket_number"]
                                     <-Map 8 [SIMPLE_EDGE]
@@ -94,7 +94,7 @@ Stage-0
                                         Select Operator [SEL_5] (rows=18262 width=1119)
                                           Output:["_col0"]
                                           Filter Operator [FIL_53] (rows=18262 width=1119)
-                                            predicate:(((d_year) IN (1998, 1999, 2000) and d_dom BETWEEN 1 AND 2) and d_date_sk is not null)
+                                            predicate:((d_year) IN (1998, 1999, 2000) and d_dom BETWEEN 1 AND 2 and d_date_sk is not null)
                                             TableScan [TS_3] (rows=73049 width=1119)
                                               default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query75.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query75.q.out b/ql/src/test/results/clientpositive/perf/query75.q.out
index 25a8776..35729a2 100644
--- a/ql/src/test/results/clientpositive/perf/query75.q.out
+++ b/ql/src/test/results/clientpositive/perf/query75.q.out
@@ -106,7 +106,7 @@ Stage-0
                                               Select Operator [SEL_79] (rows=231000 width=1436)
                                                 Output:["_col0","_col1","_col2","_col3","_col5"]
                                                 Filter Operator [FIL_230] (rows=231000 width=1436)
-                                                  predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_brand_id is not null) and i_class_id is not null) and i_category_id is not null) and i_manufact_id is not null)
+                                                  predicate:((i_category = 'Sports') and i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_manufact_id is not null)
                                                   TableScan [TS_77] (rows=462000 width=1436)
                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"]
                         <-Reducer 38 [CONTAINS]
@@ -163,7 +163,7 @@ Stage-0
                                               Select Operator [SEL_101] (rows=231000 width=1436)
                                                 Output:["_col0","_col1","_col2","_col3","_col5"]
                                                 Filter Operator [FIL_234] (rows=231000 width=1436)
-                                                  predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_brand_id is not null) and i_class_id is not null) and i_category_id is not null) and i_manufact_id is not null)
+                                                  predicate:((i_category = 'Sports') and i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_manufact_id is not null)
                                                   TableScan [TS_99] (rows=462000 width=1436)
                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"]
                         <-Reducer 45 [CONTAINS]
@@ -220,7 +220,7 @@ Stage-0
                                               Select Operator [SEL_125] (rows=231000 width=1436)
                                                 Output:["_col0","_col1","_col2","_col3","_col5"]
                                                 Filter Operator [FIL_238] (rows=231000 width=1436)
-                                                  predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_brand_id is not null) and i_class_id is not null) and i_category_id is not null) and i_manufact_id is not null)
+                                                  predicate:((i_category = 'Sports') and i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_manufact_id is not null)
                                                   TableScan [TS_123] (rows=462000 width=1436)
                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"]
                   <-Reducer 6 [SIMPLE_EDGE]
@@ -283,7 +283,7 @@ Stage-0
                                               Select Operator [SEL_27] (rows=231000 width=1436)
                                                 Output:["_col0","_col1","_col2","_col3","_col5"]
                                                 Filter Operator [FIL_222] (rows=231000 width=1436)
-                                                  predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_brand_id is not null) and i_class_id is not null) and i_category_id is not null) and i_manufact_id is not null)
+                                                  predicate:((i_category = 'Sports') and i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_manufact_id is not null)
                                                   TableScan [TS_25] (rows=462000 width=1436)
                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"]
                         <-Reducer 22 [CONTAINS]
@@ -340,7 +340,7 @@ Stage-0
                                               Select Operator [SEL_51] (rows=231000 width=1436)
                                                 Output:["_col0","_col1","_col2","_col3","_col5"]
                                                 Filter Operator [FIL_226] (rows=231000 width=1436)
-                                                  predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_brand_id is not null) and i_class_id is not null) and i_category_id is not null) and i_manufact_id is not null)
+                                                  predicate:((i_category = 'Sports') and i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_manufact_id is not null)
                                                   TableScan [TS_49] (rows=462000 width=1436)
                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"]
                         <-Reducer 4 [CONTAINS]
@@ -397,7 +397,7 @@ Stage-0
                                               Select Operator [SEL_5] (rows=231000 width=1436)
                                                 Output:["_col0","_col1","_col2","_col3","_col5"]
                                                 Filter Operator [FIL_218] (rows=231000 width=1436)
-                                                  predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_brand_id is not null) and i_class_id is not null) and i_category_id is not null) and i_manufact_id is not null)
+                                                  predicate:((i_category = 'Sports') and i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_manufact_id is not null)
                                                   TableScan [TS_3] (rows=462000 width=1436)
                                                     default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_brand_id","i_class_id","i_category_id","i_category","i_manufact_id"]
 

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query76.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query76.q.out b/ql/src/test/results/clientpositive/perf/query76.q.out
index c90578b..170c18e 100644
--- a/ql/src/test/results/clientpositive/perf/query76.q.out
+++ b/ql/src/test/results/clientpositive/perf/query76.q.out
@@ -67,7 +67,7 @@ Stage-0
                                 Select Operator [SEL_18] (rows=1 width=0)
                                   Output:["_col0","_col1","_col3"]
                                   Filter Operator [FIL_78] (rows=1 width=0)
-                                    predicate:((ws_web_page_sk is null and ws_item_sk is not null) and ws_sold_date_sk is not null)
+                                    predicate:(ws_web_page_sk is null and ws_item_sk is not null and ws_sold_date_sk is not null)
                                     TableScan [TS_16] (rows=1 width=0)
                                       default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_web_page_sk","ws_ext_sales_price"]
                 <-Reducer 16 [CONTAINS]
@@ -99,7 +99,7 @@ Stage-0
                                 Select Operator [SEL_36] (rows=1 width=0)
                                   Output:["_col0","_col2","_col3"]
                                   Filter Operator [FIL_81] (rows=1 width=0)
-                                    predicate:((cs_warehouse_sk is null and cs_item_sk is not null) and cs_sold_date_sk is not null)
+                                    predicate:(cs_warehouse_sk is null and cs_item_sk is not null and cs_sold_date_sk is not null)
                                     TableScan [TS_34] (rows=1 width=0)
                                       default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_warehouse_sk","cs_item_sk","cs_ext_sales_price"]
                             <-Map 17 [SIMPLE_EDGE]
@@ -140,7 +140,7 @@ Stage-0
                                 Select Operator [SEL_2] (rows=1 width=0)
                                   Output:["_col0","_col1","_col3"]
                                   Filter Operator [FIL_75] (rows=1 width=0)
-                                    predicate:((ss_addr_sk is null and ss_item_sk is not null) and ss_sold_date_sk is not null)
+                                    predicate:(ss_addr_sk is null and ss_item_sk is not null and ss_sold_date_sk is not null)
                                     TableScan [TS_0] (rows=1 width=0)
                                       default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_addr_sk","ss_ext_sales_price"]
                             <-Map 7 [SIMPLE_EDGE]

http://git-wip-us.apache.org/repos/asf/hive/blob/677e5d20/ql/src/test/results/clientpositive/perf/query79.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query79.q.out b/ql/src/test/results/clientpositive/perf/query79.q.out
index bf537b9..a17eb84 100644
--- a/ql/src/test/results/clientpositive/perf/query79.q.out
+++ b/ql/src/test/results/clientpositive/perf/query79.q.out
@@ -87,7 +87,7 @@ Stage-0
                                           Select Operator [SEL_2] (rows=1 width=0)
                                             Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
                                             Filter Operator [FIL_52] (rows=1 width=0)
-                                              predicate:(((ss_sold_date_sk is not null and ss_store_sk is not null) and ss_hdemo_sk is not null) and ss_customer_sk is not null)
+                                              predicate:(ss_sold_date_sk is not null and ss_store_sk is not null and ss_hdemo_sk is not null and ss_customer_sk is not null)
                                               TableScan [TS_0] (rows=1 width=0)
                                                 default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_ticket_number","ss_coupon_amt","ss_net_profit"]
                                       <-Map 8 [SIMPLE_EDGE]
@@ -96,7 +96,7 @@ Stage-0
                                           Select Operator [SEL_5] (rows=18262 width=1119)
                                             Output:["_col0"]
                                             Filter Operator [FIL_53] (rows=18262 width=1119)
-                                              predicate:(((d_year) IN (1998, 1999, 2000) and (d_dow = 1)) and d_date_sk is not null)
+                                              predicate:((d_year) IN (1998, 1999, 2000) and (d_dow = 1) and d_date_sk is not null)
                                               TableScan [TS_3] (rows=73049 width=1119)
                                                 default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dow"]
 


Mime
View raw message