You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "XieJiann (via GitHub)" <gi...@apache.org> on 2023/11/09 09:54:57 UTC
[PR] [enhancement](Nereids) add phase in shape string [doris]
XieJiann opened a new pull request, #26682:
URL: https://github.com/apache/doris/pull/26682
## 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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1803565215
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45 seconds
stream load tsv: 552 seconds loaded 74807831229 Bytes, about 129 MB/s
stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17162293597 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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805069095
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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1804986656
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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1804985878
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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805112978
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.2 seconds
stream load tsv: 555 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17162223639 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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805052221
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 0d5bd4dcf862fd23437869e0a239b599e95249e1, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5334 5063 5137 5063
q2 377 178 202 178
q3 2101 2071 2067 2067
q4 1489 1433 1404 1404
q5 4162 4189 4163 4163
q6 260 134 134 134
q7 2089 1600 1615 1600
q8 2804 2761 2770 2761
q9 10389 10555 10197 10197
q10 3493 3560 3577 3560
q11 373 260 254 254
q12 463 294 303 294
q13 4554 4110 4125 4110
q14 339 296 284 284
q15 667 555 554 554
q16 701 622 600 600
q17 1158 1115 1113 1113
q18 7775 7186 7454 7186
q19 1732 1710 1715 1710
q20 594 381 352 352
q21 4942 4578 4554 4554
q22 546 432 448 432
Total cold run time: 56342 ms
Total hot run time: 52570 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5112 5261 5030 5030
q2 349 244 258 244
q3 4113 3985 3957 3957
q4 2779 2776 2755 2755
q5 6528 6470 6480 6470
q6 255 126 132 126
q7 3170 2740 2707 2707
q8 4789 4727 4768 4727
q9 17742 17620 17702 17620
q10 4102 4134 4204 4134
q11 785 652 678 652
q12 1013 842 803 803
q13 4352 3882 3867 3867
q14 380 350 358 350
q15 624 592 569 569
q16 766 699 735 699
q17 3998 3906 3904 3904
q18 9527 9401 9351 9351
q19 1832 1784 1793 1784
q20 2365 2054 2069 2054
q21 8978 8866 8782 8782
q22 930 902 872 872
Total cold run time: 84489 ms
Total hot run time: 81457 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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805138564
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit af83145f67aabc5a7a26966af1a6831f0d6758a0, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5290 5102 5136 5102
q2 367 187 194 187
q3 2090 2050 2087 2050
q4 1488 1436 1437 1436
q5 4143 4185 4163 4163
q6 259 132 131 131
q7 2081 1615 1601 1601
q8 2773 2762 2782 2762
q9 10398 10384 10291 10291
q10 3491 3579 3572 3572
q11 376 251 261 251
q12 468 298 307 298
q13 4562 4119 4146 4119
q14 322 297 296 296
q15 661 554 572 554
q16 703 626 597 597
q17 1170 1105 1112 1105
q18 7892 7394 7225 7225
q19 1730 1715 1720 1715
q20 595 380 346 346
q21 4943 4628 4613 4613
q22 541 430 450 430
Total cold run time: 56343 ms
Total hot run time: 52844 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4989 4944 5102 4944
q2 329 229 253 229
q3 4012 4076 3961 3961
q4 2799 2756 2732 2732
q5 6543 6532 6521 6521
q6 247 129 125 125
q7 3166 2752 2712 2712
q8 4785 4763 4771 4763
q9 17769 17742 17639 17639
q10 4084 4152 4170 4152
q11 775 629 660 629
q12 1003 862 807 807
q13 4293 3918 3893 3893
q14 384 347 374 347
q15 651 558 598 558
q16 772 699 688 688
q17 3851 3854 3884 3854
q18 9342 9338 9113 9113
q19 1877 1805 1808 1805
q20 2370 2041 2041 2041
q21 9014 8886 8939 8886
q22 915 850 877 850
Total cold run time: 83970 ms
Total hot run time: 81249 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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805173583
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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805058892
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.2 seconds
stream load tsv: 551 seconds loaded 74807831229 Bytes, about 129 MB/s
stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 29.0 seconds inserted 10000000 Rows, about 344K ops/s
storage size: 17162257975 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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1803508688
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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26682:
URL: https://github.com/apache/doris/pull/26682#issuecomment-1805173551
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] [enhancement](Nereids) add phase in shape string [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener merged PR #26682:
URL: https://github.com/apache/doris/pull/26682
--
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