You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "linrrzqqq (via GitHub)" <gi...@apache.org> on 2025/11/17 05:25:29 UTC
[PR] [Enhancement](ai) relax the matching of AI_FILTER [doris]
linrrzqqq opened a new pull request, #58077:
URL: https://github.com/apache/doris/pull/58077
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Function `AI_FILTER` can only match `0` or `1`, which may cause parsing errors due to the uncertainty of AI returned content, like `0\n` or `\t1 ` etc.
This pr trims whitespace in AI_FILTER, and supports `true/false`, `yes/no` for a more relax matching restriction.
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [x] 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?
- [x] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Enhancement](ai) relax the matching of AI_FILTER [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540040131
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3544745203
<details>
<summary>TPC-DS: <b>Total hot run time: 188012 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 8dae482f69100665bbb16ff1e2a03bafbcddbd45, data reload: false
query1 1032 434 398 398
query2 6575 1700 1631 1631
query3 6760 227 224 224
query4 26360 23655 23004 23004
query5 4391 644 522 522
query6 332 245 229 229
query7 4656 499 308 308
query8 300 265 242 242
query9 8673 2916 2882 2882
query10 475 345 302 302
query11 15940 14968 14743 14743
query12 184 133 120 120
query13 1673 565 458 458
query14 11059 9053 9098 9053
query15 196 193 178 178
query16 7510 652 486 486
query17 1216 753 614 614
query18 2011 416 321 321
query19 209 193 175 175
query20 133 125 127 125
query21 215 131 114 114
query22 3972 4136 4076 4076
query23 33849 32923 33128 32923
query24 8154 2346 2349 2346
query25 605 530 503 503
query26 1239 274 165 165
query27 2736 507 367 367
query28 4440 2257 2246 2246
query29 809 624 501 501
query30 299 228 193 193
query31 911 787 734 734
query32 95 83 81 81
query33 595 399 353 353
query34 779 837 519 519
query35 806 847 732 732
query36 932 1013 865 865
query37 130 114 93 93
query38 3564 3527 3482 3482
query39 1472 1416 1409 1409
query40 233 141 128 128
query41 62 60 59 59
query42 129 126 120 120
query43 476 483 457 457
query44 1226 802 791 791
query45 192 182 172 172
query46 897 993 640 640
query47 1778 1808 1739 1739
query48 407 444 326 326
query49 781 497 418 418
query50 642 684 408 408
query51 3901 3898 3910 3898
query52 124 118 115 115
query53 253 276 207 207
query54 335 315 328 315
query55 92 99 87 87
query56 347 332 352 332
query57 1210 1186 1118 1118
query58 304 293 290 290
query59 2522 2670 2544 2544
query60 381 386 357 357
query61 191 206 191 191
query62 781 716 664 664
query63 239 204 207 204
query64 4653 1315 1024 1024
query65 4034 3957 3937 3937
query66 1193 464 370 370
query67 15421 15128 14958 14958
query68 8223 954 650 650
query69 511 349 320 320
query70 1308 1288 1296 1288
query71 450 360 339 339
query72 6003 4977 4921 4921
query73 661 586 369 369
query74 9105 9053 8676 8676
query75 3521 3210 2758 2758
query76 3415 1125 713 713
query77 780 407 343 343
query78 9617 9599 8865 8865
query79 2983 802 608 608
query80 708 600 542 542
query81 515 264 228 228
query82 703 169 139 139
query83 267 271 241 241
query84 256 118 92 92
query85 971 506 474 474
query86 390 322 303 303
query87 3732 3693 3593 3593
query88 3799 2246 2216 2216
query89 398 324 289 289
query90 2010 238 215 215
query91 173 168 134 134
query92 98 86 74 74
query93 2642 1027 683 683
query94 698 445 339 339
query95 431 347 331 331
query96 481 584 279 279
query97 2943 2948 2886 2886
query98 247 220 219 219
query99 1343 1399 1299 1299
Total cold run time: 277473 ms
Total hot run time: 188012 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3544678768
run performance
--
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3541766184
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3544754688
<details>
<summary>ClickBench: <b>Total hot run time: 27.55 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 8dae482f69100665bbb16ff1e2a03bafbcddbd45, data reload: false
query1 0.05 0.04 0.05
query2 0.09 0.05 0.05
query3 0.26 0.08 0.08
query4 1.60 0.12 0.11
query5 0.27 0.25 0.26
query6 1.18 0.65 0.64
query7 0.04 0.03 0.03
query8 0.06 0.04 0.05
query9 0.58 0.52 0.52
query10 0.57 0.56 0.56
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.63 0.62 0.61
query14 1.00 1.00 0.99
query15 0.85 0.84 0.84
query16 0.39 0.38 0.41
query17 1.01 1.02 0.98
query18 0.21 0.20 0.20
query19 1.91 1.84 1.81
query20 0.02 0.01 0.02
query21 15.45 0.21 0.14
query22 4.97 0.07 0.05
query23 15.67 0.26 0.10
query24 2.44 0.55 0.89
query25 0.08 0.06 0.05
query26 0.14 0.13 0.15
query27 0.06 0.06 0.06
query28 4.58 1.15 0.96
query29 12.56 3.87 3.20
query30 0.28 0.13 0.12
query31 2.82 0.60 0.37
query32 3.22 0.55 0.47
query33 3.03 3.16 3.05
query34 15.74 5.16 4.51
query35 4.54 4.59 4.56
query36 0.69 0.51 0.49
query37 0.09 0.07 0.07
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.14 0.14
query41 0.09 0.04 0.03
query42 0.05 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 97.85 s
Total hot run time: 27.55 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] [Enhancement](ai) relax the matching restriction of AI_FILTER [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540256004
<details>
<summary>ClickBench: <b>Total hot run time: 27.13 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 db04f466d66ba4c1508d30e92f1b1eacd8e5d799, data reload: false
query1 0.06 0.05 0.04
query2 0.10 0.05 0.04
query3 0.25 0.09 0.09
query4 1.61 0.12 0.11
query5 0.27 0.26 0.26
query6 1.18 0.65 0.65
query7 0.03 0.03 0.03
query8 0.05 0.04 0.04
query9 0.57 0.53 0.52
query10 0.56 0.58 0.57
query11 0.16 0.12 0.11
query12 0.16 0.12 0.12
query13 0.63 0.60 0.60
query14 1.00 1.00 0.99
query15 0.84 0.83 0.83
query16 0.39 0.40 0.38
query17 0.99 1.01 1.02
query18 0.22 0.20 0.20
query19 1.92 1.79 1.73
query20 0.02 0.01 0.02
query21 15.47 0.21 0.13
query22 4.92 0.07 0.05
query23 15.67 0.26 0.10
query24 2.75 0.53 0.28
query25 0.06 0.07 0.07
query26 0.15 0.14 0.14
query27 0.06 0.06 0.05
query28 3.78 1.17 0.95
query29 12.56 3.76 3.18
query30 0.28 0.13 0.12
query31 2.81 0.57 0.38
query32 3.24 0.54 0.47
query33 3.01 3.04 3.15
query34 15.87 5.14 4.51
query35 4.54 4.52 4.51
query36 0.66 0.50 0.48
query37 0.10 0.07 0.06
query38 0.06 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.13
query41 0.09 0.02 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 97.38 s
Total hot run time: 27.13 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540476562
<details>
<summary>TPC-DS: <b>Total hot run time: 188823 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 8dae482f69100665bbb16ff1e2a03bafbcddbd45, data reload: false
query1 1008 408 425 408
query2 6546 1681 1653 1653
query3 6756 244 231 231
query4 26426 23592 23546 23546
query5 4429 651 526 526
query6 350 237 225 225
query7 4645 497 314 314
query8 320 279 252 252
query9 8667 2939 2931 2931
query10 478 368 309 309
query11 15500 14970 14829 14829
query12 183 133 122 122
query13 1684 593 466 466
query14 10272 9171 9159 9159
query15 205 195 176 176
query16 7426 660 500 500
query17 1265 801 659 659
query18 2019 432 368 368
query19 221 210 191 191
query20 135 127 128 127
query21 224 136 119 119
query22 3962 4092 3992 3992
query23 33801 32853 32837 32837
query24 8103 2431 2365 2365
query25 633 524 454 454
query26 1240 271 165 165
query27 2745 504 359 359
query28 4438 2262 2248 2248
query29 818 647 496 496
query30 300 225 198 198
query31 884 804 697 697
query32 96 82 78 78
query33 584 388 347 347
query34 780 890 514 514
query35 818 841 754 754
query36 940 1013 884 884
query37 129 113 93 93
query38 3517 3482 3454 3454
query39 1437 1405 1403 1403
query40 232 131 120 120
query41 62 62 60 60
query42 132 115 117 115
query43 464 486 452 452
query44 1296 796 784 784
query45 190 182 173 173
query46 888 989 653 653
query47 1768 1771 1735 1735
query48 387 424 333 333
query49 761 505 424 424
query50 644 675 410 410
query51 3887 3886 3846 3846
query52 118 118 108 108
query53 251 285 208 208
query54 329 316 312 312
query55 97 96 95 95
query56 353 343 350 343
query57 1179 1192 1128 1128
query58 299 300 289 289
query59 2569 2595 2516 2516
query60 367 374 358 358
query61 165 159 150 150
query62 794 732 657 657
query63 227 198 207 198
query64 4520 1197 875 875
query65 4018 3940 3942 3940
query66 1172 455 368 368
query67 15247 15087 14859 14859
query68 4936 956 635 635
query69 512 340 298 298
query70 1296 1301 1301 1301
query71 431 349 331 331
query72 5782 4977 4977 4977
query73 662 601 372 372
query74 8884 9158 8937 8937
query75 3258 3265 2832 2832
query76 3276 1119 730 730
query77 522 407 342 342
query78 9495 9741 8930 8930
query79 978 850 609 609
query80 1249 619 561 561
query81 549 256 226 226
query82 377 178 141 141
query83 360 262 249 249
query84 253 111 100 100
query85 922 490 450 450
query86 392 306 299 299
query87 3755 3718 3529 3529
query88 2817 2247 2246 2246
query89 371 337 300 300
query90 1748 239 233 233
query91 175 165 134 134
query92 81 81 76 76
query93 1097 986 686 686
query94 687 433 344 344
query95 428 342 341 341
query96 477 610 280 280
query97 2885 2983 2871 2871
query98 248 223 217 217
query99 1318 1393 1288 1288
Total cold run time: 266621 ms
Total hot run time: 188823 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540315053
<details>
<summary>TPC-H: <b>Total hot run time: 34522 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 d82b92fb8edcdde515fcf586b566324556e09e09, data reload: false
------ Round 1 ----------------------------------
q1 17607 5267 5244 5244
q2 2083 336 218 218
q3 10158 1282 733 733
q4 10204 816 354 354
q5 7556 2397 2302 2302
q6 183 173 141 141
q7 960 757 622 622
q8 9346 1365 1100 1100
q9 6898 5161 5162 5161
q10 6813 2230 1809 1809
q11 493 324 280 280
q12 336 393 231 231
q13 17755 3658 3004 3004
q14 235 228 214 214
q15 571 506 504 504
q16 1046 996 936 936
q17 587 886 360 360
q18 7398 7271 7218 7218
q19 1100 980 549 549
q20 350 357 248 248
q21 4149 3201 2294 2294
q22 1065 1046 1000 1000
Total cold run time: 106893 ms
Total hot run time: 34522 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5113 5300 5069 5069
q2 243 319 253 253
q3 2202 2668 2262 2262
q4 1331 1767 1342 1342
q5 4184 4445 4622 4445
q6 215 172 132 132
q7 2049 2036 1836 1836
q8 2612 2580 2564 2564
q9 7394 7272 7323 7272
q10 3068 3335 2863 2863
q11 577 513 546 513
q12 696 773 657 657
q13 3533 3913 3275 3275
q14 311 322 307 307
q15 549 504 508 504
q16 1070 1099 1062 1062
q17 1166 1530 1460 1460
q18 7987 7719 7637 7637
q19 818 855 898 855
q20 2002 2032 1920 1920
q21 4982 4331 4354 4331
q22 1091 1056 1002 1002
Total cold run time: 53193 ms
Total hot run time: 51561 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3544720509
<details>
<summary>TPC-H: <b>Total hot run time: 33858 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 8dae482f69100665bbb16ff1e2a03bafbcddbd45, data reload: false
------ Round 1 ----------------------------------
q1 17628 5117 4978 4978
q2 2067 354 199 199
q3 10181 1297 716 716
q4 10222 891 363 363
q5 7462 2444 2294 2294
q6 182 167 135 135
q7 926 753 623 623
q8 9334 1557 1078 1078
q9 6951 5181 5056 5056
q10 6853 2226 1821 1821
q11 477 306 278 278
q12 328 372 239 239
q13 17792 3645 3067 3067
q14 222 225 217 217
q15 573 509 501 501
q16 1045 1008 922 922
q17 576 922 373 373
q18 7827 7034 7031 7031
q19 1099 955 539 539
q20 348 360 231 231
q21 4055 2536 2229 2229
q22 1065 1034 968 968
Total cold run time: 107213 ms
Total hot run time: 33858 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5052 5065 5034 5034
q2 255 325 227 227
q3 2151 2678 2266 2266
q4 1340 1746 1356 1356
q5 4186 4349 4646 4349
q6 214 172 129 129
q7 2013 2002 1863 1863
q8 2609 2578 2672 2578
q9 7329 7313 7380 7313
q10 2994 3237 2854 2854
q11 598 516 546 516
q12 707 738 638 638
q13 3640 3921 3323 3323
q14 311 326 273 273
q15 536 495 510 495
q16 1042 1138 1058 1058
q17 1158 1547 1368 1368
q18 8008 7620 7599 7599
q19 808 821 825 821
q20 2096 2065 1988 1988
q21 4939 4348 4342 4342
q22 1090 1025 1034 1025
Total cold run time: 53076 ms
Total hot run time: 51415 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540343029
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540437660
<details>
<summary>TPC-H: <b>Total hot run time: 34355 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 8dae482f69100665bbb16ff1e2a03bafbcddbd45, data reload: false
------ Round 1 ----------------------------------
q1 17598 5124 4974 4974
q2 2031 337 203 203
q3 10222 1267 701 701
q4 10375 930 371 371
q5 7584 2401 2338 2338
q6 179 166 132 132
q7 901 751 614 614
q8 9343 1362 1077 1077
q9 6922 5156 5188 5156
q10 6865 2234 1796 1796
q11 496 295 284 284
q12 333 356 226 226
q13 17776 3625 2987 2987
q14 232 237 212 212
q15 581 533 491 491
q16 1018 988 935 935
q17 589 853 355 355
q18 7310 7267 7602 7267
q19 1468 1004 566 566
q20 379 349 238 238
q21 4012 3394 2373 2373
q22 1132 1063 1059 1059
Total cold run time: 107346 ms
Total hot run time: 34355 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5367 5337 5239 5239
q2 253 331 254 254
q3 2322 2829 2423 2423
q4 1411 1865 1404 1404
q5 4551 4437 4373 4373
q6 213 179 128 128
q7 2012 1985 1802 1802
q8 2569 2695 2627 2627
q9 7059 7549 7175 7175
q10 3025 3137 2655 2655
q11 552 498 497 497
q12 647 707 577 577
q13 3200 3626 3026 3026
q14 272 287 272 272
q15 527 490 484 484
q16 996 1088 989 989
q17 1074 1424 1321 1321
q18 7155 7109 7135 7109
q19 733 709 716 709
q20 1928 1954 1881 1881
q21 4551 4401 4328 4328
q22 1085 1044 1001 1001
Total cold run time: 51502 ms
Total hot run time: 50274 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #58077:
URL: https://github.com/apache/doris/pull/58077
--
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3542081586
# BE UT Coverage Report
Increment line coverage `90.32% (28/31)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/8dae482f69100665bbb16ff1e2a03bafbcddbd45_8dae482f69100665bbb16ff1e2a03bafbcddbd45/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/8dae482f69100665bbb16ff1e2a03bafbcddbd45_8dae482f69100665bbb16ff1e2a03bafbcddbd45/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.75% (18277/34646) |
| Line Coverage | 38.12% (166131/435754) |
| Region Coverage | 33.10% (129234/390383) |
| Branch Coverage | 33.84% (55411/163761) |
--
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3542436073
# BE Regression && UT Coverage Report
Increment line coverage `47.06% (8/17)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.47% (24334/34046) |
| Line Coverage | 57.96% (252955/436415) |
| Region Coverage | 53.22% (210693/395881) |
| Branch Coverage | 54.55% (89913/164832) |
--
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540868253
# BE Regression && UT Coverage Report
Increment line coverage `47.06% (8/17)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.47% (24333/34046) |
| Line Coverage | 57.96% (252949/436415) |
| Region Coverage | 53.23% (210740/395881) |
| Branch Coverage | 54.55% (89920/164832) |
--
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3542117922
# BE Regression && UT Coverage Report
Increment line coverage `47.06% (8/17)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.47% (24333/34046) |
| Line Coverage | 57.96% (252954/436415) |
| Region Coverage | 53.23% (210744/395881) |
| Branch Coverage | 54.55% (89922/164832) |
--
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] [Enhancement](ai) relax the matching of AI_FILTER [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540046374
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] [Enhancement](ai) relax the matching of AI_FILTER [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540214492
<details>
<summary>TPC-H: <b>Total hot run time: 35164 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 db04f466d66ba4c1508d30e92f1b1eacd8e5d799, data reload: false
------ Round 1 ----------------------------------
q1 17630 5231 5013 5013
q2 2036 315 201 201
q3 10237 1308 732 732
q4 10232 986 358 358
q5 7501 2405 2376 2376
q6 200 168 137 137
q7 925 769 638 638
q8 9358 1360 1198 1198
q9 6982 5109 5217 5109
q10 6941 2227 1790 1790
q11 503 299 278 278
q12 375 367 244 244
q13 17815 3645 3028 3028
q14 232 229 221 221
q15 598 514 515 514
q16 1006 1006 939 939
q17 602 873 371 371
q18 7882 7624 8192 7624
q19 1138 992 560 560
q20 387 368 233 233
q21 4462 3440 2447 2447
q22 1154 1153 1175 1153
Total cold run time: 108196 ms
Total hot run time: 35164 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5320 5198 5460 5198
q2 250 344 241 241
q3 2289 2755 2482 2482
q4 1434 1958 1498 1498
q5 4581 4471 4432 4432
q6 201 166 131 131
q7 1937 2027 1820 1820
q8 2615 2503 2714 2503
q9 7336 7301 7300 7300
q10 3056 3345 2844 2844
q11 596 546 490 490
q12 702 760 611 611
q13 3558 3787 3056 3056
q14 294 280 256 256
q15 521 476 482 476
q16 1013 1041 995 995
q17 1114 1480 1360 1360
q18 7164 7207 6899 6899
q19 778 770 845 770
q20 1883 1975 1788 1788
q21 4674 4394 4239 4239
q22 1105 1009 1013 1009
Total cold run time: 52421 ms
Total hot run time: 50398 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540564749
# BE UT Coverage Report
Increment line coverage `90.32% (28/31)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/8dae482f69100665bbb16ff1e2a03bafbcddbd45_8dae482f69100665bbb16ff1e2a03bafbcddbd45/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/8dae482f69100665bbb16ff1e2a03bafbcddbd45_8dae482f69100665bbb16ff1e2a03bafbcddbd45/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.75% (18277/34646) |
| Line Coverage | 38.13% (166134/435754) |
| Region Coverage | 33.08% (129121/390383) |
| Branch Coverage | 33.84% (55418/163761) |
--
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] [Enhancement](ai) relax the matching restriction of AI_FILTER [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540244314
<details>
<summary>TPC-DS: <b>Total hot run time: 189119 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 db04f466d66ba4c1508d30e92f1b1eacd8e5d799, data reload: false
query1 1050 398 386 386
query2 6600 1699 1712 1699
query3 6754 226 224 224
query4 26632 23634 23492 23492
query5 4819 653 536 536
query6 361 253 234 234
query7 4657 504 320 320
query8 311 271 257 257
query9 8641 2985 2969 2969
query10 539 349 321 321
query11 15927 15167 14752 14752
query12 197 130 122 122
query13 1681 582 469 469
query14 11604 9192 9158 9158
query15 207 195 170 170
query16 7699 694 512 512
query17 1493 792 649 649
query18 2047 431 349 349
query19 224 208 182 182
query20 137 128 128 128
query21 222 172 119 119
query22 4093 4062 4186 4062
query23 33724 33085 32955 32955
query24 8104 2451 2376 2376
query25 603 499 455 455
query26 1255 279 170 170
query27 2721 495 356 356
query28 4399 2281 2253 2253
query29 793 664 500 500
query30 310 226 197 197
query31 931 805 707 707
query32 97 83 78 78
query33 595 416 351 351
query34 797 852 516 516
query35 817 854 757 757
query36 957 989 906 906
query37 129 121 100 100
query38 3487 3498 3454 3454
query39 1459 1392 1416 1392
query40 231 141 132 132
query41 64 61 62 61
query42 134 122 116 116
query43 481 478 471 471
query44 1253 807 790 790
query45 187 182 174 174
query46 896 991 646 646
query47 1762 1789 1774 1774
query48 412 423 322 322
query49 768 490 426 426
query50 655 680 399 399
query51 3876 4097 3998 3998
query52 118 116 106 106
query53 245 279 216 216
query54 326 311 294 294
query55 96 97 92 92
query56 350 342 353 342
query57 1189 1196 1139 1139
query58 299 292 281 281
query59 2591 2668 2605 2605
query60 370 362 343 343
query61 166 160 151 151
query62 818 717 693 693
query63 245 197 199 197
query64 4389 1186 877 877
query65 4066 3924 3931 3924
query66 1101 448 351 351
query67 15394 15239 15061 15061
query68 8317 935 639 639
query69 496 334 297 297
query70 1244 1338 1156 1156
query71 450 353 330 330
query72 5403 4883 5059 4883
query73 650 555 365 365
query74 8939 9111 8961 8961
query75 3253 3235 2773 2773
query76 3304 1130 732 732
query77 532 414 340 340
query78 9598 9667 8913 8913
query79 2249 805 612 612
query80 739 606 522 522
query81 514 268 232 232
query82 457 167 135 135
query83 265 265 248 248
query84 255 111 90 90
query85 918 484 444 444
query86 364 318 301 301
query87 3638 3694 3525 3525
query88 2833 2260 2251 2251
query89 374 335 301 301
query90 1814 238 222 222
query91 165 171 134 134
query92 80 82 76 76
query93 1201 1021 697 697
query94 669 423 332 332
query95 425 341 337 337
query96 490 609 283 283
query97 2858 2977 2846 2846
query98 246 222 223 222
query99 1318 1426 1306 1306
Total cold run time: 273613 ms
Total hot run time: 189119 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] [Enhancement](ai) relax the matching restriction of AI_FILTER [doris]
Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540260950
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3540495984
<details>
<summary>ClickBench: <b>Total hot run time: 27.61 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 8dae482f69100665bbb16ff1e2a03bafbcddbd45, data reload: false
query1 0.06 0.05 0.06
query2 0.09 0.05 0.05
query3 0.25 0.08 0.08
query4 1.61 0.11 0.11
query5 0.26 0.25 0.25
query6 1.16 0.67 0.64
query7 0.03 0.03 0.03
query8 0.05 0.05 0.04
query9 0.59 0.52 0.51
query10 0.58 0.57 0.58
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.61 0.60 0.60
query14 1.00 0.99 1.00
query15 0.85 0.82 0.84
query16 0.39 0.38 0.39
query17 1.01 1.04 1.03
query18 0.22 0.20 0.20
query19 1.89 1.84 1.78
query20 0.01 0.01 0.02
query21 15.46 0.22 0.13
query22 4.86 0.07 0.04
query23 15.67 0.26 0.10
query24 2.89 0.99 0.46
query25 0.06 0.06 0.05
query26 0.14 0.13 0.13
query27 0.05 0.05 0.06
query28 4.92 1.14 0.95
query29 12.59 3.94 3.34
query30 0.28 0.13 0.13
query31 2.82 0.58 0.38
query32 3.23 0.55 0.47
query33 3.11 3.13 3.07
query34 15.63 5.12 4.58
query35 4.60 4.53 4.58
query36 0.67 0.50 0.49
query37 0.09 0.07 0.06
query38 0.07 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.14 0.13
query41 0.09 0.03 0.04
query42 0.04 0.02 0.02
query43 0.04 0.04 0.03
Total cold run time: 98.46 s
Total hot run time: 27.61 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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3541146994
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3541147157
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] [Enhancement](ai) relax the matching restriction of some AI-Functions [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58077:
URL: https://github.com/apache/doris/pull/58077#issuecomment-3542535868
# BE Regression && UT Coverage Report
Increment line coverage `47.06% (8/17)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58077_8dae482f69100665bbb16ff1e2a03bafbcddbd45_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 71.47% (24334/34046) |
| Line Coverage | 57.96% (252939/436415) |
| Region Coverage | 53.23% (210739/395881) |
| Branch Coverage | 54.54% (89903/164832) |
--
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