You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2025/05/27 03:23:28 UTC
[PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
github-actions[bot] opened a new pull request, #51275:
URL: https://github.com/apache/doris/pull/51275
Cherry-picked from #51195
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2961097482
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] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #51275:
URL: https://github.com/apache/doris/pull/51275
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2961097449
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] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #51275: branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195
URL: https://github.com/apache/doris/pull/51275
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2910987625
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2911033610
<details>
<summary>TPC-H: <b>Total hot run time: 40038 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 e72709e6b69d54ce85abc6e2ce9029d90c84e491, data reload: false
------ Round 1 ----------------------------------
q1 17563 6710 6593 6593
q2 2039 171 176 171
q3 10554 1060 1199 1060
q4 10532 754 718 718
q5 7728 2872 2824 2824
q6 219 140 131 131
q7 999 615 618 615
q8 9360 1912 2014 1912
q9 6687 6427 6497 6427
q10 7059 2269 2319 2269
q11 468 278 265 265
q12 402 215 211 211
q13 17925 2994 3015 2994
q14 237 213 214 213
q15 511 458 457 457
q16 472 383 392 383
q17 974 666 532 532
q18 7269 6789 6729 6729
q19 1483 1093 1077 1077
q20 476 198 196 196
q21 3966 3368 3259 3259
q22 1098 1002 1009 1002
Total cold run time: 108021 ms
Total hot run time: 40038 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6691 6620 6625 6620
q2 338 234 238 234
q3 3058 2941 3163 2941
q4 2153 1858 1826 1826
q5 6078 6104 6023 6023
q6 216 134 132 132
q7 2355 1914 1861 1861
q8 3439 3578 3558 3558
q9 8993 8770 8847 8770
q10 3612 3517 3510 3510
q11 603 499 497 497
q12 811 607 592 592
q13 14981 3078 3157 3078
q14 325 285 291 285
q15 501 465 461 461
q16 483 433 433 433
q17 1845 1611 1611 1611
q18 8173 7831 7748 7748
q19 1713 1555 1543 1543
q20 2115 1884 1803 1803
q21 5365 5325 5370 5325
q22 1168 1050 1013 1013
Total cold run time: 75016 ms
Total hot run time: 59864 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2910987566
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2911047438
<details>
<summary>TPC-DS: <b>Total hot run time: 195969 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 e72709e6b69d54ce85abc6e2ce9029d90c84e491, data reload: false
query1 1286 899 921 899
query2 6369 1938 1825 1825
query3 10833 4347 4170 4170
query4 61005 29218 23679 23679
query5 5156 457 458 457
query6 409 166 195 166
query7 5425 300 300 300
query8 293 226 227 226
query9 8530 2587 2564 2564
query10 439 262 256 256
query11 17794 15124 15820 15124
query12 161 105 116 105
query13 1444 440 426 426
query14 10410 6686 7151 6686
query15 203 177 185 177
query16 7087 475 480 475
query17 1178 603 581 581
query18 1924 328 318 318
query19 225 160 164 160
query20 115 107 111 107
query21 206 109 103 103
query22 4992 4668 4899 4668
query23 34274 33553 33900 33553
query24 6132 2963 2865 2865
query25 512 389 399 389
query26 658 168 169 168
query27 1930 362 364 362
query28 4018 2183 2159 2159
query29 686 450 427 427
query30 236 162 161 161
query31 1007 819 825 819
query32 65 58 55 55
query33 479 288 298 288
query34 919 507 505 505
query35 872 753 717 717
query36 1088 942 953 942
query37 108 67 78 67
query38 4031 3994 4035 3994
query39 1492 1498 1441 1441
query40 194 104 104 104
query41 53 47 45 45
query42 115 108 109 108
query43 523 476 481 476
query44 1231 805 806 805
query45 184 167 170 167
query46 1145 729 740 729
query47 2037 1923 1925 1923
query48 484 393 387 387
query49 772 412 412 412
query50 869 441 443 441
query51 7370 7196 7311 7196
query52 100 91 93 91
query53 262 185 191 185
query54 585 492 484 484
query55 87 88 79 79
query56 283 267 284 267
query57 1284 1199 1189 1189
query58 242 233 228 228
query59 3254 3114 2962 2962
query60 295 262 262 262
query61 129 138 114 114
query62 767 652 681 652
query63 218 187 184 184
query64 1350 638 630 630
query65 3265 3170 3209 3170
query66 702 289 301 289
query67 15995 15615 15739 15615
query68 4113 598 593 593
query69 423 263 272 263
query70 1192 1124 1062 1062
query71 352 250 255 250
query72 6368 3942 4047 3942
query73 762 352 361 352
query74 10490 9107 8972 8972
query75 3370 2692 2643 2643
query76 1966 1005 1064 1005
query77 478 274 268 268
query78 10611 9599 9640 9599
query79 1642 602 597 597
query80 979 430 440 430
query81 518 221 219 219
query82 177 87 86 86
query83 160 142 143 142
query84 279 83 82 82
query85 994 301 291 291
query86 382 274 309 274
query87 4457 4225 4230 4225
query88 3784 2385 2363 2363
query89 401 292 293 292
query90 1965 185 187 185
query91 182 147 150 147
query92 63 52 50 50
query93 2286 558 557 557
query94 765 290 295 290
query95 360 258 254 254
query96 614 279 281 279
query97 3323 3201 3203 3201
query98 224 199 194 194
query99 1573 1312 1284 1284
Total cold run time: 313039 ms
Total hot run time: 195969 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2911053442
<details>
<summary>ClickBench: <b>Total hot run time: 30.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 e72709e6b69d54ce85abc6e2ce9029d90c84e491, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.03 0.04
query3 0.24 0.06 0.06
query4 1.63 0.10 0.10
query5 0.52 0.53 0.53
query6 1.14 0.73 0.72
query7 0.02 0.02 0.01
query8 0.04 0.03 0.03
query9 0.57 0.50 0.50
query10 0.56 0.56 0.57
query11 0.14 0.11 0.11
query12 0.13 0.14 0.10
query13 0.61 0.61 0.60
query14 0.78 0.77 0.81
query15 0.85 0.83 0.83
query16 0.37 0.38 0.40
query17 1.06 1.03 1.02
query18 0.23 0.22 0.21
query19 1.88 1.74 1.83
query20 0.01 0.01 0.02
query21 15.40 0.59 0.59
query22 2.48 2.80 2.02
query23 16.81 1.02 0.82
query24 3.01 0.99 1.28
query25 0.14 0.22 0.10
query26 0.42 0.13 0.13
query27 0.06 0.04 0.04
query28 10.29 0.54 0.46
query29 12.62 3.23 3.26
query30 0.24 0.06 0.06
query31 2.87 0.40 0.38
query32 3.23 0.47 0.47
query33 2.99 3.04 3.03
query34 17.16 4.45 4.44
query35 4.50 4.53 4.57
query36 0.68 0.49 0.48
query37 0.09 0.05 0.06
query38 0.05 0.04 0.03
query39 0.03 0.02 0.02
query40 0.16 0.12 0.13
query41 0.08 0.03 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 104.25 s
Total hot run time: 30.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