You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "robll-v1 (via GitHub)" <gi...@apache.org> on 2025/11/11 05:44:16 UTC
[PR] (enhanced) completed the function : century from duckdb [doris]
robll-v1 opened a new pull request, #57893:
URL: https://github.com/apache/doris/pull/57893
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
mysql> SELECT CENTURY('2024-01-15');
+-----------------------+
| CENTURY('2024-01-15') |
+-----------------------+
| 21 |
+-----------------------+
1 row in set (0.03 sec)
mysql> SELECT CENTURY(NOW());
+----------------+
| CENTURY(NOW()) |
+----------------+
| 21 |
+----------------+
1 row in set (0.01 sec)
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] (enhanced) completed the function : century from duckdb [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3569353726
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572360459
<details>
<summary>TPC-DS: <b>Total hot run time: 184809 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 400017aef5f4fc75d75e289c44184ed9887e3786, data reload: false
query1 1039 419 416 416
query2 6607 1566 1592 1566
query3 6764 222 227 222
query4 25667 22539 22723 22539
query5 4382 632 470 470
query6 339 240 223 223
query7 4650 498 303 303
query8 301 250 235 235
query9 8689 2590 2610 2590
query10 496 382 318 318
query11 15363 14818 14623 14623
query12 187 117 113 113
query13 1703 594 467 467
query14 10271 8997 9059 8997
query15 209 206 181 181
query16 7587 711 558 558
query17 1289 784 647 647
query18 2059 458 351 351
query19 220 211 183 183
query20 137 134 118 118
query21 218 138 119 119
query22 4012 4053 3822 3822
query23 33039 31986 31946 31946
query24 8529 2429 2418 2418
query25 598 535 451 451
query26 1238 272 163 163
query27 2772 532 358 358
query28 4397 2185 2163 2163
query29 817 631 492 492
query30 306 244 210 210
query31 825 699 634 634
query32 83 75 68 68
query33 612 412 333 333
query34 803 870 524 524
query35 814 827 740 740
query36 901 957 854 854
query37 131 117 88 88
query38 3431 3409 3250 3250
query39 1467 1414 1407 1407
query40 224 129 118 118
query41 82 61 64 61
query42 124 109 116 109
query43 459 470 445 445
query44 1270 775 770 770
query45 192 192 190 190
query46 902 1021 669 669
query47 1689 1711 1667 1667
query48 399 441 326 326
query49 775 514 413 413
query50 659 683 404 404
query51 3875 3868 4005 3868
query52 110 110 107 107
query53 251 275 194 194
query54 312 300 282 282
query55 94 88 85 85
query56 329 319 314 314
query57 1138 1168 1106 1106
query58 289 274 267 267
query59 2366 2554 2408 2408
query60 352 354 334 334
query61 169 171 165 165
query62 781 724 666 666
query63 229 197 201 197
query64 4503 1245 920 920
query65 4070 3976 4002 3976
query66 1165 434 330 330
query67 15172 15116 14902 14902
query68 5482 942 655 655
query69 537 358 304 304
query70 1281 1212 1139 1139
query71 409 339 308 308
query72 6096 5008 5063 5008
query73 697 636 374 374
query74 8810 8781 8567 8567
query75 3283 3366 2847 2847
query76 3355 1141 727 727
query77 510 401 310 310
query78 9457 9775 8937 8937
query79 1068 822 604 604
query80 1176 589 497 497
query81 533 266 237 237
query82 432 171 136 136
query83 281 266 267 266
query84 251 120 94 94
query85 895 526 559 526
query86 338 312 293 293
query87 3494 3567 3399 3399
query88 2836 2254 2239 2239
query89 386 334 287 287
query90 1759 225 219 219
query91 193 195 173 173
query92 75 70 71 70
query93 1125 999 680 680
query94 744 459 366 366
query95 523 427 414 414
query96 493 542 286 286
query97 2908 2969 2893 2893
query98 244 215 208 208
query99 1296 1389 1293 1293
Total cold run time: 265899 ms
Total hot run time: 184809 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3575087879
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565809082
<details>
<summary>ClickBench: <b>Total hot run time: 27.22 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 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.05 0.06
query3 0.26 0.08 0.08
query4 1.60 0.11 0.11
query5 0.27 0.26 0.25
query6 1.17 0.66 0.65
query7 0.03 0.03 0.02
query8 0.06 0.04 0.04
query9 0.58 0.53 0.53
query10 0.57 0.57 0.56
query11 0.16 0.11 0.11
query12 0.14 0.12 0.12
query13 0.62 0.60 0.61
query14 1.00 1.00 0.99
query15 0.85 0.82 0.83
query16 0.39 0.41 0.38
query17 1.01 1.03 1.04
query18 0.21 0.20 0.19
query19 1.87 1.73 1.76
query20 0.04 0.01 0.01
query21 15.43 0.20 0.13
query22 5.06 0.07 0.05
query23 15.65 0.26 0.11
query24 2.90 1.54 0.31
query25 0.07 0.06 0.06
query26 0.15 0.12 0.13
query27 0.06 0.05 0.06
query28 4.08 1.15 0.95
query29 12.56 3.85 3.21
query30 0.27 0.12 0.11
query31 2.81 0.58 0.39
query32 3.22 0.54 0.49
query33 2.95 3.06 3.01
query34 15.77 5.11 4.54
query35 4.65 4.56 4.54
query36 0.68 0.49 0.48
query37 0.10 0.07 0.06
query38 0.07 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.13 0.13
query41 0.09 0.03 0.03
query42 0.04 0.03 0.03
query43 0.05 0.03 0.04
Total cold run time: 97.83 s
Total hot run time: 27.22 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565867126
# FE UT Coverage Report
Increment line coverage ` 5.56% (1/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3551307666
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562848470
<details>
<summary>TPC-H: <b>Total hot run time: 34973 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 6cef593381e024328e084fe233417b7c22b8c6da, data reload: false
------ Round 1 ----------------------------------
q1 17592 4958 4888 4888
q2 1997 317 202 202
q3 10312 1358 717 717
q4 10265 915 375 375
q5 8233 2294 2431 2294
q6 187 167 137 137
q7 930 797 647 647
q8 9367 1352 1077 1077
q9 7293 5531 5765 5531
q10 6890 2248 1793 1793
q11 520 294 276 276
q12 332 364 224 224
q13 17776 3672 2998 2998
q14 225 237 218 218
q15 580 511 505 505
q16 1008 1028 942 942
q17 584 860 364 364
q18 7441 7539 7568 7539
q19 1357 966 554 554
q20 367 373 237 237
q21 3996 3338 2413 2413
q22 1093 1103 1042 1042
Total cold run time: 108345 ms
Total hot run time: 34973 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5191 5161 5152 5152
q2 327 411 355 355
q3 2289 2935 2458 2458
q4 1471 1858 1458 1458
q5 4470 4664 4343 4343
q6 197 161 121 121
q7 1959 1935 1808 1808
q8 2618 2567 2526 2526
q9 7623 7473 7184 7184
q10 2871 3076 2628 2628
q11 555 511 500 500
q12 621 713 553 553
q13 3224 3677 2994 2994
q14 271 284 253 253
q15 527 503 484 484
q16 1016 1053 999 999
q17 1078 1453 1314 1314
q18 7267 6983 6910 6910
q19 751 724 794 724
q20 1897 1950 1821 1821
q21 4813 4398 4370 4370
q22 1073 1023 962 962
Total cold run time: 52109 ms
Total hot run time: 49917 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3571857339
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb merged PR #57893:
URL: https://github.com/apache/doris/pull/57893
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3569348377
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572383091
<details>
<summary>ClickBench: <b>Total hot run time: 27.36 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 400017aef5f4fc75d75e289c44184ed9887e3786, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.09 0.08
query4 1.61 0.11 0.10
query5 0.28 0.25 0.25
query6 1.15 0.65 0.65
query7 0.02 0.02 0.02
query8 0.05 0.05 0.04
query9 0.58 0.54 0.51
query10 0.58 0.59 0.58
query11 0.16 0.11 0.11
query12 0.15 0.13 0.11
query13 0.61 0.61 0.60
query14 1.00 1.00 1.00
query15 0.85 0.83 0.84
query16 0.41 0.39 0.39
query17 1.03 1.04 1.02
query18 0.22 0.21 0.20
query19 1.84 1.84 1.83
query20 0.01 0.01 0.01
query21 15.52 0.20 0.13
query22 5.08 0.07 0.04
query23 15.68 0.26 0.11
query24 2.68 0.88 0.32
query25 0.08 0.06 0.06
query26 0.14 0.13 0.12
query27 0.06 0.05 0.06
query28 3.77 1.14 0.94
query29 12.56 3.98 3.23
query30 0.28 0.13 0.12
query31 2.81 0.57 0.38
query32 3.23 0.57 0.47
query33 2.97 3.15 3.02
query34 16.01 5.19 4.52
query35 4.55 4.59 4.57
query36 0.69 0.50 0.49
query37 0.10 0.06 0.08
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.14
query41 0.09 0.02 0.03
query42 0.03 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 97.6 s
Total hot run time: 27.36 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] (enhanced) completed the function : century from duckdb [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572035723
compile failed. still need to fix
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3573312261
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.55% (24404/34106) |
| Line Coverage | 58.02% (253661/437196) |
| Region Coverage | 53.40% (211996/396965) |
| Branch Coverage | 54.68% (90292/165135) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565796346
<details>
<summary>TPC-DS: <b>Total hot run time: 187024 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 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
query1 1096 391 372 372
query2 6610 1699 1712 1699
query3 6858 222 223 222
query4 25959 23458 22727 22727
query5 4410 644 485 485
query6 381 263 249 249
query7 4657 493 296 296
query8 323 260 244 244
query9 8713 2588 2583 2583
query10 505 348 296 296
query11 15235 15062 14805 14805
query12 176 126 114 114
query13 1686 588 456 456
query14 10494 9171 9192 9171
query15 196 189 177 177
query16 7683 672 530 530
query17 1244 736 615 615
query18 2009 419 323 323
query19 211 203 175 175
query20 131 127 121 121
query21 266 131 113 113
query22 3966 4061 3959 3959
query23 34002 33082 33094 33082
query24 8418 2410 2388 2388
query25 599 522 459 459
query26 1248 270 164 164
query27 2740 494 363 363
query28 4356 2189 2160 2160
query29 814 611 492 492
query30 318 218 212 212
query31 894 789 717 717
query32 81 81 74 74
query33 624 382 319 319
query34 795 847 517 517
query35 841 837 729 729
query36 938 980 857 857
query37 141 102 83 83
query38 3528 3521 3499 3499
query39 1476 1416 1405 1405
query40 229 124 121 121
query41 70 64 63 63
query42 123 106 115 106
query43 491 499 457 457
query44 1236 762 757 757
query45 187 177 177 177
query46 884 985 632 632
query47 1730 1755 1682 1682
query48 398 418 329 329
query49 767 490 390 390
query50 639 675 402 402
query51 3883 3842 3990 3842
query52 113 113 103 103
query53 246 264 195 195
query54 307 288 276 276
query55 84 82 81 81
query56 332 320 314 314
query57 1158 1171 1106 1106
query58 284 280 285 280
query59 2539 2603 2494 2494
query60 338 343 334 334
query61 191 164 160 160
query62 789 703 661 661
query63 240 199 192 192
query64 4425 1175 877 877
query65 4051 3945 3934 3934
query66 1126 440 329 329
query67 15268 15014 14721 14721
query68 4706 951 638 638
query69 522 325 281 281
query70 1319 1318 1280 1280
query71 418 343 313 313
query72 5964 5021 5121 5021
query73 665 603 365 365
query74 8835 9035 8884 8884
query75 3281 3334 2806 2806
query76 3267 1156 732 732
query77 535 419 318 318
query78 9432 9791 8989 8989
query79 2103 812 608 608
query80 1289 664 501 501
query81 550 252 222 222
query82 412 155 130 130
query83 271 262 240 240
query84 259 115 98 98
query85 909 487 453 453
query86 396 290 301 290
query87 3796 3768 3645 3645
query88 2836 2282 2266 2266
query89 376 327 288 288
query90 1667 231 225 225
query91 165 170 133 133
query92 75 69 57 57
query93 1231 997 685 685
query94 764 430 348 348
query95 397 327 314 314
query96 472 568 282 282
query97 2897 2990 2846 2846
query98 235 215 207 207
query99 1286 1416 1292 1292
Total cold run time: 268080 ms
Total hot run time: 187024 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565777112
<details>
<summary>TPC-H: <b>Total hot run time: 34352 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 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
------ Round 1 ----------------------------------
q1 17694 5031 4882 4882
q2 2224 310 209 209
q3 10192 1278 688 688
q4 10253 922 399 399
q5 7585 2345 2410 2345
q6 184 175 139 139
q7 892 770 639 639
q8 9380 1343 1160 1160
q9 7206 5460 5537 5460
q10 7016 2233 1792 1792
q11 504 300 290 290
q12 334 361 227 227
q13 17777 3577 3019 3019
q14 225 237 207 207
q15 571 522 501 501
q16 1011 1009 978 978
q17 588 855 364 364
q18 7380 7100 7196 7100
q19 1166 931 525 525
q20 336 326 221 221
q21 3613 3086 2229 2229
q22 1092 1015 978 978
Total cold run time: 107223 ms
Total hot run time: 34352 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4970 4922 4906 4906
q2 320 388 329 329
q3 2120 2681 2211 2211
q4 1315 1771 1330 1330
q5 4186 4462 4501 4462
q6 220 188 133 133
q7 2057 1911 1791 1791
q8 2647 2495 2628 2495
q9 7540 7483 7566 7483
q10 2999 3246 2794 2794
q11 604 545 518 518
q12 733 758 654 654
q13 3503 3895 3285 3285
q14 306 298 287 287
q15 561 493 496 493
q16 1082 1082 1043 1043
q17 1114 1517 1422 1422
q18 7830 7500 7713 7500
q19 800 892 868 868
q20 2014 2042 1797 1797
q21 4718 4414 4316 4316
q22 1056 1033 997 997
Total cold run time: 52695 ms
Total hot run time: 51114 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565847264
# BE UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.64% (18283/34735) |
| Line Coverage | 38.08% (166359/436870) |
| Region Coverage | 33.03% (129368/391628) |
| Branch Coverage | 33.83% (55514/164107) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562890328
<details>
<summary>TPC-DS: <b>Total hot run time: 186757 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 6cef593381e024328e084fe233417b7c22b8c6da, data reload: false
query1 1013 404 410 404
query2 6541 1687 1658 1658
query3 6768 222 229 222
query4 26285 23135 22989 22989
query5 4422 647 474 474
query6 348 244 232 232
query7 4647 496 303 303
query8 313 267 246 246
query9 8707 2590 2587 2587
query10 474 351 294 294
query11 15641 15079 14801 14801
query12 170 113 108 108
query13 1674 570 439 439
query14 11146 9093 9064 9064
query15 196 185 161 161
query16 7590 669 503 503
query17 1226 734 633 633
query18 2015 421 318 318
query19 205 199 174 174
query20 126 123 119 119
query21 212 132 112 112
query22 4092 4110 4127 4110
query23 33887 33039 32885 32885
query24 8435 2399 2431 2399
query25 576 513 429 429
query26 1234 266 153 153
query27 2783 484 358 358
query28 4345 2195 2175 2175
query29 795 606 468 468
query30 305 225 197 197
query31 930 793 720 720
query32 80 76 71 71
query33 572 384 325 325
query34 785 848 518 518
query35 801 823 725 725
query36 952 982 899 899
query37 149 108 88 88
query38 3463 3474 3463 3463
query39 1640 1570 1433 1433
query40 219 124 118 118
query41 67 61 60 60
query42 125 111 111 111
query43 477 482 468 468
query44 1247 766 768 766
query45 186 182 170 170
query46 878 981 631 631
query47 1769 1827 1731 1731
query48 410 427 326 326
query49 786 478 404 404
query50 652 673 392 392
query51 3862 3874 3933 3874
query52 107 111 106 106
query53 238 261 197 197
query54 307 289 284 284
query55 85 83 82 82
query56 337 325 327 325
query57 1196 1184 1116 1116
query58 280 276 274 274
query59 2550 2629 2484 2484
query60 331 338 342 338
query61 166 165 161 161
query62 770 702 676 676
query63 225 190 188 188
query64 4480 1271 936 936
query65 4029 3963 3942 3942
query66 1105 429 325 325
query67 14924 15372 14847 14847
query68 5700 959 632 632
query69 495 320 277 277
query70 1339 1185 1270 1185
query71 424 339 309 309
query72 5980 4847 4814 4814
query73 614 583 368 368
query74 8890 9041 8645 8645
query75 3297 3295 2787 2787
query76 3310 1126 698 698
query77 538 397 314 314
query78 9614 9614 8919 8919
query79 1397 812 606 606
query80 683 563 492 492
query81 486 255 227 227
query82 213 171 154 154
query83 277 272 258 258
query84 252 114 87 87
query85 883 476 483 476
query86 323 306 293 293
query87 3719 3804 3618 3618
query88 2889 2273 2238 2238
query89 402 331 308 308
query90 1746 226 229 226
query91 187 178 153 153
query92 71 72 62 62
query93 1154 988 688 688
query94 663 473 357 357
query95 429 344 334 334
query96 493 583 280 280
query97 2889 2982 2853 2853
query98 234 209 216 209
query99 1330 1390 1301 1301
Total cold run time: 268272 ms
Total hot run time: 186757 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563834247
<details>
<summary>ClickBench: <b>Total hot run time: 27.31 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 1b4dee7d8e8e582813a843d9acddf72ff86782d5, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.05
query3 0.26 0.08 0.08
query4 1.60 0.11 0.10
query5 0.27 0.26 0.26
query6 1.17 0.65 0.63
query7 0.03 0.02 0.03
query8 0.05 0.04 0.04
query9 0.58 0.53 0.52
query10 0.57 0.58 0.57
query11 0.16 0.11 0.12
query12 0.15 0.11 0.13
query13 0.62 0.60 0.62
query14 1.01 0.99 1.00
query15 0.83 0.83 0.84
query16 0.38 0.40 0.38
query17 1.01 1.02 1.00
query18 0.21 0.20 0.20
query19 1.95 1.77 1.82
query20 0.02 0.01 0.01
query21 15.47 0.21 0.13
query22 5.07 0.06 0.05
query23 15.64 0.26 0.11
query24 2.45 1.37 0.32
query25 0.08 0.06 0.07
query26 0.15 0.13 0.14
query27 0.08 0.06 0.06
query28 4.33 1.16 0.93
query29 12.58 3.88 3.24
query30 0.28 0.15 0.11
query31 2.81 0.59 0.41
query32 3.22 0.54 0.47
query33 3.11 3.02 3.06
query34 15.56 5.15 4.55
query35 4.59 4.58 4.55
query36 0.68 0.50 0.49
query37 0.10 0.07 0.06
query38 0.07 0.04 0.05
query39 0.04 0.03 0.03
query40 0.17 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.03 0.02
query43 0.04 0.04 0.04
Total cold run time: 97.66 s
Total hot run time: 27.31 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563980243
# BE UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/1b4dee7d8e8e582813a843d9acddf72ff86782d5_1b4dee7d8e8e582813a843d9acddf72ff86782d5/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/1b4dee7d8e8e582813a843d9acddf72ff86782d5_1b4dee7d8e8e582813a843d9acddf72ff86782d5/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.64% (18283/34735) |
| Line Coverage | 38.08% (166359/436861) |
| Region Coverage | 33.03% (129338/391628) |
| Branch Coverage | 33.82% (55509/164107) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565496728
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565696423
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566373316
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 73.01% (24895/34096) |
| Line Coverage | 60.05% (262461/437036) |
| Region Coverage | 55.39% (219866/396936) |
| Branch Coverage | 57.06% (94213/165118) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566324778
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 73.01% (24893/34096) |
| Line Coverage | 60.05% (262441/437036) |
| Region Coverage | 55.38% (219820/396936) |
| Branch Coverage | 57.06% (94209/165118) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572158109
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515493800
# BE UT Coverage Report
Increment line coverage ` ` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/1b9ab77eb857ca1fa6af6d1183feba8da7912751_1b9ab77eb857ca1fa6af6d1183feba8da7912751/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/1b9ab77eb857ca1fa6af6d1183feba8da7912751_1b9ab77eb857ca1fa6af6d1183feba8da7912751/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.82% (18283/34611) |
| Line Coverage | 38.20% (166245/435251) |
| Region Coverage | 33.19% (129247/389444) |
| Branch Coverage | 33.92% (55461/163488) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3520370913
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on code in PR #57893:
URL: https://github.com/apache/doris/pull/57893#discussion_r2514774317
##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,23 @@ namespace doris::vectorized {
#define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>
+struct ToCenturyImpl {
+ static constexpr PrimitiveType OpArgType = PType;
+ using NativeType = typename PrimitiveTypeTraits<PType>::CppNativeType;
+ static constexpr auto name = "century";
+
+ static inline auto execute(const NativeType& t) {
+ const auto& date_time_value = (typename PrimitiveTypeTraits<PType>::CppType&)(t);
+ int year = date_time_value.year();
+ // 计算世纪: (year - 1) / 100 + 1
Review Comment:
plz use english for comment
##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,23 @@ namespace doris::vectorized {
#define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>
Review Comment:
where is this template instantiated?
##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,23 @@ namespace doris::vectorized {
#define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>
Review Comment:
Also register this function in BE.
I think the example in pr description didn't reach be, because the input is a constant value, which will directly go through the constant folding part of fe. If you want to test the code of be, you can try `SET debug_skip_fold_constant = true;` or directly creating a table.
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521803246
@linrrzqqq Could you please first check the correctness of my code
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563699282
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562906274
<details>
<summary>ClickBench: <b>Total hot run time: 27.4 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 6cef593381e024328e084fe233417b7c22b8c6da, data reload: false
query1 0.05 0.04 0.04
query2 0.09 0.05 0.05
query3 0.26 0.08 0.08
query4 1.64 0.11 0.10
query5 0.27 0.26 0.25
query6 1.16 0.65 0.64
query7 0.04 0.03 0.02
query8 0.05 0.04 0.04
query9 0.58 0.54 0.52
query10 0.57 0.59 0.57
query11 0.16 0.11 0.11
query12 0.16 0.11 0.12
query13 0.62 0.60 0.61
query14 1.00 1.00 0.99
query15 0.84 0.83 0.85
query16 0.39 0.40 0.38
query17 1.05 0.99 1.01
query18 0.22 0.19 0.19
query19 1.98 1.76 1.86
query20 0.02 0.02 0.02
query21 15.44 0.19 0.12
query22 4.90 0.07 0.05
query23 15.68 0.25 0.10
query24 1.99 0.58 0.46
query25 0.07 0.07 0.06
query26 0.15 0.13 0.14
query27 0.06 0.06 0.05
query28 4.38 1.15 0.92
query29 12.56 3.90 3.32
query30 0.27 0.14 0.11
query31 2.81 0.60 0.39
query32 3.22 0.55 0.47
query33 3.02 3.05 3.09
query34 15.79 5.19 4.53
query35 4.51 4.52 4.54
query36 0.67 0.51 0.49
query37 0.10 0.07 0.06
query38 0.07 0.04 0.03
query39 0.04 0.04 0.03
query40 0.18 0.15 0.14
query41 0.08 0.03 0.03
query42 0.04 0.03 0.02
query43 0.04 0.03 0.03
Total cold run time: 97.22 s
Total hot run time: 27.4 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3550911005
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3573346829
# FE Regression Coverage Report
Increment line coverage ` 77.78% (14/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572399331
# BE UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/400017aef5f4fc75d75e289c44184ed9887e3786_400017aef5f4fc75d75e289c44184ed9887e3786/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/400017aef5f4fc75d75e289c44184ed9887e3786_400017aef5f4fc75d75e289c44184ed9887e3786/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.65% (18294/34748) |
| Line Coverage | 38.07% (166391/437039) |
| Region Coverage | 33.04% (129398/391640) |
| Branch Coverage | 33.82% (55504/164134) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566417641
# FE Regression Coverage Report
Increment line coverage ` 77.78% (14/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565627409
# BE UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.64% (18283/34735) |
| Line Coverage | 38.08% (166367/436870) |
| Region Coverage | 33.03% (129345/391628) |
| Branch Coverage | 33.83% (55511/164107) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565648843
# FE UT Coverage Report
Increment line coverage ` 5.56% (1/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565856913
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.49% (24375/34096) |
| Line Coverage | 57.96% (253314/437036) |
| Region Coverage | 53.29% (211514/396936) |
| Branch Coverage | 54.62% (90189/165118) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3575192527
fix the docs then we can merge both~
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3575215283
Okay, thank you for your patience
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521928200
solve the format
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515092111
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3545037921
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572430557
# FE UT Coverage Report
Increment line coverage ` 5.56% (1/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786/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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515398839
<details>
<summary>TPC-H: <b>Total hot run time: 34180 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 1b9ab77eb857ca1fa6af6d1183feba8da7912751, data reload: false
------ Round 1 ----------------------------------
q1 17602 5176 5050 5050
q2 2034 358 206 206
q3 10220 1272 695 695
q4 10233 918 372 372
q5 7526 2365 2308 2308
q6 184 170 132 132
q7 918 763 616 616
q8 9328 1329 1092 1092
q9 6917 5122 5154 5122
q10 6880 2215 1816 1816
q11 496 298 303 298
q12 338 363 231 231
q13 18114 3710 3150 3150
q14 231 234 226 226
q15 580 512 501 501
q16 1022 1025 955 955
q17 607 887 375 375
q18 7587 7050 7086 7050
q19 1483 946 545 545
q20 354 333 218 218
q21 3666 3188 2252 2252
q22 1069 1018 970 970
Total cold run time: 107389 ms
Total hot run time: 34180 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5161 5115 5058 5058
q2 245 324 226 226
q3 2184 2648 2295 2295
q4 1356 1747 1357 1357
q5 4135 4381 4567 4381
q6 212 173 133 133
q7 2030 1950 1755 1755
q8 2707 2730 2558 2558
q9 7359 7412 7278 7278
q10 3088 3249 2793 2793
q11 602 529 496 496
q12 684 1067 613 613
q13 3453 3895 3244 3244
q14 277 348 308 308
q15 539 504 494 494
q16 1065 1114 1081 1081
q17 1178 1556 1383 1383
q18 7951 7881 7544 7544
q19 779 857 1012 857
q20 2047 1996 1830 1830
q21 4730 4497 4270 4270
q22 1090 1030 984 984
Total cold run time: 52872 ms
Total hot run time: 50938 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515446987
<details>
<summary>ClickBench: <b>Total hot run time: 27.42 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 1b9ab77eb857ca1fa6af6d1183feba8da7912751, data reload: false
query1 0.06 0.04 0.05
query2 0.10 0.05 0.04
query3 0.25 0.08 0.08
query4 1.61 0.12 0.11
query5 0.27 0.26 0.26
query6 1.18 0.64 0.66
query7 0.03 0.02 0.03
query8 0.05 0.05 0.04
query9 0.60 0.52 0.51
query10 0.57 0.57 0.57
query11 0.16 0.12 0.11
query12 0.16 0.12 0.12
query13 0.61 0.61 0.60
query14 0.99 1.00 1.01
query15 0.83 0.81 0.82
query16 0.41 0.39 0.39
query17 1.01 1.00 1.05
query18 0.21 0.20 0.20
query19 1.93 1.81 1.82
query20 0.01 0.02 0.01
query21 15.44 0.18 0.13
query22 5.18 0.06 0.05
query23 15.66 0.26 0.10
query24 2.60 1.17 0.42
query25 0.07 0.06 0.06
query26 0.14 0.14 0.13
query27 0.07 0.05 0.05
query28 4.58 1.13 0.94
query29 12.57 3.91 3.21
query30 0.28 0.16 0.11
query31 2.82 0.59 0.39
query32 3.24 0.56 0.48
query33 3.07 3.02 3.12
query34 15.81 5.19 4.59
query35 4.59 4.60 4.54
query36 0.67 0.49 0.49
query37 0.09 0.06 0.07
query38 0.06 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.14
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.36 s
Total hot run time: 27.42 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3517765661
Please add as comprehensive test cases as possible.
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521091973
# BE UT Coverage Report
Increment line coverage ` ` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/9c2892f46a2873712235737086dcada39333cef6_9c2892f46a2873712235737086dcada39333cef6/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/9c2892f46a2873712235737086dcada39333cef6_9c2892f46a2873712235737086dcada39333cef6/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.81% (18279/34611) |
| Line Coverage | 38.17% (166148/435260) |
| Region Coverage | 33.20% (129299/389453) |
| Branch Coverage | 33.91% (55438/163491) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521941204
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563302740
# FE Regression Coverage Report
Increment line coverage ` 72.22% (13/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563209918
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.56% (24400/34096) |
| Line Coverage | 58.03% (253608/437027) |
| Region Coverage | 53.30% (211585/396936) |
| Branch Coverage | 54.74% (90382/165118) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515135236
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515287924
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565588086
<details>
<summary>ClickBench: <b>Total hot run time: 27.19 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 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
query1 0.05 0.05 0.08
query2 0.09 0.04 0.04
query3 0.26 0.09 0.08
query4 1.61 0.11 0.11
query5 0.26 0.24 0.25
query6 1.20 0.66 0.63
query7 0.04 0.02 0.03
query8 0.06 0.04 0.05
query9 0.58 0.52 0.52
query10 0.58 0.56 0.58
query11 0.16 0.11 0.11
query12 0.15 0.12 0.12
query13 0.62 0.60 0.60
query14 1.00 1.01 0.98
query15 0.83 0.82 0.83
query16 0.40 0.38 0.39
query17 1.04 1.04 1.03
query18 0.21 0.20 0.19
query19 1.92 1.85 1.80
query20 0.02 0.01 0.01
query21 15.40 0.22 0.13
query22 4.90 0.07 0.05
query23 15.69 0.25 0.10
query24 2.85 1.63 0.39
query25 0.08 0.07 0.05
query26 0.15 0.14 0.13
query27 0.07 0.05 0.05
query28 4.70 1.16 0.93
query29 12.62 3.88 3.22
query30 0.28 0.13 0.11
query31 2.81 0.57 0.38
query32 3.23 0.53 0.46
query33 2.95 3.02 3.04
query34 15.83 5.19 4.46
query35 4.56 4.55 4.54
query36 0.69 0.51 0.49
query37 0.10 0.07 0.07
query38 0.06 0.04 0.04
query39 0.04 0.04 0.03
query40 0.18 0.15 0.13
query41 0.08 0.03 0.03
query42 0.04 0.03 0.02
query43 0.05 0.03 0.03
Total cold run time: 98.44 s
Total hot run time: 27.19 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565824192
# BE Regression && UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.49% (24375/34096) |
| Line Coverage | 57.96% (253317/437036) |
| Region Coverage | 53.29% (211546/396936) |
| Branch Coverage | 54.62% (90192/165118) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3560994068
compile failed in FE. please rebase your code and fix it
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562697812
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3545322682
# BE UT Coverage Report
Increment line coverage `50.00% (5/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/6554d35d7deb278c66a82afee685d67c69a83418_6554d35d7deb278c66a82afee685d67c69a83418/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/6554d35d7deb278c66a82afee685d67c69a83418_6554d35d7deb278c66a82afee685d67c69a83418/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.73% (18271/34650) |
| Line Coverage | 38.10% (165990/435675) |
| Region Coverage | 33.06% (129091/390422) |
| Branch Coverage | 33.81% (55376/163777) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on code in PR #57893:
URL: https://github.com/apache/doris/pull/57893#discussion_r2555016206
##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,22 @@ namespace doris::vectorized {
#define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>
+struct ToCenturyImpl {
+ static constexpr PrimitiveType OpArgType = PType;
+ using NativeType = typename PrimitiveTypeTraits<PType>::CppNativeType;
+ static constexpr auto name = "century";
+
+ static inline auto execute(const NativeType& t) {
+ const auto& date_time_value = (typename PrimitiveTypeTraits<PType>::CppType&)(t);
Review Comment:
```suggestion
const auto& date_time_value = assert_cast<typename PrimitiveTypeTraits<PType>::CppType&>(t);
```
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515091464
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515432177
<details>
<summary>TPC-DS: <b>Total hot run time: 187991 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 1b9ab77eb857ca1fa6af6d1183feba8da7912751, data reload: false
query1 1059 406 410 406
query2 6617 1734 1725 1725
query3 6753 223 216 216
query4 26624 23870 23468 23468
query5 4410 600 464 464
query6 329 228 218 218
query7 4645 494 291 291
query8 295 259 264 259
query9 8698 2600 2597 2597
query10 497 349 307 307
query11 15844 15010 14854 14854
query12 178 121 111 111
query13 1659 559 441 441
query14 11081 9248 9238 9238
query15 199 185 181 181
query16 7513 686 493 493
query17 1212 732 608 608
query18 2017 444 321 321
query19 211 201 175 175
query20 133 128 119 119
query21 213 131 112 112
query22 3877 3972 4056 3972
query23 33753 32949 33112 32949
query24 8457 2404 2433 2404
query25 597 549 445 445
query26 1241 269 161 161
query27 2768 494 355 355
query28 4363 2201 2221 2201
query29 792 593 470 470
query30 306 224 203 203
query31 924 800 719 719
query32 81 72 67 67
query33 584 366 324 324
query34 788 844 529 529
query35 806 834 752 752
query36 964 1004 901 901
query37 116 110 87 87
query38 3548 3578 3461 3461
query39 1467 1430 1415 1415
query40 225 130 124 124
query41 62 60 63 60
query42 124 117 113 113
query43 485 506 458 458
query44 1211 741 735 735
query45 192 185 185 185
query46 901 984 637 637
query47 1733 1809 1687 1687
query48 385 422 318 318
query49 812 517 418 418
query50 641 685 407 407
query51 3867 3968 3873 3873
query52 114 113 102 102
query53 248 262 203 203
query54 322 301 295 295
query55 87 89 83 83
query56 347 333 332 332
query57 1176 1187 1118 1118
query58 294 282 283 282
query59 2553 2630 2612 2612
query60 358 361 348 348
query61 193 197 192 192
query62 798 733 675 675
query63 231 200 190 190
query64 4561 1268 950 950
query65 4047 3958 3947 3947
query66 1143 465 365 365
query67 15331 14929 14804 14804
query68 8233 918 600 600
query69 503 331 295 295
query70 1311 1258 1213 1213
query71 454 340 324 324
query72 6267 4929 5034 4929
query73 644 607 362 362
query74 8879 9032 8980 8980
query75 3539 3323 2745 2745
query76 3405 1155 746 746
query77 717 404 310 310
query78 9508 9605 8865 8865
query79 2296 875 608 608
query80 692 567 492 492
query81 515 260 231 231
query82 459 165 128 128
query83 277 262 243 243
query84 258 108 102 102
query85 918 470 452 452
query86 389 299 308 299
query87 3700 3677 3653 3653
query88 3837 2265 2243 2243
query89 399 345 288 288
query90 1924 222 230 222
query91 191 168 141 141
query92 80 68 65 65
query93 2206 962 630 630
query94 723 458 333 333
query95 405 321 318 318
query96 487 559 285 285
query97 2900 2958 2854 2854
query98 243 218 215 215
query99 1379 1428 1288 1288
Total cold run time: 275798 ms
Total hot run time: 187991 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on code in PR #57893:
URL: https://github.com/apache/doris/pull/57893#discussion_r2517725572
##########
regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy:
##########
Review Comment:
Add expected results in `test_date_function.out`.
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565555501
<details>
<summary>TPC-H: <b>Total hot run time: 35127 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 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
------ Round 1 ----------------------------------
q1 17595 5059 4879 4879
q2 2008 318 214 214
q3 10224 1270 737 737
q4 10232 892 358 358
q5 7538 2414 2342 2342
q6 184 170 139 139
q7 925 787 623 623
q8 9353 1344 1201 1201
q9 6990 5338 5376 5338
q10 7230 2232 1824 1824
q11 493 295 283 283
q12 342 372 238 238
q13 17850 3641 3024 3024
q14 239 229 211 211
q15 580 503 499 499
q16 999 995 952 952
q17 571 838 392 392
q18 7281 7427 7636 7427
q19 1166 981 568 568
q20 372 368 262 262
q21 4461 4020 2580 2580
q22 1147 1123 1036 1036
Total cold run time: 107780 ms
Total hot run time: 35127 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5168 5254 5220 5220
q2 325 401 321 321
q3 2454 2892 2485 2485
q4 1468 1906 1453 1453
q5 4568 4534 4282 4282
q6 198 171 127 127
q7 2032 1906 1722 1722
q8 2671 2599 2510 2510
q9 7579 7452 7504 7452
q10 2902 3110 2659 2659
q11 561 498 495 495
q12 649 721 556 556
q13 3275 3681 3077 3077
q14 283 284 261 261
q15 546 492 497 492
q16 1012 1039 982 982
q17 1104 1516 1322 1322
q18 7311 7250 7026 7026
q19 789 776 982 776
q20 1946 1997 1797 1797
q21 4704 4375 4197 4197
q22 1075 1031 1001 1001
Total cold run time: 52620 ms
Total hot run time: 50213 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562962822
# BE UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/6cef593381e024328e084fe233417b7c22b8c6da_6cef593381e024328e084fe233417b7c22b8c6da/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/6cef593381e024328e084fe233417b7c22b8c6da_6cef593381e024328e084fe233417b7c22b8c6da/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.63% (18282/34735) |
| Line Coverage | 38.08% (166356/436861) |
| Region Coverage | 33.01% (129295/391628) |
| Branch Coverage | 33.83% (55512/164107) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563776879
<details>
<summary>TPC-H: <b>Total hot run time: 34328 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 1b4dee7d8e8e582813a843d9acddf72ff86782d5, data reload: false
------ Round 1 ----------------------------------
q1 17588 5078 5063 5063
q2 2026 315 204 204
q3 10252 1272 722 722
q4 10242 977 379 379
q5 7543 2360 2331 2331
q6 179 173 137 137
q7 927 773 637 637
q8 9345 1341 1089 1089
q9 7098 5348 5357 5348
q10 6814 2234 1788 1788
q11 475 300 279 279
q12 340 368 240 240
q13 17776 3667 3022 3022
q14 226 247 222 222
q15 556 517 513 513
q16 1022 1018 935 935
q17 588 858 385 385
q18 7463 7216 7003 7003
q19 1078 964 547 547
q20 342 340 224 224
q21 3765 3226 2285 2285
q22 1044 1026 975 975
Total cold run time: 106689 ms
Total hot run time: 34328 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4990 4951 4949 4949
q2 312 394 307 307
q3 2229 2687 2257 2257
q4 1338 1771 1321 1321
q5 4171 4376 4660 4376
q6 215 170 132 132
q7 2044 1967 1812 1812
q8 2648 2664 2641 2641
q9 7583 7525 7546 7525
q10 3054 3296 2916 2916
q11 574 555 498 498
q12 666 772 619 619
q13 3489 3931 3364 3364
q14 304 297 266 266
q15 547 517 527 517
q16 1064 1098 1091 1091
q17 1155 1593 1382 1382
q18 7972 7592 7619 7592
q19 788 797 929 797
q20 2046 2065 1913 1913
q21 5095 4352 4194 4194
q22 1078 1027 996 996
Total cold run time: 53362 ms
Total hot run time: 51465 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566364854
# FE Regression Coverage Report
Increment line coverage ` 77.78% (14/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565483063
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572313231
<details>
<summary>TPC-H: <b>Total hot run time: 35754 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 400017aef5f4fc75d75e289c44184ed9887e3786, data reload: false
------ Round 1 ----------------------------------
q1 17578 5075 4994 4994
q2 2018 336 208 208
q3 10240 1335 740 740
q4 10234 952 378 378
q5 7542 2423 2347 2347
q6 181 168 138 138
q7 920 778 625 625
q8 9370 1322 1124 1124
q9 7048 5274 5318 5274
q10 6879 2230 1828 1828
q11 497 305 288 288
q12 345 365 229 229
q13 17793 3645 3070 3070
q14 236 244 212 212
q15 585 521 515 515
q16 1025 1002 965 965
q17 590 890 359 359
q18 7500 7435 7614 7435
q19 1312 988 585 585
q20 382 358 246 246
q21 4418 3802 3147 3147
q22 1111 1070 1047 1047
Total cold run time: 107804 ms
Total hot run time: 35754 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5231 5183 5194 5183
q2 349 397 320 320
q3 2395 2877 2463 2463
q4 1459 1909 1451 1451
q5 4605 4468 4549 4468
q6 203 167 126 126
q7 2016 1995 1805 1805
q8 2651 2992 2583 2583
q9 7496 7524 7391 7391
q10 2873 3120 2689 2689
q11 560 497 481 481
q12 650 714 568 568
q13 3249 3641 3029 3029
q14 281 290 254 254
q15 533 508 493 493
q16 1025 1058 1022 1022
q17 1087 1393 1318 1318
q18 7221 7173 7003 7003
q19 765 802 883 802
q20 1918 1959 1813 1813
q21 4778 4403 4320 4320
q22 1080 1041 1006 1006
Total cold run time: 52425 ms
Total hot run time: 50588 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3522369661
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521181253
Resolve formatting issues and remember to link your function doc and issue(`Issue Number: #xxxxx`) in pr description
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3551595807
# BE UT Coverage Report
Increment line coverage `100.00% (10/10)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/6004f83144bf54d4a0fcc92fc0d0a69164ede5de_6004f83144bf54d4a0fcc92fc0d0a69164ede5de/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/6004f83144bf54d4a0fcc92fc0d0a69164ede5de_6004f83144bf54d4a0fcc92fc0d0a69164ede5de/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.74% (18279/34659) |
| Line Coverage | 38.10% (166077/435843) |
| Region Coverage | 33.03% (129085/390837) |
| Branch Coverage | 33.81% (55401/163845) |
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563817401
<details>
<summary>TPC-DS: <b>Total hot run time: 187853 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 1b4dee7d8e8e582813a843d9acddf72ff86782d5, data reload: false
query1 1031 436 389 389
query2 6551 1692 1651 1651
query3 6749 225 220 220
query4 25908 23346 23408 23346
query5 4399 620 464 464
query6 341 247 243 243
query7 4660 487 308 308
query8 306 265 253 253
query9 8704 2554 2593 2554
query10 503 342 297 297
query11 15939 15032 14734 14734
query12 170 117 114 114
query13 1696 583 474 474
query14 11009 9185 9198 9185
query15 214 195 179 179
query16 7420 695 516 516
query17 1270 787 642 642
query18 2007 412 311 311
query19 196 199 170 170
query20 125 124 120 120
query21 217 139 114 114
query22 4007 4065 4076 4065
query23 33901 32785 32777 32777
query24 8540 2353 2400 2353
query25 588 535 443 443
query26 1239 272 160 160
query27 2769 502 357 357
query28 4351 2180 2184 2180
query29 813 609 476 476
query30 303 222 207 207
query31 883 807 704 704
query32 86 72 76 72
query33 603 374 344 344
query34 774 849 513 513
query35 824 822 736 736
query36 960 998 910 910
query37 127 112 81 81
query38 3489 3510 3500 3500
query39 1457 1425 1412 1412
query40 233 129 119 119
query41 68 64 64 64
query42 130 110 108 108
query43 480 516 455 455
query44 1218 765 763 763
query45 183 179 175 175
query46 894 992 635 635
query47 1724 1781 1716 1716
query48 386 420 315 315
query49 782 493 411 411
query50 687 679 406 406
query51 3863 3938 3895 3895
query52 114 110 108 108
query53 242 261 199 199
query54 306 292 270 270
query55 85 84 81 81
query56 326 332 300 300
query57 1185 1188 1113 1113
query58 281 279 271 271
query59 2518 2614 2608 2608
query60 361 337 334 334
query61 167 162 159 159
query62 792 688 659 659
query63 225 189 198 189
query64 4524 1169 877 877
query65 4049 3922 3936 3922
query66 1162 427 321 321
query67 15208 15172 15215 15172
query68 4173 968 642 642
query69 482 313 279 279
query70 1356 1284 1239 1239
query71 413 341 303 303
query72 5924 5288 5256 5256
query73 682 630 365 365
query74 8827 8822 8678 8678
query75 3265 3350 2822 2822
query76 3264 1155 764 764
query77 522 394 319 319
query78 10216 9773 8859 8859
query79 1700 794 595 595
query80 1647 579 510 510
query81 556 262 227 227
query82 398 158 133 133
query83 353 263 245 245
query84 249 118 91 91
query85 924 505 460 460
query86 380 301 318 301
query87 3669 3700 3634 3634
query88 2885 2276 2230 2230
query89 386 335 290 290
query90 1744 224 224 224
query91 170 171 139 139
query92 73 71 64 64
query93 1171 1045 687 687
query94 703 440 352 352
query95 405 328 324 324
query96 489 554 279 279
query97 2895 2944 2832 2832
query98 235 218 215 215
query99 1296 1401 1276 1276
Total cold run time: 268774 ms
Total hot run time: 187853 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565578264
<details>
<summary>TPC-DS: <b>Total hot run time: 186696 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 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
query1 1028 391 431 391
query2 6551 1700 1722 1700
query3 6770 232 220 220
query4 25770 23163 22723 22723
query5 4399 627 470 470
query6 319 257 220 220
query7 4661 498 301 301
query8 314 276 245 245
query9 8754 2581 2588 2581
query10 516 339 295 295
query11 15102 15063 14875 14875
query12 178 117 117 117
query13 1695 583 466 466
query14 10276 9161 9174 9161
query15 209 187 174 174
query16 7417 693 543 543
query17 1291 773 655 655
query18 2006 431 341 341
query19 210 210 185 185
query20 131 128 124 124
query21 215 154 115 115
query22 3931 4101 4071 4071
query23 33925 32999 33119 32999
query24 8493 2420 2399 2399
query25 640 543 480 480
query26 1240 283 167 167
query27 2746 502 361 361
query28 4365 2178 2162 2162
query29 853 671 517 517
query30 301 224 191 191
query31 908 788 721 721
query32 87 78 75 75
query33 619 399 353 353
query34 803 859 586 586
query35 778 836 731 731
query36 944 973 921 921
query37 117 112 86 86
query38 3475 3510 3437 3437
query39 1472 1420 1416 1416
query40 221 130 120 120
query41 66 60 61 60
query42 128 110 114 110
query43 493 495 452 452
query44 1243 758 774 758
query45 179 180 173 173
query46 908 993 644 644
query47 1735 1767 1709 1709
query48 406 420 322 322
query49 771 472 410 410
query50 658 678 404 404
query51 3840 3867 3811 3811
query52 111 110 103 103
query53 243 273 203 203
query54 310 296 280 280
query55 89 87 86 86
query56 338 367 305 305
query57 1194 1172 1117 1117
query58 292 278 272 272
query59 2495 2615 2507 2507
query60 341 350 344 344
query61 163 165 163 163
query62 772 699 658 658
query63 231 203 198 198
query64 4481 1184 874 874
query65 4004 3914 3939 3914
query66 1170 446 347 347
query67 15073 14897 14825 14825
query68 8423 954 628 628
query69 495 321 284 284
query70 1319 1262 1257 1257
query71 518 357 313 313
query72 5922 4913 4792 4792
query73 657 574 367 367
query74 8887 9101 8629 8629
query75 4066 3277 2824 2824
query76 3709 1124 734 734
query77 828 413 319 319
query78 9450 9564 8805 8805
query79 2032 843 599 599
query80 638 563 500 500
query81 504 263 222 222
query82 486 154 136 136
query83 267 252 257 252
query84 250 107 98 98
query85 924 489 441 441
query86 392 314 283 283
query87 3739 3667 3575 3575
query88 3889 2251 2243 2243
query89 399 324 293 293
query90 1955 221 222 221
query91 181 170 133 133
query92 84 66 62 62
query93 1765 985 684 684
query94 709 455 334 334
query95 412 325 317 317
query96 495 556 290 290
query97 2932 2935 2842 2842
query98 269 217 206 206
query99 1424 1429 1269 1269
Total cold run time: 273484 ms
Total hot run time: 186696 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] (enhanced) completed the function : century from duckdb [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565482775
Please submit a PR for `century` function document to the repository https://github.com/apache/doris-website, and link it in the description in this pr.
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565858136
# FE Regression Coverage Report
Increment line coverage ` 77.78% (14/18)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_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] (enhanced) completed the function : century from duckdb [doris]
Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3573453127
fixed
--
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] (enhanced) completed the function : century from duckdb [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3571854630
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