@@ -89,12 +89,12 @@ PhysicalResultSink
8989----hashAgg[GLOBAL]
9090------PhysicalDistribute[DistributionSpecHash]
9191--------hashAgg[LOCAL]
92- ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
92+ ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
93+ ------------hashAgg[LOCAL]
94+ --------------PhysicalOlapScan[count_t] apply RFs: RF0
9395------------hashAgg[LOCAL]
9496--------------filter((count_t.score > 10))
9597----------------PhysicalOlapScan[count_t]
96- ------------hashAgg[LOCAL]
97- --------------PhysicalOlapScan[count_t]
9898
9999-- !groupby_pushdown_outer_join --
100100PhysicalResultSink
@@ -112,12 +112,12 @@ PhysicalResultSink
112112----hashAgg[GLOBAL]
113113------PhysicalDistribute[DistributionSpecHash]
114114--------hashAgg[LOCAL]
115- ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
115+ ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
116+ ------------hashAgg[LOCAL]
117+ --------------PhysicalOlapScan[count_t] apply RFs: RF0
116118------------hashAgg[LOCAL]
117119--------------filter((count_t.score > 10))
118120----------------PhysicalOlapScan[count_t]
119- ------------hashAgg[LOCAL]
120- --------------PhysicalOlapScan[count_t]
121121
122122-- !groupby_pushdown_having --
123123PhysicalResultSink
@@ -226,12 +226,12 @@ PhysicalResultSink
226226----hashAgg[GLOBAL]
227227------PhysicalDistribute[DistributionSpecHash]
228228--------hashAgg[LOCAL]
229- ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
229+ ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
230+ ------------hashAgg[LOCAL]
231+ --------------PhysicalOlapScan[count_t] apply RFs: RF0
230232------------hashAgg[LOCAL]
231233--------------filter((t1.score > 50))
232234----------------PhysicalOlapScan[count_t]
233- ------------hashAgg[LOCAL]
234- --------------PhysicalOlapScan[count_t]
235235
236236-- !groupby_pushdown_varied_aggregates --
237237PhysicalResultSink
@@ -297,10 +297,10 @@ PhysicalResultSink
297297--------hashAgg[LOCAL]
298298----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
299299------------hashAgg[LOCAL]
300- --------------filter((count_t.score > 20) and (t1. id < 100))
300+ --------------filter((count_t.id < 100))
301301----------------PhysicalOlapScan[count_t] apply RFs: RF0
302302------------hashAgg[LOCAL]
303- --------------filter((count_t.id < 100))
303+ --------------filter((count_t.score > 20) and (t1. id < 100))
304304----------------PhysicalOlapScan[count_t]
305305
306306-- !groupby_pushdown_basic --
@@ -395,12 +395,12 @@ PhysicalResultSink
395395----hashAgg[GLOBAL]
396396------PhysicalDistribute[DistributionSpecHash]
397397--------hashAgg[LOCAL]
398- ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
398+ ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
399+ ------------hashAgg[LOCAL]
400+ --------------PhysicalOlapScan[count_t] apply RFs: RF0
399401------------hashAgg[LOCAL]
400402--------------filter((count_t.score > 10))
401403----------------PhysicalOlapScan[count_t]
402- ------------hashAgg[LOCAL]
403- --------------PhysicalOlapScan[count_t]
404404
405405-- !groupby_pushdown_outer_join --
406406PhysicalResultSink
@@ -418,12 +418,12 @@ PhysicalResultSink
418418----hashAgg[GLOBAL]
419419------PhysicalDistribute[DistributionSpecHash]
420420--------hashAgg[LOCAL]
421- ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
421+ ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
422+ ------------hashAgg[LOCAL]
423+ --------------PhysicalOlapScan[count_t] apply RFs: RF0
422424------------hashAgg[LOCAL]
423425--------------filter((count_t.score > 10))
424426----------------PhysicalOlapScan[count_t]
425- ------------hashAgg[LOCAL]
426- --------------PhysicalOlapScan[count_t]
427427
428428-- !groupby_pushdown_having --
429429PhysicalResultSink
@@ -500,12 +500,12 @@ PhysicalResultSink
500500----hashAgg[GLOBAL]
501501------PhysicalDistribute[DistributionSpecHash]
502502--------hashAgg[LOCAL]
503- ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
503+ ----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
504+ ------------hashAgg[LOCAL]
505+ --------------PhysicalOlapScan[count_t] apply RFs: RF0
504506------------hashAgg[LOCAL]
505507--------------filter((t1.score > 50))
506508----------------PhysicalOlapScan[count_t]
507- ------------hashAgg[LOCAL]
508- --------------PhysicalOlapScan[count_t]
509509
510510-- !groupby_pushdown_varied_aggregates --
511511PhysicalResultSink
@@ -549,9 +549,9 @@ PhysicalResultSink
549549--------hashAgg[LOCAL]
550550----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
551551------------hashAgg[LOCAL]
552- --------------filter((count_t.score > 20) and (t1. id < 100))
552+ --------------filter((count_t.id < 100))
553553----------------PhysicalOlapScan[count_t] apply RFs: RF0
554554------------hashAgg[LOCAL]
555- --------------filter((count_t.id < 100))
555+ --------------filter((count_t.score > 20) and (t1. id < 100))
556556----------------PhysicalOlapScan[count_t]
557557
0 commit comments