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