You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "w41ter (via GitHub)" <gi...@apache.org> on 2023/11/17 07:56:40 UTC
[PR] [refactor](planner) filter empty partitions in a unified location [doris]
w41ter opened a new pull request, #27190:
URL: https://github.com/apache/doris/pull/27190
(no comment)
--
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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27190:
URL: https://github.com/apache/doris/pull/27190#issuecomment-1816064061
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit c2359373e545a4144d6497f9e72aaf92063b654e, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5007 4697 4716 4697
q2 363 153 159 153
q3 2048 1949 1958 1949
q4 1407 1260 1247 1247
q5 3995 3979 4051 3979
q6 256 130 137 130
q7 1400 885 878 878
q8 2790 2830 2826 2826
q9 9811 9784 9709 9709
q10 3481 3557 3546 3546
q11 383 258 246 246
q12 447 299 302 299
q13 4579 3825 3802 3802
q14 323 296 305 296
q15 600 530 518 518
q16 669 590 588 588
q17 1141 951 922 922
q18 7783 7442 7335 7335
q19 1677 1679 1697 1679
q20 572 292 300 292
q21 4455 4041 4072 4041
q22 470 374 375 374
Total cold run time: 53657 ms
Total hot run time: 49506 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4611 4598 4590 4590
q2 355 224 268 224
q3 4026 4013 4024 4013
q4 2725 2716 2712 2712
q5 9654 9645 9670 9645
q6 250 125 127 125
q7 2612 2295 2317 2295
q8 4473 4501 4511 4501
q9 13216 13112 13102 13102
q10 4115 4210 4193 4193
q11 774 682 662 662
q12 971 800 809 800
q13 4309 3605 3635 3605
q14 374 356 359 356
q15 580 525 524 524
q16 733 665 661 661
q17 3877 3901 3952 3901
q18 9508 9096 9104 9096
q19 1828 1811 1785 1785
q20 2391 2079 2050 2050
q21 8923 8777 8741 8741
q22 883 802 834 802
Total cold run time: 81188 ms
Total hot run time: 78383 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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27190:
URL: https://github.com/apache/doris/pull/27190#issuecomment-1815953778
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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #27190:
URL: https://github.com/apache/doris/pull/27190#issuecomment-1815896125
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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #27190:
URL: https://github.com/apache/doris/pull/27190
--
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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27190:
URL: https://github.com/apache/doris/pull/27190#issuecomment-1815953827
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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27190:
URL: https://github.com/apache/doris/pull/27190#issuecomment-1816058165
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.47 seconds
stream load tsv: 585 seconds loaded 74807831229 Bytes, about 121 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 34 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.0 seconds inserted 10000000 Rows, about 357K ops/s
storage size: 17099823702 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] [refactor](planner) filter empty partitions in a unified location [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #27190:
URL: https://github.com/apache/doris/pull/27190#issuecomment-1815896567
add desc please
--
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