You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "eldenmoon (via GitHub)" <gi...@apache.org> on 2023/12/07 07:20:09 UTC
[PR] [Fix](variant) fallback to none partial update for mow table [doris]
eldenmoon opened a new pull request, #28116:
URL: https://github.com/apache/doris/pull/28116
## 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](variant) fallback to none partial update for mow table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28116:
URL: https://github.com/apache/doris/pull/28116#issuecomment-1845030336
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](variant) fallback to none partial update for mow table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28116:
URL: https://github.com/apache/doris/pull/28116#issuecomment-1844950055
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 8d4ecb27778c0df472fc9d600092648416bec186, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4747 4426 4474 4426
q2 369 148 158 148
q3 1473 1238 1219 1219
q4 1128 961 928 928
q5 3161 3200 3192 3192
q6 250 131 130 130
q7 1002 502 491 491
q8 2219 2240 2193 2193
q9 6680 6676 6661 6661
q10 3219 3245 3272 3245
q11 325 211 203 203
q12 356 221 217 217
q13 4536 3867 3840 3840
q14 242 212 217 212
q15 562 527 519 519
q16 445 385 385 385
q17 1003 594 580 580
q18 8275 7551 7365 7365
q19 1514 1420 1434 1420
q20 566 323 308 308
q21 3129 2710 2806 2710
q22 362 287 298 287
Total cold run time: 45563 ms
Total hot run time: 40679 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4413 4366 4388 4366
q2 267 164 169 164
q3 3533 3540 3533 3533
q4 2374 2369 2360 2360
q5 5732 5719 5728 5719
q6 241 120 124 120
q7 2370 1866 1889 1866
q8 3521 3512 3519 3512
q9 9036 9023 8978 8978
q10 3924 3995 4009 3995
q11 511 381 376 376
q12 776 596 585 585
q13 4326 3575 3543 3543
q14 281 261 252 252
q15 567 525 528 525
q16 502 484 457 457
q17 1865 1866 1868 1866
q18 8627 8477 8288 8288
q19 1716 1772 1746 1746
q20 2272 1947 1946 1946
q21 6522 6163 6179 6163
q22 493 434 420 420
Total cold run time: 63869 ms
Total hot run time: 60780 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](variant) fallback to none partial update for mow table [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon commented on PR #28116:
URL: https://github.com/apache/doris/pull/28116#issuecomment-1844801983
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](variant) fallback to none partial update for mow table [doris]
Posted by "qidaye (via GitHub)" <gi...@apache.org>.
qidaye merged PR #28116:
URL: https://github.com/apache/doris/pull/28116
--
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](variant) fallback to none partial update for mow table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28116:
URL: https://github.com/apache/doris/pull/28116#issuecomment-1844898238
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 43.47 seconds
stream load tsv: 584 seconds loaded 74807831229 Bytes, about 122 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: 34 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 29.2 seconds inserted 10000000 Rows, about 342K ops/s
storage size: 17194696702 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](variant) fallback to none partial update for mow table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28116:
URL: https://github.com/apache/doris/pull/28116#issuecomment-1845030265
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