Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
morrySnow merged PR #40698: URL: https://github.com/apache/doris/pull/40698 -- 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.ap

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
github-actions[bot] commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2370249450 PR approved by at least one committer and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
github-actions[bot] commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2370249489 PR approved by anyone and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the UR

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2370134577 run cloud_p0 -- 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2369878832 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2368216919 run p0 -- 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 unsubscrib

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-23 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2367612720 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-22 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2367110066 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-20 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2363080581 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-19 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2362939300 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-19 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2362822443 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 uns

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-19 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2361075448 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2359956889 ClickBench: Total hot run time: 32.56 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2359951926 TPC-DS: Total hot run time: 195653 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2359941451 TPC-H: Total hot run time: 41568 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2359890283 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2359877647 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
xzj7019 commented on code in PR #40698: URL: https://github.com/apache/doris/pull/40698#discussion_r1766076990 ## fe/fe-core/src/main/java/org/apache/doris/nereids/stats/ExpressionEstimation.java: ## @@ -430,7 +457,14 @@ public ColumnStatistic visitBoundFunction(BoundFunction b

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-18 Thread via GitHub
englefly commented on code in PR #40698: URL: https://github.com/apache/doris/pull/40698#discussion_r1766073257 ## fe/fe-core/src/main/java/org/apache/doris/nereids/stats/ExpressionEstimation.java: ## @@ -430,7 +457,14 @@ public ColumnStatistic visitBoundFunction(BoundFunction

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-14 Thread via GitHub
xzj7019 commented on code in PR #40698: URL: https://github.com/apache/doris/pull/40698#discussion_r1759702046 ## fe/fe-core/src/main/java/org/apache/doris/nereids/stats/ExpressionEstimation.java: ## @@ -430,7 +457,14 @@ public ColumnStatistic visitBoundFunction(BoundFunction b

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-12 Thread via GitHub
xzj7019 commented on code in PR #40698: URL: https://github.com/apache/doris/pull/40698#discussion_r1756717759 ## fe/fe-core/src/main/java/org/apache/doris/nereids/stats/FilterEstimation.java: ## @@ -332,7 +332,8 @@ private Statistics estimateEqualTo(ComparisonPredicate cp, Col

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
englefly commented on code in PR #40698: URL: https://github.com/apache/doris/pull/40698#discussion_r1756021675 ## fe/fe-core/src/main/java/org/apache/doris/nereids/stats/ExpressionEstimation.java: ## @@ -430,7 +457,14 @@ public ColumnStatistic visitBoundFunction(BoundFunction

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343765692 ClickBench: Total hot run time: 31.89 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343750567 TPC-DS: Total hot run time: 192387 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343719023 TPC-H: Total hot run time: 39038 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343670987 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343653781 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343648811 TPC-H: Total hot run time: 38717 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343603446 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
xzj7019 commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343569119 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 unsu

Re: [PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
doris-robot commented on PR #40698: URL: https://github.com/apache/doris/pull/40698#issuecomment-2343567542 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

[PR] [opt](nereids) refine expression estimation [doris]

2024-09-11 Thread via GitHub
xzj7019 opened a new pull request, #40698: URL: https://github.com/apache/doris/pull/40698 Stats deriving refinement step 2: refine expression estimation a. refine calculation of avgDataSize b. refine calculation of numNull c. refine literal, etc. d. search cache at first during e