You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2026/01/06 02:27:25 UTC
[PR] [dnm](cbo) optimize exploration in memo [doris]
morrySnow opened a new pull request, #59582:
URL: https://github.com/apache/doris/pull/59582
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59582:
URL: https://github.com/apache/doris/pull/59582#issuecomment-3712970572
<details>
<summary>ClickBench: <b>Total hot run time: 27.18 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 32e0e7e42f15488680c846513f4cc6f5b5a7fe19, data reload: false
query1 0.06 0.05 0.05
query2 0.32 0.05 0.05
query3 0.37 0.09 0.09
query4 1.60 0.11 0.11
query5 0.28 0.26 0.26
query6 1.15 0.67 0.65
query7 0.04 0.03 0.03
query8 0.06 0.04 0.04
query9 0.60 0.50 0.49
query10 0.57 0.55 0.57
query11 0.23 0.10 0.09
query12 0.20 0.11 0.11
query13 0.61 0.60 0.59
query14 0.96 0.95 0.95
query15 0.79 0.79 0.79
query16 0.39 0.40 0.40
query17 1.01 1.07 1.05
query18 0.24 0.22 0.21
query19 1.99 1.90 1.74
query20 0.02 0.02 0.01
query21 15.59 0.30 0.14
query22 5.09 0.06 0.04
query23 16.02 0.28 0.10
query24 4.02 0.56 1.05
query25 0.12 0.12 0.11
query26 0.14 0.14 0.13
query27 0.06 0.07 0.05
query28 5.84 1.03 0.88
query29 12.63 3.90 3.13
query30 0.28 0.14 0.13
query31 2.83 0.63 0.39
query32 3.24 0.57 0.46
query33 3.06 3.07 3.00
query34 16.47 5.08 4.50
query35 4.48 4.47 4.46
query36 0.67 0.50 0.49
query37 0.19 0.06 0.06
query38 0.11 0.04 0.04
query39 0.06 0.03 0.04
query40 0.18 0.15 0.13
query41 0.12 0.03 0.03
query42 0.07 0.03 0.03
query43 0.06 0.03 0.03
Total cold run time: 102.82 s
Total hot run time: 27.18 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow closed pull request #59582: [dnm](cbo) optimize exploration in memo
URL: https://github.com/apache/doris/pull/59582
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #59582:
URL: https://github.com/apache/doris/pull/59582#issuecomment-3712856694
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+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #59582:
URL: https://github.com/apache/doris/pull/59582#issuecomment-3712856674
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 unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59582:
URL: https://github.com/apache/doris/pull/59582#issuecomment-3712944094
<details>
<summary>TPC-H: <b>Total hot run time: 31343 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 32e0e7e42f15488680c846513f4cc6f5b5a7fe19, data reload: false
------ Round 1 ----------------------------------
q1 17713 4332 4078 4078
q2 2156 349 237 237
q3 10201 1300 718 718
q4 10217 842 316 316
q5 7481 2082 1828 1828
q6 188 168 140 140
q7 915 802 651 651
q8 9274 1379 1159 1159
q9 4860 4587 4511 4511
q10 7125 1805 1407 1407
q11 560 292 286 286
q12 700 764 569 569
q13 17873 3793 3054 3054
q14 289 291 277 277
q15 583 522 511 511
q16 665 656 617 617
q17 711 776 574 574
q18 6609 6425 6344 6344
q19 1128 965 604 604
q20 389 360 245 245
q21 3058 2428 2294 2294
q22 1026 961 923 923
Total cold run time: 103721 ms
Total hot run time: 31343 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4129 4021 4037 4021
q2 322 395 319 319
q3 2082 2595 2205 2205
q4 1313 1724 1337 1337
q5 4114 3984 4019 3984
q6 212 172 131 131
q7 1836 1783 1960 1783
q8 2593 2412 2406 2406
q9 7181 7100 7084 7084
q10 2492 2746 2297 2297
q11 564 512 473 473
q12 755 733 621 621
q13 3586 4014 3280 3280
q14 294 297 277 277
q15 542 518 496 496
q16 941 711 626 626
q17 1142 1273 1343 1273
q18 7973 7912 7621 7621
q19 889 886 928 886
q20 1965 2095 1950 1950
q21 4851 4612 4339 4339
q22 1137 1108 1060 1060
Total cold run time: 50913 ms
Total hot run time: 48469 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59582:
URL: https://github.com/apache/doris/pull/59582#issuecomment-3712962113
<details>
<summary>TPC-DS: <b>Total hot run time: 172789 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 32e0e7e42f15488680c846513f4cc6f5b5a7fe19, data reload: false
query5 4447 579 430 430
query6 329 217 202 202
query7 4212 461 264 264
query8 337 247 271 247
query9 8748 2643 2650 2643
query10 506 397 326 326
query11 15224 15169 14789 14789
query12 174 113 109 109
query13 1257 488 398 398
query14 6156 3016 2794 2794
query14_1 2653 2613 2635 2613
query15 205 194 174 174
query16 1059 473 438 438
query17 1102 676 576 576
query18 2423 428 331 331
query19 226 229 196 196
query20 127 124 115 115
query21 390 142 119 119
query22 3934 4116 3940 3940
query23 15915 15745 15396 15396
query23_1 15401 15638 15389 15389
query24 7369 1571 1146 1146
query24_1 1197 1191 1220 1191
query25 607 489 377 377
query26 1299 268 163 163
query27 2694 456 290 290
query28 4521 2136 2133 2133
query29 736 526 424 424
query30 326 236 222 222
query31 780 601 555 555
query32 77 72 67 67
query33 517 314 271 271
query34 883 886 536 536
query35 732 777 715 715
query36 852 885 798 798
query37 158 88 74 74
query38 2785 2749 2714 2714
query39 803 759 721 721
query39_1 719 701 700 700
query40 227 131 114 114
query41 65 62 63 62
query42 109 102 101 101
query43 427 475 411 411
query44 1317 718 721 718
query45 187 184 176 176
query46 853 959 590 590
query47 1353 1459 1344 1344
query48 311 317 240 240
query49 594 417 320 320
query50 658 281 205 205
query51 3800 3883 3760 3760
query52 108 103 99 99
query53 290 320 272 272
query54 295 235 232 232
query55 76 75 75 75
query56 275 284 298 284
query57 1053 972 944 944
query58 261 253 252 252
query59 1953 2081 1913 1913
query60 308 303 292 292
query61 153 149 146 146
query62 399 365 305 305
query63 300 260 269 260
query64 4921 1326 992 992
query65 3784 3719 3783 3719
query66 1445 414 299 299
query67 14916 15236 15533 15236
query68 4719 1022 710 710
query69 491 346 305 305
query70 1061 950 960 950
query71 373 299 276 276
query72 6148 3407 3541 3407
query73 766 739 304 304
query74 8858 8894 8585 8585
query75 2817 2799 2505 2505
query76 3804 1061 643 643
query77 532 365 279 279
query78 9630 9777 9140 9140
query79 1186 916 594 594
query80 648 574 466 466
query81 497 266 228 228
query82 359 146 109 109
query83 265 267 242 242
query84 258 121 103 103
query85 862 488 424 424
query86 320 305 320 305
query87 2839 2889 2736 2736
query88 3226 2240 2244 2240
query89 393 339 333 333
query90 1958 160 141 141
query91 162 171 142 142
query92 71 69 62 62
query93 1091 900 558 558
query94 567 322 313 313
query95 584 327 356 327
query96 604 470 205 205
query97 2336 2356 2331 2331
query98 227 204 195 195
query99 611 605 538 538
Total cold run time: 250309 ms
Total hot run time: 172789 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [dnm](cbo) optimize exploration in memo [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59582:
URL: https://github.com/apache/doris/pull/59582#issuecomment-3713240184
# FE Regression Coverage Report
Increment line coverage ` 100% (0/0)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59582_32e0e7e42f15488680c846513f4cc6f5b5a7fe19_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59582_32e0e7e42f15488680c846513f4cc6f5b5a7fe19_merge_fe/report/index.html)
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org