You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2025/10/15 10:01:47 UTC
[PR] [fix](ut)fix ut AlterMTMVTest [doris]
zddr opened a new pull request, #56997:
URL: https://github.com/apache/doris/pull/56997
### What problem does this PR solve?
MTMV may nit refresh finish when getCandidateMTMVs
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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3405804235
<details>
<summary>TPC-DS: <b>Total hot run time: 189764 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 3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3, data reload: false
query1 1065 453 429 429
query2 6562 1709 1669 1669
query3 6771 224 228 224
query4 26171 23281 23027 23027
query5 4542 623 474 474
query6 341 242 238 238
query7 4655 509 304 304
query8 349 279 261 261
query9 8695 2577 2586 2577
query10 509 367 300 300
query11 15761 15585 14781 14781
query12 195 123 117 117
query13 1694 586 457 457
query14 12800 9336 9313 9313
query15 271 197 178 178
query16 7861 728 584 584
query17 1888 855 714 714
query18 2184 451 385 385
query19 491 213 180 180
query20 150 127 124 124
query21 216 149 119 119
query22 4805 4954 4765 4765
query23 34733 33896 33715 33715
query24 8310 2532 2540 2532
query25 572 551 470 470
query26 1233 281 164 164
query27 2746 533 367 367
query28 4634 2186 2177 2177
query29 795 653 531 531
query30 304 232 212 212
query31 928 834 723 723
query32 85 70 70 70
query33 597 381 331 331
query34 804 866 520 520
query35 795 824 732 732
query36 963 1012 917 917
query37 126 123 94 94
query38 3499 3498 3434 3434
query39 1467 1421 1413 1413
query40 218 128 115 115
query41 62 63 59 59
query42 123 114 122 114
query43 493 492 489 489
query44 1359 831 828 828
query45 184 178 173 173
query46 842 995 647 647
query47 1752 1829 1702 1702
query48 407 424 323 323
query49 773 516 417 417
query50 672 695 401 401
query51 3915 3893 3921 3893
query52 111 112 98 98
query53 237 275 210 210
query54 602 607 528 528
query55 89 90 88 88
query56 329 319 295 295
query57 1179 1193 1141 1141
query58 309 282 283 282
query59 2510 2618 2512 2512
query60 359 341 332 332
query61 159 154 152 152
query62 804 702 650 650
query63 235 205 203 203
query64 4402 1222 850 850
query65 4025 3948 3991 3948
query66 1087 433 334 334
query67 15388 15276 15091 15091
query68 9561 959 603 603
query69 482 326 296 296
query70 1396 1326 1321 1321
query71 507 357 305 305
query72 5948 4829 4747 4747
query73 714 591 430 430
query74 8828 9128 8734 8734
query75 4518 3359 2890 2890
query76 4574 1169 760 760
query77 1033 430 317 317
query78 9509 9801 8786 8786
query79 5482 839 583 583
query80 727 571 510 510
query81 489 256 225 225
query82 494 168 138 138
query83 298 276 258 258
query84 341 107 95 95
query85 869 469 420 420
query86 345 313 278 278
query87 3900 3816 3624 3624
query88 2963 2270 2243 2243
query89 448 337 303 303
query90 2182 219 223 219
query91 164 167 136 136
query92 89 71 66 66
query93 3266 964 639 639
query94 696 439 343 343
query95 411 317 319 317
query96 495 611 284 284
query97 2913 2964 2869 2869
query98 230 225 214 214
query99 1425 1386 1314 1314
Total cold run time: 288489 ms
Total hot run time: 189764 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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3405906164
# FE UT Coverage Report
Increment line coverage `` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56997_3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56997_3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3/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
Re: [PR] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3435851834
# FE UT Coverage Report
Increment line coverage `` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56997_3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56997_3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3/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
Re: [PR] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3440848554
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
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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3405592327
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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3435781334
<details>
<summary>ClickBench: <b>Total hot run time: 29.57 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 3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3, data reload: false
query1 0.07 0.06 0.05
query2 0.11 0.05 0.06
query3 0.26 0.09 0.10
query4 1.61 0.12 0.12
query5 0.30 0.28 0.27
query6 1.17 0.69 0.68
query7 0.04 0.03 0.03
query8 0.06 0.06 0.05
query9 0.66 0.58 0.57
query10 0.63 0.62 0.62
query11 0.18 0.13 0.13
query12 0.18 0.13 0.16
query13 0.63 0.62 0.61
query14 1.05 1.03 1.05
query15 0.89 0.90 0.90
query16 0.42 0.43 0.42
query17 1.11 1.15 1.18
query18 0.23 0.21 0.23
query19 2.01 1.86 1.96
query20 0.02 0.02 0.01
query21 15.41 0.21 0.15
query22 5.03 0.08 0.05
query23 15.64 0.29 0.12
query24 2.24 1.31 0.86
query25 0.08 0.07 0.06
query26 0.16 0.15 0.17
query27 0.06 0.06 0.06
query28 4.82 1.18 0.98
query29 12.58 4.62 3.74
query30 0.30 0.16 0.12
query31 2.84 0.64 0.41
query32 3.24 0.59 0.49
query33 3.09 3.18 3.21
query34 15.81 5.22 4.66
query35 4.67 4.65 4.70
query36 0.69 0.53 0.50
query37 0.10 0.08 0.07
query38 0.07 0.05 0.05
query39 0.04 0.03 0.04
query40 0.19 0.15 0.14
query41 0.10 0.04 0.04
query42 0.04 0.04 0.03
query43 0.06 0.05 0.05
Total cold run time: 98.89 s
Total hot run time: 29.57 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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3435640784
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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3440848409
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 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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #56997:
URL: https://github.com/apache/doris/pull/56997
--
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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3405592767
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] [fix](ut)fix ut AlterMTMVTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56997:
URL: https://github.com/apache/doris/pull/56997#issuecomment-3405822941
<details>
<summary>ClickBench: <b>Total hot run time: 30.11 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 3bf7db8f1e98234ce4da4f74af22c3c34f2d50c3, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.05 0.06
query3 0.25 0.08 0.08
query4 1.61 0.11 0.12
query5 0.27 0.26 0.25
query6 1.17 0.66 0.63
query7 0.03 0.03 0.03
query8 0.06 0.05 0.05
query9 0.62 0.53 0.54
query10 0.57 0.58 0.56
query11 0.17 0.11 0.12
query12 0.16 0.12 0.13
query13 0.64 0.61 0.62
query14 1.00 1.05 1.03
query15 0.86 0.85 0.86
query16 0.40 0.40 0.39
query17 1.04 1.05 1.03
query18 0.22 0.20 0.20
query19 1.92 1.81 1.81
query20 0.02 0.01 0.02
query21 15.43 0.94 0.57
query22 0.77 1.26 0.66
query23 14.86 1.41 0.60
query24 6.56 2.05 0.51
query25 0.50 0.24 0.13
query26 0.69 0.16 0.13
query27 0.07 0.06 0.05
query28 9.61 1.39 0.94
query29 12.61 4.00 3.32
query30 0.30 0.14 0.13
query31 2.84 0.59 0.38
query32 3.24 0.56 0.49
query33 3.05 3.07 3.14
query34 16.07 5.47 4.86
query35 4.88 4.90 4.90
query36 0.69 0.51 0.51
query37 0.10 0.07 0.08
query38 0.06 0.05 0.04
query39 0.04 0.03 0.02
query40 0.18 0.15 0.16
query41 0.08 0.04 0.03
query42 0.04 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 103.86 s
Total hot run time: 30.11 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