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/27 08:49:38 UTC
[PR] [fix](nereids)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
starocean999 opened a new pull request, #29143:
URL: https://github.com/apache/doris/pull/29143
## 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)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29143:
URL: https://github.com/apache/doris/pull/29143#issuecomment-1871796725
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)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #29143:
URL: https://github.com/apache/doris/pull/29143#issuecomment-1870084772
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)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29143:
URL: https://github.com/apache/doris/pull/29143#issuecomment-1870111477
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.36 seconds
stream load tsv: 565 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: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 29.7 seconds inserted 10000000 Rows, about 336K ops/s
storage size: 17183628853 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)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #29143:
URL: https://github.com/apache/doris/pull/29143
--
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)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29143:
URL: https://github.com/apache/doris/pull/29143#issuecomment-1871796707
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)FillUpMissingSlots rule didn't process standalone having clause correctly [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29143:
URL: https://github.com/apache/doris/pull/29143#issuecomment-1870121286
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Tpch sf100 test result on commit d30175a56a725242b038d0798b5ad0659b6715ea, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4955 4641 4610 4610
q2 366 158 157 157
q3 1482 1305 1238 1238
q4 1141 939 919 919
q5 3203 3165 3159 3159
q6 247 128 128 128
q7 1007 497 478 478
q8 2250 2253 2252 2252
q9 6752 6688 6692 6688
q10 3171 3262 3263 3262
q11 326 211 208 208
q12 348 205 207 205
q13 4157 3429 3417 3417
q14 236 217 214 214
q15 573 519 526 519
q16 445 379 392 379
q17 1039 808 686 686
q18 7158 6938 6806 6806
q19 1639 1651 1647 1647
q20 570 330 317 317
q21 3162 2703 2764 2703
q22 376 312 314 312
Total cold run time: 44603 ms
Total hot run time: 40304 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4570 4558 4566 4558
q2 270 164 167 164
q3 3375 3357 3368 3357
q4 2233 2214 2209 2209
q5 5707 5729 5723 5723
q6 240 117 120 117
q7 2373 1835 1860 1835
q8 3608 3626 3614 3614
q9 9040 8983 8972 8972
q10 3816 3897 3914 3897
q11 478 367 349 349
q12 770 596 624 596
q13 3905 3204 3201 3201
q14 283 260 258 258
q15 569 519 514 514
q16 503 469 466 466
q17 1975 1960 1959 1959
q18 8839 8133 8204 8133
q19 1770 1766 1773 1766
q20 2246 1933 1919 1919
q21 6148 5792 5724 5724
q22 553 453 499 453
Total cold run time: 63271 ms
Total hot run time: 59784 ms
```
--
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