[feat](restore): enhance storage medium control #58897

Ryan19929 · 2025-12-10T07:47:41Z

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Background

In current Doris, storage medium (SSD/HDD) selection lacks fine-grained control:

Implicit medium selection with inconsistent fallback behavior
Restore operations cannot control whether to preserve or override source table's storage medium

Solution

This PR introduces medium_allocation_mode property with two modes:

Mode	Behavior
`strict`	Strictly use the specified `storage_medium`. Fail if unavailable (except in single-medium environments where fallback is necessary)
`adaptive`	Prefer the specified medium, but automatically fallback to available alternatives if the preferred medium is unavailable

Additionally, RESTORE command now supports:

storage_medium: Choose hdd, ssd, or same_with_upstream (preserve source table's medium)
medium_allocation_mode: Control allocation strategy during restore

Main Changes

FE:

DataProperty.java: Add MediumAllocationMode enum
RestoreCommand.java: Support new properties
RestoreJob.java: Integrate medium decision logic
MediumDecisionMaker.java: Centralized medium selection (new)
SystemInfoService.java: Support allocation mode in backend selection
TableProperty.java: Persist medium_allocation_mode
FrontendService.thrift: Add new RPC fields

BE:

config.cpp/h: Add enable_storage_medium_fallback for runtime fallback
storage_engine.cpp: Support fallback logic

Legacy Table Compatibility

Existing tables automatically infer allocation mode:

Tables with explicit storage_medium → STRICT mode (preserve current behavior)
Tables without storage_medium → ADAPTIVE mode (allow flexibility)

Usage Examples

-- Create with strict mode
CREATE TABLE t1 (...) PROPERTIES (
    'storage_medium' = 'ssd',
    'medium_allocation_mode' = 'strict'
);

-- Restore preserving source medium
RESTORE SNAPSHOT db1.snap FROM repo PROPERTIES (
    'backup_timestamp' = '...',
    'storage_medium' = 'same_with_upstream',
    'medium_allocation_mode' = 'adaptive'
);

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. [doc] enhance storage medium allocation control doris-website#2701

Check List (For Reviewer who merge this PR)

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

Ryan19929 · 2025-12-10T07:50:33Z

run buildall

hello-stephen · 2025-12-10T08:07:44Z

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	79.82% (1728/2165)
Line Coverage	65.94% (30590/46390)
Region Coverage	66.63% (15258/22900)
Branch Coverage	56.95% (8115/14250)

hello-stephen · 2025-12-10T09:03:56Z

FE UT Coverage Report

Increment line coverage 33.13% (161/486) 🎉
Increment coverage report
Complete coverage report

doris-robot · 2025-12-10T10:14:31Z

TPC-H: Total hot run time: 36623 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 6f78c73a37d9227124a04c937d2a38a2019e1973, data reload: false

------ Round 1 ----------------------------------
q1	17607	4191	4066	4066
q2	2005	341	236	236
q3	10234	1325	737	737
q4	10223	854	317	317
q5	7956	2210	1905	1905
q6	245	172	140	140
q7	1012	864	718	718
q8	9368	1474	1140	1140
q9	7193	5335	5400	5335
q10	6875	2405	1969	1969
q11	518	312	308	308
q12	734	756	631	631
q13	17808	3672	3059	3059
q14	305	300	277	277
q15	602	528	515	515
q16	950	927	861	861
q17	716	822	538	538
q18	7527	7898	7801	7801
q19	1537	1003	625	625
q20	414	372	251	251
q21	4574	4257	4143	4143
q22	1142	1064	1051	1051
Total cold run time: 109545 ms
Total hot run time: 36623 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4412	4293	4323	4293
q2	338	411	332	332
q3	2494	2838	2494	2494
q4	1403	1864	1445	1445
q5	4721	4475	4474	4474
q6	214	171	126	126
q7	1999	1884	1781	1781
q8	2670	2573	2552	2552
q9	7662	7599	7154	7154
q10	2908	3133	2629	2629
q11	564	485	474	474
q12	625	712	548	548
q13	3314	3630	2985	2985
q14	272	284	259	259
q15	532	503	495	495
q16	841	884	844	844
q17	1128	1353	1385	1353
q18	7318	7105	7147	7105
q19	814	785	829	785
q20	1909	1990	1841	1841
q21	4627	4265	4155	4155
q22	1104	1028	1003	1003
Total cold run time: 51869 ms
Total hot run time: 49127 ms

doris-robot · 2025-12-10T10:25:50Z

TPC-DS: Total hot run time: 182217 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 6f78c73a37d9227124a04c937d2a38a2019e1973, data reload: false

query5	4541	630	493	493
query6	332	238	227	227
query7	4229	479	293	293
query8	315	268	251	251
query9	8799	2577	2595	2577
query10	551	405	343	343
query11	15061	15200	15203	15200
query12	198	122	119	119
query13	1271	517	402	402
query14	6643	3272	3015	3015
query14_1	2934	2894	2958	2894
query15	208	200	182	182
query16	804	479	465	465
query17	1148	738	610	610
query18	2700	450	358	358
query19	241	242	215	215
query20	128	119	115	115
query21	223	144	118	118
query22	3898	4004	3877	3877
query23	16643	16054	16062	16054
query23_1	16127	16105	16047	16047
query24	7416	1668	1278	1278
query24_1	1242	1257	1248	1248
query25	566	501	470	470
query26	1263	273	167	167
query27	2733	463	323	323
query28	4448	2160	2148	2148
query29	846	537	443	443
query30	319	251	215	215
query31	856	703	613	613
query32	86	70	72	70
query33	533	330	296	296
query34	904	896	554	554
query35	778	832	733	733
query36	864	902	824	824
query37	137	96	79	79
query38	3889	3872	3764	3764
query39	753	754	707	707
query39_1	692	694	719	694
query40	228	139	128	128
query41	70	63	60	60
query42	112	110	108	108
query43	429	424	395	395
query44	1360	752	751	751
query45	194	194	183	183
query46	891	980	637	637
query47	1667	1707	1611	1611
query48	310	323	246	246
query49	627	437	355	355
query50	672	302	227	227
query51	3908	3816	3889	3816
query52	112	108	102	102
query53	343	359	293	293
query54	301	266	249	249
query55	78	77	69	69
query56	300	298	329	298
query57	1131	1136	1072	1072
query58	270	254	253	253
query59	2298	2466	2316	2316
query60	310	315	293	293
query61	163	155	153	153
query62	703	671	650	650
query63	327	297	299	297
query64	4918	1320	1020	1020
query65	4027	3953	3952	3952
query66	1382	448	344	344
query67	15372	14821	14600	14600
query68	8292	1012	748	748
query69	485	345	306	306
query70	1105	1002	1015	1002
query71	366	322	287	287
query72	6082	5097	5248	5097
query73	727	682	311	311
query74	8893	8812	8677	8677
query75	3600	3514	3181	3181
query76	4059	1159	773	773
query77	547	401	304	304
query78	9369	9662	8900	8900
query79	1727	845	630	630
query80	721	653	556	556
query81	516	275	236	236
query82	202	139	108	108
query83	266	263	245	245
query84	256	124	109	109
query85	915	516	473	473
query86	379	299	302	299
query87	4018	4133	4005	4005
query88	3323	2292	2305	2292
query89	476	438	407	407
query90	2204	179	148	148
query91	177	171	146	146
query92	81	72	67	67
query93	2329	933	566	566
query94	466	303	271	271
query95	600	327	313	313
query96	584	473	212	212
query97	2626	2648	2574	2574
query98	219	197	192	192
query99	1369	1307	1223	1223
Total cold run time: 264878 ms
Total hot run time: 182217 ms

doris-robot · 2025-12-10T10:31:01Z

ClickBench: Total hot run time: 28.28 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 6f78c73a37d9227124a04c937d2a38a2019e1973, data reload: false

query1	0.05	0.05	0.04
query2	0.14	0.07	0.06
query3	0.30	0.08	0.07
query4	1.61	0.10	0.10
query5	0.26	0.24	0.25
query6	1.17	0.64	0.63
query7	0.04	0.03	0.03
query8	0.07	0.06	0.06
query9	0.58	0.51	0.50
query10	0.56	0.58	0.55
query11	0.26	0.13	0.14
query12	0.26	0.14	0.14
query13	0.64	0.65	0.61
query14	1.01	1.01	1.01
query15	0.89	0.84	0.81
query16	0.40	0.37	0.43
query17	0.98	0.96	0.97
query18	0.24	0.22	0.22
query19	1.97	1.85	1.84
query20	0.02	0.02	0.01
query21	15.44	0.29	0.24
query22	4.98	0.10	0.09
query23	15.41	0.41	0.22
query24	2.41	0.44	0.29
query25	0.10	0.09	0.09
query26	0.18	0.18	0.18
query27	0.10	0.09	0.09
query28	3.71	1.37	1.15
query29	12.56	4.09	3.29
query30	0.32	0.13	0.10
query31	2.81	0.64	0.43
query32	3.25	0.60	0.48
query33	3.07	3.04	3.11
query34	16.78	5.19	4.62
query35	4.68	4.74	4.61
query36	0.62	0.49	0.48
query37	0.27	0.09	0.09
query38	0.19	0.06	0.06
query39	0.07	0.05	0.05
query40	0.19	0.16	0.17
query41	0.13	0.06	0.05
query42	0.08	0.05	0.04
query43	0.07	0.05	0.05
Total cold run time: 98.87 s
Total hot run time: 28.28 s

doris-robot · 2025-12-10T11:24:41Z

BE UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.36% (18717/35078)
Line Coverage	39.06% (173083/443106)
Region Coverage	33.76% (134327/397915)
Branch Coverage	34.67% (57723/166514)

hello-stephen · 2025-12-10T13:41:58Z

BE Regression && UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	73.06% (25117/34380)
Line Coverage	60.23% (266595/442630)
Region Coverage	55.97% (225372/402638)
Branch Coverage	57.12% (95611/167389)

hello-stephen · 2025-12-10T14:00:34Z

FE Regression Coverage Report

Increment line coverage 40.74% (198/486) 🎉
Increment coverage report
Complete coverage report

Ryan19929 · 2025-12-11T02:36:16Z

run feut

Ryan19929 · 2025-12-11T05:41:16Z

run p0

Ryan19929 · 2025-12-11T06:56:16Z

run buildall

hello-stephen · 2025-12-11T07:21:23Z

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	79.82% (1728/2165)
Line Coverage	65.92% (30578/46390)
Region Coverage	66.63% (15259/22900)
Branch Coverage	56.89% (8107/14250)

hello-stephen · 2025-12-11T08:12:33Z

FE UT Coverage Report

Increment line coverage 32.02% (154/481) 🎉
Increment coverage report
Complete coverage report

doris-robot · 2025-12-11T09:14:14Z

TPC-H: Total hot run time: 35526 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 792260b13e371e2a17a046cc66c71c673a1f27eb, data reload: false

------ Round 1 ----------------------------------
q1	17632	4321	4172	4172
q2	2035	356	247	247
q3	10405	1317	742	742
q4	10326	823	315	315
q5	9413	2192	1951	1951
q6	217	168	136	136
q7	1024	873	718	718
q8	9353	1488	1203	1203
q9	7382	5278	5386	5278
q10	6878	2417	1997	1997
q11	534	322	317	317
q12	734	754	583	583
q13	17788	3707	3078	3078
q14	295	298	264	264
q15	581	515	517	515
q16	941	921	873	873
q17	720	862	483	483
q18	8288	7162	7150	7150
q19	1132	974	615	615
q20	418	363	244	244
q21	4338	4048	3685	3685
q22	1047	1006	960	960
Total cold run time: 111481 ms
Total hot run time: 35526 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4154	4162	4068	4068
q2	334	405	323	323
q3	2176	2687	2271	2271
q4	1354	1777	1313	1313
q5	4788	4740	4611	4611
q6	213	165	127	127
q7	2053	1886	1856	1856
q8	2734	2532	2560	2532
q9	7618	7554	7447	7447
q10	3107	3237	3010	3010
q11	597	521	483	483
q12	693	767	569	569
q13	3804	3894	3406	3406
q14	285	331	265	265
q15	567	528	530	528
q16	963	922	878	878
q17	1258	1548	1413	1413
q18	7887	7734	7601	7601
q19	945	895	897	895
q20	1950	1966	1865	1865
q21	4729	4242	4169	4169
q22	1076	1032	974	974
Total cold run time: 53285 ms
Total hot run time: 50604 ms

doris-robot · 2025-12-11T09:25:25Z

TPC-DS: Total hot run time: 181839 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 792260b13e371e2a17a046cc66c71c673a1f27eb, data reload: false

query5	5209	637	478	478
query6	335	235	214	214
query7	4221	483	277	277
query8	303	251	237	237
query9	8793	2578	2583	2578
query10	550	381	321	321
query11	15800	15335	15163	15163
query12	188	115	117	115
query13	1262	497	373	373
query14	6414	3316	2993	2993
query14_1	2935	2884	2960	2884
query15	216	204	183	183
query16	831	480	441	441
query17	1089	712	579	579
query18	2682	431	346	346
query19	232	240	208	208
query20	124	115	111	111
query21	218	133	113	113
query22	3811	3892	3823	3823
query23	16496	16188	15877	15877
query23_1	16142	16069	15948	15948
query24	7340	1665	1227	1227
query24_1	1226	1220	1260	1220
query25	547	457	434	434
query26	1246	273	162	162
query27	2767	463	303	303
query28	4476	2169	2129	2129
query29	808	548	437	437
query30	321	247	226	226
query31	848	716	621	621
query32	77	72	72	72
query33	553	332	279	279
query34	902	923	538	538
query35	782	840	732	732
query36	866	912	828	828
query37	126	91	84	84
query38	3884	3892	3894	3892
query39	784	735	728	728
query39_1	706	695	701	695
query40	222	136	122	122
query41	69	63	64	63
query42	106	103	107	103
query43	436	429	403	403
query44	1359	762	755	755
query45	198	194	184	184
query46	876	986	634	634
query47	1671	1688	1611	1611
query48	316	324	249	249
query49	653	438	358	358
query50	650	298	221	221
query51	3782	3816	3806	3806
query52	108	111	99	99
query53	322	339	298	298
query54	294	272	283	272
query55	81	76	72	72
query56	291	302	295	295
query57	1146	1131	1070	1070
query58	271	255	254	254
query59	2307	2454	2380	2380
query60	325	329	315	315
query61	188	180	188	180
query62	723	669	633	633
query63	334	300	307	300
query64	5074	1368	1017	1017
query65	3998	3952	3964	3952
query66	1376	450	341	341
query67	15120	14963	14833	14833
query68	3078	1073	774	774
query69	506	350	306	306
query70	1084	1011	987	987
query71	346	311	284	284
query72	6000	4999	5138	4999
query73	536	567	314	314
query74	8706	8848	8517	8517
query75	3572	3561	3202	3202
query76	3615	1148	759	759
query77	548	389	312	312
query78	9514	9739	8885	8885
query79	1004	880	616	616
query80	1145	684	605	605
query81	569	273	244	244
query82	435	135	108	108
query83	280	261	250	250
query84	263	123	106	106
query85	1078	509	470	470
query86	359	303	302	302
query87	4010	4228	4001	4001
query88	3229	2316	2310	2310
query89	465	457	390	390
query90	1934	174	156	156
query91	177	171	149	149
query92	68	69	65	65
query93	1047	916	572	572
query94	574	299	283	283
query95	575	329	366	329
query96	600	454	211	211
query97	2622	2632	2579	2579
query98	207	195	201	195
query99	1275	1290	1204	1204
Total cold run time: 257841 ms
Total hot run time: 181839 ms

doris-robot · 2025-12-11T09:30:37Z

ClickBench: Total hot run time: 28.49 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 792260b13e371e2a17a046cc66c71c673a1f27eb, data reload: false

query1	0.05	0.05	0.04
query2	0.13	0.07	0.07
query3	0.31	0.08	0.08
query4	1.61	0.10	0.10
query5	0.26	0.25	0.25
query6	1.19	0.66	0.64
query7	0.03	0.03	0.03
query8	0.07	0.06	0.06
query9	0.59	0.50	0.50
query10	0.57	0.57	0.56
query11	0.26	0.13	0.14
query12	0.25	0.14	0.14
query13	0.64	0.63	0.60
query14	1.01	1.01	1.02
query15	0.90	0.82	0.83
query16	0.40	0.39	0.40
query17	1.05	1.06	1.07
query18	0.23	0.22	0.22
query19	1.98	1.84	1.86
query20	0.02	0.01	0.02
query21	15.40	0.28	0.23
query22	4.98	0.09	0.10
query23	15.39	0.40	0.22
query24	2.40	0.48	0.32
query25	0.10	0.09	0.10
query26	0.18	0.18	0.19
query27	0.09	0.09	0.10
query28	3.71	1.34	1.16
query29	12.58	4.16	3.36
query30	0.33	0.13	0.11
query31	2.82	0.63	0.43
query32	3.24	0.59	0.50
query33	3.01	2.99	3.14
query34	16.67	5.20	4.62
query35	4.75	4.57	4.73
query36	0.62	0.52	0.48
query37	0.24	0.09	0.08
query38	0.21	0.06	0.05
query39	0.07	0.05	0.05
query40	0.20	0.18	0.16
query41	0.13	0.06	0.06
query42	0.07	0.06	0.05
query43	0.06	0.06	0.05
Total cold run time: 98.8 s
Total hot run time: 28.49 s

hello-stephen · 2025-12-11T10:27:34Z

BE UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.36% (18764/35165)
Line Coverage	39.11% (173543/443704)
Region Coverage	33.80% (134613/398245)
Branch Coverage	34.73% (57884/166661)

hello-stephen · 2025-12-11T10:37:00Z

BE Regression && UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	72.27% (24911/34467)
Line Coverage	59.02% (261608/443228)
Region Coverage	54.03% (217741/402968)
Branch Coverage	55.51% (92997/167536)

hello-stephen · 2025-12-11T10:52:05Z

FE Regression Coverage Report

Increment line coverage 42.20% (203/481) 🎉
Increment coverage report
Complete coverage report

Ryan19929 · 2025-12-12T01:53:09Z

run buildall

hello-stephen · 2025-12-12T02:23:03Z

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	79.83% (1730/2167)
Line Coverage	65.86% (30607/46476)
Region Coverage	66.58% (15270/22934)
Branch Coverage	56.89% (8116/14266)

doris-robot · 2025-12-12T04:18:59Z

TPC-H: Total hot run time: 36834 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2c30e08fcd3bb3cd050152eb5b790e4b39aead13, data reload: false

------ Round 1 ----------------------------------
q1	17663	4221	4216	4216
q2	2040	366	237	237
q3	10433	1345	766	766
q4	10338	800	315	315
q5	9765	2099	2035	2035
q6	246	170	135	135
q7	1028	865	708	708
q8	9365	1378	1203	1203
q9	7255	5439	5398	5398
q10	6890	2385	2015	2015
q11	551	328	281	281
q12	739	716	595	595
q13	17825	3678	3086	3086
q14	286	315	272	272
q15	597	520	518	518
q16	915	936	872	872
q17	722	858	511	511
q18	7740	8465	7556	7556
q19	1124	1026	641	641
q20	434	392	251	251
q21	4651	4209	4234	4209
q22	1120	1099	1014	1014
Total cold run time: 111727 ms
Total hot run time: 36834 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4371	4268	4460	4268
q2	319	398	342	342
q3	2338	2894	2697	2697
q4	1406	1821	1455	1455
q5	4594	4511	4457	4457
q6	214	168	127	127
q7	2155	1965	1841	1841
q8	2669	2590	2621	2590
q9	7671	7404	7022	7022
q10	2926	3103	2695	2695
q11	560	489	467	467
q12	648	681	564	564
q13	3243	3682	3021	3021
q14	279	276	253	253
q15	528	495	493	493
q16	859	873	840	840
q17	1162	1451	1368	1368
q18	7244	7086	7141	7086
q19	867	814	837	814
q20	1932	1993	1807	1807
q21	4702	4349	4157	4157
q22	1136	1045	972	972
Total cold run time: 51823 ms
Total hot run time: 49336 ms

doris-robot · 2025-12-12T04:30:15Z

TPC-DS: Total hot run time: 181614 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 2c30e08fcd3bb3cd050152eb5b790e4b39aead13, data reload: false

query5	4775	606	479	479
query6	330	236	221	221
query7	4255	471	283	283
query8	319	259	249	249
query9	8798	2593	2590	2590
query10	533	400	343	343
query11	15610	15137	14553	14553
query12	192	120	120	120
query13	1277	515	391	391
query14	6476	3257	2987	2987
query14_1	2955	2967	2923	2923
query15	221	203	188	188
query16	904	463	471	463
query17	1153	739	619	619
query18	2577	449	361	361
query19	235	231	218	218
query20	125	120	115	115
query21	223	139	122	122
query22	3965	3939	4054	3939
query23	16771	16295	16322	16295
query23_1	16190	16105	16186	16105
query24	7373	1654	1222	1222
query24_1	1266	1228	1246	1228
query25	602	498	452	452
query26	1272	274	174	174
query27	2734	471	306	306
query28	4456	2159	2180	2159
query29	788	537	450	450
query30	315	247	216	216
query31	884	711	612	612
query32	79	66	69	66
query33	543	332	285	285
query34	913	887	544	544
query35	783	825	737	737
query36	850	903	823	823
query37	131	93	80	80
query38	3836	3852	3704	3704
query39	761	729	767	729
query39_1	706	700	728	700
query40	236	139	121	121
query41	69	66	63	63
query42	112	106	105	105
query43	432	417	398	398
query44	1307	751	748	748
query45	194	194	181	181
query46	879	985	607	607
query47	1689	1697	1630	1630
query48	314	326	243	243
query49	675	442	360	360
query50	675	304	229	229
query51	3884	3813	3803	3803
query52	105	107	101	101
query53	332	353	294	294
query54	291	263	260	260
query55	78	77	73	73
query56	298	304	287	287
query57	1132	1159	1089	1089
query58	276	259	253	253
query59	2417	2528	2392	2392
query60	322	318	290	290
query61	163	161	154	154
query62	697	658	637	637
query63	330	296	298	296
query64	4927	1304	1014	1014
query65	4051	3923	3955	3923
query66	1431	451	323	323
query67	15208	15155	14908	14908
query68	6492	1009	731	731
query69	498	350	319	319
query70	1115	1022	987	987
query71	357	310	293	293
query72	6040	4889	5014	4889
query73	652	558	312	312
query74	8927	8925	8618	8618
query75	3560	3545	3207	3207
query76	3910	1147	774	774
query77	527	385	302	302
query78	9467	9650	8796	8796
query79	1149	883	597	597
query80	971	646	543	543
query81	520	276	241	241
query82	409	136	103	103
query83	271	263	242	242
query84	260	126	99	99
query85	890	529	465	465
query86	345	303	282	282
query87	4134	4144	3975	3975
query88	3194	2280	2282	2280
query89	460	428	398	398
query90	1946	161	154	154
query91	178	171	148	148
query92	70	68	65	65
query93	1135	898	556	556
query94	567	303	270	270
query95	578	392	337	337
query96	615	459	209	209
query97	2590	2681	2602	2602
query98	217	193	204	193
query99	1282	1325	1203	1203
Total cold run time: 262081 ms
Total hot run time: 181614 ms

doris-robot · 2025-12-30T12:09:58Z

BE UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.37% (18951/35508)
Line Coverage	39.26% (175895/448082)
Region Coverage	33.83% (136172/402470)
Branch Coverage	34.76% (58801/169156)

hello-stephen · 2025-12-30T15:26:48Z

BE Regression && UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	72.15% (25045/34713)
Line Coverage	58.88% (263139/446897)
Region Coverage	53.75% (218566/406608)
Branch Coverage	55.29% (93834/169718)

hello-stephen · 2025-12-30T15:39:33Z

FE Regression Coverage Report

Increment line coverage 49.48% (238/481) 🎉
Increment coverage report
Complete coverage report

Ryan19929 · 2025-12-31T07:29:06Z

run buildall

hello-stephen · 2025-12-31T08:13:03Z

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	79.52% (1774/2231)
Line Coverage	64.81% (31409/48466)
Region Coverage	65.37% (15625/23901)
Branch Coverage	56.05% (8320/14844)

doris-robot · 2025-12-31T09:41:41Z

TPC-H: Total hot run time: 34348 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 10f96ac95da82309e044bb29b7d385d3ec6dc5da, data reload: false

------ Round 1 ----------------------------------
q1	17643	4305	4066	4066
q2	2038	377	235	235
q3	10467	1310	746	746
q4	10349	836	316	316
q5	9399	2135	1896	1896
q6	205	171	137	137
q7	948	801	666	666
q8	9282	1423	1118	1118
q9	6888	5180	5137	5137
q10	6841	1811	1410	1410
q11	504	323	289	289
q12	755	758	625	625
q13	17839	3855	3128	3128
q14	298	298	272	272
q15	583	518	501	501
q16	686	681	637	637
q17	714	735	608	608
q18	7991	7512	7271	7271
q19	1111	981	631	631
q20	412	371	248	248
q21	4287	3912	3438	3438
q22	1066	1049	973	973
Total cold run time: 110306 ms
Total hot run time: 34348 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4142	4011	4068	4011
q2	316	393	308	308
q3	2109	2610	2252	2252
q4	1360	1769	1321	1321
q5	4139	4734	4603	4603
q6	224	181	132	132
q7	1944	1960	1784	1784
q8	2523	2364	2319	2319
q9	7116	7215	7354	7215
q10	2502	2675	2256	2256
q11	552	493	461	461
q12	713	898	607	607
q13	3580	4250	3497	3497
q14	293	297	284	284
q15	544	511	499	499
q16	702	675	621	621
q17	1169	1343	1327	1327
q18	8018	7719	7991	7719
q19	911	931	950	931
q20	2035	2046	1909	1909
q21	4748	4232	4085	4085
q22	1075	1039	980	980
Total cold run time: 50715 ms
Total hot run time: 49121 ms

doris-robot · 2025-12-31T09:52:28Z

TPC-DS: Total hot run time: 174426 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 10f96ac95da82309e044bb29b7d385d3ec6dc5da, data reload: false

query5	4756	609	448	448
query6	336	230	212	212
query7	4212	460	270	270
query8	340	243	232	232
query9	8759	2594	2648	2594
query10	535	378	320	320
query11	15440	15057	14805	14805
query12	182	116	116	116
query13	1270	521	379	379
query14	6110	2973	2722	2722
query14_1	2578	2579	2613	2579
query15	211	192	170	170
query16	983	467	450	450
query17	1057	667	571	571
query18	2442	431	330	330
query19	224	215	188	188
query20	135	123	116	116
query21	219	138	119	119
query22	3952	3938	3957	3938
query23	15961	15513	15229	15229
query23_1	15350	15361	15462	15361
query24	7390	1582	1204	1204
query24_1	1227	1198	1200	1198
query25	540	440	407	407
query26	1250	265	155	155
query27	2766	444	295	295
query28	4599	2193	2186	2186
query29	781	519	458	458
query30	310	240	211	211
query31	849	642	548	548
query32	75	80	64	64
query33	519	338	279	279
query34	921	904	527	527
query35	775	784	689	689
query36	869	886	815	815
query37	125	93	77	77
query38	2838	2735	2689	2689
query39	766	755	727	727
query39_1	716	706	727	706
query40	217	135	114	114
query41	67	61	62	61
query42	105	102	101	101
query43	443	468	385	385
query44	1369	771	749	749
query45	185	184	177	177
query46	874	984	612	612
query47	1412	1423	1347	1347
query48	320	327	245	245
query49	615	426	315	315
query50	646	291	218	218
query51	3749	3746	3792	3746
query52	106	103	98	98
query53	287	322	269	269
query54	278	256	243	243
query55	79	78	70	70
query56	280	292	285	285
query57	1023	1010	947	947
query58	271	265	267	265
query59	2010	2179	2148	2148
query60	329	327	313	313
query61	192	189	184	184
query62	384	379	317	317
query63	302	269	275	269
query64	5139	1316	965	965
query65	3856	3707	3728	3707
query66	1423	413	310	310
query67	14967	15040	15608	15040
query68	2749	1050	753	753
query69	427	353	312	312
query70	990	912	978	912
query71	315	298	275	275
query72	6109	4849	5002	4849
query73	522	580	317	317
query74	8862	8855	8675	8675
query75	2851	2917	2511	2511
query76	2857	1057	658	658
query77	347	385	293	293
query78	9828	9973	9256	9256
query79	1108	935	609	609
query80	681	632	520	520
query81	493	268	228	228
query82	1338	145	116	116
query83	378	260	245	245
query84	267	120	107	107
query85	1030	511	473	473
query86	342	300	295	295
query87	2896	2847	2732	2732
query88	3361	2304	2305	2304
query89	396	345	320	320
query90	1869	156	154	154
query91	170	165	142	142
query92	72	65	62	62
query93	954	918	568	568
query94	447	333	285	285
query95	563	383	304	304
query96	600	467	208	208
query97	2339	2341	2243	2243
query98	215	206	198	198
query99	567	566	515	515
Total cold run time: 248142 ms
Total hot run time: 174426 ms

doris-robot · 2025-12-31T09:57:37Z

ClickBench: Total hot run time: 27.83 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 10f96ac95da82309e044bb29b7d385d3ec6dc5da, data reload: false

query1	0.06	0.05	0.05
query2	0.15	0.07	0.07
query3	0.35	0.08	0.08
query4	1.60	0.10	0.09
query5	0.25	0.25	0.25
query6	1.14	0.65	0.65
query7	0.04	0.03	0.02
query8	0.07	0.07	0.06
query9	0.59	0.50	0.50
query10	0.56	0.57	0.55
query11	0.28	0.15	0.14
query12	0.26	0.16	0.15
query13	0.64	0.62	0.60
query14	1.03	0.99	1.02
query15	0.89	0.82	0.82
query16	0.40	0.39	0.38
query17	1.05	1.02	1.04
query18	0.24	0.22	0.22
query19	1.86	1.88	1.81
query20	0.02	0.02	0.01
query21	15.38	0.28	0.23
query22	4.96	0.10	0.10
query23	15.40	0.41	0.23
query24	2.39	0.45	0.29
query25	0.10	0.10	0.09
query26	0.17	0.17	0.18
query27	0.10	0.09	0.10
query28	3.53	1.13	0.95
query29	12.54	4.00	3.26
query30	0.33	0.14	0.10
query31	2.82	0.65	0.42
query32	3.24	0.61	0.49
query33	3.05	3.09	3.01
query34	16.93	5.16	4.45
query35	4.47	4.55	4.49
query36	0.61	0.49	0.48
query37	0.24	0.09	0.09
query38	0.21	0.06	0.06
query39	0.07	0.05	0.04
query40	0.19	0.17	0.17
query41	0.12	0.06	0.06
query42	0.08	0.05	0.05
query43	0.06	0.05	0.05
Total cold run time: 98.47 s
Total hot run time: 27.83 s

hello-stephen · 2025-12-31T10:04:34Z

FE UT Coverage Report

Increment line coverage 50.90% (254/499) 🎉
Increment coverage report
Complete coverage report

hello-stephen · 2025-12-31T11:18:58Z

BE UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.38% (18955/35510)
Line Coverage	39.27% (175974/448104)
Region Coverage	33.82% (136106/402470)
Branch Coverage	34.77% (58821/169158)

hello-stephen · 2025-12-31T13:09:29Z

BE Regression && UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	73.87% (25643/34715)
Line Coverage	61.29% (273927/446912)
Region Coverage	56.02% (227788/406633)
Branch Coverage	58.03% (98481/169720)

hello-stephen · 2025-12-31T13:23:29Z

FE Regression Coverage Report

Increment line coverage 43.69% (218/499) 🎉
Increment coverage report
Complete coverage report

Ryan19929 · 2026-01-04T01:56:27Z

run buildall

doris-robot · 2026-01-04T03:54:50Z

TPC-H: Total hot run time: 32838 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ac95885053e50e4574a29755cc7639ac00780d1c, data reload: false

------ Round 1 ----------------------------------
q1	17678	4211	4042	4042
q2	2025	363	244	244
q3	10111	1329	758	758
q4	10210	828	339	339
q5	7525	2195	1924	1924
q6	193	173	142	142
q7	943	812	665	665
q8	9285	1449	1174	1174
q9	5595	4727	4873	4727
q10	6878	1796	1445	1445
q11	512	303	308	303
q12	734	727	581	581
q13	17800	3834	3151	3151
q14	290	301	276	276
q15	588	517	508	508
q16	733	673	646	646
q17	740	767	629	629
q18	6762	6399	7245	6399
q19	1421	1042	663	663
q20	446	382	268	268
q21	3468	2902	2873	2873
q22	1143	1120	1081	1081
Total cold run time: 105080 ms
Total hot run time: 32838 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4381	4282	4252	4252
q2	325	418	312	312
q3	2293	2790	2575	2575
q4	1424	1838	1449	1449
q5	4414	4316	4330	4316
q6	222	166	123	123
q7	2042	1984	1734	1734
q8	2750	2361	2348	2348
q9	6972	7167	7212	7167
q10	2511	2782	2300	2300
q11	570	454	469	454
q12	755	757	636	636
q13	3662	4075	3164	3164
q14	268	279	272	272
q15	533	497	492	492
q16	611	649	593	593
q17	1104	1335	1361	1335
q18	7372	7296	7095	7095
q19	861	838	914	838
q20	1928	1998	1815	1815
q21	4651	4306	4179	4179
q22	1098	1078	993	993
Total cold run time: 50747 ms
Total hot run time: 48442 ms

doris-robot · 2026-01-04T04:05:39Z

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

query5	4565	592	461	461
query6	344	237	209	209
query7	4213	469	273	273
query8	347	238	237	237
query9	8753	2621	2626	2621
query10	477	366	324	324
query11	15259	15199	14956	14956
query12	176	121	118	118
query13	1258	516	395	395
query14	6206	3080	2756	2756
query14_1	2707	2671	2691	2671
query15	204	202	178	178
query16	1003	418	470	418
query17	1109	703	609	609
query18	2457	435	339	339
query19	226	221	195	195
query20	123	115	114	114
query21	214	147	120	120
query22	3810	3883	3791	3791
query23	16033	15755	15314	15314
query23_1	15441	15426	15341	15341
query24	7483	1578	1213	1213
query24_1	1253	1218	1254	1218
query25	526	467	437	437
query26	1261	265	154	154
query27	2767	453	295	295
query28	4548	2218	2199	2199
query29	788	543	439	439
query30	314	240	218	218
query31	780	625	537	537
query32	76	78	77	77
query33	536	348	284	284
query34	914	942	557	557
query35	742	785	698	698
query36	855	871	845	845
query37	128	100	75	75
query38	2950	2655	2746	2655
query39	788	743	734	734
query39_1	710	724	724	724
query40	220	154	118	118
query41	68	67	63	63
query42	110	118	103	103
query43	428	479	457	457
query44	1352	765	759	759
query45	185	186	186	186
query46	895	978	626	626
query47	1387	1382	1398	1382
query48	320	346	245	245
query49	613	421	341	341
query50	656	294	212	212
query51	3780	3742	3755	3742
query52	104	110	98	98
query53	306	327	268	268
query54	291	253	257	253
query55	81	78	75	75
query56	290	288	298	288
query57	954	973	864	864
query58	263	251	250	250
query59	2142	2138	2148	2138
query60	338	317	297	297
query61	182	193	193	193
query62	397	364	312	312
query63	300	263	275	263
query64	5068	1439	1103	1103
query65	3764	3708	3611	3611
query66	1454	440	332	332
query67	15258	14860	15208	14860
query68	5178	1050	743	743
query69	504	361	330	330
query70	1088	973	848	848
query71	370	309	282	282
query72	6159	3500	3484	3484
query73	780	745	317	317
query74	8742	8767	8565	8565
query75	2842	2830	2520	2520
query76	3904	1088	672	672
query77	526	388	274	274
query78	9728	9885	9176	9176
query79	1781	872	610	610
query80	1539	603	494	494
query81	548	267	231	231
query82	410	144	109	109
query83	354	258	245	245
query84	254	120	104	104
query85	907	510	482	482
query86	392	334	315	315
query87	2839	2853	2744	2744
query88	3285	2305	2329	2305
query89	400	349	341	341
query90	1947	167	150	150
query91	175	170	138	138
query92	72	69	69	69
query93	1170	909	573	573
query94	632	330	288	288
query95	586	387	306	306
query96	599	478	209	209
query97	2369	2344	2295	2295
query98	235	210	201	201
query99	561	579	495	495
Total cold run time: 253295 ms
Total hot run time: 173284 ms

doris-robot · 2026-01-04T04:10:50Z

ClickBench: Total hot run time: 27.47 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit ac95885053e50e4574a29755cc7639ac00780d1c, data reload: false

query1	0.06	0.04	0.04
query2	0.11	0.05	0.04
query3	0.26	0.09	0.09
query4	1.61	0.12	0.11
query5	0.28	0.26	0.26
query6	1.15	0.67	0.65
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.57	0.49	0.49
query10	0.56	0.54	0.55
query11	0.16	0.11	0.12
query12	0.16	0.12	0.12
query13	0.61	0.60	0.60
query14	1.00	0.98	0.99
query15	0.82	0.79	0.82
query16	0.40	0.41	0.42
query17	1.02	1.05	1.04
query18	0.23	0.21	0.20
query19	1.92	1.88	1.80
query20	0.02	0.02	0.02
query21	15.44	0.31	0.15
query22	4.55	0.05	0.04
query23	15.88	0.29	0.10
query24	2.11	0.28	0.64
query25	0.12	0.06	0.05
query26	0.14	0.14	0.14
query27	0.08	0.06	0.05
query28	5.75	1.03	0.88
query29	12.59	3.96	3.12
query30	0.27	0.14	0.13
query31	2.81	0.62	0.38
query32	3.23	0.56	0.47
query33	2.99	3.05	3.04
query34	16.62	5.18	4.49
query35	4.48	4.90	5.01
query36	0.70	0.57	0.55
query37	0.10	0.06	0.06
query38	0.07	0.04	0.04
query39	0.04	0.02	0.02
query40	0.18	0.15	0.14
query41	0.08	0.03	0.04
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 99.33 s
Total hot run time: 27.47 s

hello-stephen · 2026-01-04T05:46:05Z

BE UT Coverage Report

Increment line coverage 100.00% (30/30) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.43% (18978/35518)
Line Coverage	39.29% (176107/448189)
Region Coverage	33.83% (136190/402518)
Branch Coverage	34.79% (58864/169180)

Ryan19929 · 2026-01-05T00:40:10Z

run feut

hello-stephen · 2026-01-05T01:50:24Z

FE UT Coverage Report

Increment line coverage 53.31% (266/499) 🎉
Increment coverage report
Complete coverage report

Ryan19929 · 2026-01-05T02:48:47Z

run compile

jmgarcia1230-commits · 2026-01-05T07:32:55Z

i need all data and scripts related to the hone number 469-907-7212 this was done to mi acount eith out my consent

hello-stephen · 2026-01-05T08:20:40Z

FE Regression Coverage Report

Increment line coverage 43.49% (217/499) 🎉
Increment coverage report
Complete coverage report

Ryan19929 · 2026-01-06T01:46:22Z

run compile

hello-stephen · 2026-01-06T06:03:09Z

FE Regression Coverage Report

Increment line coverage 46.89% (234/499) 🎉
Increment coverage report
Complete coverage report

Ryan19929 requested review from CalvinKirs, dataroaring, gavinchou, morningman and w41ter as code owners December 10, 2025 07:47

Ryan19929 force-pushed the enhance-medium-control branch from 792260b to 2c30e08 Compare December 12, 2025 00:57

udpate test

10f96ac

Ryan19929 force-pushed the enhance-medium-control branch 2 times, most recently from 3a24098 to dc1107f Compare January 4, 2026 13:52

Ryan19929 force-pushed the enhance-medium-control branch from dc1107f to 68a5fd7 Compare January 6, 2026 01:43

2026_update1

79525bf

Ryan19929 force-pushed the enhance-medium-control branch from 68a5fd7 to 79525bf Compare January 6, 2026 05:58

[feat](restore): enhance storage medium control #58897

Are you sure you want to change the base?

[feat](restore): enhance storage medium control #58897

Uh oh!

Conversation

Ryan19929 commented Dec 10, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

What problem does this PR solve?

Background

Solution

Main Changes

Legacy Table Compatibility

Usage Examples

Release note

Check List (For Author)

Check List (For Reviewer who merge this PR)

Uh oh!

Ryan19929 commented Dec 10, 2025

Uh oh!

hello-stephen commented Dec 10, 2025

Cloud UT Coverage Report

Uh oh!

hello-stephen commented Dec 10, 2025

FE UT Coverage Report

Uh oh!

doris-robot commented Dec 10, 2025

Uh oh!

doris-robot commented Dec 10, 2025

Uh oh!

doris-robot commented Dec 10, 2025

Uh oh!

doris-robot commented Dec 10, 2025

BE UT Coverage Report

Uh oh!

hello-stephen commented Dec 10, 2025

BE Regression && UT Coverage Report

Uh oh!

hello-stephen commented Dec 10, 2025

FE Regression Coverage Report

Uh oh!

Ryan19929 commented Dec 11, 2025

Uh oh!

Ryan19929 commented Dec 11, 2025

Uh oh!

Ryan19929 commented Dec 11, 2025

Uh oh!

hello-stephen commented Dec 11, 2025

Cloud UT Coverage Report

Uh oh!

hello-stephen commented Dec 11, 2025

FE UT Coverage Report

Uh oh!

doris-robot commented Dec 11, 2025

Uh oh!

doris-robot commented Dec 11, 2025

Uh oh!

doris-robot commented Dec 11, 2025

Uh oh!

hello-stephen commented Dec 11, 2025

BE UT Coverage Report

Uh oh!

hello-stephen commented Dec 11, 2025

BE Regression && UT Coverage Report

Uh oh!

hello-stephen commented Dec 11, 2025

FE Regression Coverage Report

Uh oh!

Ryan19929 commented Dec 12, 2025

Uh oh!

hello-stephen commented Dec 12, 2025

Cloud UT Coverage Report

Uh oh!

doris-robot commented Dec 12, 2025

Uh oh!

doris-robot commented Dec 12, 2025

Uh oh!

doris-robot commented Dec 30, 2025

BE UT Coverage Report

Uh oh!

hello-stephen commented Dec 30, 2025

Ryan19929 commented Dec 10, 2025 •

edited

Loading