You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "bobhan1 (via GitHub)" <gi...@apache.org> on 2023/11/10 10:38:12 UTC
[PR] [Coverage](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
bobhan1 opened a new pull request, #26776:
URL: https://github.com/apache/doris/pull/26776
## Proposed 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] [Coverage](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1805595624
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] [Coverage](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1805530087
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.22 seconds
stream load tsv: 555 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 22 seconds loaded 2358488459 Bytes, about 102 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.8 seconds inserted 10000000 Rows, about 347K ops/s
storage size: 17162409837 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] [Coverage](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1805483052
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] [regression](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1806750569
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit e809fd984d9e89927868272b7d049c180fcc3c82, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5316 5097 5234 5097
q2 365 190 177 177
q3 2075 2090 2053 2053
q4 1473 1438 1437 1437
q5 4132 4163 4106 4106
q6 253 140 136 136
q7 2090 1602 1613 1602
q8 2761 2751 2764 2751
q9 10321 10222 10122 10122
q10 3480 3578 3556 3556
q11 377 257 256 256
q12 474 304 294 294
q13 4519 4116 4118 4116
q14 323 304 293 293
q15 615 564 592 564
q16 700 618 597 597
q17 1151 1113 1063 1063
q18 7841 7363 7353 7353
q19 1691 1712 1693 1693
q20 596 357 363 357
q21 4937 4565 4568 4565
q22 542 435 434 434
Total cold run time: 56032 ms
Total hot run time: 52622 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4998 5052 5004 5004
q2 352 258 255 255
q3 4010 3992 3989 3989
q4 2785 2747 2742 2742
q5 6535 6413 6545 6413
q6 246 127 133 127
q7 3150 2711 2752 2711
q8 4782 4822 4830 4822
q9 17740 17733 17689 17689
q10 4107 4169 4162 4162
q11 772 661 657 657
q12 1010 813 805 805
q13 4306 3896 3887 3887
q14 375 354 367 354
q15 647 571 555 555
q16 801 673 698 673
q17 3895 3891 3903 3891
q18 9450 9009 9083 9009
q19 1894 1763 1772 1763
q20 2383 2040 2039 2039
q21 8869 8663 8781 8663
q22 893 893 865 865
Total cold run time: 84000 ms
Total hot run time: 81075 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] [regression](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "zhannngchen (via GitHub)" <gi...@apache.org>.
zhannngchen merged PR #26776:
URL: https://github.com/apache/doris/pull/26776
--
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] [Coverage](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1805528733
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 5c45b720959f5d8dae79434535c6725f7313d78d, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5198 5130 5127 5127
q2 372 200 201 200
q3 2102 2063 2040 2040
q4 1475 1417 1417 1417
q5 4156 4159 4173 4159
q6 253 134 130 130
q7 2089 1598 1588 1588
q8 2795 2766 2780 2766
q9 38214 10580 10281 10281
q10 11579 3556 3542 3542
q11 368 259 249 249
q12 514 296 299 296
q13 10715 3988 4121 3988
q14 326 312 305 305
q15 641 572 572 572
q16 688 618 595 595
q17 1154 1090 1097 1090
q18 7748 7385 7436 7385
q19 1735 1716 1709 1709
q20 596 372 353 353
q21 5997 4628 4589 4589
q22 530 436 435 435
Total cold run time: 99245 ms
Total hot run time: 52816 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5073 5099 5022 5022
q2 344 263 249 249
q3 4000 3957 3974 3957
q4 2824 2740 2745 2740
q5 6461 6437 6491 6437
q6 246 136 133 133
q7 3147 2788 2659 2659
q8 4838 4782 4773 4773
q9 17753 17763 17562 17562
q10 4066 4164 4199 4164
q11 743 680 659 659
q12 991 794 818 794
q13 4283 3853 3891 3853
q14 398 367 341 341
q15 634 555 581 555
q16 796 763 730 730
q17 3870 3805 3923 3805
q18 9459 9211 9204 9204
q19 1921 1791 1795 1791
q20 2400 2066 2020 2020
q21 8837 8696 8618 8618
q22 945 840 876 840
Total cold run time: 84029 ms
Total hot run time: 80906 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] [regression](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1806737150
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] [Coverage](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1805595585
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] [regression](partial update) Add cases when the deleted rows have non nullable columns without default value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26776:
URL: https://github.com/apache/doris/pull/26776#issuecomment-1806752822
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.61 seconds
stream load tsv: 554 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 21 seconds loaded 2358488459 Bytes, about 107 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17162336337 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