You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HappenLee (via GitHub)" <gi...@apache.org> on 2025/11/24 07:14:00 UTC
[PR] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
HappenLee opened a new pull request, #58289:
URL: https://github.com/apache/doris/pull/58289
### What problem does this PR solve?
The pr #55534 change scanner logic use by index scan cause perfermance problem. need revert the error change
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)
- [x] No need to test or manual test. Explain why:
- [x] 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:
- [x] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [x] 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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3569236123
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3569252067
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3569235376
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3573972463
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3570181938
<details>
<summary>TPC-DS: <b>Total hot run time: 187949 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 60ebd337713605456a16bff3b2925494a5f57f94, data reload: false
query1 1040 431 419 419
query2 6574 1698 1677 1677
query3 6751 230 223 223
query4 25939 23195 23306 23195
query5 4938 615 482 482
query6 333 234 227 227
query7 4638 507 301 301
query8 309 240 241 240
query9 8712 2634 2610 2610
query10 526 338 279 279
query11 15540 15094 14874 14874
query12 174 119 111 111
query13 1670 553 456 456
query14 11054 9171 9121 9121
query15 207 195 164 164
query16 7685 707 519 519
query17 1177 733 606 606
query18 2035 426 317 317
query19 206 198 172 172
query20 127 126 123 123
query21 230 135 116 116
query22 4001 4088 4035 4035
query23 33922 33341 33217 33217
query24 8396 2419 2382 2382
query25 582 511 456 456
query26 1245 277 162 162
query27 2733 495 358 358
query28 4417 2207 2186 2186
query29 780 607 489 489
query30 297 225 198 198
query31 913 775 732 732
query32 90 77 70 70
query33 594 371 327 327
query34 797 845 524 524
query35 819 828 740 740
query36 978 1034 883 883
query37 123 110 89 89
query38 3532 3454 3437 3437
query39 1483 1404 1406 1404
query40 225 130 120 120
query41 64 63 64 63
query42 124 119 116 116
query43 494 496 471 471
query44 1233 763 770 763
query45 183 178 174 174
query46 886 1009 635 635
query47 1751 1771 1697 1697
query48 382 419 333 333
query49 768 496 399 399
query50 671 686 417 417
query51 3839 3871 3852 3852
query52 113 116 108 108
query53 249 276 205 205
query54 327 310 292 292
query55 93 88 89 88
query56 337 339 339 339
query57 1145 1209 1111 1111
query58 298 285 278 278
query59 2536 2682 2513 2513
query60 379 354 351 351
query61 205 193 194 193
query62 810 705 667 667
query63 236 199 201 199
query64 4587 1295 986 986
query65 4034 3959 3942 3942
query66 1118 464 350 350
query67 15365 15075 14916 14916
query68 8132 968 640 640
query69 500 327 293 293
query70 1398 1328 1256 1256
query71 441 340 319 319
query72 5991 4895 4846 4846
query73 652 580 371 371
query74 8839 9070 8998 8998
query75 3741 3310 2768 2768
query76 3554 1157 729 729
query77 811 403 310 310
query78 9516 9492 8875 8875
query79 2802 833 615 615
query80 711 588 506 506
query81 503 260 228 228
query82 500 161 135 135
query83 296 265 249 249
query84 309 114 93 93
query85 917 485 441 441
query86 387 336 298 298
query87 3706 3728 3543 3543
query88 3789 2298 2290 2290
query89 376 318 294 294
query90 1907 235 219 219
query91 165 171 135 135
query92 82 66 65 65
query93 2089 987 679 679
query94 729 427 338 338
query95 409 321 310 310
query96 488 571 283 283
query97 2923 2914 2857 2857
query98 231 213 208 208
query99 1400 1384 1259 1259
Total cold run time: 276313 ms
Total hot run time: 187949 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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3569381374
<details>
<summary>TPC-DS: <b>Total hot run time: 187444 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 b8da8fd88ae3660db7f8fc3a4e1e87f89851a298, data reload: false
query1 1033 409 422 409
query2 6544 1677 1693 1677
query3 6755 225 233 225
query4 25896 22953 22736 22736
query5 4399 668 476 476
query6 327 237 225 225
query7 4660 507 305 305
query8 306 257 244 244
query9 8702 2559 2535 2535
query10 493 354 315 315
query11 15653 14963 14778 14778
query12 174 115 113 113
query13 1673 593 451 451
query14 10935 9168 9213 9168
query15 232 187 169 169
query16 7604 657 503 503
query17 1224 741 619 619
query18 2054 434 322 322
query19 219 197 189 189
query20 141 140 127 127
query21 220 136 116 116
query22 4135 4080 4051 4051
query23 33935 32983 32902 32902
query24 8432 2407 2405 2405
query25 597 522 447 447
query26 1243 282 165 165
query27 2747 507 359 359
query28 4379 2246 2187 2187
query29 789 607 511 511
query30 307 225 199 199
query31 911 790 703 703
query32 82 74 69 69
query33 609 379 337 337
query34 827 872 524 524
query35 806 834 735 735
query36 968 1011 920 920
query37 125 116 90 90
query38 3505 3444 3476 3444
query39 1489 1424 1424 1424
query40 232 136 119 119
query41 67 63 63 63
query42 138 114 112 112
query43 492 492 466 466
query44 1291 807 790 790
query45 190 176 176 176
query46 885 985 655 655
query47 1760 1766 1711 1711
query48 407 456 337 337
query49 776 524 426 426
query50 671 693 419 419
query51 3889 4047 3987 3987
query52 113 121 121 121
query53 262 277 209 209
query54 326 310 311 310
query55 92 90 93 90
query56 352 326 337 326
query57 1168 1182 1129 1129
query58 303 285 282 282
query59 2637 2739 2555 2555
query60 380 366 355 355
query61 200 195 193 193
query62 763 718 648 648
query63 243 203 206 203
query64 4646 1296 1011 1011
query65 4039 3916 3917 3916
query66 1140 455 349 349
query67 15365 15160 14847 14847
query68 8220 919 653 653
query69 526 338 302 302
query70 1352 1214 1246 1214
query71 442 347 306 306
query72 6104 4885 4831 4831
query73 663 611 374 374
query74 8905 8797 8822 8797
query75 3304 3337 2807 2807
query76 3339 1134 735 735
query77 529 415 320 320
query78 9478 9575 8827 8827
query79 2586 820 624 624
query80 773 593 521 521
query81 517 256 229 229
query82 461 151 142 142
query83 307 262 244 244
query84 312 115 89 89
query85 911 491 450 450
query86 386 310 308 308
query87 3727 3704 3654 3654
query88 3671 2349 2374 2349
query89 388 323 290 290
query90 1935 218 230 218
query91 171 172 137 137
query92 84 70 67 67
query93 2161 989 687 687
query94 761 457 343 343
query95 405 326 316 316
query96 491 575 287 287
query97 2919 2976 2901 2901
query98 240 221 211 211
query99 1425 1414 1232 1232
Total cold run time: 275450 ms
Total hot run time: 187444 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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "airborne12 (via GitHub)" <gi...@apache.org>.
airborne12 merged PR #58289:
URL: https://github.com/apache/doris/pull/58289
--
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3570420812
# BE UT Coverage Report
Increment line coverage `0.00% (0/16)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60ebd337713605456a16bff3b2925494a5f57f94_60ebd337713605456a16bff3b2925494a5f57f94/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60ebd337713605456a16bff3b2925494a5f57f94_60ebd337713605456a16bff3b2925494a5f57f94/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.63% (18280/34732) |
| Line Coverage | 38.07% (166310/436898) |
| Region Coverage | 33.03% (129333/391516) |
| Branch Coverage | 33.82% (55488/164060) |
--
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3569397283
<details>
<summary>ClickBench: <b>Total hot run time: 27.43 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 b8da8fd88ae3660db7f8fc3a4e1e87f89851a298, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.06 0.05
query3 0.25 0.08 0.08
query4 1.60 0.12 0.11
query5 0.27 0.25 0.26
query6 1.17 0.64 0.62
query7 0.03 0.03 0.02
query8 0.06 0.04 0.04
query9 0.60 0.52 0.51
query10 0.57 0.57 0.58
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.62 0.61 0.61
query14 1.00 0.99 0.99
query15 0.85 0.82 0.83
query16 0.37 0.40 0.39
query17 1.01 0.99 1.04
query18 0.21 0.20 0.19
query19 1.84 1.85 1.88
query20 0.02 0.01 0.01
query21 15.44 0.18 0.12
query22 5.12 0.07 0.05
query23 15.66 0.27 0.10
query24 2.62 0.57 0.41
query25 0.07 0.06 0.06
query26 0.14 0.14 0.13
query27 0.08 0.05 0.05
query28 4.36 1.13 0.91
query29 12.58 3.89 3.22
query30 0.27 0.14 0.13
query31 2.81 0.58 0.38
query32 3.22 0.54 0.46
query33 3.07 3.12 3.12
query34 15.97 5.19 4.51
query35 4.54 4.54 4.58
query36 0.67 0.50 0.50
query37 0.10 0.06 0.07
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.15 0.15
query41 0.09 0.03 0.02
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 98.1 s
Total hot run time: 27.43 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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3570205800
<details>
<summary>ClickBench: <b>Total hot run time: 27.7 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 60ebd337713605456a16bff3b2925494a5f57f94, data reload: false
query1 0.05 0.04 0.05
query2 0.10 0.05 0.04
query3 0.26 0.08 0.08
query4 1.60 0.12 0.11
query5 0.26 0.26 0.25
query6 1.16 0.66 0.63
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.58 0.52 0.51
query10 0.57 0.57 0.57
query11 0.17 0.11 0.11
query12 0.15 0.11 0.12
query13 0.63 0.61 0.61
query14 0.99 1.00 0.99
query15 0.86 0.84 0.85
query16 0.41 0.40 0.39
query17 1.01 0.98 1.01
query18 0.21 0.21 0.20
query19 1.95 1.79 1.80
query20 0.02 0.01 0.01
query21 15.44 0.21 0.14
query22 4.99 0.07 0.05
query23 15.66 0.26 0.10
query24 2.54 0.59 1.06
query25 0.07 0.07 0.05
query26 0.14 0.12 0.14
query27 0.06 0.06 0.05
query28 4.85 1.15 0.93
query29 12.58 3.87 3.28
query30 0.29 0.14 0.12
query31 2.82 0.59 0.39
query32 3.24 0.56 0.48
query33 3.06 3.14 3.05
query34 15.95 5.14 4.61
query35 4.56 4.54 4.60
query36 0.67 0.51 0.50
query37 0.10 0.07 0.07
query38 0.07 0.04 0.05
query39 0.04 0.03 0.03
query40 0.17 0.16 0.15
query41 0.08 0.04 0.04
query42 0.04 0.03 0.02
query43 0.05 0.04 0.03
Total cold run time: 98.53 s
Total hot run time: 27.7 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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3570029736
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3570699167
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (16/16)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58289_60ebd337713605456a16bff3b2925494a5f57f94_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58289_60ebd337713605456a16bff3b2925494a5f57f94_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.28% (24301/34091) |
| Line Coverage | 57.72% (252259/437071) |
| Region Coverage | 52.82% (209617/396833) |
| Branch Coverage | 54.30% (89627/165071) |
--
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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3569339147
<details>
<summary>TPC-H: <b>Total hot run time: 35109 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 b8da8fd88ae3660db7f8fc3a4e1e87f89851a298, data reload: false
------ Round 1 ----------------------------------
q1 17586 5008 4883 4883
q2 2015 319 212 212
q3 10234 1293 707 707
q4 10239 909 377 377
q5 7471 2352 2403 2352
q6 184 169 137 137
q7 906 787 630 630
q8 9354 1329 1165 1165
q9 7099 5374 5369 5369
q10 6827 2220 1812 1812
q11 503 305 287 287
q12 344 365 224 224
q13 17800 3693 3038 3038
q14 228 234 215 215
q15 559 512 501 501
q16 1014 1002 942 942
q17 568 863 364 364
q18 7472 7546 8023 7546
q19 1271 984 568 568
q20 358 349 245 245
q21 4579 3549 2539 2539
q22 1086 1070 996 996
Total cold run time: 107697 ms
Total hot run time: 35109 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5187 5141 5168 5141
q2 319 423 330 330
q3 2349 2961 2520 2520
q4 1479 1913 1459 1459
q5 4514 4425 4435 4425
q6 202 173 132 132
q7 2032 1974 1782 1782
q8 2605 2605 2569 2569
q9 7707 7472 7640 7472
q10 3010 3250 2825 2825
q11 611 539 521 521
q12 692 783 648 648
q13 3422 3647 3082 3082
q14 266 276 265 265
q15 522 486 500 486
q16 1001 1034 991 991
q17 1074 1497 1314 1314
q18 7370 7149 7022 7022
q19 784 751 831 751
q20 1935 1999 1807 1807
q21 4657 4298 4300 4298
q22 1092 1064 993 993
Total cold run time: 52830 ms
Total hot run time: 50833 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] [Revert](exec) revert error change in pr55534 to keep the origin logic for index scan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58289:
URL: https://github.com/apache/doris/pull/58289#issuecomment-3570123258
<details>
<summary>TPC-H: <b>Total hot run time: 34173 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 60ebd337713605456a16bff3b2925494a5f57f94, data reload: false
------ Round 1 ----------------------------------
q1 17641 5107 4886 4886
q2 2055 311 204 204
q3 10222 1282 728 728
q4 10218 914 363 363
q5 7456 2354 2296 2296
q6 181 171 135 135
q7 923 754 623 623
q8 9344 1263 1046 1046
q9 7127 5370 5345 5345
q10 6815 2230 1796 1796
q11 494 296 281 281
q12 336 366 225 225
q13 17793 3616 3038 3038
q14 234 231 208 208
q15 570 507 490 490
q16 1013 985 945 945
q17 574 858 360 360
q18 7898 7237 7203 7203
q19 1241 931 543 543
q20 337 335 234 234
q21 3657 3174 2266 2266
q22 1022 1007 958 958
Total cold run time: 107151 ms
Total hot run time: 34173 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4902 4895 4883 4883
q2 317 410 329 329
q3 2198 2655 2279 2279
q4 1339 1794 1308 1308
q5 4161 4427 4571 4427
q6 232 181 140 140
q7 1975 1953 1914 1914
q8 2636 2624 2570 2570
q9 7508 7647 7450 7450
q10 3037 3254 2864 2864
q11 600 562 512 512
q12 676 731 657 657
q13 3600 3911 3408 3408
q14 291 290 281 281
q15 548 508 513 508
q16 1092 1121 1073 1073
q17 1166 1526 1385 1385
q18 7987 7792 7450 7450
q19 752 868 990 868
q20 2014 2064 1952 1952
q21 4913 4359 4327 4327
q22 1102 1052 992 992
Total cold run time: 53046 ms
Total hot run time: 51577 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