You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "mrhhsg (via GitHub)" <gi...@apache.org> on 2023/12/13 12:33:49 UTC
[PR] [fix](function) bad performance caused by creating Status::RuntimeError [doris]
mrhhsg opened a new pull request, #28362:
URL: https://github.com/apache/doris/pull/28362
## Proposed changes
Performance issue imported by #28219
## 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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28362:
URL: https://github.com/apache/doris/pull/28362#issuecomment-1853847359
clang-tidy review says "All clean, LGTM! :+1:"
--
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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28362:
URL: https://github.com/apache/doris/pull/28362#issuecomment-1853916406
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.02 seconds
stream load tsv: 588 seconds loaded 74807831229 Bytes, about 121 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 67 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 29.2 seconds inserted 10000000 Rows, about 342K ops/s
storage size: 17219361985 Bytes
--
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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28362:
URL: https://github.com/apache/doris/pull/28362#issuecomment-1853987005
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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28362:
URL: https://github.com/apache/doris/pull/28362#issuecomment-1853969269
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 83a5b828e0b7f24ad2032e6cb9c80bfc3e74d87b, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4736 4497 4498 4497
q2 358 156 159 156
q3 1461 1214 1248 1214
q4 1119 936 872 872
q5 3178 3179 3208 3179
q6 243 125 128 125
q7 997 483 484 483
q8 2183 2221 2190 2190
q9 6693 6672 6686 6672
q10 3215 3278 3293 3278
q11 327 209 199 199
q12 356 206 204 204
q13 4548 3776 3752 3752
q14 248 212 212 212
q15 575 517 528 517
q16 436 403 396 396
q17 1001 653 582 582
q18 7657 6947 6952 6947
q19 1585 1453 1262 1262
q20 528 345 306 306
q21 3102 2606 2624 2606
q22 345 279 282 279
Total cold run time: 44891 ms
Total hot run time: 39928 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4433 4419 4396 4396
q2 270 163 170 163
q3 3507 3503 3503 3503
q4 2403 2390 2392 2390
q5 5737 5744 5765 5744
q6 236 119 119 119
q7 2384 1859 1864 1859
q8 3529 3528 3526 3526
q9 9036 9046 9028 9028
q10 3927 4009 4019 4009
q11 506 382 384 382
q12 763 586 615 586
q13 4308 3570 3546 3546
q14 295 252 264 252
q15 572 523 530 523
q16 488 430 463 430
q17 1904 1848 1846 1846
q18 8573 8111 8113 8111
q19 1735 1722 1756 1722
q20 2263 1941 1938 1938
q21 6470 6143 6130 6130
q22 497 410 436 410
Total cold run time: 63836 ms
Total hot run time: 60613 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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28362:
URL: https://github.com/apache/doris/pull/28362#issuecomment-1853987089
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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #28362:
URL: https://github.com/apache/doris/pull/28362
--
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](function) bad performance caused by creating Status::RuntimeError [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #28362:
URL: https://github.com/apache/doris/pull/28362#issuecomment-1853836838
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