hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [01/15] hive git commit: HIVE-13542 : Missing stats for tables in TPCDS performance regression suite (Hari Subramaniyan via Ashutosh Chauhan)
Date Fri, 06 May 2016 20:55:53 GMT
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"]
 


Mime
View raw message