http://git-wip-us.apache.org/repos/asf/hive/blob/230cc4bb/ql/src/test/results/clientpositive/perf/tez/query1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query1.q.out b/ql/src/test/results/clientpositive/perf/tez/query1.q.out index cbdd09a..eb1f83c 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query1.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query1.q.out @@ -62,11 +62,11 @@ Stage-0 Fetch Operator limit:100 Stage-1 - Reducer 7 - File Output Operator [FS_53] - Limit [LIM_52] (rows=100 width=860) + Reducer 7 vectorized + File Output Operator [FS_108] + Limit [LIM_107] (rows=100 width=860) Number of rows:100 - Select Operator [SEL_51] (rows=32266667 width=860) + Select Operator [SEL_106] (rows=32266667 width=860) Output:["_col0"] <-Reducer 6 [SIMPLE_EDGE] SHUFFLE [RS_50] @@ -75,18 +75,18 @@ Stage-0 Filter Operator [FIL_48] (rows=32266667 width=860) predicate:(_col2 > CASE WHEN (_col8 is null) THEN (null) ELSE (_col7) END) Merge Join Operator [MERGEJOIN_81] (rows=96800003 width=860) - Conds:RS_45._col1=RS_46._col2(Inner),Output:["_col2","_col6","_col7","_col8"] + Conds:RS_45._col1=RS_105._col2(Inner),Output:["_col2","_col6","_col7","_col8"] <-Reducer 5 [SIMPLE_EDGE] SHUFFLE [RS_45] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_79] (rows=88000001 width=860) - Conds:RS_42._col0=RS_43._col0(Inner),Output:["_col1","_col2","_col6"] - <-Map 12 [SIMPLE_EDGE] - SHUFFLE [RS_43] + Conds:RS_42._col0=RS_100._col0(Inner),Output:["_col1","_col2","_col6"] + <-Map 12 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_100] PartitionCols:_col0 - Select Operator [SEL_19] (rows=80000000 width=860) + Select Operator [SEL_99] (rows=80000000 width=860) Output:["_col0","_col1"] - Filter Operator [FIL_74] (rows=80000000 width=860) + Filter Operator [FIL_98] (rows=80000000 width=860) predicate:c_customer_sk is not null TableScan [TS_17] (rows=80000000 width=860) default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_customer_id"] @@ -94,22 +94,22 @@ Stage-0 SHUFFLE [RS_42] PartitionCols:_col0 Merge Join Operator [MERGEJOIN_78] (rows=34842647 width=77) - Conds:RS_39._col1=RS_40._col0(Inner),Output:["_col0","_col1","_col2"] - <-Map 11 [SIMPLE_EDGE] - SHUFFLE [RS_40] + Conds:RS_94._col1=RS_97._col0(Inner),Output:["_col0","_col1","_col2"] + <-Map 11 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_97] PartitionCols:_col0 - Select Operator [SEL_16] (rows=852 width=1910) + Select Operator [SEL_96] (rows=852 width=1910) Output:["_col0"] - Filter Operator [FIL_73] (rows=852 width=1910) + Filter Operator [FIL_95] (rows=852 width=1910) predicate:((s_state = 'NM') and s_store_sk is not null) TableScan [TS_14] (rows=1704 width=1910) default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_state"] - <-Reducer 3 [SIMPLE_EDGE] - SHUFFLE [RS_39] + <-Reducer 3 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_94] PartitionCols:_col1 - Select Operator [SEL_13] (rows=31675133 width=77) + Select Operator [SEL_93] (rows=31675133 width=77) Output:["_col0","_col1","_col2"] - Group By Operator [GBY_12] (rows=31675133 width=77) + Group By Operator [GBY_92] (rows=31675133 width=77) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1 <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_11] @@ -117,35 +117,35 @@ Stage-0 Group By Operator [GBY_10] (rows=63350266 width=77) Output:["_col0","_col1","_col2"],aggregations:["sum(_col3)"],keys:_col2, _col1 Merge Join Operator [MERGEJOIN_77] (rows=63350266 width=77) - Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col1","_col2","_col3"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_6] + Conds:RS_86._col0=RS_90._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_86] PartitionCols:_col0 - Select Operator [SEL_2] (rows=57591150 width=77) + Select Operator [SEL_84] (rows=57591150 width=77) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_71] (rows=57591150 width=77) + Filter Operator [FIL_82] (rows=57591150 width=77) predicate:(sr_customer_sk is not null and sr_returned_date_sk is not null and sr_store_sk is not null) TableScan [TS_0] (rows=57591150 width=77) default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_returned_date_sk","sr_customer_sk","sr_store_sk","sr_fee"] - <-Map 10 [SIMPLE_EDGE] - SHUFFLE [RS_7] + <-Map 10 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_90] PartitionCols:_col0 - Select Operator [SEL_5] (rows=36524 width=1119) + Select Operator [SEL_89] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_72] (rows=36524 width=1119) + Filter Operator [FIL_88] (rows=36524 width=1119) predicate:((d_year = 2000) and d_date_sk is not null) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] - <-Reducer 9 [SIMPLE_EDGE] - SHUFFLE [RS_46] + <-Reducer 9 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_105] PartitionCols:_col2 - Select Operator [SEL_38] (rows=15837566 width=77) + Select Operator [SEL_104] (rows=15837566 width=77) Output:["_col0","_col1","_col2"] - Group By Operator [GBY_37] (rows=15837566 width=77) + Group By Operator [GBY_103] (rows=15837566 width=77) Output:["_col0","_col1","_col2"],aggregations:["sum(_col2)","count(_col2)"],keys:_col1 - Select Operator [SEL_33] (rows=31675133 width=77) + Select Operator [SEL_102] (rows=31675133 width=77) Output:["_col1","_col2"] - Group By Operator [GBY_32] (rows=31675133 width=77) + Group By Operator [GBY_101] (rows=31675133 width=77) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1 <-Reducer 8 [SIMPLE_EDGE] SHUFFLE [RS_31] @@ -153,17 +153,17 @@ Stage-0 Group By Operator [GBY_30] (rows=63350266 width=77) Output:["_col0","_col1","_col2"],aggregations:["sum(_col3)"],keys:_col2, _col1 Merge Join Operator [MERGEJOIN_80] (rows=63350266 width=77) - Conds:RS_26._col0=RS_27._col0(Inner),Output:["_col1","_col2","_col3"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_26] + Conds:RS_87._col0=RS_91._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_87] PartitionCols:_col0 - Select Operator [SEL_22] (rows=57591150 width=77) + Select Operator [SEL_85] (rows=57591150 width=77) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_75] (rows=57591150 width=77) + Filter Operator [FIL_83] (rows=57591150 width=77) predicate:(sr_returned_date_sk is not null and sr_store_sk is not null) Please refer to the previous TableScan [TS_0] - <-Map 10 [SIMPLE_EDGE] - SHUFFLE [RS_27] + <-Map 10 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_91] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_5] + Please refer to the previous Select Operator [SEL_89]
http://git-wip-us.apache.org/repos/asf/hive/blob/230cc4bb/ql/src/test/results/clientpositive/perf/tez/query10.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query10.q.out b/ql/src/test/results/clientpositive/perf/tez/query10.q.out index 457e55e..a88b7e1 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query10.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query10.q.out @@ -132,17 +132,17 @@ Stage-0 Fetch Operator limit:100 Stage-1 - Reducer 6 - File Output Operator [FS_69] - Limit [LIM_68] (rows=100 width=88) + Reducer 6 vectorized + File Output Operator [FS_143] + Limit [LIM_142] (rows=100 width=88) Number of rows:100 - Select Operator [SEL_67] (rows=1045432122 width=88) + Select Operator [SEL_141] (rows=1045432122 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] - <-Reducer 5 [SIMPLE_EDGE] - SHUFFLE [RS_66] - Select Operator [SEL_65] (rows=1045432122 width=88) + <-Reducer 5 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_140] + Select Operator [SEL_139] (rows=1045432122 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col6","_col8","_col10","_col12"] - Group By Operator [GBY_64] (rows=1045432122 width=88) + Group By Operator [GBY_138] (rows=1045432122 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"],aggregations:["count(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5, KEY._col6, KEY._col7 <-Reducer 4 [SIMPLE_EDGE] SHUFFLE [RS_63] @@ -154,7 +154,7 @@ Stage-0 Filter Operator [FIL_60] (rows=2090864244 width=88) predicate:(_col15 is not null or _col17 is not null) Merge Join Operator [MERGEJOIN_108] (rows=2090864244 width=88) - Conds:RS_55._col0=RS_56._col0(Left Semi),RS_55._col0=RS_57._col0(Left Outer),RS_55._col0=RS_58._col0(Left Outer),Output:["_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col15","_col17"] + Conds:RS_55._col0=RS_56._col0(Left Semi),RS_55._col0=RS_131._col0(Left Outer),RS_55._col0=RS_137._col0(Left Outer),Output:["_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col15","_col17"] <-Reducer 10 [SIMPLE_EDGE] SHUFFLE [RS_56] PartitionCols:_col0 @@ -163,31 +163,31 @@ Stage-0 Select Operator [SEL_18] (rows=633595212 width=88) Output:["_col0"] Merge Join Operator [MERGEJOIN_105] (rows=633595212 width=88) - Conds:RS_15._col0=RS_16._col0(Inner),Output:["_col1"] - <-Map 11 [SIMPLE_EDGE] - SHUFFLE [RS_16] + Conds:RS_120._col0=RS_123._col0(Inner),Output:["_col1"] + <-Map 11 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_123] PartitionCols:_col0 - Select Operator [SEL_14] (rows=4058 width=1119) + Select Operator [SEL_122] (rows=4058 width=1119) Output:["_col0"] - Filter Operator [FIL_98] (rows=4058 width=1119) + Filter Operator [FIL_121] (rows=4058 width=1119) predicate:((d_year = 2002) and d_date_sk is not null and d_moy BETWEEN 4 AND 7) TableScan [TS_12] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"] - <-Map 9 [SIMPLE_EDGE] - SHUFFLE [RS_15] + <-Map 9 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_120] PartitionCols:_col0 - Select Operator [SEL_11] (rows=575995635 width=88) + Select Operator [SEL_119] (rows=575995635 width=88) Output:["_col0","_col1"] - Filter Operator [FIL_97] (rows=575995635 width=88) + Filter Operator [FIL_118] (rows=575995635 width=88) predicate:(ss_customer_sk is not null and ss_sold_date_sk is not null) TableScan [TS_9] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk"] - <-Reducer 13 [ONE_TO_ONE_EDGE] - FORWARD [RS_57] + <-Reducer 13 [ONE_TO_ONE_EDGE] vectorized + FORWARD [RS_131] PartitionCols:_col0 - Select Operator [SEL_32] (rows=79201469 width=135) + Select Operator [SEL_130] (rows=79201469 width=135) Output:["_col0","_col1"] - Group By Operator [GBY_31] (rows=79201469 width=135) + Group By Operator [GBY_129] (rows=79201469 width=135) Output:["_col0"],keys:KEY._col0 <-Reducer 12 [SIMPLE_EDGE] SHUFFLE [RS_30] @@ -195,26 +195,26 @@ Stage-0 Group By Operator [GBY_29] (rows=158402938 width=135) Output:["_col0"],keys:_col1 Merge Join Operator [MERGEJOIN_106] (rows=158402938 width=135) - Conds:RS_25._col0=RS_26._col0(Inner),Output:["_col1"] - <-Map 11 [SIMPLE_EDGE] - SHUFFLE [RS_26] + Conds:RS_128._col0=RS_124._col0(Inner),Output:["_col1"] + <-Map 11 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_124] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_14] - <-Map 16 [SIMPLE_EDGE] - SHUFFLE [RS_25] + Please refer to the previous Select Operator [SEL_122] + <-Map 16 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_128] PartitionCols:_col0 - Select Operator [SEL_21] (rows=144002668 width=135) + Select Operator [SEL_127] (rows=144002668 width=135) Output:["_col0","_col1"] - Filter Operator [FIL_99] (rows=144002668 width=135) + Filter Operator [FIL_126] (rows=144002668 width=135) predicate:(ws_bill_customer_sk is not null and ws_sold_date_sk is not null) TableScan [TS_19] (rows=144002668 width=135) default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_bill_customer_sk"] - <-Reducer 15 [ONE_TO_ONE_EDGE] - FORWARD [RS_58] + <-Reducer 15 [ONE_TO_ONE_EDGE] vectorized + FORWARD [RS_137] PartitionCols:_col0 - Select Operator [SEL_46] (rows=158394413 width=135) + Select Operator [SEL_136] (rows=158394413 width=135) Output:["_col0","_col1"] - Group By Operator [GBY_45] (rows=158394413 width=135) + Group By Operator [GBY_135] (rows=158394413 width=135) Output:["_col0"],keys:KEY._col0 <-Reducer 14 [SIMPLE_EDGE] SHUFFLE [RS_44] @@ -222,17 +222,17 @@ Stage-0 Group By Operator [GBY_43] (rows=316788826 width=135) Output:["_col0"],keys:_col1 Merge Join Operator [MERGEJOIN_107] (rows=316788826 width=135) - Conds:RS_39._col0=RS_40._col0(Inner),Output:["_col1"] - <-Map 11 [SIMPLE_EDGE] - SHUFFLE [RS_40] + Conds:RS_134._col0=RS_125._col0(Inner),Output:["_col1"] + <-Map 11 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_125] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_14] - <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_39] + Please refer to the previous Select Operator [SEL_122] + <-Map 17 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_134] PartitionCols:_col0 - Select Operator [SEL_35] (rows=287989836 width=135) + Select Operator [SEL_133] (rows=287989836 width=135) Output:["_col0","_col1"] - Filter Operator [FIL_101] (rows=287989836 width=135) + Filter Operator [FIL_132] (rows=287989836 width=135) predicate:(cs_ship_customer_sk is not null and cs_sold_date_sk is not null) TableScan [TS_33] (rows=287989836 width=135) default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_ship_customer_sk"] @@ -240,13 +240,13 @@ Stage-0 SHUFFLE [RS_55] PartitionCols:_col0 Merge Join Operator [MERGEJOIN_104] (rows=96800003 width=860) - Conds:RS_50._col1=RS_51._col0(Inner),Output:["_col0","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] - <-Map 8 [SIMPLE_EDGE] - SHUFFLE [RS_51] + Conds:RS_50._col1=RS_117._col0(Inner),Output:["_col0","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] + <-Map 8 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_117] PartitionCols:_col0 - Select Operator [SEL_8] (rows=1861800 width=385) + Select Operator [SEL_116] (rows=1861800 width=385) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"] - Filter Operator [FIL_96] (rows=1861800 width=385) + Filter Operator [FIL_115] (rows=1861800 width=385) predicate:cd_demo_sk is not null TableScan [TS_6] (rows=1861800 width=385) default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_gender","cd_marital_status","cd_education_status","cd_purchase_estimate","cd_credit_rating","cd_dep_count","cd_dep_employed_count","cd_dep_college_count"] @@ -254,22 +254,22 @@ Stage-0 SHUFFLE [RS_50] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_103] (rows=88000001 width=860) - Conds:RS_47._col2=RS_48._col0(Inner),Output:["_col0","_col1"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_47] + Conds:RS_111._col2=RS_114._col0(Inner),Output:["_col0","_col1"] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_111] PartitionCols:_col2 - Select Operator [SEL_2] (rows=80000000 width=860) + Select Operator [SEL_110] (rows=80000000 width=860) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_94] (rows=80000000 width=860) + Filter Operator [FIL_109] (rows=80000000 width=860) predicate:(c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_customer_sk is not null) TableScan [TS_0] (rows=80000000 width=860) default@customer,c,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_cdemo_sk","c_current_addr_sk"] - <-Map 7 [SIMPLE_EDGE] - SHUFFLE [RS_48] + <-Map 7 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_114] PartitionCols:_col0 - Select Operator [SEL_5] (rows=20000000 width=1014) + Select Operator [SEL_113] (rows=20000000 width=1014) Output:["_col0"] - Filter Operator [FIL_95] (rows=20000000 width=1014) + Filter Operator [FIL_112] (rows=20000000 width=1014) predicate:((ca_county) IN ('Walker County', 'Richland County', 'Gaines County', 'Douglas County', 'Dona Ana County') and ca_address_sk is not null) TableScan [TS_3] (rows=40000000 width=1014) default@customer_address,ca,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_county"] http://git-wip-us.apache.org/repos/asf/hive/blob/230cc4bb/ql/src/test/results/clientpositive/perf/tez/query11.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query11.q.out b/ql/src/test/results/clientpositive/perf/tez/query11.q.out index e3ac717..2599621 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query11.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query11.q.out @@ -168,11 +168,11 @@ Stage-0 Fetch Operator limit:100 Stage-1 - Reducer 6 - File Output Operator [FS_96] - Limit [LIM_95] (rows=100 width=88) + Reducer 6 vectorized + File Output Operator [FS_218] + Limit [LIM_217] (rows=100 width=88) Number of rows:100 - Select Operator [SEL_94] (rows=383325119 width=88) + Select Operator [SEL_216] (rows=383325119 width=88) Output:["_col0"] <-Reducer 5 [SIMPLE_EDGE] SHUFFLE [RS_93] @@ -181,13 +181,13 @@ Stage-0 Filter Operator [FIL_91] (rows=383325119 width=88) predicate:((_col1 / _col8) > (_col6 / _col3)) Merge Join Operator [MERGEJOIN_175] (rows=1149975359 width=88) - Conds:RS_86._col0=RS_87._col0(Inner),RS_87._col0=RS_88._col0(Inner),RS_87._col0=RS_89._col0(Inner),Output:["_col1","_col3","_col5","_col6","_col8"] - <-Reducer 13 [SIMPLE_EDGE] - SHUFFLE [RS_88] + Conds:RS_198._col0=RS_215._col0(Inner),RS_215._col0=RS_210._col0(Inner),RS_215._col0=RS_203._col0(Inner),Output:["_col1","_col3","_col5","_col6","_col8"] + <-Reducer 13 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_210] PartitionCols:_col0 - Select Operator [SEL_63] (rows=348477374 width=88) + Select Operator [SEL_209] (rows=348477374 width=88) Output:["_col0","_col1","_col2"] - Group By Operator [GBY_62] (rows=348477374 width=88) + Group By Operator [GBY_208] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5, KEY._col6 <-Reducer 12 [SIMPLE_EDGE] SHUFFLE [RS_61] @@ -197,13 +197,13 @@ Stage-0 Select Operator [SEL_58] (rows=696954748 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] Merge Join Operator [MERGEJOIN_172] (rows=696954748 width=88) - Conds:RS_55._col1=RS_56._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] - <-Map 18 [SIMPLE_EDGE] - SHUFFLE [RS_56] + Conds:RS_55._col1=RS_192._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] + <-Map 18 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_192] PartitionCols:_col0 - Select Operator [SEL_51] (rows=80000000 width=860) + Select Operator [SEL_191] (rows=80000000 width=860) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] - Filter Operator [FIL_161] (rows=80000000 width=860) + Filter Operator [FIL_190] (rows=80000000 width=860) predicate:(c_customer_id is not null and c_customer_sk is not null) TableScan [TS_49] (rows=80000000 width=860) default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_customer_id","c_first_name","c_last_name","c_preferred_cust_flag","c_birth_country","c_login","c_email_address"] @@ -211,35 +211,35 @@ Stage-0 SHUFFLE [RS_55] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_171] (rows=633595212 width=88) - Conds:RS_52._col0=RS_53._col0(Inner),Output:["_col1","_col2","_col3"] - <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_53] + Conds:RS_206._col0=RS_186._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 17 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_186] PartitionCols:_col0 - Select Operator [SEL_48] (rows=36524 width=1119) + Select Operator [SEL_183] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_160] (rows=36524 width=1119) + Filter Operator [FIL_180] (rows=36524 width=1119) predicate:((d_year = 2002) and d_date_sk is not null) TableScan [TS_46] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] - <-Map 10 [SIMPLE_EDGE] - SHUFFLE [RS_52] + <-Map 10 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_206] PartitionCols:_col0 - Select Operator [SEL_45] (rows=575995635 width=88) + Select Operator [SEL_205] (rows=575995635 width=88) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_159] (rows=575995635 width=88) + Filter Operator [FIL_204] (rows=575995635 width=88) predicate:(ss_customer_sk is not null and ss_sold_date_sk is not null) TableScan [TS_43] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk","ss_ext_discount_amt","ss_ext_list_price"] - <-Reducer 16 [SIMPLE_EDGE] - SHUFFLE [RS_87] + <-Reducer 16 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_215] PartitionCols:_col0 - Select Operator [SEL_42] (rows=116159124 width=88) + Select Operator [SEL_214] (rows=116159124 width=88) Output:["_col0","_col1"] - Filter Operator [FIL_41] (rows=116159124 width=88) + Filter Operator [FIL_213] (rows=116159124 width=88) predicate:(_col7 > 0) - Select Operator [SEL_166] (rows=348477374 width=88) + Select Operator [SEL_212] (rows=348477374 width=88) Output:["_col0","_col7"] - Group By Operator [GBY_40] (rows=348477374 width=88) + Group By Operator [GBY_211] (rows=348477374 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5, KEY._col6 <-Reducer 15 [SIMPLE_EDGE] SHUFFLE [RS_39] @@ -249,34 +249,34 @@ Stage-0 Select Operator [SEL_36] (rows=696954748 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] Merge Join Operator [MERGEJOIN_170] (rows=696954748 width=88) - Conds:RS_33._col1=RS_34._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] - <-Map 18 [SIMPLE_EDGE] - SHUFFLE [RS_34] + Conds:RS_33._col1=RS_194._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] + <-Map 18 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_194] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_51] + Please refer to the previous Select Operator [SEL_191] <-Reducer 14 [SIMPLE_EDGE] SHUFFLE [RS_33] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_169] (rows=633595212 width=88) - Conds:RS_30._col0=RS_31._col0(Inner),Output:["_col1","_col2","_col3"] - <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_31] + Conds:RS_207._col0=RS_188._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 17 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_188] PartitionCols:_col0 - Select Operator [SEL_26] (rows=36524 width=1119) + Select Operator [SEL_184] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_157] (rows=36524 width=1119) + Filter Operator [FIL_181] (rows=36524 width=1119) predicate:((d_year = 2001) and d_date_sk is not null) Please refer to the previous TableScan [TS_46] - <-Map 10 [SIMPLE_EDGE] - SHUFFLE [RS_30] + <-Map 10 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_207] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_45] - <-Reducer 4 [SIMPLE_EDGE] - SHUFFLE [RS_86] + Please refer to the previous Select Operator [SEL_205] + <-Reducer 4 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_198] PartitionCols:_col0 - Select Operator [SEL_20] (rows=87121617 width=135) + Select Operator [SEL_197] (rows=87121617 width=135) Output:["_col0","_col1"] - Group By Operator [GBY_19] (rows=87121617 width=135) + Group By Operator [GBY_196] (rows=87121617 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5, KEY._col6 <-Reducer 3 [SIMPLE_EDGE] SHUFFLE [RS_18] @@ -286,39 +286,39 @@ Stage-0 Select Operator [SEL_15] (rows=174243235 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] Merge Join Operator [MERGEJOIN_168] (rows=174243235 width=135) - Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] - <-Map 18 [SIMPLE_EDGE] - SHUFFLE [RS_13] + Conds:RS_12._col1=RS_193._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] + <-Map 18 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_193] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_51] + Please refer to the previous Select Operator [SEL_191] <-Reducer 2 [SIMPLE_EDGE] SHUFFLE [RS_12] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_167] (rows=158402938 width=135) - Conds:RS_9._col0=RS_10._col0(Inner),Output:["_col1","_col2","_col3"] - <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_10] + Conds:RS_178._col0=RS_187._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 17 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_187] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_48] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_9] + Please refer to the previous Select Operator [SEL_183] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_178] PartitionCols:_col0 - Select Operator [SEL_2] (rows=144002668 width=135) + Select Operator [SEL_177] (rows=144002668 width=135) Output:["_col0","_col1","_col2","_col3"] - Filter Operator [FIL_153] (rows=144002668 width=135) + Filter Operator [FIL_176] (rows=144002668 width=135) predicate:(ws_bill_customer_sk is not null and ws_sold_date_sk is not null) TableScan [TS_0] (rows=144002668 width=135) default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_bill_customer_sk","ws_ext_discount_amt","ws_ext_list_price"] - <-Reducer 9 [SIMPLE_EDGE] - SHUFFLE [RS_89] + <-Reducer 9 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_203] PartitionCols:_col0 - Select Operator [SEL_85] (rows=29040539 width=135) + Select Operator [SEL_202] (rows=29040539 width=135) Output:["_col0","_col1"] - Filter Operator [FIL_84] (rows=29040539 width=135) + Filter Operator [FIL_201] (rows=29040539 width=135) predicate:(_col7 > 0) - Select Operator [SEL_165] (rows=87121617 width=135) + Select Operator [SEL_200] (rows=87121617 width=135) Output:["_col0","_col7"] - Group By Operator [GBY_83] (rows=87121617 width=135) + Group By Operator [GBY_199] (rows=87121617 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"],aggregations:["sum(VALUE._col0)"],keys:KEY._col0, KEY._col1, KEY._col2, KEY._col3, KEY._col4, KEY._col5, KEY._col6 <-Reducer 8 [SIMPLE_EDGE] SHUFFLE [RS_82] @@ -328,26 +328,26 @@ Stage-0 Select Operator [SEL_79] (rows=174243235 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] Merge Join Operator [MERGEJOIN_174] (rows=174243235 width=135) - Conds:RS_76._col1=RS_77._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] - <-Map 18 [SIMPLE_EDGE] - SHUFFLE [RS_77] + Conds:RS_76._col1=RS_195._col0(Inner),Output:["_col2","_col3","_col7","_col8","_col9","_col10","_col11","_col12","_col13"] + <-Map 18 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_195] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_51] + Please refer to the previous Select Operator [SEL_191] <-Reducer 7 [SIMPLE_EDGE] SHUFFLE [RS_76] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_173] (rows=158402938 width=135) - Conds:RS_73._col0=RS_74._col0(Inner),Output:["_col1","_col2","_col3"] - <-Map 17 [SIMPLE_EDGE] - SHUFFLE [RS_74] + Conds:RS_179._col0=RS_189._col0(Inner),Output:["_col1","_col2","_col3"] + <-Map 17 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_189] PartitionCols:_col0 - Select Operator [SEL_69] (rows=36524 width=1119) + Select Operator [SEL_185] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_163] (rows=36524 width=1119) + Filter Operator [FIL_182] (rows=36524 width=1119) predicate:((d_year = 2001) and d_date_sk is not null) Please refer to the previous TableScan [TS_46] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_73] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_179] PartitionCols:_col0 - Please refer to the previous Select Operator [SEL_2] + Please refer to the previous Select Operator [SEL_177] http://git-wip-us.apache.org/repos/asf/hive/blob/230cc4bb/ql/src/test/results/clientpositive/perf/tez/query12.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query12.q.out b/ql/src/test/results/clientpositive/perf/tez/query12.q.out index b1f5926..6e304aa 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query12.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query12.q.out @@ -75,24 +75,24 @@ Stage-0 Fetch Operator limit:-1 Stage-1 - Reducer 6 - File Output Operator [FS_28] - Limit [LIM_26] (rows=100 width=135) + Reducer 6 vectorized + File Output Operator [FS_56] + Limit [LIM_55] (rows=100 width=135) Number of rows:100 - Select Operator [SEL_25] (rows=87121617 width=135) + Select Operator [SEL_54] (rows=87121617 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Reducer 5 [SIMPLE_EDGE] - SHUFFLE [RS_24] - Select Operator [SEL_22] (rows=87121617 width=135) + <-Reducer 5 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_53] + Select Operator [SEL_52] (rows=87121617 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"] - PTF Operator [PTF_21] (rows=87121617 width=135) + PTF Operator [PTF_51] (rows=87121617 width=135) Function definitions:[{},{"name:":"windowingtablefunction","order by:":"_col1 ASC NULLS FIRST","partition by:":"_col1"}] - Select Operator [SEL_20] (rows=87121617 width=135) + Select Operator [SEL_50] (rows=87121617 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - <-Reducer 4 [SIMPLE_EDGE] - SHUFFLE [RS_19] + <-Reducer 4 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_49] PartitionCols:_col1 - Group By Operator [GBY_18] (rows=87121617 width=135) + Group By Operator [GBY_48] (rows=87121617 width=135) 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] @@ -100,13 +100,13 @@ Stage-0 Group By Operator [GBY_16] (rows=174243235 width=135) Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(_col2)"],keys:_col10, _col9, _col6, _col7, _col8 Merge Join Operator [MERGEJOIN_38] (rows=174243235 width=135) - Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10"] - <-Map 8 [SIMPLE_EDGE] - SHUFFLE [RS_13] + Conds:RS_12._col1=RS_47._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10"] + <-Map 8 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_47] PartitionCols:_col0 - Select Operator [SEL_8] (rows=231000 width=1436) + Select Operator [SEL_46] (rows=231000 width=1436) Output:["_col0","_col1","_col2","_col3","_col4","_col5"] - Filter Operator [FIL_36] (rows=231000 width=1436) + Filter Operator [FIL_45] (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"] @@ -114,22 +114,22 @@ Stage-0 SHUFFLE [RS_12] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_37] (rows=158402938 width=135) - Conds:RS_9._col0=RS_10._col0(Inner),Output:["_col1","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_9] + Conds:RS_41._col0=RS_44._col0(Inner),Output:["_col1","_col2"] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_41] PartitionCols:_col0 - Select Operator [SEL_2] (rows=144002668 width=135) + Select Operator [SEL_40] (rows=144002668 width=135) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_34] (rows=144002668 width=135) + Filter Operator [FIL_39] (rows=144002668 width=135) predicate:(ws_item_sk is not null and ws_sold_date_sk is not null) TableScan [TS_0] (rows=144002668 width=135) default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_ext_sales_price"] - <-Map 7 [SIMPLE_EDGE] - SHUFFLE [RS_10] + <-Map 7 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_44] PartitionCols:_col0 - Select Operator [SEL_5] (rows=8116 width=1119) + Select Operator [SEL_43] (rows=8116 width=1119) Output:["_col0"] - Filter Operator [FIL_35] (rows=8116 width=1119) + Filter Operator [FIL_42] (rows=8116 width=1119) predicate:(CAST( d_date AS TIMESTAMP) BETWEEN TIMESTAMP'2001-01-12 00:00:00.0' AND TIMESTAMP'2001-02-11 00:00:00.0' 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"] http://git-wip-us.apache.org/repos/asf/hive/blob/230cc4bb/ql/src/test/results/clientpositive/perf/tez/query13.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query13.q.out b/ql/src/test/results/clientpositive/perf/tez/query13.q.out index 065b231..d0ed3d8 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query13.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query13.q.out @@ -112,11 +112,11 @@ Stage-0 Fetch Operator limit:-1 Stage-1 - Reducer 7 - File Output Operator [FS_40] - Select Operator [SEL_39] (rows=1 width=256) + Reducer 7 vectorized + File Output Operator [FS_92] + Select Operator [SEL_91] (rows=1 width=256) Output:["_col0","_col1","_col2","_col3"] - Group By Operator [GBY_38] (rows=1 width=256) + Group By Operator [GBY_90] (rows=1 width=256) Output:["_col0","_col1","_col2","_col3","_col4","_col5"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)","sum(VALUE._col2)","count(VALUE._col3)","sum(VALUE._col4)","count(VALUE._col5)"] <-Reducer 6 [CUSTOM_SIMPLE_EDGE] PARTITION_ONLY_SHUFFLE [RS_37] @@ -127,13 +127,13 @@ Stage-0 Filter Operator [FIL_34] (rows=715776 width=88) predicate:(((_col19 = 'D') and (_col20 = 'Primary') and _col7 BETWEEN 50 AND 100 and (_col14 = 1)) or ((_col19 = 'M') and (_col20 = '4 yr Degree') and _col7 BETWEEN 100 AND 150 and (_col14 = 3)) or ((_col19 = 'U') and (_col20 = 'Advanced Degree') and _col7 BETWEEN 150 AND 200 and (_col14 = 1))) Merge Join Operator [MERGEJOIN_71] (rows=17178642 width=88) - Conds:RS_31._col2=RS_32._col0(Inner),Output:["_col6","_col7","_col8","_col9","_col14","_col19","_col20"] - <-Map 12 [SIMPLE_EDGE] - SHUFFLE [RS_32] + Conds:RS_31._col2=RS_89._col0(Inner),Output:["_col6","_col7","_col8","_col9","_col14","_col19","_col20"] + <-Map 12 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_89] PartitionCols:_col0 - Select Operator [SEL_17] (rows=1861800 width=385) + Select Operator [SEL_88] (rows=1861800 width=385) Output:["_col0","_col1","_col2"] - Filter Operator [FIL_66] (rows=1861800 width=385) + Filter Operator [FIL_87] (rows=1861800 width=385) predicate:(((cd_education_status = '4 yr Degree') or (cd_education_status = 'Primary') or (cd_education_status = 'Advanced Degree')) and ((cd_marital_status = 'M') or (cd_marital_status = 'D') or (cd_marital_status = 'U')) and cd_demo_sk is not null) TableScan [TS_15] (rows=1861800 width=385) default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status","cd_education_status"] @@ -143,13 +143,13 @@ Stage-0 Filter Operator [FIL_30] (rows=15616947 width=88) predicate:(((_col16) IN ('KY', 'GA', 'NM') and _col10 BETWEEN 100 AND 200) or ((_col16) IN ('MT', 'OR', 'IN') and _col10 BETWEEN 150 AND 300) or ((_col16) IN ('WI', 'MO', 'WV') and _col10 BETWEEN 50 AND 250)) Merge Join Operator [MERGEJOIN_70] (rows=93701693 width=88) - Conds:RS_27._col4=RS_28._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10","_col14","_col16"] - <-Map 11 [SIMPLE_EDGE] - SHUFFLE [RS_28] + Conds:RS_27._col4=RS_86._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10","_col14","_col16"] + <-Map 11 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_86] PartitionCols:_col0 - Select Operator [SEL_14] (rows=10000000 width=1014) + Select Operator [SEL_85] (rows=10000000 width=1014) Output:["_col0","_col1"] - Filter Operator [FIL_65] (rows=10000000 width=1014) + Filter Operator [FIL_84] (rows=10000000 width=1014) predicate:((ca_country = 'United States') and (ca_state) IN ('KY', 'GA', 'NM', 'MT', 'OR', 'IN', 'WI', 'MO', 'WV') and ca_address_sk is not null) TableScan [TS_12] (rows=40000000 width=1014) default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state","ca_country"] @@ -157,13 +157,13 @@ Stage-0 SHUFFLE [RS_27] PartitionCols:_col4 Merge Join Operator [MERGEJOIN_69] (rows=85183356 width=88) - Conds:RS_24._col3=RS_25._col0(Inner),Output:["_col2","_col4","_col6","_col7","_col8","_col9","_col10","_col14"] - <-Map 10 [SIMPLE_EDGE] - SHUFFLE [RS_25] + Conds:RS_24._col3=RS_83._col0(Inner),Output:["_col2","_col4","_col6","_col7","_col8","_col9","_col10","_col14"] + <-Map 10 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_83] PartitionCols:_col0 - Select Operator [SEL_11] (rows=7200 width=107) + Select Operator [SEL_82] (rows=7200 width=107) Output:["_col0","_col1"] - Filter Operator [FIL_64] (rows=7200 width=107) + Filter Operator [FIL_81] (rows=7200 width=107) predicate:(((hd_dep_count = 3) or (hd_dep_count = 1)) and hd_demo_sk is not null) TableScan [TS_9] (rows=7200 width=107) default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"] @@ -171,13 +171,13 @@ Stage-0 SHUFFLE [RS_24] PartitionCols:_col3 Merge Join Operator [MERGEJOIN_68] (rows=77439413 width=88) - Conds:RS_21._col1=RS_22._col0(Inner),Output:["_col2","_col3","_col4","_col6","_col7","_col8","_col9","_col10"] - <-Map 9 [SIMPLE_EDGE] - SHUFFLE [RS_22] + Conds:RS_21._col1=RS_80._col0(Inner),Output:["_col2","_col3","_col4","_col6","_col7","_col8","_col9","_col10"] + <-Map 9 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_80] PartitionCols:_col0 - Select Operator [SEL_8] (rows=36524 width=1119) + Select Operator [SEL_79] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_63] (rows=36524 width=1119) + Filter Operator [FIL_78] (rows=36524 width=1119) predicate:((d_year = 2001) and d_date_sk is not null) TableScan [TS_6] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"] @@ -185,22 +185,22 @@ Stage-0 SHUFFLE [RS_21] PartitionCols:_col1 Merge Join Operator [MERGEJOIN_67] (rows=70399465 width=88) - Conds:RS_18._col0=RS_19._col4(Inner),Output:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col9","_col10"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_18] + Conds:RS_74._col0=RS_77._col4(Inner),Output:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col9","_col10"] + <-Map 1 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_74] PartitionCols:_col0 - Select Operator [SEL_2] (rows=1704 width=1910) + Select Operator [SEL_73] (rows=1704 width=1910) Output:["_col0"] - Filter Operator [FIL_61] (rows=1704 width=1910) + Filter Operator [FIL_72] (rows=1704 width=1910) predicate:s_store_sk is not null TableScan [TS_0] (rows=1704 width=1910) default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk"] - <-Map 8 [SIMPLE_EDGE] - SHUFFLE [RS_19] + <-Map 8 [SIMPLE_EDGE] vectorized + SHUFFLE [RS_77] PartitionCols:_col4 - Select Operator [SEL_5] (rows=63999513 width=88) + Select Operator [SEL_76] (rows=63999513 width=88) Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"] - Filter Operator [FIL_62] (rows=63999513 width=88) + Filter Operator [FIL_75] (rows=63999513 width=88) predicate:((ss_net_profit BETWEEN 100 AND 200 or ss_net_profit BETWEEN 150 AND 300 or ss_net_profit BETWEEN 50 AND 250) and (ss_sales_price BETWEEN 100 AND 150 or ss_sales_price BETWEEN 50 AND 100 or ss_sales_price BETWEEN 150 AND 200) and ss_addr_sk is not null and ss_cdemo_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) TableScan [TS_3] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_cdemo_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_quantity","ss_sales_price","ss_ext_sales_price","ss_ext_wholesale_cost","ss_net_profit"]
