You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "BePPPower (via GitHub)" <gi...@apache.org> on 2025/04/27 09:31:34 UTC
[PR] [fix](function) support new functions [doris]
BePPPower opened a new pull request, #50470:
URL: https://github.com/apache/doris/pull/50470
Problem Summary:
picked form:
1. #49392
2. #49084
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] branch-3.0: [fix](function) support new functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2833990193
TeamCity cloud ut coverage result:
Function Coverage: 83.05% (1088/1310)
Line Coverage: 65.97% (18000/27285)
Region Coverage: 65.46% (8859/13534)
Branch Coverage: 55.38% (4783/8636)
Coverage Report: http://coverage.selectdb-in.cc/coverage/2870ba5faf7c07dde915a3b38942252f2f6d99f5_2870ba5faf7c07dde915a3b38942252f2f6d99f5_cloud/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] branch-3.0: [fix](function) support new functions [doris]
Posted by "BePPPower (via GitHub)" <gi...@apache.org>.
BePPPower commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2837660586
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] branch-3.0: [fix](function) support new functions [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #50470:
URL: https://github.com/apache/doris/pull/50470
--
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] branch-3.0: [fix](function) support new functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2837824308
<details>
<summary>ClickBench: <b>Total hot run time: 31.99 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 3f326295c716c26bc2137631cfa4f8d4d73b8f1b, data reload: false
query1 0.04 0.03 0.02
query2 0.07 0.04 0.03
query3 0.23 0.06 0.07
query4 1.63 0.10 0.10
query5 0.51 0.51 0.51
query6 1.14 0.73 0.74
query7 0.02 0.01 0.02
query8 0.04 0.03 0.04
query9 0.59 0.51 0.50
query10 0.54 0.54 0.54
query11 0.15 0.11 0.11
query12 0.14 0.11 0.11
query13 0.60 0.60 0.59
query14 2.72 2.74 2.86
query15 0.89 0.83 0.83
query16 0.37 0.39 0.41
query17 0.99 1.06 1.06
query18 0.24 0.21 0.21
query19 1.97 1.81 2.02
query20 0.02 0.01 0.01
query21 15.36 0.58 0.62
query22 2.24 2.87 2.06
query23 17.03 0.98 0.88
query24 3.31 0.34 2.01
query25 0.15 0.13 0.14
query26 0.48 0.15 0.14
query27 0.04 0.05 0.05
query28 10.01 0.49 0.46
query29 12.54 3.29 3.29
query30 0.25 0.07 0.06
query31 2.85 0.40 0.38
query32 3.25 0.46 0.47
query33 2.95 3.01 3.03
query34 16.82 4.46 4.50
query35 4.56 4.52 4.54
query36 0.68 0.50 0.48
query37 0.09 0.07 0.06
query38 0.05 0.04 0.04
query39 0.04 0.02 0.03
query40 0.16 0.12 0.12
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.04 0.02 0.03
Total cold run time: 105.91 s
Total hot run time: 31.99 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] branch-3.0: [fix](function) support new functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2838016247
# BE UT Coverage Report
Increment line coverage `71.75% (254/354)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/3f326295c716c26bc2137631cfa4f8d4d73b8f1b_3f326295c716c26bc2137631cfa4f8d4d73b8f1b/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/3f326295c716c26bc2137631cfa4f8d4d73b8f1b_3f326295c716c26bc2137631cfa4f8d4d73b8f1b/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 40.55% (10658/26281) |
| Line Coverage | 31.31% (90429/288814) |
| Region Coverage | 30.45% (46691/153347) |
| Branch Coverage | 26.93% (23881/88666) |
--
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] branch-3.0: [fix](function) support new functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2837727355
TeamCity cloud ut coverage result:
Function Coverage: 83.05% (1088/1310)
Line Coverage: 66.06% (18025/27285)
Region Coverage: 65.56% (8873/13534)
Branch Coverage: 55.44% (4788/8636)
Coverage Report: http://coverage.selectdb-in.cc/coverage/3f326295c716c26bc2137631cfa4f8d4d73b8f1b_3f326295c716c26bc2137631cfa4f8d4d73b8f1b_cloud/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](function) support new functions [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2833352147
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] branch-3.0: [fix](function) support new functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2837811053
<details>
<summary>TPC-DS: <b>Total hot run time: 198581 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 3f326295c716c26bc2137631cfa4f8d4d73b8f1b, data reload: false
query1 1278 921 928 921
query2 6263 1975 1964 1964
query3 10962 4441 4287 4287
query4 61522 30630 23852 23852
query5 5247 503 471 471
query6 418 187 210 187
query7 5464 317 307 307
query8 321 238 226 226
query9 8597 2598 2593 2593
query10 448 276 254 254
query11 17543 15232 15790 15232
query12 151 109 107 107
query13 1425 448 421 421
query14 10659 7225 7794 7225
query15 202 195 192 192
query16 7027 499 528 499
query17 1147 610 605 605
query18 1619 329 316 316
query19 217 163 164 163
query20 117 110 111 110
query21 208 103 102 102
query22 4677 4513 4660 4513
query23 34712 34268 34326 34268
query24 6184 3021 3003 3003
query25 538 414 418 414
query26 656 204 170 170
query27 1932 365 365 365
query28 4035 2462 2414 2414
query29 696 449 450 449
query30 244 166 166 166
query31 967 842 837 837
query32 68 54 55 54
query33 463 292 274 274
query34 907 528 524 524
query35 887 750 717 717
query36 1081 958 948 948
query37 117 67 67 67
query38 4023 4020 4007 4007
query39 1523 1469 1483 1469
query40 218 101 98 98
query41 53 59 49 49
query42 115 107 113 107
query43 523 489 478 478
query44 1179 825 835 825
query45 192 174 174 174
query46 1152 749 728 728
query47 1995 1948 1928 1928
query48 484 379 397 379
query49 764 390 397 390
query50 866 438 437 437
query51 7425 7268 7281 7268
query52 106 93 95 93
query53 265 206 188 188
query54 582 470 473 470
query55 81 84 75 75
query56 272 284 263 263
query57 1270 1158 1134 1134
query58 221 204 250 204
query59 3180 3148 3011 3011
query60 292 267 252 252
query61 112 109 110 109
query62 788 707 685 685
query63 230 195 193 193
query64 1315 700 648 648
query65 3299 3229 3261 3229
query66 701 306 300 300
query67 15759 15637 15664 15637
query68 4133 593 573 573
query69 448 265 269 265
query70 1238 1137 1118 1118
query71 352 264 260 260
query72 6367 4098 3959 3959
query73 756 360 349 349
query74 10246 8952 9000 8952
query75 3327 2638 2632 2632
query76 2018 1111 1093 1093
query77 479 289 270 270
query78 10560 9627 9624 9624
query79 1832 625 612 612
query80 1359 445 436 436
query81 535 248 242 242
query82 1274 91 90 90
query83 267 148 143 143
query84 283 87 81 81
query85 1042 313 295 295
query86 376 296 283 283
query87 4492 4304 4211 4211
query88 3726 2394 2358 2358
query89 421 299 293 293
query90 2010 194 188 188
query91 185 150 148 148
query92 65 50 53 50
query93 2528 559 553 553
query94 802 289 294 289
query95 366 255 257 255
query96 630 276 291 276
query97 3281 3153 3177 3153
query98 220 221 195 195
query99 1558 1322 1290 1290
Total cold run time: 315160 ms
Total hot run time: 198581 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] branch-3.0: [fix](function) support new functions [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2833971447
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] branch-3.0: [fix](function) support new functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50470:
URL: https://github.com/apache/doris/pull/50470#issuecomment-2837773615
<details>
<summary>TPC-H: <b>Total hot run time: 40242 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 3f326295c716c26bc2137631cfa4f8d4d73b8f1b, data reload: false
------ Round 1 ----------------------------------
q1 17661 6807 6607 6607
q2 2064 173 173 173
q3 10644 1077 1220 1077
q4 10559 750 763 750
q5 7734 2866 2846 2846
q6 224 137 135 135
q7 961 616 608 608
q8 9371 1943 2078 1943
q9 6700 6555 6480 6480
q10 7365 2260 2311 2260
q11 469 268 263 263
q12 409 224 220 220
q13 18172 3007 3024 3007
q14 230 214 220 214
q15 491 471 476 471
q16 678 602 597 597
q17 984 500 611 500
q18 7258 6671 6782 6671
q19 1391 1059 1075 1059
q20 494 200 206 200
q21 4032 3242 3194 3194
q22 1108 967 992 967
Total cold run time: 108999 ms
Total hot run time: 40242 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6624 6604 6588 6588
q2 337 239 231 231
q3 2862 2793 2912 2793
q4 2103 1826 1779 1779
q5 5717 5682 5729 5682
q6 218 129 131 129
q7 2233 1776 1804 1776
q8 3370 3541 3506 3506
q9 8967 8827 8905 8827
q10 3570 3542 3514 3514
q11 608 491 490 490
q12 810 607 635 607
q13 8694 3224 3216 3216
q14 295 272 274 272
q15 527 473 464 464
q16 724 638 647 638
q17 1854 1633 1596 1596
q18 8190 7845 7743 7743
q19 1697 1475 1637 1475
q20 2051 1854 1816 1816
q21 5559 5322 5275 5275
q22 1125 1048 1046 1046
Total cold run time: 68135 ms
Total hot run time: 59463 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