You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "jackwener (via GitHub)" <gi...@apache.org> on 2023/11/09 06:37:37 UTC
[PR] [fix](Nereids): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
jackwener opened a new pull request, #26641:
URL: https://github.com/apache/doris/pull/26641
## 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](Nereids): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26641:
URL: https://github.com/apache/doris/pull/26641#issuecomment-1803283375
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.05 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: 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.5 seconds inserted 10000000 Rows, about 338K ops/s
storage size: 17162336472 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](Nereids): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26641:
URL: https://github.com/apache/doris/pull/26641#issuecomment-1803427356
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): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26641:
URL: https://github.com/apache/doris/pull/26641#issuecomment-1803432735
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): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener commented on PR #26641:
URL: https://github.com/apache/doris/pull/26641#issuecomment-1803243928
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): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener merged PR #26641:
URL: https://github.com/apache/doris/pull/26641
--
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): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "jackwener (via GitHub)" <gi...@apache.org>.
jackwener commented on PR #26641:
URL: https://github.com/apache/doris/pull/26641#issuecomment-1803258909
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): skip OptimizeGroupExpressionJob if groupExpression is unused [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26641:
URL: https://github.com/apache/doris/pull/26641#issuecomment-1803273130
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 120c3081b7ee447e771b6ea2a43d7407d83f8785, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5246 5019 5136 5019
q2 368 179 237 179
q3 2083 2005 2032 2005
q4 1461 1418 1417 1417
q5 4150 4155 4084 4084
q6 255 130 129 129
q7 2078 1597 1609 1597
q8 2736 2736 2731 2731
q9 10332 10281 10155 10155
q10 3503 3566 3582 3566
q11 373 258 251 251
q12 446 293 293 293
q13 4506 4065 4064 4064
q14 317 283 288 283
q15 611 553 581 553
q16 699 617 591 591
q17 1144 1082 1059 1059
q18 7906 7471 7502 7471
q19 1676 1690 1680 1680
q20 580 364 375 364
q21 4905 4531 4569 4531
q22 543 431 422 422
Total cold run time: 55918 ms
Total hot run time: 52444 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5014 4923 5128 4923
q2 335 243 271 243
q3 4016 3973 3980 3973
q4 2785 2741 2741 2741
q5 6541 6489 6479 6479
q6 236 119 125 119
q7 3162 2761 2723 2723
q8 4790 4769 4735 4735
q9 17799 17676 17758 17676
q10 4136 4187 4185 4185
q11 733 673 639 639
q12 986 826 811 811
q13 4325 3863 3865 3863
q14 383 343 350 343
q15 595 544 562 544
q16 819 696 664 664
q17 3923 3900 4033 3900
q18 9401 9373 9358 9358
q19 1886 1783 1779 1779
q20 2375 2054 2053 2053
q21 8916 8834 8655 8655
q22 971 868 887 868
Total cold run time: 84127 ms
Total hot run time: 81274 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