yujun777 commented on code in PR #45081:
URL: https://github.com/apache/doris/pull/45081#discussion_r1879313557
##########
regression-test/data/nereids_hint_tpcds_p0/shape/query13.out:
##########
@@ -7,7 +7,7 @@ PhysicalResultSink
--------PhysicalProject
----------hashJoin[INNER_JOIN broadcast] hashCondition=((store.s_store_sk =
store_sales.ss_store_sk)) otherCondition=() build RFs:RF4
s_store_sk->[ss_store_sk]
------------PhysicalProject
---------------hashJoin[INNER_JOIN shuffle]
hashCondition=((customer_demographics.cd_demo_sk = store_sales.ss_cdemo_sk))
otherCondition=(OR[AND[(household_demographics.hd_dep_count =
1),cd_marital_status IN ('D', 'W'),cd_education_status IN ('2 yr Degree',
'Primary'),OR[AND[(customer_demographics.cd_marital_status =
'D'),(customer_demographics.cd_education_status =
'Primary'),(store_sales.ss_sales_price >= 50.00),(store_sales.ss_sales_price <=
100.00)],AND[(customer_demographics.cd_marital_status =
'W'),(customer_demographics.cd_education_status = '2 yr
Degree'),(store_sales.ss_sales_price >= 150.00),(store_sales.ss_sales_price <=
200.00)]]],AND[(customer_demographics.cd_marital_status =
'M'),(customer_demographics.cd_education_status =
'College'),(store_sales.ss_sales_price >= 100.00),(store_sales.ss_sales_price
<= 150.00),(household_demographics.hd_dep_count = 3)]]) build RFs:RF3
ss_cdemo_sk->[cd_demo_sk]
+--------------hashJoin[INNER_JOIN shuffle]
hashCondition=((customer_demographics.cd_demo_sk = store_sales.ss_cdemo_sk))
otherCondition=(OR[AND[(household_demographics.hd_dep_count =
1),cd_marital_status IN ('D', 'W'),cd_education_status IN ('2 yr Degree',
'Primary'),OR[AND[(customer_demographics.cd_marital_status =
'D'),(customer_demographics.cd_education_status =
'Primary'),(store_sales.ss_sales_price <=
100.00)],AND[(customer_demographics.cd_marital_status =
'W'),(customer_demographics.cd_education_status = '2 yr
Degree'),(store_sales.ss_sales_price >=
150.00)]]],AND[(customer_demographics.cd_marital_status =
'M'),(customer_demographics.cd_education_status =
'College'),(store_sales.ss_sales_price >= 100.00),(store_sales.ss_sales_price
<= 150.00),(household_demographics.hd_dep_count = 3)]]) build RFs:RF3
ss_cdemo_sk->[cd_demo_sk]
Review Comment:
had push down to children
--
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.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
