Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 20608200CAF for ; Thu, 22 Jun 2017 17:12:58 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 1F20D160BE5; Thu, 22 Jun 2017 15:12:58 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D263F160BF1 for ; Thu, 22 Jun 2017 17:12:55 +0200 (CEST) Received: (qmail 95906 invoked by uid 500); 22 Jun 2017 15:12:54 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 95875 invoked by uid 99); 22 Jun 2017 15:12:54 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Jun 2017 15:12:54 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id A33ACDFF5F; Thu, 22 Jun 2017 15:12:53 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: jcamacho@apache.org To: commits@hive.apache.org Date: Thu, 22 Jun 2017 15:12:54 -0000 Message-Id: <27bd7f3543624efc867ef5e59d326563@git.apache.org> In-Reply-To: <9925e0c590354f29ab1f8acedc42e6c7@git.apache.org> References: <9925e0c590354f29ab1f8acedc42e6c7@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [2/9] hive git commit: HIVE-16867: Extend shared scan optimizer to reuse computation from other operators (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan) archived-at: Thu, 22 Jun 2017 15:12:58 -0000 http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/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 f24b14d..ddd0614 100644 --- a/ql/src/test/results/clientpositive/perf/query64.q.out +++ b/ql/src/test/results/clientpositive/perf/query64.q.out @@ -317,9 +317,9 @@ Stage-0 <-Map 40 [SIMPLE_EDGE] SHUFFLE [RS_247] PartitionCols:_col0 - Select Operator [SEL_227] (rows=1861800 width=385) + Select Operator [SEL_24] (rows=1861800 width=385) Output:["_col0","_col1"] - Filter Operator [FIL_574] (rows=1861800 width=385) + Filter Operator [FIL_543] (rows=1861800 width=385) predicate:cd_demo_sk is not null TableScan [TS_22] (rows=1861800 width=385) default@customer_demographics,cd2,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status"] @@ -336,11 +336,7 @@ Stage-0 <-Map 40 [SIMPLE_EDGE] SHUFFLE [RS_241] PartitionCols:_col0 - Select Operator [SEL_152] (rows=1861800 width=385) - Output:["_col0","_col1"] - Filter Operator [FIL_562] (rows=1861800 width=385) - predicate:cd_demo_sk is not null - Please refer to the previous TableScan [TS_22] + Please refer to the previous Select Operator [SEL_24] <-Reducer 15 [SIMPLE_EDGE] SHUFFLE [RS_240] PartitionCols:_col1 @@ -349,9 +345,9 @@ Stage-0 <-Map 39 [SIMPLE_EDGE] SHUFFLE [RS_238] PartitionCols:_col0 - Select Operator [SEL_149] (rows=40000000 width=1014) + Select Operator [SEL_21] (rows=40000000 width=1014) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_561] (rows=40000000 width=1014) + Filter Operator [FIL_542] (rows=40000000 width=1014) predicate:ca_address_sk is not null TableScan [TS_19] (rows=40000000 width=1014) default@customer_address,ad2,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_street_number","ca_street_name","ca_city","ca_zip"] @@ -390,9 +386,9 @@ Stage-0 <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_228] PartitionCols:_col5 - Select Operator [SEL_130] (rows=80000000 width=860) + Select Operator [SEL_2] (rows=80000000 width=860) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_556] (rows=80000000 width=860) + Filter Operator [FIL_537] (rows=80000000 width=860) predicate:(c_customer_sk is not null and c_first_shipto_date_sk is not null and c_first_sales_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_0] (rows=80000000 width=860) default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_cdemo_sk","c_current_hdemo_sk","c_current_addr_sk","c_first_shipto_date_sk","c_first_sales_date_sk"] @@ -404,18 +400,18 @@ Stage-0 <-Map 33 [SIMPLE_EDGE] SHUFFLE [RS_143] PartitionCols:_col1 - Select Operator [SEL_139] (rows=7200 width=107) + Select Operator [SEL_11] (rows=7200 width=107) Output:["_col0","_col1"] - Filter Operator [FIL_559] (rows=7200 width=107) + Filter Operator [FIL_540] (rows=7200 width=107) predicate:(hd_demo_sk is not null and hd_income_band_sk is not null) TableScan [TS_9] (rows=7200 width=107) default@household_demographics,hd2,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_income_band_sk"] <-Map 38 [SIMPLE_EDGE] SHUFFLE [RS_144] PartitionCols:_col0 - Select Operator [SEL_142] (rows=20 width=12) + Select Operator [SEL_14] (rows=20 width=12) Output:["_col0"] - Filter Operator [FIL_560] (rows=20 width=12) + Filter Operator [FIL_541] (rows=20 width=12) predicate:ib_income_band_sk is not null TableScan [TS_12] (rows=20 width=12) default@income_band,ib2,Tbl:COMPLETE,Col:NONE,Output:["ib_income_band_sk"] @@ -429,11 +425,7 @@ Stage-0 <-Map 39 [SIMPLE_EDGE] SHUFFLE [RS_222] PartitionCols:_col0 - Select Operator [SEL_208] (rows=40000000 width=1014) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_573] (rows=40000000 width=1014) - predicate:ca_address_sk is not null - Please refer to the previous TableScan [TS_19] + Please refer to the previous Select Operator [SEL_21] <-Reducer 31 [SIMPLE_EDGE] SHUFFLE [RS_221] PartitionCols:_col13 @@ -442,9 +434,9 @@ Stage-0 <-Map 55 [SIMPLE_EDGE] SHUFFLE [RS_219] PartitionCols:_col0 - Select Operator [SEL_205] (rows=1704 width=1910) + Select Operator [SEL_77] (rows=1704 width=1910) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_572] (rows=1704 width=1910) + Filter Operator [FIL_553] (rows=1704 width=1910) predicate:(s_store_sk is not null and s_store_name is not null and s_zip is not null) TableScan [TS_75] (rows=1704 width=1910) default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_store_name","s_zip"] @@ -468,9 +460,9 @@ Stage-0 <-Map 48 [SIMPLE_EDGE] SHUFFLE [RS_184] PartitionCols:_col0 - Select Operator [SEL_173] (rows=2300 width=1179) + Select Operator [SEL_45] (rows=2300 width=1179) Output:["_col0"] - Filter Operator [FIL_569] (rows=2300 width=1179) + Filter Operator [FIL_550] (rows=2300 width=1179) predicate:p_promo_sk is not null TableScan [TS_43] (rows=2300 width=1179) default@promotion,promotion,Tbl:COMPLETE,Col:NONE,Output:["p_promo_sk"] @@ -495,9 +487,9 @@ Stage-0 <-Map 47 [SIMPLE_EDGE] SHUFFLE [RS_178] PartitionCols:_col0, _col1 - Select Operator [SEL_167] (rows=57591150 width=77) + Select Operator [SEL_39] (rows=57591150 width=77) Output:["_col0","_col1"] - Filter Operator [FIL_567] (rows=57591150 width=77) + Filter Operator [FIL_548] (rows=57591150 width=77) predicate:(sr_item_sk is not null and sr_ticket_number is not null) TableScan [TS_37] (rows=57591150 width=77) default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_item_sk","sr_ticket_number"] @@ -509,18 +501,18 @@ Stage-0 <-Map 41 [SIMPLE_EDGE] SHUFFLE [RS_174] PartitionCols:_col1 - Select Operator [SEL_161] (rows=575995635 width=88) + Select Operator [SEL_33] (rows=575995635 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"] - Filter Operator [FIL_565] (rows=575995635 width=88) + Filter Operator [FIL_546] (rows=575995635 width=88) predicate:(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 and ss_customer_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_31] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,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 46 [SIMPLE_EDGE] SHUFFLE [RS_175] PartitionCols:_col0 - Select Operator [SEL_164] (rows=2851 width=1436) + Select Operator [SEL_36] (rows=2851 width=1436) Output:["_col0","_col3"] - Filter Operator [FIL_566] (rows=2851 width=1436) + Filter Operator [FIL_547] (rows=2851 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) TableScan [TS_34] (rows=462000 width=1436) default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_current_price","i_color","i_product_name"] @@ -532,19 +524,11 @@ Stage-0 <-Map 33 [SIMPLE_EDGE] SHUFFLE [RS_209] PartitionCols:_col1 - Select Operator [SEL_155] (rows=7200 width=107) - Output:["_col0","_col1"] - Filter Operator [FIL_563] (rows=7200 width=107) - predicate:(hd_demo_sk is not null and hd_income_band_sk is not null) - Please refer to the previous TableScan [TS_9] + Please refer to the previous Select Operator [SEL_11] <-Map 38 [SIMPLE_EDGE] SHUFFLE [RS_210] PartitionCols:_col0 - Select Operator [SEL_158] (rows=20 width=12) - Output:["_col0"] - Filter Operator [FIL_564] (rows=20 width=12) - predicate:ib_income_band_sk is not null - Please refer to the previous TableScan [TS_12] + Please refer to the previous Select Operator [SEL_14] <-Reducer 53 [SIMPLE_EDGE] SHUFFLE [RS_216] PartitionCols:_col0 @@ -566,18 +550,18 @@ Stage-0 <-Map 49 [SIMPLE_EDGE] SHUFFLE [RS_193] PartitionCols:_col0, _col1 - Select Operator [SEL_189] (rows=287989836 width=135) + Select Operator [SEL_61] (rows=287989836 width=135) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_570] (rows=287989836 width=135) + Filter Operator [FIL_551] (rows=287989836 width=135) predicate:(cs_order_number is not null and cs_item_sk is not null) TableScan [TS_59] (rows=287989836 width=135) default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_item_sk","cs_order_number","cs_ext_list_price"] <-Map 54 [SIMPLE_EDGE] SHUFFLE [RS_194] PartitionCols:_col0, _col1 - Select Operator [SEL_192] (rows=28798881 width=106) + Select Operator [SEL_64] (rows=28798881 width=106) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_571] (rows=28798881 width=106) + Filter Operator [FIL_552] (rows=28798881 width=106) predicate:(cr_order_number is not null and cr_item_sk is not null) TableScan [TS_62] (rows=28798881 width=106) default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:NONE,Output:["cr_item_sk","cr_order_number","cr_refunded_cash","cr_reversed_charge","cr_store_credit"] @@ -602,11 +586,7 @@ Stage-0 <-Map 40 [SIMPLE_EDGE] SHUFFLE [RS_119] PartitionCols:_col0 - Select Operator [SEL_99] (rows=1861800 width=385) - Output:["_col0","_col1"] - Filter Operator [FIL_555] (rows=1861800 width=385) - predicate:cd_demo_sk is not null - Please refer to the previous TableScan [TS_22] + Please refer to the previous Select Operator [SEL_24] <-Reducer 7 [SIMPLE_EDGE] SHUFFLE [RS_118] PartitionCols:_col39 @@ -622,11 +602,7 @@ Stage-0 <-Map 39 [SIMPLE_EDGE] SHUFFLE [RS_94] PartitionCols:_col0 - Select Operator [SEL_80] (rows=40000000 width=1014) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_554] (rows=40000000 width=1014) - predicate:ca_address_sk is not null - Please refer to the previous TableScan [TS_19] + Please refer to the previous Select Operator [SEL_21] <-Reducer 25 [SIMPLE_EDGE] SHUFFLE [RS_93] PartitionCols:_col13 @@ -635,11 +611,7 @@ Stage-0 <-Map 55 [SIMPLE_EDGE] SHUFFLE [RS_91] PartitionCols:_col0 - Select Operator [SEL_77] (rows=1704 width=1910) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_553] (rows=1704 width=1910) - predicate:(s_store_sk is not null and s_store_name is not null and s_zip is not null) - Please refer to the previous TableScan [TS_75] + Please refer to the previous Select Operator [SEL_77] <-Reducer 24 [SIMPLE_EDGE] SHUFFLE [RS_90] PartitionCols:_col14 @@ -660,11 +632,7 @@ Stage-0 <-Map 48 [SIMPLE_EDGE] SHUFFLE [RS_56] PartitionCols:_col0 - Select Operator [SEL_45] (rows=2300 width=1179) - Output:["_col0"] - Filter Operator [FIL_550] (rows=2300 width=1179) - predicate:p_promo_sk is not null - Please refer to the previous TableScan [TS_43] + Please refer to the previous Select Operator [SEL_45] <-Reducer 21 [SIMPLE_EDGE] SHUFFLE [RS_55] PartitionCols:_col7 @@ -686,11 +654,7 @@ Stage-0 <-Map 47 [SIMPLE_EDGE] SHUFFLE [RS_50] PartitionCols:_col0, _col1 - Select Operator [SEL_39] (rows=57591150 width=77) - Output:["_col0","_col1"] - Filter Operator [FIL_548] (rows=57591150 width=77) - predicate:(sr_item_sk is not null and sr_ticket_number is not null) - Please refer to the previous TableScan [TS_37] + Please refer to the previous Select Operator [SEL_39] <-Reducer 42 [SIMPLE_EDGE] SHUFFLE [RS_49] PartitionCols:_col1, _col8 @@ -699,19 +663,11 @@ Stage-0 <-Map 41 [SIMPLE_EDGE] SHUFFLE [RS_46] PartitionCols:_col1 - Select Operator [SEL_33] (rows=575995635 width=88) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"] - Filter Operator [FIL_546] (rows=575995635 width=88) - predicate:(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 and ss_customer_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) - Please refer to the previous TableScan [TS_31] + Please refer to the previous Select Operator [SEL_33] <-Map 46 [SIMPLE_EDGE] SHUFFLE [RS_47] PartitionCols:_col0 - Select Operator [SEL_36] (rows=2851 width=1436) - Output:["_col0","_col3"] - Filter Operator [FIL_547] (rows=2851 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) - Please refer to the previous TableScan [TS_34] + Please refer to the previous Select Operator [SEL_36] <-Reducer 35 [SIMPLE_EDGE] SHUFFLE [RS_84] PartitionCols:_col0 @@ -720,19 +676,11 @@ Stage-0 <-Map 33 [SIMPLE_EDGE] SHUFFLE [RS_81] PartitionCols:_col1 - Select Operator [SEL_27] (rows=7200 width=107) - Output:["_col0","_col1"] - Filter Operator [FIL_544] (rows=7200 width=107) - predicate:(hd_demo_sk is not null and hd_income_band_sk is not null) - Please refer to the previous TableScan [TS_9] + Please refer to the previous Select Operator [SEL_11] <-Map 38 [SIMPLE_EDGE] SHUFFLE [RS_82] PartitionCols:_col0 - Select Operator [SEL_30] (rows=20 width=12) - Output:["_col0"] - Filter Operator [FIL_545] (rows=20 width=12) - predicate:ib_income_band_sk is not null - Please refer to the previous TableScan [TS_12] + Please refer to the previous Select Operator [SEL_14] <-Reducer 51 [SIMPLE_EDGE] SHUFFLE [RS_88] PartitionCols:_col0 @@ -754,19 +702,11 @@ Stage-0 <-Map 49 [SIMPLE_EDGE] SHUFFLE [RS_65] PartitionCols:_col0, _col1 - Select Operator [SEL_61] (rows=287989836 width=135) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_551] (rows=287989836 width=135) - predicate:(cs_order_number is not null and cs_item_sk is not null) - Please refer to the previous TableScan [TS_59] + Please refer to the previous Select Operator [SEL_61] <-Map 54 [SIMPLE_EDGE] SHUFFLE [RS_66] PartitionCols:_col0, _col1 - Select Operator [SEL_64] (rows=28798881 width=106) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_552] (rows=28798881 width=106) - predicate:(cr_order_number is not null and cr_item_sk is not null) - Please refer to the previous TableScan [TS_62] + Please refer to the previous Select Operator [SEL_64] <-Reducer 6 [SIMPLE_EDGE] SHUFFLE [RS_115] PartitionCols:_col0 @@ -775,11 +715,7 @@ Stage-0 <-Map 40 [SIMPLE_EDGE] SHUFFLE [RS_113] PartitionCols:_col0 - Select Operator [SEL_24] (rows=1861800 width=385) - Output:["_col0","_col1"] - Filter Operator [FIL_543] (rows=1861800 width=385) - predicate:cd_demo_sk is not null - Please refer to the previous TableScan [TS_22] + Please refer to the previous Select Operator [SEL_24] <-Reducer 5 [SIMPLE_EDGE] SHUFFLE [RS_112] PartitionCols:_col1 @@ -788,11 +724,7 @@ Stage-0 <-Map 39 [SIMPLE_EDGE] SHUFFLE [RS_110] PartitionCols:_col0 - Select Operator [SEL_21] (rows=40000000 width=1014) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_542] (rows=40000000 width=1014) - predicate:ca_address_sk is not null - Please refer to the previous TableScan [TS_19] + Please refer to the previous Select Operator [SEL_21] <-Reducer 4 [SIMPLE_EDGE] SHUFFLE [RS_109] PartitionCols:_col3 @@ -806,9 +738,9 @@ Stage-0 <-Map 20 [SIMPLE_EDGE] SHUFFLE [RS_104] PartitionCols:_col0 - Select Operator [SEL_8] (rows=73049 width=1119) + Select Operator [SEL_5] (rows=73049 width=1119) Output:["_col0","_col1"] - Filter Operator [FIL_539] (rows=73049 width=1119) + Filter Operator [FIL_538] (rows=73049 width=1119) predicate:d_date_sk is not null Please refer to the previous TableScan [TS_3] <-Reducer 2 [SIMPLE_EDGE] @@ -819,19 +751,11 @@ Stage-0 <-Map 20 [SIMPLE_EDGE] SHUFFLE [RS_101] PartitionCols:_col0 - Select Operator [SEL_5] (rows=73049 width=1119) - Output:["_col0","_col1"] - Filter Operator [FIL_538] (rows=73049 width=1119) - predicate:d_date_sk is not null - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_100] PartitionCols:_col5 - Select Operator [SEL_2] (rows=80000000 width=860) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_537] (rows=80000000 width=860) - predicate:(c_customer_sk is not null and c_first_shipto_date_sk is not null and c_first_sales_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) - Please refer to the previous TableScan [TS_0] + Please refer to the previous Select Operator [SEL_2] <-Reducer 34 [SIMPLE_EDGE] SHUFFLE [RS_107] PartitionCols:_col0 @@ -840,17 +764,9 @@ Stage-0 <-Map 33 [SIMPLE_EDGE] SHUFFLE [RS_15] PartitionCols:_col1 - Select Operator [SEL_11] (rows=7200 width=107) - Output:["_col0","_col1"] - Filter Operator [FIL_540] (rows=7200 width=107) - predicate:(hd_demo_sk is not null and hd_income_band_sk is not null) - Please refer to the previous TableScan [TS_9] + Please refer to the previous Select Operator [SEL_11] <-Map 38 [SIMPLE_EDGE] SHUFFLE [RS_16] PartitionCols:_col0 - Select Operator [SEL_14] (rows=20 width=12) - Output:["_col0"] - Filter Operator [FIL_541] (rows=20 width=12) - predicate:ib_income_band_sk is not null - Please refer to the previous TableScan [TS_12] + Please refer to the previous Select Operator [SEL_14] http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/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 b2035c2..1b32ed6 100644 --- a/ql/src/test/results/clientpositive/perf/query65.q.out +++ b/ql/src/test/results/clientpositive/perf/query65.q.out @@ -165,9 +165,5 @@ Stage-0 <-Map 9 [SIMPLE_EDGE] SHUFFLE [RS_21] PartitionCols:_col0 - Select Operator [SEL_19] (rows=8116 width=1119) - Output:["_col0"] - Filter Operator [FIL_75] (rows=8116 width=1119) - predicate:(d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null) - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/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 2c74815..9a37cf3 100644 --- a/ql/src/test/results/clientpositive/perf/query66.q.out +++ b/ql/src/test/results/clientpositive/perf/query66.q.out @@ -494,9 +494,9 @@ Stage-0 <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_58] PartitionCols:_col0 - Select Operator [SEL_47] (rows=27 width=1029) + Select Operator [SEL_14] (rows=27 width=1029) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - Filter Operator [FIL_115] (rows=27 width=1029) + Filter Operator [FIL_110] (rows=27 width=1029) predicate:w_warehouse_sk is not null TableScan [TS_12] (rows=27 width=1029) default@warehouse,warehouse,Tbl:COMPLETE,Col:NONE,Output:["w_warehouse_sk","w_warehouse_name","w_warehouse_sq_ft","w_city","w_county","w_state","w_country"] @@ -508,9 +508,9 @@ Stage-0 <-Map 17 [SIMPLE_EDGE] SHUFFLE [RS_55] PartitionCols:_col0 - Select Operator [SEL_44] (rows=1 width=0) + Select Operator [SEL_11] (rows=1 width=0) Output:["_col0"] - Filter Operator [FIL_114] (rows=1 width=0) + Filter Operator [FIL_109] (rows=1 width=0) predicate:((sm_carrier) IN ('DIAMOND', 'AIRBORNE') and sm_ship_mode_sk is not null) TableScan [TS_9] (rows=1 width=0) default@ship_mode,ship_mode,Tbl:PARTIAL,Col:NONE,Output:["sm_ship_mode_sk","sm_carrier"] @@ -522,9 +522,9 @@ Stage-0 <-Map 16 [SIMPLE_EDGE] SHUFFLE [RS_52] PartitionCols:_col0 - Select Operator [SEL_41] (rows=36524 width=1119) + Select Operator [SEL_8] (rows=36524 width=1119) Output:["_col0","_col2"] - Filter Operator [FIL_113] (rows=36524 width=1119) + Filter Operator [FIL_108] (rows=36524 width=1119) predicate:((d_year = 2002) 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"] @@ -536,9 +536,9 @@ Stage-0 <-Map 10 [SIMPLE_EDGE] SHUFFLE [RS_49] PartitionCols:_col0 - Select Operator [SEL_38] (rows=9600 width=471) + Select Operator [SEL_5] (rows=9600 width=471) Output:["_col0"] - Filter Operator [FIL_112] (rows=9600 width=471) + Filter Operator [FIL_107] (rows=9600 width=471) predicate:(t_time BETWEEN 49530 AND 78330 and t_time_sk is not null) TableScan [TS_3] (rows=86400 width=471) default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_time"] @@ -572,11 +572,7 @@ Stage-0 <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_25] PartitionCols:_col0 - Select Operator [SEL_14] (rows=27 width=1029) - Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - Filter Operator [FIL_110] (rows=27 width=1029) - predicate:w_warehouse_sk is not null - Please refer to the previous TableScan [TS_12] + Please refer to the previous Select Operator [SEL_14] <-Reducer 4 [SIMPLE_EDGE] SHUFFLE [RS_24] PartitionCols:_col3 @@ -585,11 +581,7 @@ Stage-0 <-Map 17 [SIMPLE_EDGE] SHUFFLE [RS_22] PartitionCols:_col0 - Select Operator [SEL_11] (rows=1 width=0) - Output:["_col0"] - Filter Operator [FIL_109] (rows=1 width=0) - predicate:((sm_carrier) IN ('DIAMOND', 'AIRBORNE') and sm_ship_mode_sk is not null) - Please refer to the previous TableScan [TS_9] + Please refer to the previous Select Operator [SEL_11] <-Reducer 3 [SIMPLE_EDGE] SHUFFLE [RS_21] PartitionCols:_col2 @@ -598,11 +590,7 @@ Stage-0 <-Map 16 [SIMPLE_EDGE] SHUFFLE [RS_19] PartitionCols:_col0 - Select Operator [SEL_8] (rows=36524 width=1119) - Output:["_col0","_col2"] - Filter Operator [FIL_108] (rows=36524 width=1119) - predicate:((d_year = 2002) and d_date_sk is not null) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_18] PartitionCols:_col0 @@ -611,11 +599,7 @@ Stage-0 <-Map 10 [SIMPLE_EDGE] SHUFFLE [RS_16] PartitionCols:_col0 - Select Operator [SEL_5] (rows=9600 width=471) - Output:["_col0"] - Filter Operator [FIL_107] (rows=9600 width=471) - predicate:(t_time BETWEEN 49530 AND 78330 and t_time_sk is not null) - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_15] PartitionCols:_col1 http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/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 bd9b5ec..5f763d5 100644 --- a/ql/src/test/results/clientpositive/perf/query68.q.out +++ b/ql/src/test/results/clientpositive/perf/query68.q.out @@ -150,11 +150,7 @@ Stage-0 <-Map 5 [SIMPLE_EDGE] SHUFFLE [RS_31] PartitionCols:_col0 - Select Operator [SEL_20] (rows=40000000 width=1014) - Output:["_col0","_col1"] - Filter Operator [FIL_80] (rows=40000000 width=1014) - predicate:ca_address_sk is not null - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] <-Reducer 11 [SIMPLE_EDGE] SHUFFLE [RS_30] PartitionCols:_col3 http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/ql/src/test/results/clientpositive/perf/query69.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/query69.q.out b/ql/src/test/results/clientpositive/perf/query69.q.out index a55c368..2769bc5 100644 --- a/ql/src/test/results/clientpositive/perf/query69.q.out +++ b/ql/src/test/results/clientpositive/perf/query69.q.out @@ -150,9 +150,9 @@ Stage-0 <-Map 13 [SIMPLE_EDGE] SHUFFLE [RS_57] PartitionCols:_col0 - Select Operator [SEL_55] (rows=4058 width=1119) + Select Operator [SEL_14] (rows=4058 width=1119) Output:["_col0"] - Filter Operator [FIL_107] (rows=4058 width=1119) + Filter Operator [FIL_103] (rows=4058 width=1119) predicate:((d_year = 1999) and d_moy BETWEEN 1 AND 3 and d_date_sk is not null) TableScan [TS_12] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"] @@ -193,11 +193,7 @@ Stage-0 <-Map 13 [SIMPLE_EDGE] SHUFFLE [RS_16] PartitionCols:_col0 - Select Operator [SEL_14] (rows=4058 width=1119) - Output:["_col0"] - Filter Operator [FIL_103] (rows=4058 width=1119) - predicate:((d_year = 1999) and d_moy BETWEEN 1 AND 3 and d_date_sk is not null) - Please refer to the previous TableScan [TS_12] + Please refer to the previous Select Operator [SEL_14] <-Map 10 [SIMPLE_EDGE] SHUFFLE [RS_15] PartitionCols:_col0 @@ -222,11 +218,7 @@ Stage-0 <-Map 13 [SIMPLE_EDGE] SHUFFLE [RS_30] PartitionCols:_col0 - Select Operator [SEL_28] (rows=4058 width=1119) - Output:["_col0"] - Filter Operator [FIL_105] (rows=4058 width=1119) - predicate:((d_year = 1999) and d_moy BETWEEN 1 AND 3 and d_date_sk is not null) - Please refer to the previous TableScan [TS_12] + Please refer to the previous Select Operator [SEL_14] <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_29] PartitionCols:_col0 http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/ql/src/test/results/clientpositive/perf/query70.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/query70.q.out b/ql/src/test/results/clientpositive/perf/query70.q.out index ee1fe86..9f9a8e1 100644 --- a/ql/src/test/results/clientpositive/perf/query70.q.out +++ b/ql/src/test/results/clientpositive/perf/query70.q.out @@ -160,18 +160,18 @@ Stage-0 <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_18] PartitionCols:_col0 - Select Operator [SEL_11] (rows=575995635 width=88) + Select Operator [SEL_2] (rows=575995635 width=88) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_82] (rows=575995635 width=88) - predicate:(ss_store_sk is not null and ss_sold_date_sk is not null) + Filter Operator [FIL_78] (rows=575995635 width=88) + predicate:(ss_sold_date_sk is not null and ss_store_sk is not null) TableScan [TS_0] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_store_sk","ss_net_profit"] <-Map 12 [SIMPLE_EDGE] SHUFFLE [RS_19] PartitionCols:_col0 - Select Operator [SEL_14] (rows=8116 width=1119) + Select Operator [SEL_5] (rows=8116 width=1119) Output:["_col0"] - Filter Operator [FIL_83] (rows=8116 width=1119) + Filter Operator [FIL_79] (rows=8116 width=1119) predicate:(d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"] @@ -197,17 +197,9 @@ Stage-0 <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_37] PartitionCols:_col0 - Select Operator [SEL_2] (rows=575995635 width=88) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_78] (rows=575995635 width=88) - predicate:(ss_sold_date_sk is not null and ss_store_sk is not null) - Please refer to the previous TableScan [TS_0] + Please refer to the previous Select Operator [SEL_2] <-Map 12 [SIMPLE_EDGE] SHUFFLE [RS_38] PartitionCols:_col0 - Select Operator [SEL_5] (rows=8116 width=1119) - Output:["_col0"] - Filter Operator [FIL_79] (rows=8116 width=1119) - predicate:(d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null) - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/ql/src/test/results/clientpositive/perf/query74.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/query74.q.out b/ql/src/test/results/clientpositive/perf/query74.q.out index 50d97e7..9dddd6a 100644 --- a/ql/src/test/results/clientpositive/perf/query74.q.out +++ b/ql/src/test/results/clientpositive/perf/query74.q.out @@ -173,9 +173,9 @@ Stage-0 <-Map 17 [SIMPLE_EDGE] SHUFFLE [RS_33] PartitionCols:_col0 - Select Operator [SEL_28] (rows=80000000 width=860) + Select Operator [SEL_8] (rows=80000000 width=860) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_154] (rows=80000000 width=860) + Filter Operator [FIL_151] (rows=80000000 width=860) predicate:(c_customer_sk is not null and c_customer_id is not null) TableScan [TS_6] (rows=80000000 width=860) default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_customer_id","c_first_name","c_last_name"] @@ -219,11 +219,7 @@ Stage-0 <-Map 17 [SIMPLE_EDGE] SHUFFLE [RS_75] PartitionCols:_col0 - Select Operator [SEL_70] (rows=80000000 width=860) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_160] (rows=80000000 width=860) - predicate:(c_customer_sk is not null and c_customer_id is not null) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 14 [SIMPLE_EDGE] SHUFFLE [RS_74] PartitionCols:_col1 @@ -240,11 +236,7 @@ Stage-0 <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_71] PartitionCols:_col0 - Select Operator [SEL_64] (rows=575995635 width=88) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_158] (rows=575995635 width=88) - predicate:(ss_customer_sk is not null and ss_sold_date_sk is not null) - Please refer to the previous TableScan [TS_20] + Please refer to the previous Select Operator [SEL_22] <-Reducer 4 [SIMPLE_EDGE] SHUFFLE [RS_82] PartitionCols:_col0 @@ -262,11 +254,7 @@ Stage-0 <-Map 17 [SIMPLE_EDGE] SHUFFLE [RS_13] PartitionCols:_col0 - Select Operator [SEL_8] (rows=80000000 width=860) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_151] (rows=80000000 width=860) - predicate:(c_customer_sk is not null and c_customer_id is not null) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_12] PartitionCols:_col1 @@ -308,11 +296,7 @@ Stage-0 <-Map 17 [SIMPLE_EDGE] SHUFFLE [RS_54] PartitionCols:_col0 - Select Operator [SEL_49] (rows=80000000 width=860) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_157] (rows=80000000 width=860) - predicate:(c_customer_sk is not null and c_customer_id is not null) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 7 [SIMPLE_EDGE] SHUFFLE [RS_53] PartitionCols:_col1 @@ -329,9 +313,5 @@ Stage-0 <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_50] PartitionCols:_col0 - Select Operator [SEL_43] (rows=144002668 width=135) - Output:["_col0","_col1","_col2"] - Filter Operator [FIL_155] (rows=144002668 width=135) - predicate:(ws_bill_customer_sk is not null and ws_sold_date_sk is not null) - Please refer to the previous TableScan [TS_0] + Please refer to the previous Select Operator [SEL_2] http://git-wip-us.apache.org/repos/asf/hive/blob/7819cd36/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 d399567..c3dfff5 100644 --- a/ql/src/test/results/clientpositive/perf/query75.q.out +++ b/ql/src/test/results/clientpositive/perf/query75.q.out @@ -212,9 +212,9 @@ Stage-0 <-Map 32 [SIMPLE_EDGE] SHUFFLE [RS_104] PartitionCols:_col0, _col1 - Select Operator [SEL_96] (rows=28798881 width=106) + Select Operator [SEL_11] (rows=28798881 width=106) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_255] (rows=28798881 width=106) + Filter Operator [FIL_243] (rows=28798881 width=106) predicate:cr_item_sk is not null TableScan [TS_9] (rows=28798881 width=106) default@catalog_returns,catalog_returns,Tbl:COMPLETE,Col:NONE,Output:["cr_item_sk","cr_order_number","cr_return_quantity","cr_return_amount"] @@ -226,9 +226,9 @@ Stage-0 <-Map 31 [SIMPLE_EDGE] SHUFFLE [RS_101] PartitionCols:_col0 - Select Operator [SEL_93] (rows=231000 width=1436) + Select Operator [SEL_8] (rows=231000 width=1436) Output:["_col0","_col1","_col2","_col3","_col5"] - Filter Operator [FIL_254] (rows=231000 width=1436) + Filter Operator [FIL_242] (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) TableScan [TS_6] (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"] @@ -249,9 +249,9 @@ Stage-0 <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_97] PartitionCols:_col0 - Select Operator [SEL_87] (rows=287989836 width=135) + Select Operator [SEL_2] (rows=287989836 width=135) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_252] (rows=287989836 width=135) + Filter Operator [FIL_240] (rows=287989836 width=135) predicate:(cs_item_sk is not null and cs_sold_date_sk is not null) TableScan [TS_0] (rows=287989836 width=135) default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_item_sk","cs_order_number","cs_quantity","cs_ext_sales_price"] @@ -267,9 +267,9 @@ Stage-0 <-Map 34 [SIMPLE_EDGE] SHUFFLE [RS_126] PartitionCols:_col0, _col1 - Select Operator [SEL_118] (rows=57591150 width=77) + Select Operator [SEL_33] (rows=57591150 width=77) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_259] (rows=57591150 width=77) + Filter Operator [FIL_247] (rows=57591150 width=77) predicate:sr_item_sk is not null TableScan [TS_31] (rows=57591150 width=77) default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_item_sk","sr_ticket_number","sr_return_quantity","sr_return_amt"] @@ -281,11 +281,7 @@ Stage-0 <-Map 31 [SIMPLE_EDGE] SHUFFLE [RS_123] PartitionCols:_col0 - Select Operator [SEL_115] (rows=231000 width=1436) - Output:["_col0","_col1","_col2","_col3","_col5"] - Filter Operator [FIL_258] (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) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 25 [SIMPLE_EDGE] SHUFFLE [RS_122] PartitionCols:_col1 @@ -302,9 +298,9 @@ Stage-0 <-Map 33 [SIMPLE_EDGE] SHUFFLE [RS_119] PartitionCols:_col0 - Select Operator [SEL_109] (rows=575995635 width=88) + Select Operator [SEL_24] (rows=575995635 width=88) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_256] (rows=575995635 width=88) + Filter Operator [FIL_244] (rows=575995635 width=88) predicate:(ss_item_sk is not null and ss_sold_date_sk is not null) TableScan [TS_22] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_ticket_number","ss_quantity","ss_ext_sales_price"] @@ -320,9 +316,9 @@ Stage-0 <-Map 36 [SIMPLE_EDGE] SHUFFLE [RS_155] PartitionCols:_col0, _col1 - Select Operator [SEL_147] (rows=14398467 width=92) + Select Operator [SEL_62] (rows=14398467 width=92) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_263] (rows=14398467 width=92) + Filter Operator [FIL_251] (rows=14398467 width=92) predicate:wr_item_sk is not null TableScan [TS_60] (rows=14398467 width=92) default@web_returns,web_returns,Tbl:COMPLETE,Col:NONE,Output:["wr_item_sk","wr_order_number","wr_return_quantity","wr_return_amt"] @@ -334,11 +330,7 @@ Stage-0 <-Map 31 [SIMPLE_EDGE] SHUFFLE [RS_152] PartitionCols:_col0 - Select Operator [SEL_144] (rows=231000 width=1436) - Output:["_col0","_col1","_col2","_col3","_col5"] - Filter Operator [FIL_262] (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) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 28 [SIMPLE_EDGE] SHUFFLE [RS_151] PartitionCols:_col1 @@ -355,9 +347,9 @@ Stage-0 <-Map 35 [SIMPLE_EDGE] SHUFFLE [RS_148] PartitionCols:_col0 - Select Operator [SEL_138] (rows=144002668 width=135) + Select Operator [SEL_53] (rows=144002668 width=135) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_260] (rows=144002668 width=135) + Filter Operator [FIL_248] (rows=144002668 width=135) predicate:(ws_item_sk is not null and ws_sold_date_sk is not null) TableScan [TS_51] (rows=144002668 width=135) default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_order_number","ws_quantity","ws_ext_sales_price"] @@ -381,11 +373,7 @@ Stage-0 <-Map 36 [SIMPLE_EDGE] SHUFFLE [RS_70] PartitionCols:_col0, _col1 - Select Operator [SEL_62] (rows=14398467 width=92) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_251] (rows=14398467 width=92) - predicate:wr_item_sk is not null - Please refer to the previous TableScan [TS_60] + Please refer to the previous Select Operator [SEL_62] <-Reducer 23 [SIMPLE_EDGE] SHUFFLE [RS_69] PartitionCols:_col1, _col2 @@ -394,11 +382,7 @@ Stage-0 <-Map 31 [SIMPLE_EDGE] SHUFFLE [RS_67] PartitionCols:_col0 - Select Operator [SEL_59] (rows=231000 width=1436) - Output:["_col0","_col1","_col2","_col3","_col5"] - Filter Operator [FIL_250] (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) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 22 [SIMPLE_EDGE] SHUFFLE [RS_66] PartitionCols:_col1 @@ -407,19 +391,15 @@ Stage-0 <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_64] PartitionCols:_col0 - Select Operator [SEL_56] (rows=36524 width=1119) + Select Operator [SEL_5] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_249] (rows=36524 width=1119) + Filter Operator [FIL_241] (rows=36524 width=1119) predicate:((d_year = 2001) and d_date_sk is not null) Please refer to the previous TableScan [TS_3] <-Map 35 [SIMPLE_EDGE] SHUFFLE [RS_63] PartitionCols:_col0 - Select Operator [SEL_53] (rows=144002668 width=135) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_248] (rows=144002668 width=135) - predicate:(ws_item_sk is not null and ws_sold_date_sk is not null) - Please refer to the previous TableScan [TS_51] + Please refer to the previous Select Operator [SEL_53] <-Reducer 6 [CONTAINS] Reduce Output Operator [RS_77] PartitionCols:_col0, _col1, _col2, _col3 @@ -440,11 +420,7 @@ Stage-0 <-Map 34 [SIMPLE_EDGE] SHUFFLE [RS_41] PartitionCols:_col0, _col1 - Select Operator [SEL_33] (rows=57591150 width=77) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_247] (rows=57591150 width=77) - predicate:sr_item_sk is not null - Please refer to the previous TableScan [TS_31] + Please refer to the previous Select Operator [SEL_33] <-Reducer 20 [SIMPLE_EDGE] SHUFFLE [RS_40] PartitionCols:_col1, _col2 @@ -453,11 +429,7 @@ Stage-0 <-Map 31 [SIMPLE_EDGE] SHUFFLE [RS_38] PartitionCols:_col0 - Select Operator [SEL_30] (rows=231000 width=1436) - Output:["_col0","_col1","_col2","_col3","_col5"] - Filter Operator [FIL_246] (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) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 19 [SIMPLE_EDGE] SHUFFLE [RS_37] PartitionCols:_col1 @@ -466,19 +438,11 @@ Stage-0 <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_35] PartitionCols:_col0 - Select Operator [SEL_27] (rows=36524 width=1119) - Output:["_col0"] - Filter Operator [FIL_245] (rows=36524 width=1119) - predicate:((d_year = 2001) and d_date_sk is not null) - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] <-Map 33 [SIMPLE_EDGE] SHUFFLE [RS_34] PartitionCols:_col0 - Select Operator [SEL_24] (rows=575995635 width=88) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_244] (rows=575995635 width=88) - predicate:(ss_item_sk is not null and ss_sold_date_sk is not null) - Please refer to the previous TableScan [TS_22] + Please refer to the previous Select Operator [SEL_24] <-Reducer 4 [CONTAINS] Reduce Output Operator [RS_48] PartitionCols:_col0, _col1, _col2, _col3, _col4, _col5 @@ -491,11 +455,7 @@ Stage-0 <-Map 32 [SIMPLE_EDGE] SHUFFLE [RS_19] PartitionCols:_col0, _col1 - Select Operator [SEL_11] (rows=28798881 width=106) - Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_243] (rows=28798881 width=106) - predicate:cr_item_sk is not null - Please refer to the previous TableScan [TS_9] + Please refer to the previous Select Operator [SEL_11] <-Reducer 3 [SIMPLE_EDGE] SHUFFLE [RS_18] PartitionCols:_col1, _col2 @@ -504,11 +464,7 @@ Stage-0 <-Map 31 [SIMPLE_EDGE] SHUFFLE [RS_16] PartitionCols:_col0 - Select Operator [SEL_8] (rows=231000 width=1436) - Output:["_col0","_col1","_col2","_col3","_col5"] - Filter Operator [FIL_242] (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) - Please refer to the previous TableScan [TS_6] + Please refer to the previous Select Operator [SEL_8] <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_15] PartitionCols:_col1 @@ -517,17 +473,9 @@ Stage-0 <-Map 18 [SIMPLE_EDGE] SHUFFLE [RS_13] PartitionCols:_col0 - Select Operator [SEL_5] (rows=36524 width=1119) - Output:["_col0"] - Filter Operator [FIL_241] (rows=36524 width=1119) - predicate:((d_year = 2001) and d_date_sk is not null) - Please refer to the previous TableScan [TS_3] + Please refer to the previous Select Operator [SEL_5] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_12] PartitionCols:_col0 - Select Operator [SEL_2] (rows=287989836 width=135) - Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_240] (rows=287989836 width=135) - predicate:(cs_item_sk is not null and cs_sold_date_sk is not null) - Please refer to the previous TableScan [TS_0] + Please refer to the previous Select Operator [SEL_2]