Skip to content

[Chore](nereids) Remove ShowTabletStmt #51578

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
wants to merge 5 commits into
base: master
Choose a base branch
from
Open

[Chore](nereids) Remove ShowTabletStmt #51578

wants to merge 5 commits into from
+24 −547

Conversation

xiedeyantu
Copy link
Member

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

  • Test

    • 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

  • Behavior changed:

    • No.
    • Yes.

  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@Thearas
Copy link
Contributor

Thearas commented Jun 9, 2025

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See 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?

@xiedeyantu
Copy link
Member Author

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 34258 ms 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit bc27e6c7328d7ca8060d216c0b8b896aa82013f8, data reload: false

------ Round 1 ----------------------------------
q1	26041	5129	5049	5049
q2	2148	267	174	174
q3	11781	1283	694	694
q4	10225	991	545	545
q5	8013	2363	2348	2348
q6	175	163	137	137
q7	908	736	611	611
q8	9303	1257	1119	1119
q9	6925	5101	5134	5101
q10	6846	2319	1873	1873
q11	498	284	275	275
q12	329	343	207	207
q13	18440	3979	3450	3450
q14	237	236	226	226
q15	579	493	501	493
q16	457	447	399	399
q17	585	857	379	379
q18	9119	7426	7076	7076
q19	1898	940	547	547
q20	344	338	221	221
q21	3783	2608	2343	2343
q22	1075	1011	991	991
Total cold run time: 119709 ms
Total hot run time: 34258 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5487	5048	5054	5048
q2	232	314	225	225
q3	2199	2682	2277	2277
q4	1571	1925	1501	1501
q5	4530	4435	4473	4435
q6	214	174	135	135
q7	2063	1941	1793	1793
q8	2654	2554	2608	2554
q9	7474	7127	7270	7127
q10	3030	3263	2825	2825
q11	587	528	508	508
q12	676	764	670	670
q13	3553	3968	3250	3250
q14	279	317	264	264
q15	517	477	489	477
q16	470	491	444	444
q17	1166	1483	1395	1395
q18	7864	7519	7375	7375
q19	758	782	768	768
q20	1895	1963	1864	1864
q21	4960	4636	4564	4564
q22	1114	1061	1036	1036
Total cold run time: 53293 ms
Total hot run time: 50535 ms

@xiedeyantu
Copy link
Member Author

run buildall

1 similar comment
@xiedeyantu
Copy link
Member Author

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 33316 ms 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 6363fe79af43c94b021f153833c11da16bc211f5, data reload: false

------ Round 1 ----------------------------------
q1	26025	4976	4938	4938
q2	1927	270	177	177
q3	10309	1217	671	671
q4	10227	990	520	520
q5	7519	2259	2351	2259
q6	176	160	132	132
q7	891	740	594	594
q8	9304	1254	1068	1068
q9	6824	5062	5136	5062
q10	6868	2293	1886	1886
q11	478	278	286	278
q12	339	360	211	211
q13	17762	3611	3039	3039
q14	230	232	215	215
q15	562	490	481	481
q16	412	429	372	372
q17	594	850	356	356
q18	7464	7274	6995	6995
q19	1666	948	568	568
q20	335	331	221	221
q21	3580	2536	2276	2276
q22	1042	1041	997	997
Total cold run time: 114534 ms
Total hot run time: 33316 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5102	5031	5007	5007
q2	235	315	223	223
q3	2155	2640	2265	2265
q4	1407	1769	1355	1355
q5	4261	4361	4368	4361
q6	220	176	126	126
q7	1991	1892	1792	1792
q8	2585	2610	2504	2504
q9	7174	7229	7028	7028
q10	2983	3240	2753	2753
q11	564	511	493	493
q12	681	762	590	590
q13	3472	3886	3238	3238
q14	277	293	272	272
q15	534	474	486	474
q16	442	493	444	444
q17	1178	1493	1375	1375
q18	7622	7527	7483	7483
q19	787	845	965	845
q20	1990	1992	1917	1917
q21	4704	4578	4418	4418
q22	1140	1061	1003	1003
Total cold run time: 51504 ms
Total hot run time: 49966 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 193012 ms 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 6363fe79af43c94b021f153833c11da16bc211f5, data reload: false

query1	1401	1087	1075	1075
query2	6405	1815	1772	1772
query3	11138	4751	4451	4451
query4	54536	25313	23399	23399
query5	4973	507	469	469
query6	341	216	197	197
query7	4879	494	294	294
query8	270	233	219	219
query9	5257	2628	2591	2591
query10	439	332	273	273
query11	14944	15008	14819	14819
query12	150	108	102	102
query13	1009	506	409	409
query14	10057	6317	6450	6317
query15	211	200	185	185
query16	7128	645	498	498
query17	1084	779	628	628
query18	1558	428	336	336
query19	204	199	171	171
query20	137	130	121	121
query21	214	123	113	113
query22	4438	4572	4486	4486
query23	34461	33603	33721	33603
query24	6973	2405	2429	2405
query25	465	467	463	463
query26	716	273	151	151
query27	2331	515	345	345
query28	3443	2153	2156	2153
query29	580	562	435	435
query30	271	218	187	187
query31	843	860	747	747
query32	71	60	64	60
query33	478	353	336	336
query34	786	857	522	522
query35	813	836	749	749
query36	953	1014	906	906
query37	107	98	78	78
query38	4246	4243	4235	4235
query39	1478	1489	1469	1469
query40	205	132	109	109
query41	82	57	57	57
query42	139	123	113	113
query43	508	520	479	479
query44	1391	854	866	854
query45	181	172	165	165
query46	842	1060	653	653
query47	1866	1896	1794	1794
query48	401	428	324	324
query49	645	484	407	407
query50	653	716	406	406
query51	4292	4223	4227	4223
query52	114	127	97	97
query53	233	256	188	188
query54	585	589	522	522
query55	86	89	88	88
query56	323	334	291	291
query57	1196	1228	1151	1151
query58	287	265	254	254
query59	2749	2811	2563	2563
query60	347	325	328	325
query61	147	128	132	128
query62	760	726	644	644
query63	223	185	179	179
query64	1723	1050	710	710
query65	4203	4167	4183	4167
query66	721	393	297	297
query67	16089	15743	15574	15574
query68	7818	906	538	538
query69	546	314	269	269
query70	1186	1137	1075	1075
query71	490	322	298	298
query72	5842	4880	5082	4880
query73	1525	734	360	360
query74	9312	8909	8834	8834
query75	3792	3182	2720	2720
query76	4175	1191	750	750
query77	625	360	294	294
query78	10344	10139	9368	9368
query79	6149	810	568	568
query80	636	506	444	444
query81	505	266	220	220
query82	697	129	97	97
query83	360	250	239	239
query84	297	105	90	90
query85	820	355	320	320
query86	405	305	274	274
query87	4515	4446	4264	4264
query88	4114	2325	2301	2301
query89	452	306	288	288
query90	1778	206	211	206
query91	147	141	113	113
query92	80	57	58	57
query93	3923	940	595	595
query94	670	406	301	301
query95	364	304	283	283
query96	497	576	285	285
query97	2761	2742	2667	2667
query98	234	209	204	204
query99	1469	1410	1279	1279
Total cold run time: 307307 ms
Total hot run time: 193012 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 29.23 s 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 6363fe79af43c94b021f153833c11da16bc211f5, data reload: false

query1	0.04	0.04	0.03
query2	0.12	0.10	0.11
query3	0.26	0.19	0.19
query4	1.59	0.18	0.19
query5	0.46	0.44	0.43
query6	1.15	0.67	0.67
query7	0.03	0.02	0.02
query8	0.04	0.03	0.04
query9	0.61	0.51	0.51
query10	0.57	0.58	0.55
query11	0.16	0.11	0.10
query12	0.14	0.12	0.11
query13	0.60	0.60	0.60
query14	0.79	0.81	0.82
query15	0.87	0.86	0.85
query16	0.38	0.38	0.39
query17	1.05	1.03	1.02
query18	0.22	0.21	0.21
query19	1.92	1.85	1.77
query20	0.01	0.01	0.02
query21	15.46	0.89	0.55
query22	0.76	1.17	0.59
query23	15.01	1.39	0.60
query24	6.65	1.96	0.93
query25	0.48	0.18	0.09
query26	0.71	0.18	0.14
query27	0.05	0.05	0.05
query28	9.24	0.87	0.43
query29	12.54	4.23	3.48
query30	0.24	0.09	0.06
query31	2.84	0.59	0.39
query32	3.22	0.55	0.47
query33	3.05	3.09	3.12
query34	15.88	5.11	4.49
query35	4.55	4.54	4.53
query36	0.67	0.50	0.47
query37	0.08	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.03
query40	0.16	0.13	0.13
query41	0.07	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.02	0.02
Total cold run time: 102.82 s
Total hot run time: 29.23 s

@xiedeyantu
Copy link
Member Author

run buildall

@xiedeyantu
Copy link
Member Author

run buildall

1 similar comment
@xiedeyantu
Copy link
Member Author

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 33502 ms 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 668e986fc7d876e653c8823bedebfe3fa7e01811, data reload: false

------ Round 1 ----------------------------------
q1	26024	5331	4994	4994
q2	1959	287	178	178
q3	10282	1203	695	695
q4	10224	981	533	533
q5	7578	2398	2270	2270
q6	176	162	138	138
q7	908	751	610	610
q8	9323	1259	1079	1079
q9	6876	5068	5064	5064
q10	6874	2305	1903	1903
q11	472	293	269	269
q12	347	348	214	214
q13	17763	3700	3065	3065
q14	231	223	209	209
q15	547	483	484	483
q16	430	424	377	377
q17	577	831	363	363
q18	7675	6996	7151	6996
q19	1812	954	556	556
q20	316	326	215	215
q21	3580	3141	2317	2317
q22	1059	1007	974	974
Total cold run time: 115033 ms
Total hot run time: 33502 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5186	5021	5034	5021
q2	228	315	219	219
q3	2130	2638	2294	2294
q4	1321	1759	1336	1336
q5	4391	4386	4410	4386
q6	218	166	123	123
q7	1950	1951	1742	1742
q8	2579	2585	2467	2467
q9	7172	7226	7002	7002
q10	2996	3214	2752	2752
q11	567	502	492	492
q12	680	773	611	611
q13	3504	3965	3289	3289
q14	299	300	269	269
q15	533	503	503	503
q16	449	499	427	427
q17	1125	1451	1402	1402
q18	7838	7547	7579	7547
q19	793	764	877	764
q20	1982	2004	1845	1845
q21	4725	4522	4401	4401
q22	1077	1058	1052	1052
Total cold run time: 51743 ms
Total hot run time: 49944 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192771 ms 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 668e986fc7d876e653c8823bedebfe3fa7e01811, data reload: false

query1	1437	1102	1093	1093
query2	6151	1863	1886	1863
query3	11075	4486	4473	4473
query4	54541	25394	23478	23478
query5	5130	555	479	479
query6	357	214	197	197
query7	4888	520	298	298
query8	288	259	224	224
query9	5451	2641	2624	2624
query10	467	342	272	272
query11	15459	14960	14753	14753
query12	175	117	116	116
query13	1031	515	431	431
query14	10222	6407	6358	6358
query15	208	207	182	182
query16	7097	657	493	493
query17	1106	840	593	593
query18	1524	416	321	321
query19	201	188	179	179
query20	128	128	133	128
query21	241	123	109	109
query22	4374	4385	4155	4155
query23	34187	33512	33695	33512
query24	6788	2439	2437	2437
query25	480	475	427	427
query26	706	271	167	167
query27	2262	514	346	346
query28	3020	2193	2163	2163
query29	587	598	451	451
query30	274	228	193	193
query31	881	876	780	780
query32	71	69	64	64
query33	457	366	317	317
query34	787	854	543	543
query35	810	847	732	732
query36	983	1005	894	894
query37	117	102	81	81
query38	4260	4249	4379	4249
query39	1528	1465	1494	1465
query40	213	119	113	113
query41	66	59	58	58
query42	133	115	113	113
query43	520	521	505	505
query44	1357	857	857	857
query45	183	175	170	170
query46	847	1042	663	663
query47	1871	1880	1785	1785
query48	394	422	334	334
query49	648	480	368	368
query50	670	715	406	406
query51	4218	4201	4315	4201
query52	116	103	101	101
query53	240	254	193	193
query54	599	572	515	515
query55	91	82	86	82
query56	302	299	316	299
query57	1223	1210	1177	1177
query58	271	293	257	257
query59	2731	2825	2668	2668
query60	344	336	321	321
query61	131	128	137	128
query62	772	798	660	660
query63	250	197	187	187
query64	1458	1029	718	718
query65	4216	4112	4171	4112
query66	729	405	307	307
query67	15823	15678	15409	15409
query68	7299	913	532	532
query69	549	304	263	263
query70	1240	1128	1123	1123
query71	501	321	307	307
query72	5890	4816	4905	4816
query73	1525	672	370	370
query74	8994	9116	8815	8815
query75	3911	3213	2730	2730
query76	4201	1202	745	745
query77	718	360	292	292
query78	10162	9948	9325	9325
query79	2564	829	583	583
query80	621	518	433	433
query81	498	252	222	222
query82	441	131	99	99
query83	310	249	236	236
query84	295	110	86	86
query85	780	339	315	315
query86	382	290	296	290
query87	4380	4390	4357	4357
query88	3728	2364	2274	2274
query89	408	306	289	289
query90	1845	212	205	205
query91	145	137	113	113
query92	71	60	60	60
query93	1997	965	594	594
query94	679	419	315	315
query95	373	294	294	294
query96	486	577	277	277
query97	2745	2755	2611	2611
query98	225	203	195	195
query99	1465	1392	1258	1258
Total cold run time: 299593 ms
Total hot run time: 192771 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 29.3 s 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 668e986fc7d876e653c8823bedebfe3fa7e01811, data reload: false

query1	0.04	0.04	0.03
query2	0.13	0.10	0.11
query3	0.26	0.19	0.20
query4	1.59	0.20	0.20
query5	0.47	0.45	0.46
query6	1.16	0.67	0.67
query7	0.03	0.02	0.01
query8	0.04	0.03	0.04
query9	0.59	0.51	0.53
query10	0.56	0.57	0.56
query11	0.16	0.11	0.11
query12	0.15	0.12	0.12
query13	0.61	0.60	0.59
query14	0.78	0.81	0.81
query15	0.87	0.86	0.88
query16	0.38	0.39	0.38
query17	1.00	1.04	1.02
query18	0.23	0.21	0.21
query19	1.94	1.83	1.81
query20	0.01	0.01	0.01
query21	15.40	0.90	0.54
query22	0.77	1.02	0.69
query23	15.09	1.35	0.63
query24	7.07	0.82	1.40
query25	0.52	0.14	0.19
query26	0.59	0.16	0.14
query27	0.05	0.05	0.05
query28	10.02	0.89	0.46
query29	12.64	4.01	3.42
query30	0.25	0.09	0.07
query31	2.80	0.57	0.39
query32	3.24	0.55	0.47
query33	3.03	3.07	3.11
query34	15.74	5.15	4.45
query35	4.50	4.53	4.50
query36	0.65	0.50	0.48
query37	0.10	0.07	0.06
query38	0.05	0.04	0.04
query39	0.04	0.02	0.03
query40	0.16	0.13	0.13
query41	0.08	0.02	0.03
query42	0.03	0.02	0.03
query43	0.04	0.03	0.02
Total cold run time: 103.86 s
Total hot run time: 29.3 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage `` 🎉
Increment coverage report
Complete coverage report

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
4 participants
@xiedeyantu @Thearas @doris-robot @hello-stephen