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/12/13 02:54:01 UTC
[PR] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
starocean999 opened a new pull request, #28316:
URL: https://github.com/apache/doris/pull/28316
## 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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1867123380
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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1853211690
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit f9a7e3d47017356847ccd45a722b997958c21f30, data reload: false
run tpch-sf100 query with default conf and session variables
q1 51491 31817 31843 31817
q2 383 137 141 137
q3 1576 1250 1240 1240
q4 1109 930 876 876
q5 3175 3183 3223 3183
q6 266 144 143 143
q7 1048 496 481 481
q8 2144 2207 2179 2179
q9 6963 6989 6889 6889
q10 3273 3294 3304 3294
q11 340 222 200 200
q12 359 203 206 203
q13 4591 4108 3815 3815
q14 437 316 319 316
q15 776 1307 1365 1307
q16 444 390 387 387
q17 1013 563 554 554
q18 7455 7300 6897 6897
q19 1513 1324 1459 1324
q20 590 317 313 313
q21 3071 2625 2683 2625
q22 357 285 289 285
Total cold run time: 92374 ms
Total hot run time: 68465 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 30806 31836 31808 31808
q2 276 165 169 165
q3 3668 3668 3617 3617
q4 2413 2386 2380 2380
q5 5807 5802 5821 5802
q6 243 131 131 131
q7 3056 3401 3381 3381
q8 3538 3528 3543 3528
q9 9243 9250 9190 9190
q10 3997 4035 4063 4035
q11 802 921 1348 921
q12 767 593 608 593
q13 4321 3561 3580 3561
q14 491 424 435 424
q15 1157 1348 1315 1315
q16 505 472 471 471
q17 1892 1866 1842 1842
q18 8847 8235 8206 8206
q19 1757 1779 1760 1760
q20 2897 2612 2707 2612
q21 6578 6185 6178 6178
q22 516 401 430 401
Total cold run time: 93577 ms
Total hot run time: 92321 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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1853186453
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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1853212915
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.27 seconds
stream load tsv: 590 seconds loaded 74807831229 Bytes, about 120 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 29.0 seconds inserted 10000000 Rows, about 344K ops/s
storage size: 17219679322 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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1867152158
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.88 seconds
stream load tsv: 564 seconds loaded 74807831229 Bytes, about 126 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.7 seconds inserted 10000000 Rows, about 348K ops/s
storage size: 17183770081 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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1853188849
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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28316:
URL: https://github.com/apache/doris/pull/28316#issuecomment-1853188871
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] [enhancement](nereids)convert or to inpredicate and optimize inpredicate partition prune [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #28316:
URL: https://github.com/apache/doris/pull/28316
--
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