You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lsy3993 (via GitHub)" <gi...@apache.org> on 2025/05/19 06:47:28 UTC

[PR] [improvement](nereids)abstract order by for show command [doris]

lsy3993 opened a new pull request, #51019:
URL: https://github.com/apache/doris/pull/51019

   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [x] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890700891

   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] [improvement](nereids)abstract order by for show command [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890056908

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 184231 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 073ce66bb13db85c039ddc6eebbd5e08b2f01b88, data reload: false
   
   query1	1033	481	501	481
   query2	6570	1911	1950	1911
   query3	6749	222	222	222
   query4	26189	23269	23260	23260
   query5	4325	603	461	461
   query6	308	204	188	188
   query7	4621	489	281	281
   query8	275	243	239	239
   query9	8626	2620	2642	2620
   query10	473	324	288	288
   query11	15489	15042	14813	14813
   query12	167	117	111	111
   query13	1659	529	427	427
   query14	8930	6237	6161	6161
   query15	210	187	175	175
   query16	7133	619	480	480
   query17	1187	710	573	573
   query18	1951	391	297	297
   query19	196	180	158	158
   query20	119	114	125	114
   query21	219	131	106	106
   query22	4123	4150	4071	4071
   query23	34112	33104	32964	32964
   query24	8426	2484	2384	2384
   query25	535	458	406	406
   query26	1239	269	155	155
   query27	2735	497	348	348
   query28	4337	2132	2109	2109
   query29	786	537	438	438
   query30	281	221	183	183
   query31	951	862	756	756
   query32	79	69	63	63
   query33	561	374	341	341
   query34	816	861	538	538
   query35	777	808	736	736
   query36	965	986	901	901
   query37	120	107	84	84
   query38	4159	4173	4061	4061
   query39	1487	1453	1392	1392
   query40	221	126	114	114
   query41	65	58	67	58
   query42	131	116	112	112
   query43	529	531	505	505
   query44	1337	848	850	848
   query45	186	174	172	172
   query46	839	1032	649	649
   query47	1750	1791	1706	1706
   query48	392	435	328	328
   query49	838	518	426	426
   query50	645	681	439	439
   query51	4097	4146	4171	4146
   query52	119	110	99	99
   query53	232	252	186	186
   query54	603	587	512	512
   query55	88	91	99	91
   query56	312	326	303	303
   query57	1160	1160	1080	1080
   query58	281	267	268	267
   query59	2731	2876	2787	2787
   query60	338	330	344	330
   query61	128	126	126	126
   query62	792	748	665	665
   query63	242	193	192	192
   query64	4385	996	671	671
   query65	4310	4251	4235	4235
   query66	1155	419	325	325
   query67	15707	15545	15242	15242
   query68	7866	897	526	526
   query69	474	325	291	291
   query70	1222	1135	1118	1118
   query71	458	337	303	303
   query72	5312	4690	2378	2378
   query73	655	582	368	368
   query74	8844	9091	8879	8879
   query75	3793	3188	2692	2692
   query76	3501	1157	754	754
   query77	790	384	294	294
   query78	9994	10038	9403	9403
   query79	2288	850	590	590
   query80	608	529	483	483
   query81	487	252	226	226
   query82	451	133	93	93
   query83	248	253	230	230
   query84	246	99	86	86
   query85	806	413	324	324
   query86	387	324	278	278
   query87	4350	4535	4351	4351
   query88	3902	2367	2358	2358
   query89	388	309	286	286
   query90	1816	223	216	216
   query91	147	158	116	116
   query92	78	67	60	60
   query93	1849	920	574	574
   query94	639	386	309	309
   query95	377	298	289	289
   query96	510	584	289	289
   query97	2765	2746	2641	2641
   query98	254	216	211	211
   query99	1336	1391	1305	1305
   Total cold run time: 273372 ms
   Total hot run time: 184231 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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890462907

   run p0


-- 
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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2891011590

   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] [improvement](nereids)abstract order by for show command [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890071636

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.59 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 073ce66bb13db85c039ddc6eebbd5e08b2f01b88, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.12	0.11	0.11
   query3	0.25	0.20	0.20
   query4	1.59	0.19	0.12
   query5	0.44	0.41	0.44
   query6	1.15	0.66	0.65
   query7	0.03	0.01	0.02
   query8	0.04	0.03	0.04
   query9	0.58	0.52	0.51
   query10	0.55	0.58	0.57
   query11	0.15	0.11	0.10
   query12	0.14	0.12	0.12
   query13	0.62	0.61	0.59
   query14	0.79	0.80	0.83
   query15	0.86	0.85	0.86
   query16	0.38	0.39	0.39
   query17	1.07	1.02	1.01
   query18	0.22	0.22	0.22
   query19	1.96	1.79	1.79
   query20	0.02	0.01	0.01
   query21	15.40	0.89	0.54
   query22	0.77	1.24	0.60
   query23	14.92	1.40	0.63
   query24	7.26	1.95	0.37
   query25	0.40	0.13	0.09
   query26	0.76	0.17	0.14
   query27	0.05	0.05	0.06
   query28	8.62	0.87	0.43
   query29	12.52	4.08	3.43
   query30	0.26	0.09	0.06
   query31	2.84	0.62	0.39
   query32	3.24	0.55	0.47
   query33	3.09	3.09	3.14
   query34	15.81	5.10	4.47
   query35	4.52	4.50	4.50
   query36	0.68	0.49	0.48
   query37	0.08	0.07	0.06
   query38	0.05	0.04	0.04
   query39	0.03	0.02	0.02
   query40	0.18	0.14	0.14
   query41	0.08	0.02	0.02
   query42	0.04	0.02	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 102.64 s
   Total hot run time: 28.59 s
   ```
   </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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890477041

   run p0


-- 
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] [improvement](nereids)abstract order by for show command [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890756748

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34023 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 94d01d52ffd5acade91a1c5639cdba43a8d6b1c8, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26415	5129	5033	5033
   q2	2069	279	196	196
   q3	10383	1266	733	733
   q4	10252	1001	523	523
   q5	7518	2984	2328	2328
   q6	191	176	138	138
   q7	916	741	615	615
   q8	9338	1300	1165	1165
   q9	6803	5024	5108	5024
   q10	6818	2328	1909	1909
   q11	483	290	269	269
   q12	341	346	226	226
   q13	17785	3749	3087	3087
   q14	243	230	216	216
   q15	530	493	487	487
   q16	437	436	376	376
   q17	592	870	365	365
   q18	7601	7162	7139	7139
   q19	1215	938	550	550
   q20	340	335	227	227
   q21	4142	3207	2435	2435
   q22	1050	1007	982	982
   Total cold run time: 115462 ms
   Total hot run time: 34023 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5143	5087	5109	5087
   q2	242	325	228	228
   q3	2212	2662	2312	2312
   q4	1325	1790	1415	1415
   q5	4568	4450	4456	4450
   q6	218	172	134	134
   q7	2028	1918	1776	1776
   q8	2605	2475	2665	2475
   q9	7245	7253	7123	7123
   q10	2964	3196	2751	2751
   q11	588	518	514	514
   q12	675	766	621	621
   q13	3543	3924	3268	3268
   q14	281	297	293	293
   q15	519	486	476	476
   q16	453	491	435	435
   q17	1162	1591	1426	1426
   q18	7611	7593	7404	7404
   q19	848	808	956	808
   q20	1996	2041	1900	1900
   q21	4774	4373	4236	4236
   q22	1059	1014	965	965
   Total cold run time: 52059 ms
   Total hot run time: 50097 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] [improvement](nereids)abstract order by for show command [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2892648049

   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] [improvement](nereids)abstract order by for show command [doris]

Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #51019:
URL: https://github.com/apache/doris/pull/51019


-- 
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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890464227

   run cloud_p0


-- 
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] [improvement](nereids)abstract order by for show command [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2892648012

   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] [improvement](nereids)abstract order by for show command [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890010925

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34255 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 073ce66bb13db85c039ddc6eebbd5e08b2f01b88, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26472	5031	5026	5026
   q2	2100	288	201	201
   q3	10502	1293	754	754
   q4	10247	1011	516	516
   q5	7697	2366	2392	2366
   q6	193	166	145	145
   q7	920	748	673	673
   q8	9325	1296	1148	1148
   q9	6791	5121	5110	5110
   q10	6823	2340	1900	1900
   q11	506	295	275	275
   q12	344	352	218	218
   q13	17782	3729	3147	3147
   q14	226	236	213	213
   q15	533	501	482	482
   q16	434	436	383	383
   q17	615	897	368	368
   q18	7626	7076	7115	7076
   q19	1602	958	600	600
   q20	349	345	225	225
   q21	4068	3329	2450	2450
   q22	1057	1033	979	979
   Total cold run time: 116212 ms
   Total hot run time: 34255 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5252	5093	5150	5093
   q2	241	324	228	228
   q3	2199	2683	2286	2286
   q4	1400	1773	1514	1514
   q5	4593	4456	4363	4363
   q6	213	168	126	126
   q7	2004	1914	1764	1764
   q8	2599	2598	2581	2581
   q9	7156	7256	7138	7138
   q10	3002	3182	2758	2758
   q11	572	506	493	493
   q12	692	781	604	604
   q13	3519	3945	3296	3296
   q14	293	294	269	269
   q15	521	479	473	473
   q16	465	512	439	439
   q17	1214	1620	1373	1373
   q18	7722	7595	7590	7590
   q19	878	881	943	881
   q20	2015	2064	1880	1880
   q21	4708	4289	4203	4203
   q22	1030	989	1007	989
   Total cold run time: 52288 ms
   Total hot run time: 50341 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] [improvement](nereids)abstract order by for show command [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890805463

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.24 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 94d01d52ffd5acade91a1c5639cdba43a8d6b1c8, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.13	0.10	0.11
   query3	0.28	0.19	0.19
   query4	1.60	0.19	0.19
   query5	0.46	0.44	0.44
   query6	1.50	0.66	0.66
   query7	0.02	0.02	0.01
   query8	0.04	0.04	0.04
   query9	0.58	0.53	0.51
   query10	0.56	0.58	0.57
   query11	0.15	0.11	0.11
   query12	0.15	0.13	0.12
   query13	0.61	0.60	0.62
   query14	0.79	0.80	0.81
   query15	0.88	0.86	0.87
   query16	0.39	0.38	0.38
   query17	1.01	1.04	1.06
   query18	0.23	0.20	0.21
   query19	1.93	1.80	1.82
   query20	0.01	0.00	0.02
   query21	15.40	0.91	0.54
   query22	0.78	1.31	0.68
   query23	14.83	1.34	0.60
   query24	6.76	1.35	0.91
   query25	0.47	0.28	0.08
   query26	0.59	0.16	0.14
   query27	0.05	0.05	0.06
   query28	9.64	0.94	0.45
   query29	12.54	3.96	3.33
   query30	0.26	0.09	0.07
   query31	2.80	0.59	0.39
   query32	3.23	0.56	0.47
   query33	3.10	3.01	3.05
   query34	15.78	5.07	4.52
   query35	4.56	4.55	4.54
   query36	0.67	0.51	0.48
   query37	0.09	0.06	0.07
   query38	0.05	0.04	0.04
   query39	0.03	0.03	0.03
   query40	0.17	0.13	0.14
   query41	0.08	0.03	0.02
   query42	0.03	0.02	0.03
   query43	0.04	0.04	0.03
   Total cold run time: 103.31 s
   Total hot run time: 29.24 s
   ```
   </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] [improvement](nereids)abstract order by for show command [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2889812553

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and after the optimization?
       


-- 
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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2889813092

   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] [improvement](nereids)abstract order by for show command [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890790299

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186225 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 94d01d52ffd5acade91a1c5639cdba43a8d6b1c8, data reload: false
   
   query1	997	493	499	493
   query2	6578	1923	1873	1873
   query3	6737	237	216	216
   query4	26609	23885	22961	22961
   query5	4371	621	442	442
   query6	279	202	197	197
   query7	4617	501	288	288
   query8	303	263	242	242
   query9	8626	2646	2670	2646
   query10	505	336	283	283
   query11	15406	15058	14877	14877
   query12	166	113	105	105
   query13	1672	551	434	434
   query14	8824	6236	6203	6203
   query15	216	194	170	170
   query16	7306	639	473	473
   query17	1190	731	584	584
   query18	1991	395	294	294
   query19	220	183	159	159
   query20	121	121	125	121
   query21	214	126	108	108
   query22	4108	4181	4030	4030
   query23	34009	33301	32866	32866
   query24	8505	2404	2367	2367
   query25	550	451	401	401
   query26	1228	275	155	155
   query27	2747	521	346	346
   query28	4298	2134	2126	2126
   query29	808	572	452	452
   query30	289	243	197	197
   query31	922	863	768	768
   query32	73	62	68	62
   query33	555	369	324	324
   query34	796	861	543	543
   query35	783	814	747	747
   query36	966	992	898	898
   query37	118	98	104	98
   query38	4086	4191	4057	4057
   query39	1498	1524	1436	1436
   query40	214	121	109	109
   query41	58	56	56	56
   query42	127	123	106	106
   query43	516	507	496	496
   query44	1321	852	859	852
   query45	179	171	182	171
   query46	832	1034	664	664
   query47	1769	1814	1774	1774
   query48	396	426	325	325
   query49	798	510	438	438
   query50	652	692	421	421
   query51	4166	4221	4097	4097
   query52	114	107	107	107
   query53	228	258	199	199
   query54	575	586	518	518
   query55	88	87	87	87
   query56	297	306	292	292
   query57	1168	1182	1113	1113
   query58	288	268	264	264
   query59	2677	2716	2641	2641
   query60	353	338	328	328
   query61	153	150	151	150
   query62	792	710	668	668
   query63	230	191	191	191
   query64	4466	1093	791	791
   query65	4332	4228	4265	4228
   query66	1180	412	323	323
   query67	15902	15712	15295	15295
   query68	8012	893	532	532
   query69	478	310	277	277
   query70	1244	1140	1070	1070
   query71	472	327	315	315
   query72	5547	4687	4627	4627
   query73	688	574	360	360
   query74	8986	9030	8814	8814
   query75	3838	3188	2756	2756
   query76	3666	1194	749	749
   query77	787	362	291	291
   query78	9917	10082	9326	9326
   query79	2849	796	593	593
   query80	620	532	453	453
   query81	494	255	223	223
   query82	482	126	99	99
   query83	290	258	239	239
   query84	305	112	87	87
   query85	805	384	331	331
   query86	387	282	275	275
   query87	4401	4521	4340	4340
   query88	3335	2382	2369	2369
   query89	423	311	288	288
   query90	1833	215	204	204
   query91	147	144	113	113
   query92	82	59	57	57
   query93	1947	928	591	591
   query94	672	416	311	311
   query95	380	286	285	285
   query96	508	583	298	298
   query97	2735	2780	2687	2687
   query98	238	216	213	213
   query99	1453	1417	1306	1306
   Total cold run time: 275179 ms
   Total hot run time: 186225 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] [improvement](nereids)abstract order by for show command [doris]

Posted by "lsy3993 (via GitHub)" <gi...@apache.org>.
lsy3993 commented on PR #51019:
URL: https://github.com/apache/doris/pull/51019#issuecomment-2890477318

   run cloud_p0


-- 
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