You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2025/12/17 02:34:25 UTC
[PR] [only test now] check use count in clear_column_data [doris]
Mryange opened a new pull request, #59100:
URL: https://github.com/apache/doris/pull/59100
### 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] [only test now] check use count in clear_column_data [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange closed pull request #59100: [only test now] check use count in clear_column_data
URL: https://github.com/apache/doris/pull/59100
--
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] [only test now] check use count in clear_column_data [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59100:
URL: https://github.com/apache/doris/pull/59100#issuecomment-3663408137
<details>
<summary>TPC-H: <b>Total hot run time: 35471 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 a6c0d08e378201798b221858bf335f145a308bfe, data reload: false
------ Round 1 ----------------------------------
q1 17626 4355 4158 4158
q2 2038 375 246 246
q3 10171 1361 785 785
q4 10238 967 328 328
q5 7566 2102 1975 1975
q6 193 179 139 139
q7 1023 863 712 712
q8 9352 1414 1157 1157
q9 6984 5310 5298 5298
q10 6803 2402 1998 1998
q11 553 326 302 302
q12 642 736 597 597
q13 17783 3670 3071 3071
q14 311 292 275 275
q15 590 536 531 531
q16 688 674 617 617
q17 686 818 550 550
q18 7714 7164 7084 7084
q19 1247 977 621 621
q20 401 357 255 255
q21 4275 3895 3820 3820
q22 1041 1023 952 952
Total cold run time: 107925 ms
Total hot run time: 35471 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4132 4083 4158 4083
q2 344 409 319 319
q3 2184 2667 2247 2247
q4 1374 1750 1285 1285
q5 4243 4770 4643 4643
q6 232 178 133 133
q7 2078 1993 1887 1887
q8 2721 2603 2614 2603
q9 7782 7299 7390 7299
q10 3120 3288 2952 2952
q11 604 529 589 529
q12 811 745 603 603
q13 3555 3825 3265 3265
q14 295 313 299 299
q15 568 522 522 522
q16 688 696 634 634
q17 1283 1467 1412 1412
q18 8073 7728 7557 7557
q19 955 891 905 891
q20 2037 2062 1940 1940
q21 5034 4653 4480 4480
q22 1111 1046 988 988
Total cold run time: 53224 ms
Total hot run time: 50571 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] [only test now] check use count in clear_column_data [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #59100:
URL: https://github.com/apache/doris/pull/59100#issuecomment-3663368045
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] [only test now] check use count in clear_column_data [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #59100:
URL: https://github.com/apache/doris/pull/59100#issuecomment-3663370620
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] [only test now] check use count in clear_column_data [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59100:
URL: https://github.com/apache/doris/pull/59100#issuecomment-3663429624
<details>
<summary>TPC-DS: <b>Total hot run time: 178600 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 a6c0d08e378201798b221858bf335f145a308bfe, data reload: false
query5 4408 586 467 467
query6 342 239 224 224
query7 4227 485 283 283
query8 318 264 257 257
query9 8753 2558 2571 2558
query10 497 392 332 332
query11 15327 15128 14659 14659
query12 199 118 122 118
query13 1280 499 401 401
query14 6246 3164 2741 2741
query14_1 2757 2679 2724 2679
query15 213 200 179 179
query16 768 471 441 441
query17 1116 704 596 596
query18 2566 430 331 331
query19 232 223 201 201
query20 117 117 111 111
query21 213 139 114 114
query22 3868 3879 3932 3879
query23 16539 16198 15943 15943
query23_1 16035 16079 15980 15980
query24 7352 1672 1257 1257
query24_1 1290 1257 1301 1257
query25 583 513 470 470
query26 1246 272 206 206
query27 2709 482 318 318
query28 4490 2132 2138 2132
query29 796 543 442 442
query30 318 249 213 213
query31 829 724 617 617
query32 77 70 67 67
query33 542 343 294 294
query34 916 904 565 565
query35 780 812 765 765
query36 851 921 830 830
query37 128 93 91 91
query38 2848 2900 2866 2866
query39 750 773 728 728
query39_1 693 711 695 695
query40 225 148 134 134
query41 72 70 63 63
query42 115 106 112 106
query43 456 449 417 417
query44 1377 751 747 747
query45 195 193 184 184
query46 904 991 616 616
query47 1658 1650 1616 1616
query48 327 347 245 245
query49 641 447 361 361
query50 692 307 215 215
query51 3797 3801 3849 3801
query52 111 115 108 108
query53 344 355 295 295
query54 295 267 251 251
query55 81 78 71 71
query56 305 312 297 297
query57 1142 1147 1096 1096
query58 269 251 259 251
query59 2341 2453 2379 2379
query60 321 321 296 296
query61 166 167 170 167
query62 708 676 617 617
query63 336 308 306 306
query64 4909 1340 1038 1038
query65 3983 3982 3977 3977
query66 1439 439 329 329
query67 15079 14872 14658 14658
query68 2760 1066 764 764
query69 450 365 332 332
query70 1076 1026 1003 1003
query71 330 298 281 281
query72 6238 5177 5103 5103
query73 520 616 312 312
query74 8644 8879 8491 8491
query75 3117 3171 2790 2790
query76 2835 1171 734 734
query77 372 386 311 311
query78 9465 9714 8888 8888
query79 1079 933 615 615
query80 732 677 563 563
query81 511 266 234 234
query82 1350 141 106 106
query83 366 271 245 245
query84 262 129 113 113
query85 919 537 482 482
query86 319 303 284 284
query87 3095 3077 2890 2890
query88 3264 2276 2257 2257
query89 471 421 386 386
query90 1882 162 144 144
query91 177 169 150 150
query92 69 74 66 66
query93 1035 896 561 561
query94 366 307 287 287
query95 573 341 309 309
query96 599 466 216 216
query97 2274 2302 2237 2237
query98 203 195 195 195
query99 1328 1292 1216 1216
Total cold run time: 251854 ms
Total hot run time: 178600 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] [only test now] check use count in clear_column_data [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59100:
URL: https://github.com/apache/doris/pull/59100#issuecomment-3663439147
<details>
<summary>ClickBench: <b>Total hot run time: 27 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 a6c0d08e378201798b221858bf335f145a308bfe, data reload: false
query1 0.05 0.04 0.05
query2 0.09 0.05 0.05
query3 0.26 0.09 0.08
query4 1.62 0.11 0.11
query5 0.28 0.27 0.27
query6 1.17 0.64 0.62
query7 0.03 0.03 0.02
query8 0.06 0.04 0.04
query9 0.58 0.49 0.50
query10 0.56 0.56 0.54
query11 0.15 0.10 0.12
query12 0.14 0.10 0.10
query13 0.62 0.61 0.59
query14 1.01 1.00 0.97
query15 0.81 0.80 0.80
query16 0.42 0.41 0.39
query17 1.00 0.98 0.98
query18 0.24 0.20 0.22
query19 1.85 1.78 1.80
query20 0.02 0.01 0.01
query21 15.43 0.28 0.15
query22 4.86 0.05 0.05
query23 16.11 0.29 0.10
query24 1.01 0.33 0.19
query25 0.08 0.08 0.06
query26 0.14 0.13 0.14
query27 0.08 0.05 0.05
query28 3.12 1.23 1.02
query29 12.56 4.01 3.21
query30 0.28 0.14 0.11
query31 2.81 0.61 0.38
query32 3.22 0.55 0.46
query33 2.97 2.95 3.09
query34 16.85 5.17 4.56
query35 4.54 4.57 4.56
query36 0.66 0.50 0.49
query37 0.11 0.06 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.04
query40 0.17 0.15 0.13
query41 0.10 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.25 s
Total hot run time: 27 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