You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "TangSiyang2001 (via GitHub)" <gi...@apache.org> on 2023/11/14 12:00:35 UTC
[PR] [fix](statistics) fix updated rows incorrect due to typo in code [doris]
TangSiyang2001 opened a new pull request, #26979:
URL: https://github.com/apache/doris/pull/26979
## Proposed changes
As title.
--
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810078707
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811930087
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.27 seconds
stream load tsv: 554 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 64 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.9 seconds inserted 10000000 Rows, about 358K ops/s
storage size: 17096825872 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1812153414
run feut
--
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811964611
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1812153930
run external
--
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810073268
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811666154
Added case should be modified, I'll add modification later.
--
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810526136
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810131913
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810078645
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810153143
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.92 seconds
stream load tsv: 554 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.2 seconds inserted 10000000 Rows, about 354K ops/s
storage size: 17096212218 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810386654
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 50baf9748af7570c1901298da7eaf79fd42ca9ca, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5239 5141 5097 5097
q2 361 162 163 162
q3 2029 2020 1995 1995
q4 1402 1369 1341 1341
q5 3990 3963 4007 3963
q6 253 132 132 132
q7 1487 894 899 894
q8 2793 2777 2775 2775
q9 9855 9607 9525 9525
q10 3454 3505 3527 3505
q11 390 252 259 252
q12 435 279 284 279
q13 4600 4176 4126 4126
q14 324 281 285 281
q15 629 562 551 551
q16 670 598 584 584
q17 1136 1101 1101 1101
q18 8106 7632 7617 7617
q19 1652 1689 1680 1680
q20 531 306 307 306
q21 4699 4365 4384 4365
q22 515 415 421 415
Total cold run time: 54550 ms
Total hot run time: 50946 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5156 5058 5059 5058
q2 343 228 244 228
q3 4077 4067 3992 3992
q4 2793 2793 2792 2792
q5 9727 9579 9674 9579
q6 243 124 127 124
q7 3063 2534 2519 2519
q8 4866 4832 4808 4808
q9 13287 13125 13248 13125
q10 4084 4193 4160 4160
q11 788 663 653 653
q12 980 878 856 856
q13 4313 3909 3894 3894
q14 372 349 346 346
q15 582 555 562 555
q16 783 701 682 682
q17 4006 3878 3944 3878
q18 9744 9541 9652 9541
q19 1831 1789 1766 1766
q20 2426 2078 2046 2046
q21 9011 8648 8849 8648
q22 944 833 870 833
Total cold run time: 83419 ms
Total hot run time: 80083 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811776156
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.91 seconds
stream load tsv: 556 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 28.3 seconds inserted 10000000 Rows, about 353K ops/s
storage size: 17097644356 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1810336952
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 5acd952804da3627974aa0d32897cfcbe76dbe61, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5270 5132 5211 5132
q2 358 166 161 161
q3 2035 2029 2027 2027
q4 1408 1350 1336 1336
q5 3941 3952 4008 3952
q6 257 132 122 122
q7 1493 890 888 888
q8 2779 2782 2749 2749
q9 9695 9514 9530 9514
q10 3454 3537 3539 3537
q11 391 239 261 239
q12 437 276 287 276
q13 4570 4154 4125 4125
q14 306 287 290 287
q15 624 557 561 557
q16 680 598 593 593
q17 1126 1096 1096 1096
q18 8026 7634 7659 7634
q19 1677 1685 1673 1673
q20 586 333 285 285
q21 4693 4349 4355 4349
q22 524 409 396 396
Total cold run time: 54330 ms
Total hot run time: 50928 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5053 5055 5070 5055
q2 327 228 224 224
q3 4035 4031 3985 3985
q4 2780 2745 2758 2745
q5 9637 9642 9631 9631
q6 246 126 124 124
q7 3079 2491 2469 2469
q8 4898 4821 4802 4802
q9 13373 13259 13154 13154
q10 4070 4170 4182 4170
q11 811 656 661 656
q12 1004 832 834 832
q13 4296 3868 3884 3868
q14 379 341 362 341
q15 607 559 540 540
q16 742 679 693 679
q17 3920 3837 3913 3837
q18 9612 9311 9344 9311
q19 1789 1808 1766 1766
q20 2418 2064 2041 2041
q21 8848 8780 8846 8780
q22 910 889 812 812
Total cold run time: 82834 ms
Total hot run time: 79822 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811782210
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 57a5649e8926cbc4964a73104e7e8ca5b049a858, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5268 5136 5187 5136
q2 371 151 155 151
q3 2046 2015 2003 2003
q4 1413 1381 1374 1374
q5 3942 3965 3969 3965
q6 259 129 131 129
q7 1464 895 909 895
q8 2782 2791 2767 2767
q9 9708 9595 9734 9595
q10 3479 3538 3552 3538
q11 387 251 265 251
q12 437 290 292 290
q13 4575 4118 4127 4118
q14 315 281 301 281
q15 655 542 526 526
q16 690 588 597 588
q17 1142 1078 1084 1078
q18 7986 7543 7667 7543
q19 1673 1680 1658 1658
q20 571 290 281 281
q21 4682 4368 4357 4357
q22 507 411 389 389
Total cold run time: 54352 ms
Total hot run time: 50913 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5075 5055 5005 5005
q2 323 218 222 218
q3 4109 4001 4013 4001
q4 2840 2785 2778 2778
q5 9644 9669 9699 9669
q6 246 123 124 123
q7 3078 2508 2500 2500
q8 4831 4874 4878 4874
q9 13247 13157 13126 13126
q10 4098 4159 4168 4159
q11 806 666 645 645
q12 984 833 846 833
q13 4315 3886 3857 3857
q14 390 354 333 333
q15 601 537 517 517
q16 753 673 691 673
q17 3909 3863 3952 3863
q18 9567 9467 9509 9467
q19 1837 1771 1760 1760
q20 2389 2039 2085 2039
q21 8771 8745 8857 8745
q22 963 828 831 828
Total cold run time: 82776 ms
Total hot run time: 80013 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #26979:
URL: https://github.com/apache/doris/pull/26979
--
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811823247
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1812186372
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1812151796
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 6b28f62c64b5343cebfa70fe645d2620a6108cac, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5326 5044 5107 5044
q2 354 161 158 158
q3 2037 1930 1910 1910
q4 1391 1284 1252 1252
q5 3950 3938 4021 3938
q6 254 129 136 129
q7 1387 884 906 884
q8 2752 2770 2758 2758
q9 17876 9625 9654 9625
q10 3457 3504 3497 3497
q11 391 257 243 243
q12 457 277 285 277
q13 4591 3815 3825 3815
q14 315 282 285 282
q15 597 535 571 535
q16 670 595 575 575
q17 1125 986 949 949
q18 7877 7431 7394 7394
q19 1676 1675 1662 1662
q20 521 322 306 306
q21 4503 4022 4020 4020
q22 522 407 412 407
Total cold run time: 62029 ms
Total hot run time: 49660 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5070 4958 5069 4958
q2 320 222 232 222
q3 4016 3985 3966 3966
q4 2818 2797 2749 2749
q5 9515 9534 9582 9534
q6 247 128 126 126
q7 2683 2283 2267 2267
q8 4884 4866 4856 4856
q9 13207 13152 13048 13048
q10 4081 4178 4183 4178
q11 764 662 669 662
q12 978 825 850 825
q13 4295 3598 3561 3561
q14 388 342 340 340
q15 602 522 550 522
q16 751 658 687 658
q17 3883 3930 3840 3840
q18 9513 8992 8844 8844
q19 1838 1794 1778 1778
q20 2395 2061 2052 2052
q21 8705 8538 8384 8384
q22 914 901 882 882
Total cold run time: 81867 ms
Total hot run time: 78252 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811690906
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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1811918618
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit d9f8528fca0186b0cc217a857071fa4955db8bca, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5251 5145 5059 5059
q2 370 144 159 144
q3 2047 1997 2003 1997
q4 1396 1358 1364 1358
q5 3995 3989 4043 3989
q6 251 133 133 133
q7 1482 874 898 874
q8 2776 2794 2768 2768
q9 9943 9789 9549 9549
q10 3485 3543 3545 3543
q11 377 259 250 250
q12 429 281 289 281
q13 4588 4123 4118 4118
q14 319 285 282 282
q15 632 557 531 531
q16 674 588 587 587
q17 1143 1097 1077 1077
q18 7989 7545 7630 7545
q19 1685 1680 1686 1680
q20 554 304 313 304
q21 4705 4321 4382 4321
q22 521 412 405 405
Total cold run time: 54612 ms
Total hot run time: 50795 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4999 5018 5053 5018
q2 327 217 227 217
q3 4040 4019 4025 4019
q4 2770 2770 2744 2744
q5 9647 9619 9620 9619
q6 247 120 122 120
q7 3047 2466 2491 2466
q8 4879 4842 4828 4828
q9 13255 13105 13158 13105
q10 4104 4182 4188 4182
q11 790 680 676 676
q12 976 851 825 825
q13 4297 3908 3834 3834
q14 379 351 349 349
q15 592 536 557 536
q16 762 695 681 681
q17 3831 3937 3910 3910
q18 9687 9466 9280 9280
q19 1827 1775 1782 1775
q20 2411 2052 2043 2043
q21 8901 8843 8550 8550
q22 908 890 853 853
Total cold run time: 82676 ms
Total hot run time: 79630 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](statistics) fix updated rows incorrect due to typo in code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #26979:
URL: https://github.com/apache/doris/pull/26979#issuecomment-1812139628
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.48 seconds
stream load tsv: 556 seconds loaded 74807831229 Bytes, about 128 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 34 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17096115121 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