You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "XLPE (via GitHub)" <gi...@apache.org> on 2025/05/22 03:43:24 UTC
[PR] [bugfix](nerids) concat function supports function folding [doris]
XLPE opened a new pull request, #51141:
URL: https://github.com/apache/doris/pull/51141
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
In Doris versions above 2.1.8 and above 3.0.3, , the newly added concat function can't fold when more than two parameters.
before:
```
mysql> EXPLAIN SELECT concat('a', 'a', 'b', 'c', 'd', 'efddd');
+---------------------------------------------------+
| Explain String(Nereids Planner) |
+---------------------------------------------------+
| PLAN FRAGMENT 0 |
| OUTPUT EXPRS: |
| concat('a', 'a', 'b', 'c', 'd', 'efddd')[#0] |
| PARTITION: UNPARTITIONED |
| |
| HAS_COLO_PLAN_NODE: false |
| |
| VRESULT SINK |
| MYSQL_PROTOCAL |
| |
| 0:VUNION(30) |
| constant exprs: |
| concat('a', 'a', 'b', 'c', 'd', 'efddd') |
+---------------------------------------------------+
```
after:
```
mysql> EXPLAIN SELECT concat('a', 'a', 'b', 'c', 'd', 'efddd');
+----------------------------------+
| Explain String(Nereids Planner) |
+----------------------------------+
| PLAN FRAGMENT 0 |
| OUTPUT EXPRS: |
| 'aabcdefddd'[#0] |
| PARTITION: UNPARTITIONED |
| |
| HAS_COLO_PLAN_NODE: false |
| |
| VRESULT SINK |
| MYSQL_PROTOCAL |
| |
| 0:VUNION(30) |
| constant exprs: |
| 'aabcdefddd' |
+----------------------------------+
```
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [x] 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.
- [x] 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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2908294114
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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "XLPE (via GitHub)" <gi...@apache.org>.
XLPE commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2903837796
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] [bugfix](nerids) concat function supports function folding [doris]
Posted by "XLPE (via GitHub)" <gi...@apache.org>.
XLPE commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2899812241
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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "XLPE (via GitHub)" <gi...@apache.org>.
XLPE commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2903386163
> Please add a regression test case: https://doris.apache.org/community/developer-guide/regression-testing
@Jibing-Li
The [fold_constant_string_arithmetic ](https://github.com/apache/doris/blob/master/regression-test/suites/nereids_p0/expression/fold_constant/fold_constant_string_arithmatic.groovy#L103)already includes the required tests. Although the previous code was not fully implemented in the FE, it could still pass the regression tests. This time, we have completed its implementation.
--
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] [bugfix](nerids) concat function supports function folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2899887713
<details>
<summary>ClickBench: <b>Total hot run time: 29.26 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 6b657da257aad71565e7b3ad1d48818608a573eb, data reload: false
query1 0.04 0.04 0.03
query2 0.14 0.10 0.11
query3 0.25 0.19 0.18
query4 1.59 0.20 0.19
query5 0.46 0.44 0.45
query6 1.14 0.66 0.66
query7 0.02 0.01 0.02
query8 0.04 0.03 0.03
query9 0.58 0.54 0.52
query10 0.58 0.58 0.58
query11 0.15 0.11 0.11
query12 0.14 0.11 0.12
query13 0.61 0.60 0.60
query14 0.80 0.81 0.80
query15 0.87 0.86 0.85
query16 0.39 0.38 0.37
query17 1.06 1.02 1.01
query18 0.23 0.21 0.20
query19 1.91 1.80 1.79
query20 0.01 0.01 0.02
query21 15.41 0.92 0.58
query22 0.76 1.22 0.71
query23 14.82 1.37 0.61
query24 7.44 0.93 0.85
query25 0.51 0.11 0.13
query26 0.66 0.17 0.13
query27 0.05 0.05 0.05
query28 9.13 0.87 0.45
query29 12.56 3.96 3.33
query30 0.25 0.09 0.06
query31 2.83 0.59 0.38
query32 3.23 0.55 0.46
query33 3.03 3.07 3.15
query34 15.84 5.11 4.57
query35 4.55 4.52 4.55
query36 0.66 0.50 0.48
query37 0.09 0.06 0.07
query38 0.06 0.04 0.04
query39 0.03 0.02 0.02
query40 0.18 0.14 0.13
query41 0.07 0.02 0.02
query42 0.03 0.02 0.03
query43 0.04 0.03 0.02
Total cold run time: 103.24 s
Total hot run time: 29.26 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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2903940924
<details>
<summary>TPC-H: <b>Total hot run time: 33831 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 a8d05a63b7ed83126b0a5434a6967271c0c658cc, data reload: false
------ Round 1 ----------------------------------
q1 26079 5122 4993 4993
q2 2078 265 175 175
q3 10404 1213 715 715
q4 10224 1021 543 543
q5 7544 2323 2336 2323
q6 180 166 135 135
q7 914 737 601 601
q8 9316 1276 1066 1066
q9 6874 5130 5119 5119
q10 6805 2290 1895 1895
q11 488 291 275 275
q12 339 346 210 210
q13 17774 3631 3049 3049
q14 226 235 211 211
q15 535 496 486 486
q16 418 437 370 370
q17 591 832 370 370
q18 7564 7186 7147 7147
q19 1218 930 550 550
q20 345 331 231 231
q21 3785 3186 2340 2340
q22 1065 1071 1027 1027
Total cold run time: 114766 ms
Total hot run time: 33831 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5026 5076 5010 5010
q2 244 330 243 243
q3 2232 2688 2361 2361
q4 1388 1801 1387 1387
q5 4432 4475 4458 4458
q6 231 171 129 129
q7 2066 1939 1776 1776
q8 2606 2554 2511 2511
q9 7333 7326 7033 7033
q10 3007 3202 2768 2768
q11 575 511 507 507
q12 703 738 596 596
q13 3457 3854 3331 3331
q14 288 289 294 289
q15 525 487 470 470
q16 452 467 435 435
q17 1115 1517 1420 1420
q18 7774 7615 7428 7428
q19 804 807 928 807
q20 1986 2086 1882 1882
q21 4740 4423 4374 4374
q22 1093 1077 1006 1006
Total cold run time: 52077 ms
Total hot run time: 50221 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] [bugfix](nerids) concat function supports function folding [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2899810197
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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2903973476
<details>
<summary>TPC-DS: <b>Total hot run time: 192514 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 a8d05a63b7ed83126b0a5434a6967271c0c658cc, data reload: false
query1 1396 1085 1055 1055
query2 6405 1839 1805 1805
query3 11015 4607 4475 4475
query4 54565 24136 22968 22968
query5 5152 531 468 468
query6 353 211 203 203
query7 4915 510 308 308
query8 314 274 237 237
query9 5363 2629 2633 2629
query10 445 335 268 268
query11 15110 15025 14797 14797
query12 157 106 107 106
query13 1015 515 406 406
query14 10232 6437 6348 6348
query15 206 209 179 179
query16 7085 665 477 477
query17 1084 732 623 623
query18 1599 422 324 324
query19 204 198 178 178
query20 134 134 127 127
query21 211 131 116 116
query22 4459 4495 4388 4388
query23 34450 33807 33623 33623
query24 6650 2419 2482 2419
query25 477 532 390 390
query26 717 275 149 149
query27 2449 512 351 351
query28 2999 2174 2167 2167
query29 595 582 431 431
query30 288 221 192 192
query31 882 864 794 794
query32 74 63 63 63
query33 454 360 341 341
query34 779 875 514 514
query35 796 846 756 756
query36 964 1014 909 909
query37 117 101 81 81
query38 4337 4410 4245 4245
query39 1566 1506 1525 1506
query40 211 119 112 112
query41 56 57 56 56
query42 129 124 115 115
query43 512 506 473 473
query44 1344 848 845 845
query45 183 177 172 172
query46 855 1030 671 671
query47 1833 1899 1802 1802
query48 391 425 320 320
query49 692 515 442 442
query50 663 709 412 412
query51 4223 4415 4241 4241
query52 111 108 99 99
query53 231 261 189 189
query54 607 576 516 516
query55 87 84 82 82
query56 303 308 309 308
query57 1181 1217 1137 1137
query58 266 267 270 267
query59 2691 2800 2670 2670
query60 338 332 317 317
query61 136 125 122 122
query62 761 760 690 690
query63 229 191 187 187
query64 1769 1031 683 683
query65 4300 4251 4234 4234
query66 709 395 307 307
query67 15895 15736 15305 15305
query68 7731 882 529 529
query69 542 310 264 264
query70 1209 1093 1116 1093
query71 496 328 316 316
query72 6026 4874 4895 4874
query73 1475 668 360 360
query74 8944 9485 8726 8726
query75 3873 3195 2682 2682
query76 4246 1190 753 753
query77 622 371 282 282
query78 10194 10336 9321 9321
query79 2494 787 577 577
query80 677 551 450 450
query81 478 253 224 224
query82 440 126 96 96
query83 255 255 239 239
query84 299 107 101 101
query85 772 350 325 325
query86 377 308 303 303
query87 4423 4429 4374 4374
query88 3206 2270 2290 2270
query89 410 313 284 284
query90 1785 204 206 204
query91 143 148 114 114
query92 74 62 57 57
query93 2028 933 591 591
query94 671 422 304 304
query95 372 300 287 287
query96 497 575 279 279
query97 2731 2722 2607 2607
query98 265 207 196 196
query99 1641 1392 1242 1242
Total cold run time: 300115 ms
Total hot run time: 192514 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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2903985623
<details>
<summary>ClickBench: <b>Total hot run time: 29.3 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 a8d05a63b7ed83126b0a5434a6967271c0c658cc, data reload: false
query1 0.04 0.03 0.03
query2 0.13 0.10 0.12
query3 0.24 0.19 0.20
query4 1.59 0.20 0.20
query5 0.46 0.43 0.44
query6 1.53 0.66 0.66
query7 0.03 0.02 0.01
query8 0.04 0.03 0.03
query9 0.58 0.52 0.53
query10 0.57 0.58 0.57
query11 0.16 0.11 0.11
query12 0.15 0.11 0.11
query13 0.62 0.60 0.61
query14 0.80 0.80 0.80
query15 0.89 0.85 0.85
query16 0.39 0.38 0.38
query17 1.00 1.06 1.07
query18 0.24 0.23 0.21
query19 1.91 1.77 1.87
query20 0.01 0.01 0.02
query21 15.40 0.87 0.53
query22 0.77 1.26 0.69
query23 14.83 1.41 0.63
query24 6.93 2.27 1.03
query25 0.46 0.14 0.08
query26 0.65 0.16 0.13
query27 0.06 0.05 0.04
query28 9.83 0.87 0.45
query29 12.65 4.00 3.33
query30 0.25 0.09 0.06
query31 2.82 0.59 0.40
query32 3.23 0.55 0.46
query33 3.06 3.06 3.14
query34 15.77 5.04 4.48
query35 4.55 4.58 4.50
query36 0.69 0.51 0.48
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.03 0.03 0.02
query40 0.17 0.13 0.12
query41 0.08 0.03 0.03
query42 0.03 0.02 0.02
query43 0.04 0.03 0.02
Total cold run time: 103.83 s
Total hot run time: 29.3 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] [bugfix](nerids) concat function supports function folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2899876519
<details>
<summary>TPC-DS: <b>Total hot run time: 193174 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 6b657da257aad71565e7b3ad1d48818608a573eb, data reload: false
query1 1435 1087 1067 1067
query2 6271 1812 1842 1812
query3 11156 4648 4434 4434
query4 54133 25185 23054 23054
query5 5036 598 456 456
query6 334 207 208 207
query7 4884 540 299 299
query8 312 262 242 242
query9 5293 2658 2659 2658
query10 461 327 269 269
query11 15047 14971 14799 14799
query12 163 116 112 112
query13 1023 528 432 432
query14 10263 6439 6425 6425
query15 203 203 181 181
query16 7110 686 518 518
query17 1091 818 610 610
query18 1561 434 334 334
query19 209 209 179 179
query20 136 130 126 126
query21 211 133 115 115
query22 4426 4444 4275 4275
query23 34442 33667 33736 33667
query24 6719 2445 2445 2445
query25 480 491 413 413
query26 723 290 156 156
query27 2378 525 351 351
query28 3024 2192 2177 2177
query29 599 592 445 445
query30 289 228 186 186
query31 911 862 783 783
query32 75 62 63 62
query33 465 364 317 317
query34 785 910 534 534
query35 827 847 760 760
query36 941 1023 906 906
query37 140 103 80 80
query38 4317 4330 4266 4266
query39 1519 1471 1578 1471
query40 216 126 110 110
query41 53 52 51 51
query42 124 108 104 104
query43 491 516 479 479
query44 1398 848 824 824
query45 184 181 175 175
query46 917 1095 648 648
query47 1833 1855 1803 1803
query48 397 464 342 342
query49 676 523 444 444
query50 722 748 408 408
query51 4280 4185 4189 4185
query52 106 110 103 103
query53 236 270 186 186
query54 603 577 536 536
query55 85 90 89 89
query56 305 331 293 293
query57 1192 1197 1169 1169
query58 268 265 256 256
query59 2708 2810 2756 2756
query60 322 334 328 328
query61 131 123 122 122
query62 748 769 644 644
query63 233 180 197 180
query64 1737 1025 693 693
query65 4314 4284 4229 4229
query66 718 419 298 298
query67 15911 15551 15533 15533
query68 7151 915 544 544
query69 562 352 270 270
query70 1299 1072 1153 1072
query71 505 315 302 302
query72 6021 4987 5136 4987
query73 1529 783 355 355
query74 8970 9158 8798 8798
query75 3993 3214 2673 2673
query76 4209 1300 811 811
query77 728 387 276 276
query78 10107 9989 9276 9276
query79 3558 854 581 581
query80 701 520 451 451
query81 494 260 218 218
query82 478 131 101 101
query83 302 256 238 238
query84 298 101 80 80
query85 809 360 321 321
query86 367 314 304 304
query87 4435 4399 4359 4359
query88 3653 2301 2289 2289
query89 440 336 283 283
query90 1949 213 204 204
query91 138 148 121 121
query92 74 64 63 63
query93 2828 951 581 581
query94 674 443 314 314
query95 377 303 311 303
query96 506 625 289 289
query97 2817 2787 2629 2629
query98 244 214 200 200
query99 1464 1404 1270 1270
Total cold run time: 301980 ms
Total hot run time: 193174 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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "XLPE (via GitHub)" <gi...@apache.org>.
XLPE commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2907882789
run external
--
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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "XLPE (via GitHub)" <gi...@apache.org>.
XLPE commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2906822851
run cloud_p0
--
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] [bugfix](nerids) concat function supports function folding [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2899861703
<details>
<summary>TPC-H: <b>Total hot run time: 33641 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 6b657da257aad71565e7b3ad1d48818608a573eb, data reload: false
------ Round 1 ----------------------------------
q1 25653 5074 4968 4968
q2 2061 289 193 193
q3 10376 1221 669 669
q4 10452 1005 500 500
q5 7527 2371 2338 2338
q6 179 162 128 128
q7 905 750 614 614
q8 9440 1236 1049 1049
q9 6795 5070 5073 5070
q10 6841 2311 1893 1893
q11 479 283 267 267
q12 347 346 213 213
q13 17812 3701 3054 3054
q14 220 223 219 219
q15 541 490 484 484
q16 422 429 375 375
q17 590 836 359 359
q18 7653 7236 7170 7170
q19 1424 945 546 546
q20 345 329 226 226
q21 3768 3140 2341 2341
q22 1075 1004 965 965
Total cold run time: 114905 ms
Total hot run time: 33641 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5147 5124 5115 5115
q2 235 321 234 234
q3 2186 2704 2318 2318
q4 1353 1768 1320 1320
q5 4364 4382 4423 4382
q6 210 164 133 133
q7 2022 1941 1770 1770
q8 2563 2541 2516 2516
q9 7170 7213 7071 7071
q10 3007 3192 2740 2740
q11 564 503 497 497
q12 719 786 606 606
q13 3525 3878 3278 3278
q14 293 318 302 302
q15 526 487 464 464
q16 439 470 432 432
q17 1142 1485 1414 1414
q18 7787 7673 7413 7413
q19 796 830 833 830
q20 1968 1960 1845 1845
q21 4836 4433 4375 4375
q22 1125 1081 1038 1038
Total cold run time: 51977 ms
Total hot run time: 50093 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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "XLPE (via GitHub)" <gi...@apache.org>.
XLPE commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2906861379
run External Regression
--
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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51141:
URL: https://github.com/apache/doris/pull/51141#issuecomment-2908294139
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] [bugfix](nerids) complete the implementation of the concat method. [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #51141:
URL: https://github.com/apache/doris/pull/51141
--
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