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/08 10:41:02 UTC
[PR] [WIP only test] sort [doris]
Mryange opened a new pull request, #58822:
URL: https://github.com/apache/doris/pull/58822
### 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] [WIP only test] sort [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3644319353
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] [WIP only test] sort [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3644620154
<details>
<summary>ClickBench: <b>Total hot run time: 27.15 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 f70ac3d79a1834efb5278129ffd15232c640532a, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.04 0.04
query3 0.25 0.09 0.09
query4 1.61 0.11 0.12
query5 0.27 0.26 0.26
query6 1.20 0.63 0.64
query7 0.03 0.03 0.03
query8 0.06 0.04 0.05
query9 0.58 0.50 0.52
query10 0.54 0.57 0.55
query11 0.15 0.10 0.10
query12 0.15 0.12 0.12
query13 0.61 0.60 0.61
query14 0.99 0.97 0.98
query15 0.80 0.79 0.81
query16 0.39 0.39 0.40
query17 1.03 1.03 1.06
query18 0.23 0.21 0.21
query19 1.86 1.73 1.85
query20 0.02 0.02 0.01
query21 15.46 0.31 0.14
query22 4.77 0.06 0.06
query23 16.10 0.28 0.10
query24 1.27 0.30 0.48
query25 0.06 0.10 0.07
query26 0.14 0.14 0.14
query27 0.14 0.06 0.06
query28 4.01 1.22 1.02
query29 12.59 3.98 3.17
query30 0.28 0.14 0.12
query31 2.83 0.61 0.41
query32 3.23 0.54 0.46
query33 2.95 3.01 3.01
query34 16.72 5.21 4.50
query35 4.55 4.50 4.63
query36 0.66 0.50 0.49
query37 0.11 0.07 0.06
query38 0.07 0.05 0.04
query39 0.05 0.03 0.03
query40 0.16 0.14 0.15
query41 0.09 0.04 0.03
query42 0.04 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 97.23 s
Total hot run time: 27.15 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] [WIP only test] sort [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3640248851
<details>
<summary>ClickBench: <b>Total hot run time: 27.36 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 f70ac3d79a1834efb5278129ffd15232c640532a, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.09 0.09
query4 1.60 0.11 0.11
query5 0.27 0.25 0.26
query6 1.16 0.64 0.63
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.59 0.51 0.50
query10 0.56 0.54 0.57
query11 0.15 0.10 0.12
query12 0.14 0.10 0.11
query13 0.61 0.60 0.62
query14 1.00 0.98 0.98
query15 0.83 0.82 0.82
query16 0.42 0.41 0.41
query17 0.98 0.99 1.02
query18 0.23 0.22 0.23
query19 1.82 1.91 1.79
query20 0.01 0.01 0.01
query21 15.46 0.29 0.13
query22 4.78 0.05 0.04
query23 16.08 0.28 0.10
query24 1.35 0.67 0.31
query25 0.08 0.09 0.05
query26 0.15 0.13 0.13
query27 0.06 0.05 0.04
query28 3.71 1.24 1.04
query29 12.56 4.12 3.27
query30 0.27 0.13 0.12
query31 2.81 0.62 0.39
query32 3.24 0.55 0.47
query33 3.11 3.09 3.08
query34 16.83 5.17 4.53
query35 4.57 4.60 4.54
query36 0.65 0.50 0.48
query37 0.11 0.07 0.07
query38 0.07 0.04 0.03
query39 0.05 0.03 0.02
query40 0.17 0.14 0.13
query41 0.09 0.04 0.03
query42 0.04 0.04 0.03
query43 0.05 0.04 0.03
Total cold run time: 97.14 s
Total hot run time: 27.36 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] [WIP only test] sort [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3644609520
<details>
<summary>TPC-DS: <b>Total hot run time: 182284 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 f70ac3d79a1834efb5278129ffd15232c640532a, data reload: false
query5 5001 626 497 497
query6 348 237 221 221
query7 4220 465 274 274
query8 300 248 242 242
query9 8808 2549 2567 2549
query10 533 381 342 342
query11 15709 15036 14861 14861
query12 188 126 122 122
query13 1277 518 385 385
query14 6216 3216 3000 3000
query14_1 2883 2945 2899 2899
query15 216 201 177 177
query16 937 485 457 457
query17 1096 684 589 589
query18 2490 442 354 354
query19 239 230 213 213
query20 123 118 117 117
query21 221 139 121 121
query22 3838 4029 3987 3987
query23 16582 16266 16056 16056
query23_1 16075 16120 16033 16033
query24 7357 1677 1263 1263
query24_1 1262 1246 1257 1246
query25 593 526 457 457
query26 1260 278 169 169
query27 2748 462 317 317
query28 4490 2189 2133 2133
query29 836 599 486 486
query30 319 249 220 220
query31 831 710 586 586
query32 86 78 78 78
query33 553 369 317 317
query34 902 918 570 570
query35 799 824 727 727
query36 884 905 824 824
query37 142 98 85 85
query38 3856 3846 3815 3815
query39 772 748 737 737
query39_1 713 700 702 700
query40 230 153 129 129
query41 74 72 69 69
query42 110 111 112 111
query43 430 443 407 407
query44 1382 759 772 759
query45 197 194 190 190
query46 927 1024 639 639
query47 1681 1698 1603 1603
query48 333 340 265 265
query49 663 445 374 374
query50 700 293 232 232
query51 3818 3821 3794 3794
query52 114 115 103 103
query53 338 367 302 302
query54 314 278 288 278
query55 85 79 76 76
query56 309 324 333 324
query57 1149 1149 1080 1080
query58 289 302 259 259
query59 2401 2473 2329 2329
query60 308 335 289 289
query61 168 165 157 157
query62 693 691 610 610
query63 326 307 303 303
query64 4902 1348 1032 1032
query65 4009 3961 3939 3939
query66 1454 446 320 320
query67 15215 15088 14855 14855
query68 8333 1038 750 750
query69 484 352 313 313
query70 1076 1009 1012 1009
query71 388 334 305 305
query72 6137 4960 4914 4914
query73 683 603 319 319
query74 8543 8876 8628 8628
query75 3644 3564 3158 3158
query76 3945 1176 763 763
query77 617 420 302 302
query78 9514 9775 8860 8860
query79 1660 864 638 638
query80 724 648 552 552
query81 525 269 242 242
query82 199 131 106 106
query83 269 261 246 246
query84 257 121 101 101
query85 904 513 459 459
query86 385 317 306 306
query87 4064 4095 4024 4024
query88 3177 2284 2275 2275
query89 466 413 401 401
query90 2141 157 156 156
query91 169 160 146 146
query92 82 68 62 62
query93 1497 909 583 583
query94 473 323 285 285
query95 572 371 343 343
query96 601 466 219 219
query97 2593 2687 2547 2547
query98 220 192 189 189
query99 1289 1314 1264 1264
Total cold run time: 263902 ms
Total hot run time: 182284 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] [WIP only test] sort [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3639950817
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] [WIP only test] sort [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3640229503
<details>
<summary>TPC-DS: <b>Total hot run time: 179106 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 f70ac3d79a1834efb5278129ffd15232c640532a, data reload: false
query5 4896 626 480 480
query6 336 237 223 223
query7 4224 476 278 278
query8 295 255 240 240
query9 8761 2589 2629 2589
query10 533 354 330 330
query11 15209 14916 14679 14679
query12 187 123 117 117
query13 1273 555 405 405
query14 6121 3290 3084 3084
query14_1 2894 2952 3001 2952
query15 209 202 183 183
query16 897 440 502 440
query17 1147 724 622 622
query18 2600 456 354 354
query19 258 231 217 217
query20 125 114 111 111
query21 221 137 123 123
query22 3932 3854 3839 3839
query23 16733 16233 15802 15802
query23_1 15974 16147 16108 16108
query24 7385 1672 1238 1238
query24_1 1235 1267 1265 1265
query25 593 524 449 449
query26 1250 269 167 167
query27 2762 473 326 326
query28 4446 2188 2167 2167
query29 846 582 470 470
query30 315 251 219 219
query31 833 694 642 642
query32 119 73 66 66
query33 545 334 298 298
query34 906 891 535 535
query35 774 804 723 723
query36 861 905 817 817
query37 129 94 79 79
query38 3909 3881 3761 3761
query39 763 735 710 710
query39_1 708 697 712 697
query40 232 146 123 123
query41 69 64 62 62
query42 110 110 117 110
query43 438 444 396 396
query44 1353 781 762 762
query45 200 195 189 189
query46 874 984 640 640
query47 1633 1673 1609 1609
query48 322 334 260 260
query49 637 445 353 353
query50 681 299 231 231
query51 3836 3789 3826 3789
query52 105 110 102 102
query53 335 355 307 307
query54 342 264 256 256
query55 80 80 77 77
query56 300 314 300 300
query57 1133 1121 1076 1076
query58 277 258 248 248
query59 2323 2367 2301 2301
query60 315 306 293 293
query61 168 158 168 158
query62 726 694 641 641
query63 332 303 307 303
query64 4983 1317 1023 1023
query65 4024 3968 3968 3968
query66 1421 461 321 321
query67 15197 14966 14889 14889
query68 8398 1016 741 741
query69 504 353 314 314
query70 1048 1026 967 967
query71 382 315 295 295
query72 6101 2634 5425 2634
query73 754 735 313 313
query74 8745 8813 8607 8607
query75 3601 3543 3159 3159
query76 4031 1166 760 760
query77 719 403 293 293
query78 9584 9589 8931 8931
query79 1623 882 623 623
query80 738 668 565 565
query81 533 266 243 243
query82 494 134 111 111
query83 265 260 242 242
query84 274 126 97 97
query85 979 515 480 480
query86 392 300 291 291
query87 4145 4101 3985 3985
query88 4316 2298 2272 2272
query89 466 426 402 402
query90 2143 167 159 159
query91 182 170 145 145
query92 86 69 69 69
query93 1667 939 565 565
query94 475 320 288 288
query95 574 384 306 306
query96 582 481 215 215
query97 2654 2642 2555 2555
query98 219 200 193 193
query99 1279 1288 1223 1223
Total cold run time: 265506 ms
Total hot run time: 179106 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] [WIP only test] sort [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange closed pull request #58822: [WIP only test] sort
URL: https://github.com/apache/doris/pull/58822
--
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] [WIP only test] sort [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3640187084
<details>
<summary>TPC-H: <b>Total hot run time: 35487 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 f70ac3d79a1834efb5278129ffd15232c640532a, data reload: false
------ Round 1 ----------------------------------
q1 17626 4284 4122 4122
q2 2040 358 246 246
q3 10162 1319 747 747
q4 10203 832 308 308
q5 7501 2165 1909 1909
q6 182 169 136 136
q7 1063 861 716 716
q8 9342 1439 1118 1118
q9 7198 5342 5330 5330
q10 6830 2422 1967 1967
q11 514 321 291 291
q12 673 731 572 572
q13 17790 3712 3073 3073
q14 285 287 276 276
q15 597 523 511 511
q16 977 927 873 873
q17 711 822 563 563
q18 7929 7059 7101 7059
q19 1092 976 611 611
q20 392 372 250 250
q21 4278 4013 3843 3843
q22 1079 1009 966 966
Total cold run time: 108464 ms
Total hot run time: 35487 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4110 4063 4059 4059
q2 325 414 328 328
q3 2135 2701 2312 2312
q4 1368 1770 1321 1321
q5 4270 4916 4730 4730
q6 233 176 128 128
q7 2078 1993 1854 1854
q8 2653 2543 2547 2543
q9 7800 7593 7616 7593
q10 3113 3285 2819 2819
q11 585 507 489 489
q12 717 734 572 572
q13 3660 3990 3307 3307
q14 302 318 310 310
q15 566 532 509 509
q16 918 920 875 875
q17 1354 1461 1452 1452
q18 7898 7712 7542 7542
q19 921 874 918 874
q20 2059 2084 1982 1982
q21 4850 4472 4161 4161
q22 1135 1066 973 973
Total cold run time: 53050 ms
Total hot run time: 50733 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] [WIP only test] sort [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3644584935
<details>
<summary>TPC-H: <b>Total hot run time: 35669 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 f70ac3d79a1834efb5278129ffd15232c640532a, data reload: false
------ Round 1 ----------------------------------
q1 17629 4195 4046 4046
q2 2010 350 259 259
q3 10169 1293 750 750
q4 10224 893 314 314
q5 8114 2185 1972 1972
q6 238 169 136 136
q7 1003 867 731 731
q8 9370 1529 1205 1205
q9 7351 5406 5363 5363
q10 6871 2414 1957 1957
q11 537 323 304 304
q12 687 735 598 598
q13 17799 3673 3059 3059
q14 286 296 277 277
q15 607 531 512 512
q16 925 913 867 867
q17 715 850 534 534
q18 7690 7152 7004 7004
q19 1096 971 648 648
q20 414 378 251 251
q21 4314 4078 3924 3924
q22 1076 1021 958 958
Total cold run time: 109125 ms
Total hot run time: 35669 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4133 4114 4041 4041
q2 348 424 317 317
q3 2133 2680 2346 2346
q4 1314 1777 1312 1312
q5 4293 5010 4611 4611
q6 222 171 128 128
q7 1985 1979 1893 1893
q8 2707 2559 2551 2551
q9 7567 7577 7561 7561
q10 3135 3240 2854 2854
q11 590 521 573 521
q12 772 736 629 629
q13 3750 3810 3311 3311
q14 295 333 297 297
q15 549 514 525 514
q16 917 974 900 900
q17 1222 1418 1417 1417
q18 8009 7853 7594 7594
q19 957 988 943 943
q20 1957 2055 1979 1979
q21 4711 4378 4162 4162
q22 1106 1046 993 993
Total cold run time: 52672 ms
Total hot run time: 50874 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] [WIP only test] sort [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58822:
URL: https://github.com/apache/doris/pull/58822#issuecomment-3626245284
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