http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query27.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query27.q.out b/ql/src/test/results/clientpositive/perf/spark/query27.q.out index f0154c6..e7ed297 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query27.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query27.q.out @@ -56,6 +56,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store + filterExpr: ((s_state) IN ('SD', 'FL', 'MI', 'LA', 'MO', 'SC') and s_store_sk is not null) (type: boolean) Statistics: Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((s_state) IN ('SD', 'FL', 'MI', 'LA', 'MO', 'SC') and s_store_sk is not null) (type: boolean) @@ -86,6 +87,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (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) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_cdemo_sk is not null and ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null) (type: boolean) @@ -105,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) @@ -124,6 +127,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_demographics + filterExpr: ((cd_gender = 'M') and (cd_marital_status = 'U') and (cd_education_status = '2 yr Degree') and cd_demo_sk is not null) (type: boolean) Statistics: Num rows: 1861800 Data size: 717186159 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((cd_education_status = '2 yr Degree') and (cd_gender = 'M') and (cd_marital_status = 'U') and cd_demo_sk is not null) (type: boolean) @@ -142,6 +146,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2001) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2001) and d_date_sk is not null) (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query28.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query28.q.out b/ql/src/test/results/clientpositive/perf/spark/query28.q.out index c9c507a..b437829 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query28.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query28.q.out @@ -128,6 +128,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_quantity BETWEEN 16 AND 20 and (ss_list_price BETWEEN 142 AND 152 or ss_coupon_amt BETWEEN 3054 AND 4054 or ss_wholesale_cost BETWEEN 80 AND 100)) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_list_price BETWEEN 142 AND 152 or ss_coupon_amt BETWEEN 3054 AND 4054 or ss_wholesale_cost BETWEEN 80 AND 100) and ss_quantity BETWEEN 16 AND 20) (type: boolean) @@ -153,6 +154,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_quantity BETWEEN 11 AND 15 and (ss_list_price BETWEEN 66 AND 76 or ss_coupon_amt BETWEEN 920 AND 1920 or ss_wholesale_cost BETWEEN 4 AND 24)) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_list_price BETWEEN 66 AND 76 or ss_coupon_amt BETWEEN 920 AND 1920 or ss_wholesale_cost BETWEEN 4 AND 24) and ss_quantity BETWEEN 11 AND 15) (type: boolean) @@ -178,6 +180,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_quantity BETWEEN 6 AND 10 and (ss_list_price BETWEEN 91 AND 101 or ss_coupon_amt BETWEEN 1430 AND 2430 or ss_wholesale_cost BETWEEN 32 AND 52)) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_list_price BETWEEN 91 AND 101 or ss_coupon_amt BETWEEN 1430 AND 2430 or ss_wholesale_cost BETWEEN 32 AND 52) and ss_quantity BETWEEN 6 AND 10) (type: boolean) @@ -203,6 +206,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_quantity BETWEEN 26 AND 30 and (ss_list_price BETWEEN 28 AND 38 or ss_coupon_amt BETWEEN 2513 AND 3513 or ss_wholesale_cost BETWEEN 42 AND 62)) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_list_price BETWEEN 28 AND 38 or ss_coupon_amt BETWEEN 2513 AND 3513 or ss_wholesale_cost BETWEEN 42 AND 62) and ss_quantity BETWEEN 26 AND 30) (type: boolean) @@ -228,6 +232,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_quantity BETWEEN 21 AND 25 and (ss_list_price BETWEEN 135 AND 145 or ss_coupon_amt BETWEEN 14180 AND 15180 or ss_wholesale_cost BETWEEN 38 AND 58)) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_list_price BETWEEN 135 AND 145 or ss_coupon_amt BETWEEN 14180 AND 15180 or ss_wholesale_cost BETWEEN 38 AND 58) and ss_quantity BETWEEN 21 AND 25) (type: boolean) @@ -461,6 +466,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_quantity BETWEEN 0 AND 5 and (ss_list_price BETWEEN 11 AND 21 or ss_coupon_amt BETWEEN 460 AND 1460 or ss_wholesale_cost BETWEEN 14 AND 34)) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_list_price BETWEEN 11 AND 21 or ss_coupon_amt BETWEEN 460 AND 1460 or ss_wholesale_cost BETWEEN 14 AND 34) and ss_quantity BETWEEN 0 AND 5) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query29.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query29.q.out b/ql/src/test/results/clientpositive/perf/spark/query29.q.out index 43d68f1..b070fc0 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query29.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query29.q.out @@ -105,6 +105,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store + filterExpr: s_store_sk is not null (type: boolean) Statistics: Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: s_store_sk is not null (type: boolean) @@ -129,6 +130,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d2 + filterExpr: (d_moy BETWEEN 4 AND 7 and (d_year = 1999) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 1999) and d_date_sk is not null and d_moy BETWEEN 4 AND 7) (type: boolean) @@ -161,6 +163,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -180,6 +183,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d1 + filterExpr: ((d_moy = 4) and (d_year = 1999) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 4) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -198,6 +202,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_returns + filterExpr: (sr_customer_sk is not null and sr_item_sk is not null and sr_ticket_number is not null and sr_returned_date_sk is not null) (type: boolean) Statistics: Num rows: 57591150 Data size: 4462194832 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (sr_customer_sk is not null and sr_item_sk is not null and sr_returned_date_sk is not null and sr_ticket_number is not null) (type: boolean) @@ -229,6 +234,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) @@ -248,6 +254,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d3 + filterExpr: ((d_year) IN (1999, 2000, 2001) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year) IN (1999, 2000, 2001) and d_date_sk is not null) (type: boolean) @@ -266,6 +273,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_customer_sk is not null and ss_item_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) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_customer_sk is not null and ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null and ss_ticket_number is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query3.q.out b/ql/src/test/results/clientpositive/perf/spark/query3.q.out index e9d78c5..5604cef 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query3.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query3.q.out @@ -56,6 +56,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_item_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_item_sk is not null and ss_sold_date_sk is not null) (type: boolean) @@ -75,6 +76,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: ((i_manufact_id = 436) and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((i_manufact_id = 436) and i_item_sk is not null) (type: boolean) @@ -94,6 +96,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: dt + filterExpr: ((d_moy = 12) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 12) and d_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query30.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query30.q.out b/ql/src/test/results/clientpositive/perf/spark/query30.q.out index 16c11ca..46c62e8 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query30.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query30.q.out @@ -82,6 +82,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_current_addr_sk is not null and c_customer_sk is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_current_addr_sk is not null and c_customer_sk is not null) (type: boolean) @@ -101,6 +102,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2002) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2002) and d_date_sk is not null) (type: boolean) @@ -119,6 +121,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_state is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_state is not null) (type: boolean) @@ -138,6 +141,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_returns + filterExpr: (wr_returned_date_sk is not null and wr_returning_addr_sk is not null) (type: boolean) Statistics: Num rows: 14398467 Data size: 1325194184 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (wr_returned_date_sk is not null and wr_returning_addr_sk is not null) (type: boolean) @@ -157,6 +161,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2002) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2002) and d_date_sk is not null) (type: boolean) @@ -175,6 +180,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_state is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_state is not null) (type: boolean) @@ -194,6 +200,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: ((ca_state = 'IL') and ca_address_sk is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ca_state = 'IL') and ca_address_sk is not null) (type: boolean) @@ -212,6 +219,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_returns + filterExpr: (wr_returned_date_sk is not null and wr_returning_addr_sk is not null and wr_returning_customer_sk is not null) (type: boolean) Statistics: Num rows: 14398467 Data size: 1325194184 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (wr_returned_date_sk is not null and wr_returning_addr_sk is not null and wr_returning_customer_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query31.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query31.q.out b/ql/src/test/results/clientpositive/perf/spark/query31.q.out index 38dc809..81deede 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query31.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query31.q.out @@ -134,6 +134,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_addr_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_addr_sk is not null and ss_sold_date_sk is not null) (type: boolean) @@ -153,6 +154,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 1) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 1) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -171,6 +173,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_county is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_county is not null) (type: boolean) @@ -190,6 +193,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_addr_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_addr_sk is not null and ss_sold_date_sk is not null) (type: boolean) @@ -209,6 +213,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 3) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 3) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -227,6 +232,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_county is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_county is not null) (type: boolean) @@ -246,6 +252,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_addr_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -265,6 +272,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 1) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 1) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -283,6 +291,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_county is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_county is not null) (type: boolean) @@ -302,6 +311,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_addr_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -321,6 +331,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 2) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 2) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -339,6 +350,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_county is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_county is not null) (type: boolean) @@ -358,6 +370,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_addr_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -377,6 +390,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 3) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 3) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -395,6 +409,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_county is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_county is not null) (type: boolean) @@ -414,6 +429,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 2) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 2) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -432,6 +448,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: (ca_address_sk is not null and ca_county is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ca_address_sk is not null and ca_county is not null) (type: boolean) @@ -451,6 +468,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_addr_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_addr_sk is not null and ss_sold_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query32.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query32.q.out b/ql/src/test/results/clientpositive/perf/spark/query32.q.out index bb17957..17b9764 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query32.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query32.q.out @@ -67,6 +67,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-18 00:00:00.0' AND TIMESTAMP'1998-06-16 01:00:00.0' and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-18 00:00:00.0' AND TIMESTAMP'1998-06-16 01:00:00.0' and d_date_sk is not null) (type: boolean) @@ -91,6 +92,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-18 00:00:00.0' AND TIMESTAMP'1998-06-16 01:00:00.0' and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-18 00:00:00.0' AND TIMESTAMP'1998-06-16 01:00:00.0' and d_date_sk is not null) (type: boolean) @@ -120,6 +122,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -151,6 +154,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -188,6 +192,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: ((i_manufact_id = 269) and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((i_manufact_id = 269) and i_item_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query33.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query33.q.out b/ql/src/test/results/clientpositive/perf/spark/query33.q.out index 46a77aa..39851fb 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query33.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query33.q.out @@ -178,6 +178,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: (i_manufact_id is not null and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (i_item_sk is not null and i_manufact_id is not null) (type: boolean) @@ -197,6 +198,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_moy = 3) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 3) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -215,6 +217,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: ((ca_gmt_offset = -6) and ca_address_sk is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ca_gmt_offset = -6) and ca_address_sk is not null) (type: boolean) @@ -233,6 +236,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: ((i_category = 'Books') and i_manufact_id is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((i_category = 'Books') and i_manufact_id is not null) (type: boolean) @@ -256,6 +260,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_sold_date_sk is not null and cs_bill_addr_sk is not null and cs_item_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_bill_addr_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -275,6 +280,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: (i_manufact_id is not null and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (i_item_sk is not null and i_manufact_id is not null) (type: boolean) @@ -294,6 +300,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_sold_date_sk is not null and ws_bill_addr_sk is not null and ws_item_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_addr_sk is not null and ws_item_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -313,6 +320,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_moy = 3) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 3) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -331,6 +339,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: ((ca_gmt_offset = -6) and ca_address_sk is not null) (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ca_gmt_offset = -6) and ca_address_sk is not null) (type: boolean) @@ -349,6 +358,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_addr_sk is not null and ss_item_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_addr_sk is not null and ss_item_sk is not null and ss_sold_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query34.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query34.q.out b/ql/src/test/results/clientpositive/perf/spark/query34.q.out index 9535394..b40081e 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query34.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query34.q.out @@ -72,6 +72,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: household_demographics + filterExpr: (((hd_buy_potential = '>10000') or (hd_buy_potential = 'unknown')) and (hd_vehicle_count > 0) and CASE WHEN ((hd_vehicle_count > 0)) THEN (((UDFToDouble(hd_dep_count) / UDFToDouble(hd_vehicle_count)) > 1.2D)) ELSE (null) END and hd_demo_sk is not null) (type: boolean) Statistics: Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((hd_buy_potential = '>10000') or (hd_buy_potential = 'unknown')) and (hd_vehicle_count > 0) and CASE WHEN ((hd_vehicle_count > 0)) THEN (((UDFToDouble(hd_dep_count) / UDFToDouble(hd_vehicle_count)) > 1.2D)) ELSE (null) END and hd_demo_sk is not null) (type: boolean) @@ -90,6 +91,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store + filterExpr: ((s_county) IN ('Mobile County', 'Maverick County', 'Huron County', 'Kittitas County', 'Fairfield County', 'Jackson County', 'Barrow County', 'Pennington County') and s_store_sk is not null) (type: boolean) Statistics: Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((s_county) IN ('Mobile County', 'Maverick County', 'Huron County', 'Kittitas County', 'Fairfield County', 'Jackson County', 'Barrow County', 'Pennington County') and s_store_sk is not null) (type: boolean) @@ -119,6 +121,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: c_customer_sk is not null (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: c_customer_sk is not null (type: boolean) @@ -138,6 +141,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (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) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_customer_sk is not null and ss_hdemo_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null) (type: boolean) @@ -157,6 +161,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year) IN (2000, 2001, 2002) and (d_dom BETWEEN 1 AND 3 or d_dom BETWEEN 25 AND 28) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_dom BETWEEN 1 AND 3 or d_dom BETWEEN 25 AND 28) and (d_year) IN (2000, 2001, 2002) and d_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query35.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query35.q.out b/ql/src/test/results/clientpositive/perf/spark/query35.q.out index 5bd9b75..6d1ea9b 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query35.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query35.q.out @@ -134,6 +134,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c + filterExpr: (c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_customer_sk is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_customer_sk is not null) (type: boolean) @@ -153,6 +154,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_qoy < 4) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy < 4) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -171,6 +173,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -190,6 +193,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_qoy < 4) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy < 4) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -208,6 +212,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_ship_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_ship_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -227,6 +232,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_qoy < 4) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy < 4) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -245,6 +251,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: ca + filterExpr: ca_address_sk is not null (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ca_address_sk is not null (type: boolean) @@ -264,6 +271,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_demographics + filterExpr: cd_demo_sk is not null (type: boolean) Statistics: Num rows: 1861800 Data size: 717186159 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cd_demo_sk is not null (type: boolean) @@ -283,6 +291,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query36.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query36.q.out b/ql/src/test/results/clientpositive/perf/spark/query36.q.out index dd6d793..bdf96a9 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query36.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query36.q.out @@ -70,6 +70,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store + filterExpr: ((s_state) IN ('SD', 'FL', 'MI', 'LA', 'MO', 'SC', 'AL', 'GA') and s_store_sk is not null) (type: boolean) Statistics: Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((s_state) IN ('SD', 'FL', 'MI', 'LA', 'MO', 'SC', 'AL', 'GA') and s_store_sk is not null) (type: boolean) @@ -100,6 +101,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_item_sk is not null and ss_store_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null) (type: boolean) @@ -119,6 +121,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: d1 + filterExpr: ((d_year = 1999) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -137,6 +140,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query37.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query37.q.out b/ql/src/test/results/clientpositive/perf/spark/query37.q.out index 07e8eda..57cb061 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query37.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query37.q.out @@ -44,6 +44,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'2001-06-02 00:00:00.0' AND TIMESTAMP'2001-08-01 00:00:00.0' and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'2001-06-02 00:00:00.0' AND TIMESTAMP'2001-08-01 00:00:00.0' and d_date_sk is not null) (type: boolean) @@ -72,6 +73,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: cs_item_sk is not null (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cs_item_sk is not null (type: boolean) @@ -90,6 +92,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: ((i_manufact_id) IN (678, 964, 918, 849) and i_current_price BETWEEN 22 AND 52 and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((i_manufact_id) IN (678, 964, 918, 849) and i_current_price BETWEEN 22 AND 52 and i_item_sk is not null) (type: boolean) @@ -109,6 +112,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: inventory + filterExpr: (inv_quantity_on_hand BETWEEN 100 AND 500 and inv_item_sk is not null and inv_date_sk is not null) (type: boolean) Statistics: Num rows: 37584000 Data size: 593821104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (inv_date_sk is not null and inv_item_sk is not null and inv_quantity_on_hand BETWEEN 100 AND 500) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query38.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query38.q.out b/ql/src/test/results/clientpositive/perf/spark/query38.q.out index aa5660c..0064177 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query38.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query38.q.out @@ -58,6 +58,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) (type: boolean) @@ -82,6 +83,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) (type: boolean) @@ -106,6 +108,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) (type: boolean) @@ -139,6 +142,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_customer_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) @@ -170,6 +174,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: c_customer_sk is not null (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: c_customer_sk is not null (type: boolean) @@ -189,6 +194,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_sold_date_sk is not null and ws_bill_customer_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -220,6 +226,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: c_customer_sk is not null (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: c_customer_sk is not null (type: boolean) @@ -239,6 +246,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_sold_date_sk is not null and cs_bill_customer_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_bill_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query39.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query39.q.out b/ql/src/test/results/clientpositive/perf/spark/query39.q.out index d126120..cab0feb 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query39.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query39.q.out @@ -65,6 +65,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: warehouse + filterExpr: w_warehouse_sk is not null (type: boolean) Statistics: Num rows: 27 Data size: 27802 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: w_warehouse_sk is not null (type: boolean) @@ -89,6 +90,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: warehouse + filterExpr: w_warehouse_sk is not null (type: boolean) Statistics: Num rows: 27 Data size: 27802 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: w_warehouse_sk is not null (type: boolean) @@ -122,6 +124,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: inventory + filterExpr: (inv_item_sk is not null and inv_warehouse_sk is not null and inv_date_sk is not null) (type: boolean) Statistics: Num rows: 37584000 Data size: 593821104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (inv_date_sk is not null and inv_item_sk is not null and inv_warehouse_sk is not null) (type: boolean) @@ -141,6 +144,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: inventory + filterExpr: (inv_item_sk is not null and inv_warehouse_sk is not null and inv_date_sk is not null) (type: boolean) Statistics: Num rows: 37584000 Data size: 593821104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (inv_date_sk is not null and inv_item_sk is not null and inv_warehouse_sk is not null) (type: boolean) @@ -160,6 +164,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_moy = 5) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 5) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -178,6 +183,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) @@ -196,6 +202,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1999) and (d_moy = 4) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 4) and (d_year = 1999) and d_date_sk is not null) (type: boolean) @@ -214,6 +221,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query4.q.out b/ql/src/test/results/clientpositive/perf/spark/query4.q.out index c79ac8f..0993dc2 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query4.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query4.q.out @@ -248,6 +248,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_bill_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_bill_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -267,6 +268,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2001) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2001) and d_date_sk is not null) (type: boolean) @@ -285,6 +287,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_customer_id is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_customer_id is not null and c_customer_sk is not null) (type: boolean) @@ -304,6 +307,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) @@ -323,6 +327,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2002) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2002) and d_date_sk is not null) (type: boolean) @@ -341,6 +346,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_customer_id is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_customer_id is not null and c_customer_sk is not null) (type: boolean) @@ -360,6 +366,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_bill_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_bill_customer_sk is not null and cs_sold_date_sk is not null) (type: boolean) @@ -379,6 +386,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2001) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2001) and d_date_sk is not null) (type: boolean) @@ -397,6 +405,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_customer_id is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_customer_id is not null and c_customer_sk is not null) (type: boolean) @@ -416,6 +425,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -435,6 +445,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2002) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2002) and d_date_sk is not null) (type: boolean) @@ -453,6 +464,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_customer_id is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_customer_id is not null and c_customer_sk is not null) (type: boolean) @@ -472,6 +484,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -491,6 +504,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2001) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2001) and d_date_sk is not null) (type: boolean) @@ -509,6 +523,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_customer_id is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_customer_id is not null and c_customer_sk is not null) (type: boolean) @@ -528,6 +543,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 2002) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 2002) and d_date_sk is not null) (type: boolean) @@ -546,6 +562,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_customer_id is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_customer_id is not null and c_customer_sk is not null) (type: boolean) @@ -565,6 +582,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_customer_sk is not null and ss_sold_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query40.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query40.q.out b/ql/src/test/results/clientpositive/perf/spark/query40.q.out index cf54ed8..949840d 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query40.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query40.q.out @@ -67,6 +67,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: warehouse + filterExpr: w_warehouse_sk is not null (type: boolean) Statistics: Num rows: 27 Data size: 27802 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: w_warehouse_sk is not null (type: boolean) @@ -91,6 +92,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-08 23:00:00.0' AND TIMESTAMP'1998-05-08 00:00:00.0' and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'1998-03-08 23:00:00.0' AND TIMESTAMP'1998-05-08 00:00:00.0' and d_date_sk is not null) (type: boolean) @@ -120,6 +122,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_sales + filterExpr: (cs_warehouse_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean) Statistics: Num rows: 287989836 Data size: 38999608952 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (cs_item_sk is not null and cs_sold_date_sk is not null and cs_warehouse_sk is not null) (type: boolean) @@ -139,6 +142,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: catalog_returns + filterExpr: cr_item_sk is not null (type: boolean) Statistics: Num rows: 28798881 Data size: 3057234680 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: cr_item_sk is not null (type: boolean) @@ -158,6 +162,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: (i_current_price BETWEEN 0.99 AND 1.49 and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (i_current_price BETWEEN 0.99 AND 1.49 and i_item_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query42.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query42.q.out b/ql/src/test/results/clientpositive/perf/spark/query42.q.out index 31ff56e..8d9777f 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query42.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query42.q.out @@ -58,6 +58,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_item_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_item_sk is not null and ss_sold_date_sk is not null) (type: boolean) @@ -77,6 +78,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: dt + filterExpr: ((d_moy = 12) and (d_year = 1998) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_moy = 12) and (d_year = 1998) and d_date_sk is not null) (type: boolean) @@ -95,6 +97,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: ((i_manager_id = 1) and i_item_sk is not null) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((i_manager_id = 1) and i_item_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query43.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query43.q.out b/ql/src/test/results/clientpositive/perf/spark/query43.q.out index 61f3cc0..3e234a1 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query43.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query43.q.out @@ -48,6 +48,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store + filterExpr: ((s_gmt_offset = -6) and s_store_sk is not null) (type: boolean) Statistics: Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((s_gmt_offset = -6) and s_store_sk is not null) (type: boolean) @@ -76,6 +77,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (ss_sold_date_sk is not null and ss_store_sk is not null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_sold_date_sk is not null and ss_store_sk is not null) (type: boolean) @@ -95,6 +97,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_year = 1998) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_year = 1998) and d_date_sk is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query44.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query44.q.out b/ql/src/test/results/clientpositive/perf/spark/query44.q.out index 77006c1..6ba55e9 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query44.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query44.q.out @@ -96,6 +96,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: i1 + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) @@ -115,6 +116,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: ((ss_store_sk = 410) and ss_hdemo_sk is null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_store_sk = 410) and ss_hdemo_sk is null) (type: boolean) @@ -140,6 +142,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: ss1 + filterExpr: (ss_store_sk = 410) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_store_sk = 410) (type: boolean) @@ -165,6 +168,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: i2 + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) @@ -184,6 +188,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: ((ss_store_sk = 410) and ss_hdemo_sk is null) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((ss_store_sk = 410) and ss_hdemo_sk is null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query45.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query45.q.out b/ql/src/test/results/clientpositive/perf/spark/query45.q.out index c2ff079..d61f8b8 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query45.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query45.q.out @@ -53,6 +53,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: (i_item_sk) IN (2, 3, 5, 7, 11, 13, 17, 19, 23, 29) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (i_item_sk) IN (2, 3, 5, 7, 11, 13, 17, 19, 23, 29) (type: boolean) @@ -103,6 +104,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_current_addr_sk is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_current_addr_sk is not null and c_customer_sk is not null) (type: boolean) @@ -122,6 +124,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: (i_item_sk) IN (2, 3, 5, 7, 11, 13, 17, 19, 23, 29) (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (i_item_sk) IN (2, 3, 5, 7, 11, 13, 17, 19, 23, 29) (type: boolean) @@ -145,6 +148,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: web_sales + filterExpr: (ws_bill_customer_sk is not null and ws_sold_date_sk is not null and ws_item_sk is not null) (type: boolean) Statistics: Num rows: 144002668 Data size: 19580198212 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ws_bill_customer_sk is not null and ws_item_sk is not null and ws_sold_date_sk is not null) (type: boolean) @@ -164,6 +168,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_qoy = 2) and (d_year = 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_qoy = 2) and (d_year = 2000) and d_date_sk is not null) (type: boolean) @@ -182,6 +187,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: ca_address_sk is not null (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ca_address_sk is not null (type: boolean) @@ -201,6 +207,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: item + filterExpr: i_item_sk is not null (type: boolean) Statistics: Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: i_item_sk is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/perf/spark/query46.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/spark/query46.q.out b/ql/src/test/results/clientpositive/perf/spark/query46.q.out index a26fc9e..ccce45c 100644 --- a/ql/src/test/results/clientpositive/perf/spark/query46.q.out +++ b/ql/src/test/results/clientpositive/perf/spark/query46.q.out @@ -80,6 +80,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store + filterExpr: ((s_city) IN ('Cedar Grove', 'Wildwood', 'Union', 'Salem', 'Highland Park') and s_store_sk is not null) (type: boolean) Statistics: Num rows: 1704 Data size: 3256276 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((s_city) IN ('Cedar Grove', 'Wildwood', 'Union', 'Salem', 'Highland Park') and s_store_sk is not null) (type: boolean) @@ -99,6 +100,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: household_demographics + filterExpr: (((hd_dep_count = 2) or (hd_vehicle_count = 1)) and hd_demo_sk is not null) (type: boolean) Statistics: Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((hd_dep_count = 2) or (hd_vehicle_count = 1)) and hd_demo_sk is not null) (type: boolean) @@ -130,6 +132,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer + filterExpr: (c_customer_sk is not null and c_current_addr_sk is not null) (type: boolean) Statistics: Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c_current_addr_sk is not null and c_customer_sk is not null) (type: boolean) @@ -149,6 +152,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: date_dim + filterExpr: ((d_dow) IN (6, 0) and (d_year) IN (1998, 1999, 2000) and d_date_sk is not null) (type: boolean) Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((d_dow) IN (6, 0) and (d_year) IN (1998, 1999, 2000) and d_date_sk is not null) (type: boolean) @@ -167,6 +171,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: customer_address + filterExpr: ca_address_sk is not null (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ca_address_sk is not null (type: boolean) @@ -186,6 +191,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: current_addr + filterExpr: ca_address_sk is not null (type: boolean) Statistics: Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ca_address_sk is not null (type: boolean) @@ -205,6 +211,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: store_sales + filterExpr: (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) (type: boolean) Statistics: Num rows: 575995635 Data size: 50814502088 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (ss_addr_sk is not null and ss_customer_sk is not null and ss_hdemo_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null) (type: boolean)
