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"]
