You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "starocean999 (via GitHub)" <gi...@apache.org> on 2024/03/15 03:18:26 UTC
[PR] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
starocean999 opened a new pull request, #32276:
URL: https://github.com/apache/doris/pull/32276
## Proposed changes
select count(*) from t where dt > (select '2024-02-02 00:00:00');
-->
select count(*) from t where dt > '2024-02-02 00:00:00';
<!--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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1998867203
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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1998891885
<details>
<summary>TPC-H: <b>Total hot run time: 38470 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 7e2fc3c4c620676c58779603c0e09db0e5b48d0b, data reload: false
------ Round 1 ----------------------------------
q1 17652 4259 4115 4115
q2 2019 155 143 143
q3 10604 1082 895 895
q4 7078 689 694 689
q5 7475 2777 2765 2765
q6 188 126 125 125
q7 1167 814 802 802
q8 9332 2009 2013 2009
q9 7237 6406 6415 6406
q10 8538 3521 3631 3521
q11 435 236 218 218
q12 754 304 293 293
q13 18081 2857 2847 2847
q14 275 256 255 255
q15 495 451 451 451
q16 508 395 392 392
q17 943 518 528 518
q18 6992 6501 6460 6460
q19 2178 1461 1421 1421
q20 562 297 291 291
q21 6388 3552 3596 3552
q22 346 331 302 302
Total cold run time: 109247 ms
Total hot run time: 38470 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4148 4122 4120 4120
q2 327 215 224 215
q3 2955 2841 2846 2841
q4 1911 1605 1547 1547
q5 5260 5298 5279 5279
q6 194 117 119 117
q7 2215 1859 1864 1859
q8 3145 3322 3298 3298
q9 8609 8586 8530 8530
q10 3687 3688 3689 3688
q11 551 433 434 433
q12 719 541 553 541
q13 16934 2867 2862 2862
q14 275 246 258 246
q15 498 444 451 444
q16 457 421 427 421
q17 1758 1487 1465 1465
q18 7561 7173 7061 7061
q19 1633 1554 1560 1554
q20 1900 1727 1720 1720
q21 4964 4661 4561 4561
q22 530 453 454 453
Total cold run time: 70231 ms
Total hot run time: 53255 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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1998867306
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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1999195470
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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1999852637
<details>
<summary>TPC-H: <b>Total hot run time: 37863 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 f24ee11f052c630da0b131ff0cb4ea532d4ae1d4, data reload: false
------ Round 1 ----------------------------------
q1 17633 4244 4112 4112
q2 2019 157 141 141
q3 10588 1068 904 904
q4 7775 728 655 655
q5 7464 2590 2653 2590
q6 185 121 122 121
q7 1219 821 781 781
q8 9320 1935 1988 1935
q9 7164 6390 6379 6379
q10 8518 3459 3606 3459
q11 430 222 215 215
q12 579 300 296 296
q13 17794 2840 2846 2840
q14 271 244 249 244
q15 509 469 445 445
q16 511 392 381 381
q17 942 506 536 506
q18 7083 6486 6369 6369
q19 4202 1421 1482 1421
q20 538 288 271 271
q21 6268 3496 3590 3496
q22 372 302 315 302
Total cold run time: 111384 ms
Total hot run time: 37863 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4103 4061 4084 4061
q2 328 228 225 225
q3 2923 2811 2809 2809
q4 1858 1535 1610 1535
q5 5243 5251 5235 5235
q6 195 115 118 115
q7 2243 1812 1856 1812
q8 3147 3295 3278 3278
q9 8489 8545 8505 8505
q10 3694 3643 3646 3643
q11 544 436 434 434
q12 750 561 541 541
q13 16909 2830 2844 2830
q14 273 245 249 245
q15 493 455 441 441
q16 448 406 414 406
q17 1750 1483 1462 1462
q18 7465 7237 6997 6997
q19 1623 1522 1521 1521
q20 1909 1683 1707 1683
q21 4815 4572 4720 4572
q22 520 447 433 433
Total cold run time: 69722 ms
Total hot run time: 52783 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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #32276:
URL: https://github.com/apache/doris/pull/32276
--
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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1999195507
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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-1999780457
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] [enhancement](nereids)simplify OneRowRelation scalar subquery [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32276:
URL: https://github.com/apache/doris/pull/32276#issuecomment-2002724719
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