You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "englefly (via GitHub)" <gi...@apache.org> on 2024/03/30 00:37:24 UTC
[PR] [fix](ut)fix createFunctionTest [doris]
englefly opened a new pull request, #33061:
URL: https://github.com/apache/doris/pull/33061
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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](ut)fix createFunctionTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #33061:
URL: https://github.com/apache/doris/pull/33061#issuecomment-2027860727
<details>
<summary>TPC-DS: <b>Total hot run time: 182907 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 32e820f842c51de2e2c5b04e9388e2462ead7019, data reload: false
query1 867 1121 1119 1119
query2 6995 2039 1936 1936
query3 6667 214 211 211
query4 25061 21515 21400 21400
query5 4280 412 408 408
query6 276 188 193 188
query7 4595 295 296 295
query8 233 175 178 175
query9 8405 2285 2278 2278
query10 434 236 260 236
query11 14900 14188 14230 14188
query12 140 93 90 90
query13 1664 369 371 369
query14 8809 6903 6927 6903
query15 208 173 174 173
query16 7194 268 265 265
query17 1383 597 559 559
query18 1501 297 277 277
query19 206 156 154 154
query20 93 91 87 87
query21 203 133 136 133
query22 5002 4848 4806 4806
query23 33205 32660 32629 32629
query24 11739 2907 2851 2851
query25 595 388 398 388
query26 823 160 160 160
query27 2917 370 373 370
query28 6198 1919 1897 1897
query29 884 628 638 628
query30 303 1072 149 149
query31 1044 756 752 752
query32 82 57 55 55
query33 588 241 253 241
query34 938 501 508 501
query35 850 720 717 717
query36 1093 910 933 910
query37 101 70 69 69
query38 3820 3611 3674 3611
query39 1616 1602 1615 1602
query40 194 136 139 136
query41 49 50 46 46
query42 105 107 103 103
query43 488 455 450 450
query44 1134 748 749 748
query45 298 267 279 267
query46 1119 729 714 714
query47 2008 1927 1947 1927
query48 390 303 302 302
query49 868 373 374 373
query50 818 405 399 399
query51 6959 6865 6892 6865
query52 108 93 94 93
query53 353 284 298 284
query54 304 244 255 244
query55 86 83 81 81
query56 253 243 233 233
query57 1289 1193 1182 1182
query58 239 212 216 212
query59 2978 2842 2707 2707
query60 252 235 235 235
query61 99 94 99 94
query62 591 443 425 425
query63 308 277 277 277
query64 4706 3863 4020 3863
query65 3130 3027 3040 3027
query66 801 331 335 331
query67 15358 15058 14994 14994
query68 7125 527 525 525
query69 537 312 311 311
query70 1237 1180 1162 1162
query71 465 275 266 266
query72 6824 2647 2471 2471
query73 730 325 323 323
query74 7080 6396 6455 6396
query75 3208 2332 2365 2332
query76 3956 906 1045 906
query77 571 257 253 253
query78 10896 10219 10087 10087
query79 8524 528 530 528
query80 1570 453 453 453
query81 517 224 219 219
query82 1596 96 94 94
query83 209 177 179 177
query84 272 89 88 88
query85 1303 323 319 319
query86 451 292 278 278
query87 3770 3506 3528 3506
query88 5473 2436 2396 2396
query89 547 369 371 369
query90 1766 180 180 180
query91 126 99 98 98
query92 57 53 47 47
query93 6668 509 513 509
query94 1162 185 187 185
query95 421 314 308 308
query96 613 278 270 270
query97 2661 2493 2450 2450
query98 235 221 214 214
query99 1156 795 864 795
Total cold run time: 292923 ms
Total hot run time: 182907 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](ut)fix createFunctionTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #33061:
URL: https://github.com/apache/doris/pull/33061#issuecomment-2027846559
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](ut)fix createFunctionTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #33061:
URL: https://github.com/apache/doris/pull/33061#issuecomment-2027857433
<details>
<summary>TPC-H: <b>Total hot run time: 38206 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 32e820f842c51de2e2c5b04e9388e2462ead7019, data reload: false
------ Round 1 ----------------------------------
q1 17620 4355 4221 4221
q2 2092 193 197 193
q3 10397 1137 1136 1136
q4 10195 784 761 761
q5 7452 2810 2697 2697
q6 216 132 132 132
q7 994 602 593 593
q8 9223 2047 2019 2019
q9 7674 6607 6562 6562
q10 8587 3480 3509 3480
q11 437 242 227 227
q12 456 224 219 219
q13 18802 2934 2958 2934
q14 266 244 234 234
q15 506 464 463 463
q16 518 386 374 374
q17 945 569 593 569
q18 7212 6715 6705 6705
q19 2987 1432 1500 1432
q20 660 308 306 306
q21 3423 2649 2808 2649
q22 359 300 307 300
Total cold run time: 111021 ms
Total hot run time: 38206 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4293 4205 4207 4205
q2 363 273 253 253
q3 2938 2679 2645 2645
q4 1824 1485 1470 1470
q5 5226 5154 5190 5154
q6 208 122 124 122
q7 2189 1855 1857 1855
q8 3202 3284 3266 3266
q9 8586 8528 8603 8528
q10 3906 4076 3806 3806
q11 581 498 500 498
q12 771 612 657 612
q13 16734 3146 3156 3146
q14 327 302 301 301
q15 542 485 494 485
q16 528 464 439 439
q17 1832 1496 1496 1496
q18 8120 7855 7779 7779
q19 1657 1577 1607 1577
q20 2039 1902 1867 1867
q21 8220 5041 4844 4844
q22 527 475 475 475
Total cold run time: 74613 ms
Total hot run time: 54823 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](ut)fix createFunctionTest [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #33061:
URL: https://github.com/apache/doris/pull/33061#issuecomment-2027846584
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](ut)fix createFunctionTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #33061:
URL: https://github.com/apache/doris/pull/33061#issuecomment-2027862115
<details>
<summary>ClickBench: <b>Total hot run time: 29.79 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 32e820f842c51de2e2c5b04e9388e2462ead7019, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.67 0.07 0.07
query5 0.50 0.50 0.52
query6 1.13 0.66 0.64
query7 0.01 0.01 0.02
query8 0.05 0.04 0.04
query9 0.54 0.51 0.50
query10 0.54 0.55 0.54
query11 0.16 0.09 0.11
query12 0.15 0.12 0.10
query13 0.58 0.58 0.58
query14 0.76 0.77 0.77
query15 0.83 0.81 0.82
query16 0.37 0.37 0.37
query17 0.98 0.95 0.97
query18 0.23 0.23 0.24
query19 1.73 1.70 1.65
query20 0.01 0.02 0.01
query21 15.54 0.63 0.63
query22 2.72 2.49 2.16
query23 17.16 0.96 0.82
query24 1.13 0.24 0.21
query25 0.09 0.08 0.08
query26 0.24 0.17 0.16
query27 0.07 0.08 0.07
query28 14.10 0.93 0.92
query29 12.55 3.16 3.17
query30 0.27 0.09 0.08
query31 2.83 0.37 0.38
query32 3.33 0.46 0.45
query33 2.83 2.77 2.81
query34 16.47 4.44 4.41
query35 4.46 4.50 4.46
query36 0.60 0.47 0.46
query37 0.19 0.15 0.15
query38 0.15 0.14 0.14
query39 0.05 0.03 0.04
query40 0.18 0.15 0.14
query41 0.09 0.05 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 105.73 s
Total hot run time: 29.79 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](ut)fix createFunctionTest [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #33061:
URL: https://github.com/apache/doris/pull/33061#issuecomment-2027862724
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 32e820f842c51de2e2c5b04e9388e2462ead7019 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.6 seconds inserted 10000000 Rows, about 735K 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](ut)fix createFunctionTest [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly closed pull request #33061: [fix](ut)fix createFunctionTest
URL: https://github.com/apache/doris/pull/33061
--
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