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 ACBB72009FB for ; Fri, 6 May 2016 22:55:55 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id AB4EE160A13; Fri, 6 May 2016 20:55:55 +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 A4E3E1608F8 for ; Fri, 6 May 2016 22:55:54 +0200 (CEST) Received: (qmail 9474 invoked by uid 500); 6 May 2016 20:55:53 -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 9460 invoked by uid 99); 6 May 2016 20:55:53 -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; Fri, 06 May 2016 20:55:53 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id AF9B3DFE61; Fri, 6 May 2016 20:55:53 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: hashutosh@apache.org To: commits@hive.apache.org Date: Fri, 06 May 2016 20:55:53 -0000 Message-Id: X-Mailer: ASF-Git Admin Mailer Subject: [01/15] hive git commit: HIVE-13542 : Missing stats for tables in TPCDS performance regression suite (Hari Subramaniyan via Ashutosh Chauhan) archived-at: Fri, 06 May 2016 20:55:55 -0000 Repository: hive Updated Branches: refs/heads/master 92a9ae800 -> db8a6db99 http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query97.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/query97.q.out b/ql/src/test/results/clientpositive/perf/query97.q.out index 2f610bd..5dcd341 100644 --- a/ql/src/test/results/clientpositive/perf/query97.q.out +++ b/ql/src/test/results/clientpositive/perf/query97.q.out @@ -26,33 +26,33 @@ Stage-0 SHUFFLE [RS_34] Group By Operator [GBY_33] (rows=1 width=24) Output:["_col0","_col1","_col2"],aggregations:["sum(_col0)","sum(_col1)","sum(_col2)"] - Select Operator [SEL_31] (rows=22096 width=1119) + Select Operator [SEL_31] (rows=348477374 width=88) Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_49] (rows=22096 width=1119) + Merge Join Operator [MERGEJOIN_49] (rows=348477374 width=88) Conds:RS_28._col0, _col1=RS_29._col0, _col1(Outer),Output:["_col0","_col2"] <-Reducer 3 [SIMPLE_EDGE] SHUFFLE [RS_28] PartitionCols:_col0, _col1 - Select Operator [SEL_13] (rows=20088 width=1119) + Select Operator [SEL_13] (rows=316797606 width=88) Output:["_col0","_col1"] - Group By Operator [GBY_12] (rows=20088 width=1119) + Group By Operator [GBY_12] (rows=316797606 width=88) Output:["_col0","_col1"],keys:KEY._col0, KEY._col1 <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_11] PartitionCols:_col0, _col1 - Group By Operator [GBY_10] (rows=40176 width=1119) + Group By Operator [GBY_10] (rows=633595212 width=88) Output:["_col0","_col1"],keys:_col1, _col2 - Merge Join Operator [MERGEJOIN_47] (rows=40176 width=1119) + Merge Join Operator [MERGEJOIN_47] (rows=633595212 width=88) Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col1","_col2"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_6] PartitionCols:_col0 - Select Operator [SEL_2] (rows=1 width=0) + Select Operator [SEL_2] (rows=575995635 width=88) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_43] (rows=1 width=0) + Filter Operator [FIL_43] (rows=575995635 width=88) predicate:ss_sold_date_sk is not null - TableScan [TS_0] (rows=1 width=0) - default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk"] + TableScan [TS_0] (rows=575995635 width=88) + default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk"] <-Map 6 [SIMPLE_EDGE] SHUFFLE [RS_7] PartitionCols:_col0 @@ -65,14 +65,14 @@ Stage-0 <-Reducer 9 [SIMPLE_EDGE] SHUFFLE [RS_29] PartitionCols:_col0, _col1 - Group By Operator [GBY_26] (rows=20088 width=1119) + Group By Operator [GBY_26] (rows=158394413 width=135) Output:["_col0","_col1"],keys:KEY._col0, KEY._col1 <-Reducer 8 [SIMPLE_EDGE] SHUFFLE [RS_25] PartitionCols:_col0, _col1 - Group By Operator [GBY_24] (rows=40176 width=1119) + Group By Operator [GBY_24] (rows=316788826 width=135) Output:["_col0","_col1"],keys:_col1, _col2 - Merge Join Operator [MERGEJOIN_48] (rows=40176 width=1119) + Merge Join Operator [MERGEJOIN_48] (rows=316788826 width=135) Conds:RS_20._col0=RS_21._col0(Inner),Output:["_col1","_col2"] <-Map 10 [SIMPLE_EDGE] SHUFFLE [RS_21] @@ -86,10 +86,10 @@ Stage-0 <-Map 7 [SIMPLE_EDGE] SHUFFLE [RS_20] PartitionCols:_col0 - Select Operator [SEL_16] (rows=1 width=0) + Select Operator [SEL_16] (rows=287989836 width=135) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_45] (rows=1 width=0) + Filter Operator [FIL_45] (rows=287989836 width=135) predicate:cs_sold_date_sk is not null - TableScan [TS_14] (rows=1 width=0) - default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk"] + TableScan [TS_14] (rows=287989836 width=135) + default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk"] http://git-wip-us.apache.org/repos/asf/hive/blob/db8a6db9/ql/src/test/results/clientpositive/perf/query98.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/query98.q.out b/ql/src/test/results/clientpositive/perf/query98.q.out index fc4b7a3..484f3c6 100644 --- a/ql/src/test/results/clientpositive/perf/query98.q.out +++ b/ql/src/test/results/clientpositive/perf/query98.q.out @@ -17,62 +17,62 @@ Stage-0 Stage-1 Reducer 6 File Output Operator [FS_27] - Select Operator [SEL_26] (rows=139755 width=1436) + Select Operator [SEL_26] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] <-Reducer 5 [SIMPLE_EDGE] SHUFFLE [RS_25] - Select Operator [SEL_23] (rows=139755 width=1436) + Select Operator [SEL_23] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - PTF Operator [PTF_22] (rows=139755 width=1436) + PTF Operator [PTF_22] (rows=348477374 width=88) Function definitions:[{},{"name:":"windowingtablefunction","order by:":"_col3 ASC NULLS FIRST","partition by:":"_col3"}] - Select Operator [SEL_21] (rows=139755 width=1436) + Select Operator [SEL_21] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] <-Reducer 4 [SIMPLE_EDGE] SHUFFLE [RS_20] PartitionCols:_col3 - Select Operator [SEL_19] (rows=139755 width=1436) + Select Operator [SEL_19] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Group By Operator [GBY_18] (rows=139755 width=1436) + Group By Operator [GBY_18] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4 <-Reducer 3 [SIMPLE_EDGE] SHUFFLE [RS_17] PartitionCols:_col0, _col1, _col2, _col3, _col4 - Group By Operator [GBY_16] (rows=279510 width=1436) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)"],keys:_col4, _col5, _col6, _col7, _col8 - Select Operator [SEL_15] (rows=279510 width=1436) - Output:["_col4","_col5","_col6","_col7","_col8","_col2"] - Merge Join Operator [MERGEJOIN_37] (rows=279510 width=1436) - Conds:RS_12._col0=RS_13._col0(Inner),Output:["_col2","_col4","_col5","_col6","_col7","_col8"] + Group By Operator [GBY_16] (rows=696954748 width=88) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)"],keys:_col6, _col7, _col8, _col9, _col10 + Select Operator [SEL_15] (rows=696954748 width=88) + Output:["_col6","_col7","_col8","_col9","_col10","_col2"] + Merge Join Operator [MERGEJOIN_37] (rows=696954748 width=88) + Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10"] <-Map 8 [SIMPLE_EDGE] SHUFFLE [RS_13] PartitionCols:_col0 - Select Operator [SEL_8] (rows=36524 width=1119) - Output:["_col0"] - Filter Operator [FIL_35] (rows=36524 width=1119) - predicate:(d_date BETWEEN 2001-01-12 AND 2001-02-11 and d_date_sk is not null) - TableScan [TS_6] (rows=73049 width=1119) - default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"] + Select Operator [SEL_8] (rows=231000 width=1436) + Output:["_col0","_col1","_col2","_col3","_col4","_col5"] + Filter Operator [FIL_35] (rows=231000 width=1436) + predicate:((i_category) IN ('Jewelry', 'Sports', 'Books') and i_item_sk is not null) + TableScan [TS_6] (rows=462000 width=1436) + default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_item_id","i_item_desc","i_current_price","i_class","i_category"] <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_12] - PartitionCols:_col0 - Merge Join Operator [MERGEJOIN_36] (rows=254100 width=1436) - Conds:RS_9._col1=RS_10._col0(Inner),Output:["_col0","_col2","_col4","_col5","_col6","_col7","_col8"] + PartitionCols:_col1 + Merge Join Operator [MERGEJOIN_36] (rows=633595212 width=88) + Conds:RS_9._col0=RS_10._col0(Inner),Output:["_col1","_col2"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_9] - PartitionCols:_col1 - Select Operator [SEL_2] (rows=1 width=0) + PartitionCols:_col0 + Select Operator [SEL_2] (rows=575995635 width=88) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_33] (rows=1 width=0) + Filter Operator [FIL_33] (rows=575995635 width=88) predicate:(ss_item_sk is not null and ss_sold_date_sk is not null) - TableScan [TS_0] (rows=1 width=0) - default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_ext_sales_price"] + TableScan [TS_0] (rows=575995635 width=88) + default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_ext_sales_price"] <-Map 7 [SIMPLE_EDGE] SHUFFLE [RS_10] PartitionCols:_col0 - Select Operator [SEL_5] (rows=231000 width=1436) - Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_34] (rows=231000 width=1436) - predicate:((i_category) IN ('Jewelry', 'Sports', 'Books') and i_item_sk is not null) - TableScan [TS_3] (rows=462000 width=1436) - default@item,item,Tbl:COMPLETE,Col:NONE,Output:["i_item_sk","i_item_id","i_item_desc","i_current_price","i_class","i_category"] + Select Operator [SEL_5] (rows=36524 width=1119) + Output:["_col0"] + Filter Operator [FIL_34] (rows=36524 width=1119) + predicate:(d_date BETWEEN 2001-01-12 AND 2001-02-11 and d_date_sk is not null) + TableScan [TS_3] (rows=73049 width=1119) + default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date"]