Skip to content

[Enhancement] (nereids)implement adminSetFrontendConfigCommand in nereids #50616

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 1 commit into
base: master
Choose a base branch
from
Open

[Enhancement] (nereids)implement adminSetFrontendConfigCommand in nereids #50616

wants to merge 1 commit into from

Conversation

codeDing18
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #42842

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

@hello-stephen
Copy link
Contributor

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?

@codeDing18 codeDing18 force-pushed the adminsetfrontconfig-nereids branch from 222bff4 to 1383ca3 Compare June 4, 2025 07:04
@codeDing18
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26929	5021	5020	5020
q2	1980	287	191	191
q3	10261	1240	692	692
q4	10218	989	518	518
q5	7512	2328	2313	2313
q6	181	167	135	135
q7	898	718	619	619
q8	9327	1254	1189	1189
q9	6835	5054	4984	4984
q10	6863	2296	1913	1913
q11	478	294	279	279
q12	352	348	219	219
q13	17788	3649	3068	3068
q14	235	223	221	221
q15	556	474	487	474
q16	427	430	387	387
q17	604	851	381	381
q18	7496	7219	7203	7203
q19	1913	969	582	582
q20	350	356	222	222
q21	3780	3169	2420	2420
q22	1067	1042	1005	1005
Total cold run time: 116050 ms
Total hot run time: 34035 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5164	5048	5036	5036
q2	247	320	232	232
q3	2261	2794	2313	2313
q4	1296	1752	1351	1351
q5	4521	4409	4338	4338
q6	220	171	127	127
q7	1977	1942	1808	1808
q8	2591	2621	2579	2579
q9	7297	7119	7022	7022
q10	3043	3170	2739	2739
q11	571	507	488	488
q12	697	772	631	631
q13	3510	3860	3314	3314
q14	296	321	299	299
q15	527	486	469	469
q16	433	482	446	446
q17	1153	1559	1363	1363
q18	7697	7605	7443	7443
q19	799	787	899	787
q20	2004	1994	1832	1832
q21	4833	4456	4506	4456
q22	1059	1045	1045	1045
Total cold run time: 52196 ms
Total hot run time: 50118 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 193201 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 1383ca3e595e75e6bb43c3b42300906c3e8af34a, data reload: false

query1	1412	1107	1037	1037
query2	6331	1864	1904	1864
query3	10967	4557	4637	4557
query4	57145	25074	22935	22935
query5	5204	481	460	460
query6	413	211	214	211
query7	5350	513	303	303
query8	310	241	220	220
query9	7157	2611	2631	2611
query10	436	322	277	277
query11	15358	15011	14774	14774
query12	159	114	109	109
query13	1293	534	432	432
query14	10033	6551	6642	6551
query15	209	200	181	181
query16	7084	657	508	508
query17	1086	727	594	594
query18	1498	396	307	307
query19	203	192	179	179
query20	131	121	119	119
query21	211	124	108	108
query22	4382	4484	4280	4280
query23	34308	33766	33535	33535
query24	6626	2417	2442	2417
query25	463	488	457	457
query26	663	278	152	152
query27	2206	516	355	355
query28	3368	2142	2128	2128
query29	573	560	438	438
query30	277	227	201	201
query31	868	862	783	783
query32	85	62	66	62
query33	467	379	322	322
query34	811	863	527	527
query35	799	822	749	749
query36	981	997	909	909
query37	115	101	78	78
query38	4309	4344	4236	4236
query39	1518	1487	1488	1487
query40	227	128	114	114
query41	64	59	58	58
query42	131	116	122	116
query43	504	517	484	484
query44	1335	861	825	825
query45	188	179	170	170
query46	859	1037	671	671
query47	1908	1932	1823	1823
query48	411	429	330	330
query49	673	488	395	395
query50	710	700	439	439
query51	4226	4300	4279	4279
query52	110	109	101	101
query53	234	259	186	186
query54	596	617	514	514
query55	86	89	85	85
query56	332	304	300	300
query57	1201	1192	1098	1098
query58	284	296	270	270
query59	2779	2907	2751	2751
query60	377	352	353	352
query61	150	148	150	148
query62	739	740	647	647
query63	231	193	189	189
query64	1521	1099	736	736
query65	4216	4130	4152	4130
query66	722	404	307	307
query67	15957	15980	15566	15566
query68	7396	856	523	523
query69	549	297	276	276
query70	1226	1084	1109	1084
query71	497	319	317	317
query72	5537	4762	4781	4762
query73	1152	655	360	360
query74	9212	9071	8909	8909
query75	3809	3229	2740	2740
query76	4395	1205	779	779
query77	606	385	313	313
query78	10077	10146	9391	9391
query79	4427	806	554	554
query80	689	527	501	501
query81	511	262	217	217
query82	541	133	97	97
query83	427	256	264	256
query84	293	117	95	95
query85	809	354	313	313
query86	391	298	287	287
query87	4469	4509	4367	4367
query88	3169	2276	2256	2256
query89	442	320	291	291
query90	1953	214	215	214
query91	144	149	110	110
query92	73	60	58	58
query93	2341	954	578	578
query94	694	397	309	309
query95	375	307	289	289
query96	506	564	282	282
query97	2826	2780	2669	2669
query98	246	204	209	204
query99	1431	1385	1263	1263
Total cold run time: 306793 ms
Total hot run time: 193201 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.14	0.10	0.12
query3	0.24	0.20	0.20
query4	1.59	0.20	0.21
query5	0.45	0.44	0.46
query6	1.18	0.67	0.66
query7	0.02	0.02	0.02
query8	0.05	0.04	0.04
query9	0.60	0.52	0.53
query10	0.57	0.57	0.57
query11	0.15	0.11	0.11
query12	0.15	0.12	0.12
query13	0.62	0.60	0.60
query14	0.79	0.81	0.81
query15	0.88	0.85	0.89
query16	0.39	0.40	0.40
query17	1.06	1.04	1.03
query18	0.23	0.22	0.22
query19	2.04	1.79	1.82
query20	0.01	0.01	0.01
query21	15.40	0.90	0.53
query22	0.76	1.32	0.78
query23	14.73	1.35	0.61
query24	7.69	0.91	0.80
query25	0.55	0.30	0.15
query26	0.77	0.18	0.14
query27	0.06	0.06	0.05
query28	9.78	0.94	0.45
query29	12.61	4.08	3.34
query30	0.26	0.09	0.06
query31	2.83	0.59	0.38
query32	3.23	0.55	0.48
query33	3.02	3.03	3.06
query34	15.76	5.11	4.48
query35	4.47	4.52	4.53
query36	0.68	0.50	0.48
query37	0.09	0.06	0.07
query38	0.05	0.05	0.03
query39	0.04	0.02	0.02
query40	0.18	0.15	0.13
query41	0.09	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 104.32 s
Total hot run time: 29.31 s

@codeDing18
Copy link
Contributor Author

run external

@codeDing18
Copy link
Contributor Author

run feut

@codeDing18
Copy link
Contributor Author

run external

1 similar comment
@codeDing18
Copy link
Contributor Author

run external

@codeDing18 codeDing18 force-pushed the adminsetfrontconfig-nereids branch from 1383ca3 to 35fdeb3 Compare June 5, 2025 03:30
@codeDing18
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26415	5065	5035	5035
q2	1943	269	175	175
q3	10337	1250	720	720
q4	10218	1034	534	534
q5	7536	2405	2332	2332
q6	190	167	137	137
q7	912	750	642	642
q8	9303	1293	1058	1058
q9	6721	5152	5100	5100
q10	6838	2313	1904	1904
q11	485	300	287	287
q12	348	364	222	222
q13	17766	3740	3147	3147
q14	223	233	218	218
q15	542	509	494	494
q16	414	432	369	369
q17	586	870	385	385
q18	7642	7109	7206	7109
q19	1231	964	578	578
q20	345	350	233	233
q21	4094	3322	2399	2399
q22	1044	1043	989	989
Total cold run time: 115133 ms
Total hot run time: 34067 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5138	5072	5109	5072
q2	229	316	230	230
q3	2163	2706	2282	2282
q4	1371	1770	1416	1416
q5	4619	4487	4432	4432
q6	207	168	128	128
q7	2014	1913	1737	1737
q8	2642	2656	2570	2570
q9	7147	7189	7141	7141
q10	2992	3209	2730	2730
q11	587	512	491	491
q12	699	787	603	603
q13	3501	3878	3204	3204
q14	287	302	279	279
q15	524	478	473	473
q16	441	531	455	455
q17	1168	1551	1381	1381
q18	7810	7595	7413	7413
q19	805	829	948	829
q20	1981	2037	1879	1879
q21	4892	4593	4391	4391
q22	1037	1020	971	971
Total cold run time: 52254 ms
Total hot run time: 50107 ms

@codeDing18
Copy link
Contributor Author

run external

@doris-robot
Copy link

TPC-DS: Total hot run time: 186174 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 35fdeb3d76137db5d9823607967860f802a3a882, data reload: false

query1	1003	479	501	479
query2	6553	1777	1766	1766
query3	6759	219	220	219
query4	26404	23798	23332	23332
query5	4336	616	483	483
query6	307	208	206	206
query7	4625	498	306	306
query8	267	236	220	220
query9	8645	2666	2678	2666
query10	508	331	273	273
query11	15818	15047	14914	14914
query12	156	106	109	106
query13	1651	562	412	412
query14	8757	6171	6174	6171
query15	217	205	165	165
query16	7119	580	486	486
query17	1187	721	565	565
query18	1996	393	302	302
query19	190	182	197	182
query20	122	118	115	115
query21	214	125	109	109
query22	4133	4052	3933	3933
query23	34144	33044	33094	33044
query24	8446	2387	2421	2387
query25	541	454	389	389
query26	1232	280	147	147
query27	2737	499	339	339
query28	4320	2138	2134	2134
query29	772	581	438	438
query30	280	209	187	187
query31	911	835	761	761
query32	77	63	63	63
query33	565	395	300	300
query34	788	843	538	538
query35	772	804	744	744
query36	949	967	897	897
query37	111	101	85	85
query38	4093	4043	4129	4043
query39	1484	1428	1421	1421
query40	211	124	109	109
query41	59	58	55	55
query42	125	107	105	105
query43	490	493	467	467
query44	1347	828	824	824
query45	178	172	169	169
query46	831	1025	618	618
query47	1744	1761	1701	1701
query48	394	452	308	308
query49	731	505	404	404
query50	626	665	408	408
query51	4220	4147	4030	4030
query52	111	104	101	101
query53	216	254	181	181
query54	582	583	493	493
query55	85	80	91	80
query56	307	295	279	279
query57	1132	1144	1062	1062
query58	260	266	249	249
query59	2576	2617	2578	2578
query60	322	312	308	308
query61	133	124	124	124
query62	807	742	655	655
query63	220	187	187	187
query64	4436	1109	765	765
query65	4211	4143	4124	4124
query66	1196	419	325	325
query67	15893	15513	15243	15243
query68	7808	881	530	530
query69	484	342	280	280
query70	1176	1106	1088	1088
query71	450	335	310	310
query72	5674	4775	4962	4775
query73	678	675	351	351
query74	8820	9219	8976	8976
query75	3619	3209	2779	2779
query76	3396	1187	750	750
query77	772	361	308	308
query78	10183	10179	9407	9407
query79	2247	823	596	596
query80	599	505	434	434
query81	478	263	225	225
query82	448	126	106	106
query83	252	252	242	242
query84	246	122	90	90
query85	811	351	318	318
query86	384	318	291	291
query87	4414	4503	4386	4386
query88	3851	2281	2295	2281
query89	391	316	289	289
query90	1856	212	207	207
query91	138	157	109	109
query92	80	60	58	58
query93	1859	943	583	583
query94	678	421	305	305
query95	371	298	285	285
query96	495	572	291	291
query97	2726	2750	2803	2750
query98	232	207	203	203
query99	1414	1377	1292	1292
Total cold run time: 273662 ms
Total hot run time: 186174 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.13	0.10	0.11
query3	0.25	0.20	0.20
query4	1.59	0.19	0.19
query5	0.44	0.41	0.41
query6	1.19	0.67	0.65
query7	0.03	0.01	0.02
query8	0.04	0.04	0.03
query9	0.58	0.52	0.51
query10	0.57	0.58	0.57
query11	0.15	0.11	0.11
query12	0.15	0.12	0.11
query13	0.62	0.61	0.61
query14	0.80	0.81	0.82
query15	0.89	0.85	0.86
query16	0.38	0.38	0.40
query17	1.04	1.03	1.03
query18	0.22	0.21	0.21
query19	1.92	1.78	1.86
query20	0.01	0.01	0.01
query21	15.42	0.86	0.54
query22	0.76	1.20	0.65
query23	14.93	1.38	0.61
query24	6.65	1.99	0.86
query25	0.51	0.15	0.09
query26	0.61	0.16	0.14
query27	0.05	0.05	0.04
query28	9.74	0.86	0.46
query29	12.61	4.10	3.33
query30	0.27	0.09	0.07
query31	2.82	0.61	0.40
query32	3.23	0.57	0.48
query33	3.10	3.08	3.05
query34	15.82	5.17	4.49
query35	4.52	4.53	4.50
query36	0.66	0.50	0.48
query37	0.08	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.14	0.14
query41	0.07	0.02	0.02
query42	0.03	0.02	0.03
query43	0.04	0.03	0.03
Total cold run time: 103.21 s
Total hot run time: 29.12 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 44.07% (26/59) 🎉
Increment coverage report
Complete coverage report

@codeDing18 codeDing18 force-pushed the adminsetfrontconfig-nereids branch 2 times, most recently from 4f482d7 to fe6f91c Compare June 5, 2025 06:49
@codeDing18
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 40.68% (24/59) 🎉
Increment coverage report
Complete coverage report

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26114	5091	5001	5001
q2	1943	281	183	183
q3	10505	1225	701	701
q4	10246	984	543	543
q5	7798	2431	2301	2301
q6	182	161	130	130
q7	901	722	614	614
q8	9315	1274	1122	1122
q9	6744	5087	5102	5087
q10	6860	2294	1904	1904
q11	489	286	263	263
q12	350	340	211	211
q13	17771	3653	3063	3063
q14	223	236	218	218
q15	568	472	500	472
q16	424	431	384	384
q17	581	856	366	366
q18	7727	7196	7245	7196
q19	2092	981	564	564
q20	325	339	225	225
q21	3631	3174	2331	2331
q22	1053	1021	951	951
Total cold run time: 115842 ms
Total hot run time: 33830 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5161	5054	5078	5054
q2	247	318	227	227
q3	2144	2638	2321	2321
q4	1350	1760	1309	1309
q5	4427	4368	4423	4368
q6	214	175	134	134
q7	2008	1885	1774	1774
q8	2562	2587	2527	2527
q9	7267	7157	6917	6917
q10	2964	3265	2738	2738
q11	571	506	488	488
q12	636	766	640	640
q13	3493	3888	3283	3283
q14	277	317	261	261
q15	519	491	477	477
q16	446	478	460	460
q17	1192	1584	1327	1327
q18	7866	7692	7404	7404
q19	816	778	845	778
q20	2000	2048	1952	1952
q21	4807	4488	4398	4398
q22	1112	1050	1048	1048
Total cold run time: 52079 ms
Total hot run time: 49885 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 193097 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 fe6f91c687e75537aabf8dcf9ae7e7dd2a0f425a, data reload: false

query1	1385	1092	1071	1071
query2	6131	1810	1805	1805
query3	11024	4398	4642	4398
query4	55803	25705	23687	23687
query5	5107	518	465	465
query6	347	206	200	200
query7	4881	528	294	294
query8	281	223	225	223
query9	5721	2682	2707	2682
query10	461	323	265	265
query11	15034	15170	14901	14901
query12	157	106	109	106
query13	1033	542	424	424
query14	10149	6315	6288	6288
query15	209	209	184	184
query16	7196	626	479	479
query17	1085	728	572	572
query18	1709	411	314	314
query19	198	187	169	169
query20	139	128	126	126
query21	211	128	106	106
query22	4375	4489	4419	4419
query23	34358	33536	33861	33536
query24	6523	2433	2429	2429
query25	476	474	410	410
query26	700	273	153	153
query27	2214	510	344	344
query28	2980	2212	2171	2171
query29	579	567	424	424
query30	275	218	198	198
query31	858	871	780	780
query32	70	66	63	63
query33	463	397	306	306
query34	797	858	525	525
query35	796	850	739	739
query36	948	994	918	918
query37	116	103	90	90
query38	4248	4339	4212	4212
query39	1524	1449	1475	1449
query40	221	134	121	121
query41	71	67	63	63
query42	139	117	149	117
query43	514	512	487	487
query44	1329	838	849	838
query45	195	177	164	164
query46	861	1032	648	648
query47	1839	1927	1825	1825
query48	415	476	338	338
query49	677	501	399	399
query50	671	707	409	409
query51	4220	4289	4238	4238
query52	114	108	103	103
query53	233	260	190	190
query54	578	582	515	515
query55	89	86	86	86
query56	344	321	288	288
query57	1168	1177	1119	1119
query58	266	279	269	269
query59	2744	2721	2683	2683
query60	349	333	302	302
query61	130	127	142	127
query62	737	760	659	659
query63	217	181	181	181
query64	1715	1029	676	676
query65	4208	4126	4151	4126
query66	710	396	298	298
query67	16119	15591	15344	15344
query68	8076	888	527	527
query69	553	311	280	280
query70	1238	1110	1117	1110
query71	472	316	300	300
query72	5873	4900	4936	4900
query73	1492	711	354	354
query74	8967	9241	8895	8895
query75	3679	3204	2712	2712
query76	4172	1194	748	748
query77	624	376	287	287
query78	10255	10058	9268	9268
query79	4664	808	565	565
query80	644	508	429	429
query81	495	253	221	221
query82	500	126	94	94
query83	370	251	232	232
query84	296	119	91	91
query85	788	400	317	317
query86	388	294	283	283
query87	4486	4378	4422	4378
query88	3277	2290	2256	2256
query89	428	324	281	281
query90	1909	208	213	208
query91	135	141	112	112
query92	76	58	53	53
query93	2265	946	579	579
query94	683	419	290	290
query95	370	299	297	297
query96	487	579	284	284
query97	2765	2779	2677	2677
query98	222	219	201	201
query99	1476	1408	1330	1330
Total cold run time: 303559 ms
Total hot run time: 193097 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.10	0.10
query3	0.26	0.19	0.18
query4	1.59	0.19	0.20
query5	0.45	0.41	0.42
query6	1.16	0.67	0.67
query7	0.03	0.02	0.02
query8	0.04	0.04	0.04
query9	0.58	0.51	0.52
query10	0.57	0.58	0.57
query11	0.15	0.11	0.11
query12	0.15	0.11	0.12
query13	0.62	0.60	0.60
query14	0.77	0.80	0.80
query15	0.88	0.86	0.87
query16	0.38	0.39	0.37
query17	1.04	1.08	1.09
query18	0.23	0.22	0.21
query19	1.88	1.84	1.79
query20	0.01	0.01	0.02
query21	15.40	0.90	0.54
query22	0.76	1.24	0.69
query23	14.89	1.40	0.63
query24	7.65	0.96	0.31
query25	0.37	0.26	0.10
query26	0.67	0.17	0.13
query27	0.06	0.05	0.05
query28	9.11	0.86	0.45
query29	12.54	4.08	3.29
query30	0.25	0.09	0.06
query31	2.82	0.59	0.40
query32	3.25	0.55	0.47
query33	3.04	3.07	3.10
query34	15.73	5.12	4.51
query35	4.50	4.55	4.47
query36	0.65	0.49	0.48
query37	0.08	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.16	0.14	0.12
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 103.12 s
Total hot run time: 28.6 s

@codeDing18 codeDing18 force-pushed the adminsetfrontconfig-nereids branch from fe6f91c to 7574349 Compare June 5, 2025 14:21
@codeDing18
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 40.68% (24/59) 🎉
Increment coverage report
Complete coverage report

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26401	5027	4994	4994
q2	1951	275	193	193
q3	10396	1229	699	699
q4	10233	999	510	510
q5	7811	2354	2327	2327
q6	179	160	131	131
q7	900	735	590	590
q8	9320	1279	1036	1036
q9	6714	5097	5123	5097
q10	6802	2326	1887	1887
q11	473	285	261	261
q12	337	349	221	221
q13	17751	3647	3098	3098
q14	229	222	212	212
q15	565	484	484	484
q16	425	426	389	389
q17	583	842	354	354
q18	7642	7251	7082	7082
q19	2149	957	553	553
q20	328	337	220	220
q21	3634	3144	2334	2334
q22	1069	1011	965	965
Total cold run time: 115892 ms
Total hot run time: 33637 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5167	5021	5054	5021
q2	240	322	218	218
q3	2157	2611	2287	2287
q4	1391	1840	1348	1348
q5	4519	4422	4466	4422
q6	211	176	126	126
q7	1999	1955	1778	1778
q8	2590	2643	2504	2504
q9	7185	7078	7106	7078
q10	3027	3235	2764	2764
q11	572	520	493	493
q12	675	806	633	633
q13	3469	3864	3338	3338
q14	284	288	271	271
q15	519	467	467	467
q16	431	484	452	452
q17	1148	1547	1376	1376
q18	7801	7606	7450	7450
q19	794	798	981	798
q20	2005	1958	1851	1851
q21	4932	4458	4468	4458
q22	1138	1047	1029	1029
Total cold run time: 52254 ms
Total hot run time: 50162 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 191930 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 7574349125ee095f45367af5a682c2834bb26c84, data reload: false

query1	1419	1083	1056	1056
query2	6342	1834	1811	1811
query3	10982	4398	4599	4398
query4	53780	25477	22799	22799
query5	5197	505	462	462
query6	394	218	206	206
query7	5086	511	298	298
query8	290	231	227	227
query9	6559	2666	2669	2666
query10	454	329	256	256
query11	15127	14941	14699	14699
query12	166	110	107	107
query13	1175	575	419	419
query14	10151	6337	6253	6253
query15	204	200	170	170
query16	7131	644	487	487
query17	1084	732	589	589
query18	1639	403	324	324
query19	201	191	191	191
query20	135	128	119	119
query21	222	125	146	125
query22	4508	4503	4365	4365
query23	34454	33494	33677	33494
query24	6651	2374	2428	2374
query25	492	474	415	415
query26	699	278	154	154
query27	2388	508	348	348
query28	2877	2202	2176	2176
query29	577	549	435	435
query30	274	223	193	193
query31	863	858	792	792
query32	69	67	64	64
query33	481	364	317	317
query34	765	851	554	554
query35	824	844	755	755
query36	956	1008	909	909
query37	112	99	79	79
query38	4238	4286	4240	4240
query39	1507	1434	1465	1434
query40	209	125	116	116
query41	61	85	60	60
query42	133	121	114	114
query43	495	515	497	497
query44	1346	860	844	844
query45	179	176	176	176
query46	837	1013	649	649
query47	1852	1903	1829	1829
query48	405	430	319	319
query49	671	504	431	431
query50	648	712	411	411
query51	4225	4265	4170	4170
query52	110	109	99	99
query53	223	270	192	192
query54	591	584	512	512
query55	92	87	83	83
query56	323	302	304	302
query57	1178	1222	1116	1116
query58	268	284	263	263
query59	2686	2891	2661	2661
query60	338	330	314	314
query61	132	124	141	124
query62	742	747	651	651
query63	225	192	194	192
query64	1792	1019	691	691
query65	4231	4131	4130	4130
query66	727	397	296	296
query67	16015	15784	15620	15620
query68	7295	879	540	540
query69	551	299	265	265
query70	1212	1148	1131	1131
query71	502	317	293	293
query72	5617	4734	4915	4734
query73	1272	656	358	358
query74	8974	9078	8946	8946
query75	3740	3178	2687	2687
query76	4335	1203	753	753
query77	619	375	282	282
query78	10140	10062	9369	9369
query79	3033	805	573	573
query80	669	502	435	435
query81	496	266	217	217
query82	466	126	93	93
query83	379	247	229	229
query84	296	110	93	93
query85	802	355	320	320
query86	407	312	273	273
query87	4367	4408	4271	4271
query88	3116	2272	2260	2260
query89	400	333	282	282
query90	1911	200	201	200
query91	142	146	111	111
query92	81	67	58	58
query93	1514	922	583	583
query94	675	388	307	307
query95	364	310	284	284
query96	487	578	282	282
query97	2742	2714	2617	2617
query98	222	212	202	202
query99	1442	1366	1260	1260
Total cold run time: 299475 ms
Total hot run time: 191930 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.11	0.11
query3	0.25	0.19	0.19
query4	1.59	0.19	0.19
query5	0.46	0.44	0.43
query6	1.41	0.68	0.66
query7	0.02	0.02	0.02
query8	0.05	0.03	0.04
query9	0.61	0.54	0.53
query10	0.58	0.57	0.56
query11	0.15	0.11	0.11
query12	0.15	0.11	0.12
query13	0.61	0.59	0.59
query14	0.78	0.81	0.80
query15	0.88	0.85	0.87
query16	0.37	0.38	0.38
query17	1.03	1.02	1.03
query18	0.22	0.20	0.21
query19	1.99	1.82	1.87
query20	0.02	0.02	0.01
query21	15.39	0.92	0.55
query22	0.73	1.25	0.64
query23	14.92	1.38	0.62
query24	7.20	1.62	0.36
query25	0.32	0.14	0.08
query26	0.70	0.16	0.14
query27	0.05	0.05	0.05
query28	8.97	0.92	0.45
query29	12.56	4.08	3.37
query30	0.26	0.09	0.08
query31	2.81	0.59	0.39
query32	3.24	0.55	0.46
query33	3.14	3.09	3.17
query34	15.62	5.16	4.50
query35	4.52	4.49	4.50
query36	0.67	0.50	0.46
query37	0.08	0.06	0.07
query38	0.05	0.04	0.03
query39	0.04	0.03	0.02
query40	0.16	0.14	0.13
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 102.92 s
Total hot run time: 28.68 s

@codeDing18
Copy link
Contributor Author

run external

@codeDing18 codeDing18 force-pushed the adminsetfrontconfig-nereids branch from 7574349 to 000383a Compare June 6, 2025 02:48
@codeDing18
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26424	5098	5108	5098
q2	2007	293	199	199
q3	10270	1255	727	727
q4	10226	1009	519	519
q5	7550	2328	2390	2328
q6	188	175	135	135
q7	909	763	617	617
q8	9319	1300	1159	1159
q9	6882	5160	5108	5108
q10	6863	2332	1927	1927
q11	503	295	279	279
q12	349	350	216	216
q13	17787	3722	3105	3105
q14	232	225	215	215
q15	562	484	474	474
q16	445	439	376	376
q17	610	866	357	357
q18	7699	7114	7074	7074
q19	1574	962	585	585
q20	346	352	224	224
q21	3670	3194	2348	2348
q22	1021	992	934	934
Total cold run time: 115436 ms
Total hot run time: 34004 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5220	5091	5131	5091
q2	242	330	221	221
q3	2238	2698	2298	2298
q4	1348	1759	1382	1382
q5	4488	4420	4432	4420
q6	214	178	130	130
q7	2029	1935	1803	1803
q8	2600	2649	2558	2558
q9	7291	7148	7002	7002
q10	3094	3180	2734	2734
q11	595	511	506	506
q12	714	778	623	623
q13	3514	3947	3370	3370
q14	270	294	286	286
q15	536	474	485	474
q16	439	491	442	442
q17	1172	1555	1419	1419
q18	7890	7719	7543	7543
q19	827	817	852	817
q20	2033	1969	1858	1858
q21	4810	4420	4482	4420
q22	1084	1067	1017	1017
Total cold run time: 52648 ms
Total hot run time: 50414 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 193237 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 000383aa129f8dcadcf103f2697be5e2d6412235, data reload: false

query1	1414	1091	1072	1072
query2	6184	1827	1813	1813
query3	11003	4507	4369	4369
query4	54801	25687	23786	23786
query5	5144	534	469	469
query6	371	232	207	207
query7	4993	531	297	297
query8	275	221	227	221
query9	6014	2646	2657	2646
query10	431	337	293	293
query11	15123	15024	14863	14863
query12	166	108	105	105
query13	1109	533	418	418
query14	10184	6360	6475	6360
query15	221	213	179	179
query16	7082	686	500	500
query17	1105	756	588	588
query18	1555	418	332	332
query19	206	197	169	169
query20	131	140	128	128
query21	216	126	113	113
query22	4376	4432	4169	4169
query23	34496	33701	33482	33482
query24	6607	2387	2449	2387
query25	463	468	410	410
query26	702	306	158	158
query27	2299	535	349	349
query28	3292	2188	2184	2184
query29	577	559	444	444
query30	272	221	190	190
query31	912	874	776	776
query32	75	71	67	67
query33	459	399	321	321
query34	786	882	546	546
query35	795	827	741	741
query36	957	989	901	901
query37	121	104	82	82
query38	4144	4375	4210	4210
query39	1537	1448	1472	1448
query40	216	122	113	113
query41	61	55	55	55
query42	143	119	110	110
query43	510	513	491	491
query44	1394	856	844	844
query45	182	185	167	167
query46	860	1014	655	655
query47	1856	1832	1750	1750
query48	393	437	326	326
query49	670	528	429	429
query50	693	697	409	409
query51	4242	4217	4211	4211
query52	111	114	115	114
query53	266	261	195	195
query54	618	587	514	514
query55	85	86	87	86
query56	314	326	309	309
query57	1204	1171	1139	1139
query58	279	283	257	257
query59	2708	2777	2718	2718
query60	334	356	325	325
query61	130	124	126	124
query62	757	746	682	682
query63	239	208	192	192
query64	2173	1038	728	728
query65	4356	4164	4137	4137
query66	727	416	303	303
query67	15951	15576	15680	15576
query68	7104	897	529	529
query69	541	306	260	260
query70	1225	1131	1033	1033
query71	505	323	305	305
query72	5932	4810	4963	4810
query73	1348	676	356	356
query74	9126	9095	8881	8881
query75	3830	3203	2700	2700
query76	4307	1187	809	809
query77	630	368	298	298
query78	10127	10190	9315	9315
query79	2271	830	582	582
query80	670	504	451	451
query81	482	253	215	215
query82	472	135	93	93
query83	256	250	245	245
query84	294	123	83	83
query85	766	345	369	345
query86	371	294	281	281
query87	4445	4406	4304	4304
query88	3573	2301	2294	2294
query89	394	310	283	283
query90	1784	221	214	214
query91	150	150	115	115
query92	76	61	66	61
query93	2023	921	585	585
query94	656	419	308	308
query95	371	288	294	288
query96	517	573	281	281
query97	2724	2760	2670	2670
query98	235	221	195	195
query99	1647	1395	1296	1296
Total cold run time: 300922 ms
Total hot run time: 193237 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.11	0.11
query3	0.25	0.19	0.19
query4	1.59	0.19	0.19
query5	0.45	0.44	0.46
query6	1.20	0.67	0.65
query7	0.02	0.02	0.02
query8	0.05	0.03	0.04
query9	0.59	0.52	0.51
query10	0.57	0.58	0.56
query11	0.16	0.10	0.11
query12	0.15	0.11	0.12
query13	0.62	0.59	0.60
query14	0.80	0.81	0.81
query15	0.87	0.85	0.87
query16	0.38	0.40	0.38
query17	1.02	1.05	1.04
query18	0.23	0.21	0.21
query19	1.97	1.87	1.83
query20	0.01	0.01	0.01
query21	15.42	0.91	0.56
query22	0.76	1.11	0.72
query23	14.90	1.40	0.58
query24	7.46	0.82	1.43
query25	0.46	0.16	0.11
query26	0.62	0.18	0.15
query27	0.05	0.06	0.05
query28	9.26	0.91	0.45
query29	12.57	4.04	3.32
query30	0.26	0.10	0.06
query31	2.81	0.59	0.39
query32	3.24	0.54	0.47
query33	3.04	3.04	3.09
query34	15.79	5.09	4.50
query35	4.53	4.46	4.51
query36	0.66	0.49	0.47
query37	0.09	0.07	0.06
query38	0.05	0.04	0.04
query39	0.03	0.03	0.03
query40	0.17	0.13	0.13
query41	0.07	0.02	0.02
query42	0.03	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 103.4 s
Total hot run time: 29.14 s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@dataroaring dataroaring Awaiting requested review from dataroaring dataroaring is a code owner

@CalvinKirs CalvinKirs Awaiting requested review from CalvinKirs CalvinKirs is a code owner

@morningman morningman Awaiting requested review from morningman morningman is a code owner

At least 1 approving review is required to merge this pull request.

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

[Enhancement] (nereids)implement adminSetFrontendConfigCommand in nereids
3 participants
@codeDing18 @hello-stephen @doris-robot