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 2024/03/14 07:47:31 UTC
[PR] [opt](Nereids) opt distinct agg without group by key plan [doris]
morrySnow opened a new pull request, #32236:
URL: https://github.com/apache/doris/pull/32236
(no comment)
--
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1996798316
<details>
<summary>TPC-H: <b>Total hot run time: 38338 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 03452fbc50b18ff9b78dc324f6c9881e8681ce75, data reload: false
------ Round 1 ----------------------------------
q1 17648 4329 4091 4091
q2 2036 150 143 143
q3 10718 1083 905 905
q4 7136 716 748 716
q5 7493 2615 2623 2615
q6 186 121 120 120
q7 1212 825 812 812
q8 9404 1999 2029 1999
q9 7019 6430 6421 6421
q10 8479 3543 3602 3543
q11 419 231 220 220
q12 670 309 313 309
q13 17806 2884 2855 2855
q14 272 259 255 255
q15 498 452 454 452
q16 480 399 390 390
q17 946 528 541 528
q18 7382 6481 6451 6451
q19 1848 1465 1394 1394
q20 552 293 292 292
q21 6310 3582 3527 3527
q22 372 300 304 300
Total cold run time: 108886 ms
Total hot run time: 38338 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4096 4063 4019 4019
q2 327 227 215 215
q3 2976 2858 2872 2858
q4 1850 1543 1599 1543
q5 5239 5253 5238 5238
q6 204 116 123 116
q7 2187 1816 1847 1816
q8 3131 3265 3295 3265
q9 8567 8541 8591 8541
q10 3730 3720 3690 3690
q11 547 444 440 440
q12 732 556 542 542
q13 16917 2837 2869 2837
q14 286 250 245 245
q15 487 436 452 436
q16 452 419 420 419
q17 1740 1476 1473 1473
q18 7597 7318 7070 7070
q19 1599 1570 1492 1492
q20 1910 1734 1736 1734
q21 4981 4724 4527 4527
q22 515 458 450 450
Total cold run time: 70070 ms
Total hot run time: 52966 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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1996773573
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #32236:
URL: https://github.com/apache/doris/pull/32236
--
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1996758049
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1997047441
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1996757979
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
--
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1996773501
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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1997084217
<details>
<summary>TPC-H: <b>Total hot run time: 38403 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2ad6cabaade139f40555406cad3ecefb973043d5, data reload: false
------ Round 1 ----------------------------------
q1 17646 4385 4152 4152
q2 2033 149 145 145
q3 10699 1083 898 898
q4 8171 754 754 754
q5 7510 2752 2727 2727
q6 185 119 120 119
q7 1168 822 799 799
q8 9387 2055 2017 2017
q9 7195 6387 6415 6387
q10 8448 3499 3633 3499
q11 438 229 211 211
q12 606 301 285 285
q13 17789 2875 2855 2855
q14 273 249 243 243
q15 504 446 452 446
q16 470 386 383 383
q17 939 518 621 518
q18 7340 6669 6469 6469
q19 1630 1480 1393 1393
q20 540 278 280 278
q21 6433 3524 3592 3524
q22 375 327 301 301
Total cold run time: 109779 ms
Total hot run time: 38403 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4126 4113 4074 4074
q2 341 232 219 219
q3 2956 2862 2817 2817
q4 1901 1579 1594 1579
q5 5243 5291 5221 5221
q6 194 116 116 116
q7 2275 1832 1833 1832
q8 3162 3282 3270 3270
q9 8591 8591 8579 8579
q10 3706 3699 3648 3648
q11 537 431 451 431
q12 730 587 542 542
q13 16872 2905 2843 2843
q14 267 248 262 248
q15 486 441 450 441
q16 451 403 404 403
q17 1763 1510 1474 1474
q18 7633 7208 7152 7152
q19 1633 1508 1515 1508
q20 1894 1729 1716 1716
q21 4854 4795 4761 4761
q22 522 424 473 424
Total cold run time: 70137 ms
Total hot run time: 53298 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] [opt](Nereids) opt distinct agg without group by key plan [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32236:
URL: https://github.com/apache/doris/pull/32236#issuecomment-1997076402
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