Skip to content

Commit d907806

Browse files
committed
rt
1 parent c208da8 commit d907806

14 files changed

Lines changed: 393 additions & 395 deletions

File tree

‎regression-test/data/nereids_rules_p0/eager_aggregate/push_down_count_through_join.out‎

Lines changed: 22 additions & 22 deletions
Original file line numberDiff line numberDiff line change
@@ -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 --
100100
PhysicalResultSink
@@ -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 --
123123
PhysicalResultSink
@@ -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 --
237237
PhysicalResultSink
@@ -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 --
406406
PhysicalResultSink
@@ -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 --
429429
PhysicalResultSink
@@ -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 --
511511
PhysicalResultSink
@@ -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

‎regression-test/data/nereids_rules_p0/eager_aggregate/push_down_sum_through_join.out‎

Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -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[sum_t] apply RFs: RF0
9395
------------hashAgg[LOCAL]
9496
--------------filter((sum_t.score > 10))
9597
----------------PhysicalOlapScan[sum_t]
96-
------------hashAgg[LOCAL]
97-
--------------PhysicalOlapScan[sum_t]
9898

9999
-- !groupby_pushdown_outer_join --
100100
PhysicalResultSink
@@ -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[sum_t] apply RFs: RF0
116118
------------hashAgg[LOCAL]
117119
--------------filter((sum_t.score > 10))
118120
----------------PhysicalOlapScan[sum_t]
119-
------------hashAgg[LOCAL]
120-
--------------PhysicalOlapScan[sum_t]
121121

122122
-- !groupby_pushdown_having --
123123
PhysicalResultSink
@@ -224,12 +224,12 @@ PhysicalResultSink
224224
----hashAgg[GLOBAL]
225225
------PhysicalDistribute[DistributionSpecHash]
226226
--------hashAgg[LOCAL]
227-
----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=()
227+
----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
228+
------------hashAgg[LOCAL]
229+
--------------PhysicalOlapScan[sum_t] apply RFs: RF0
228230
------------hashAgg[LOCAL]
229231
--------------filter((t1.score > 50))
230232
----------------PhysicalOlapScan[sum_t]
231-
------------hashAgg[LOCAL]
232-
--------------PhysicalOlapScan[sum_t]
233233

234234
-- !groupby_pushdown_varied_aggregates --
235235
PhysicalResultSink
@@ -295,9 +295,9 @@ PhysicalResultSink
295295
--------hashAgg[LOCAL]
296296
----------hashJoin[INNER_JOIN] hashCondition=((t1.id = t2.id)) otherCondition=() build RFs:RF0 id->[id]
297297
------------hashAgg[LOCAL]
298-
--------------filter((sum_t.score > 20) and (t1.id < 100))
298+
--------------filter((sum_t.id < 100))
299299
----------------PhysicalOlapScan[sum_t] apply RFs: RF0
300300
------------hashAgg[LOCAL]
301-
--------------filter((sum_t.id < 100))
301+
--------------filter((sum_t.score > 20) and (t1.id < 100))
302302
----------------PhysicalOlapScan[sum_t]
303303

‎regression-test/data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query10.out‎

Lines changed: 20 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -13,28 +13,28 @@ PhysicalResultSink
1313
--------------------hashJoin[LEFT_SEMI_JOIN] hashCondition=((c.c_customer_sk = catalog_sales.cs_ship_customer_sk)) otherCondition=()
1414
----------------------hashJoin[LEFT_SEMI_JOIN] hashCondition=((c.c_customer_sk = web_sales.ws_bill_customer_sk)) otherCondition=()
1515
------------------------PhysicalProject
16-
--------------------------hashJoin[RIGHT_SEMI_JOIN] hashCondition=((c.c_customer_sk = store_sales.ss_customer_sk)) otherCondition=() build RFs:RF5 c_customer_sk->[ss_customer_sk]
17-
----------------------------PhysicalDistribute[DistributionSpecHash]
18-
------------------------------PhysicalProject
19-
--------------------------------hashJoin[INNER_JOIN] hashCondition=((store_sales.ss_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF4 d_date_sk->[ss_sold_date_sk]
20-
----------------------------------PhysicalProject
21-
------------------------------------PhysicalOlapScan[store_sales] apply RFs: RF4 RF5
22-
----------------------------------PhysicalDistribute[DistributionSpecReplicated]
16+
--------------------------hashJoin[INNER_JOIN] hashCondition=((c.c_current_addr_sk = ca.ca_address_sk)) otherCondition=() build RFs:RF5 ca_address_sk->[c_current_addr_sk]
17+
----------------------------hashJoin[INNER_JOIN] hashCondition=((customer_demographics.cd_demo_sk = c.c_current_cdemo_sk)) otherCondition=()
18+
------------------------------PhysicalDistribute[DistributionSpecHash]
19+
--------------------------------hashJoin[RIGHT_SEMI_JOIN] hashCondition=((c.c_customer_sk = store_sales.ss_customer_sk)) otherCondition=() build RFs:RF3 c_customer_sk->[ss_customer_sk]
20+
----------------------------------PhysicalDistribute[DistributionSpecHash]
2321
------------------------------------PhysicalProject
24-
--------------------------------------filter((date_dim.d_moy <= 4) and (date_dim.d_moy >= 1) and (date_dim.d_year = 2001))
25-
----------------------------------------PhysicalOlapScan[date_dim]
26-
----------------------------PhysicalDistribute[DistributionSpecHash]
27-
------------------------------hashJoin[INNER_JOIN] hashCondition=((customer_demographics.cd_demo_sk = c.c_current_cdemo_sk)) otherCondition=()
28-
--------------------------------PhysicalDistribute[DistributionSpecHash]
29-
----------------------------------hashJoin[INNER_JOIN] hashCondition=((c.c_current_addr_sk = ca.ca_address_sk)) otherCondition=() build RFs:RF2 ca_address_sk->[c_current_addr_sk]
22+
--------------------------------------hashJoin[INNER_JOIN] hashCondition=((store_sales.ss_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF2 d_date_sk->[ss_sold_date_sk]
23+
----------------------------------------PhysicalProject
24+
------------------------------------------PhysicalOlapScan[store_sales] apply RFs: RF2 RF3
25+
----------------------------------------PhysicalDistribute[DistributionSpecReplicated]
26+
------------------------------------------PhysicalProject
27+
--------------------------------------------filter((date_dim.d_moy <= 4) and (date_dim.d_moy >= 1) and (date_dim.d_year = 2001))
28+
----------------------------------------------PhysicalOlapScan[date_dim]
29+
----------------------------------PhysicalDistribute[DistributionSpecHash]
3030
------------------------------------PhysicalProject
31-
--------------------------------------PhysicalOlapScan[customer] apply RFs: RF2
32-
------------------------------------PhysicalDistribute[DistributionSpecReplicated]
33-
--------------------------------------PhysicalProject
34-
----------------------------------------filter(ca_county IN ('Cochran County', 'Kandiyohi County', 'Marquette County', 'Storey County', 'Warren County'))
35-
------------------------------------------PhysicalOlapScan[customer_address]
36-
--------------------------------PhysicalDistribute[DistributionSpecHash]
37-
----------------------------------PhysicalOlapScan[customer_demographics]
31+
--------------------------------------PhysicalOlapScan[customer] apply RFs: RF5
32+
------------------------------PhysicalDistribute[DistributionSpecHash]
33+
--------------------------------PhysicalOlapScan[customer_demographics]
34+
----------------------------PhysicalDistribute[DistributionSpecReplicated]
35+
------------------------------PhysicalProject
36+
--------------------------------filter(ca_county IN ('Cochran County', 'Kandiyohi County', 'Marquette County', 'Storey County', 'Warren County'))
37+
----------------------------------PhysicalOlapScan[customer_address]
3838
------------------------PhysicalDistribute[DistributionSpecReplicated]
3939
--------------------------PhysicalProject
4040
----------------------------hashJoin[INNER_JOIN] hashCondition=((web_sales.ws_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF1 d_date_sk->[ws_sold_date_sk]

‎regression-test/data/nereids_tpcds_shape_sf100_p0/noStatsRfPrune/query35.out‎

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -13,29 +13,29 @@ PhysicalResultSink
1313
--------------------hashJoin[LEFT_SEMI_JOIN] hashCondition=((c.c_customer_sk = catalog_sales.cs_ship_customer_sk)) otherCondition=()
1414
----------------------hashJoin[LEFT_SEMI_JOIN] hashCondition=((c.c_customer_sk = web_sales.ws_bill_customer_sk)) otherCondition=()
1515
------------------------PhysicalProject
16-
--------------------------hashJoin[RIGHT_SEMI_JOIN] hashCondition=((c.c_customer_sk = store_sales.ss_customer_sk)) otherCondition=()
17-
----------------------------PhysicalDistribute[DistributionSpecHash]
18-
------------------------------PhysicalProject
19-
--------------------------------hashJoin[INNER_JOIN] hashCondition=((store_sales.ss_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF4 d_date_sk->[ss_sold_date_sk]
20-
----------------------------------PhysicalProject
21-
------------------------------------PhysicalOlapScan[store_sales] apply RFs: RF4
22-
----------------------------------PhysicalDistribute[DistributionSpecReplicated]
23-
------------------------------------PhysicalProject
24-
--------------------------------------filter((date_dim.d_qoy < 4) and (date_dim.d_year = 2001))
25-
----------------------------------------PhysicalOlapScan[date_dim]
16+
--------------------------hashJoin[INNER_JOIN] hashCondition=((c.c_current_addr_sk = ca.ca_address_sk)) otherCondition=()
2617
----------------------------PhysicalDistribute[DistributionSpecHash]
2718
------------------------------hashJoin[INNER_JOIN] hashCondition=((customer_demographics.cd_demo_sk = c.c_current_cdemo_sk)) otherCondition=()
2819
--------------------------------PhysicalDistribute[DistributionSpecHash]
29-
----------------------------------hashJoin[INNER_JOIN] hashCondition=((c.c_current_addr_sk = ca.ca_address_sk)) otherCondition=()
20+
----------------------------------hashJoin[RIGHT_SEMI_JOIN] hashCondition=((c.c_customer_sk = store_sales.ss_customer_sk)) otherCondition=()
3021
------------------------------------PhysicalDistribute[DistributionSpecHash]
3122
--------------------------------------PhysicalProject
32-
----------------------------------------PhysicalOlapScan[customer]
23+
----------------------------------------hashJoin[INNER_JOIN] hashCondition=((store_sales.ss_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF2 d_date_sk->[ss_sold_date_sk]
24+
------------------------------------------PhysicalProject
25+
--------------------------------------------PhysicalOlapScan[store_sales] apply RFs: RF2
26+
------------------------------------------PhysicalDistribute[DistributionSpecReplicated]
27+
--------------------------------------------PhysicalProject
28+
----------------------------------------------filter((date_dim.d_qoy < 4) and (date_dim.d_year = 2001))
29+
------------------------------------------------PhysicalOlapScan[date_dim]
3330
------------------------------------PhysicalDistribute[DistributionSpecHash]
3431
--------------------------------------PhysicalProject
35-
----------------------------------------PhysicalOlapScan[customer_address]
32+
----------------------------------------PhysicalOlapScan[customer]
3633
--------------------------------PhysicalDistribute[DistributionSpecHash]
3734
----------------------------------PhysicalProject
3835
------------------------------------PhysicalOlapScan[customer_demographics]
36+
----------------------------PhysicalDistribute[DistributionSpecHash]
37+
------------------------------PhysicalProject
38+
--------------------------------PhysicalOlapScan[customer_address]
3939
------------------------PhysicalDistribute[DistributionSpecReplicated]
4040
--------------------------PhysicalProject
4141
----------------------------hashJoin[INNER_JOIN] hashCondition=((web_sales.ws_sold_date_sk = date_dim.d_date_sk)) otherCondition=() build RFs:RF1 d_date_sk->[ws_sold_date_sk]

0 commit comments

Comments
 (0)