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/12/15 03:11:11 UTC
[PR] [fix](Nereids) stats estimation of lessThan [doris]
englefly opened a new pull request, #28444:
URL: https://github.com/apache/doris/pull/28444
## 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) stats estimation of lessThan [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly merged PR #28444:
URL: https://github.com/apache/doris/pull/28444
--
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) stats estimation of lessThan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28444:
URL: https://github.com/apache/doris/pull/28444#issuecomment-1860634856
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) stats estimation of lessThan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28444:
URL: https://github.com/apache/doris/pull/28444#issuecomment-1858699476
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit a1454bf86018c7be4b27070be5e62013c8328223, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4711 4455 4454 4454
q2 362 157 155 155
q3 1453 1262 1236 1236
q4 1106 930 916 916
q5 3213 3204 3204 3204
q6 244 129 126 126
q7 1020 484 482 482
q8 2196 2221 2194 2194
q9 6744 6678 6644 6644
q10 3225 3303 3308 3303
q11 327 199 197 197
q12 363 208 202 202
q13 4584 3797 3795 3795
q14 240 210 215 210
q15 568 525 528 525
q16 441 384 387 384
q17 1004 644 572 572
q18 7039 6768 6884 6768
q19 1557 1497 1396 1396
q20 563 299 286 286
q21 3066 2623 2620 2620
q22 355 281 288 281
Total cold run time: 44381 ms
Total hot run time: 39950 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4392 4357 4413 4357
q2 263 164 171 164
q3 3522 3510 3495 3495
q4 2393 2390 2371 2371
q5 5746 5726 5750 5726
q6 239 121 124 121
q7 2374 1828 1857 1828
q8 3526 3531 3533 3531
q9 9068 8994 8994 8994
q10 3919 4012 4016 4012
q11 505 399 396 396
q12 767 596 584 584
q13 4311 3577 3554 3554
q14 295 256 261 256
q15 574 516 520 516
q16 508 460 453 453
q17 1866 1863 1829 1829
q18 8474 8154 8290 8154
q19 1750 1754 1785 1754
q20 2250 1959 1937 1937
q21 6519 6161 6119 6119
q22 501 436 432 432
Total cold run time: 63762 ms
Total hot run time: 60583 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) stats estimation of lessThan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28444:
URL: https://github.com/apache/doris/pull/28444#issuecomment-1858690780
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.07 seconds
stream load tsv: 585 seconds loaded 74807831229 Bytes, about 121 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.5 seconds inserted 10000000 Rows, about 350K ops/s
storage size: 17224350748 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) stats estimation of lessThan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28444:
URL: https://github.com/apache/doris/pull/28444#issuecomment-1860634768
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) stats estimation of lessThan [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #28444:
URL: https://github.com/apache/doris/pull/28444#issuecomment-1858679777
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