kgyrtkirk commented on a change in pull request #1553:
URL: https://github.com/apache/hive/pull/1553#discussion_r503840610
##########
File path: ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out
##########
@@ -103,102 +107,143 @@ Stage-0
Top N Key Operator [TNK_99] (rows=6951 width=218)
keys:_col1,top n:100
Merge Join Operator [MERGEJOIN_116] (rows=6951 width=218)
-
Conds:RS_66._col2=RS_146._col0(Inner),Output:["_col1","_col5","_col7"]
- <-Map 11 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_146]
+
Conds:RS_66._col2=RS_163._col0(Inner),Output:["_col1","_col5","_col7"]
+ <-Map 14 [SIMPLE_EDGE] vectorized
+ SHUFFLE [RS_163]
PartitionCols:_col0
- Select Operator [SEL_144] (rows=462000 width=111)
+ Select Operator [SEL_161] (rows=462000 width=111)
Output:["_col0","_col1"]
TableScan [TS_56] (rows=462000 width=111)
default@item,i1,Tbl:COMPLETE,Col:COMPLETE,Output:["i_item_sk","i_product_name"]
<-Reducer 6 [SIMPLE_EDGE]
SHUFFLE [RS_66]
PartitionCols:_col2
Merge Join Operator [MERGEJOIN_115] (rows=6951 width=115)
-
Conds:RS_63._col0=RS_145._col0(Inner),Output:["_col1","_col2","_col5"]
- <-Map 11 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_145]
+
Conds:RS_63._col0=RS_162._col0(Inner),Output:["_col1","_col2","_col5"]
+ <-Map 14 [SIMPLE_EDGE] vectorized
+ SHUFFLE [RS_162]
PartitionCols:_col0
- Please refer to the previous Select Operator
[SEL_144]
+ Please refer to the previous Select Operator
[SEL_161]
<-Reducer 5 [SIMPLE_EDGE]
SHUFFLE [RS_63]
PartitionCols:_col0
Merge Join Operator [MERGEJOIN_114] (rows=6951
width=12)
-
Conds:RS_138._col1=RS_143._col1(Inner),Output:["_col0","_col1","_col2"]
- <-Reducer 4 [SIMPLE_EDGE] vectorized
- SHUFFLE [RS_138]
+
Conds:RS_146._col1=RS_160._col1(Inner),Output:["_col0","_col1","_col2"]
+ <-Reducer 12 [SIMPLE_EDGE] vectorized
+ SHUFFLE [RS_160]
PartitionCols:_col1
- Select Operator [SEL_137] (rows=6951 width=8)
+ Select Operator [SEL_159] (rows=6951 width=8)
Output:["_col0","_col1"]
- Filter Operator [FIL_136] (rows=6951 width=116)
+ Filter Operator [FIL_158] (rows=6951 width=116)
predicate:(rank_window_0 < 11)
- PTF Operator [PTF_135] (rows=20854 width=116)
- Function
definitions:[{},{"name:":"windowingtablefunction","order by:":"_col1 ASC NULLS
LAST","partition by:":"0"}]
- Select Operator [SEL_134] (rows=20854
width=116)
+ PTF Operator [PTF_157] (rows=20854 width=116)
+ Function
definitions:[{},{"name:":"windowingtablefunction","order by:":"_col1 DESC NULLS
FIRST","partition by:":"0"}]
+ Select Operator [SEL_156] (rows=20854
width=116)
Output:["_col0","_col1"]
- <-Reducer 3 [SIMPLE_EDGE]
- SHUFFLE [RS_21]
+ <-Reducer 11 [SIMPLE_EDGE]
+ SHUFFLE [RS_49]
PartitionCols:0
- Top N Key Operator [TNK_100]
(rows=20854 width=228)
+ Top N Key Operator [TNK_101]
(rows=20854 width=228)
keys:_col1,top n:11
- Filter Operator [FIL_20] (rows=20854
width=228)
+ Filter Operator [FIL_48] (rows=20854
width=228)
predicate:(_col1 > (0.9 * _col2))
- Merge Join Operator
[MERGEJOIN_112] (rows=62562 width=228)
+ Merge Join Operator
[MERGEJOIN_113] (rows=62562 width=228)
Conds:(Inner),Output:["_col0","_col1","_col2"]
<-Reducer 10 [CUSTOM_SIMPLE_EDGE]
vectorized
- PARTITION_ONLY_SHUFFLE [RS_133]
- Select Operator [SEL_132]
(rows=1 width=112)
+ PARTITION_ONLY_SHUFFLE [RS_150]
+ Select Operator [SEL_149]
(rows=62562 width=116)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_148]
(rows=62562 width=124)
+ predicate:CAST( (_col1 /
_col2) AS decimal(11,6)) is not null
+ Group By Operator
[GBY_147] (rows=62562 width=124)
+
Output:["_col0","_col1","_col2"],aggregations:["sum(VALUE._col0)","count(VALUE._col1)"],keys:KEY._col0
+ <-Map 1 [SIMPLE_EDGE]
vectorized
+ SHUFFLE [RS_131]
+ PartitionCols:_col0
+ Group By Operator
[GBY_127] (rows=3199976 width=124)
+
Output:["_col0","_col1","_col2"],aggregations:["sum(ss_net_profit)","count(ss_net_profit)"],keys:ss_item_sk
+ Select Operator
[SEL_123] (rows=6399952 width=114)
+
Output:["ss_item_sk","ss_net_profit"]
+ Filter Operator
[FIL_119] (rows=6399952 width=114)
+
predicate:(ss_store_sk = 410)
+ TableScan [TS_0]
(rows=575995635 width=114)
+
default@store_sales,ss1,Tbl:COMPLETE,Col:COMPLETE,Output:["ss_item_sk","ss_store_sk","ss_net_profit","ss_hdemo_sk"]
Review comment:
gone back to master state in latest update
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
