You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "englefly (via GitHub)" <gi...@apache.org> on 2023/11/27 07:44:59 UTC
[PR] [fix](nereids)when range bounder is inifinte, range length should be POSITIVE_INFINITE [doris]
englefly opened a new pull request, #27624:
URL: https://github.com/apache/doris/pull/27624
## 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)when range bounder is inifinte, range length should be POSITIVE_INFINITE [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27624:
URL: https://github.com/apache/doris/pull/27624#issuecomment-1827542423
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 653d47c8ea7b803361606f3ac19f1fb09b25f3fc, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4929 4654 4640 4640
q2 363 153 158 153
q3 2033 1926 1943 1926
q4 1406 1263 1251 1251
q5 3986 3972 4028 3972
q6 257 133 131 131
q7 1408 896 877 877
q8 2802 2818 2778 2778
q9 9860 9592 9671 9592
q10 3486 3515 3529 3515
q11 381 248 234 234
q12 435 291 295 291
q13 4573 3852 3787 3787
q14 319 284 289 284
q15 578 530 531 530
q16 660 582 580 580
q17 1145 982 941 941
q18 7942 7629 7344 7344
q19 1684 1664 1692 1664
q20 556 305 286 286
q21 4474 4046 4055 4046
q22 471 377 385 377
Total cold run time: 53748 ms
Total hot run time: 49199 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4591 4589 4608 4589
q2 339 224 253 224
q3 4071 4030 4022 4022
q4 2721 2700 2717 2700
q5 9596 9716 9644 9644
q6 245 122 120 120
q7 3022 2487 2486 2486
q8 4486 4499 4493 4493
q9 13279 13225 13186 13186
q10 4063 4154 4127 4127
q11 788 632 640 632
q12 982 830 813 813
q13 4278 3592 3592 3592
q14 368 356 349 349
q15 573 515 508 508
q16 734 658 683 658
q17 3850 3903 3910 3903
q18 9718 9167 9151 9151
q19 1838 1807 1776 1776
q20 2407 2063 2043 2043
q21 8778 8701 8640 8640
q22 890 767 818 767
Total cold run time: 81617 ms
Total hot run time: 78423 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)when range bounder is inifinte, range length should be POSITIVE_INFINITE [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #27624:
URL: https://github.com/apache/doris/pull/27624#issuecomment-1827283692
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)when range bounder is inifinte, range length should be POSITIVE_INFINITE [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly closed pull request #27624: [fix](nereids)when range bounder is inifinte, range length should be POSITIVE_INFINITE
URL: https://github.com/apache/doris/pull/27624
--
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)when range bounder is inifinte, range length should be POSITIVE_INFINITE [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27624:
URL: https://github.com/apache/doris/pull/27624#issuecomment-1827499680
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.85 seconds
stream load tsv: 566 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 28 seconds loaded 2358488459 Bytes, about 80 MB/s
stream load orc: 70 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 34 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.8 seconds inserted 10000000 Rows, about 347K ops/s
storage size: 17099069457 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