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/07/16 02:18:29 UTC
[PR] [fix](Nereids) fix fe fold constant failed when using like function [doris]
LiBinfeng-01 opened a new pull request, #37863:
URL: https://github.com/apache/doris/pull/37863
cherry-pick: #37616
--
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) fix fe fold constant failed when using like function [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #37863:
URL: https://github.com/apache/doris/pull/37863#issuecomment-2229873935
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) fix fe fold constant failed when using like function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37863:
URL: https://github.com/apache/doris/pull/37863#issuecomment-2229902321
<details>
<summary>TPC-H: <b>Total hot run time: 49667 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 3cdfdd3cf875ad884c4c6534cf3136d60b098d62, data reload: false
------ Round 1 ----------------------------------
q1 17620 4363 4347 4347
q2 2066 155 157 155
q3 10457 1875 1961 1875
q4 10339 1220 1315 1220
q5 8326 3861 3893 3861
q6 251 126 144 126
q7 2058 1625 1581 1581
q8 9352 2787 2695 2695
q9 10598 10379 10214 10214
q10 8654 3511 3506 3506
q11 430 239 249 239
q12 480 315 310 310
q13 18332 3957 4019 3957
q14 352 325 325 325
q15 513 458 462 458
q16 688 565 573 565
q17 1137 953 969 953
q18 7308 6978 6809 6809
q19 1796 1687 1657 1657
q20 520 290 296 290
q21 4434 4091 4109 4091
q22 532 433 436 433
Total cold run time: 116243 ms
Total hot run time: 49667 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4323 4268 4291 4268
q2 325 230 225 225
q3 4133 4150 4128 4128
q4 2748 2752 2757 2752
q5 7123 7023 7041 7023
q6 237 120 119 119
q7 3210 2830 2884 2830
q8 4365 4420 4491 4420
q9 16833 16817 16793 16793
q10 4221 4257 4251 4251
q11 776 671 655 655
q12 1044 877 858 858
q13 7041 3736 3717 3717
q14 453 430 421 421
q15 509 465 464 464
q16 741 683 678 678
q17 3929 3915 3840 3840
q18 8762 8839 8779 8779
q19 1738 1710 1652 1652
q20 2417 2101 2098 2098
q21 8430 8440 8456 8440
q22 1082 1010 1009 1009
Total cold run time: 84440 ms
Total hot run time: 79420 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) fix fe fold constant failed when using like function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37863:
URL: https://github.com/apache/doris/pull/37863#issuecomment-2229919975
<details>
<summary>ClickBench: <b>Total hot run time: 30.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 3cdfdd3cf875ad884c4c6534cf3136d60b098d62, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.02
query3 0.25 0.04 0.05
query4 1.81 0.06 0.07
query5 0.53 0.52 0.52
query6 1.23 0.62 0.61
query7 0.01 0.02 0.02
query8 0.03 0.03 0.02
query9 0.53 0.50 0.49
query10 0.54 0.53 0.54
query11 0.13 0.08 0.09
query12 0.11 0.08 0.09
query13 0.63 0.61 0.61
query14 0.81 0.78 0.78
query15 0.78 0.75 0.74
query16 0.38 0.39 0.36
query17 1.02 1.03 1.01
query18 0.23 0.25 0.22
query19 1.93 1.86 1.84
query20 0.02 0.01 0.01
query21 15.46 0.57 0.55
query22 2.10 2.43 1.63
query23 16.39 1.14 0.92
query24 6.73 0.59 1.01
query25 0.39 0.14 0.04
query26 0.62 0.17 0.16
query27 0.04 0.05 0.04
query28 6.78 0.78 0.77
query29 12.71 2.40 2.41
query30 0.61 0.53 0.53
query31 2.81 0.39 0.37
query32 3.38 0.48 0.50
query33 3.09 3.07 3.06
query34 15.26 4.79 4.80
query35 4.85 4.84 4.83
query36 1.06 1.01 1.00
query37 0.06 0.04 0.05
query38 0.04 0.02 0.02
query39 0.02 0.01 0.02
query40 0.16 0.14 0.15
query41 0.07 0.01 0.01
query42 0.02 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 103.73 s
Total hot run time: 30.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] [fix](Nereids) fix fe fold constant failed when using like function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37863:
URL: https://github.com/apache/doris/pull/37863#issuecomment-2229922124
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 3cdfdd3cf875ad884c4c6534cf3136d60b098d62 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.5 seconds inserted 10000000 Rows, about 465K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: 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) fix fe fold constant failed when using like function [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #37863:
URL: https://github.com/apache/doris/pull/37863
--
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) fix fe fold constant failed when using like function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37863:
URL: https://github.com/apache/doris/pull/37863#issuecomment-2229914738
<details>
<summary>TPC-DS: <b>Total hot run time: 204104 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 3cdfdd3cf875ad884c4c6534cf3136d60b098d62, data reload: false
query1 925 425 380 380
query2 6544 2740 2644 2644
query3 6922 209 203 203
query4 20194 18110 18061 18061
query5 19721 6588 6468 6468
query6 281 220 239 220
query7 4163 302 303 302
query8 448 420 429 420
query9 3121 2656 2587 2587
query10 423 296 297 296
query11 11328 10635 10603 10603
query12 126 79 75 75
query13 5598 711 689 689
query14 17718 13576 13245 13245
query15 368 241 248 241
query16 6474 283 267 267
query17 1538 1480 863 863
query18 2293 411 410 410
query19 216 154 155 154
query20 79 75 81 75
query21 194 100 94 94
query22 5304 5110 5111 5110
query23 32322 32061 32043 32043
query24 6993 6557 6457 6457
query25 526 435 427 427
query26 529 161 160 160
query27 1868 289 294 289
query28 6137 2361 2328 2328
query29 2976 2648 2731 2648
query30 243 166 176 166
query31 901 725 726 725
query32 73 59 60 59
query33 405 261 250 250
query34 855 477 473 473
query35 1124 936 912 912
query36 1288 1127 1247 1127
query37 95 59 59 59
query38 3103 2999 2976 2976
query39 1399 1365 1368 1365
query40 210 97 98 97
query41 48 47 45 45
query42 88 83 87 83
query43 788 747 681 681
query44 1166 762 755 755
query45 257 244 237 237
query46 1244 1013 996 996
query47 2025 1919 2019 1919
query48 1063 725 736 725
query49 616 388 365 365
query50 868 640 619 619
query51 4762 4564 4694 4564
query52 93 78 85 78
query53 447 336 319 319
query54 2662 2435 2473 2435
query55 90 84 88 84
query56 246 225 212 212
query57 1231 1166 1176 1166
query58 214 214 203 203
query59 4084 3688 3960 3688
query60 208 201 204 201
query61 100 95 120 95
query62 729 472 500 472
query63 484 336 349 336
query64 2470 1547 1453 1453
query65 3626 3544 3557 3544
query66 780 375 378 375
query67 15626 16647 15735 15735
query68 9225 651 652 651
query69 577 360 333 333
query70 1554 1560 1283 1283
query71 426 312 306 306
query72 6603 3481 3493 3481
query73 748 332 318 318
query74 6304 5860 5817 5817
query75 5357 3765 3765 3765
query76 5715 1148 1140 1140
query77 931 264 261 261
query78 12589 12310 11705 11705
query79 11129 649 645 645
query80 708 393 407 393
query81 485 243 229 229
query82 1152 96 94 94
query83 168 135 135 135
query84 258 71 73 71
query85 852 337 341 337
query86 346 293 285 285
query87 3294 3028 3077 3028
query88 4713 2299 2314 2299
query89 444 307 293 293
query90 1981 197 201 197
query91 167 151 137 137
query92 62 53 52 52
query93 5820 565 586 565
query94 724 209 210 209
query95 1097 1042 1045 1042
query96 654 334 331 331
query97 6453 6313 6399 6313
query98 196 176 169 169
query99 2921 928 867 867
Total cold run time: 314693 ms
Total hot run time: 204104 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) fix fe fold constant failed when using like function [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37863:
URL: https://github.com/apache/doris/pull/37863#issuecomment-2229873789
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