doris icon indicating copy to clipboard operation
doris copied to clipboard

[Chore](nereids) Remove AdminStmt

Open yx-keith opened this issue 5 months ago • 6 comments

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

yx-keith avatar Jun 19 '25 02:06 yx-keith

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?

hello-stephen avatar Jun 19 '25 02:06 hello-stephen

run buildall

yx-keith avatar Jun 19 '25 02:06 yx-keith

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

------ Round 1 ----------------------------------
q1	17587	5246	4933	4933
q2	1919	273	187	187
q3	10359	1288	699	699
q4	10214	993	532	532
q5	7608	2399	2329	2329
q6	182	168	128	128
q7	906	739	604	604
q8	9296	1305	1106	1106
q9	6816	5062	5072	5062
q10	6933	2375	1965	1965
q11	482	287	279	279
q12	345	348	215	215
q13	17786	3700	3057	3057
q14	220	238	212	212
q15	563	475	484	475
q16	430	418	377	377
q17	574	870	354	354
q18	7587	7258	7062	7062
q19	2170	1053	552	552
q20	327	329	218	218
q21	3632	2591	2327	2327
q22	1040	1016	938	938
Total cold run time: 106976 ms
Total hot run time: 33611 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5143	5091	5115	5091
q2	242	321	220	220
q3	2172	2668	2312	2312
q4	1354	1762	1403	1403
q5	4234	4099	4318	4099
q6	219	172	129	129
q7	2069	1965	1806	1806
q8	2568	2569	2480	2480
q9	7152	7027	7161	7027
q10	3107	3314	2857	2857
q11	574	531	481	481
q12	673	798	624	624
q13	3451	3913	3286	3286
q14	284	285	267	267
q15	516	482	481	481
q16	443	476	431	431
q17	1152	1573	1375	1375
q18	7554	7210	7025	7025
q19	771	801	864	801
q20	1910	1978	1864	1864
q21	4712	4343	4334	4334
q22	1054	1030	998	998
Total cold run time: 51354 ms
Total hot run time: 49391 ms

doris-robot avatar Jun 19 '25 03:06 doris-robot

TPC-DS: Total hot run time: 186851 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 608bbef1d1bd51ea44fac859d95efd6ccd878274, data reload: false

query1	1001	382	388	382
query2	6530	1954	1933	1933
query3	6743	225	223	223
query4	26601	23299	23436	23299
query5	4313	625	460	460
query6	302	209	196	196
query7	4623	510	298	298
query8	277	234	225	225
query9	8671	2655	2656	2655
query10	468	352	296	296
query11	15914	15151	14951	14951
query12	159	108	108	108
query13	1690	533	422	422
query14	9676	6233	6187	6187
query15	215	193	178	178
query16	7469	629	474	474
query17	1195	740	599	599
query18	2026	410	317	317
query19	199	196	174	174
query20	124	122	115	115
query21	212	134	119	119
query22	4046	4091	4114	4091
query23	34057	33210	33359	33210
query24	8489	2383	2406	2383
query25	536	456	397	397
query26	1245	274	152	152
query27	2745	505	345	345
query28	4338	2140	2134	2134
query29	728	535	429	429
query30	292	222	194	194
query31	936	818	766	766
query32	73	64	64	64
query33	555	404	301	301
query34	801	839	540	540
query35	775	816	765	765
query36	948	998	905	905
query37	109	101	74	74
query38	4180	4248	4063	4063
query39	1494	1448	1437	1437
query40	219	121	108	108
query41	63	59	58	58
query42	121	110	111	110
query43	523	541	494	494
query44	1351	864	846	846
query45	176	175	166	166
query46	847	1024	631	631
query47	1753	1817	1711	1711
query48	404	418	319	319
query49	744	504	446	446
query50	655	679	418	418
query51	4097	4128	4107	4107
query52	108	108	103	103
query53	236	261	185	185
query54	580	570	506	506
query55	89	84	86	84
query56	309	310	303	303
query57	1182	1215	1131	1131
query58	263	261	256	256
query59	2702	2774	2709	2709
query60	326	315	303	303
query61	123	126	124	124
query62	782	731	658	658
query63	227	190	189	189
query64	4285	994	697	697
query65	4282	4201	4205	4201
query66	1092	422	365	365
query67	15723	15614	15410	15410
query68	8055	900	529	529
query69	470	328	266	266
query70	1246	1136	1141	1136
query71	468	326	297	297
query72	5676	4647	4759	4647
query73	684	629	354	354
query74	9074	9215	8833	8833
query75	3866	3212	2700	2700
query76	3717	1182	761	761
query77	783	442	309	309
query78	10007	10148	9267	9267
query79	2531	816	576	576
query80	617	499	443	443
query81	494	322	233	233
query82	453	126	94	94
query83	287	243	236	236
query84	297	116	96	96
query85	832	359	301	301
query86	391	310	282	282
query87	4424	4497	4408	4408
query88	3325	2311	2286	2286
query89	385	333	287	287
query90	1865	206	206	206
query91	141	138	110	110
query92	78	63	60	60
query93	1849	957	594	594
query94	665	412	313	313
query95	375	302	290	290
query96	489	576	280	280
query97	2720	2749	2681	2681
query98	240	209	203	203
query99	1436	1419	1274	1274
Total cold run time: 275957 ms
Total hot run time: 186851 ms

doris-robot avatar Jun 19 '25 03:06 doris-robot

FE UT Coverage Report

Increment line coverage 0.00% (0/1) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Jun 19 '25 04:06 hello-stephen

run buildall

yx-keith avatar Jun 19 '25 06:06 yx-keith

FE UT Coverage Report

Increment line coverage 0.00% (0/1) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Jun 19 '25 07:06 hello-stephen

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

------ Round 1 ----------------------------------
q1	17638	5296	5033	5033
q2	1929	320	182	182
q3	10349	1296	722	722
q4	10226	992	528	528
q5	7575	2359	2302	2302
q6	187	163	130	130
q7	905	722	614	614
q8	9296	1300	1089	1089
q9	6870	5114	5081	5081
q10	6870	2372	1966	1966
q11	481	287	262	262
q12	343	347	216	216
q13	17762	3646	3081	3081
q14	231	226	211	211
q15	554	469	478	469
q16	415	451	370	370
q17	592	853	379	379
q18	7738	7046	7079	7046
q19	2077	957	559	559
q20	331	341	218	218
q21	3732	3144	2320	2320
q22	1027	1030	985	985
Total cold run time: 107128 ms
Total hot run time: 33763 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5283	5100	5097	5097
q2	255	332	231	231
q3	2159	2670	2288	2288
q4	1398	1832	1388	1388
q5	4238	4104	4361	4104
q6	214	173	131	131
q7	1985	1954	1779	1779
q8	2563	2629	2517	2517
q9	7221	7063	7161	7063
q10	3113	3257	2828	2828
q11	569	500	495	495
q12	682	778	656	656
q13	3523	3852	3266	3266
q14	301	307	284	284
q15	517	481	472	472
q16	437	476	455	455
q17	1165	1597	1337	1337
q18	7447	7177	7085	7085
q19	783	723	799	723
q20	1923	1994	1822	1822
q21	4787	4365	4268	4268
q22	1088	1058	1013	1013
Total cold run time: 51651 ms
Total hot run time: 49302 ms

doris-robot avatar Jun 19 '25 08:06 doris-robot

TPC-DS: Total hot run time: 184985 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 22b0682681a29b2a5791840d76ff2f28008ae327, data reload: false

query1	976	393	382	382
query2	6513	1898	1873	1873
query3	6753	227	218	218
query4	26409	23551	22990	22990
query5	4340	617	450	450
query6	299	208	196	196
query7	4629	489	287	287
query8	284	237	210	210
query9	8621	2602	2622	2602
query10	488	340	273	273
query11	15291	15010	14794	14794
query12	155	112	109	109
query13	1663	541	408	408
query14	8905	6084	6254	6084
query15	205	182	170	170
query16	7293	642	494	494
query17	1215	721	595	595
query18	2006	414	317	317
query19	197	199	162	162
query20	127	120	118	118
query21	219	136	109	109
query22	4088	4205	4075	4075
query23	34325	32948	33133	32948
query24	8439	2373	2391	2373
query25	527	453	381	381
query26	784	275	148	148
query27	2731	508	348	348
query28	4303	2108	2092	2092
query29	706	546	430	430
query30	282	212	188	188
query31	920	838	778	778
query32	74	67	64	64
query33	540	366	316	316
query34	799	844	532	532
query35	796	808	722	722
query36	932	978	875	875
query37	109	99	73	73
query38	4102	4236	4043	4043
query39	1496	1407	1411	1407
query40	206	127	125	125
query41	60	62	54	54
query42	127	104	105	104
query43	502	496	497	496
query44	1315	822	812	812
query45	175	177	167	167
query46	831	999	614	614
query47	1796	1794	1707	1707
query48	378	430	303	303
query49	693	479	393	393
query50	650	686	407	407
query51	4173	4254	4075	4075
query52	115	105	102	102
query53	227	249	181	181
query54	561	567	487	487
query55	83	89	83	83
query56	287	285	273	273
query57	1168	1213	1145	1145
query58	258	263	251	251
query59	2674	2750	2652	2652
query60	345	321	302	302
query61	131	124	126	124
query62	828	752	640	640
query63	224	182	182	182
query64	3390	1031	676	676
query65	4249	4193	4176	4176
query66	1022	407	310	310
query67	15689	15630	15345	15345
query68	7984	875	516	516
query69	490	303	276	276
query70	1224	1195	1131	1131
query71	467	320	291	291
query72	5502	4690	4737	4690
query73	702	581	349	349
query74	8880	8924	8827	8827
query75	3900	3212	2648	2648
query76	3637	1187	747	747
query77	773	362	296	296
query78	10036	10208	9348	9348
query79	1939	822	572	572
query80	561	512	427	427
query81	480	258	229	229
query82	414	130	94	94
query83	254	248	229	229
query84	251	119	95	95
query85	797	343	318	318
query86	342	300	288	288
query87	4413	4442	4267	4267
query88	3341	2283	2276	2276
query89	388	312	281	281
query90	1920	211	208	208
query91	138	141	124	124
query92	76	62	60	60
query93	1129	924	579	579
query94	663	442	302	302
query95	368	294	275	275
query96	488	611	281	281
query97	2725	2732	2619	2619
query98	235	217	199	199
query99	1466	1397	1323	1323
Total cold run time: 270681 ms
Total hot run time: 184985 ms

doris-robot avatar Jun 19 '25 08:06 doris-robot

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

query1	0.03	0.03	0.03
query2	0.06	0.04	0.03
query3	0.24	0.07	0.07
query4	1.60	0.11	0.11
query5	0.43	0.43	0.43
query6	1.17	0.66	0.66
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.60	0.52	0.52
query10	0.58	0.58	0.56
query11	0.15	0.11	0.11
query12	0.14	0.11	0.12
query13	0.63	0.61	0.60
query14	0.80	0.81	0.82
query15	0.88	0.86	0.90
query16	0.39	0.38	0.38
query17	1.07	1.03	1.06
query18	0.22	0.21	0.21
query19	1.95	1.84	1.86
query20	0.02	0.01	0.01
query21	15.46	0.92	0.53
query22	0.75	1.17	0.63
query23	14.99	1.36	0.62
query24	6.73	1.96	0.33
query25	0.29	0.08	0.11
query26	0.57	0.18	0.14
query27	0.06	0.06	0.05
query28	9.28	0.91	0.45
query29	12.58	3.97	3.39
query30	0.26	0.09	0.06
query31	2.82	0.59	0.39
query32	3.23	0.55	0.49
query33	3.11	3.07	3.17
query34	16.23	5.38	4.85
query35	4.85	4.89	4.82
query36	0.73	0.49	0.49
query37	0.09	0.06	0.06
query38	0.06	0.04	0.04
query39	0.03	0.03	0.03
query40	0.17	0.14	0.14
query41	0.08	0.02	0.02
query42	0.03	0.02	0.03
query43	0.04	0.04	0.03
Total cold run time: 103.46 s
Total hot run time: 29.15 s

doris-robot avatar Jun 19 '25 08:06 doris-robot

run buildall

yx-keith avatar Jun 19 '25 14:06 yx-keith

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

------ Round 1 ----------------------------------
q1	17576	5213	5077	5077
q2	1960	297	206	206
q3	10250	1245	718	718
q4	10240	985	511	511
q5	7542	2399	2279	2279
q6	180	162	130	130
q7	906	729	588	588
q8	9304	1344	969	969
q9	6783	5078	5151	5078
q10	6927	2383	1971	1971
q11	492	295	271	271
q12	332	346	214	214
q13	17762	3680	3072	3072
q14	242	229	219	219
q15	570	476	488	476
q16	431	426	365	365
q17	581	852	363	363
q18	7609	7126	7008	7008
q19	1876	936	554	554
q20	345	333	220	220
q21	3683	2595	2322	2322
q22	1051	1042	961	961
Total cold run time: 106642 ms
Total hot run time: 33572 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5213	5041	5067	5041
q2	247	317	227	227
q3	2158	2681	2251	2251
q4	1323	1791	1349	1349
q5	4230	4119	4367	4119
q6	212	173	130	130
q7	2060	1894	1743	1743
q8	2617	2567	2541	2541
q9	7191	7124	7001	7001
q10	3049	3248	2837	2837
q11	572	511	487	487
q12	681	762	617	617
q13	3541	4044	3283	3283
q14	283	284	273	273
q15	531	482	478	478
q16	428	493	432	432
q17	1146	1603	1380	1380
q18	7682	7161	7100	7100
q19	785	798	919	798
q20	1945	2011	1810	1810
q21	4762	4469	4415	4415
q22	1054	1011	986	986
Total cold run time: 51710 ms
Total hot run time: 49298 ms

doris-robot avatar Jun 19 '25 15:06 doris-robot

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

query1	1009	388	400	388
query2	6528	1796	1780	1780
query3	6738	217	212	212
query4	26566	23675	22973	22973
query5	4367	614	453	453
query6	300	197	183	183
query7	4641	503	287	287
query8	276	218	201	201
query9	8625	2591	2625	2591
query10	500	325	287	287
query11	15358	15196	14826	14826
query12	158	114	105	105
query13	1670	547	409	409
query14	9506	6108	6129	6108
query15	208	199	168	168
query16	7411	647	476	476
query17	1211	718	586	586
query18	2027	414	315	315
query19	205	193	176	176
query20	121	116	115	115
query21	218	143	113	113
query22	4173	4235	4133	4133
query23	34028	33068	33274	33068
query24	7806	2401	2358	2358
query25	547	456	392	392
query26	1226	265	151	151
query27	2636	478	342	342
query28	4390	2107	2084	2084
query29	768	542	446	446
query30	284	223	192	192
query31	913	864	752	752
query32	70	71	61	61
query33	556	369	302	302
query34	803	853	526	526
query35	777	859	748	748
query36	953	961	879	879
query37	110	102	75	75
query38	4139	4149	4054	4054
query39	1454	1410	1404	1404
query40	210	118	107	107
query41	64	59	59	59
query42	135	105	104	104
query43	495	493	467	467
query44	1304	823	818	818
query45	182	176	168	168
query46	828	1035	644	644
query47	1747	1793	1727	1727
query48	380	421	308	308
query49	745	482	401	401
query50	619	695	402	402
query51	4196	4054	4083	4054
query52	114	111	100	100
query53	235	250	184	184
query54	561	560	502	502
query55	88	83	80	80
query56	323	321	293	293
query57	1168	1195	1132	1132
query58	261	258	263	258
query59	2551	2587	2560	2560
query60	326	322	327	322
query61	129	119	123	119
query62	805	746	669	669
query63	221	178	187	178
query64	4324	992	660	660
query65	4259	4197	4157	4157
query66	1158	413	314	314
query67	15687	15691	15535	15535
query68	8181	888	524	524
query69	462	312	270	270
query70	1188	1084	1068	1068
query71	466	338	302	302
query72	5591	4737	4873	4737
query73	746	632	347	347
query74	8898	9102	8656	8656
query75	3827	3199	2683	2683
query76	3697	1207	767	767
query77	766	390	276	276
query78	9987	10189	9600	9600
query79	2607	795	572	572
query80	605	516	445	445
query81	503	257	227	227
query82	644	126	98	98
query83	253	252	236	236
query84	249	115	86	86
query85	800	367	311	311
query86	387	308	279	279
query87	4433	4498	4397	4397
query88	3751	2363	2279	2279
query89	402	320	289	289
query90	1845	212	219	212
query91	152	137	111	111
query92	82	63	62	62
query93	1675	970	584	584
query94	680	430	309	309
query95	375	299	291	291
query96	497	559	285	285
query97	2688	2685	2660	2660
query98	237	207	203	203
query99	1429	1426	1280	1280
Total cold run time: 274494 ms
Total hot run time: 185487 ms

doris-robot avatar Jun 19 '25 15:06 doris-robot

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

query1	0.04	0.04	0.03
query2	0.08	0.03	0.04
query3	0.24	0.07	0.07
query4	1.60	0.10	0.10
query5	0.44	0.44	0.43
query6	1.16	0.65	0.67
query7	0.03	0.02	0.01
query8	0.04	0.04	0.04
query9	0.59	0.51	0.52
query10	0.57	0.58	0.56
query11	0.16	0.11	0.11
query12	0.16	0.11	0.12
query13	0.64	0.61	0.61
query14	0.81	0.82	0.82
query15	0.91	0.86	0.89
query16	0.39	0.41	0.41
query17	1.04	1.05	1.10
query18	0.22	0.21	0.21
query19	1.94	1.81	1.82
query20	0.01	0.01	0.01
query21	15.38	0.94	0.55
query22	0.76	1.06	0.59
query23	15.11	1.40	0.59
query24	6.86	1.91	0.85
query25	0.49	0.24	0.07
query26	0.56	0.16	0.16
query27	0.06	0.05	0.05
query28	9.77	0.95	0.46
query29	12.54	4.02	3.33
query30	0.25	0.09	0.07
query31	2.84	0.63	0.39
query32	3.23	0.58	0.48
query33	3.15	3.09	3.10
query34	16.14	5.43	4.76
query35	4.88	4.86	4.85
query36	0.69	0.51	0.49
query37	0.09	0.06	0.06
query38	0.06	0.04	0.04
query39	0.03	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.04	0.03	0.03
Total cold run time: 104.28 s
Total hot run time: 29.56 s

doris-robot avatar Jun 19 '25 15:06 doris-robot

run buildall

yx-keith avatar Jun 20 '25 06:06 yx-keith

run buildall

yx-keith avatar Jun 20 '25 09:06 yx-keith

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

------ Round 1 ----------------------------------
q1	17634	5203	5059	5059
q2	1942	291	203	203
q3	10311	1320	764	764
q4	10293	1008	562	562
q5	8655	2350	2452	2350
q6	233	171	138	138
q7	929	766	628	628
q8	9317	1506	1198	1198
q9	6861	5126	5241	5126
q10	6903	2410	1957	1957
q11	481	307	289	289
q12	357	355	228	228
q13	17800	3721	3128	3128
q14	242	232	225	225
q15	583	480	481	480
q16	441	435	386	386
q17	627	862	423	423
q18	7442	7294	7167	7167
q19	1628	975	552	552
q20	336	346	243	243
q21	4159	3314	2434	2434
q22	1099	1062	969	969
Total cold run time: 108273 ms
Total hot run time: 34509 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5147	5095	5139	5095
q2	249	330	227	227
q3	2177	2751	2305	2305
q4	1396	1792	1370	1370
q5	4252	4377	4393	4377
q6	216	171	133	133
q7	2019	1899	1770	1770
q8	2569	2616	2510	2510
q9	7253	7225	7074	7074
q10	3090	3232	2835	2835
q11	563	522	483	483
q12	704	795	651	651
q13	3568	3879	3302	3302
q14	276	291	281	281
q15	526	477	474	474
q16	442	505	466	466
q17	1182	1537	1412	1412
q18	7691	7266	7069	7069
q19	794	802	848	802
q20	1915	1970	1885	1885
q21	4710	4470	4361	4361
q22	1090	1103	1012	1012
Total cold run time: 51829 ms
Total hot run time: 49894 ms

doris-robot avatar Jun 20 '25 09:06 doris-robot

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

query1	997	398	387	387
query2	6539	1818	1782	1782
query3	6753	226	220	220
query4	26246	23801	23084	23084
query5	4389	644	472	472
query6	304	213	218	213
query7	4628	505	316	316
query8	269	232	214	214
query9	8624	2662	2660	2660
query10	502	335	284	284
query11	15546	15078	14810	14810
query12	166	110	110	110
query13	1666	547	415	415
query14	9125	6181	6314	6181
query15	199	195	181	181
query16	7503	630	471	471
query17	1205	730	595	595
query18	2075	423	325	325
query19	205	206	165	165
query20	120	119	117	117
query21	216	125	111	111
query22	4139	4194	4078	4078
query23	34201	33442	33087	33087
query24	8548	2352	2379	2352
query25	556	458	402	402
query26	1220	272	149	149
query27	2737	507	350	350
query28	4331	2118	2122	2118
query29	745	552	439	439
query30	291	215	189	189
query31	935	826	764	764
query32	72	63	63	63
query33	569	379	343	343
query34	801	862	529	529
query35	783	841	768	768
query36	922	976	873	873
query37	113	101	75	75
query38	4166	4171	4125	4125
query39	1656	1435	1442	1435
query40	219	123	106	106
query41	63	58	60	58
query42	125	113	106	106
query43	496	504	485	485
query44	1297	818	823	818
query45	185	175	171	171
query46	867	1008	622	622
query47	1733	1811	1720	1720
query48	402	418	311	311
query49	745	494	389	389
query50	634	687	407	407
query51	4152	4131	4103	4103
query52	114	112	106	106
query53	229	252	190	190
query54	582	569	505	505
query55	89	91	89	89
query56	301	312	299	299
query57	1172	1221	1109	1109
query58	269	266	283	266
query59	2547	2675	2477	2477
query60	336	328	313	313
query61	128	132	119	119
query62	815	706	645	645
query63	233	187	194	187
query64	4318	1012	667	667
query65	4298	4154	4178	4154
query66	1114	415	334	334
query67	16399	15909	15485	15485
query68	8257	889	536	536
query69	485	302	270	270
query70	1217	1120	1050	1050
query71	497	346	312	312
query72	5742	4820	4781	4781
query73	679	614	358	358
query74	9285	9145	9050	9050
query75	3900	3199	2680	2680
query76	3727	1258	769	769
query77	800	406	296	296
query78	10048	10149	9268	9268
query79	2559	783	585	585
query80	625	504	444	444
query81	504	260	231	231
query82	452	135	98	98
query83	289	249	226	226
query84	296	99	83	83
query85	787	348	310	310
query86	383	314	283	283
query87	4436	4365	4394	4365
query88	3612	2265	2248	2248
query89	380	307	284	284
query90	1852	246	207	207
query91	140	144	113	113
query92	82	60	59	59
query93	1951	963	591	591
query94	663	414	312	312
query95	380	290	285	285
query96	492	570	278	278
query97	2759	2830	2655	2655
query98	238	215	205	205
query99	1443	1438	1261	1261
Total cold run time: 276884 ms
Total hot run time: 185986 ms

doris-robot avatar Jun 20 '25 09:06 doris-robot

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.03
query3	0.24	0.07	0.06
query4	1.61	0.10	0.11
query5	0.43	0.44	0.43
query6	1.18	0.66	0.66
query7	0.02	0.02	0.01
query8	0.04	0.04	0.04
query9	0.58	0.50	0.52
query10	0.57	0.58	0.57
query11	0.16	0.11	0.12
query12	0.15	0.11	0.12
query13	0.64	0.63	0.61
query14	0.80	0.86	0.81
query15	0.90	0.86	0.88
query16	0.38	0.39	0.41
query17	1.04	1.01	1.05
query18	0.23	0.22	0.21
query19	2.00	1.81	1.91
query20	0.02	0.01	0.01
query21	15.39	0.89	0.54
query22	0.76	1.19	0.67
query23	14.98	1.36	0.63
query24	6.91	1.23	0.98
query25	0.54	0.26	0.09
query26	0.61	0.16	0.15
query27	0.08	0.06	0.05
query28	9.69	0.89	0.44
query29	12.56	4.04	3.34
query30	0.27	0.09	0.06
query31	2.82	0.61	0.41
query32	3.23	0.57	0.46
query33	3.10	3.07	3.06
query34	16.15	5.42	4.83
query35	4.90	4.86	4.84
query36	0.70	0.53	0.48
query37	0.09	0.07	0.07
query38	0.05	0.04	0.03
query39	0.04	0.03	0.02
query40	0.17	0.15	0.14
query41	0.09	0.03	0.03
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 104.3 s
Total hot run time: 29.73 s

doris-robot avatar Jun 20 '25 10:06 doris-robot

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Jun 23 '25 01:06 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Jun 23 '25 01:06 github-actions[bot]