You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "starocean999 (via GitHub)" <gi...@apache.org> on 2023/11/24 08:36:47 UTC
[PR] [fix](nereids)add HllUnion and BitmapUnion for pre agg match [doris]
starocean999 opened a new pull request, #27548:
URL: https://github.com/apache/doris/pull/27548
## 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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1825315196
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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1827078772
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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1835390075
better add test case to regression-test's mv_p0
--
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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1827154045
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 43.8 seconds
stream load tsv: 583 seconds loaded 74807831229 Bytes, about 122 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.8 seconds inserted 10000000 Rows, about 347K ops/s
storage size: 17157903960 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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #27548:
URL: https://github.com/apache/doris/pull/27548
--
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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1835388479
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)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1827154058
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 382c706eb8e16c733ebf5b839b420cbe63537422, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4917 4642 4658 4642
q2 360 155 164 155
q3 2045 1965 1924 1924
q4 1396 1258 1255 1255
q5 3955 3947 4059 3947
q6 253 128 129 128
q7 1452 868 887 868
q8 2804 2803 2787 2787
q9 9750 9436 9486 9436
q10 3450 3509 3533 3509
q11 389 246 246 246
q12 441 289 288 288
q13 4515 3826 3786 3786
q14 317 284 279 279
q15 576 526 525 525
q16 660 580 591 580
q17 1141 957 952 952
q18 7939 7527 7671 7527
q19 1686 1671 1693 1671
q20 571 289 299 289
q21 4473 4029 3998 3998
q22 463 359 372 359
Total cold run time: 53553 ms
Total hot run time: 49151 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4586 4565 4572 4565
q2 345 232 266 232
q3 4007 4005 4031 4005
q4 2740 2881 2787 2787
q5 9679 9715 9627 9627
q6 246 118 121 118
q7 3010 2470 2476 2470
q8 4499 4418 4511 4418
q9 12974 12898 12962 12898
q10 4023 4139 4161 4139
q11 784 685 662 662
q12 988 809 799 799
q13 4240 3561 3563 3561
q14 386 352 329 329
q15 564 522 523 522
q16 728 669 681 669
q17 3961 3825 3884 3825
q18 9758 9052 9141 9052
q19 1795 1785 1775 1775
q20 2380 2052 2065 2052
q21 8766 8714 8582 8582
q22 894 829 805 805
Total cold run time: 81353 ms
Total hot run time: 77892 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](nereids)add HllUnion and BitmapUnion for pre agg match [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27548:
URL: https://github.com/apache/doris/pull/27548#issuecomment-1835388506
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