Repository: hive Updated Branches: refs/heads/master 530e04065 -> e74eb354f
http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query28.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query28.q.out b/ql/src/test/results/clientpositive/perf/tez/query28.q.out index ca0bf37..27546e8 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query28.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query28.q.out @@ -142,16 +142,16 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_139] Group By Operator [GBY_138] (rows=1 width=232) Output:["_col0","_col1","_col2"],aggregations:["sum(_col1)","count(_col2)","count(_col0)"] - Group By Operator [GBY_137] (rows=21333171 width=88) + Group By Operator [GBY_137] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] vectorized SHUFFLE [RS_116] PartitionCols:_col0 - Group By Operator [GBY_110] (rows=21333171 width=88) + Group By Operator [GBY_110] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(ss_list_price)","count(ss_list_price)"],keys:ss_list_price - Select Operator [SEL_104] (rows=21333171 width=88) + Select Operator [SEL_104] (rows=191998545 width=88) Output:["ss_list_price"] - Filter Operator [FIL_98] (rows=21333171 width=88) + Filter Operator [FIL_98] (rows=191998545 width=88) predicate:((ss_list_price BETWEEN 142 AND 152 or ss_coupon_amt BETWEEN 3054 AND 4054 or ss_wholesale_cost BETWEEN 80 AND 100) and ss_quantity BETWEEN 16 AND 20) TableScan [TS_0] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_wholesale_cost","ss_list_price","ss_coupon_amt"] @@ -165,16 +165,16 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_145] Group By Operator [GBY_144] (rows=1 width=232) Output:["_col0","_col1","_col2"],aggregations:["sum(_col1)","count(_col2)","count(_col0)"] - Group By Operator [GBY_143] (rows=21333171 width=88) + Group By Operator [GBY_143] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] vectorized SHUFFLE [RS_117] PartitionCols:_col0 - Group By Operator [GBY_111] (rows=21333171 width=88) + Group By Operator [GBY_111] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(ss_list_price)","count(ss_list_price)"],keys:ss_list_price - Select Operator [SEL_105] (rows=21333171 width=88) + Select Operator [SEL_105] (rows=191998545 width=88) Output:["ss_list_price"] - Filter Operator [FIL_99] (rows=21333171 width=88) + Filter Operator [FIL_99] (rows=191998545 width=88) predicate:((ss_list_price BETWEEN 66 AND 76 or ss_coupon_amt BETWEEN 920 AND 1920 or ss_wholesale_cost BETWEEN 4 AND 24) and ss_quantity BETWEEN 11 AND 15) Please refer to the previous TableScan [TS_0] <-Reducer 14 [CUSTOM_SIMPLE_EDGE] vectorized @@ -187,16 +187,16 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_151] Group By Operator [GBY_150] (rows=1 width=232) Output:["_col0","_col1","_col2"],aggregations:["sum(_col1)","count(_col2)","count(_col0)"] - Group By Operator [GBY_149] (rows=21333171 width=88) + Group By Operator [GBY_149] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] vectorized SHUFFLE [RS_118] PartitionCols:_col0 - Group By Operator [GBY_112] (rows=21333171 width=88) + Group By Operator [GBY_112] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(ss_list_price)","count(ss_list_price)"],keys:ss_list_price - Select Operator [SEL_106] (rows=21333171 width=88) + Select Operator [SEL_106] (rows=191998545 width=88) Output:["ss_list_price"] - Filter Operator [FIL_100] (rows=21333171 width=88) + Filter Operator [FIL_100] (rows=191998545 width=88) predicate:((ss_list_price BETWEEN 91 AND 101 or ss_coupon_amt BETWEEN 1430 AND 2430 or ss_wholesale_cost BETWEEN 32 AND 52) and ss_quantity BETWEEN 6 AND 10) Please refer to the previous TableScan [TS_0] <-Reducer 3 [CUSTOM_SIMPLE_EDGE] vectorized @@ -209,16 +209,16 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_121] Group By Operator [GBY_120] (rows=1 width=232) Output:["_col0","_col1","_col2"],aggregations:["sum(_col1)","count(_col2)","count(_col0)"] - Group By Operator [GBY_119] (rows=21333171 width=88) + Group By Operator [GBY_119] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] vectorized SHUFFLE [RS_113] PartitionCols:_col0 - Group By Operator [GBY_107] (rows=21333171 width=88) + Group By Operator [GBY_107] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(ss_list_price)","count(ss_list_price)"],keys:ss_list_price - Select Operator [SEL_101] (rows=21333171 width=88) + Select Operator [SEL_101] (rows=191998545 width=88) Output:["ss_list_price"] - Filter Operator [FIL_95] (rows=21333171 width=88) + Filter Operator [FIL_95] (rows=191998545 width=88) predicate:((ss_list_price BETWEEN 11 AND 21 or ss_coupon_amt BETWEEN 460 AND 1460 or ss_wholesale_cost BETWEEN 14 AND 34) and ss_quantity BETWEEN 0 AND 5) Please refer to the previous TableScan [TS_0] <-Reducer 6 [CUSTOM_SIMPLE_EDGE] vectorized @@ -231,16 +231,16 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_127] Group By Operator [GBY_126] (rows=1 width=232) Output:["_col0","_col1","_col2"],aggregations:["sum(_col1)","count(_col2)","count(_col0)"] - Group By Operator [GBY_125] (rows=21333171 width=88) + Group By Operator [GBY_125] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] vectorized SHUFFLE [RS_114] PartitionCols:_col0 - Group By Operator [GBY_108] (rows=21333171 width=88) + Group By Operator [GBY_108] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(ss_list_price)","count(ss_list_price)"],keys:ss_list_price - Select Operator [SEL_102] (rows=21333171 width=88) + Select Operator [SEL_102] (rows=191998545 width=88) Output:["ss_list_price"] - Filter Operator [FIL_96] (rows=21333171 width=88) + Filter Operator [FIL_96] (rows=191998545 width=88) predicate:((ss_list_price BETWEEN 28 AND 38 or ss_coupon_amt BETWEEN 2513 AND 3513 or ss_wholesale_cost BETWEEN 42 AND 62) and ss_quantity BETWEEN 26 AND 30) Please refer to the previous TableScan [TS_0] <-Reducer 8 [CUSTOM_SIMPLE_EDGE] vectorized @@ -253,16 +253,16 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_133] Group By Operator [GBY_132] (rows=1 width=232) Output:["_col0","_col1","_col2"],aggregations:["sum(_col1)","count(_col2)","count(_col0)"] - Group By Operator [GBY_131] (rows=21333171 width=88) + Group By Operator [GBY_131] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] vectorized SHUFFLE [RS_115] PartitionCols:_col0 - Group By Operator [GBY_109] (rows=21333171 width=88) + Group By Operator [GBY_109] (rows=191998545 width=88) Output:["_col0","_col1","_col2"],aggregations:["sum(ss_list_price)","count(ss_list_price)"],keys:ss_list_price - Select Operator [SEL_103] (rows=21333171 width=88) + Select Operator [SEL_103] (rows=191998545 width=88) Output:["ss_list_price"] - Filter Operator [FIL_97] (rows=21333171 width=88) + Filter Operator [FIL_97] (rows=191998545 width=88) predicate:((ss_list_price BETWEEN 135 AND 145 or ss_coupon_amt BETWEEN 14180 AND 15180 or ss_wholesale_cost BETWEEN 38 AND 58) and ss_quantity BETWEEN 21 AND 25) Please refer to the previous TableScan [TS_0] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query29.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query29.q.out b/ql/src/test/results/clientpositive/perf/tez/query29.q.out index b051622..0f019d5 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query29.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query29.q.out @@ -178,9 +178,9 @@ Stage-0 <-Map 13 [SIMPLE_EDGE] vectorized SHUFFLE [RS_223] PartitionCols:_col0 - Select Operator [SEL_220] (rows=4058 width=1119) + Select Operator [SEL_220] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_218] (rows=4058 width=1119) + Filter Operator [FIL_218] (rows=36524 width=1119) predicate:((d_year = 1999) and d_date_sk is not null and d_moy BETWEEN 4 AND 7) TableScan [TS_9] (rows=73049 width=1119) default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query34.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query34.q.out b/ql/src/test/results/clientpositive/perf/tez/query34.q.out index 7d14092..b339193 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query34.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query34.q.out @@ -99,7 +99,7 @@ Stage-0 <-Reducer 9 [SIMPLE_EDGE] vectorized SHUFFLE [RS_139] PartitionCols:_col1 - Filter Operator [FIL_138] (rows=42591679 width=88) + Filter Operator [FIL_138] (rows=19166256 width=88) predicate:_col2 BETWEEN 15 AND 20 Select Operator [SEL_137] (rows=383325119 width=88) Output:["_col0","_col1","_col2"] @@ -143,9 +143,9 @@ Stage-0 <-Map 10 [SIMPLE_EDGE] vectorized SHUFFLE [RS_109] PartitionCols:_col0 - Select Operator [SEL_108] (rows=16232 width=1119) + Select Operator [SEL_108] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_107] (rows=16232 width=1119) + Filter Operator [FIL_107] (rows=73049 width=1119) predicate:((d_dom BETWEEN 1 AND 3 or d_dom BETWEEN 25 AND 28) and (d_year) IN (2000, 2001, 2002) and d_date_sk is not null) TableScan [TS_6] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"] @@ -166,7 +166,7 @@ Stage-0 SHUFFLE [RS_112] Group By Operator [GBY_111] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_110] (rows=16232 width=1119) + Select Operator [SEL_110] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_108] <-Reducer 13 [BROADCAST_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query38.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query38.q.out b/ql/src/test/results/clientpositive/perf/tez/query38.q.out index 78cb5e1..915f228 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query38.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query38.q.out @@ -122,9 +122,9 @@ Stage-0 <-Map 8 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_203] PartitionCols:_col0 - Select Operator [SEL_200] (rows=8116 width=1119) + Select Operator [SEL_200] (rows=73049 width=1119) Output:["_col0","_col1"] - Filter Operator [FIL_199] (rows=8116 width=1119) + Filter Operator [FIL_199] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"] @@ -145,7 +145,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_211] Group By Operator [GBY_208] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_204] (rows=8116 width=1119) + Select Operator [SEL_204] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_200] <-Reducer 20 [BROADCAST_EDGE] vectorized @@ -207,7 +207,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_212] Group By Operator [GBY_209] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_206] (rows=8116 width=1119) + Select Operator [SEL_206] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_200] <-Reducer 4 [CONTAINS] vectorized @@ -269,7 +269,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_210] Group By Operator [GBY_207] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_202] (rows=8116 width=1119) + Select Operator [SEL_202] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_200] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query51.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query51.q.out b/ql/src/test/results/clientpositive/perf/tez/query51.q.out index ba3f994..ec9f50c 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query51.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query51.q.out @@ -145,9 +145,9 @@ Stage-0 <-Map 7 [SIMPLE_EDGE] vectorized SHUFFLE [RS_92] PartitionCols:_col0 - Select Operator [SEL_89] (rows=8116 width=1119) + Select Operator [SEL_89] (rows=73049 width=1119) Output:["_col0","_col1"] - Filter Operator [FIL_88] (rows=8116 width=1119) + Filter Operator [FIL_88] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"] @@ -168,7 +168,7 @@ Stage-0 SHUFFLE [RS_97] Group By Operator [GBY_95] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_93] (rows=8116 width=1119) + Select Operator [SEL_93] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_89] <-Reducer 3 [SIMPLE_EDGE] @@ -208,7 +208,7 @@ Stage-0 SHUFFLE [RS_96] Group By Operator [GBY_94] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_91] (rows=8116 width=1119) + Select Operator [SEL_91] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_89] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query59.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query59.q.out b/ql/src/test/results/clientpositive/perf/tez/query59.q.out index a4be291..54ddb1f 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query59.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query59.q.out @@ -144,9 +144,9 @@ Stage-0 <-Map 15 [SIMPLE_EDGE] vectorized SHUFFLE [RS_216] PartitionCols:_col1 - Select Operator [SEL_214] (rows=8116 width=1119) + Select Operator [SEL_214] (rows=73049 width=1119) Output:["_col1"] - Filter Operator [FIL_212] (rows=8116 width=1119) + Filter Operator [FIL_212] (rows=73049 width=1119) predicate:(d_month_seq BETWEEN 1197 AND 1208 and d_week_seq is not null) TableScan [TS_15] (rows=73049 width=1119) default@date_dim,d,Tbl:COMPLETE,Col:NONE,Output:["d_month_seq","d_week_seq"] @@ -226,9 +226,9 @@ Stage-0 <-Map 15 [SIMPLE_EDGE] vectorized SHUFFLE [RS_215] PartitionCols:_col1 - Select Operator [SEL_213] (rows=8116 width=1119) + Select Operator [SEL_213] (rows=73049 width=1119) Output:["_col1"] - Filter Operator [FIL_211] (rows=8116 width=1119) + Filter Operator [FIL_211] (rows=73049 width=1119) predicate:(d_month_seq BETWEEN 1185 AND 1196 and d_week_seq is not null) Please refer to the previous TableScan [TS_15] <-Reducer 3 [SIMPLE_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query65.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query65.q.out b/ql/src/test/results/clientpositive/perf/tez/query65.q.out index c9759c3..e86179c 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query65.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query65.q.out @@ -133,9 +133,9 @@ Stage-0 <-Map 7 [SIMPLE_EDGE] vectorized SHUFFLE [RS_134] PartitionCols:_col0 - Select Operator [SEL_131] (rows=8116 width=1119) + Select Operator [SEL_131] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_130] (rows=8116 width=1119) + Filter Operator [FIL_130] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"] @@ -167,7 +167,7 @@ Stage-0 SHUFFLE [RS_139] Group By Operator [GBY_137] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_135] (rows=8116 width=1119) + Select Operator [SEL_135] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_131] <-Reducer 3 [SIMPLE_EDGE] vectorized @@ -217,7 +217,7 @@ Stage-0 SHUFFLE [RS_138] Group By Operator [GBY_136] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_133] (rows=8116 width=1119) + Select Operator [SEL_133] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_131] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query67.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query67.q.out b/ql/src/test/results/clientpositive/perf/tez/query67.q.out index 960e668..9f41800 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query67.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query67.q.out @@ -165,9 +165,9 @@ Stage-0 <-Map 8 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_87] PartitionCols:_col0 - Select Operator [SEL_86] (rows=8116 width=1119) + Select Operator [SEL_86] (rows=73049 width=1119) Output:["_col0","_col2","_col3","_col4"] - Filter Operator [FIL_85] (rows=8116 width=1119) + Filter Operator [FIL_85] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq","d_year","d_moy","d_qoy"] @@ -210,7 +210,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_90] Group By Operator [GBY_89] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_88] (rows=8116 width=1119) + Select Operator [SEL_88] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_86] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query68.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query68.q.out b/ql/src/test/results/clientpositive/perf/tez/query68.q.out index fd1e04b..b0dc839 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query68.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query68.q.out @@ -193,9 +193,9 @@ Stage-0 <-Map 14 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_158] PartitionCols:_col0 - Select Operator [SEL_157] (rows=8116 width=1119) + Select Operator [SEL_157] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_156] (rows=8116 width=1119) + Filter Operator [FIL_156] (rows=73049 width=1119) predicate:((d_year) IN (1998, 1999, 2000) and d_date_sk is not null and d_dom BETWEEN 1 AND 2) TableScan [TS_9] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"] @@ -216,7 +216,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_161] Group By Operator [GBY_160] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_159] (rows=8116 width=1119) + Select Operator [SEL_159] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_157] <-Reducer 17 [BROADCAST_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query69.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query69.q.out b/ql/src/test/results/clientpositive/perf/tez/query69.q.out index 4aad667..58e9c50 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query69.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query69.q.out @@ -158,9 +158,9 @@ Stage-0 <-Map 13 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_197] PartitionCols:_col0 - Select Operator [SEL_192] (rows=4058 width=1119) + Select Operator [SEL_192] (rows=36524 width=1119) Output:["_col0"] - Filter Operator [FIL_191] (rows=4058 width=1119) + Filter Operator [FIL_191] (rows=36524 width=1119) predicate:((d_year = 1999) and d_date_sk is not null and d_moy BETWEEN 1 AND 3) TableScan [TS_12] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"] @@ -181,7 +181,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_204] Group By Operator [GBY_201] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_198] (rows=4058 width=1119) + Select Operator [SEL_198] (rows=36524 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_192] <-Reducer 4 [ONE_TO_ONE_EDGE] @@ -260,7 +260,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_202] Group By Operator [GBY_199] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_194] (rows=4058 width=1119) + Select Operator [SEL_194] (rows=36524 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_192] <-Reducer 8 [BROADCAST_EDGE] vectorized @@ -309,7 +309,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_203] Group By Operator [GBY_200] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_196] (rows=4058 width=1119) + Select Operator [SEL_196] (rows=36524 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_192] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query70.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query70.q.out b/ql/src/test/results/clientpositive/perf/tez/query70.q.out index 4efb85a..c80c0d5 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query70.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query70.q.out @@ -166,9 +166,9 @@ Stage-0 <-Map 8 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_139] PartitionCols:_col0 - Select Operator [SEL_136] (rows=8116 width=1119) + Select Operator [SEL_136] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_135] (rows=8116 width=1119) + Filter Operator [FIL_135] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"] @@ -189,7 +189,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_144] Group By Operator [GBY_142] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_140] (rows=8116 width=1119) + Select Operator [SEL_140] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_136] <-Reducer 19 [BROADCAST_EDGE] vectorized @@ -254,7 +254,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_143] Group By Operator [GBY_141] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_138] (rows=8116 width=1119) + Select Operator [SEL_138] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_136] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query73.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query73.q.out b/ql/src/test/results/clientpositive/perf/tez/query73.q.out index b18b860..e485144 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query73.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query73.q.out @@ -93,7 +93,7 @@ Stage-0 <-Reducer 9 [SIMPLE_EDGE] vectorized SHUFFLE [RS_139] PartitionCols:_col1 - Filter Operator [FIL_138] (rows=42591679 width=88) + Filter Operator [FIL_138] (rows=19166256 width=88) predicate:_col2 BETWEEN 1 AND 5 Select Operator [SEL_137] (rows=383325119 width=88) Output:["_col0","_col1","_col2"] @@ -137,9 +137,9 @@ Stage-0 <-Map 10 [SIMPLE_EDGE] vectorized SHUFFLE [RS_109] PartitionCols:_col0 - Select Operator [SEL_108] (rows=8116 width=1119) + Select Operator [SEL_108] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_107] (rows=8116 width=1119) + Filter Operator [FIL_107] (rows=73049 width=1119) predicate:((d_year) IN (2000, 2001, 2002) and d_date_sk is not null and d_dom BETWEEN 1 AND 2) TableScan [TS_6] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_dom"] @@ -160,7 +160,7 @@ Stage-0 SHUFFLE [RS_112] Group By Operator [GBY_111] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_110] (rows=8116 width=1119) + Select Operator [SEL_110] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_108] <-Reducer 13 [BROADCAST_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query79.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query79.q.out b/ql/src/test/results/clientpositive/perf/tez/query79.q.out index 7b9d48f..ac8eef6 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query79.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query79.q.out @@ -113,9 +113,9 @@ Stage-0 <-Map 12 [SIMPLE_EDGE] vectorized SHUFFLE [RS_117] PartitionCols:_col0 - Select Operator [SEL_116] (rows=189 width=1910) + Select Operator [SEL_116] (rows=1704 width=1910) Output:["_col0","_col2"] - Filter Operator [FIL_115] (rows=189 width=1910) + Filter Operator [FIL_115] (rows=1704 width=1910) predicate:(s_number_employees BETWEEN 200 AND 295 and s_store_sk is not null) TableScan [TS_9] (rows=1704 width=1910) default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk","s_number_employees","s_city"] @@ -161,7 +161,7 @@ Stage-0 SHUFFLE [RS_120] Group By Operator [GBY_119] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_118] (rows=189 width=1910) + Select Operator [SEL_118] (rows=1704 width=1910) Output:["_col0"] Please refer to the previous Select Operator [SEL_116] <-Reducer 15 [BROADCAST_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query86.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query86.q.out b/ql/src/test/results/clientpositive/perf/tez/query86.q.out index 8140b72..b6e7ce0 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query86.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query86.q.out @@ -111,9 +111,9 @@ Stage-0 <-Map 7 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_63] PartitionCols:_col0 - Select Operator [SEL_62] (rows=8116 width=1119) + Select Operator [SEL_62] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_61] (rows=8116 width=1119) + Filter Operator [FIL_61] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"] @@ -145,7 +145,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_66] Group By Operator [GBY_65] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_64] (rows=8116 width=1119) + Select Operator [SEL_64] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_62] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query87.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query87.q.out b/ql/src/test/results/clientpositive/perf/tez/query87.q.out index 1b9256d..00b31aa 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query87.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query87.q.out @@ -123,9 +123,9 @@ Stage-0 <-Map 10 [SIMPLE_EDGE] vectorized SHUFFLE [RS_232] PartitionCols:_col0 - Select Operator [SEL_227] (rows=8116 width=1119) + Select Operator [SEL_227] (rows=73049 width=1119) Output:["_col0","_col1"] - Filter Operator [FIL_226] (rows=8116 width=1119) + Filter Operator [FIL_226] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"] @@ -146,7 +146,7 @@ Stage-0 SHUFFLE [RS_239] Group By Operator [GBY_236] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_233] (rows=8116 width=1119) + Select Operator [SEL_233] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_227] <-Reducer 6 [CONTAINS] vectorized @@ -219,7 +219,7 @@ Stage-0 SHUFFLE [RS_238] Group By Operator [GBY_235] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_231] (rows=8116 width=1119) + Select Operator [SEL_231] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_227] <-Reducer 22 [BROADCAST_EDGE] vectorized @@ -285,7 +285,7 @@ Stage-0 SHUFFLE [RS_237] Group By Operator [GBY_234] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_229] (rows=8116 width=1119) + Select Operator [SEL_229] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_227] <-Reducer 21 [BROADCAST_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query9.q.out b/ql/src/test/results/clientpositive/perf/tez/query9.q.out index 611daa8..47aadb1 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query9.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query9.q.out @@ -189,9 +189,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_253] Group By Operator [GBY_248] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_net_paid_inc_tax)","count(ss_net_paid_inc_tax)"] - Select Operator [SEL_243] (rows=63999515 width=88) + Select Operator [SEL_243] (rows=575995635 width=88) Output:["ss_net_paid_inc_tax"] - Filter Operator [FIL_238] (rows=63999515 width=88) + Filter Operator [FIL_238] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 41 AND 60 TableScan [TS_80] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_net_paid_inc_tax"] @@ -209,9 +209,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_230] Group By Operator [GBY_225] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_ext_list_price)","count(ss_ext_list_price)"] - Select Operator [SEL_220] (rows=63999515 width=88) + Select Operator [SEL_220] (rows=575995635 width=88) Output:["ss_ext_list_price"] - Filter Operator [FIL_215] (rows=63999515 width=88) + Filter Operator [FIL_215] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 41 AND 60 TableScan [TS_73] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"] @@ -227,8 +227,8 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_208] Group By Operator [GBY_203] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_198] (rows=63999515 width=88) - Filter Operator [FIL_193] (rows=63999515 width=88) + Select Operator [SEL_198] (rows=575995635 width=88) + Filter Operator [FIL_193] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 41 AND 60 TableScan [TS_66] (rows=575995635 width=88) default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"] @@ -246,9 +246,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_252] Group By Operator [GBY_247] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_net_paid_inc_tax)","count(ss_net_paid_inc_tax)"] - Select Operator [SEL_242] (rows=63999515 width=88) + Select Operator [SEL_242] (rows=575995635 width=88) Output:["ss_net_paid_inc_tax"] - Filter Operator [FIL_237] (rows=63999515 width=88) + Filter Operator [FIL_237] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 21 AND 40 Please refer to the previous TableScan [TS_80] <-Reducer 6 [CUSTOM_SIMPLE_EDGE] @@ -265,9 +265,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_229] Group By Operator [GBY_224] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_ext_list_price)","count(ss_ext_list_price)"] - Select Operator [SEL_219] (rows=63999515 width=88) + Select Operator [SEL_219] (rows=575995635 width=88) Output:["ss_ext_list_price"] - Filter Operator [FIL_214] (rows=63999515 width=88) + Filter Operator [FIL_214] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 21 AND 40 Please refer to the previous TableScan [TS_73] <-Reducer 5 [CUSTOM_SIMPLE_EDGE] @@ -282,8 +282,8 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_207] Group By Operator [GBY_202] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_197] (rows=63999515 width=88) - Filter Operator [FIL_192] (rows=63999515 width=88) + Select Operator [SEL_197] (rows=575995635 width=88) + Filter Operator [FIL_192] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 21 AND 40 Please refer to the previous TableScan [TS_66] <-Reducer 4 [CUSTOM_SIMPLE_EDGE] @@ -313,8 +313,8 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_206] Group By Operator [GBY_201] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_196] (rows=63999515 width=88) - Filter Operator [FIL_191] (rows=63999515 width=88) + Select Operator [SEL_196] (rows=575995635 width=88) + Filter Operator [FIL_191] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 1 AND 20 Please refer to the previous TableScan [TS_66] <-Reducer 26 [CUSTOM_SIMPLE_EDGE] vectorized @@ -327,9 +327,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_228] Group By Operator [GBY_223] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_ext_list_price)","count(ss_ext_list_price)"] - Select Operator [SEL_218] (rows=63999515 width=88) + Select Operator [SEL_218] (rows=575995635 width=88) Output:["ss_ext_list_price"] - Filter Operator [FIL_213] (rows=63999515 width=88) + Filter Operator [FIL_213] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 1 AND 20 Please refer to the previous TableScan [TS_73] <-Reducer 32 [CUSTOM_SIMPLE_EDGE] vectorized @@ -342,9 +342,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_251] Group By Operator [GBY_246] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_net_paid_inc_tax)","count(ss_net_paid_inc_tax)"] - Select Operator [SEL_241] (rows=63999515 width=88) + Select Operator [SEL_241] (rows=575995635 width=88) Output:["ss_net_paid_inc_tax"] - Filter Operator [FIL_236] (rows=63999515 width=88) + Filter Operator [FIL_236] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 1 AND 20 Please refer to the previous TableScan [TS_80] <-Reducer 18 [CUSTOM_SIMPLE_EDGE] vectorized @@ -355,8 +355,8 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_204] Group By Operator [GBY_199] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_194] (rows=63999515 width=88) - Filter Operator [FIL_189] (rows=63999515 width=88) + Select Operator [SEL_194] (rows=575995635 width=88) + Filter Operator [FIL_189] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 61 AND 80 Please refer to the previous TableScan [TS_66] <-Reducer 24 [CUSTOM_SIMPLE_EDGE] vectorized @@ -369,9 +369,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_226] Group By Operator [GBY_221] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_ext_list_price)","count(ss_ext_list_price)"] - Select Operator [SEL_216] (rows=63999515 width=88) + Select Operator [SEL_216] (rows=575995635 width=88) Output:["ss_ext_list_price"] - Filter Operator [FIL_211] (rows=63999515 width=88) + Filter Operator [FIL_211] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 61 AND 80 Please refer to the previous TableScan [TS_73] <-Reducer 30 [CUSTOM_SIMPLE_EDGE] vectorized @@ -384,9 +384,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_249] Group By Operator [GBY_244] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_net_paid_inc_tax)","count(ss_net_paid_inc_tax)"] - Select Operator [SEL_239] (rows=63999515 width=88) + Select Operator [SEL_239] (rows=575995635 width=88) Output:["ss_net_paid_inc_tax"] - Filter Operator [FIL_234] (rows=63999515 width=88) + Filter Operator [FIL_234] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 61 AND 80 Please refer to the previous TableScan [TS_80] <-Reducer 19 [CUSTOM_SIMPLE_EDGE] vectorized @@ -397,8 +397,8 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_205] Group By Operator [GBY_200] (rows=1 width=8) Output:["_col0"],aggregations:["count()"] - Select Operator [SEL_195] (rows=63999515 width=88) - Filter Operator [FIL_190] (rows=63999515 width=88) + Select Operator [SEL_195] (rows=575995635 width=88) + Filter Operator [FIL_190] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 81 AND 100 Please refer to the previous TableScan [TS_66] <-Reducer 25 [CUSTOM_SIMPLE_EDGE] vectorized @@ -411,9 +411,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_227] Group By Operator [GBY_222] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_ext_list_price)","count(ss_ext_list_price)"] - Select Operator [SEL_217] (rows=63999515 width=88) + Select Operator [SEL_217] (rows=575995635 width=88) Output:["ss_ext_list_price"] - Filter Operator [FIL_212] (rows=63999515 width=88) + Filter Operator [FIL_212] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 81 AND 100 Please refer to the previous TableScan [TS_73] <-Reducer 31 [CUSTOM_SIMPLE_EDGE] vectorized @@ -426,9 +426,9 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_250] Group By Operator [GBY_245] (rows=1 width=120) Output:["_col0","_col1"],aggregations:["sum(ss_net_paid_inc_tax)","count(ss_net_paid_inc_tax)"] - Select Operator [SEL_240] (rows=63999515 width=88) + Select Operator [SEL_240] (rows=575995635 width=88) Output:["ss_net_paid_inc_tax"] - Filter Operator [FIL_235] (rows=63999515 width=88) + Filter Operator [FIL_235] (rows=575995635 width=88) predicate:ss_quantity BETWEEN 81 AND 100 Please refer to the previous TableScan [TS_80] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query90.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query90.q.out b/ql/src/test/results/clientpositive/perf/tez/query90.q.out index ae5c596..f52669d 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query90.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query90.q.out @@ -106,9 +106,9 @@ Stage-0 <-Map 15 [SIMPLE_EDGE] vectorized SHUFFLE [RS_171] PartitionCols:_col0 - Select Operator [SEL_168] (rows=9600 width=471) + Select Operator [SEL_168] (rows=86400 width=471) Output:["_col0"] - Filter Operator [FIL_166] (rows=9600 width=471) + Filter Operator [FIL_166] (rows=86400 width=471) predicate:(t_hour BETWEEN 14 AND 15 and t_time_sk is not null) TableScan [TS_6] (rows=86400 width=471) default@time_dim,time_dim,Tbl:COMPLETE,Col:NONE,Output:["t_time_sk","t_hour"] @@ -154,7 +154,7 @@ Stage-0 SHUFFLE [RS_176] Group By Operator [GBY_174] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_172] (rows=9600 width=471) + Select Operator [SEL_172] (rows=86400 width=471) Output:["_col0"] Please refer to the previous Select Operator [SEL_168] <-Reducer 20 [BROADCAST_EDGE] vectorized @@ -190,9 +190,9 @@ Stage-0 <-Map 15 [SIMPLE_EDGE] vectorized SHUFFLE [RS_169] PartitionCols:_col0 - Select Operator [SEL_167] (rows=9600 width=471) + Select Operator [SEL_167] (rows=86400 width=471) Output:["_col0"] - Filter Operator [FIL_165] (rows=9600 width=471) + Filter Operator [FIL_165] (rows=86400 width=471) predicate:(t_hour BETWEEN 6 AND 7 and t_time_sk is not null) Please refer to the previous TableScan [TS_6] <-Reducer 2 [SIMPLE_EDGE] @@ -221,7 +221,7 @@ Stage-0 SHUFFLE [RS_175] Group By Operator [GBY_173] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_170] (rows=9600 width=471) + Select Operator [SEL_170] (rows=86400 width=471) Output:["_col0"] Please refer to the previous Select Operator [SEL_167] <-Reducer 19 [BROADCAST_EDGE] vectorized http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query97.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query97.q.out b/ql/src/test/results/clientpositive/perf/tez/query97.q.out index b65b57a..db42b98 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query97.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query97.q.out @@ -93,9 +93,9 @@ Stage-0 <-Map 6 [SIMPLE_EDGE] vectorized SHUFFLE [RS_72] PartitionCols:_col0 - Select Operator [SEL_71] (rows=8116 width=1119) + Select Operator [SEL_71] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_70] (rows=8116 width=1119) + Filter Operator [FIL_70] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"] @@ -116,7 +116,7 @@ Stage-0 SHUFFLE [RS_78] Group By Operator [GBY_76] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_73] (rows=8116 width=1119) + Select Operator [SEL_73] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_71] <-Reducer 9 [ONE_TO_ONE_EDGE] vectorized @@ -152,7 +152,7 @@ Stage-0 SHUFFLE [RS_79] Group By Operator [GBY_77] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_75] (rows=8116 width=1119) + Select Operator [SEL_75] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_71] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/perf/tez/query99.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/perf/tez/query99.q.out b/ql/src/test/results/clientpositive/perf/tez/query99.q.out index 456fd8c..97eb605 100644 --- a/ql/src/test/results/clientpositive/perf/tez/query99.q.out +++ b/ql/src/test/results/clientpositive/perf/tez/query99.q.out @@ -153,9 +153,9 @@ Stage-0 <-Map 8 [SIMPLE_EDGE] vectorized PARTITION_ONLY_SHUFFLE [RS_104] PartitionCols:_col0 - Select Operator [SEL_103] (rows=8116 width=1119) + Select Operator [SEL_103] (rows=73049 width=1119) Output:["_col0"] - Filter Operator [FIL_102] (rows=8116 width=1119) + Filter Operator [FIL_102] (rows=73049 width=1119) predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223) TableScan [TS_3] (rows=73049 width=1119) default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"] @@ -209,7 +209,7 @@ Stage-0 PARTITION_ONLY_SHUFFLE [RS_107] Group By Operator [GBY_106] (rows=1 width=12) Output:["_col0","_col1","_col2"],aggregations:["min(_col0)","max(_col0)","bloom_filter(_col0, expectedEntries=1000000)"] - Select Operator [SEL_105] (rows=8116 width=1119) + Select Operator [SEL_105] (rows=73049 width=1119) Output:["_col0"] Please refer to the previous Select Operator [SEL_103] http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out index 1627af2..098b53a 100644 --- a/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out +++ b/ql/src/test/results/clientpositive/smb_mapjoin_46.q.out @@ -258,11 +258,11 @@ STAGE PLANS: Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key BETWEEN 100 AND 102 (type: boolean) - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: int), col_2 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator filter predicates: 0 {_col0 BETWEEN 100 AND 102} @@ -291,10 +291,10 @@ STAGE PLANS: 0 1 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 6 Data size: 116 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 6 Data size: 116 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/smb_mapjoin_47.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/smb_mapjoin_47.q.out b/ql/src/test/results/clientpositive/smb_mapjoin_47.q.out index 9cc2de4..a5f3fb9 100644 --- a/ql/src/test/results/clientpositive/smb_mapjoin_47.q.out +++ b/ql/src/test/results/clientpositive/smb_mapjoin_47.q.out @@ -112,11 +112,11 @@ STAGE PLANS: Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key BETWEEN 100 AND 102 and value is not null) (type: boolean) - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: int), col_1 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE Sorted Merge Bucket Map Join Operator condition map: Inner Join 0 to 1 @@ -270,11 +270,11 @@ STAGE PLANS: Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key BETWEEN 100 AND 102 (type: boolean) - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: int), col_2 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 38 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator keys: 0 @@ -289,11 +289,11 @@ STAGE PLANS: Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key BETWEEN 100 AND 102 (type: boolean) - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), value (type: int), col_1 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 9 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 6 Data size: 56 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 @@ -301,13 +301,13 @@ STAGE PLANS: 0 1 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 1 Data size: 19 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 1 Data size: 19 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 190 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 19 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 190 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -406,7 +406,7 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 residual filter predicates: {((_col1 = _col4) or _col0 BETWEEN 100 AND 102 or _col3 BETWEEN 100 AND 102)} - Statistics: Num rows: 16 Data size: 317 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 24 Data size: 476 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 Statistics: Num rows: 10 Data size: 190 Basic stats: COMPLETE Column stats: NONE http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning_3.q.out b/ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning_3.q.out index a141409..1f60dcd 100644 --- a/ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning_3.q.out +++ b/ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning_3.q.out @@ -932,11 +932,11 @@ STAGE PLANS: Statistics: Num rows: 3 Data size: 9 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (col1 is not null and col2 BETWEEN 1 AND 3) (type: boolean) - Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 9 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: col1 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 9 Basic stats: COMPLETE Column stats: NONE Spark HashTable Sink Operator keys: 0 _col0 (type: int) @@ -944,15 +944,15 @@ STAGE PLANS: Select Operator expressions: _col0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 9 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col0 (type: int) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 9 Basic stats: COMPLETE Column stats: NONE Spark Partition Pruning Sink Operator Target Columns: [Map 2 -> [part_col:int (part_col)]] - Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 9 Basic stats: COMPLETE Column stats: NONE Local Work: Map Reduce Local Work http://git-wip-us.apache.org/repos/asf/hive/blob/e74eb354/ql/src/test/results/clientpositive/spark/subquery_select.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/subquery_select.q.out b/ql/src/test/results/clientpositive/spark/subquery_select.q.out index dc7a510..8a14d71 100644 --- a/ql/src/test/results/clientpositive/spark/subquery_select.q.out +++ b/ql/src/test/results/clientpositive/spark/subquery_select.q.out @@ -3762,9 +3762,9 @@ STAGE PLANS: Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_size BETWEEN 1 AND 20 (type: boolean) - Statistics: Num rows: 2 Data size: 242 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 2 Data size: 242 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -3783,7 +3783,7 @@ STAGE PLANS: Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_partkey BETWEEN 1 AND 20 (type: boolean) - Statistics: Num rows: 2 Data size: 242 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(p_partkey), count(p_partkey) mode: hash
