You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "yx-keith (via GitHub)" <gi...@apache.org> on 2025/05/10 17:24:40 UTC

[PR] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

yx-keith opened a new pull request, #50787:
URL: https://github.com/apache/doris/pull/50787

   ### 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
       - [ ] 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   run ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.01 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 7812a5979523ef2ca73ccd878551c905f6afbb4c, data reload: false
   
   query1	0.04	0.04	0.02
   query2	0.12	0.10	0.12
   query3	0.26	0.19	0.20
   query4	1.60	0.19	0.20
   query5	0.47	0.45	0.46
   query6	1.16	0.66	0.66
   query7	0.02	0.02	0.01
   query8	0.04	0.04	0.03
   query9	0.59	0.53	0.53
   query10	0.56	0.59	0.57
   query11	0.15	0.11	0.11
   query12	0.15	0.11	0.11
   query13	0.61	0.59	0.59
   query14	0.79	0.81	0.82
   query15	0.87	0.87	0.86
   query16	0.39	0.38	0.39
   query17	1.03	1.04	1.02
   query18	0.23	0.21	0.21
   query19	1.89	1.74	1.79
   query20	0.01	0.01	0.01
   query21	15.42	0.90	0.55
   query22	0.77	1.31	0.66
   query23	14.79	1.39	0.66
   query24	6.52	1.99	0.72
   query25	0.50	0.22	0.09
   query26	0.64	0.17	0.15
   query27	0.06	0.05	0.05
   query28	9.82	0.83	0.44
   query29	12.56	3.90	3.25
   query30	0.26	0.10	0.07
   query31	2.80	0.59	0.38
   query32	3.24	0.56	0.48
   query33	3.08	3.09	3.09
   query34	15.82	5.08	4.52
   query35	4.54	4.51	4.51
   query36	0.69	0.49	0.48
   query37	0.09	0.07	0.06
   query38	0.05	0.04	0.03
   query39	0.03	0.03	0.02
   query40	0.17	0.13	0.13
   query41	0.09	0.03	0.03
   query42	0.04	0.03	0.02
   query43	0.04	0.04	0.03
   Total cold run time: 103 s
   Total hot run time: 29.01 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 193049 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 2496d7c779fbcd3ebd72a61f3d4d1a1e52054c2d, data reload: false
   
   query1	1385	1104	1038	1038
   query2	6293	1898	1867	1867
   query3	11017	4410	4472	4410
   query4	53879	24425	23127	23127
   query5	5338	531	500	500
   query6	385	222	214	214
   query7	5048	560	300	300
   query8	345	285	223	223
   query9	6567	2604	2586	2586
   query10	446	334	264	264
   query11	15316	14973	14835	14835
   query12	168	114	104	104
   query13	1141	522	400	400
   query14	10085	6278	6294	6278
   query15	207	190	178	178
   query16	7055	688	462	462
   query17	1093	773	613	613
   query18	1545	433	334	334
   query19	223	217	189	189
   query20	134	132	137	132
   query21	208	128	112	112
   query22	4625	4693	4429	4429
   query23	34277	33678	33569	33569
   query24	6722	2445	2465	2445
   query25	466	479	409	409
   query26	720	295	151	151
   query27	2284	548	348	348
   query28	3001	2206	2176	2176
   query29	595	591	461	461
   query30	283	221	192	192
   query31	874	881	762	762
   query32	73	64	74	64
   query33	453	370	340	340
   query34	814	935	549	549
   query35	818	870	755	755
   query36	996	1033	901	901
   query37	116	109	78	78
   query38	4259	4236	4232	4232
   query39	1517	1474	1479	1474
   query40	218	121	111	111
   query41	60	59	61	59
   query42	127	112	112	112
   query43	514	512	494	494
   query44	1436	843	829	829
   query45	192	184	175	175
   query46	925	1093	653	653
   query47	1818	1889	1812	1812
   query48	434	448	321	321
   query49	721	582	451	451
   query50	707	786	407	407
   query51	4264	4186	4199	4186
   query52	114	111	100	100
   query53	231	278	195	195
   query54	600	591	537	537
   query55	87	81	88	81
   query56	336	336	312	312
   query57	1229	1227	1133	1133
   query58	263	255	263	255
   query59	2788	2834	2663	2663
   query60	339	320	317	317
   query61	132	129	124	124
   query62	731	764	664	664
   query63	241	191	190	190
   query64	2068	1033	701	701
   query65	4334	4216	4210	4210
   query66	749	416	304	304
   query67	16095	15653	15539	15539
   query68	6510	912	522	522
   query69	541	315	272	272
   query70	1226	1094	1085	1085
   query71	509	334	317	317
   query72	5776	4780	4803	4780
   query73	1240	607	354	354
   query74	8946	9118	8919	8919
   query75	3905	3261	2681	2681
   query76	4283	1302	770	770
   query77	651	425	293	293
   query78	10124	10228	9352	9352
   query79	2483	879	577	577
   query80	649	546	443	443
   query81	496	255	217	217
   query82	454	134	100	100
   query83	334	259	233	233
   query84	298	102	98	98
   query85	784	353	327	327
   query86	392	302	295	295
   query87	4378	4510	4331	4331
   query88	3646	2312	2303	2303
   query89	430	334	283	283
   query90	1904	205	211	205
   query91	144	152	119	119
   query92	80	59	63	59
   query93	1710	953	589	589
   query94	678	453	308	308
   query95	398	290	294	290
   query96	505	625	285	285
   query97	2775	2741	2697	2697
   query98	230	213	200	200
   query99	1477	1392	1309	1309
   Total cold run time: 300480 ms
   Total hot run time: 193049 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 195477 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 0e15d5b4b3d827c53b83d032de2f5101c161134d, data reload: false
   
   query1	1432	1102	1086	1086
   query2	6244	1872	1877	1872
   query3	11145	4483	4533	4483
   query4	54655	25184	23003	23003
   query5	5067	618	493	493
   query6	367	218	207	207
   query7	4917	536	309	309
   query8	349	272	251	251
   query9	5566	2825	2821	2821
   query10	482	337	290	290
   query11	15030	15010	14976	14976
   query12	167	113	111	111
   query13	1041	548	427	427
   query14	10263	6525	6425	6425
   query15	208	208	190	190
   query16	7058	672	515	515
   query17	1103	795	616	616
   query18	1575	431	342	342
   query19	214	202	189	189
   query20	169	129	119	119
   query21	210	129	107	107
   query22	4574	4508	4487	4487
   query23	34403	33803	33620	33620
   query24	6724	2440	2469	2440
   query25	499	469	425	425
   query26	731	282	166	166
   query27	2402	524	369	369
   query28	2961	2323	2325	2323
   query29	600	581	462	462
   query30	277	221	197	197
   query31	894	858	769	769
   query32	79	67	60	60
   query33	476	385	323	323
   query34	810	907	560	560
   query35	795	865	756	756
   query36	983	1003	920	920
   query37	117	101	80	80
   query38	4321	4386	4288	4288
   query39	1566	1453	1494	1453
   query40	211	132	114	114
   query41	55	56	58	56
   query42	133	117	113	113
   query43	522	516	496	496
   query44	1393	909	888	888
   query45	190	188	190	188
   query46	890	1049	668	668
   query47	1842	1895	1815	1815
   query48	417	438	351	351
   query49	680	570	453	453
   query50	691	706	416	416
   query51	4266	4353	4275	4275
   query52	112	113	108	108
   query53	246	270	206	206
   query54	634	610	550	550
   query55	94	94	88	88
   query56	305	320	314	314
   query57	1191	1193	1149	1149
   query58	287	272	266	266
   query59	2819	2882	2832	2832
   query60	368	363	343	343
   query61	131	127	126	126
   query62	751	758	678	678
   query63	243	203	203	203
   query64	1868	1059	729	729
   query65	4364	4229	4234	4229
   query66	727	405	312	312
   query67	16181	15790	15752	15752
   query68	7095	864	612	612
   query69	543	322	266	266
   query70	1221	1166	1136	1136
   query71	518	347	306	306
   query72	5962	4829	4834	4829
   query73	1442	679	376	376
   query74	9100	9124	8945	8945
   query75	4065	3203	2728	2728
   query76	4182	1216	783	783
   query77	715	356	288	288
   query78	10233	10235	9479	9479
   query79	2505	819	616	616
   query80	619	577	459	459
   query81	506	255	220	220
   query82	437	131	107	107
   query83	277	263	247	247
   query84	302	113	90	90
   query85	776	355	313	313
   query86	374	309	304	304
   query87	4446	4456	4371	4371
   query88	3578	2395	2395	2395
   query89	427	322	290	290
   query90	1796	218	207	207
   query91	145	164	116	116
   query92	76	68	58	58
   query93	1881	974	626	626
   query94	659	415	307	307
   query95	370	299	315	299
   query96	519	586	292	292
   query97	2784	2728	2675	2675
   query98	241	217	203	203
   query99	1435	1398	1286	1286
   Total cold run time: 301314 ms
   Total hot run time: 195477 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33785 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 92dbadb3ac924b5ce0d10fbe888a698caccc44d0, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26066	5105	4980	4980
   q2	2066	286	185	185
   q3	10461	1227	703	703
   q4	10257	1008	528	528
   q5	8140	2396	2358	2358
   q6	181	160	131	131
   q7	902	751	613	613
   q8	9320	1311	1132	1132
   q9	6796	5155	5170	5155
   q10	6863	2310	1878	1878
   q11	476	279	279	279
   q12	353	349	210	210
   q13	17811	3708	3129	3129
   q14	233	235	218	218
   q15	521	482	492	482
   q16	419	443	369	369
   q17	582	914	365	365
   q18	7807	7221	7008	7008
   q19	1370	947	542	542
   q20	330	339	219	219
   q21	4026	3141	2335	2335
   q22	1050	1017	966	966
   Total cold run time: 116030 ms
   Total hot run time: 33785 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5145	5028	5113	5028
   q2	246	323	233	233
   q3	2155	2605	2319	2319
   q4	1348	1795	1381	1381
   q5	4552	4415	4372	4372
   q6	219	168	128	128
   q7	1999	1918	1759	1759
   q8	2551	2407	2523	2407
   q9	7211	7179	7203	7179
   q10	3015	3171	2747	2747
   q11	569	513	496	496
   q12	683	759	593	593
   q13	3428	3938	3258	3258
   q14	295	311	262	262
   q15	517	472	473	472
   q16	435	473	448	448
   q17	1175	1663	1324	1324
   q18	7709	7761	7416	7416
   q19	797	809	987	809
   q20	2018	2039	1816	1816
   q21	4781	4352	4203	4203
   q22	1079	1007	958	958
   Total cold run time: 51927 ms
   Total hot run time: 49608 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34949 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 0e15d5b4b3d827c53b83d032de2f5101c161134d, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26278	5229	5226	5226
   q2	2062	314	186	186
   q3	10363	1339	709	709
   q4	10221	1066	526	526
   q5	7562	2688	2652	2652
   q6	205	177	140	140
   q7	999	765	605	605
   q8	9317	1453	1206	1206
   q9	6901	5290	5465	5290
   q10	6964	2442	1935	1935
   q11	510	298	271	271
   q12	354	394	220	220
   q13	17864	3849	3098	3098
   q14	254	237	214	214
   q15	545	502	483	483
   q16	437	450	381	381
   q17	635	915	386	386
   q18	7634	7109	7189	7109
   q19	1958	1093	591	591
   q20	366	364	240	240
   q21	4323	3551	2511	2511
   q22	1063	1035	970	970
   Total cold run time: 116815 ms
   Total hot run time: 34949 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5515	5913	5421	5421
   q2	257	349	237	237
   q3	2221	2733	2465	2465
   q4	1448	1943	1484	1484
   q5	4622	4415	4390	4390
   q6	268	187	131	131
   q7	2047	1964	1739	1739
   q8	2891	2907	2831	2831
   q9	7256	7231	7212	7212
   q10	3145	3294	2825	2825
   q11	636	520	503	503
   q12	734	763	584	584
   q13	3637	4099	3298	3298
   q14	301	313	289	289
   q15	543	480	481	480
   q16	463	523	451	451
   q17	1225	1751	1440	1440
   q18	7818	7616	7449	7449
   q19	884	830	906	830
   q20	1990	2109	1972	1972
   q21	5180	4650	4458	4458
   q22	1174	1125	1037	1037
   Total cold run time: 54255 ms
   Total hot run time: 51526 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33871 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 72ad9dd758eefad73975c6f040e2210022c700ec, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26134	5031	5018	5018
   q2	2058	265	184	184
   q3	10415	1219	733	733
   q4	10219	980	532	532
   q5	7525	2354	2346	2346
   q6	178	161	131	131
   q7	906	725	617	617
   q8	9299	1258	1105	1105
   q9	6813	5106	5072	5072
   q10	6856	2322	1880	1880
   q11	469	296	285	285
   q12	336	342	212	212
   q13	17794	3686	3065	3065
   q14	233	231	219	219
   q15	527	491	485	485
   q16	417	453	379	379
   q17	603	844	364	364
   q18	7467	7146	7200	7146
   q19	1555	966	558	558
   q20	336	340	229	229
   q21	3717	3159	2339	2339
   q22	1070	1034	972	972
   Total cold run time: 114927 ms
   Total hot run time: 33871 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5150	5055	5156	5055
   q2	237	330	241	241
   q3	2194	2680	2419	2419
   q4	1418	1810	1379	1379
   q5	4556	4467	4393	4393
   q6	209	171	124	124
   q7	1994	1931	1765	1765
   q8	2580	2557	2535	2535
   q9	7160	7191	6929	6929
   q10	3105	3201	2796	2796
   q11	575	513	511	511
   q12	677	754	616	616
   q13	3583	3850	3319	3319
   q14	287	299	274	274
   q15	534	481	486	481
   q16	457	497	432	432
   q17	1127	1546	1360	1360
   q18	7739	7495	7563	7495
   q19	801	766	805	766
   q20	1982	2072	1843	1843
   q21	4707	4490	4373	4373
   q22	1108	1088	1021	1021
   Total cold run time: 52180 ms
   Total hot run time: 50127 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34181 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 2a52bf424c1bca445950039e2b39e6bd45d20895, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	25990	5075	5018	5018
   q2	2069	277	189	189
   q3	10396	1241	717	717
   q4	10226	1045	528	528
   q5	7542	2339	2355	2339
   q6	180	160	134	134
   q7	885	753	614	614
   q8	9314	1297	1096	1096
   q9	6719	5093	5097	5093
   q10	6859	2285	1911	1911
   q11	498	282	272	272
   q12	347	355	216	216
   q13	18047	3710	3231	3231
   q14	248	238	229	229
   q15	532	481	475	475
   q16	434	450	382	382
   q17	599	864	379	379
   q18	7638	7309	7204	7204
   q19	1798	961	573	573
   q20	330	326	234	234
   q21	3730	3214	2338	2338
   q22	1052	1039	1009	1009
   Total cold run time: 115433 ms
   Total hot run time: 34181 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5091	5071	5053	5053
   q2	230	322	236	236
   q3	2147	2634	2270	2270
   q4	1375	1753	1352	1352
   q5	4456	4352	4417	4352
   q6	217	169	127	127
   q7	2022	1905	1751	1751
   q8	2605	2559	2456	2456
   q9	7376	7249	7065	7065
   q10	2997	3154	2747	2747
   q11	563	502	488	488
   q12	681	807	619	619
   q13	3505	3868	3261	3261
   q14	278	324	278	278
   q15	534	485	485	485
   q16	443	487	444	444
   q17	1125	1525	1355	1355
   q18	7608	7594	7580	7580
   q19	785	774	886	774
   q20	1950	1970	1866	1866
   q21	4835	4493	4485	4485
   q22	1085	1072	1007	1007
   Total cold run time: 51908 ms
   Total hot run time: 50051 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192562 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 2a52bf424c1bca445950039e2b39e6bd45d20895, data reload: false
   
   query1	1419	1098	1070	1070
   query2	6170	1798	1784	1784
   query3	11141	4482	4493	4482
   query4	54820	24641	23521	23521
   query5	5253	520	462	462
   query6	420	213	200	200
   query7	5331	505	290	290
   query8	327	246	242	242
   query9	7220	2611	2620	2611
   query10	420	323	272	272
   query11	15071	15171	14750	14750
   query12	159	110	108	108
   query13	1299	523	400	400
   query14	10124	6246	6280	6246
   query15	205	205	186	186
   query16	7013	628	506	506
   query17	1081	757	565	565
   query18	1538	392	300	300
   query19	191	178	163	163
   query20	125	124	114	114
   query21	202	127	110	110
   query22	4252	4496	4402	4402
   query23	34363	33541	33511	33511
   query24	6546	2458	2486	2458
   query25	462	489	419	419
   query26	708	275	158	158
   query27	2274	500	334	334
   query28	2945	2151	2153	2151
   query29	596	579	439	439
   query30	279	221	192	192
   query31	874	838	776	776
   query32	73	62	68	62
   query33	464	358	329	329
   query34	806	856	509	509
   query35	773	833	750	750
   query36	935	998	892	892
   query37	110	99	75	75
   query38	4223	4343	4154	4154
   query39	1515	1451	1441	1441
   query40	214	123	113	113
   query41	63	54	57	54
   query42	133	127	111	111
   query43	522	518	487	487
   query44	1316	835	831	831
   query45	185	181	174	174
   query46	866	1046	640	640
   query47	1870	1865	1767	1767
   query48	397	422	326	326
   query49	688	554	426	426
   query50	643	689	411	411
   query51	4196	4307	4178	4178
   query52	116	107	114	107
   query53	231	251	194	194
   query54	587	564	517	517
   query55	89	90	83	83
   query56	322	310	272	272
   query57	1156	1201	1132	1132
   query58	265	266	262	262
   query59	2711	2804	2657	2657
   query60	322	321	357	321
   query61	125	123	121	121
   query62	730	762	652	652
   query63	242	185	184	184
   query64	1421	999	681	681
   query65	4309	4252	4250	4250
   query66	714	397	301	301
   query67	15818	15657	15572	15572
   query68	4998	897	526	526
   query69	521	304	273	273
   query70	1217	1141	1107	1107
   query71	451	323	299	299
   query72	6138	4770	5208	4770
   query73	840	654	350	350
   query74	9007	9005	8820	8820
   query75	3517	3198	2679	2679
   query76	3626	1192	754	754
   query77	530	357	300	300
   query78	10196	10082	9388	9388
   query79	2800	816	566	566
   query80	855	500	424	424
   query81	495	250	220	220
   query82	723	125	98	98
   query83	263	251	233	233
   query84	294	111	88	88
   query85	803	354	306	306
   query86	487	292	298	292
   query87	4421	4352	4310	4310
   query88	3619	2364	2231	2231
   query89	418	323	286	286
   query90	1904	207	199	199
   query91	140	147	116	116
   query92	77	59	52	52
   query93	2749	921	570	570
   query94	725	416	314	314
   query95	381	299	289	289
   query96	478	578	280	280
   query97	2724	2770	2661	2661
   query98	235	205	201	201
   query99	1404	1372	1302	1302
   Total cold run time: 299014 ms
   Total hot run time: 192562 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.17 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 92dbadb3ac924b5ce0d10fbe888a698caccc44d0, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.12	0.11	0.10
   query3	0.25	0.20	0.20
   query4	1.59	0.20	0.11
   query5	0.45	0.41	0.41
   query6	1.16	0.65	0.65
   query7	0.03	0.02	0.02
   query8	0.05	0.03	0.04
   query9	0.56	0.54	0.51
   query10	0.57	0.57	0.56
   query11	0.15	0.11	0.11
   query12	0.16	0.11	0.12
   query13	0.62	0.61	0.60
   query14	0.77	0.80	0.80
   query15	0.88	0.86	0.87
   query16	0.39	0.39	0.39
   query17	1.04	1.04	1.05
   query18	0.23	0.22	0.22
   query19	1.88	1.87	1.80
   query20	0.01	0.01	0.01
   query21	15.44	0.88	0.54
   query22	0.74	1.13	0.92
   query23	14.68	1.35	0.62
   query24	6.55	2.65	0.66
   query25	0.50	0.19	0.06
   query26	0.68	0.16	0.14
   query27	0.06	0.05	0.04
   query28	9.64	0.87	0.43
   query29	12.58	3.98	3.33
   query30	0.25	0.10	0.07
   query31	2.81	0.59	0.38
   query32	3.22	0.56	0.48
   query33	3.00	3.09	3.06
   query34	15.80	5.10	4.56
   query35	4.51	4.51	4.51
   query36	0.66	0.49	0.49
   query37	0.08	0.06	0.06
   query38	0.05	0.05	0.04
   query39	0.03	0.02	0.02
   query40	0.17	0.12	0.13
   query41	0.09	0.03	0.03
   query42	0.03	0.03	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 102.56 s
   Total hot run time: 29.17 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run external


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.06 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 2a52bf424c1bca445950039e2b39e6bd45d20895, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.12	0.10	0.11
   query3	0.24	0.20	0.19
   query4	1.58	0.20	0.19
   query5	0.45	0.45	0.43
   query6	1.49	0.65	0.66
   query7	0.02	0.02	0.02
   query8	0.04	0.04	0.03
   query9	0.58	0.53	0.52
   query10	0.58	0.57	0.57
   query11	0.14	0.11	0.11
   query12	0.14	0.12	0.11
   query13	0.62	0.60	0.59
   query14	0.85	0.77	0.80
   query15	0.86	0.86	0.85
   query16	0.37	0.38	0.39
   query17	1.05	1.05	1.04
   query18	0.23	0.21	0.21
   query19	1.89	1.83	1.81
   query20	0.01	0.01	0.02
   query21	15.40	0.91	0.54
   query22	0.76	1.16	0.77
   query23	14.77	1.34	0.60
   query24	7.21	0.80	0.70
   query25	0.50	0.12	0.14
   query26	0.68	0.17	0.13
   query27	0.05	0.06	0.05
   query28	9.52	0.88	0.44
   query29	12.57	3.88	3.26
   query30	0.26	0.09	0.06
   query31	2.83	0.59	0.39
   query32	3.22	0.55	0.47
   query33	3.13	3.06	3.09
   query34	15.79	5.11	4.52
   query35	4.50	4.52	4.56
   query36	0.68	0.49	0.49
   query37	0.09	0.06	0.07
   query38	0.04	0.04	0.03
   query39	0.03	0.03	0.02
   query40	0.17	0.15	0.14
   query41	0.08	0.03	0.03
   query42	0.03	0.02	0.02
   query43	0.03	0.03	0.02
   Total cold run time: 103.64 s
   Total hot run time: 29.06 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 191872 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 72ad9dd758eefad73975c6f040e2210022c700ec, data reload: false
   
   query1	1392	1098	1074	1074
   query2	6303	1913	1938	1913
   query3	11034	4718	4423	4423
   query4	25496	23735	23030	23030
   query5	4463	613	454	454
   query6	313	212	193	193
   query7	3982	492	275	275
   query8	288	254	231	231
   query9	8513	2611	2598	2598
   query10	481	337	274	274
   query11	15351	15222	14850	14850
   query12	164	108	112	108
   query13	1573	525	402	402
   query14	8892	6047	6206	6047
   query15	205	193	167	167
   query16	7447	624	477	477
   query17	1197	734	592	592
   query18	2192	418	305	305
   query19	190	198	170	170
   query20	132	124	119	119
   query21	210	125	112	112
   query22	4418	4480	4214	4214
   query23	34681	33876	33531	33531
   query24	9036	2403	2431	2403
   query25	518	471	423	423
   query26	1191	276	155	155
   query27	2775	523	346	346
   query28	4801	2155	2146	2146
   query29	689	565	445	445
   query30	280	220	193	193
   query31	913	894	810	810
   query32	70	70	66	66
   query33	534	384	304	304
   query34	788	850	529	529
   query35	809	819	739	739
   query36	947	1013	895	895
   query37	106	103	80	80
   query38	4225	4302	4288	4288
   query39	1562	1486	1471	1471
   query40	218	125	115	115
   query41	55	55	51	51
   query42	127	108	112	108
   query43	514	521	476	476
   query44	1312	825	821	821
   query45	182	175	169	169
   query46	857	1026	641	641
   query47	1844	1836	1764	1764
   query48	403	438	325	325
   query49	766	541	437	437
   query50	668	696	415	415
   query51	4253	4291	4274	4274
   query52	117	107	97	97
   query53	232	270	183	183
   query54	590	564	521	521
   query55	82	82	82	82
   query56	325	317	291	291
   query57	1190	1233	1119	1119
   query58	271	267	260	260
   query59	2772	2980	2712	2712
   query60	349	357	310	310
   query61	163	152	155	152
   query62	760	753	681	681
   query63	228	190	204	190
   query64	4170	1081	677	677
   query65	4403	4329	4338	4329
   query66	1322	407	308	308
   query67	15779	15691	15348	15348
   query68	8714	882	523	523
   query69	481	296	266	266
   query70	1162	1094	1081	1081
   query71	470	314	296	296
   query72	5805	4669	4635	4635
   query73	693	577	353	353
   query74	8901	9311	8696	8696
   query75	3933	3201	2803	2803
   query76	3775	1195	733	733
   query77	784	368	291	291
   query78	10174	10078	9409	9409
   query79	2819	813	571	571
   query80	726	504	451	451
   query81	495	252	225	225
   query82	516	126	95	95
   query83	283	245	222	222
   query84	289	111	82	82
   query85	789	353	394	353
   query86	385	326	285	285
   query87	4429	4497	4359	4359
   query88	3339	2290	2248	2248
   query89	400	319	279	279
   query90	1824	208	207	207
   query91	143	152	110	110
   query92	76	60	53	53
   query93	1940	952	571	571
   query94	667	402	296	296
   query95	369	291	273	273
   query96	493	571	282	282
   query97	2738	2779	2637	2637
   query98	222	210	202	202
   query99	1431	1429	1277	1277
   Total cold run time: 281378 ms
   Total hot run time: 191872 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33911 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 2496d7c779fbcd3ebd72a61f3d4d1a1e52054c2d, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26448	5084	5041	5041
   q2	2079	282	199	199
   q3	10481	1276	714	714
   q4	10225	1018	518	518
   q5	7662	2327	2394	2327
   q6	179	166	135	135
   q7	889	757	616	616
   q8	9310	1311	1079	1079
   q9	6820	5211	5157	5157
   q10	6901	2309	1888	1888
   q11	505	287	279	279
   q12	342	355	215	215
   q13	17784	3679	3097	3097
   q14	240	228	217	217
   q15	530	490	477	477
   q16	419	441	377	377
   q17	610	863	371	371
   q18	7698	7179	7055	7055
   q19	1882	974	558	558
   q20	332	337	226	226
   q21	3674	3275	2374	2374
   q22	1035	991	999	991
   Total cold run time: 116045 ms
   Total hot run time: 33911 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5207	5110	5104	5104
   q2	241	324	234	234
   q3	2150	2662	2273	2273
   q4	1361	1799	1402	1402
   q5	4458	4385	4380	4380
   q6	227	175	136	136
   q7	1948	1936	1763	1763
   q8	2680	2685	2630	2630
   q9	7238	7133	6991	6991
   q10	3033	3170	2743	2743
   q11	582	498	486	486
   q12	701	747	612	612
   q13	3546	3881	3271	3271
   q14	284	332	283	283
   q15	533	490	475	475
   q16	440	490	447	447
   q17	1165	1534	1401	1401
   q18	7879	7593	7494	7494
   q19	795	805	897	805
   q20	2019	1977	1856	1856
   q21	4851	4536	4486	4486
   q22	1119	1070	1026	1026
   Total cold run time: 52457 ms
   Total hot run time: 50298 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.94 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 0e15d5b4b3d827c53b83d032de2f5101c161134d, data reload: false
   
   query1	0.05	0.04	0.03
   query2	0.13	0.11	0.10
   query3	0.27	0.20	0.19
   query4	1.60	0.11	0.11
   query5	0.45	0.40	0.43
   query6	1.14	0.66	0.67
   query7	0.03	0.02	0.02
   query8	0.04	0.03	0.03
   query9	0.58	0.52	0.51
   query10	0.57	0.57	0.56
   query11	0.16	0.11	0.11
   query12	0.15	0.11	0.12
   query13	0.62	0.61	0.61
   query14	0.81	0.82	0.81
   query15	0.88	0.86	0.90
   query16	0.39	0.38	0.38
   query17	1.09	1.09	1.06
   query18	0.23	0.21	0.21
   query19	1.96	1.82	1.80
   query20	0.02	0.01	0.01
   query21	15.40	0.92	0.54
   query22	0.77	1.23	0.78
   query23	14.79	1.38	0.66
   query24	7.44	1.30	0.35
   query25	0.43	0.28	0.14
   query26	0.62	0.18	0.14
   query27	0.06	0.06	0.05
   query28	9.38	0.92	0.44
   query29	12.58	4.04	3.31
   query30	0.25	0.09	0.06
   query31	2.83	0.59	0.39
   query32	3.22	0.57	0.47
   query33	3.04	3.16	3.11
   query34	15.98	5.15	4.53
   query35	4.58	4.60	4.57
   query36	0.66	0.50	0.49
   query37	0.12	0.07	0.06
   query38	0.06	0.05	0.04
   query39	0.03	0.03	0.03
   query40	0.17	0.15	0.13
   query41	0.08	0.03	0.02
   query42	0.03	0.02	0.02
   query43	0.04	0.04	0.04
   Total cold run time: 103.73 s
   Total hot run time: 28.94 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33724 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 c81d0eb6ba285c3cfd89ac1856121a23467d2203, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26270	5031	5118	5031
   q2	2126	266	178	178
   q3	10407	1220	684	684
   q4	10235	981	495	495
   q5	7514	2305	2335	2305
   q6	178	163	131	131
   q7	875	758	628	628
   q8	9302	1235	1107	1107
   q9	6771	5083	5071	5071
   q10	6815	2301	1882	1882
   q11	473	284	283	283
   q12	334	345	219	219
   q13	17774	3672	3037	3037
   q14	232	230	206	206
   q15	526	484	492	484
   q16	432	430	377	377
   q17	608	839	358	358
   q18	8019	7281	7174	7174
   q19	1211	943	577	577
   q20	338	339	220	220
   q21	3680	3159	2312	2312
   q22	1057	1030	965	965
   Total cold run time: 115177 ms
   Total hot run time: 33724 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5098	5070	5081	5070
   q2	242	331	232	232
   q3	2157	2645	2262	2262
   q4	1320	1742	1407	1407
   q5	4416	4364	4337	4337
   q6	212	166	134	134
   q7	2010	1918	1796	1796
   q8	2562	2486	2472	2472
   q9	7224	7115	6986	6986
   q10	2956	3197	2768	2768
   q11	584	525	496	496
   q12	676	745	647	647
   q13	3451	3863	3362	3362
   q14	297	296	288	288
   q15	518	475	471	471
   q16	451	499	462	462
   q17	1157	1516	1426	1426
   q18	7720	7515	7438	7438
   q19	817	814	859	814
   q20	2076	1961	1842	1842
   q21	4890	4493	4433	4433
   q22	1072	1053	988	988
   Total cold run time: 51906 ms
   Total hot run time: 50131 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33833 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 7812a5979523ef2ca73ccd878551c905f6afbb4c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26730	5037	5015	5015
   q2	2112	301	192	192
   q3	10434	1231	688	688
   q4	10225	998	525	525
   q5	7545	2378	2291	2291
   q6	180	172	135	135
   q7	924	728	605	605
   q8	9296	1262	1047	1047
   q9	6802	5137	5052	5052
   q10	6875	2302	1890	1890
   q11	504	278	272	272
   q12	338	347	214	214
   q13	17806	3677	3076	3076
   q14	242	224	220	220
   q15	528	478	490	478
   q16	432	429	383	383
   q17	589	856	361	361
   q18	7890	7223	7292	7223
   q19	1630	964	574	574
   q20	335	337	233	233
   q21	3820	2563	2375	2375
   q22	1030	1018	984	984
   Total cold run time: 116267 ms
   Total hot run time: 33833 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5092	5071	5039	5039
   q2	236	327	234	234
   q3	2144	2664	2254	2254
   q4	1348	1810	1383	1383
   q5	4477	4306	4459	4306
   q6	220	171	125	125
   q7	1994	1960	1752	1752
   q8	2578	2608	2533	2533
   q9	7267	7298	6966	6966
   q10	3063	3191	2797	2797
   q11	575	524	498	498
   q12	667	776	616	616
   q13	3552	3889	3335	3335
   q14	294	327	292	292
   q15	535	477	480	477
   q16	447	494	443	443
   q17	1149	1565	1386	1386
   q18	7828	7605	7466	7466
   q19	814	797	889	797
   q20	2045	2031	1838	1838
   q21	4850	4578	4380	4380
   q22	1105	1060	1036	1036
   Total cold run time: 52280 ms
   Total hot run time: 49953 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 193422 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 c81d0eb6ba285c3cfd89ac1856121a23467d2203, data reload: false
   
   query1	1419	1100	1078	1078
   query2	6074	1879	1813	1813
   query3	10980	4506	4492	4492
   query4	54584	25122	23343	23343
   query5	5008	537	467	467
   query6	368	232	197	197
   query7	4898	516	296	296
   query8	337	245	232	232
   query9	5857	2617	2608	2608
   query10	443	335	261	261
   query11	15107	15069	15155	15069
   query12	165	109	101	101
   query13	1046	513	403	403
   query14	10158	6242	6328	6242
   query15	229	205	175	175
   query16	7140	682	488	488
   query17	1074	736	572	572
   query18	1697	400	331	331
   query19	208	191	179	179
   query20	135	132	130	130
   query21	208	123	119	119
   query22	4511	4494	4514	4494
   query23	34331	33567	33516	33516
   query24	6655	2398	2447	2398
   query25	487	459	405	405
   query26	675	282	159	159
   query27	2269	538	361	361
   query28	2939	2156	2155	2155
   query29	613	592	475	475
   query30	288	217	199	199
   query31	896	878	799	799
   query32	70	65	67	65
   query33	459	406	338	338
   query34	810	860	519	519
   query35	782	836	765	765
   query36	955	999	895	895
   query37	114	97	83	83
   query38	4175	4378	4179	4179
   query39	1493	1449	1451	1449
   query40	213	119	107	107
   query41	55	54	54	54
   query42	130	106	118	106
   query43	505	508	485	485
   query44	1366	854	843	843
   query45	182	186	166	166
   query46	862	1039	656	656
   query47	1851	1912	1834	1834
   query48	409	445	331	331
   query49	717	518	443	443
   query50	676	702	416	416
   query51	4350	4239	4257	4239
   query52	108	114	99	99
   query53	228	258	193	193
   query54	595	591	528	528
   query55	89	86	92	86
   query56	314	323	292	292
   query57	1167	1173	1151	1151
   query58	269	263	267	263
   query59	2717	2893	2711	2711
   query60	336	332	324	324
   query61	131	130	151	130
   query62	764	756	686	686
   query63	238	193	205	193
   query64	1762	1143	784	784
   query65	4290	4318	4307	4307
   query66	788	421	330	330
   query67	16029	15741	15531	15531
   query68	7113	898	530	530
   query69	554	311	288	288
   query70	1125	1115	1116	1115
   query71	500	333	301	301
   query72	5785	4711	4740	4711
   query73	1490	592	351	351
   query74	8888	8886	8679	8679
   query75	3854	3203	2706	2706
   query76	4118	1195	745	745
   query77	614	367	289	289
   query78	10125	10292	9297	9297
   query79	2437	808	598	598
   query80	659	513	464	464
   query81	489	258	220	220
   query82	440	127	97	97
   query83	341	248	237	237
   query84	296	104	84	84
   query85	763	354	310	310
   query86	382	307	283	283
   query87	4363	4430	4402	4402
   query88	3612	2325	2396	2325
   query89	414	316	290	290
   query90	1853	202	210	202
   query91	143	138	112	112
   query92	72	62	58	58
   query93	2009	934	590	590
   query94	673	383	298	298
   query95	364	301	290	290
   query96	498	580	291	291
   query97	2731	2783	2656	2656
   query98	229	205	198	198
   query99	1411	1384	1267	1267
   Total cold run time: 299143 ms
   Total hot run time: 193422 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 185704 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 92dbadb3ac924b5ce0d10fbe888a698caccc44d0, data reload: false
   
   query1	1000	482	500	482
   query2	6574	1828	1806	1806
   query3	6760	240	225	225
   query4	26024	23709	23124	23124
   query5	4341	640	451	451
   query6	286	199	211	199
   query7	4616	503	279	279
   query8	291	244	228	228
   query9	8617	2624	2622	2622
   query10	490	326	270	270
   query11	15171	15043	14769	14769
   query12	155	111	108	108
   query13	1663	524	433	433
   query14	8714	6175	6355	6175
   query15	212	197	168	168
   query16	7137	647	490	490
   query17	937	728	572	572
   query18	1986	409	320	320
   query19	201	195	163	163
   query20	120	125	119	119
   query21	211	123	109	109
   query22	4068	4215	4127	4127
   query23	33963	33172	33087	33087
   query24	8449	2389	2390	2389
   query25	585	466	390	390
   query26	1233	261	155	155
   query27	2760	502	335	335
   query28	4339	2109	2092	2092
   query29	754	546	431	431
   query30	286	219	194	194
   query31	923	855	768	768
   query32	138	65	58	58
   query33	556	360	310	310
   query34	785	850	544	544
   query35	766	794	712	712
   query36	970	991	884	884
   query37	111	100	74	74
   query38	4095	4189	4187	4187
   query39	1470	1419	1413	1413
   query40	211	115	105	105
   query41	56	55	72	55
   query42	122	116	113	113
   query43	517	506	468	468
   query44	1294	822	812	812
   query45	175	167	168	167
   query46	833	1025	629	629
   query47	1741	1806	1725	1725
   query48	389	432	310	310
   query49	764	518	418	418
   query50	630	700	407	407
   query51	4146	4109	4140	4109
   query52	111	108	101	101
   query53	224	252	190	190
   query54	577	568	507	507
   query55	88	87	83	83
   query56	304	297	309	297
   query57	1112	1132	1125	1125
   query58	260	264	254	254
   query59	2470	2697	2493	2493
   query60	321	310	315	310
   query61	129	123	124	123
   query62	788	712	652	652
   query63	225	180	181	180
   query64	4351	992	670	670
   query65	4312	4173	4204	4173
   query66	1164	425	323	323
   query67	15873	15449	15320	15320
   query68	8630	881	560	560
   query69	482	310	271	271
   query70	1181	1117	1079	1079
   query71	470	316	287	287
   query72	5374	4692	4959	4692
   query73	737	629	352	352
   query74	8785	9237	8825	8825
   query75	4168	3182	2691	2691
   query76	3750	1239	743	743
   query77	793	392	288	288
   query78	10019	10082	9373	9373
   query79	2800	816	579	579
   query80	631	513	497	497
   query81	477	257	218	218
   query82	478	123	96	96
   query83	288	246	230	230
   query84	301	112	91	91
   query85	792	345	308	308
   query86	333	327	273	273
   query87	4358	4379	4334	4334
   query88	3438	2350	2295	2295
   query89	414	317	288	288
   query90	1945	212	200	200
   query91	145	145	115	115
   query92	81	62	56	56
   query93	2494	948	573	573
   query94	672	405	306	306
   query95	364	295	286	286
   query96	494	584	279	279
   query97	2660	2730	2664	2664
   query98	249	211	201	201
   query99	1443	1417	1273	1273
   Total cold run time: 274190 ms
   Total hot run time: 185704 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192942 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 7812a5979523ef2ca73ccd878551c905f6afbb4c, data reload: false
   
   query1	1407	1103	1062	1062
   query2	6263	1804	1807	1804
   query3	11027	4598	4412	4412
   query4	53770	24586	23605	23605
   query5	5089	543	452	452
   query6	342	213	192	192
   query7	4867	504	288	288
   query8	303	253	229	229
   query9	5658	2615	2621	2615
   query10	438	344	272	272
   query11	15005	15060	14805	14805
   query12	163	109	106	106
   query13	1048	523	429	429
   query14	10109	6274	6310	6274
   query15	207	207	171	171
   query16	7061	671	524	524
   query17	1088	745	617	617
   query18	1579	419	321	321
   query19	206	199	180	180
   query20	131	126	137	126
   query21	214	145	118	118
   query22	4686	4629	4332	4332
   query23	34410	33731	33603	33603
   query24	6668	2498	2458	2458
   query25	491	479	417	417
   query26	709	283	157	157
   query27	2305	517	340	340
   query28	3227	2135	2144	2135
   query29	577	570	448	448
   query30	273	217	193	193
   query31	892	882	788	788
   query32	80	73	63	63
   query33	456	375	315	315
   query34	778	873	558	558
   query35	809	840	746	746
   query36	980	1017	912	912
   query37	109	99	70	70
   query38	4241	4248	4210	4210
   query39	1540	1465	1536	1465
   query40	205	123	109	109
   query41	54	55	57	55
   query42	127	118	124	118
   query43	499	507	493	493
   query44	1345	830	830	830
   query45	185	176	165	165
   query46	864	1022	655	655
   query47	1872	1882	1830	1830
   query48	404	436	315	315
   query49	705	506	439	439
   query50	652	693	408	408
   query51	4318	4248	4253	4248
   query52	116	111	112	111
   query53	234	262	192	192
   query54	592	582	531	531
   query55	86	89	88	88
   query56	327	305	295	295
   query57	1214	1211	1124	1124
   query58	282	263	263	263
   query59	2610	2733	2644	2644
   query60	337	326	316	316
   query61	130	121	131	121
   query62	747	737	645	645
   query63	227	198	190	190
   query64	1475	1026	674	674
   query65	4322	4210	4294	4210
   query66	710	410	359	359
   query67	15914	15612	15682	15612
   query68	6977	879	531	531
   query69	549	315	266	266
   query70	1221	1149	1096	1096
   query71	521	353	296	296
   query72	5852	4778	4736	4736
   query73	1389	613	355	355
   query74	9250	8836	8624	8624
   query75	3827	3231	2684	2684
   query76	4198	1191	763	763
   query77	629	373	279	279
   query78	10023	10113	9319	9319
   query79	2203	818	567	567
   query80	581	501	460	460
   query81	482	249	222	222
   query82	461	122	92	92
   query83	253	242	237	237
   query84	302	109	102	102
   query85	781	357	321	321
   query86	376	297	295	295
   query87	4359	4524	4328	4328
   query88	3714	2304	2341	2304
   query89	407	328	282	282
   query90	1785	202	204	202
   query91	147	135	116	116
   query92	76	60	61	60
   query93	1847	943	577	577
   query94	661	419	310	310
   query95	369	286	286	286
   query96	498	569	278	278
   query97	2738	2785	2621	2621
   query98	247	210	204	204
   query99	1323	1432	1277	1277
   Total cold run time: 297805 ms
   Total hot run time: 192942 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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run FE UT


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.66 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 2496d7c779fbcd3ebd72a61f3d4d1a1e52054c2d, data reload: false
   
   query1	0.04	0.03	0.04
   query2	0.12	0.11	0.11
   query3	0.25	0.19	0.19
   query4	1.59	0.20	0.20
   query5	0.45	0.46	0.44
   query6	1.14	0.67	0.66
   query7	0.02	0.02	0.02
   query8	0.04	0.04	0.04
   query9	0.57	0.51	0.52
   query10	0.58	0.59	0.57
   query11	0.16	0.11	0.11
   query12	0.15	0.11	0.11
   query13	0.61	0.60	0.60
   query14	0.79	0.81	0.80
   query15	0.88	0.86	0.87
   query16	0.38	0.38	0.38
   query17	1.08	1.06	1.10
   query18	0.22	0.20	0.21
   query19	1.90	1.84	1.84
   query20	0.01	0.01	0.02
   query21	15.39	0.92	0.55
   query22	0.76	1.24	0.64
   query23	14.91	1.38	0.60
   query24	7.18	2.08	0.36
   query25	0.29	0.17	0.08
   query26	0.64	0.17	0.15
   query27	0.06	0.05	0.06
   query28	8.54	0.88	0.45
   query29	12.59	3.93	3.27
   query30	0.26	0.10	0.07
   query31	2.86	0.60	0.38
   query32	3.24	0.55	0.47
   query33	2.97	3.14	3.08
   query34	15.71	5.10	4.49
   query35	4.57	4.53	4.47
   query36	0.69	0.50	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.14	0.13
   query41	0.08	0.02	0.02
   query42	0.03	0.02	0.03
   query43	0.03	0.03	0.03
   Total cold run time: 102.12 s
   Total hot run time: 28.66 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   run external
   


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.36 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 72ad9dd758eefad73975c6f040e2210022c700ec, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.13	0.11	0.12
   query3	0.24	0.21	0.21
   query4	1.59	0.20	0.21
   query5	0.46	0.44	0.44
   query6	1.17	0.66	0.65
   query7	0.02	0.02	0.02
   query8	0.04	0.03	0.04
   query9	0.59	0.51	0.52
   query10	0.55	0.58	0.56
   query11	0.15	0.11	0.11
   query12	0.15	0.12	0.11
   query13	0.62	0.60	0.59
   query14	0.82	0.79	0.81
   query15	0.88	0.86	0.87
   query16	0.38	0.38	0.38
   query17	1.01	1.02	1.02
   query18	0.23	0.21	0.21
   query19	1.95	1.75	1.85
   query20	0.01	0.01	0.01
   query21	15.39	0.90	0.56
   query22	0.77	1.23	0.68
   query23	14.81	1.42	0.69
   query24	6.83	1.80	1.04
   query25	0.56	0.18	0.08
   query26	0.63	0.16	0.13
   query27	0.05	0.05	0.05
   query28	10.00	0.90	0.44
   query29	12.52	4.09	3.29
   query30	0.25	0.09	0.07
   query31	2.82	0.60	0.39
   query32	3.22	0.55	0.48
   query33	3.08	3.12	3.13
   query34	15.87	5.13	4.46
   query35	4.47	4.46	4.54
   query36	0.67	0.50	0.48
   query37	0.08	0.06	0.07
   query38	0.05	0.04	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.14	0.14
   query41	0.08	0.03	0.03
   query42	0.03	0.03	0.02
   query43	0.03	0.03	0.03
   Total cold run time: 103.45 s
   Total hot run time: 29.36 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on code in PR #50787:
URL: https://github.com/apache/doris/pull/50787#discussion_r2106384895


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowReplicaStatusCommand.java:
##########
@@ -0,0 +1,220 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.catalog.MetadataViewer;
+import org.apache.doris.catalog.Replica.ReplicaStatus;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.DdlException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.util.Util;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.analyzer.UnboundSlot;
+import org.apache.doris.nereids.trees.expressions.EqualTo;
+import org.apache.doris.nereids.trees.expressions.Expression;
+import org.apache.doris.nereids.trees.expressions.Not;
+import org.apache.doris.nereids.trees.expressions.literal.StringLiteral;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.commands.info.PartitionNamesInfo;
+import org.apache.doris.nereids.trees.plans.commands.info.TableRefInfo;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.collect.ImmutableList;
+import com.google.common.collect.Lists;
+
+import java.util.List;
+
+/**
+ * ShowReplicaStatusCommand
+ */
+public class ShowReplicaStatusCommand extends ShowCommand {
+    public static final ImmutableList<String> TITLE_NAMES = new ImmutableList.Builder<String>()
+            .add("TabletId").add("ReplicaId").add("BackendId").add("Version").add("LastFailedVersion")
+            .add("LastSuccessVersion").add("CommittedVersion").add("SchemaHash").add("VersionNum")
+            .add("IsBad").add("IsUserDrop").add("State").add("Status")
+            .build();
+
+    private final TableRefInfo tableRefInfo;
+    private Expression where;
+    private List<String> partitions = Lists.newArrayList();
+    private ReplicaStatus statusFilter;
+
+    public ShowReplicaStatusCommand(TableRefInfo tableRefInfo, Expression where) {
+        super(PlanType.SHOW_REPLICA_STATUS_COMMAND);
+        this.tableRefInfo = tableRefInfo;
+        this.where = where;
+    }
+
+    @Override
+    public ShowResultSet doRun(ConnectContext ctx, StmtExecutor executor) throws Exception {
+        validate(ctx);
+        return handleShowReplicaStatus();
+    }
+
+    /**
+     * validate
+     */
+    public void validate(ConnectContext ctx) throws AnalysisException {
+        // check auth
+        if (!Env.getCurrentEnv().getAccessManager().checkGlobalPriv(ConnectContext.get(), PrivPredicate.ADMIN)) {
+            ErrorReport.reportAnalysisException(ErrorCode.ERR_SPECIFIC_ACCESS_DENIED_ERROR, "ADMIN");
+        }
+
+        tableRefInfo.getTableNameInfo().analyze(ctx);
+        Util.prohibitExternalCatalog(tableRefInfo.getTableNameInfo().getCtl(), this.getClass().getSimpleName());
+
+        PartitionNamesInfo partitionNamesInfo = tableRefInfo.getPartitionNamesInfo();
+        if (partitionNamesInfo != null) {
+            if (partitionNamesInfo.isTemp()) {
+                throw new AnalysisException("Do not support showing replica status of temporary partitions");
+            }
+            partitions.addAll(partitionNamesInfo.getPartitionNames());
+        }
+
+        if (!analyzeWhereClause()) {
+            throw new AnalysisException(
+                "Where clause should looks like: status =/!= 'OK/DEAD/VERSION_ERROR/SCHEMA_ERROR/MISSING'");
+        }
+    }
+
+    private boolean analyzeWhereClause() {
+        if (where == null) {
+            return true;
+        }
+
+        if (!(where instanceof EqualTo || where instanceof Not)) {
+            return false;
+        }
+
+        if (where instanceof Not) {
+            if (!(where.child(0) instanceof EqualTo)) {
+                return false;
+            }
+        }
+
+        Expression leftExpr = null;
+        if (where instanceof EqualTo) {
+            leftExpr = where.child(0);
+        } else if (where instanceof Not) {
+            leftExpr = where.child(0).child(0);
+        }
+
+        if (leftExpr == null) {
+            return false;
+        }
+
+        if (!(leftExpr instanceof UnboundSlot)) {
+            return false;
+        }
+
+        String leftKey = ((UnboundSlot) leftExpr).getName();
+        if (!leftKey.equalsIgnoreCase("status")) {
+            return false;
+        }
+
+        Expression rightExpr = null;
+        if (where instanceof EqualTo) {
+            rightExpr = where.child(1);
+        } else if (where instanceof Not) {
+            rightExpr = where.child(0).child(1);
+        }
+
+        if (rightExpr == null) {
+            return false;
+        }
+
+        if (!(rightExpr instanceof StringLiteral)) {
+            return false;
+        }
+
+        try {
+            statusFilter = ReplicaStatus.valueOf(((StringLiteral) rightExpr).getStringValue().toUpperCase());
+        } catch (Exception e) {
+            return false;
+        }
+
+        if (statusFilter == null) {
+            return false;
+        }
+
+        return true;
+    }
+
+    public String getDbName() {
+        return tableRefInfo.getTableNameInfo().getDb();
+    }
+
+    public String getTblName() {
+        return tableRefInfo.getTableNameInfo().getTbl();
+    }
+
+    public List<String> getPartitions() {
+        return partitions;
+    }
+
+    /**
+     * where expression is equal expression or not
+     */
+    public boolean isEqual() {
+        if (where == null) {
+            return false;
+        }
+
+        if (where instanceof EqualTo) {
+            return true;
+        }
+
+        return false;
+    }
+
+    public ReplicaStatus getStatusFilter() {
+        return statusFilter;
+    }
+
+    private ShowResultSet handleShowReplicaStatus() throws AnalysisException {
+        List<List<String>> results;
+        try {
+            results = MetadataViewer.getTabletStatus(this);
+        } catch (DdlException e) {
+            throw new AnalysisException(e.getMessage());
+        }
+        return new ShowResultSet(getMetaData(), results);
+    }
+
+    @Override
+    public <R, C> R accept(PlanVisitor<R, C> visitor, C context) {
+        return visitor.visitShowReplicaStatusCommand(this, context);
+    }
+

Review Comment:
   ```
   @Override
   public RedirectStatus toRedirectStatus() {
       if (ConnectContext.get().getSessionVariable().getForwardToMaster()) {
           return RedirectStatus.FORWARD_NO_SYNC;
       } else {
           return RedirectStatus.NO_FORWARD;
       }
   }
   ```



-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe ut


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run external


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   run p0 regression


-- 
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) implement ShowReplicaStatusCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.46 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 c81d0eb6ba285c3cfd89ac1856121a23467d2203, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.12	0.10	0.12
   query3	0.24	0.20	0.19
   query4	1.59	0.19	0.20
   query5	0.43	0.40	0.43
   query6	1.17	0.65	0.67
   query7	0.02	0.02	0.02
   query8	0.04	0.04	0.03
   query9	0.59	0.53	0.50
   query10	0.58	0.58	0.57
   query11	0.15	0.11	0.11
   query12	0.15	0.11	0.11
   query13	0.62	0.61	0.61
   query14	0.79	0.80	0.81
   query15	0.88	0.84	0.85
   query16	0.38	0.40	0.38
   query17	1.02	1.05	1.06
   query18	0.22	0.21	0.21
   query19	1.90	1.77	1.81
   query20	0.01	0.01	0.01
   query21	15.43	0.90	0.57
   query22	0.76	1.17	0.69
   query23	14.98	1.39	0.63
   query24	6.69	1.56	1.12
   query25	0.48	0.26	0.06
   query26	0.50	0.16	0.14
   query27	0.05	0.06	0.05
   query28	9.02	0.93	0.45
   query29	12.53	4.06	3.42
   query30	0.26	0.09	0.07
   query31	2.82	0.58	0.38
   query32	3.24	0.55	0.48
   query33	3.04	3.04	3.03
   query34	15.76	5.10	4.48
   query35	4.54	4.50	4.50
   query36	0.68	0.50	0.49
   query37	0.09	0.07	0.06
   query38	0.05	0.04	0.04
   query39	0.03	0.02	0.02
   query40	0.17	0.14	0.13
   query41	0.08	0.03	0.03
   query42	0.03	0.02	0.02
   query43	0.04	0.03	0.04
   Total cold run time: 102.21 s
   Total hot run time: 29.46 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] [Enhancement] (nereids) implement ShowReplicaStatusCommand in nereids [doris]

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

   run fe


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