You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "LiBinfeng-01 (via GitHub)" <gi...@apache.org> on 2024/09/05 10:41:28 UTC
[PR] [Feat](Nereids) support string functions fold constant by fe [doris]
LiBinfeng-01 opened a new pull request, #40441:
URL: https://github.com/apache/doris/pull/40441
support string functions fold constant by fe:
Concat, Substring, Length, Lower, Upper, Trim, Ltrim, Rtrim, Replace, Left, Right, Locate,
Instr, Ascii, Bin, Hex, Unhex, ConcatWs, Char, CharacterLength, Initcap, Md5, Md5Sum,
JsonExtract, JsonbExtractString, Field, FindInSet, Repeat, Reverse, Space, SplitByChar,
SplitByString, SplitPart, SubstringIndex, Strcmp, StrLeft, StrRight, Overlay, ParseUrl,
UrlDecode, AppendTrailingCharIfAbsent, EndsWith, ExtractUrlParameter, Quote, ToBase64, ReplaceEmpty, Password
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337631395
<details>
<summary>TPC-H: <b>Total hot run time: 37997 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 d6184aa3608a3589aab38b39f82fd670d256aaa7, data reload: false
------ Round 1 ----------------------------------
q1 17633 4345 4367 4345
q2 2034 194 180 180
q3 11756 985 1075 985
q4 10513 726 668 668
q5 7731 2858 2815 2815
q6 222 137 136 136
q7 964 619 609 609
q8 9502 2069 2023 2023
q9 7210 6506 6530 6506
q10 6989 2208 2215 2208
q11 465 261 237 237
q12 388 227 234 227
q13 18992 3041 3083 3041
q14 273 234 242 234
q15 536 497 474 474
q16 530 430 427 427
q17 976 710 677 677
q18 7313 6840 6901 6840
q19 1390 1090 1127 1090
q20 666 331 334 331
q21 4002 2934 3065 2934
q22 1128 1010 1015 1010
Total cold run time: 111213 ms
Total hot run time: 37997 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4412 4274 4272 4272
q2 392 271 261 261
q3 2848 2635 2669 2635
q4 1958 1643 1652 1643
q5 5705 5693 5777 5693
q6 231 139 137 137
q7 2184 1836 1803 1803
q8 3257 3445 3461 3445
q9 8865 8802 8763 8763
q10 3626 3409 3319 3319
q11 597 510 513 510
q12 822 655 652 652
q13 13429 3250 3331 3250
q14 339 300 288 288
q15 531 509 483 483
q16 576 494 515 494
q17 1838 1519 1540 1519
q18 8110 7829 7909 7829
q19 1727 1542 1566 1542
q20 2220 1879 1903 1879
q21 5788 5394 5424 5394
q22 1131 1011 1037 1011
Total cold run time: 70586 ms
Total hot run time: 56822 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339617245
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337055406
<details>
<summary>TPC-DS: <b>Total hot run time: 191376 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 54275d49f7d10ca215ab7a109cdd22246ffd24af, data reload: false
query1 1232 900 869 869
query2 6472 1872 1867 1867
query3 10589 4099 3958 3958
query4 59489 25830 23328 23328
query5 5460 483 484 483
query6 395 158 161 158
query7 5871 292 287 287
query8 313 218 217 217
query9 9043 2481 2472 2472
query10 493 265 272 265
query11 17876 14889 15250 14889
query12 160 106 102 102
query13 1552 392 383 383
query14 11284 7327 7305 7305
query15 254 175 167 167
query16 7548 472 495 472
query17 1139 549 553 549
query18 2010 305 291 291
query19 291 144 142 142
query20 117 107 103 103
query21 207 101 101 101
query22 4797 4331 4683 4331
query23 34165 33272 33295 33272
query24 5898 2765 2846 2765
query25 529 373 381 373
query26 686 147 152 147
query27 1806 262 270 262
query28 3820 2008 2001 2001
query29 686 396 420 396
query30 237 148 150 148
query31 918 758 747 747
query32 81 51 54 51
query33 448 281 269 269
query34 860 460 455 455
query35 842 697 729 697
query36 1072 932 933 932
query37 144 84 79 79
query38 4003 3801 3836 3801
query39 1453 1409 1363 1363
query40 195 110 109 109
query41 45 46 44 44
query42 118 95 93 93
query43 495 483 452 452
query44 1074 752 719 719
query45 197 166 166 166
query46 1088 743 723 723
query47 1900 1778 1839 1778
query48 364 280 283 280
query49 763 460 431 431
query50 837 396 416 396
query51 7121 6806 6882 6806
query52 96 85 85 85
query53 261 178 179 178
query54 541 434 438 434
query55 74 76 74 74
query56 264 257 256 256
query57 1177 1049 1088 1049
query58 220 223 217 217
query59 2955 2879 2784 2784
query60 296 259 260 259
query61 98 101 99 99
query62 746 649 651 649
query63 210 183 182 182
query64 2874 664 651 651
query65 3209 3108 3097 3097
query66 671 335 333 333
query67 15289 15224 15224 15224
query68 2958 574 579 574
query69 397 260 269 260
query70 1127 1109 1074 1074
query71 345 263 267 263
query72 5193 3898 4197 3898
query73 738 314 319 314
query74 9159 8876 8758 8758
query75 3370 2682 2696 2682
query76 1381 978 1004 978
query77 537 319 342 319
query78 9708 9075 8981 8981
query79 1037 547 513 513
query80 695 510 513 510
query81 464 233 239 233
query82 240 142 143 142
query83 177 152 153 152
query84 260 76 78 76
query85 742 341 339 339
query86 320 314 298 298
query87 4328 4192 4317 4192
query88 3265 2273 2286 2273
query89 380 294 287 287
query90 1995 186 188 186
query91 132 110 109 109
query92 63 48 53 48
query93 1046 526 528 526
query94 742 306 297 297
query95 355 264 262 262
query96 583 269 261 261
query97 3187 3048 3049 3048
query98 224 209 203 203
query99 1544 1255 1269 1255
Total cold run time: 304110 ms
Total hot run time: 191376 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2340909591
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339865232
> I think you should check the result type too
we can not get return type before execution
FunctionSignature signature = new FunctionSignature(fnName, args, null, false);
the third parameter is return expression
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2331286425
<details>
<summary>TPC-DS: <b>Total hot run time: 192427 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 0145f57c013df6e8296ec89ca0919744e1056d22, data reload: false
query1 1263 901 895 895
query2 6347 1883 1848 1848
query3 10626 3903 3723 3723
query4 59537 23791 23314 23314
query5 5335 505 492 492
query6 396 164 187 164
query7 5780 304 290 290
query8 314 229 224 224
query9 9030 2499 2496 2496
query10 472 272 257 257
query11 18097 15138 15368 15138
query12 172 103 107 103
query13 1586 417 416 416
query14 10883 7331 7394 7331
query15 251 172 168 168
query16 7576 484 448 448
query17 1088 565 592 565
query18 2107 305 292 292
query19 298 148 151 148
query20 120 112 107 107
query21 206 105 106 105
query22 4727 4450 4558 4450
query23 34378 33429 33497 33429
query24 5930 2817 2859 2817
query25 524 387 365 365
query26 687 154 150 150
query27 1806 274 274 274
query28 3788 2067 2053 2053
query29 695 401 403 401
query30 232 152 155 152
query31 949 762 768 762
query32 83 50 49 49
query33 429 280 281 280
query34 882 481 471 471
query35 857 728 724 724
query36 1056 927 912 912
query37 153 88 93 88
query38 4002 3957 3869 3869
query39 1450 1392 1412 1392
query40 200 112 113 112
query41 49 46 45 45
query42 111 89 93 89
query43 517 473 459 459
query44 1108 773 738 738
query45 204 166 167 166
query46 1117 713 748 713
query47 1892 1783 1801 1783
query48 382 304 296 296
query49 766 432 444 432
query50 807 404 398 398
query51 6959 6824 6798 6798
query52 98 82 83 82
query53 245 178 182 178
query54 556 470 448 448
query55 78 75 73 73
query56 273 240 254 240
query57 1204 1072 1095 1072
query58 227 227 221 221
query59 3014 2904 2749 2749
query60 290 263 272 263
query61 103 98 102 98
query62 769 657 657 657
query63 217 182 215 182
query64 2861 679 661 661
query65 3228 3152 3159 3152
query66 685 324 339 324
query67 15228 15211 15268 15211
query68 2947 592 596 592
query69 405 268 280 268
query70 1178 1160 1133 1133
query71 343 276 281 276
query72 5262 3987 3934 3934
query73 755 321 326 321
query74 9290 8930 8812 8812
query75 3370 2702 2749 2702
query76 1418 1039 945 945
query77 552 329 326 326
query78 10030 9101 9031 9031
query79 1038 541 527 527
query80 669 498 505 498
query81 539 237 234 234
query82 252 150 143 143
query83 172 148 148 148
query84 256 77 78 77
query85 671 284 275 275
query86 321 286 300 286
query87 4549 4261 4229 4229
query88 2928 2393 2376 2376
query89 370 285 283 283
query90 1921 196 188 188
query91 121 98 100 98
query92 59 48 48 48
query93 1036 530 521 521
query94 706 308 373 308
query95 301 249 244 244
query96 589 270 270 270
query97 3192 3074 3096 3074
query98 212 194 201 194
query99 1549 1264 1266 1264
Total cold run time: 304301 ms
Total hot run time: 192427 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly merged PR #40441:
URL: https://github.com/apache/doris/pull/40441
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2336984296
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337018943
<details>
<summary>TPC-H: <b>Total hot run time: 38006 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 54275d49f7d10ca215ab7a109cdd22246ffd24af, data reload: false
------ Round 1 ----------------------------------
q1 17625 4472 4309 4309
q2 2024 207 184 184
q3 11844 952 1162 952
q4 10525 763 751 751
q5 7772 2843 2811 2811
q6 225 136 135 135
q7 961 621 605 605
q8 9316 2086 2065 2065
q9 7201 6506 6584 6506
q10 7003 2226 2242 2226
q11 478 234 240 234
q12 392 219 221 219
q13 18715 3083 3052 3052
q14 287 231 248 231
q15 540 492 487 487
q16 531 420 437 420
q17 975 708 681 681
q18 7344 6949 6762 6762
q19 1389 1122 1027 1027
q20 691 331 331 331
q21 3929 3126 3000 3000
q22 1156 1043 1018 1018
Total cold run time: 110923 ms
Total hot run time: 38006 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4346 4331 4258 4258
q2 391 281 267 267
q3 2915 2734 2650 2650
q4 1976 1686 1647 1647
q5 5672 5640 5770 5640
q6 233 140 142 140
q7 2177 1876 1809 1809
q8 3233 3473 3458 3458
q9 8775 8786 8807 8786
q10 3550 3383 3345 3345
q11 597 499 511 499
q12 833 698 653 653
q13 15157 3306 3253 3253
q14 324 293 297 293
q15 517 484 497 484
q16 545 516 486 486
q17 1837 1525 1516 1516
q18 8005 7664 7777 7664
q19 1700 1530 1539 1530
q20 2160 1902 1926 1902
q21 5779 5554 5591 5554
q22 1169 1070 1054 1054
Total cold run time: 71891 ms
Total hot run time: 56888 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342592129
<details>
<summary>TPC-H: <b>Total hot run time: 38190 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 8ad3460c9e129dc70f344421f6067eaa20d79f5e, data reload: false
------ Round 1 ----------------------------------
q1 17642 4347 4273 4273
q2 2020 183 174 174
q3 11585 978 1171 978
q4 10523 700 737 700
q5 7791 2839 2804 2804
q6 231 146 146 146
q7 960 634 613 613
q8 9338 2066 2027 2027
q9 7251 6557 6563 6557
q10 7012 2256 2276 2256
q11 463 256 248 248
q12 392 228 229 228
q13 18970 3070 3085 3070
q14 295 234 238 234
q15 529 483 481 481
q16 496 424 421 421
q17 986 694 691 691
q18 7387 6918 6917 6917
q19 1391 1035 1133 1035
q20 664 341 324 324
q21 4332 3060 2997 2997
q22 1087 1016 1018 1016
Total cold run time: 111345 ms
Total hot run time: 38190 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4358 4408 4301 4301
q2 378 267 267 267
q3 2858 2638 2658 2638
q4 1905 1696 1641 1641
q5 5647 5737 5767 5737
q6 233 138 148 138
q7 2206 1812 1820 1812
q8 3303 3487 3508 3487
q9 8879 8794 8766 8766
q10 3594 3437 3357 3357
q11 622 501 514 501
q12 826 693 680 680
q13 14904 3215 3300 3215
q14 327 289 285 285
q15 528 475 469 469
q16 574 480 495 480
q17 1873 1559 1537 1537
q18 8130 7809 7867 7809
q19 1702 1650 1608 1608
q20 2157 1932 1903 1903
q21 5812 5554 5480 5480
q22 1122 1050 1031 1031
Total cold run time: 71938 ms
Total hot run time: 57142 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2335032608
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337722667
<details>
<summary>TPC-H: <b>Total hot run time: 38226 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 e8aa9761e4355180b34e613090613a2bd34e1af5, data reload: false
------ Round 1 ----------------------------------
q1 17674 4468 4299 4299
q2 2021 193 190 190
q3 10614 1177 1160 1160
q4 10676 734 707 707
q5 8086 2928 2803 2803
q6 229 136 136 136
q7 966 632 601 601
q8 9682 2427 2090 2090
q9 9744 6707 6641 6641
q10 7052 2191 2194 2191
q11 467 247 246 246
q12 400 225 227 225
q13 17773 3094 3128 3094
q14 280 232 251 232
q15 542 495 489 489
q16 525 424 419 419
q17 972 696 648 648
q18 7550 6856 6878 6856
q19 1373 1016 1031 1016
q20 683 353 343 343
q21 5122 3159 2802 2802
q22 1161 1045 1038 1038
Total cold run time: 113592 ms
Total hot run time: 38226 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4448 4294 4237 4237
q2 384 261 279 261
q3 2880 2634 2653 2634
q4 1947 1753 1813 1753
q5 5731 5774 5637 5637
q6 228 134 134 134
q7 2247 1878 1793 1793
q8 3348 3477 3503 3477
q9 8889 8915 8740 8740
q10 3571 3409 3357 3357
q11 592 504 526 504
q12 842 642 654 642
q13 8017 3282 3270 3270
q14 334 298 305 298
q15 530 496 491 491
q16 551 491 485 485
q17 1835 1542 1546 1542
q18 8247 7994 7756 7756
q19 1743 1624 1512 1512
q20 2248 1979 1864 1864
q21 5687 5451 5436 5436
q22 1141 1116 1117 1116
Total cold run time: 65440 ms
Total hot run time: 56939 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337020204
run feut
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342960219
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2331296016
<details>
<summary>ClickBench: <b>Total hot run time: 31.91 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 0145f57c013df6e8296ec89ca0919744e1056d22, data reload: false
query1 0.05 0.05 0.04
query2 0.07 0.03 0.04
query3 0.23 0.05 0.05
query4 1.69 0.09 0.08
query5 0.50 0.49 0.50
query6 1.13 0.73 0.73
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.54 0.51 0.49
query10 0.54 0.55 0.55
query11 0.16 0.12 0.11
query12 0.15 0.13 0.12
query13 0.59 0.60 0.59
query14 2.03 2.06 2.05
query15 0.84 0.82 0.83
query16 0.38 0.37 0.38
query17 1.02 1.05 1.02
query18 0.20 0.19 0.20
query19 1.94 1.76 1.79
query20 0.01 0.01 0.01
query21 15.39 0.66 0.65
query22 4.41 7.47 1.83
query23 18.23 1.41 1.29
query24 2.04 0.23 0.22
query25 0.15 0.08 0.08
query26 0.28 0.18 0.18
query27 0.07 0.07 0.08
query28 13.22 1.01 1.00
query29 12.56 3.38 3.36
query30 0.24 0.05 0.05
query31 2.88 0.40 0.39
query32 3.27 0.49 0.48
query33 3.00 3.03 2.99
query34 17.04 4.34 4.37
query35 4.43 4.46 4.38
query36 0.67 0.48 0.47
query37 0.20 0.16 0.15
query38 0.16 0.14 0.16
query39 0.05 0.04 0.04
query40 0.16 0.13 0.12
query41 0.10 0.05 0.05
query42 0.06 0.04 0.04
query43 0.05 0.04 0.04
Total cold run time: 110.8 s
Total hot run time: 31.91 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337059614
<details>
<summary>ClickBench: <b>Total hot run time: 31.75 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 54275d49f7d10ca215ab7a109cdd22246ffd24af, data reload: false
query1 0.05 0.05 0.04
query2 0.08 0.04 0.04
query3 0.23 0.04 0.05
query4 1.68 0.08 0.08
query5 0.51 0.50 0.49
query6 1.12 0.72 0.72
query7 0.02 0.01 0.01
query8 0.05 0.05 0.05
query9 0.53 0.50 0.49
query10 0.54 0.55 0.56
query11 0.16 0.12 0.11
query12 0.15 0.13 0.12
query13 0.59 0.59 0.58
query14 1.38 1.42 1.38
query15 0.84 0.83 0.82
query16 0.38 0.35 0.38
query17 1.04 1.06 1.05
query18 0.21 0.20 0.20
query19 1.88 1.72 1.77
query20 0.01 0.01 0.01
query21 15.38 0.67 0.67
query22 3.78 6.90 2.36
query23 18.29 1.38 1.28
query24 2.19 0.22 0.22
query25 0.15 0.08 0.08
query26 0.27 0.17 0.19
query27 0.08 0.08 0.08
query28 13.19 1.01 0.99
query29 12.58 3.28 3.28
query30 0.26 0.05 0.06
query31 2.88 0.41 0.39
query32 3.24 0.48 0.48
query33 2.95 2.98 3.01
query34 17.01 4.36 4.36
query35 4.41 4.46 4.44
query36 0.66 0.48 0.48
query37 0.19 0.16 0.15
query38 0.15 0.14 0.15
query39 0.06 0.04 0.04
query40 0.16 0.13 0.13
query41 0.09 0.05 0.05
query42 0.06 0.04 0.05
query43 0.05 0.04 0.05
Total cold run time: 109.53 s
Total hot run time: 31.75 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337555355
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2336538621
<details>
<summary>ClickBench: <b>Total hot run time: 31.66 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 297acb4ad4d4198ec22b4f53f656d29d4992436d, data reload: false
query1 0.04 0.04 0.04
query2 0.10 0.05 0.04
query3 0.23 0.06 0.06
query4 1.67 0.09 0.09
query5 0.50 0.49 0.49
query6 1.13 0.73 0.72
query7 0.02 0.01 0.01
query8 0.06 0.04 0.05
query9 0.53 0.50 0.49
query10 0.54 0.56 0.56
query11 0.16 0.12 0.12
query12 0.16 0.13 0.12
query13 0.59 0.58 0.58
query14 1.43 1.45 1.47
query15 0.86 0.82 0.82
query16 0.37 0.37 0.36
query17 0.99 0.98 1.06
query18 0.21 0.20 0.19
query19 1.91 1.76 1.74
query20 0.01 0.00 0.01
query21 15.40 0.65 0.65
query22 4.31 6.94 2.23
query23 18.28 1.30 1.26
query24 2.08 0.22 0.22
query25 0.14 0.08 0.08
query26 0.27 0.19 0.17
query27 0.08 0.08 0.07
query28 13.27 1.02 1.00
query29 12.65 3.30 3.31
query30 0.24 0.05 0.06
query31 2.87 0.40 0.39
query32 3.28 0.48 0.47
query33 2.95 2.99 3.03
query34 16.89 4.39 4.40
query35 4.40 4.44 4.49
query36 0.65 0.47 0.47
query37 0.18 0.15 0.16
query38 0.16 0.15 0.15
query39 0.04 0.03 0.04
query40 0.15 0.13 0.13
query41 0.10 0.04 0.05
query42 0.06 0.04 0.04
query43 0.04 0.04 0.04
Total cold run time: 110 s
Total hot run time: 31.66 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337671866
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2340820771
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337660795
<details>
<summary>TPC-DS: <b>Total hot run time: 192624 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 d6184aa3608a3589aab38b39f82fd670d256aaa7, data reload: false
query1 1284 886 907 886
query2 6374 1938 1934 1934
query3 10585 3901 3708 3708
query4 59606 24078 23126 23126
query5 5400 502 515 502
query6 407 174 161 161
query7 5759 297 283 283
query8 333 219 216 216
query9 8881 2492 2481 2481
query10 475 272 258 258
query11 17803 14908 15167 14908
query12 156 105 110 105
query13 1551 383 391 383
query14 11109 7265 7203 7203
query15 246 170 175 170
query16 7561 461 445 445
query17 1137 566 560 560
query18 2067 302 304 302
query19 283 152 150 150
query20 122 112 124 112
query21 209 101 105 101
query22 4597 4510 4370 4370
query23 34353 33622 33591 33591
query24 5958 2846 2905 2846
query25 528 372 377 372
query26 689 157 147 147
query27 1805 268 270 268
query28 3797 2036 2015 2015
query29 686 405 402 402
query30 235 153 163 153
query31 935 764 785 764
query32 84 54 56 54
query33 419 285 280 280
query34 872 458 477 458
query35 834 718 709 709
query36 1044 938 918 918
query37 142 89 82 82
query38 3934 3895 3835 3835
query39 1452 1394 1413 1394
query40 200 118 117 117
query41 49 49 45 45
query42 118 94 98 94
query43 506 475 470 470
query44 1099 747 738 738
query45 203 163 166 163
query46 1088 722 734 722
query47 1946 1835 1852 1835
query48 372 296 290 290
query49 794 452 476 452
query50 846 414 407 407
query51 6983 6831 6902 6831
query52 100 87 97 87
query53 249 180 183 180
query54 565 459 466 459
query55 77 74 75 74
query56 285 267 268 267
query57 1222 1125 1110 1110
query58 234 238 233 233
query59 3051 3011 2955 2955
query60 302 282 280 280
query61 127 126 123 123
query62 734 649 656 649
query63 218 194 183 183
query64 3011 690 684 684
query65 3203 3115 3151 3115
query66 680 336 333 333
query67 15403 15316 15306 15306
query68 3045 586 569 569
query69 394 279 280 279
query70 1213 1153 1160 1153
query71 362 277 277 277
query72 6381 3994 4001 3994
query73 749 320 317 317
query74 9167 8806 8832 8806
query75 3355 2689 2735 2689
query76 1528 1033 955 955
query77 511 313 314 313
query78 9911 9423 9316 9316
query79 1026 539 523 523
query80 679 489 516 489
query81 533 231 234 231
query82 275 140 140 140
query83 172 149 147 147
query84 252 76 75 75
query85 690 293 276 276
query86 317 307 290 290
query87 4375 4355 4203 4203
query88 3036 2324 2267 2267
query89 380 278 282 278
query90 1965 188 187 187
query91 127 100 99 99
query92 58 53 52 52
query93 1051 527 527 527
query94 708 296 284 284
query95 342 247 246 246
query96 582 268 256 256
query97 3216 3108 3088 3088
query98 222 200 194 194
query99 1514 1250 1259 1250
Total cold run time: 305513 ms
Total hot run time: 192624 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2335027737
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2335045269
<details>
<summary>ClickBench: <b>Total hot run time: 32.23 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 18f4a35d6de1e227208fa40314e909fb5d9d292c, data reload: false
query1 0.05 0.05 0.04
query2 0.09 0.04 0.04
query3 0.24 0.06 0.06
query4 1.66 0.08 0.09
query5 0.51 0.48 0.50
query6 1.13 0.73 0.73
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.55 0.50 0.50
query10 0.55 0.56 0.53
query11 0.15 0.12 0.12
query12 0.15 0.14 0.12
query13 0.59 0.60 0.58
query14 1.41 1.42 1.45
query15 0.86 0.82 0.83
query16 0.37 0.38 0.37
query17 1.05 1.04 1.02
query18 0.21 0.20 0.20
query19 1.93 1.79 1.77
query20 0.01 0.00 0.01
query21 15.40 0.69 0.65
query22 4.14 6.35 2.75
query23 18.24 1.39 1.24
query24 2.15 0.21 0.22
query25 0.15 0.09 0.08
query26 0.27 0.18 0.18
query27 0.08 0.07 0.08
query28 13.26 1.01 1.00
query29 12.63 3.34 3.35
query30 0.24 0.05 0.06
query31 2.86 0.41 0.40
query32 3.25 0.47 0.48
query33 2.94 2.97 2.95
query34 17.25 4.41 4.43
query35 4.52 4.43 4.48
query36 0.66 0.49 0.50
query37 0.18 0.16 0.15
query38 0.15 0.15 0.14
query39 0.05 0.04 0.03
query40 0.15 0.13 0.13
query41 0.10 0.05 0.05
query42 0.06 0.04 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.36 s
Total hot run time: 32.23 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339851851
I think you should check the result type too
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342558716
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342602823
<details>
<summary>TPC-DS: <b>Total hot run time: 196649 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 8ad3460c9e129dc70f344421f6067eaa20d79f5e, data reload: false
query1 1257 881 883 881
query2 6356 1885 1952 1885
query3 10613 3987 3838 3838
query4 59322 29139 23316 23316
query5 5104 503 482 482
query6 384 160 162 160
query7 5615 309 296 296
query8 320 226 229 226
query9 7733 2487 2506 2487
query10 424 280 269 269
query11 17293 15079 15425 15079
query12 160 108 104 104
query13 1487 417 421 417
query14 10348 6885 7238 6885
query15 210 186 172 172
query16 6792 443 434 434
query17 1055 570 555 555
query18 1624 309 327 309
query19 189 150 146 146
query20 117 110 112 110
query21 214 104 107 104
query22 4652 4577 4685 4577
query23 34236 33543 33384 33384
query24 6018 2815 2860 2815
query25 485 388 390 388
query26 615 148 149 148
query27 1632 275 275 275
query28 3758 2022 2021 2021
query29 628 397 399 397
query30 229 157 156 156
query31 898 739 786 739
query32 71 51 54 51
query33 423 289 284 284
query34 862 473 463 463
query35 856 749 695 695
query36 1058 941 947 941
query37 135 83 82 82
query38 3986 3835 3869 3835
query39 1467 1405 1412 1405
query40 201 116 115 115
query41 51 48 42 42
query42 113 94 96 94
query43 510 491 483 483
query44 1059 756 742 742
query45 196 165 168 165
query46 1096 738 770 738
query47 1897 1783 1833 1783
query48 366 300 296 296
query49 781 444 455 444
query50 831 432 416 416
query51 7022 6886 6881 6881
query52 98 87 86 86
query53 254 184 179 179
query54 566 459 464 459
query55 76 75 76 75
query56 283 267 329 267
query57 1194 1072 1059 1059
query58 228 234 237 234
query59 3096 2747 2759 2747
query60 302 264 259 259
query61 101 103 104 103
query62 744 661 656 656
query63 214 188 181 181
query64 1316 721 687 687
query65 3240 3172 3128 3128
query66 668 350 346 346
query67 15652 15256 15355 15256
query68 2063 834 842 834
query69 452 316 319 316
query70 1234 1184 1133 1133
query71 341 340 333 333
query72 4617 3485 3495 3485
query73 592 568 577 568
query74 8953 8864 8807 8807
query75 3016 2907 2966 2907
query76 1008 832 822 822
query77 451 393 399 393
query78 9311 9160 9502 9160
query79 896 863 847 847
query80 830 796 775 775
query81 455 258 261 258
query82 266 263 268 263
query83 186 184 183 183
query84 203 105 103 103
query85 596 392 384 384
query86 325 314 311 311
query87 4276 4373 4341 4341
query88 4307 4126 4113 4113
query89 366 357 363 357
query90 829 306 305 305
query91 124 124 123 123
query92 75 78 75 75
query93 907 887 890 887
query94 390 362 345 345
query95 424 411 409 409
query96 468 467 471 467
query97 3089 3097 3089 3089
query98 231 231 222 222
query99 1309 1305 1302 1302
Total cold run time: 293371 ms
Total hot run time: 196649 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2336524136
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337672364
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 d6184aa3608a3589aab38b39f82fd670d256aaa7, data reload: false
query1 0.05 0.05 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.07 0.07
query5 0.51 0.49 0.49
query6 1.14 0.73 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.05
query9 0.54 0.50 0.50
query10 0.55 0.56 0.54
query11 0.15 0.11 0.12
query12 0.15 0.12 0.12
query13 0.61 0.62 0.58
query14 1.39 1.42 1.44
query15 0.84 0.83 0.82
query16 0.35 0.36 0.36
query17 0.94 1.00 1.02
query18 0.21 0.20 0.19
query19 1.79 1.73 1.84
query20 0.02 0.01 0.01
query21 15.43 0.67 0.67
query22 3.91 7.46 1.87
query23 18.22 1.31 1.33
query24 2.07 0.22 0.21
query25 0.16 0.09 0.08
query26 0.27 0.18 0.18
query27 0.08 0.07 0.08
query28 13.34 1.01 0.99
query29 12.63 3.37 3.31
query30 0.25 0.06 0.05
query31 2.87 0.39 0.39
query32 3.27 0.49 0.46
query33 2.95 3.01 3.02
query34 17.04 4.37 4.38
query35 4.41 4.44 4.47
query36 0.66 0.47 0.48
query37 0.18 0.15 0.15
query38 0.15 0.15 0.15
query39 0.05 0.04 0.04
query40 0.15 0.13 0.13
query41 0.10 0.05 0.04
query42 0.05 0.04 0.05
query43 0.04 0.05 0.04
Total cold run time: 109.57 s
Total hot run time: 31.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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2340980990
<details>
<summary>TPC-H: <b>Total hot run time: 38296 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 bcce3bec259015af12c39be2d070f32d2c00c6be, data reload: false
------ Round 1 ----------------------------------
q1 18307 4450 4357 4357
q2 2755 190 182 182
q3 12223 1127 1166 1127
q4 10712 762 744 744
q5 7775 2891 2763 2763
q6 233 138 135 135
q7 959 623 604 604
q8 9313 2073 2077 2073
q9 7139 6596 6568 6568
q10 7000 2211 2106 2106
q11 488 248 245 245
q12 390 216 218 216
q13 17913 3151 3087 3087
q14 280 231 249 231
q15 544 499 475 475
q16 516 430 416 416
q17 986 707 704 704
q18 7370 6880 6902 6880
q19 1385 1079 1083 1079
q20 697 333 338 333
q21 3840 2942 3056 2942
q22 1136 1029 1060 1029
Total cold run time: 111961 ms
Total hot run time: 38296 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4337 4282 4268 4268
q2 382 274 290 274
q3 2883 2662 2724 2662
q4 1926 1598 1639 1598
q5 5402 5390 5424 5390
q6 219 131 129 129
q7 2108 1760 1735 1735
q8 3210 3349 3360 3349
q9 8408 8475 8407 8407
q10 3484 3204 3198 3198
q11 587 512 514 512
q12 803 586 598 586
q13 9463 3120 3049 3049
q14 322 300 274 274
q15 533 486 495 486
q16 533 474 500 474
q17 1786 1531 1486 1486
q18 7737 7444 7359 7359
q19 1660 1592 1468 1468
q20 2057 1864 1814 1814
q21 5506 5203 5181 5181
q22 1155 1020 1029 1020
Total cold run time: 64501 ms
Total hot run time: 54719 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342727975
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339765289
run cloud_p0
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2341053758
<details>
<summary>ClickBench: <b>Total hot run time: 32.1 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 bcce3bec259015af12c39be2d070f32d2c00c6be, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.05 0.04
query3 0.22 0.05 0.05
query4 1.67 0.09 0.10
query5 0.50 0.49 0.48
query6 1.13 0.73 0.73
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.54 0.49 0.49
query10 0.52 0.56 0.54
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.59 0.59 0.59
query14 1.35 1.41 1.39
query15 0.88 0.82 0.82
query16 0.37 0.38 0.36
query17 1.04 0.99 1.01
query18 0.21 0.20 0.21
query19 1.94 1.71 1.76
query20 0.01 0.02 0.01
query21 15.39 0.66 0.66
query22 3.91 6.43 2.55
query23 18.31 1.35 1.27
query24 2.15 0.22 0.23
query25 0.15 0.07 0.08
query26 0.29 0.19 0.18
query27 0.07 0.08 0.08
query28 13.20 1.02 1.00
query29 12.63 3.38 3.35
query30 0.24 0.05 0.05
query31 2.87 0.40 0.39
query32 3.28 0.48 0.48
query33 3.00 3.00 3.02
query34 17.05 4.45 4.45
query35 4.51 4.50 4.50
query36 0.66 0.47 0.47
query37 0.18 0.15 0.15
query38 0.15 0.14 0.15
query39 0.05 0.04 0.03
query40 0.16 0.13 0.13
query41 0.10 0.05 0.04
query42 0.06 0.05 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.94 s
Total hot run time: 32.1 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337747312
<details>
<summary>TPC-DS: <b>Total hot run time: 192460 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 e8aa9761e4355180b34e613090613a2bd34e1af5, data reload: false
query1 1247 894 896 894
query2 6330 1914 1889 1889
query3 10722 4175 4028 4028
query4 58932 26882 23205 23205
query5 5370 497 512 497
query6 412 166 163 163
query7 5783 310 296 296
query8 313 215 220 215
query9 9129 2507 2508 2507
query10 492 282 271 271
query11 16701 15024 15397 15024
query12 162 102 116 102
query13 1585 410 371 371
query14 11215 7586 7175 7175
query15 237 183 174 174
query16 7274 497 528 497
query17 1183 585 578 578
query18 1990 303 301 301
query19 299 157 154 154
query20 123 109 110 109
query21 209 104 106 104
query22 4538 4423 4445 4423
query23 34461 33896 33510 33510
query24 5982 2843 2846 2843
query25 544 417 396 396
query26 689 162 158 158
query27 1765 277 282 277
query28 3808 2046 2028 2028
query29 686 428 419 419
query30 241 154 154 154
query31 924 793 789 789
query32 82 55 58 55
query33 434 285 292 285
query34 875 470 475 470
query35 838 729 714 714
query36 1060 939 948 939
query37 151 86 86 86
query38 3986 3876 3876 3876
query39 1439 1398 1398 1398
query40 193 114 116 114
query41 48 52 46 46
query42 122 98 98 98
query43 512 455 472 455
query44 1069 739 746 739
query45 202 170 164 164
query46 1082 751 713 713
query47 1973 1802 1818 1802
query48 361 288 297 288
query49 771 441 440 440
query50 798 409 420 409
query51 6983 6942 6807 6807
query52 99 85 84 84
query53 247 175 189 175
query54 565 436 456 436
query55 76 77 76 76
query56 272 254 241 241
query57 1214 1086 1055 1055
query58 218 236 223 223
query59 2939 2928 2851 2851
query60 295 262 262 262
query61 101 96 102 96
query62 750 640 644 640
query63 218 189 191 189
query64 2775 698 652 652
query65 3205 3114 3153 3114
query66 675 330 330 330
query67 15424 15058 15237 15058
query68 4442 585 557 557
query69 413 273 284 273
query70 1154 1113 1117 1113
query71 351 276 267 267
query72 6514 3931 4049 3931
query73 742 317 322 317
query74 9361 8817 8732 8732
query75 3360 2671 2681 2671
query76 1626 1085 1052 1052
query77 599 331 355 331
query78 10824 10276 9128 9128
query79 2170 542 537 537
query80 886 511 494 494
query81 570 233 226 226
query82 294 139 136 136
query83 223 148 147 147
query84 263 75 78 75
query85 730 284 315 284
query86 422 306 282 282
query87 4417 4276 4229 4229
query88 3888 2277 2278 2277
query89 381 282 287 282
query90 2027 194 187 187
query91 128 100 99 99
query92 62 49 51 49
query93 1481 548 548 548
query94 760 293 288 288
query95 345 261 261 261
query96 590 263 258 258
query97 3229 3083 3030 3030
query98 219 206 213 206
query99 1603 1262 1297 1262
Total cold run time: 309472 ms
Total hot run time: 192460 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2336997187
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339646123
<details>
<summary>TPC-H: <b>Total hot run time: 38626 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 1d6be61e9d7e74155cd7a5454af9cfe3e5cd5121, data reload: false
------ Round 1 ----------------------------------
q1 17914 4576 4448 4448
q2 2972 189 187 187
q3 12414 1157 1133 1133
q4 10795 775 832 775
q5 8026 2894 2781 2781
q6 233 142 146 142
q7 967 621 615 615
q8 9337 2080 2072 2072
q9 7446 6568 6580 6568
q10 7023 2270 2207 2207
q11 457 242 244 242
q12 396 230 227 227
q13 17786 3139 3101 3101
q14 282 243 243 243
q15 566 494 487 487
q16 514 429 427 427
q17 969 727 793 727
q18 7413 6861 6956 6861
q19 1396 1016 1038 1016
q20 697 329 340 329
q21 4008 3040 3025 3025
q22 1109 1013 1030 1013
Total cold run time: 112720 ms
Total hot run time: 38626 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4451 4338 4357 4338
q2 397 276 285 276
q3 2924 2625 2689 2625
q4 1951 1660 1673 1660
q5 5416 5418 5486 5418
q6 223 132 134 132
q7 2131 1731 1739 1731
q8 3219 3365 3334 3334
q9 8475 8485 8461 8461
q10 3491 3256 3237 3237
q11 586 523 512 512
q12 791 597 604 597
q13 13261 3121 3126 3121
q14 309 297 276 276
q15 540 488 474 474
q16 542 494 479 479
q17 1800 1520 1489 1489
q18 7850 7442 7460 7442
q19 1688 1561 1384 1384
q20 2068 1818 1820 1818
q21 5608 5348 5193 5193
q22 1125 1029 1028 1028
Total cold run time: 68846 ms
Total hot run time: 55025 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on code in PR #40441:
URL: https://github.com/apache/doris/pull/40441#discussion_r1751330214
##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/ExecFunction.java:
##########
@@ -43,4 +43,9 @@
* return type
*/
String returnType();
+
+ /**
+ * hasVarArgsc
+ */
+ boolean varArgs();
Review Comment:
```java
boolean varArgs() default false;
```
then you can skip to set varArgs to other functions
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2335043775
<details>
<summary>TPC-DS: <b>Total hot run time: 192562 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 18f4a35d6de1e227208fa40314e909fb5d9d292c, data reload: false
query1 1253 912 875 875
query2 6324 1924 1874 1874
query3 10736 4152 3904 3904
query4 59518 23948 23247 23247
query5 5382 496 495 495
query6 408 168 173 168
query7 5743 297 287 287
query8 306 221 210 210
query9 8950 2476 2497 2476
query10 504 269 261 261
query11 18353 15024 15423 15024
query12 152 104 99 99
query13 1567 377 370 370
query14 10869 7675 7367 7367
query15 260 183 187 183
query16 7181 488 506 488
query17 1122 593 572 572
query18 1854 296 320 296
query19 291 153 152 152
query20 122 114 112 112
query21 206 102 104 102
query22 4601 4394 4452 4394
query23 34422 34113 33512 33512
query24 5931 2905 2941 2905
query25 519 372 376 372
query26 689 156 154 154
query27 1800 267 272 267
query28 3822 2046 2016 2016
query29 657 405 427 405
query30 240 150 158 150
query31 935 754 764 754
query32 83 52 52 52
query33 412 286 276 276
query34 858 481 481 481
query35 834 705 728 705
query36 1077 908 952 908
query37 148 84 85 84
query38 4103 3902 3867 3867
query39 1445 1432 1395 1395
query40 195 114 112 112
query41 47 46 44 44
query42 118 96 95 95
query43 501 455 487 455
query44 1099 751 742 742
query45 195 162 161 161
query46 1074 749 756 749
query47 1912 1766 1787 1766
query48 363 297 287 287
query49 760 434 443 434
query50 822 408 409 408
query51 6996 6982 6807 6807
query52 104 89 89 89
query53 248 182 186 182
query54 569 459 455 455
query55 78 76 75 75
query56 296 260 272 260
query57 1155 1094 1085 1085
query58 225 240 247 240
query59 3045 2742 2696 2696
query60 293 275 266 266
query61 102 99 102 99
query62 770 667 659 659
query63 216 191 187 187
query64 2842 671 690 671
query65 3269 3176 3236 3176
query66 686 347 361 347
query67 15323 15257 15186 15186
query68 2938 568 584 568
query69 397 282 275 275
query70 1173 1119 1087 1087
query71 348 280 279 279
query72 5473 4005 3976 3976
query73 741 322 326 322
query74 9208 9001 8769 8769
query75 3392 2720 2758 2720
query76 1445 954 951 951
query77 514 330 325 325
query78 9612 9057 9098 9057
query79 1030 541 540 540
query80 694 518 565 518
query81 536 227 231 227
query82 246 150 143 143
query83 173 153 150 150
query84 266 76 76 76
query85 679 284 278 278
query86 305 299 302 299
query87 4449 4372 4242 4242
query88 2950 2409 2291 2291
query89 379 294 281 281
query90 1971 198 190 190
query91 123 97 96 96
query92 58 48 49 48
query93 1032 536 536 536
query94 713 297 290 290
query95 327 250 253 250
query96 588 262 265 262
query97 3263 3087 3042 3042
query98 269 204 206 204
query99 1507 1296 1278 1278
Total cold run time: 303779 ms
Total hot run time: 192562 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2336534806
<details>
<summary>TPC-H: <b>Total hot run time: 38399 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 297acb4ad4d4198ec22b4f53f656d29d4992436d, data reload: false
------ Round 1 ----------------------------------
q1 17609 4685 4303 4303
q2 2015 193 191 191
q3 11766 1023 1189 1023
q4 10513 771 731 731
q5 7727 2902 2826 2826
q6 233 143 145 143
q7 975 637 620 620
q8 9327 2100 2101 2100
q9 7217 6559 6547 6547
q10 6997 2217 2194 2194
q11 457 246 244 244
q12 407 231 234 231
q13 17874 3083 3055 3055
q14 282 238 247 238
q15 529 495 497 495
q16 507 414 447 414
q17 986 723 723 723
q18 7307 6843 6847 6843
q19 1399 1068 998 998
q20 698 331 331 331
q21 3939 3136 3258 3136
q22 1141 1029 1013 1013
Total cold run time: 109905 ms
Total hot run time: 38399 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4356 4316 4281 4281
q2 380 287 277 277
q3 2865 2671 2674 2671
q4 1967 1721 1662 1662
q5 5665 5694 5705 5694
q6 229 144 141 141
q7 2247 1852 1830 1830
q8 3310 3419 3513 3419
q9 8841 8901 8831 8831
q10 3628 3349 3380 3349
q11 607 509 514 509
q12 841 650 694 650
q13 14933 3214 3291 3214
q14 343 297 288 288
q15 545 491 498 491
q16 567 502 514 502
q17 1846 1543 1523 1523
q18 8111 7896 7932 7896
q19 1721 1579 1489 1489
q20 2165 1894 1904 1894
q21 5686 5623 5620 5620
q22 1126 1044 1023 1023
Total cold run time: 71979 ms
Total hot run time: 57254 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2331194644
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on code in PR #40441:
URL: https://github.com/apache/doris/pull/40441#discussion_r1751372532
##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/ExecFunction.java:
##########
@@ -43,4 +43,9 @@
* return type
*/
String returnType();
+
+ /**
+ * hasVarArgsc
+ */
+ boolean varArgs();
Review Comment:
good idea, done
--
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339853907
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337758771
<details>
<summary>ClickBench: <b>Total hot run time: 31.48 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 e8aa9761e4355180b34e613090613a2bd34e1af5, data reload: false
query1 0.04 0.05 0.04
query2 0.08 0.04 0.04
query3 0.23 0.06 0.06
query4 1.66 0.10 0.10
query5 0.51 0.48 0.49
query6 1.13 0.73 0.72
query7 0.02 0.01 0.01
query8 0.06 0.04 0.04
query9 0.52 0.49 0.48
query10 0.54 0.58 0.54
query11 0.17 0.12 0.11
query12 0.16 0.13 0.12
query13 0.60 0.60 0.59
query14 1.38 1.43 1.40
query15 0.85 0.81 0.81
query16 0.34 0.35 0.38
query17 1.05 1.00 1.05
query18 0.20 0.20 0.20
query19 1.82 1.72 1.73
query20 0.01 0.01 0.01
query21 15.40 0.69 0.67
query22 3.64 7.49 1.97
query23 18.28 1.37 1.28
query24 2.15 0.23 0.22
query25 0.16 0.08 0.08
query26 0.27 0.17 0.18
query27 0.08 0.08 0.07
query28 13.20 1.02 1.00
query29 12.68 3.36 3.35
query30 0.25 0.05 0.06
query31 2.86 0.40 0.40
query32 3.25 0.47 0.48
query33 2.96 3.06 2.98
query34 17.04 4.48 4.44
query35 4.52 4.55 4.46
query36 0.66 0.48 0.47
query37 0.18 0.15 0.16
query38 0.16 0.14 0.14
query39 0.05 0.04 0.04
query40 0.16 0.13 0.12
query41 0.08 0.04 0.04
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.5 s
Total hot run time: 31.48 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2341024556
<details>
<summary>TPC-DS: <b>Total hot run time: 191990 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 bcce3bec259015af12c39be2d070f32d2c00c6be, data reload: false
query1 910 374 392 374
query2 6489 1968 1860 1860
query3 6653 216 227 216
query4 34182 23073 23102 23073
query5 4179 495 488 488
query6 256 172 179 172
query7 4587 297 294 294
query8 283 215 208 208
query9 8717 2483 2464 2464
query10 442 264 251 251
query11 18019 15074 15237 15074
query12 150 97 96 96
query13 1628 379 365 365
query14 9522 6810 7226 6810
query15 252 167 171 167
query16 7940 436 468 436
query17 1578 557 560 557
query18 1873 283 277 277
query19 224 139 141 139
query20 118 111 108 108
query21 207 106 102 102
query22 4405 4259 4248 4248
query23 34525 34125 33520 33520
query24 11157 2955 2837 2837
query25 537 375 388 375
query26 722 157 151 151
query27 2446 277 281 277
query28 7278 2044 2044 2044
query29 645 404 402 402
query30 304 155 149 149
query31 1022 779 760 760
query32 100 55 54 54
query33 757 275 291 275
query34 986 478 488 478
query35 880 749 716 716
query36 1063 924 942 924
query37 147 92 81 81
query38 3965 3890 3918 3890
query39 1453 1390 1386 1386
query40 202 115 112 112
query41 49 47 46 46
query42 111 97 100 97
query43 493 473 470 470
query44 1205 772 736 736
query45 198 161 163 161
query46 1097 744 715 715
query47 1926 1808 1795 1795
query48 373 303 288 288
query49 1083 464 445 445
query50 831 408 417 408
query51 7100 6928 6864 6864
query52 100 90 87 87
query53 255 186 186 186
query54 977 475 456 456
query55 79 79 80 79
query56 282 297 246 246
query57 1170 1080 1037 1037
query58 238 218 234 218
query59 3079 2942 2857 2857
query60 296 287 266 266
query61 98 97 102 97
query62 818 637 664 637
query63 219 185 180 180
query64 4075 694 638 638
query65 3245 3139 3143 3139
query66 1344 390 391 390
query67 15958 15199 15393 15199
query68 3101 579 563 563
query69 416 261 265 261
query70 1156 1146 1085 1085
query71 329 274 268 268
query72 5803 3767 3976 3767
query73 751 326 330 326
query74 9366 8929 8869 8869
query75 3402 2698 2687 2687
query76 1868 975 1012 975
query77 494 327 364 327
query78 9706 9948 9817 9817
query79 933 902 868 868
query80 816 800 787 787
query81 451 268 257 257
query82 280 265 266 265
query83 190 195 192 192
query84 232 106 106 106
query85 697 386 378 378
query86 318 304 306 304
query87 4381 4313 4377 4313
query88 4823 4085 4045 4045
query89 366 364 363 363
query90 1923 306 305 305
query91 122 125 119 119
query92 79 72 73 72
query93 902 929 920 920
query94 749 396 359 359
query95 432 413 403 403
query96 467 464 466 464
query97 3127 3088 3173 3088
query98 229 224 231 224
query99 1385 1266 1301 1266
Total cold run time: 286796 ms
Total hot run time: 191990 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2335041105
<details>
<summary>TPC-H: <b>Total hot run time: 37836 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 18f4a35d6de1e227208fa40314e909fb5d9d292c, data reload: false
------ Round 1 ----------------------------------
q1 17641 4390 4284 4284
q2 2023 197 181 181
q3 11983 994 1090 994
q4 10526 760 800 760
q5 7747 2863 2828 2828
q6 227 139 141 139
q7 947 610 595 595
q8 9327 2050 2071 2050
q9 7290 6546 6535 6535
q10 7004 2201 2149 2149
q11 452 241 243 241
q12 388 222 222 222
q13 17772 3111 3081 3081
q14 297 238 242 238
q15 540 501 476 476
q16 518 437 432 432
q17 972 674 636 636
q18 7351 6797 6928 6797
q19 1386 1088 1002 1002
q20 689 350 321 321
q21 3908 3161 2838 2838
q22 1128 1064 1037 1037
Total cold run time: 110116 ms
Total hot run time: 37836 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4368 4290 4302 4290
q2 375 281 275 275
q3 2905 2724 2718 2718
q4 1961 1617 1654 1617
q5 5619 5690 5713 5690
q6 230 139 139 139
q7 2204 1830 1830 1830
q8 3300 3449 3453 3449
q9 8900 8831 8778 8778
q10 3571 3387 3381 3381
q11 604 504 512 504
q12 827 644 702 644
q13 14390 3355 3251 3251
q14 310 293 300 293
q15 531 482 504 482
q16 516 504 484 484
q17 1816 1540 1548 1540
q18 8212 7871 7852 7852
q19 1742 1612 1541 1541
q20 2143 1918 1917 1917
q21 5799 5618 5430 5430
q22 1163 1055 1066 1055
Total cold run time: 71486 ms
Total hot run time: 57160 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342440347
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2331195198
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2336537067
<details>
<summary>TPC-DS: <b>Total hot run time: 192774 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 297acb4ad4d4198ec22b4f53f656d29d4992436d, data reload: false
query1 1265 876 912 876
query2 6360 1945 1768 1768
query3 10604 3907 3908 3907
query4 60020 26560 23130 23130
query5 5357 505 514 505
query6 423 176 163 163
query7 5778 295 287 287
query8 307 206 216 206
query9 8910 2469 2478 2469
query10 480 276 278 276
query11 18054 15057 15326 15057
query12 155 107 109 107
query13 1567 416 400 400
query14 11189 7007 7082 7007
query15 239 182 186 182
query16 7459 463 509 463
query17 1089 599 600 599
query18 1983 295 298 295
query19 285 150 150 150
query20 125 110 112 110
query21 201 111 105 105
query22 4589 4645 4473 4473
query23 34199 33658 33455 33455
query24 5881 2811 2828 2811
query25 515 388 386 386
query26 668 150 150 150
query27 1762 270 275 270
query28 3781 2045 2016 2016
query29 661 412 451 412
query30 233 151 153 151
query31 953 768 769 768
query32 83 52 52 52
query33 405 282 289 282
query34 854 472 480 472
query35 802 715 726 715
query36 1078 937 976 937
query37 149 88 95 88
query38 4068 3841 3886 3841
query39 1445 1367 1383 1367
query40 206 116 114 114
query41 46 47 45 45
query42 117 98 97 97
query43 493 470 467 467
query44 1079 754 739 739
query45 202 166 166 166
query46 1085 730 722 722
query47 1953 1809 1791 1791
query48 365 290 292 290
query49 784 437 437 437
query50 835 403 403 403
query51 6972 6946 6840 6840
query52 101 90 90 90
query53 261 178 182 178
query54 569 452 460 452
query55 79 75 77 75
query56 298 273 281 273
query57 1218 1092 1096 1092
query58 237 255 240 240
query59 3031 2944 2773 2773
query60 320 274 285 274
query61 120 120 122 120
query62 757 663 661 661
query63 218 191 190 190
query64 2704 759 833 759
query65 3201 3089 3177 3089
query66 684 342 340 340
query67 15419 15210 15084 15084
query68 3313 577 590 577
query69 403 286 288 286
query70 1177 1061 1149 1061
query71 361 278 283 278
query72 6301 3960 3915 3915
query73 762 324 326 324
query74 9081 8828 8824 8824
query75 3378 2719 2696 2696
query76 1423 989 995 989
query77 587 325 326 325
query78 9667 9712 10917 9712
query79 1044 527 533 527
query80 756 503 519 503
query81 545 236 230 230
query82 270 139 140 139
query83 173 153 151 151
query84 270 72 78 72
query85 743 292 276 276
query86 306 273 295 273
query87 4473 4337 4434 4337
query88 3020 2302 2296 2296
query89 379 280 285 280
query90 1992 194 189 189
query91 129 101 109 101
query92 60 47 49 47
query93 1054 579 537 537
query94 750 291 293 291
query95 353 285 251 251
query96 588 261 262 261
query97 3207 3056 3091 3056
query98 230 200 195 195
query99 1674 1266 1289 1266
Total cold run time: 305799 ms
Total hot run time: 192774 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2331265172
<details>
<summary>TPC-H: <b>Total hot run time: 38096 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 0145f57c013df6e8296ec89ca0919744e1056d22, data reload: false
------ Round 1 ----------------------------------
q1 17614 4420 4314 4314
q2 2015 189 184 184
q3 11666 968 1140 968
q4 10515 692 769 692
q5 7772 2816 2782 2782
q6 227 140 134 134
q7 954 605 613 605
q8 9305 2054 2085 2054
q9 7001 6509 6504 6504
q10 7005 2220 2249 2220
q11 452 241 233 233
q12 415 219 227 219
q13 17773 3098 3083 3083
q14 290 247 241 241
q15 542 495 485 485
q16 596 504 518 504
q17 970 697 736 697
q18 7296 6924 6870 6870
q19 1387 1061 1142 1061
q20 667 339 317 317
q21 4009 3067 2928 2928
q22 1116 1023 1001 1001
Total cold run time: 109587 ms
Total hot run time: 38096 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4438 4287 4319 4287
q2 386 267 262 262
q3 2893 2722 2655 2655
q4 1926 1658 1650 1650
q5 5605 5674 5715 5674
q6 232 135 137 135
q7 2241 1822 1882 1822
q8 3316 3463 3452 3452
q9 8785 8823 8762 8762
q10 3560 3391 3343 3343
q11 601 528 513 513
q12 845 694 688 688
q13 12888 3273 3316 3273
q14 317 307 294 294
q15 520 482 513 482
q16 625 587 599 587
q17 1812 1544 1543 1543
q18 8091 8005 7864 7864
q19 1731 1523 1483 1483
q20 2134 1951 1895 1895
q21 5790 5457 5375 5375
q22 1119 1045 1044 1044
Total cold run time: 69855 ms
Total hot run time: 57083 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337020495
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2337045853
<details>
<summary>TPC-H: <b>Total hot run time: 38078 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 54275d49f7d10ca215ab7a109cdd22246ffd24af, data reload: false
------ Round 1 ----------------------------------
q1 17660 4389 4310 4310
q2 2029 188 198 188
q3 11899 966 1165 966
q4 10506 664 651 651
q5 7766 2869 2801 2801
q6 229 137 136 136
q7 959 618 623 618
q8 10583 2062 2087 2062
q9 7070 6583 6596 6583
q10 6988 2290 2170 2170
q11 490 242 235 235
q12 445 218 221 218
q13 18994 3185 3319 3185
q14 295 241 259 241
q15 555 500 498 498
q16 527 457 466 457
q17 993 694 717 694
q18 9419 7485 6845 6845
q19 1431 1057 1079 1057
q20 699 341 336 336
q21 4696 2969 2819 2819
q22 1145 1027 1008 1008
Total cold run time: 115378 ms
Total hot run time: 38078 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4379 4264 4262 4262
q2 388 286 274 274
q3 2876 2636 2645 2636
q4 1975 1735 1709 1709
q5 5656 5832 5596 5596
q6 219 131 134 131
q7 2192 1754 1757 1754
q8 3308 3471 3462 3462
q9 8814 8767 8843 8767
q10 3588 3347 3307 3307
q11 608 529 507 507
q12 875 626 591 591
q13 16897 3312 3290 3290
q14 321 288 273 273
q15 521 491 512 491
q16 533 523 514 514
q17 1831 1544 1524 1524
q18 8159 7780 7881 7780
q19 1767 1592 1600 1592
q20 2131 1944 1897 1897
q21 5747 5394 5291 5291
q22 1149 1083 1051 1051
Total cold run time: 73934 ms
Total hot run time: 56699 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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2339853830
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2340334059
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] [Feat](Nereids) support string functions fold constant by fe [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40441:
URL: https://github.com/apache/doris/pull/40441#issuecomment-2342607959
<details>
<summary>ClickBench: <b>Total hot run time: 31.38 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 8ad3460c9e129dc70f344421f6067eaa20d79f5e, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.07 0.07
query5 0.51 0.50 0.48
query6 1.13 0.73 0.73
query7 0.02 0.01 0.01
query8 0.06 0.05 0.04
query9 0.54 0.51 0.48
query10 0.52 0.56 0.54
query11 0.15 0.12 0.11
query12 0.15 0.14 0.12
query13 0.60 0.59 0.59
query14 1.39 1.38 1.46
query15 0.87 0.83 0.82
query16 0.38 0.38 0.37
query17 0.98 1.02 1.07
query18 0.23 0.21 0.20
query19 1.94 1.80 1.84
query20 0.01 0.01 0.01
query21 15.40 0.66 0.66
query22 4.18 7.36 1.80
query23 18.26 1.32 1.31
query24 2.11 0.21 0.22
query25 0.15 0.09 0.09
query26 0.28 0.17 0.17
query27 0.08 0.08 0.07
query28 13.28 1.04 1.00
query29 12.63 3.37 3.30
query30 0.24 0.06 0.05
query31 2.87 0.41 0.40
query32 3.25 0.48 0.48
query33 3.03 3.01 3.07
query34 17.09 4.43 4.48
query35 4.43 4.45 4.45
query36 0.66 0.48 0.49
query37 0.19 0.15 0.15
query38 0.16 0.14 0.15
query39 0.05 0.04 0.05
query40 0.16 0.12 0.12
query41 0.09 0.05 0.05
query42 0.05 0.04 0.05
query43 0.04 0.03 0.04
Total cold run time: 110.19 s
Total hot run time: 31.38 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