You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2023/11/16 12:26:43 UTC
[PR] [fix](Nereids) result type of add precision is 1 more than expected [doris]
morrySnow opened a new pull request, #27136:
URL: https://github.com/apache/doris/pull/27136
## 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) result type of add precision is 1 more than expected [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1815697829
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.73 seconds
stream load tsv: 567 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 17 seconds loaded 2358488459 Bytes, about 132 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.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17099413218 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) result type of add precision is 1 more than expected [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1815739353
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) result type of add precision is 1 more than expected [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1815739386
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) result type of add precision is 1 more than expected [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1814522738
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 10a13548d81c1a079affdc062eb90adb0d65a21a, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4924 4644 4633 4633
q2 355 167 159 159
q3 2034 1948 1951 1948
q4 1385 1240 1232 1232
q5 3948 3935 4059 3935
q6 251 129 133 129
q7 1387 891 879 879
q8 2759 2773 2773 2773
q9 9774 9855 9668 9668
q10 3461 3546 3512 3512
q11 376 254 243 243
q12 439 296 299 296
q13 4538 3834 3831 3831
q14 319 284 288 284
q15 581 541 521 521
q16 676 580 583 580
q17 1132 985 927 927
q18 7782 7497 7384 7384
q19 1670 1709 1668 1668
q20 515 293 306 293
q21 4601 3986 4043 3986
q22 477 369 376 369
Total cold run time: 53384 ms
Total hot run time: 49250 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4614 4593 4578 4578
q2 340 221 275 221
q3 4005 4015 3991 3991
q4 2700 2700 2693 2693
q5 9566 9590 9540 9540
q6 246 123 125 123
q7 2615 2303 2295 2295
q8 4481 4449 4492 4449
q9 13198 13066 13131 13066
q10 4083 4178 4165 4165
q11 807 692 677 677
q12 977 830 809 809
q13 4303 3588 3561 3561
q14 385 359 339 339
q15 581 524 526 524
q16 722 661 667 661
q17 3836 3929 3875 3875
q18 9724 9015 9115 9015
q19 1825 1792 1776 1776
q20 2371 2062 2048 2048
q21 8855 8438 8638 8438
q22 900 815 792 792
Total cold run time: 81134 ms
Total hot run time: 77636 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](Nereids) result type of add precision is 1 more than expected [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1815692842
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 6f570326bfa6e08d9cfbea2a8defd213549343c4, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4960 4646 4687 4646
q2 356 144 157 144
q3 2034 1981 1905 1905
q4 1385 1233 1217 1217
q5 3943 3942 4021 3942
q6 249 130 132 130
q7 1378 876 877 876
q8 2767 2799 2775 2775
q9 9865 9609 9552 9552
q10 3481 3523 3525 3523
q11 378 247 237 237
q12 437 297 301 297
q13 4545 3786 3800 3786
q14 317 288 300 288
q15 579 528 524 524
q16 670 593 583 583
q17 1144 965 927 927
q18 7951 7419 7457 7419
q19 1678 1681 1679 1679
q20 533 325 323 323
q21 4459 3992 3999 3992
q22 475 377 373 373
Total cold run time: 53584 ms
Total hot run time: 49138 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4593 4596 4591 4591
q2 335 223 247 223
q3 4015 4002 3985 3985
q4 2701 2690 2703 2690
q5 9710 9669 9760 9669
q6 242 127 124 124
q7 2590 2314 2255 2255
q8 4433 4410 4449 4410
q9 13230 13195 13121 13121
q10 4078 4174 4187 4174
q11 779 699 700 699
q12 986 816 812 812
q13 4279 3609 3613 3609
q14 382 358 350 350
q15 582 517 522 517
q16 734 662 683 662
q17 3952 3950 3846 3846
q18 9589 9077 8912 8912
q19 1829 1790 1782 1782
q20 2414 2070 2037 2037
q21 8776 8774 8638 8638
q22 877 795 768 768
Total cold run time: 81106 ms
Total hot run time: 77874 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](Nereids) result type of add precision is 1 more than expected [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1814543785
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.24 seconds
stream load tsv: 568 seconds loaded 74807831229 Bytes, about 125 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: 17098789385 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) result type of add precision is 1 more than expected [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1815590724
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) result type of add precision is 1 more than expected [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #27136:
URL: https://github.com/apache/doris/pull/27136
--
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) result type of add precision is 1 more than expected [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #27136:
URL: https://github.com/apache/doris/pull/27136#issuecomment-1814345085
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