Skip to content

[feat](param-refactor)Rename FS v2 to v1, remove legacy FS, and integrate new Storage/Azure features #51539

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.

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

Merged
merged 7 commits into from
Jun 9, 2025

Conversation

CalvinKirs
Copy link
Member

@CalvinKirs CalvinKirs commented Jun 6, 2025

#50238

What problem does this PR solve?

Rename FS v2 to v1

The current FS v2 implementation has been renamed to FS v1, making it the default and primary file system implementation.

Remove Legacy FS

All code and dependencies related to the legacy FS (the old v1 implementation) have been completely removed.

Repository Cleanup

Dropped all compatibility logic for the old FS.

The Repository layer now exclusively uses the new FS and Storage interfaces.

Deprecated configuration entries, injection code, and transitional hooks have been removed.

New Storage and Azure Feature Integration

Added support for new Azure file system features
Improved integration between the Storage layer and Repository for better scalability.

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

…rate new Storage/Azure features

This pull request includes the following updates:

Rename FS v2 to v1

The current FS v2 implementation has been renamed to FS v1, making it the default and primary file system implementation.

Remove Legacy FS

All code and dependencies related to the legacy FS (the old v1 implementation) have been completely removed.

Repository Cleanup

Dropped all compatibility logic for the old FS.

The Repository layer now exclusively uses the new FS and Storage interfaces.

Deprecated configuration entries, injection code, and transitional hooks have been removed.

New Storage and Azure Feature Integration

Added support for new Azure file system features
Improved integration between the Storage layer and Repository for better scalability.
@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?

@CalvinKirs
Copy link
Member Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26423	5530	5094	5094
q2	1977	296	193	193
q3	10287	1280	722	722
q4	10219	1042	541	541
q5	7552	2374	2344	2344
q6	188	165	135	135
q7	910	752	627	627
q8	9328	1264	1068	1068
q9	6921	5141	5080	5080
q10	6881	2322	1899	1899
q11	504	292	282	282
q12	348	359	222	222
q13	17780	3692	3037	3037
q14	243	221	216	216
q15	566	488	488	488
q16	445	440	375	375
q17	605	858	359	359
q18	7595	7271	7227	7227
q19	1929	960	568	568
q20	334	338	225	225
q21	3958	3202	2379	2379
q22	1025	1004	928	928
Total cold run time: 116018 ms
Total hot run time: 34009 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5242	5084	5102	5084
q2	252	319	222	222
q3	2214	2672	2271	2271
q4	1379	1792	1477	1477
q5	4460	4473	4426	4426
q6	219	178	137	137
q7	2057	1967	1784	1784
q8	2671	2611	2573	2573
q9	7322	6980	7110	6980
q10	3042	3231	2778	2778
q11	613	526	513	513
q12	702	778	639	639
q13	3562	3857	3377	3377
q14	282	289	283	283
q15	517	463	490	463
q16	447	490	453	453
q17	1179	1572	1382	1382
q18	7861	7739	7578	7578
q19	902	771	841	771
q20	1935	1971	1843	1843
q21	4962	4587	4430	4430
q22	1049	1033	1026	1026
Total cold run time: 52869 ms
Total hot run time: 50490 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 193317 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 4fcc49b5e46e90301a8797ac027ddaa16c68a1d4, data reload: false

query1	1391	1076	1073	1073
query2	6242	1870	1891	1870
query3	11011	4572	4455	4455
query4	54041	25057	23260	23260
query5	5131	518	475	475
query6	397	230	205	205
query7	5117	528	292	292
query8	301	234	219	219
query9	6533	2646	2654	2646
query10	443	344	274	274
query11	15161	15021	14891	14891
query12	167	113	111	111
query13	1172	570	424	424
query14	10174	6470	6673	6470
query15	202	208	192	192
query16	6791	687	495	495
query17	1114	753	616	616
query18	1500	416	324	324
query19	222	206	175	175
query20	145	138	118	118
query21	212	125	112	112
query22	4515	4485	4169	4169
query23	34681	33702	33782	33702
query24	6581	2452	2453	2452
query25	482	470	418	418
query26	722	279	155	155
query27	2377	536	343	343
query28	2996	2185	2189	2185
query29	608	566	452	452
query30	277	223	190	190
query31	889	849	777	777
query32	80	67	63	63
query33	453	404	320	320
query34	803	881	550	550
query35	792	846	776	776
query36	983	1017	907	907
query37	117	106	79	79
query38	4220	4310	4177	4177
query39	1546	1443	1492	1443
query40	210	120	111	111
query41	64	61	60	60
query42	123	111	111	111
query43	522	529	493	493
query44	1439	867	862	862
query45	190	178	169	169
query46	882	1033	673	673
query47	1826	1900	1810	1810
query48	411	442	332	332
query49	657	510	394	394
query50	717	705	410	410
query51	4286	4321	4141	4141
query52	110	118	106	106
query53	247	269	189	189
query54	593	591	520	520
query55	87	82	86	82
query56	321	311	302	302
query57	1191	1215	1089	1089
query58	285	282	278	278
query59	2760	2804	2799	2799
query60	344	335	317	317
query61	132	155	129	129
query62	738	744	689	689
query63	226	192	197	192
query64	1817	1021	671	671
query65	4244	4158	4155	4155
query66	717	405	312	312
query67	15921	15626	15499	15499
query68	6972	906	535	535
query69	570	312	274	274
query70	1241	1172	1174	1172
query71	495	357	311	311
query72	5980	4971	4957	4957
query73	1338	714	362	362
query74	8986	8912	8760	8760
query75	3795	3201	2682	2682
query76	4262	1207	774	774
query77	622	384	285	285
query78	10090	10057	9227	9227
query79	2318	839	583	583
query80	670	523	549	523
query81	470	256	222	222
query82	424	131	102	102
query83	381	259	237	237
query84	294	111	94	94
query85	815	361	309	309
query86	379	297	281	281
query87	4385	4416	4353	4353
query88	3269	2279	2295	2279
query89	408	318	284	284
query90	1894	222	217	217
query91	148	152	122	122
query92	76	72	60	60
query93	1270	975	585	585
query94	672	452	297	297
query95	374	301	286	286
query96	516	591	284	284
query97	2745	2767	2636	2636
query98	231	218	198	198
query99	1424	1403	1276	1276
Total cold run time: 299163 ms
Total hot run time: 193317 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.11	0.11
query3	0.26	0.19	0.20
query4	1.61	0.19	0.19
query5	0.46	0.47	0.45
query6	1.15	0.67	0.66
query7	0.02	0.01	0.01
query8	0.04	0.04	0.04
query9	0.58	0.52	0.53
query10	0.56	0.58	0.57
query11	0.16	0.10	0.11
query12	0.15	0.11	0.11
query13	0.61	0.59	0.60
query14	0.79	0.83	0.81
query15	0.89	0.86	0.89
query16	0.38	0.37	0.39
query17	1.07	1.05	1.05
query18	0.22	0.20	0.21
query19	1.89	1.79	1.81
query20	0.01	0.01	0.02
query21	15.39	0.90	0.55
query22	0.76	1.15	0.74
query23	14.86	1.35	0.61
query24	6.74	1.39	0.72
query25	0.51	0.12	0.21
query26	0.60	0.16	0.15
query27	0.07	0.05	0.04
query28	9.78	0.91	0.45
query29	12.53	3.98	3.38
query30	0.25	0.09	0.07
query31	2.81	0.59	0.39
query32	3.24	0.55	0.47
query33	3.04	3.06	3.07
query34	15.82	5.13	4.51
query35	4.49	4.55	4.54
query36	0.66	0.49	0.49
query37	0.09	0.07	0.06
query38	0.06	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.14	0.13
query41	0.09	0.03	0.02
query42	0.04	0.03	0.02
query43	0.03	0.03	0.04
Total cold run time: 103.07 s
Total hot run time: 29.27 s

@CalvinKirs
Copy link
Member Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	27204	5107	5144	5107
q2	1982	288	192	192
q3	10255	1271	722	722
q4	10244	1010	567	567
q5	8211	2436	2338	2338
q6	187	164	133	133
q7	915	742	620	620
q8	9332	1334	1094	1094
q9	6793	5094	5069	5069
q10	6883	2313	1919	1919
q11	494	298	274	274
q12	353	350	221	221
q13	17790	3725	3170	3170
q14	242	241	215	215
q15	570	473	493	473
q16	445	441	388	388
q17	636	875	373	373
q18	7705	7176	7230	7176
q19	1425	979	564	564
q20	340	356	234	234
q21	4263	3274	2494	2494
q22	1052	1003	968	968
Total cold run time: 117321 ms
Total hot run time: 34311 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5186	5114	5105	5105
q2	237	314	223	223
q3	2230	2689	2315	2315
q4	1499	1923	1441	1441
q5	4489	4430	4436	4430
q6	212	167	134	134
q7	2030	1922	1767	1767
q8	2697	2518	2509	2509
q9	7182	7185	7187	7185
q10	3015	3191	2782	2782
q11	585	541	487	487
q12	730	767	631	631
q13	3626	4010	3301	3301
q14	284	310	280	280
q15	529	475	513	475
q16	475	499	447	447
q17	1166	1544	1403	1403
q18	7666	7517	7589	7517
q19	857	859	960	859
q20	1982	1956	1827	1827
q21	4904	4346	4184	4184
q22	1053	1009	958	958
Total cold run time: 52634 ms
Total hot run time: 50260 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 188044 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 67edfa512a42492327ece69e8129fa576012e838, data reload: false

query1	1038	515	514	514
query2	6586	1893	1934	1893
query3	6758	233	223	223
query4	26519	23542	23479	23479
query5	4363	663	499	499
query6	302	213	206	206
query7	4629	534	298	298
query8	254	232	222	222
query9	8604	2662	2681	2662
query10	478	345	266	266
query11	15382	15140	14944	14944
query12	160	111	105	105
query13	1649	556	417	417
query14	8991	6410	6524	6410
query15	211	198	175	175
query16	7221	669	494	494
query17	1228	743	614	614
query18	1973	413	310	310
query19	226	196	168	168
query20	129	122	118	118
query21	217	132	113	113
query22	4070	4100	4006	4006
query23	34015	33221	33204	33204
query24	8590	2477	2469	2469
query25	586	494	458	458
query26	1242	273	154	154
query27	2759	513	347	347
query28	4311	2186	2162	2162
query29	807	569	436	436
query30	287	217	196	196
query31	950	845	773	773
query32	75	70	68	68
query33	568	356	328	328
query34	849	944	572	572
query35	779	812	733	733
query36	972	1000	910	910
query37	134	105	79	79
query38	4147	4200	4144	4144
query39	1516	1425	1414	1414
query40	220	125	112	112
query41	64	73	70	70
query42	137	116	117	116
query43	534	539	485	485
query44	1399	879	884	879
query45	193	179	184	179
query46	910	1071	658	658
query47	1734	1773	1709	1709
query48	412	443	324	324
query49	763	502	410	410
query50	674	689	420	420
query51	4139	4153	4206	4153
query52	111	115	104	104
query53	239	270	191	191
query54	588	578	524	524
query55	86	85	82	82
query56	325	325	304	304
query57	1157	1149	1091	1091
query58	273	261	277	261
query59	2759	2746	2658	2658
query60	342	323	332	323
query61	132	130	122	122
query62	783	728	654	654
query63	233	202	201	201
query64	4457	1018	689	689
query65	4265	4162	4206	4162
query66	1153	410	328	328
query67	15676	15564	15427	15427
query68	8582	936	543	543
query69	497	323	283	283
query70	1217	1108	1146	1108
query71	474	350	298	298
query72	5565	4817	4891	4817
query73	843	682	361	361
query74	9159	8931	8605	8605
query75	3958	3270	2793	2793
query76	3631	1222	825	825
query77	789	417	316	316
query78	10097	10362	9433	9433
query79	2094	869	612	612
query80	629	558	448	448
query81	505	254	229	229
query82	460	136	99	99
query83	268	263	243	243
query84	258	105	99	99
query85	807	373	325	325
query86	395	299	292	292
query87	4356	4494	4408	4408
query88	3733	2370	2329	2329
query89	389	331	302	302
query90	1827	230	219	219
query91	154	155	121	121
query92	84	64	61	61
query93	1580	1001	600	600
query94	676	418	317	317
query95	387	313	294	294
query96	531	603	285	285
query97	2813	2800	2671	2671
query98	249	221	212	212
query99	1444	1401	1277	1277
Total cold run time: 275784 ms
Total hot run time: 188044 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.13	0.10	0.11
query3	0.25	0.19	0.20
query4	1.59	0.20	0.19
query5	0.42	0.42	0.43
query6	1.15	0.69	0.68
query7	0.02	0.02	0.02
query8	0.05	0.04	0.03
query9	0.61	0.52	0.52
query10	0.58	0.58	0.56
query11	0.17	0.11	0.11
query12	0.15	0.12	0.12
query13	0.62	0.61	0.61
query14	0.81	0.82	0.82
query15	0.91	0.86	0.89
query16	0.39	0.40	0.39
query17	1.07	1.04	1.13
query18	0.23	0.23	0.22
query19	1.96	1.81	1.86
query20	0.01	0.01	0.02
query21	15.41	0.90	0.56
query22	0.75	1.20	0.69
query23	14.84	1.38	0.67
query24	6.72	1.27	0.73
query25	0.47	0.10	0.10
query26	0.57	0.20	0.17
query27	0.06	0.05	0.05
query28	9.33	0.93	0.48
query29	12.52	4.00	3.31
query30	0.25	0.10	0.07
query31	2.81	0.62	0.40
query32	3.24	0.56	0.47
query33	3.09	3.08	3.14
query34	15.79	5.17	4.50
query35	4.56	4.54	4.49
query36	0.68	0.52	0.49
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.18	0.15	0.13
query41	0.07	0.02	0.02
query42	0.03	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 102.74 s
Total hot run time: 29.32 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 32.92% (53/161) 🎉
Increment coverage report
Complete coverage report

@CalvinKirs
Copy link
Member Author

run p0

@CalvinKirs
Copy link
Member Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25796	5267	5028	5028
q2	1944	283	179	179
q3	10293	1260	671	671
q4	10464	1018	518	518
q5	7688	2444	2388	2388
q6	183	165	132	132
q7	911	728	625	625
q8	9361	1294	1084	1084
q9	6869	5150	5068	5068
q10	6889	2328	1910	1910
q11	491	292	275	275
q12	340	350	212	212
q13	17779	3666	3092	3092
q14	226	234	211	211
q15	557	485	491	485
q16	420	430	368	368
q17	574	845	386	386
q18	7581	7191	7287	7191
q19	1994	981	559	559
q20	321	323	215	215
q21	3772	3170	2324	2324
q22	1083	1039	967	967
Total cold run time: 115536 ms
Total hot run time: 33888 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5242	5102	5042	5042
q2	235	326	223	223
q3	2140	2643	2306	2306
q4	1359	1763	1383	1383
q5	4485	4361	4387	4361
q6	218	169	127	127
q7	2013	1914	1806	1806
q8	2576	2657	2586	2586
q9	7203	7244	6983	6983
q10	3009	3171	2736	2736
q11	581	516	505	505
q12	686	751	639	639
q13	3515	3922	3241	3241
q14	306	317	283	283
q15	533	488	467	467
q16	438	478	436	436
q17	1176	1559	1381	1381
q18	7831	7516	7618	7516
q19	778	798	879	798
q20	1938	1966	1878	1878
q21	4945	4604	4421	4421
q22	1127	1064	1052	1052
Total cold run time: 52334 ms
Total hot run time: 50170 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192685 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 905dcbd38ae029e4e080d115e318e79d714ff796, data reload: false

query1	1446	1093	1062	1062
query2	6363	1789	1795	1789
query3	11125	4511	4522	4511
query4	54055	25846	23236	23236
query5	5101	546	450	450
query6	331	210	189	189
query7	4886	495	294	294
query8	265	224	206	206
query9	5443	2613	2626	2613
query10	444	309	260	260
query11	15159	15234	14868	14868
query12	154	109	105	105
query13	1014	535	406	406
query14	10154	6439	6435	6435
query15	204	203	181	181
query16	7111	698	529	529
query17	1094	721	573	573
query18	1589	397	307	307
query19	194	192	163	163
query20	138	124	117	117
query21	214	123	108	108
query22	4355	4569	4314	4314
query23	34408	33851	33539	33539
query24	6663	2414	2437	2414
query25	496	461	418	418
query26	692	277	154	154
query27	2174	523	334	334
query28	2892	2151	2157	2151
query29	593	560	442	442
query30	268	221	189	189
query31	863	831	787	787
query32	80	63	69	63
query33	437	377	330	330
query34	774	868	531	531
query35	795	823	742	742
query36	961	1008	895	895
query37	109	99	87	87
query38	4276	4329	4130	4130
query39	1583	1460	1495	1460
query40	218	128	118	118
query41	80	69	60	60
query42	124	109	111	109
query43	497	503	482	482
query44	1345	880	836	836
query45	182	177	167	167
query46	849	1020	689	689
query47	1873	1881	1795	1795
query48	414	432	325	325
query49	672	510	404	404
query50	674	712	432	432
query51	4271	4258	4157	4157
query52	109	107	105	105
query53	224	256	183	183
query54	580	592	532	532
query55	85	88	116	88
query56	316	310	300	300
query57	1185	1186	1119	1119
query58	271	276	254	254
query59	2723	2736	2681	2681
query60	327	324	306	306
query61	120	125	127	125
query62	752	736	669	669
query63	237	194	189	189
query64	1483	1057	802	802
query65	4233	4117	4142	4117
query66	728	418	318	318
query67	15852	15762	15490	15490
query68	5734	896	542	542
query69	549	340	283	283
query70	1208	1142	1109	1109
query71	453	324	299	299
query72	6204	4771	4795	4771
query73	1351	625	353	353
query74	9117	9056	8706	8706
query75	3295	3214	2683	2683
query76	3837	1185	753	753
query77	566	384	290	290
query78	10039	10141	9447	9447
query79	2662	813	592	592
query80	707	607	451	451
query81	504	248	217	217
query82	738	134	95	95
query83	248	246	232	232
query84	296	108	92	92
query85	786	351	319	319
query86	406	307	282	282
query87	4354	4402	4365	4365
query88	3788	2300	2294	2294
query89	405	312	290	290
query90	1721	214	214	214
query91	151	145	109	109
query92	77	62	56	56
query93	2589	932	595	595
query94	774	429	311	311
query95	363	292	290	290
query96	486	577	280	280
query97	2673	2780	2627	2627
query98	238	216	208	208
query99	1380	1395	1296	1296
Total cold run time: 297026 ms
Total hot run time: 192685 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.11	0.11
query3	0.25	0.20	0.19
query4	1.60	0.19	0.20
query5	0.45	0.44	0.46
query6	1.17	0.66	0.66
query7	0.02	0.02	0.02
query8	0.04	0.04	0.03
query9	0.61	0.51	0.51
query10	0.56	0.58	0.58
query11	0.16	0.10	0.11
query12	0.15	0.11	0.12
query13	0.61	0.59	0.59
query14	0.79	0.80	0.80
query15	0.88	0.86	0.86
query16	0.37	0.38	0.39
query17	1.02	1.07	1.02
query18	0.23	0.21	0.21
query19	1.94	1.83	1.80
query20	0.01	0.01	0.01
query21	15.41	0.90	0.53
query22	0.76	1.21	0.62
query23	14.99	1.37	0.61
query24	7.04	1.42	0.84
query25	0.45	0.10	0.08
query26	0.68	0.16	0.13
query27	0.05	0.04	0.04
query28	8.76	0.93	0.45
query29	12.54	3.96	3.41
query30	0.25	0.09	0.06
query31	2.82	0.59	0.39
query32	3.23	0.56	0.47
query33	3.06	3.09	3.06
query34	16.39	5.13	4.55
query35	4.53	4.56	4.51
query36	0.67	0.50	0.48
query37	0.09	0.07	0.06
query38	0.05	0.04	0.03
query39	0.02	0.03	0.02
query40	0.17	0.13	0.12
query41	0.08	0.03	0.02
query42	0.03	0.02	0.03
query43	0.04	0.03	0.03
Total cold run time: 103.13 s
Total hot run time: 29.17 s

@CalvinKirs
Copy link
Member Author

run external

@CalvinKirs
Copy link
Member Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25862	5101	4993	4993
q2	1947	271	182	182
q3	10319	1362	704	704
q4	10234	1023	523	523
q5	7531	2310	2376	2310
q6	177	164	136	136
q7	904	740	608	608
q8	9533	1269	1115	1115
q9	7175	5168	5151	5151
q10	6873	2313	1923	1923
q11	491	292	273	273
q12	338	355	216	216
q13	17800	3704	3075	3075
q14	229	233	207	207
q15	564	483	479	479
q16	432	430	376	376
q17	588	834	358	358
q18	7532	7059	7238	7059
q19	1864	963	589	589
q20	331	344	216	216
q21	3624	2546	2297	2297
q22	1045	1040	1020	1020
Total cold run time: 115393 ms
Total hot run time: 33810 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5188	5220	5077	5077
q2	245	315	226	226
q3	2181	2636	2284	2284
q4	1372	1806	1343	1343
q5	4417	4389	4395	4389
q6	214	178	136	136
q7	2021	1928	1774	1774
q8	2596	2586	2565	2565
q9	7275	7154	7034	7034
q10	3007	3191	2721	2721
q11	573	529	493	493
q12	682	758	638	638
q13	3506	3892	3280	3280
q14	270	310	303	303
q15	536	477	472	472
q16	434	484	439	439
q17	1152	1498	1498	1498
q18	7732	7478	7505	7478
q19	774	796	897	796
q20	2017	2006	1871	1871
q21	4830	4548	4477	4477
q22	1076	1063	1035	1035
Total cold run time: 52098 ms
Total hot run time: 50329 ms

@doris-robot
Copy link

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

query1	1407	1122	1057	1057
query2	6251	1773	1794	1773
query3	11011	4363	4517	4363
query4	54007	25666	23123	23123
query5	4839	626	469	469
query6	349	208	198	198
query7	4875	509	300	300
query8	282	231	211	211
query9	5499	2630	2619	2619
query10	461	328	280	280
query11	15012	14905	14801	14801
query12	161	111	118	111
query13	1036	528	427	427
query14	10055	6321	6412	6321
query15	228	208	177	177
query16	7201	679	521	521
query17	1093	754	589	589
query18	1640	420	311	311
query19	213	201	172	172
query20	138	123	123	123
query21	219	127	106	106
query22	4347	4419	4312	4312
query23	34491	33756	33732	33732
query24	6541	2447	2442	2442
query25	462	517	413	413
query26	696	281	146	146
query27	2302	510	348	348
query28	3073	2142	2123	2123
query29	575	603	430	430
query30	275	218	188	188
query31	865	866	786	786
query32	73	63	67	63
query33	428	363	341	341
query34	787	855	535	535
query35	819	836	762	762
query36	972	1030	918	918
query37	116	104	77	77
query38	4170	4297	4293	4293
query39	1527	1458	1483	1458
query40	220	118	109	109
query41	59	63	56	56
query42	129	108	109	108
query43	492	508	470	470
query44	1354	860	844	844
query45	176	177	165	165
query46	849	1028	652	652
query47	1873	1919	1852	1852
query48	397	427	326	326
query49	668	499	401	401
query50	683	708	412	412
query51	4288	4247	4261	4247
query52	121	113	103	103
query53	231	258	191	191
query54	596	588	515	515
query55	88	84	88	84
query56	307	307	295	295
query57	1178	1200	1099	1099
query58	276	262	266	262
query59	2592	2751	2613	2613
query60	330	336	306	306
query61	124	124	121	121
query62	738	732	670	670
query63	225	203	199	199
query64	1780	1011	678	678
query65	4215	4131	4185	4131
query66	699	405	302	302
query67	16161	15843	15565	15565
query68	7024	943	547	547
query69	528	331	280	280
query70	1232	1071	1081	1071
query71	465	322	310	310
query72	5756	4593	4894	4593
query73	1323	667	357	357
query74	8946	9188	9069	9069
query75	3672	3224	2811	2811
query76	4168	1210	745	745
query77	650	363	284	284
query78	10127	10115	9284	9284
query79	2813	822	578	578
query80	656	512	439	439
query81	499	248	212	212
query82	476	124	96	96
query83	278	251	242	242
query84	292	118	89	89
query85	788	355	312	312
query86	357	292	288	288
query87	4456	4450	4336	4336
query88	3470	2279	2283	2279
query89	393	317	288	288
query90	1777	210	207	207
query91	147	137	108	108
query92	78	64	60	60
query93	2074	952	592	592
query94	715	411	308	308
query95	372	307	284	284
query96	496	569	276	276
query97	2785	2797	2634	2634
query98	243	214	197	197
query99	1445	1422	1261	1261
Total cold run time: 297846 ms
Total hot run time: 192632 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.11	0.11	0.11
query3	0.25	0.19	0.19
query4	1.59	0.19	0.19
query5	0.42	0.41	0.44
query6	1.16	0.66	0.66
query7	0.03	0.01	0.01
query8	0.04	0.04	0.03
query9	0.59	0.52	0.53
query10	0.58	0.57	0.57
query11	0.15	0.11	0.11
query12	0.15	0.12	0.11
query13	0.62	0.60	0.61
query14	0.78	0.81	0.80
query15	0.87	0.87	0.86
query16	0.38	0.37	0.37
query17	1.07	1.04	1.08
query18	0.22	0.22	0.21
query19	1.96	1.85	1.84
query20	0.02	0.02	0.01
query21	15.39	0.89	0.53
query22	0.76	1.20	0.91
query23	14.71	1.33	0.67
query24	7.03	1.16	1.38
query25	0.46	0.15	0.25
query26	0.52	0.16	0.14
query27	0.05	0.05	0.04
query28	9.94	0.89	0.45
query29	12.57	4.03	3.35
query30	0.25	0.10	0.07
query31	2.84	0.59	0.40
query32	3.23	0.55	0.48
query33	3.10	3.14	3.03
query34	15.75	5.07	4.48
query35	4.52	4.51	4.51
query36	0.67	0.50	0.48
query37	0.09	0.07	0.06
query38	0.04	0.04	0.03
query39	0.04	0.03	0.03
query40	0.17	0.14	0.13
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 103.31 s
Total hot run time: 29.84 s


super(StorageBackend.StorageType.S3.name(), StorageBackend.StorageType.S3,
new S3ObjStorage(s3Properties));
this.s3Properties = s3Properties;
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Why need 2 properties? s3Properties and storageProperties?

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Each file system has its own parameter class with specific methods. Using the concrete type improves clarity and avoids unnecessary abstraction.

Since StorageProperties was somewhat redundant, I refactored it into an abstract base class. This allows each subclass to simply return its own concrete instance while still sharing a common structure.

public DFSFileSystem(HdfsCompatibleProperties hdfsProperties) {
super(StorageBackend.StorageType.HDFS.name(), StorageBackend.StorageType.HDFS);
this.properties.putAll(hdfsProperties.getOrigProps());
this.storageProperties = hdfsProperties;
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Why need both storageProperties and hdfsProperties

authenticator = HadoopAuthenticator.getHadoopAuthenticator(authConfig);
Configuration conf = hdfsProperties.getHadoopConfiguration();
// TODO: Temporarily disable the HDFS file system cache to prevent instances from being closed by
// each other in V1. This line can be removed once V1 and V2 are unified.
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

There is anything else we need to do to unify v1 and v2?

@CalvinKirs
Copy link
Member Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26339	4978	4978	4978
q2	1943	280	182	182
q3	10307	1248	683	683
q4	10225	998	512	512
q5	7540	2379	2282	2282
q6	176	162	138	138
q7	897	740	615	615
q8	9301	1204	1051	1051
q9	6836	5119	5080	5080
q10	6864	2299	1881	1881
q11	500	297	274	274
q12	346	344	207	207
q13	17766	3637	3099	3099
q14	230	232	215	215
q15	564	485	477	477
q16	430	428	371	371
q17	597	856	358	358
q18	7522	7286	7193	7193
q19	2046	1006	545	545
q20	326	327	215	215
q21	3746	3166	2336	2336
q22	1044	1041	963	963
Total cold run time: 115545 ms
Total hot run time: 33655 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5186	5113	5020	5020
q2	239	316	219	219
q3	2160	2674	2313	2313
q4	1351	1749	1374	1374
q5	4442	4380	4392	4380
q6	211	174	129	129
q7	2034	1927	1746	1746
q8	2559	2677	2565	2565
q9	7278	7124	6944	6944
q10	3012	3185	2757	2757
q11	577	507	485	485
q12	648	757	604	604
q13	3531	3923	3217	3217
q14	306	296	292	292
q15	520	494	493	493
q16	447	506	440	440
q17	1139	1523	1399	1399
q18	7923	7618	7455	7455
q19	805	788	893	788
q20	1994	2134	1834	1834
q21	4834	4445	4428	4428
q22	1131	1090	1054	1054
Total cold run time: 52327 ms
Total hot run time: 49936 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192566 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 0f9ade0f8f8ce73f136498e362082dce5bc4102c, data reload: false

query1	1400	1071	1039	1039
query2	6498	1791	1785	1785
query3	11018	4611	4494	4494
query4	53216	24540	22909	22909
query5	5168	503	457	457
query6	374	207	203	203
query7	5087	494	298	298
query8	300	228	209	209
query9	6474	2645	2619	2619
query10	458	337	279	279
query11	15035	15088	14773	14773
query12	166	110	102	102
query13	1160	529	424	424
query14	10006	6269	6366	6269
query15	198	196	182	182
query16	6941	615	515	515
query17	1052	770	560	560
query18	1511	393	308	308
query19	194	194	163	163
query20	130	127	119	119
query21	213	121	119	119
query22	4436	4433	4415	4415
query23	34472	33535	33579	33535
query24	6699	2408	2408	2408
query25	456	461	403	403
query26	645	272	166	166
query27	2225	527	359	359
query28	2957	2160	2160	2160
query29	576	580	452	452
query30	281	229	194	194
query31	862	860	817	817
query32	71	61	62	61
query33	427	357	316	316
query34	783	865	531	531
query35	789	845	751	751
query36	933	1005	887	887
query37	122	102	83	83
query38	4169	4254	4149	4149
query39	1496	1469	1478	1469
query40	213	121	103	103
query41	66	76	71	71
query42	130	111	112	111
query43	491	530	474	474
query44	1354	859	880	859
query45	189	180	166	166
query46	849	1023	646	646
query47	1824	1894	1794	1794
query48	410	420	329	329
query49	662	496	387	387
query50	650	697	421	421
query51	4166	4334	4198	4198
query52	117	118	117	117
query53	239	250	186	186
query54	586	583	519	519
query55	89	87	91	87
query56	314	336	290	290
query57	1162	1183	1095	1095
query58	265	260	261	260
query59	2764	2839	2735	2735
query60	346	346	324	324
query61	126	125	125	125
query62	715	757	695	695
query63	225	199	192	192
query64	1388	1025	675	675
query65	4221	4159	4153	4153
query66	728	418	316	316
query67	15962	15693	15552	15552
query68	5549	897	538	538
query69	542	317	287	287
query70	1227	1146	1100	1100
query71	427	324	306	306
query72	5894	4890	5045	4890
query73	1165	741	363	363
query74	9033	9234	8943	8943
query75	3350	3218	2795	2795
query76	3822	1200	753	753
query77	562	374	286	286
query78	10074	10221	9372	9372
query79	2306	810	567	567
query80	654	511	444	444
query81	486	264	218	218
query82	177	123	96	96
query83	297	253	235	235
query84	293	110	88	88
query85	839	347	303	303
query86	350	296	288	288
query87	4395	4414	4294	4294
query88	3331	2312	2285	2285
query89	395	307	278	278
query90	1776	205	205	205
query91	140	141	115	115
query92	74	59	59	59
query93	2090	955	585	585
query94	671	398	293	293
query95	367	290	280	280
query96	492	568	287	287
query97	2724	2714	2660	2660
query98	231	220	206	206
query99	1300	1392	1285	1285
Total cold run time: 294282 ms
Total hot run time: 192566 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 29.43 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 0f9ade0f8f8ce73f136498e362082dce5bc4102c, 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.19
query5	0.45	0.45	0.45
query6	1.18	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.04
query9	0.59	0.51	0.52
query10	0.57	0.57	0.55
query11	0.15	0.10	0.11
query12	0.15	0.11	0.11
query13	0.61	0.59	0.59
query14	0.83	0.79	0.81
query15	0.88	0.87	0.86
query16	0.38	0.37	0.38
query17	1.04	1.05	1.03
query18	0.23	0.21	0.21
query19	1.97	1.86	1.86
query20	0.01	0.00	0.02
query21	15.39	0.92	0.53
query22	0.77	1.15	0.71
query23	14.91	1.37	0.63
query24	6.87	1.66	1.05
query25	0.51	0.22	0.05
query26	0.53	0.17	0.14
query27	0.06	0.05	0.06
query28	10.30	0.87	0.43
query29	12.57	4.08	3.45
query30	0.26	0.09	0.07
query31	2.81	0.60	0.39
query32	3.23	0.54	0.46
query33	3.06	3.16	3.11
query34	15.79	5.12	4.46
query35	4.53	4.48	4.50
query36	0.68	0.50	0.49
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.04	0.02	0.02
query40	0.17	0.14	0.12
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 103.86 s
Total hot run time: 29.43 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 31.06% (50/161) 🎉
Increment coverage report
Complete coverage report

@CalvinKirs
Copy link
Member Author

run p0

@CalvinKirs
Copy link
Member Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25774	4939	4927	4927
q2	1933	277	176	176
q3	10311	1213	669	669
q4	10218	997	524	524
q5	7530	2345	2301	2301
q6	177	162	130	130
q7	896	709	604	604
q8	9310	1210	1120	1120
q9	6871	5118	5075	5075
q10	6877	2335	1950	1950
q11	477	282	277	277
q12	340	341	207	207
q13	17815	3698	3124	3124
q14	222	229	222	222
q15	576	487	478	478
q16	438	436	369	369
q17	581	809	401	401
q18	7517	7258	7149	7149
q19	1479	940	539	539
q20	336	337	223	223
q21	3799	3199	2294	2294
q22	1055	1006	945	945
Total cold run time: 114532 ms
Total hot run time: 33704 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5043	4978	5006	4978
q2	235	315	214	214
q3	2192	2637	2295	2295
q4	1348	1741	1368	1368
q5	4318	4368	4324	4324
q6	206	164	126	126
q7	2033	1918	1748	1748
q8	2584	2478	2452	2452
q9	7266	7192	7013	7013
q10	2983	3195	2748	2748
q11	583	516	489	489
q12	666	778	606	606
q13	3497	3910	3302	3302
q14	269	316	301	301
q15	529	489	485	485
q16	427	484	449	449
q17	1143	1541	1354	1354
q18	7747	7441	7634	7441
q19	780	762	769	762
q20	2003	1976	1842	1842
q21	4715	4551	4455	4455
q22	1125	1049	1052	1049
Total cold run time: 51692 ms
Total hot run time: 49801 ms

@doris-robot
Copy link

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

query1	1450	1081	1040	1040
query2	6218	1767	1791	1767
query3	10986	4470	4592	4470
query4	54085	25049	23844	23844
query5	5230	566	462	462
query6	367	206	194	194
query7	4950	520	293	293
query8	303	231	209	209
query9	5999	2616	2627	2616
query10	414	320	276	276
query11	15104	14983	14851	14851
query12	159	112	109	109
query13	1081	513	433	433
query14	10150	6352	6300	6300
query15	200	215	185	185
query16	7040	689	512	512
query17	1073	758	615	615
query18	1525	404	313	313
query19	197	202	162	162
query20	131	120	117	117
query21	199	124	106	106
query22	4475	4650	4331	4331
query23	34459	33729	33685	33685
query24	6593	2424	2432	2424
query25	475	471	426	426
query26	723	280	147	147
query27	2351	511	355	355
query28	3383	2145	2149	2145
query29	567	550	457	457
query30	275	225	191	191
query31	870	855	792	792
query32	75	61	61	61
query33	461	372	319	319
query34	787	864	545	545
query35	795	849	735	735
query36	988	997	901	901
query37	111	102	85	85
query38	4202	4287	4255	4255
query39	1494	1445	1481	1445
query40	217	123	108	108
query41	60	59	59	59
query42	135	114	106	106
query43	485	515	467	467
query44	1312	839	831	831
query45	183	177	164	164
query46	837	1034	658	658
query47	1865	1907	1834	1834
query48	396	421	332	332
query49	648	482	408	408
query50	663	691	418	418
query51	4307	4304	4178	4178
query52	114	114	102	102
query53	234	253	192	192
query54	576	580	514	514
query55	88	88	86	86
query56	312	308	295	295
query57	1172	1197	1123	1123
query58	283	271	258	258
query59	2722	2814	2626	2626
query60	347	336	309	309
query61	167	121	130	121
query62	736	733	682	682
query63	224	192	189	189
query64	1684	1015	685	685
query65	4180	4173	4138	4138
query66	733	410	321	321
query67	15952	15528	15517	15517
query68	6409	879	526	526
query69	569	298	266	266
query70	1204	1093	1114	1093
query71	512	316	320	316
query72	5695	4778	4919	4778
query73	1241	655	362	362
query74	9074	9191	8620	8620
query75	4056	3155	2704	2704
query76	4271	1192	753	753
query77	697	376	306	306
query78	10177	10233	9381	9381
query79	2681	784	567	567
query80	667	509	434	434
query81	478	255	214	214
query82	526	123	97	97
query83	319	252	233	233
query84	295	114	91	91
query85	773	345	307	307
query86	371	325	300	300
query87	4391	4437	4413	4413
query88	3445	2300	2294	2294
query89	451	314	283	283
query90	1787	209	201	201
query91	142	150	112	112
query92	71	60	65	60
query93	2338	930	585	585
query94	663	416	304	304
query95	363	300	280	280
query96	495	569	282	282
query97	2755	2795	2641	2641
query98	226	212	208	208
query99	1397	1410	1302	1302
Total cold run time: 299116 ms
Total hot run time: 193207 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.11	0.12
query3	0.25	0.19	0.20
query4	1.60	0.19	0.19
query5	0.45	0.44	0.43
query6	1.16	0.66	0.65
query7	0.03	0.02	0.01
query8	0.05	0.03	0.04
query9	0.58	0.51	0.51
query10	0.57	0.56	0.56
query11	0.15	0.11	0.11
query12	0.15	0.12	0.12
query13	0.62	0.61	0.60
query14	0.78	0.81	0.80
query15	0.88	0.86	0.87
query16	0.37	0.40	0.37
query17	0.99	1.01	1.05
query18	0.23	0.22	0.21
query19	1.90	1.81	1.86
query20	0.01	0.01	0.02
query21	15.41	0.88	0.53
query22	0.76	1.14	0.78
query23	14.82	1.35	0.60
query24	6.97	2.27	0.84
query25	0.49	0.25	0.09
query26	0.63	0.17	0.15
query27	0.06	0.05	0.05
query28	9.34	0.81	0.44
query29	12.55	4.24	3.45
query30	0.25	0.09	0.06
query31	2.83	0.61	0.39
query32	3.23	0.57	0.48
query33	3.03	3.02	3.09
query34	15.68	5.14	4.48
query35	4.47	4.50	4.50
query36	0.68	0.49	0.48
query37	0.09	0.06	0.06
query38	0.06	0.04	0.04
query39	0.03	0.03	0.02
query40	0.16	0.14	0.13
query41	0.09	0.02	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 102.63 s
Total hot run time: 29.27 s

@CalvinKirs
Copy link
Member Author

run buildall

Comment on lines 103 to +104
"storage_resource" = "${resource_table_use}",
"cooldown_datetime" = "2025-06-08 00:00:00"
"cooldown_datetime" = "2035-06-08 00:00:00"
Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This kind of absolute time writing should be prohibited

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25855	5023	4955	4955
q2	1957	272	181	181
q3	10299	1209	695	695
q4	10222	1000	534	534
q5	7513	2358	2276	2276
q6	179	165	134	134
q7	888	741	598	598
q8	9297	1276	1003	1003
q9	6816	5229	5042	5042
q10	7004	2403	1941	1941
q11	544	297	296	296
q12	354	365	222	222
q13	17766	3664	3080	3080
q14	233	222	210	210
q15	553	481	486	481
q16	424	427	372	372
q17	581	848	359	359
q18	7548	7180	7070	7070
q19	2067	946	545	545
q20	328	325	220	220
q21	3709	3124	2348	2348
q22	1043	989	979	979
Total cold run time: 115180 ms
Total hot run time: 33541 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5193	5027	5027	5027
q2	240	311	217	217
q3	2205	2621	2321	2321
q4	1388	1769	1407	1407
q5	4432	4382	4400	4382
q6	213	170	129	129
q7	1995	1927	1812	1812
q8	2561	2571	2452	2452
q9	7133	7120	6897	6897
q10	2991	3194	2780	2780
q11	572	521	495	495
q12	661	763	607	607
q13	3547	3923	3290	3290
q14	295	285	282	282
q15	552	503	496	496
q16	451	493	455	455
q17	1129	1523	1408	1408
q18	7730	7564	7414	7414
q19	772	780	825	780
q20	1985	2026	1890	1890
q21	4711	4495	4409	4409
q22	1112	1047	1036	1036
Total cold run time: 51868 ms
Total hot run time: 49986 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192480 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 5442be39eda34b01f4a8e4d341dc734de80d9807, data reload: false

query1	1407	1049	1064	1049
query2	6284	1830	1804	1804
query3	11046	4674	4302	4302
query4	54831	24332	23076	23076
query5	5019	518	454	454
query6	338	220	195	195
query7	4914	500	296	296
query8	295	228	217	217
query9	5947	2611	2623	2611
query10	432	329	283	283
query11	15107	15291	14755	14755
query12	164	111	115	111
query13	1070	530	412	412
query14	10120	6477	6481	6477
query15	195	212	184	184
query16	7073	705	518	518
query17	1091	720	597	597
query18	1542	403	307	307
query19	193	190	164	164
query20	125	130	123	123
query21	213	122	111	111
query22	4482	4473	4266	4266
query23	34253	33571	33785	33571
query24	6430	2467	2471	2467
query25	462	477	420	420
query26	666	277	177	177
query27	2260	519	343	343
query28	2991	2153	2141	2141
query29	600	586	442	442
query30	284	229	193	193
query31	877	858	794	794
query32	73	64	72	64
query33	457	407	342	342
query34	774	867	534	534
query35	822	848	782	782
query36	940	1026	924	924
query37	114	105	77	77
query38	4265	4337	4160	4160
query39	1522	1468	1570	1468
query40	224	117	104	104
query41	67	61	56	56
query42	130	116	123	116
query43	488	513	489	489
query44	1336	830	853	830
query45	186	173	174	173
query46	839	1022	667	667
query47	1842	1865	1792	1792
query48	402	460	318	318
query49	647	506	397	397
query50	666	723	410	410
query51	4187	4275	4218	4218
query52	119	110	109	109
query53	239	269	201	201
query54	579	591	525	525
query55	89	85	84	84
query56	303	313	295	295
query57	1156	1192	1110	1110
query58	271	263	267	263
query59	2638	2847	2689	2689
query60	326	321	324	321
query61	133	124	143	124
query62	715	758	693	693
query63	222	191	229	191
query64	1425	1008	682	682
query65	4264	4142	4128	4128
query66	714	398	317	317
query67	15760	15732	15174	15174
query68	6198	881	537	537
query69	537	323	277	277
query70	1161	1127	1116	1116
query71	459	319	293	293
query72	5750	4826	4856	4826
query73	1200	626	353	353
query74	8994	8955	8962	8955
query75	3410	3207	2740	2740
query76	3869	1195	768	768
query77	569	379	284	284
query78	10194	10025	9398	9398
query79	2728	805	587	587
query80	795	521	528	521
query81	477	254	222	222
query82	426	124	98	98
query83	376	254	227	227
query84	290	106	92	92
query85	794	360	318	318
query86	405	297	286	286
query87	4572	4396	4303	4303
query88	3567	2315	2315	2315
query89	404	321	278	278
query90	1827	209	211	209
query91	144	142	112	112
query92	80	67	60	60
query93	2301	933	588	588
query94	691	400	305	305
query95	370	304	288	288
query96	488	576	287	287
query97	2741	2723	2617	2617
query98	230	208	207	207
query99	1468	1441	1326	1326
Total cold run time: 297160 ms
Total hot run time: 192480 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.12	0.11	0.11
query3	0.25	0.19	0.18
query4	1.59	0.19	0.18
query5	0.45	0.44	0.45
query6	1.45	0.67	0.65
query7	0.02	0.02	0.01
query8	0.05	0.03	0.04
query9	0.59	0.51	0.51
query10	0.56	0.59	0.57
query11	0.15	0.11	0.11
query12	0.15	0.12	0.12
query13	0.61	0.61	0.60
query14	0.80	0.81	0.82
query15	0.88	0.85	0.87
query16	0.39	0.37	0.38
query17	1.06	1.06	0.99
query18	0.22	0.21	0.21
query19	1.90	1.80	1.80
query20	0.02	0.01	0.01
query21	15.42	0.92	0.56
query22	0.77	1.09	0.65
query23	15.01	1.36	0.61
query24	6.91	1.99	0.44
query25	0.51	0.26	0.13
query26	0.64	0.16	0.15
query27	0.05	0.05	0.04
query28	9.91	0.87	0.44
query29	12.57	4.10	3.47
query30	0.25	0.09	0.07
query31	2.81	0.60	0.39
query32	3.22	0.55	0.47
query33	3.00	3.06	3.09
query34	15.83	5.14	4.46
query35	4.55	4.48	4.50
query36	0.65	0.50	0.47
query37	0.08	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.03	0.03
query40	0.18	0.14	0.13
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 103.89 s
Total hot run time: 28.79 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 31.06% (50/161) 🎉
Increment coverage report
Complete coverage report

Copy link
Contributor

github-actions bot commented Jun 8, 2025

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

@github-actions github-actions bot added approved Indicates a PR has been approved by one committer. reviewed labels Jun 8, 2025
Copy link
Contributor

github-actions bot commented Jun 8, 2025

PR approved by anyone and no changes requested.

@CalvinKirs CalvinKirs merged commit 92b201b into apache:master Jun 9, 2025
25 of 28 checks passed
@CalvinKirs CalvinKirs deleted the master-fsv2-fsv1 branch June 9, 2025 01:48
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
approved Indicates a PR has been approved by one committer. dev/3.1.x reviewed
Projects
None yet
Development

Successfully merging this pull request may close these issues.

5 participants