Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

englefly commented on code in PR #35925: URL: https://github.com/apache/doris/pull/35925#discussion_r1634133270 ## fe/fe-core/src/main/java/org/apache/doris/nereids/jobs/rewrite/CostBasedRewriteJob.java: ## @@ -41,6 +45,17 @@ public class CostBasedRewriteJob implements RewriteJo

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154411255 ClickBench: Total hot run time: 31.03 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154401178 TPC-DS: Total hot run time: 173023 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154382899 TPC-H: Total hot run time: 40942 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154319584 run buildall -- 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

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154281646 ClickBench: Total hot run time: 31.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154273378 TPC-DS: Total hot run time: 171195 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154256972 TPC-H: Total hot run time: 39991 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2154217809 run buildall -- 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

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2153916604 ClickBench: Total hot run time: 30.8 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools C

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2153901794 TPC-DS: Total hot run time: 171140 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2153874419 TPC-H: Total hot run time: 41667 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2153761764 run buildall -- 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

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2151769820 ClickBench: Total hot run time: 31.5 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools C

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2151759616 TPC-DS: Total hot run time: 174333 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2151734869 TPC-H: Total hot run time: 41074 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2151660957 run buildall -- 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

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2151577404 run buildall -- 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

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2149494661 ClickBench: Total hot run time: 30.65 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2149484353 TPC-DS: Total hot run time: 175056 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2149462564 TPC-H: Total hot run time: 42090 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

doris-robot commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2149385601 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+y

Re: [PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 commented on PR #35925: URL: https://github.com/apache/doris/pull/35925#issuecomment-2149385888 run buildall -- 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

[PR] [Feat](Nereids) support cost based rule hint [doris]

LiBinfeng-01 opened a new pull request, #35925: URL: https://github.com/apache/doris/pull/35925 Add feat of cost based rule hint - usage example /*+ COST_BASED_RULE(PLACE_DISTINCT_INTO_SET) */ /*+ COST_BASED_RULE(NO_PLACE_DISTINCT_INTO_SET) */ - all hints of this kind a