You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/07/29 12:45:49 UTC
[PR] [fix](Nereids) polish function signature search algorithm [doris]
morrySnow opened a new pull request, #38497:
URL: https://github.com/apache/doris/pull/38497
(no comment)
--
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2257501106
<details>
<summary>TPC-DS: <b>Total hot run time: 169479 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 4614f38d67f48554962ed13fa025096a6075051c, data reload: false
query1 901 373 362 362
query2 6479 1782 1747 1747
query3 6676 212 221 212
query4 19873 17512 17338 17338
query5 3678 496 488 488
query6 260 161 164 161
query7 4611 295 311 295
query8 262 191 186 186
query9 8533 2373 2334 2334
query10 442 279 262 262
query11 10456 10085 10056 10056
query12 122 96 90 90
query13 1640 369 387 369
query14 8966 7856 7104 7104
query15 211 161 163 161
query16 6725 454 449 449
query17 956 562 552 552
query18 1873 286 289 286
query19 207 147 146 146
query20 93 86 87 86
query21 213 97 102 97
query22 4291 3993 4066 3993
query23 33696 33878 33337 33337
query24 10303 3127 3111 3111
query25 670 405 416 405
query26 1762 155 157 155
query27 2950 282 287 282
query28 7569 2047 1992 1992
query29 1238 438 422 422
query30 230 152 158 152
query31 958 745 776 745
query32 96 53 56 53
query33 676 325 327 325
query34 918 472 493 472
query35 865 771 747 747
query36 1047 897 902 897
query37 284 81 80 80
query38 2942 2916 2793 2793
query39 850 809 803 803
query40 253 117 115 115
query41 47 44 47 44
query42 119 100 93 93
query43 476 418 427 418
query44 1181 720 731 720
query45 216 184 182 182
query46 1086 767 774 767
query47 1800 1744 1716 1716
query48 354 284 283 283
query49 927 424 411 411
query50 910 421 430 421
query51 6674 6726 6644 6644
query52 110 89 93 89
query53 246 177 182 177
query54 606 445 438 438
query55 76 77 77 77
query56 275 257 244 244
query57 1141 1071 1077 1071
query58 290 298 256 256
query59 2773 2403 2496 2403
query60 295 270 267 267
query61 95 100 98 98
query62 887 654 679 654
query63 206 176 181 176
query64 5693 1901 1893 1893
query65 3149 3071 3076 3071
query66 1311 334 331 331
query67 15102 15326 14782 14782
query68 4651 537 556 537
query69 684 393 307 307
query70 1128 997 1098 997
query71 470 269 270 269
query72 7492 2753 2495 2495
query73 785 324 321 321
query74 6041 5624 5647 5624
query75 3408 2742 2730 2730
query76 3420 1322 1386 1322
query77 560 306 300 300
query78 9473 8904 8937 8904
query79 2648 524 527 524
query80 991 514 551 514
query81 572 230 229 229
query82 972 130 131 130
query83 248 176 171 171
query84 276 79 82 79
query85 1429 340 316 316
query86 478 311 287 287
query87 3256 3120 3211 3120
query88 3855 2378 2353 2353
query89 378 296 286 286
query90 1799 194 184 184
query91 127 101 101 101
query92 60 50 52 50
query93 2108 605 594 594
query94 756 306 295 295
query95 388 260 261 260
query96 599 277 274 274
query97 3217 3066 3086 3066
query98 270 217 195 195
query99 1615 1259 1290 1259
Total cold run time: 264974 ms
Total hot run time: 169479 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2283531095
<details>
<summary>ClickBench: <b>Total hot run time: 30.68 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 b13eaac7612d22cdc08f8a6062526597f2851027, data reload: false
query1 0.05 0.05 0.04
query2 0.09 0.04 0.04
query3 0.23 0.06 0.06
query4 1.63 0.10 0.10
query5 0.49 0.50 0.49
query6 1.14 0.73 0.72
query7 0.02 0.01 0.01
query8 0.06 0.04 0.04
query9 0.55 0.48 0.49
query10 0.54 0.52 0.53
query11 0.16 0.11 0.11
query12 0.15 0.12 0.12
query13 0.61 0.60 0.59
query14 0.77 0.79 0.76
query15 0.85 0.84 0.81
query16 0.37 0.36 0.37
query17 0.97 0.97 0.99
query18 0.24 0.23 0.22
query19 1.85 1.73 1.72
query20 0.01 0.00 0.01
query21 15.38 0.74 0.64
query22 4.80 6.35 1.97
query23 18.25 1.41 1.31
query24 2.11 0.21 0.23
query25 0.15 0.07 0.08
query26 0.31 0.22 0.21
query27 0.45 0.22 0.22
query28 13.34 1.01 1.00
query29 12.60 3.32 3.35
query30 0.23 0.06 0.05
query31 2.90 0.40 0.38
query32 3.25 0.49 0.49
query33 2.91 2.92 2.88
query34 16.89 4.31 4.38
query35 4.43 4.39 4.50
query36 0.64 0.49 0.49
query37 0.20 0.16 0.15
query38 0.16 0.15 0.15
query39 0.04 0.04 0.04
query40 0.15 0.13 0.12
query41 0.08 0.04 0.04
query42 0.06 0.04 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.16 s
Total hot run time: 30.68 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2257442929
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2255963409
<details>
<summary>TPC-DS: <b>Total hot run time: 168318 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 499de03151fd6c041110529eae015f60a795c10d, data reload: false
query1 913 373 376 373
query2 6486 1643 1656 1643
query3 6668 212 219 212
query4 19168 17650 17332 17332
query5 4289 526 506 506
query6 282 178 167 167
query7 4601 297 296 296
query8 252 188 195 188
query9 8530 2389 2378 2378
query10 441 280 268 268
query11 10589 10060 9896 9896
query12 142 89 87 87
query13 1627 384 374 374
query14 9843 7210 7092 7092
query15 198 163 166 163
query16 7116 454 448 448
query17 946 575 538 538
query18 1914 295 276 276
query19 186 143 142 142
query20 92 86 88 86
query21 205 97 104 97
query22 4051 4108 4084 4084
query23 33842 32995 32643 32643
query24 10420 3074 2987 2987
query25 694 376 382 376
query26 1777 152 148 148
query27 3038 268 278 268
query28 7054 1999 1971 1971
query29 1351 420 408 408
query30 283 147 146 146
query31 949 753 751 751
query32 96 51 56 51
query33 690 304 314 304
query34 902 473 472 472
query35 861 729 724 724
query36 989 861 873 861
query37 297 81 77 77
query38 2876 2798 2795 2795
query39 851 795 799 795
query40 290 110 116 110
query41 46 49 44 44
query42 121 99 101 99
query43 458 405 406 405
query44 1206 723 721 721
query45 206 179 177 177
query46 1111 786 770 770
query47 1812 1721 1705 1705
query48 361 290 286 286
query49 1181 414 406 406
query50 882 430 432 430
query51 6809 6783 6591 6591
query52 111 93 88 88
query53 246 177 175 175
query54 628 454 456 454
query55 75 75 75 75
query56 291 250 243 243
query57 1129 1041 1039 1039
query58 262 264 255 255
query59 2518 2522 2349 2349
query60 300 277 316 277
query61 100 98 96 96
query62 943 645 650 645
query63 207 179 180 179
query64 5895 1900 1856 1856
query65 3157 3091 3069 3069
query66 1452 335 395 335
query67 15211 14802 15006 14802
query68 4324 568 577 568
query69 432 298 289 289
query70 1087 1053 1029 1029
query71 408 268 284 268
query72 7153 2758 2491 2491
query73 782 328 325 325
query74 6008 5646 5597 5597
query75 3372 2757 2716 2716
query76 2527 1332 1411 1332
query77 451 307 301 301
query78 9364 8918 8957 8918
query79 1888 523 535 523
query80 1215 520 504 504
query81 560 225 227 225
query82 1035 132 128 128
query83 243 166 175 166
query84 275 81 77 77
query85 1380 383 298 298
query86 453 295 297 295
query87 3267 3173 3108 3108
query88 3003 2473 2483 2473
query89 388 293 281 281
query90 1828 196 184 184
query91 126 105 103 103
query92 66 52 50 50
query93 1965 629 615 615
query94 939 300 296 296
query95 381 269 270 269
query96 604 285 277 277
query97 3170 3042 3012 3012
query98 212 198 195 195
query99 1634 1366 1301 1301
Total cold run time: 263057 ms
Total hot run time: 168318 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2263102913
<details>
<summary>TPC-DS: <b>Total hot run time: 170281 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 fa80991b871d07825bed5b364f4298d54c75f901, data reload: false
query1 932 371 371 371
query2 6471 1676 1684 1676
query3 6671 220 227 220
query4 19806 17684 17631 17631
query5 3632 514 530 514
query6 287 178 161 161
query7 4595 304 296 296
query8 257 205 182 182
query9 8512 2386 2357 2357
query10 426 255 269 255
query11 10652 10245 10118 10118
query12 118 90 91 90
query13 1627 371 370 370
query14 9621 6770 7032 6770
query15 215 161 165 161
query16 6860 418 440 418
query17 935 552 557 552
query18 1908 299 276 276
query19 193 144 146 144
query20 97 90 87 87
query21 208 99 98 98
query22 4278 4220 3905 3905
query23 33643 33817 33587 33587
query24 10271 3085 3069 3069
query25 689 413 411 411
query26 1806 158 155 155
query27 2970 286 290 286
query28 7437 2025 2004 2004
query29 1296 472 426 426
query30 237 167 162 162
query31 939 775 771 771
query32 99 55 56 55
query33 670 314 333 314
query34 929 505 510 505
query35 870 750 768 750
query36 1036 905 880 880
query37 293 87 82 82
query38 2945 2885 2756 2756
query39 852 817 817 817
query40 254 116 115 115
query41 49 48 47 47
query42 118 101 104 101
query43 490 409 442 409
query44 1181 735 739 735
query45 219 185 185 185
query46 1098 840 798 798
query47 1847 1730 1744 1730
query48 381 303 294 294
query49 959 442 435 435
query50 903 447 444 444
query51 6745 6691 6729 6691
query52 100 97 89 89
query53 258 189 185 185
query54 609 456 456 456
query55 77 75 79 75
query56 291 263 263 263
query57 1132 1026 1032 1026
query58 290 283 270 270
query59 2593 2393 2331 2331
query60 313 296 294 294
query61 121 132 115 115
query62 885 667 667 667
query63 221 184 189 184
query64 5712 2002 1998 1998
query65 3173 3123 3126 3123
query66 1328 337 328 328
query67 15378 15154 14984 14984
query68 4364 566 571 566
query69 649 362 315 315
query70 1130 1060 1074 1060
query71 473 285 286 285
query72 7956 2682 2547 2547
query73 786 335 334 334
query74 6074 5664 5684 5664
query75 3656 2719 2767 2719
query76 2628 1159 1277 1159
query77 596 313 308 308
query78 9349 8949 8871 8871
query79 1400 541 544 541
query80 818 509 498 498
query81 546 235 223 223
query82 635 130 130 130
query83 252 173 170 170
query84 268 81 80 80
query85 1352 317 361 317
query86 434 272 298 272
query87 3285 3143 3125 3125
query88 3771 2433 2434 2433
query89 387 298 291 291
query90 1870 195 195 195
query91 123 101 102 101
query92 61 49 49 49
query93 1838 629 615 615
query94 790 301 304 301
query95 384 269 274 269
query96 603 286 289 286
query97 3303 3038 3065 3038
query98 227 206 198 198
query99 1608 1278 1267 1267
Total cold run time: 263624 ms
Total hot run time: 170281 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2283424625
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2257506421
<details>
<summary>ClickBench: <b>Total hot run time: 29.87 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 4614f38d67f48554962ed13fa025096a6075051c, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.04
query3 0.22 0.04 0.04
query4 1.69 0.06 0.07
query5 0.49 0.48 0.48
query6 1.16 0.71 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.57 0.53 0.51
query10 0.59 0.58 0.57
query11 0.16 0.11 0.11
query12 0.14 0.13 0.13
query13 0.61 0.61 0.59
query14 0.78 0.78 0.80
query15 0.89 0.86 0.86
query16 0.35 0.36 0.35
query17 0.97 1.01 0.98
query18 0.23 0.21 0.22
query19 1.81 1.77 1.72
query20 0.01 0.01 0.01
query21 15.41 0.77 0.65
query22 4.00 7.52 1.31
query23 17.73 1.29 1.22
query24 2.28 0.22 0.21
query25 0.19 0.08 0.08
query26 0.32 0.22 0.22
query27 0.46 0.24 0.23
query28 13.16 1.00 0.97
query29 12.54 3.37 3.32
query30 0.25 0.06 0.06
query31 2.86 0.41 0.42
query32 3.24 0.48 0.49
query33 2.94 2.86 2.95
query34 15.44 4.26 4.27
query35 4.29 4.28 4.29
query36 0.67 0.48 0.48
query37 0.19 0.16 0.16
query38 0.16 0.16 0.15
query39 0.04 0.04 0.03
query40 0.15 0.14 0.14
query41 0.10 0.05 0.06
query42 0.06 0.04 0.04
query43 0.05 0.04 0.04
Total cold run time: 107.39 s
Total hot run time: 29.87 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2285993433
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2276216272
<details>
<summary>TPC-H: <b>Total hot run time: 39416 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 95fbe270dbe4aa7c9dbed0504d8dbfceaae1d613, data reload: false
------ Round 1 ----------------------------------
q1 17606 4433 4325 4325
q2 2011 174 179 174
q3 10494 1142 1124 1124
q4 10129 720 657 657
q5 7511 2529 2455 2455
q6 223 135 139 135
q7 986 597 585 585
q8 9223 1908 1888 1888
q9 9062 6540 6534 6534
q10 7054 2195 2096 2096
q11 468 240 241 240
q12 486 229 214 214
q13 19017 2967 2981 2967
q14 286 235 245 235
q15 519 475 493 475
q16 510 398 380 380
q17 974 680 703 680
q18 7829 7479 7507 7479
q19 5416 974 963 963
q20 678 336 331 331
q21 5668 4512 4485 4485
q22 1114 1023 994 994
Total cold run time: 117264 ms
Total hot run time: 39416 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4489 4288 4289 4288
q2 380 284 271 271
q3 2825 2646 2714 2646
q4 1982 1717 1650 1650
q5 5596 5421 5467 5421
q6 227 133 135 133
q7 2158 1817 1778 1778
q8 3294 3472 3487 3472
q9 8712 8724 8738 8724
q10 3495 3342 3179 3179
q11 580 522 500 500
q12 824 642 643 642
q13 15821 3202 3206 3202
q14 317 295 278 278
q15 555 496 490 490
q16 503 469 457 457
q17 1826 1521 1555 1521
q18 7990 8037 7840 7840
q19 1775 1555 1582 1555
q20 2164 1941 1895 1895
q21 10335 5254 5335 5254
q22 1114 980 1035 980
Total cold run time: 76962 ms
Total hot run time: 56176 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2276238035
<details>
<summary>TPC-DS: <b>Total hot run time: 203457 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 95fbe270dbe4aa7c9dbed0504d8dbfceaae1d613, data reload: false
query1 952 417 397 397
query2 6439 1916 1767 1767
query3 6639 202 230 202
query4 33961 23255 23154 23154
query5 3613 494 504 494
query6 292 179 174 174
query7 4570 293 288 288
query8 234 194 188 188
query9 8505 2381 2346 2346
query10 910 895 880 880
query11 17820 15089 14960 14960
query12 127 95 92 92
query13 1621 381 367 367
query14 10361 8144 7872 7872
query15 412 326 339 326
query16 7526 416 470 416
query17 1311 593 592 592
query18 1989 425 414 414
query19 273 218 191 191
query20 121 109 109 109
query21 202 117 111 111
query22 4562 4426 4299 4299
query23 34103 33655 33689 33655
query24 11641 2905 2860 2860
query25 542 369 364 364
query26 697 148 148 148
query27 2200 277 283 277
query28 5938 1982 1988 1982
query29 789 418 440 418
query30 248 147 148 147
query31 933 724 701 701
query32 99 51 55 51
query33 721 279 273 273
query34 926 477 489 477
query35 923 843 797 797
query36 1047 907 906 906
query37 128 76 75 75
query38 4151 4237 4200 4200
query39 1446 1427 1368 1368
query40 203 112 115 112
query41 47 43 43 43
query42 111 93 95 93
query43 499 462 445 445
query44 1244 740 741 740
query45 404 371 358 358
query46 1110 764 762 762
query47 1851 1788 1769 1769
query48 378 300 296 296
query49 832 418 421 418
query50 804 398 402 398
query51 6773 6699 6665 6665
query52 100 92 91 91
query53 264 184 177 177
query54 885 464 460 460
query55 78 77 76 76
query56 268 245 252 245
query57 1137 1066 1078 1066
query58 230 231 233 231
query59 2901 2662 2691 2662
query60 306 265 268 265
query61 112 111 114 111
query62 805 647 655 647
query63 212 185 179 179
query64 9604 2500 1990 1990
query65 3225 3219 3142 3142
query66 770 343 330 330
query67 15248 15016 14759 14759
query68 4576 558 564 558
query69 416 387 378 378
query70 1151 1140 1075 1075
query71 448 293 291 291
query72 19393 16429 16599 16429
query73 753 335 331 331
query74 9141 8813 8826 8813
query75 3498 2707 2703 2703
query76 2571 1044 1040 1040
query77 465 314 314 314
query78 9689 8998 9040 8998
query79 4265 522 524 522
query80 2900 532 503 503
query81 609 242 226 226
query82 839 140 132 132
query83 313 147 144 144
query84 272 86 76 76
query85 2041 310 300 300
query86 461 281 298 281
query87 4768 4486 4546 4486
query88 5239 2488 2517 2488
query89 428 293 291 291
query90 1954 194 200 194
query91 181 121 113 113
query92 66 48 48 48
query93 5418 544 540 540
query94 1039 284 301 284
query95 349 264 262 262
query96 615 277 282 277
query97 3226 3054 3066 3054
query98 223 199 196 196
query99 1646 1255 1242 1242
Total cold run time: 318326 ms
Total hot run time: 203457 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2263067380
<details>
<summary>TPC-H: <b>Total hot run time: 41533 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 fa80991b871d07825bed5b364f4298d54c75f901, data reload: false
------ Round 1 ----------------------------------
q1 17689 4050 4077 4050
q2 2020 200 211 200
q3 10585 1267 1354 1267
q4 10170 805 946 805
q5 7649 2924 2959 2924
q6 218 137 138 137
q7 1018 612 611 611
q8 9422 1917 1957 1917
q9 8511 6591 6586 6586
q10 8754 3824 3834 3824
q11 429 243 241 241
q12 408 225 220 220
q13 17760 2952 2933 2933
q14 270 239 240 239
q15 531 502 488 488
q16 529 404 397 397
q17 950 910 913 910
q18 8035 7295 7242 7242
q19 1501 1215 1214 1214
q20 545 311 350 311
q21 5320 4733 4794 4733
q22 363 284 287 284
Total cold run time: 112677 ms
Total hot run time: 41533 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4085 3987 4023 3987
q2 325 230 235 230
q3 2990 2997 3119 2997
q4 1961 2027 1976 1976
q5 5630 5468 5439 5439
q6 230 135 132 132
q7 2135 1703 1825 1703
q8 3291 3355 3315 3315
q9 8642 8695 8717 8695
q10 3956 4058 3976 3976
q11 544 444 453 444
q12 785 589 579 579
q13 15030 3156 3152 3152
q14 294 267 270 267
q15 538 495 494 494
q16 456 400 408 400
q17 1749 1744 1712 1712
q18 8159 7702 7719 7702
q19 1728 1693 1718 1693
q20 2072 1857 1848 1848
q21 5678 5543 5270 5270
q22 522 463 465 463
Total cold run time: 70800 ms
Total hot run time: 56474 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2255838298
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2255934887
<details>
<summary>TPC-H: <b>Total hot run time: 41473 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 499de03151fd6c041110529eae015f60a795c10d, data reload: false
------ Round 1 ----------------------------------
q1 17604 4069 4026 4026
q2 2024 201 206 201
q3 10645 1285 1294 1285
q4 10230 820 948 820
q5 7917 2983 3001 2983
q6 220 155 143 143
q7 1057 626 612 612
q8 9953 1909 1934 1909
q9 8426 6582 6583 6582
q10 8686 3866 3842 3842
q11 435 254 250 250
q12 408 234 220 220
q13 17763 2941 2944 2941
q14 267 244 246 244
q15 538 491 480 480
q16 519 385 379 379
q17 957 938 880 880
q18 7866 7325 7216 7216
q19 1386 1216 1202 1202
q20 571 321 337 321
q21 5261 4791 4656 4656
q22 347 282 281 281
Total cold run time: 113080 ms
Total hot run time: 41473 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4063 3982 4024 3982
q2 335 221 218 218
q3 2985 2986 2976 2976
q4 1908 1873 1866 1866
q5 5187 5239 5257 5239
q6 217 133 132 132
q7 2074 1658 1683 1658
q8 3202 3295 3270 3270
q9 8270 8264 8275 8264
q10 3724 3822 3846 3822
q11 546 452 452 452
q12 741 586 540 540
q13 14230 2956 2919 2919
q14 287 264 256 256
q15 516 484 487 484
q16 437 394 395 394
q17 1693 1670 1671 1670
q18 7675 7283 7174 7174
q19 1645 1659 1639 1639
q20 1985 1751 1760 1751
q21 5429 5210 5208 5208
q22 511 454 459 454
Total cold run time: 67660 ms
Total hot run time: 54368 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2276147715
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2255838734
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2255976443
<details>
<summary>ClickBench: <b>Total hot run time: 30.17 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 499de03151fd6c041110529eae015f60a795c10d, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.22 0.04 0.04
query4 1.68 0.06 0.07
query5 0.48 0.49 0.50
query6 1.12 0.72 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.05
query9 0.58 0.51 0.51
query10 0.56 0.56 0.56
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.61 0.60 0.58
query14 0.78 0.79 0.78
query15 0.88 0.86 0.86
query16 0.35 0.35 0.34
query17 1.00 0.97 0.99
query18 0.22 0.21 0.21
query19 1.86 1.75 1.76
query20 0.02 0.01 0.01
query21 15.41 0.77 0.67
query22 4.11 7.22 1.50
query23 18.00 1.43 1.31
query24 2.24 0.22 0.22
query25 0.18 0.08 0.09
query26 0.31 0.22 0.21
query27 0.46 0.25 0.25
query28 13.17 1.00 0.95
query29 12.52 3.29 3.27
query30 0.25 0.06 0.05
query31 2.87 0.41 0.39
query32 3.26 0.49 0.48
query33 2.90 2.98 2.94
query34 15.44 4.26 4.29
query35 4.31 4.32 4.30
query36 0.68 0.47 0.48
query37 0.19 0.16 0.16
query38 0.16 0.15 0.15
query39 0.04 0.03 0.04
query40 0.16 0.13 0.14
query41 0.10 0.04 0.04
query42 0.06 0.04 0.05
query43 0.04 0.04 0.04
Total cold run time: 107.7 s
Total hot run time: 30.17 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2285708848
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #38497:
URL: https://github.com/apache/doris/pull/38497
--
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2285993498
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2262969271
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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2263123130
<details>
<summary>ClickBench: <b>Total hot run time: 30.72 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 fa80991b871d07825bed5b364f4298d54c75f901, data reload: false
query1 0.05 0.03 0.03
query2 0.07 0.05 0.04
query3 0.22 0.04 0.04
query4 1.69 0.06 0.06
query5 0.49 0.50 0.50
query6 1.13 0.71 0.72
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.57 0.52 0.50
query10 0.56 0.56 0.55
query11 0.17 0.11 0.12
query12 0.15 0.12 0.13
query13 0.60 0.60 0.60
query14 0.78 0.81 0.85
query15 0.90 0.86 0.86
query16 0.34 0.36 0.35
query17 1.01 1.00 1.03
query18 0.22 0.20 0.20
query19 1.83 1.74 1.73
query20 0.02 0.01 0.01
query21 15.39 0.77 0.65
query22 3.81 6.36 1.99
query23 18.06 1.30 1.27
query24 2.14 0.23 0.22
query25 0.18 0.08 0.08
query26 0.33 0.22 0.21
query27 0.45 0.23 0.23
query28 13.19 1.01 0.98
query29 12.58 3.33 3.30
query30 0.27 0.05 0.06
query31 2.85 0.42 0.40
query32 3.24 0.48 0.48
query33 2.94 2.99 2.95
query34 15.50 4.26 4.28
query35 4.31 4.30 4.29
query36 0.68 0.49 0.49
query37 0.19 0.16 0.17
query38 0.16 0.15 0.15
query39 0.04 0.03 0.04
query40 0.15 0.14 0.13
query41 0.10 0.05 0.04
query42 0.05 0.05 0.05
query43 0.04 0.04 0.05
Total cold run time: 107.52 s
Total hot run time: 30.72 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2283496683
<details>
<summary>TPC-H: <b>Total hot run time: 39492 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 b13eaac7612d22cdc08f8a6062526597f2851027, data reload: false
------ Round 1 ----------------------------------
q1 17620 4361 4263 4263
q2 2017 207 212 207
q3 11691 997 1132 997
q4 10527 749 727 727
q5 7519 2528 2505 2505
q6 220 136 138 136
q7 965 597 594 594
q8 9225 1918 1892 1892
q9 8676 6489 6502 6489
q10 7038 2180 2248 2180
q11 452 239 246 239
q12 398 226 225 225
q13 18991 3005 3014 3005
q14 285 234 242 234
q15 535 494 482 482
q16 530 388 385 385
q17 997 669 620 620
q18 8003 7495 7315 7315
q19 6016 1031 1021 1021
q20 696 330 344 330
q21 5287 4738 4641 4641
q22 1106 1005 1009 1005
Total cold run time: 118794 ms
Total hot run time: 39492 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4429 4316 4223 4223
q2 374 276 276 276
q3 2847 2822 2762 2762
q4 2001 1742 1764 1742
q5 5490 5462 5451 5451
q6 236 131 135 131
q7 2191 1801 1794 1794
q8 3259 3445 3377 3377
q9 8638 8760 8636 8636
q10 3570 3175 3192 3175
q11 601 518 519 518
q12 804 638 659 638
q13 16066 3176 3193 3176
q14 324 288 292 288
q15 541 496 494 494
q16 500 458 451 451
q17 1806 1519 1547 1519
q18 8166 7913 7774 7774
q19 4257 1630 1692 1630
q20 2163 1865 1871 1865
q21 5445 5336 5177 5177
q22 1156 1073 1055 1055
Total cold run time: 74864 ms
Total hot run time: 56152 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2257490468
<details>
<summary>TPC-H: <b>Total hot run time: 41571 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 4614f38d67f48554962ed13fa025096a6075051c, data reload: false
------ Round 1 ----------------------------------
q1 17684 4218 4109 4109
q2 2043 221 214 214
q3 10419 1310 1302 1302
q4 10185 802 940 802
q5 7666 2920 2953 2920
q6 221 135 137 135
q7 1025 613 615 613
q8 9440 1880 1946 1880
q9 8534 6603 6609 6603
q10 8752 3836 3828 3828
q11 440 259 254 254
q12 408 231 230 230
q13 17770 2964 2955 2955
q14 277 245 240 240
q15 529 491 496 491
q16 530 377 393 377
q17 977 944 890 890
q18 8099 7301 7217 7217
q19 1421 1222 1226 1222
q20 563 336 343 336
q21 5332 4722 4672 4672
q22 358 281 292 281
Total cold run time: 112673 ms
Total hot run time: 41571 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4067 4046 4016 4016
q2 333 226 229 226
q3 2990 2978 3118 2978
q4 2003 2033 1979 1979
q5 5623 5487 5448 5448
q6 219 135 142 135
q7 2136 1790 1854 1790
q8 3350 3411 3375 3375
q9 8675 8661 8716 8661
q10 3948 4013 3998 3998
q11 560 458 452 452
q12 731 610 588 588
q13 14053 3128 3144 3128
q14 305 291 276 276
q15 547 491 512 491
q16 467 430 428 428
q17 1771 1729 1757 1729
q18 8141 7698 7697 7697
q19 1752 1731 1709 1709
q20 2063 1820 1899 1820
q21 5771 5565 5558 5558
q22 519 470 471 470
Total cold run time: 70024 ms
Total hot run time: 56952 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2276247136
<details>
<summary>ClickBench: <b>Total hot run time: 31.2 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 95fbe270dbe4aa7c9dbed0504d8dbfceaae1d613, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.08 0.07
query5 0.50 0.48 0.47
query6 1.13 0.73 0.71
query7 0.02 0.01 0.02
query8 0.05 0.05 0.05
query9 0.55 0.49 0.49
query10 0.55 0.55 0.53
query11 0.15 0.11 0.12
query12 0.15 0.13 0.13
query13 0.60 0.61 0.58
query14 0.77 0.77 0.80
query15 0.84 0.82 0.82
query16 0.37 0.35 0.35
query17 0.97 0.98 0.99
query18 0.24 0.22 0.22
query19 1.79 1.67 1.78
query20 0.01 0.01 0.01
query21 15.41 0.76 0.66
query22 3.54 6.91 2.58
query23 18.28 1.39 1.23
query24 2.16 0.22 0.21
query25 0.15 0.09 0.08
query26 0.29 0.21 0.21
query27 0.45 0.22 0.23
query28 13.28 1.02 1.00
query29 12.59 3.33 3.29
query30 0.24 0.06 0.05
query31 2.89 0.39 0.38
query32 3.28 0.48 0.47
query33 2.95 2.96 2.95
query34 16.83 4.34 4.38
query35 4.40 4.39 4.45
query36 0.65 0.49 0.47
query37 0.19 0.15 0.15
query38 0.15 0.14 0.15
query39 0.05 0.04 0.04
query40 0.14 0.12 0.12
query41 0.10 0.05 0.05
query42 0.06 0.04 0.04
query43 0.04 0.05 0.04
Total cold run time: 108.83 s
Total hot run time: 31.2 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] [fix](Nereids) polish function signature search algorithm [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38497:
URL: https://github.com/apache/doris/pull/38497#issuecomment-2283520329
<details>
<summary>TPC-DS: <b>Total hot run time: 202525 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 b13eaac7612d22cdc08f8a6062526597f2851027, data reload: false
query1 1627 1461 1464 1461
query2 6445 1961 1860 1860
query3 13524 8295 317 317
query4 31423 23142 23047 23047
query5 5159 487 481 481
query6 264 163 167 163
query7 3951 301 292 292
query8 244 203 205 203
query9 8572 2507 2471 2471
query10 570 461 446 446
query11 17093 15185 15003 15003
query12 163 97 96 96
query13 1556 385 370 370
query14 9216 6930 6791 6791
query15 276 244 220 220
query16 7647 461 471 461
query17 1253 561 578 561
query18 1950 288 283 283
query19 189 143 146 143
query20 119 108 108 108
query21 202 109 95 95
query22 4550 4355 4330 4330
query23 34296 33576 33731 33576
query24 8158 2525 2516 2516
query25 563 371 364 364
query26 700 152 153 152
query27 2107 282 280 280
query28 5784 2051 2047 2047
query29 804 412 407 407
query30 245 150 151 150
query31 926 716 739 716
query32 81 50 55 50
query33 538 282 279 279
query34 843 466 477 466
query35 951 854 803 803
query36 1042 935 937 935
query37 137 80 82 80
query38 4246 4154 4198 4154
query39 1430 1372 1372 1372
query40 186 124 117 117
query41 46 42 43 42
query42 119 98 92 92
query43 515 480 477 477
query44 1039 728 713 713
query45 224 213 211 211
query46 1083 759 718 718
query47 1834 1730 1821 1730
query48 361 294 290 290
query49 827 407 415 407
query50 806 409 409 409
query51 6722 6728 6680 6680
query52 100 89 90 89
query53 248 184 177 177
query54 553 445 445 445
query55 77 107 72 72
query56 272 239 240 239
query57 1131 1064 1063 1063
query58 230 214 233 214
query59 2933 2768 2775 2768
query60 293 263 250 250
query61 96 91 94 91
query62 767 650 650 650
query63 218 182 184 182
query64 9156 2272 1800 1800
query65 3192 3172 3154 3154
query66 738 325 333 325
query67 15090 14797 14670 14670
query68 4543 545 565 545
query69 452 363 370 363
query70 1181 1107 1045 1045
query71 393 284 275 275
query72 19277 17477 17213 17213
query73 766 329 327 327
query74 9393 8708 8832 8708
query75 3366 2692 2665 2665
query76 2129 1003 966 966
query77 452 306 305 305
query78 9398 8883 8953 8883
query79 3429 524 520 520
query80 1466 492 495 492
query81 569 219 216 216
query82 760 149 142 142
query83 182 153 143 143
query84 271 85 77 77
query85 1174 279 275 275
query86 392 272 302 272
query87 4700 4663 4533 4533
query88 4276 2478 2505 2478
query89 527 284 289 284
query90 2093 199 203 199
query91 120 98 95 95
query92 63 50 53 50
query93 5787 551 536 536
query94 952 270 291 270
query95 358 263 264 263
query96 617 281 275 275
query97 3246 3043 3040 3040
query98 209 203 204 203
query99 1607 1243 1255 1243
Total cold run time: 311848 ms
Total hot run time: 202525 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