Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-06-10 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-06-10 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-06-10 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-05-26 Thread via GitHub


doris-robot commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2911053442

   
   
   ClickBench: Total hot run time: 30.4 s
   
   ```
   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.030.030.03
   query2   0.070.030.04
   query3   0.240.060.06
   query4   1.630.100.10
   query5   0.520.530.53
   query6   1.140.730.72
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.570.500.50
   query10  0.560.560.57
   query11  0.140.110.11
   query12  0.130.140.10
   query13  0.610.610.60
   query14  0.780.770.81
   query15  0.850.830.83
   query16  0.370.380.40
   query17  1.061.031.02
   query18  0.230.220.21
   query19  1.881.741.83
   query20  0.010.010.02
   query21  15.40   0.590.59
   query22  2.482.802.02
   query23  16.81   1.020.82
   query24  3.010.991.28
   query25  0.140.220.10
   query26  0.420.130.13
   query27  0.060.040.04
   query28  10.29   0.540.46
   query29  12.62   3.233.26
   query30  0.240.060.06
   query31  2.870.400.38
   query32  3.230.470.47
   query33  2.993.043.03
   query34  17.16   4.454.44
   query35  4.504.534.57
   query36  0.680.490.48
   query37  0.090.050.06
   query38  0.050.040.03
   query39  0.030.020.02
   query40  0.160.120.13
   query41  0.080.030.02
   query42  0.030.020.02
   query43  0.030.030.03
   Total cold run time: 104.25 s
   Total hot run time: 30.4 s
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-05-26 Thread via GitHub


doris-robot commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2911047438

   
   
   TPC-DS: Total hot run time: 195969 ms
   
   ```
   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   1286899 921 899
   query2   6369193818251825
   query3   10833   434741704170
   query4   61005   29218   23679   23679
   query5   5156457 458 457
   query6   409 166 195 166
   query7   5425300 300 300
   query8   293 226 227 226
   query9   8530258725642564
   query10  439 262 256 256
   query11  17794   15124   15820   15124
   query12  161 105 116 105
   query13  1444440 426 426
   query14  10410   668671516686
   query15  203 177 185 177
   query16  7087475 480 475
   query17  1178603 581 581
   query18  1924328 318 318
   query19  225 160 164 160
   query20  115 107 111 107
   query21  206 109 103 103
   query22  4992466848994668
   query23  34274   33553   33900   33553
   query24  6132296328652865
   query25  512 389 399 389
   query26  658 168 169 168
   query27  1930362 364 362
   query28  4018218321592159
   query29  686 450 427 427
   query30  236 162 161 161
   query31  1007819 825 819
   query32  65  58  55  55
   query33  479 288 298 288
   query34  919 507 505 505
   query35  872 753 717 717
   query36  1088942 953 942
   query37  108 67  78  67
   query38  4031399440353994
   query39  1492149814411441
   query40  194 104 104 104
   query41  53  47  45  45
   query42  115 108 109 108
   query43  523 476 481 476
   query44  1231805 806 805
   query45  184 167 170 167
   query46  1145729 740 729
   query47  2037192319251923
   query48  484 393 387 387
   query49  772 412 412 412
   query50  869 441 443 441
   query51  7370719673117196
   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  1284119911891189
   query58  242 233 228 228
   query59  3254311429622962
   query60  295 262 262 262
   query61  129 138 114 114
   query62  767 652 681 652
   query63  218 187 184 184
   query64  1350638 630 630
   query65  3265317032093170
   query66  702 289 301 289
   query67  15995   15615   15739   15615
   query68  4113598 593 593
   query69  423 263 272 263
   query70  1192112410621062
   query71  352 250 255 250
   query72  6368394240473942
   query73  762 352 361 352
   query74  10490   910789728972
   query75  3370269226432643
   query76  1966100510641005
   query77  478 274 268 268
   query78  10611   959996409599
   query79  1642602 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  4457422542304225
   query88  3784238523632363
   query89  401 292 293 292
   query90  1965185 187 185
   query91  182 147 150 147
   query92  63  52  50  50
   query93  2286558 557 557
   query94  765 290 295 290
   query95  360 258 254 254
   query96  614 279 281 279
   query97  3323320132033201
   query98  224 199 194 194
   query99  1573131212841284
   Total cold run time: 313039 ms
   Total hot run time: 195969 ms
   ```
   
   


-- 
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 t

Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-05-26 Thread via GitHub


doris-robot commented on PR #51275:
URL: https://github.com/apache/doris/pull/51275#issuecomment-2911033610

   
   
   TPC-H: Total hot run time: 40038 ms
   
   ```
   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   671065936593
   q2   2039171 176 171
   q3   10554   106011991060
   q4   10532   754 718 718
   q5   7728287228242824
   q6   219 140 131 131
   q7   999 615 618 615
   q8   9360191220141912
   q9   6687642764976427
   q10  7059226923192269
   q11  468 278 265 265
   q12  402 215 211 211
   q13  17925   299430152994
   q14  237 213 214 213
   q15  511 458 457 457
   q16  472 383 392 383
   q17  974 666 532 532
   q18  7269678967296729
   q19  1483109310771077
   q20  476 198 196 196
   q21  3966336832593259
   q22  1098100210091002
   Total cold run time: 108021 ms
   Total hot run time: 40038 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6691662066256620
   q2   338 234 238 234
   q3   3058294131632941
   q4   2153185818261826
   q5   6078610460236023
   q6   216 134 132 132
   q7   2355191418611861
   q8   3439357835583558
   q9   8993877088478770
   q10  3612351735103510
   q11  603 499 497 497
   q12  811 607 592 592
   q13  14981   307831573078
   q14  325 285 291 285
   q15  501 465 461 461
   q16  483 433 433 433
   q17  1845161116111611
   q18  8173783177487748
   q19  1713155515431543
   q20  2115188418031803
   q21  5365532553705325
   q22  1168105010131013
   Total cold run time: 75016 ms
   Total hot run time: 59864 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-05-26 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-05-26 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [feat](udf) support "prefer_udf_over_builtin" session variable #51195 [doris]

2025-05-26 Thread via GitHub


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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]