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 2025/12/05 08:44:24 UTC
[PR] [fix](project push down) union and its children's output are mis order [doris]
morrySnow opened a new pull request, #58765:
URL: https://github.com/apache/doris/pull/58765
### What problem does this PR solve?
Related PR: #57204
Problem Summary:
This pull request refactors and improves the `PushDownProject` rule in the Nereids optimizer, mainly focusing on the logic for pushing down projections through `UNION` operations. It also introduces a comprehensive unit test to verify the new logic, making the relevant methods more testable and robust.
**Refactoring and Logic Improvements:**
* Refactored the `pushThroughUnion` logic by extracting it into a new static method, making it easier to test and use independently. The main logic now takes explicit arguments instead of relying on the context object.
* Improved the handling of projections and child outputs when pushing down through `UNION`, ensuring correct mapping and replacement of slots. This includes using regulator outputs for children and constant expressions, and making the slot replacement logic static for better testability. [[1]](diffhunk://#diff-a53fc492953ee6c3684a7a738c19c8c8ad1d5b8acbec5c53ff71e0da90b5fbe8L201-R246) [[2]](diffhunk://#diff-a53fc492953ee6c3684a7a738c19c8c8ad1d5b8acbec5c53ff71e0da90b5fbe8L247-R255) [[3]](diffhunk://#diff-a53fc492953ee6c3684a7a738c19c8c8ad1d5b8acbec5c53ff71e0da90b5fbe8L259-R267) [[4]](diffhunk://#diff-a53fc492953ee6c3684a7a738c19c8c8ad1d5b8acbec5c53ff71e0da90b5fbe8L292-R301)
**Testing Enhancements:**
* Added a new unit test class `PushDownProjectTest` to rigorously test the pushdown logic in various scenarios, including unions with and without children. The tests verify both the structure and the correctness of the rewritten plans.
**Code Quality Improvements:**
* Added the `@VisibleForTesting` annotation and imported necessary dependencies to clarify method visibility and intent for testing.
* Replaced some usages of `Collection` with `List` for better type safety and clarity in projection handling.
These changes make the projection pushdown logic more modular, testable, and robust, and provide strong test coverage for future maintenance.
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [x] 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:
- [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] [fix](project push down) union and its children's output are mis order [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616182083
<details>
<summary>ClickBench: <b>Total hot run time: 27.34 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 7ab0330bae284857ae182595fc0651aa513b6cd5, data reload: false
query1 0.06 0.05 0.04
query2 0.10 0.05 0.05
query3 0.26 0.09 0.09
query4 1.60 0.11 0.11
query5 0.25 0.25 0.25
query6 1.17 0.64 0.63
query7 0.04 0.03 0.03
query8 0.05 0.04 0.04
query9 0.57 0.50 0.51
query10 0.57 0.56 0.54
query11 0.16 0.11 0.12
query12 0.14 0.12 0.12
query13 0.61 0.60 0.61
query14 0.98 0.99 0.98
query15 0.82 0.80 0.83
query16 0.40 0.39 0.41
query17 1.05 1.05 1.05
query18 0.23 0.21 0.21
query19 1.96 1.78 1.72
query20 0.02 0.01 0.01
query21 15.43 0.29 0.14
query22 4.82 0.06 0.05
query23 16.04 0.28 0.10
query24 1.22 0.26 0.76
query25 0.09 0.06 0.04
query26 0.13 0.12 0.12
query27 0.04 0.06 0.05
query28 4.92 1.21 1.02
query29 12.61 4.10 3.34
query30 0.30 0.13 0.14
query31 2.80 0.62 0.41
query32 3.24 0.55 0.46
query33 3.03 3.05 3.07
query34 16.90 5.17 4.54
query35 4.62 4.56 4.54
query36 0.68 0.50 0.49
query37 0.10 0.06 0.06
query38 0.07 0.04 0.03
query39 0.04 0.03 0.03
query40 0.17 0.13 0.13
query41 0.08 0.03 0.03
query42 0.04 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 98.45 s
Total hot run time: 27.34 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](project push down) union and its children's output are mis order [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616376955
<details>
<summary>TPC-DS: <b>Total hot run time: 179917 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 7ab0330bae284857ae182595fc0651aa513b6cd5, data reload: false
query5 5108 663 487 487
query6 346 247 212 212
query7 4661 485 280 280
query8 316 246 242 242
query9 8744 2645 2668 2645
query10 580 307 268 268
query11 15781 14830 14716 14716
query12 175 119 120 119
query13 1682 494 381 381
query14 6243 3267 3035 3035
query14_1 2906 2919 2867 2867
query15 208 200 182 182
query16 7706 491 463 463
query17 1236 725 613 613
query18 2055 440 348 348
query19 217 192 168 168
query20 136 133 123 123
query21 219 145 115 115
query22 3906 4230 3867 3867
query23 16827 16325 16108 16108
query23_1 16129 16036 16151 16036
query24 7242 1631 1195 1195
query24_1 1216 1193 1250 1193
query25 641 497 463 463
query26 1270 288 177 177
query27 2883 485 316 316
query28 4372 2197 2186 2186
query29 842 590 497 497
query30 321 249 220 220
query31 812 710 615 615
query32 91 73 74 73
query33 690 362 352 352
query34 874 884 535 535
query35 797 810 749 749
query36 889 924 821 821
query37 136 99 75 75
query38 3866 3884 3729 3729
query39 767 738 702 702
query39_1 719 702 694 694
query40 226 128 118 118
query41 69 60 64 60
query42 127 101 97 97
query43 435 427 395 395
query44 1310 760 765 760
query45 194 192 185 185
query46 914 963 601 601
query47 1691 1739 1632 1632
query48 400 317 242 242
query49 774 439 357 357
query50 677 306 225 225
query51 3875 3888 3808 3808
query52 114 95 87 87
query53 236 231 178 178
query54 322 254 236 236
query55 97 84 76 76
query56 343 307 286 286
query57 1166 1163 1091 1091
query58 285 281 257 257
query59 2292 2382 2440 2382
query60 377 322 301 301
query61 158 161 160 160
query62 765 703 629 629
query63 230 178 178 178
query64 4550 1187 898 898
query65 4048 3960 3956 3956
query66 1186 435 338 338
query67 15462 15047 14874 14874
query68 8461 929 668 668
query69 518 298 266 266
query70 1109 1016 982 982
query71 471 296 275 275
query72 6004 4929 4997 4929
query73 675 566 301 301
query74 8681 8815 8593 8593
query75 3535 3053 2526 2526
query76 3656 1127 732 732
query77 813 416 298 298
query78 9518 9514 8840 8840
query79 1896 867 583 583
query80 742 565 475 475
query81 497 270 238 238
query82 439 127 103 103
query83 311 266 246 246
query84 301 111 96 96
query85 908 499 448 448
query86 339 313 282 282
query87 4002 4085 3914 3914
query88 3945 2108 2117 2108
query89 386 333 276 276
query90 2101 162 161 161
query91 169 166 139 139
query92 88 69 62 62
query93 1566 1046 680 680
query94 771 303 294 294
query95 573 376 320 320
query96 540 498 214 214
query97 2616 2663 2559 2559
query98 243 200 203 200
query99 1393 1320 1255 1255
Total cold run time: 273135 ms
Total hot run time: 179917 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](project push down) union and its children's output are mis order [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3624174324
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](project push down) union and its children's output are mis order [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616096560
<details>
<summary>TPC-H: <b>Total hot run time: 34445 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 7ab0330bae284857ae182595fc0651aa513b6cd5, data reload: false
------ Round 1 ----------------------------------
q1 17617 4958 4898 4898
q2 2040 314 214 214
q3 10254 1309 732 732
q4 10220 833 317 317
q5 7473 2442 2173 2173
q6 186 177 136 136
q7 957 782 638 638
q8 9361 1479 1162 1162
q9 7071 5363 5359 5359
q10 6848 2188 1808 1808
q11 534 322 297 297
q12 379 378 220 220
q13 17768 3743 3074 3074
q14 239 241 216 216
q15 583 508 514 508
q16 909 874 825 825
q17 681 790 526 526
q18 7829 7164 7060 7060
q19 1092 979 614 614
q20 385 346 229 229
q21 3994 3253 2498 2498
q22 1023 991 941 941
Total cold run time: 107443 ms
Total hot run time: 34445 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4999 4973 4907 4907
q2 330 404 322 322
q3 2133 2727 2287 2287
q4 1341 1771 1285 1285
q5 4279 4501 4611 4501
q6 233 187 137 137
q7 2108 1975 1834 1834
q8 2733 2676 2686 2676
q9 7537 7524 7812 7524
q10 3088 3226 2887 2887
q11 604 519 497 497
q12 699 800 582 582
q13 3534 3981 3415 3415
q14 305 301 272 272
q15 540 510 517 510
q16 901 957 891 891
q17 1216 1361 1420 1361
q18 7930 7875 7562 7562
q19 928 882 909 882
q20 2058 2109 1930 1930
q21 5084 4453 4159 4159
q22 1081 1040 986 986
Total cold run time: 53661 ms
Total hot run time: 51407 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](project push down) union and its children's output are mis order [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616233083
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](project push down) union and its children's output are mis order [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3615848390
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](project push down) union and its children's output are mis order [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3617040469
# FE Regression Coverage Report
Increment line coverage ` 92.00% (46/50)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58765_7ab0330bae284857ae182595fc0651aa513b6cd5_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58765_7ab0330bae284857ae182595fc0651aa513b6cd5_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
Re: [PR] [fix](project push down) union and its children's output are mis order [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #58765:
URL: https://github.com/apache/doris/pull/58765
--
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](project push down) union and its children's output are mis order [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3615848571
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](project push down) union and its children's output are mis order [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616317672
<details>
<summary>TPC-H: <b>Total hot run time: 34604 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 7ab0330bae284857ae182595fc0651aa513b6cd5, data reload: false
------ Round 1 ----------------------------------
q1 17611 5104 4943 4943
q2 2069 314 197 197
q3 10237 1318 768 768
q4 10221 877 320 320
q5 7523 2396 2193 2193
q6 183 173 138 138
q7 1001 771 645 645
q8 9352 1426 1155 1155
q9 7047 5341 5396 5341
q10 6793 2202 1826 1826
q11 525 312 316 312
q12 337 364 231 231
q13 17779 3671 3017 3017
q14 233 244 213 213
q15 569 520 523 520
q16 915 883 818 818
q17 678 782 538 538
q18 7542 7160 7066 7066
q19 1093 970 623 623
q20 381 355 230 230
q21 4053 3421 2547 2547
q22 1057 1023 963 963
Total cold run time: 107199 ms
Total hot run time: 34604 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5033 4986 5001 4986
q2 330 404 333 333
q3 2183 2727 2279 2279
q4 1334 1740 1334 1334
q5 4208 4513 4638 4513
q6 225 175 129 129
q7 2084 2020 1861 1861
q8 2741 2561 2631 2561
q9 7612 7589 7547 7547
q10 3170 3275 2880 2880
q11 605 510 496 496
q12 679 769 610 610
q13 3510 3855 3308 3308
q14 291 292 295 292
q15 553 532 511 511
q16 940 955 888 888
q17 1175 1530 1511 1511
q18 7902 7653 7641 7641
q19 931 905 869 869
q20 2004 2133 1946 1946
q21 5122 4408 4128 4128
q22 1109 999 982 982
Total cold run time: 53741 ms
Total hot run time: 51605 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](project push down) union and its children's output are mis order [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3615848003
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](project push down) union and its children's output are mis order [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616162482
<details>
<summary>TPC-DS: <b>Total hot run time: 180274 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 7ab0330bae284857ae182595fc0651aa513b6cd5, data reload: false
query5 4412 658 491 491
query6 370 242 229 229
query7 4658 476 289 289
query8 316 257 250 250
query9 8730 2676 2649 2649
query10 515 334 272 272
query11 15290 14730 14535 14535
query12 190 121 118 118
query13 1709 475 363 363
query14 5483 3321 3018 3018
query14_1 2910 2847 2897 2847
query15 208 197 177 177
query16 7165 479 442 442
query17 1178 684 587 587
query18 1991 424 339 339
query19 207 182 156 156
query20 127 123 113 113
query21 220 137 118 118
query22 3880 3981 3889 3889
query23 16623 16088 16063 16063
query23_1 16183 16033 16078 16033
query24 7231 1601 1192 1192
query24_1 1214 1190 1212 1190
query25 639 508 455 455
query26 1268 301 182 182
query27 2897 473 309 309
query28 4417 2193 2179 2179
query29 879 585 468 468
query30 311 236 221 221
query31 814 721 628 628
query32 89 80 71 71
query33 689 364 320 320
query34 858 881 518 518
query35 803 863 747 747
query36 881 917 832 832
query37 122 88 76 76
query38 3847 3940 3804 3804
query39 758 734 715 715
query39_1 694 889 697 697
query40 233 145 122 122
query41 73 69 70 69
query42 136 101 103 101
query43 442 420 404 404
query44 1308 773 761 761
query45 197 195 184 184
query46 918 964 594 594
query47 1724 1734 1672 1672
query48 412 323 242 242
query49 823 446 383 383
query50 685 302 240 240
query51 3855 3831 3781 3781
query52 118 99 88 88
query53 239 238 181 181
query54 332 270 254 254
query55 96 81 79 79
query56 351 317 323 317
query57 1172 1142 1144 1142
query58 282 250 254 250
query59 2261 2353 2278 2278
query60 341 313 296 296
query61 160 157 151 151
query62 781 713 668 668
query63 233 175 179 175
query64 4580 1174 872 872
query65 4052 3942 3948 3942
query66 1259 435 332 332
query67 15513 15588 15201 15201
query68 8301 976 702 702
query69 533 311 267 267
query70 1148 1050 1004 1004
query71 464 309 283 283
query72 6235 4977 5123 4977
query73 724 611 304 304
query74 8598 8804 8794 8794
query75 3282 3051 2480 2480
query76 3408 1132 763 763
query77 771 396 291 291
query78 9562 9660 8808 8808
query79 1640 853 583 583
query80 703 552 462 462
query81 524 278 236 236
query82 205 127 101 101
query83 286 273 258 258
query84 276 112 96 96
query85 906 492 436 436
query86 379 282 304 282
query87 4095 4102 3978 3978
query88 3828 2146 2109 2109
query89 382 321 286 286
query90 2115 162 156 156
query91 170 165 142 142
query92 88 69 66 66
query93 2015 1069 684 684
query94 751 294 292 292
query95 575 387 335 335
query96 543 501 214 214
query97 2608 2701 2550 2550
query98 246 207 208 207
query99 1349 1305 1233 1233
Total cold run time: 270484 ms
Total hot run time: 180274 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](project push down) union and its children's output are mis order [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3624174263
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](project push down) union and its children's output are mis order [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58765:
URL: https://github.com/apache/doris/pull/58765#issuecomment-3616395756
<details>
<summary>ClickBench: <b>Total hot run time: 27.34 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 7ab0330bae284857ae182595fc0651aa513b6cd5, data reload: false
query1 0.06 0.05 0.05
query2 0.09 0.05 0.05
query3 0.25 0.09 0.08
query4 1.61 0.11 0.11
query5 0.26 0.26 0.27
query6 1.17 0.65 0.62
query7 0.03 0.02 0.03
query8 0.06 0.04 0.04
query9 0.59 0.51 0.51
query10 0.57 0.55 0.56
query11 0.15 0.11 0.12
query12 0.15 0.11 0.12
query13 0.62 0.60 0.60
query14 0.99 0.98 1.00
query15 0.82 0.79 0.80
query16 0.40 0.41 0.42
query17 1.00 0.99 1.01
query18 0.23 0.21 0.21
query19 1.94 1.80 1.89
query20 0.02 0.01 0.01
query21 15.44 0.31 0.15
query22 4.85 0.05 0.04
query23 16.12 0.28 0.10
query24 1.22 0.31 0.27
query25 0.07 0.08 0.07
query26 0.14 0.12 0.14
query27 0.08 0.04 0.06
query28 3.37 1.26 1.01
query29 12.60 4.01 3.24
query30 0.27 0.14 0.12
query31 2.81 0.64 0.39
query32 3.26 0.55 0.46
query33 3.11 3.14 3.06
query34 16.67 5.15 4.56
query35 4.54 4.58 4.54
query36 0.67 0.51 0.50
query37 0.11 0.07 0.07
query38 0.08 0.05 0.04
query39 0.04 0.03 0.03
query40 0.18 0.14 0.14
query41 0.08 0.03 0.04
query42 0.05 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.81 s
Total hot run time: 27.34 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