Skip to content

[improve](table_properties) make replication_allocation property same as show create table #51561

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

Open
wants to merge 2 commits into
base: master
Choose a base branch
from

Conversation

cambyzju
Copy link
Contributor

@cambyzju cambyzju commented Jun 6, 2025

What problem does this PR solve?

Doris has lots of location properties, such as:

replication_allocation, 
default.replication_num, 
default.replication_allocation, 
dyanamic_partition.replication_allocation, 
dyanamic_partition.replication_num, 

But we cannot find a correct property the same Show Create Table.

Here we add replication_allocation and dyanamic_partition.replication_allocation properties in table: information_schema.table_properties

Problem Summary:

Release note

None

Check List (For Author)

  • Test

    • Regression test
    • Unit Test
    • Manual test (add detailed scripts or steps below)
    • No need to test or manual test. Explain why:
      • This is a refactor/code format and no logic has been changed.
      • Previous test can cover this change.
      • No code files have been changed.
      • Other reason
  • Behavior changed:

    • No.
    • Yes.
  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

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

@hello-stephen
Copy link
Contributor

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR.

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

@cambyzju
Copy link
Contributor Author

cambyzju commented Jun 6, 2025

run buildall

@cambyzju cambyzju force-pushed the improve-master-0606 branch from 83fca07 to 9c3b089 Compare June 9, 2025 02:06
@cambyzju
Copy link
Contributor Author

cambyzju commented Jun 9, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25925	5040	4995	4995
q2	1950	293	186	186
q3	10289	1259	739	739
q4	10742	999	558	558
q5	7538	2380	2331	2331
q6	184	168	138	138
q7	924	730	615	615
q8	9319	1291	1100	1100
q9	6768	5065	5107	5065
q10	6868	2290	1896	1896
q11	498	301	297	297
q12	350	352	219	219
q13	18099	3764	3071	3071
q14	241	247	209	209
q15	569	485	490	485
q16	421	432	374	374
q17	599	862	366	366
q18	7477	7234	7159	7159
q19	1758	982	563	563
q20	344	344	221	221
q21	3785	3168	2386	2386
q22	1034	1053	977	977
Total cold run time: 115682 ms
Total hot run time: 33950 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5186	5022	5107	5022
q2	238	318	217	217
q3	2137	2627	2263	2263
q4	1398	1788	1371	1371
q5	4474	4407	4391	4391
q6	215	168	126	126
q7	2014	1928	1749	1749
q8	2584	2646	2524	2524
q9	7215	7233	6984	6984
q10	3053	3191	2794	2794
q11	595	535	497	497
q12	672	788	635	635
q13	3628	3989	3316	3316
q14	284	327	290	290
q15	561	486	493	486
q16	451	490	449	449
q17	1189	1607	1325	1325
q18	7784	7631	7446	7446
q19	826	812	881	812
q20	2050	1983	1818	1818
q21	4951	4562	4580	4562
q22	1098	1065	1069	1065
Total cold run time: 52603 ms
Total hot run time: 50142 ms

@cambyzju cambyzju force-pushed the improve-master-0606 branch from 9c3b089 to b7fe422 Compare June 9, 2025 02:36
@cambyzju
Copy link
Contributor Author

cambyzju commented Jun 9, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	26404	5048	5145	5048
q2	1946	287	198	198
q3	10278	1258	698	698
q4	10238	1007	536	536
q5	7489	2476	2408	2408
q6	187	179	139	139
q7	928	759	651	651
q8	9325	1328	1133	1133
q9	6784	5218	5071	5071
q10	6888	2329	1951	1951
q11	514	294	280	280
q12	345	359	217	217
q13	17785	3680	3106	3106
q14	233	228	210	210
q15	558	509	492	492
q16	431	434	374	374
q17	608	867	383	383
q18	7515	7158	7111	7111
q19	1212	968	602	602
q20	357	346	231	231
q21	3981	3224	2418	2418
q22	1050	1048	1015	1015
Total cold run time: 115056 ms
Total hot run time: 34272 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5089	5049	5072	5049
q2	240	316	229	229
q3	2176	2677	2336	2336
q4	1413	1840	1355	1355
q5	4267	4113	4133	4113
q6	209	167	128	128
q7	1884	1835	1671	1671
q8	2498	2490	2413	2413
q9	6816	6770	6795	6770
q10	2906	3114	2668	2668
q11	579	515	496	496
q12	646	727	601	601
q13	3420	3779	3197	3197
q14	292	277	255	255
q15	533	499	490	490
q16	426	492	448	448
q17	1113	1543	1310	1310
q18	7345	7059	7083	7059
q19	824	832	989	832
q20	1928	2009	1850	1850
q21	4734	4295	4349	4295
q22	1112	1063	1002	1002
Total cold run time: 50450 ms
Total hot run time: 48567 ms

@doris-robot
Copy link

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

query1	1041	475	513	475
query2	6426	1843	1809	1809
query3	6038	234	233	233
query4	26127	23163	23070	23070
query5	4341	633	451	451
query6	284	209	204	204
query7	3155	505	297	297
query8	254	228	215	215
query9	6546	2609	2626	2609
query10	432	340	294	294
query11	15099	15003	14792	14792
query12	156	103	103	103
query13	1014	524	392	392
query14	8831	6070	6247	6070
query15	202	203	173	173
query16	7337	623	490	490
query17	1196	714	591	591
query18	1987	412	317	317
query19	205	194	170	170
query20	120	122	120	120
query21	220	130	114	114
query22	3979	4188	3985	3985
query23	34063	33102	33037	33037
query24	9215	2439	2414	2414
query25	573	484	417	417
query26	1253	274	155	155
query27	2748	515	343	343
query28	4565	2143	2111	2111
query29	814	576	420	420
query30	299	219	194	194
query31	926	837	744	744
query32	70	62	63	62
query33	582	360	310	310
query34	806	869	529	529
query35	784	801	706	706
query36	938	961	859	859
query37	110	99	74	74
query38	4084	4255	4013	4013
query39	1451	1470	1426	1426
query40	219	126	109	109
query41	63	60	59	59
query42	127	107	106	106
query43	494	482	479	479
query44	1338	834	838	834
query45	175	170	165	165
query46	852	1025	621	621
query47	1758	1783	1745	1745
query48	388	427	308	308
query49	757	502	401	401
query50	648	693	412	412
query51	4173	4205	4132	4132
query52	110	111	104	104
query53	230	261	183	183
query54	574	578	513	513
query55	88	84	83	83
query56	303	296	298	296
query57	1145	1150	1081	1081
query58	266	271	253	253
query59	2656	2581	2563	2563
query60	335	330	340	330
query61	126	149	135	135
query62	791	715	646	646
query63	224	187	190	187
query64	4471	1007	717	717
query65	4232	4153	4167	4153
query66	1159	415	311	311
query67	15872	15717	15654	15654
query68	9141	904	535	535
query69	468	301	272	272
query70	1230	1127	1071	1071
query71	470	336	316	316
query72	5566	4690	4799	4690
query73	689	621	351	351
query74	8869	9024	9091	9024
query75	4165	3204	2745	2745
query76	3668	1203	768	768
query77	932	447	288	288
query78	9978	10126	9322	9322
query79	5938	824	563	563
query80	655	514	446	446
query81	545	258	228	228
query82	393	124	96	96
query83	289	246	237	237
query84	297	125	97	97
query85	759	355	310	310
query86	331	303	296	296
query87	4533	4357	4376	4357
query88	2878	2320	2275	2275
query89	440	306	320	306
query90	2036	218	213	213
query91	143	138	113	113
query92	82	61	66	61
query93	3496	967	587	587
query94	667	433	318	318
query95	380	298	287	287
query96	490	599	283	283
query97	2763	2754	2632	2632
query98	232	209	202	202
query99	1412	1415	1276	1276
Total cold run time: 275780 ms
Total hot run time: 185933 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.04
query2	0.13	0.11	0.11
query3	0.26	0.19	0.20
query4	1.60	0.19	0.20
query5	0.46	0.45	0.44
query6	1.16	0.67	0.64
query7	0.03	0.02	0.02
query8	0.05	0.03	0.04
query9	0.59	0.52	0.51
query10	0.58	0.60	0.56
query11	0.17	0.11	0.11
query12	0.15	0.11	0.12
query13	0.61	0.61	0.60
query14	0.79	0.81	0.81
query15	0.88	0.86	0.88
query16	0.38	0.40	0.36
query17	1.01	1.05	1.05
query18	0.23	0.22	0.22
query19	1.90	1.86	1.86
query20	0.01	0.02	0.01
query21	15.39	0.93	0.54
query22	0.76	1.19	0.63
query23	14.96	1.39	0.65
query24	6.73	1.17	0.99
query25	0.46	0.24	0.17
query26	0.62	0.16	0.14
query27	0.05	0.05	0.05
query28	9.36	0.92	0.43
query29	12.54	4.12	3.43
query30	0.25	0.08	0.06
query31	2.83	0.59	0.38
query32	3.22	0.56	0.47
query33	3.13	3.01	3.12
query34	15.69	5.12	4.48
query35	4.51	4.59	4.53
query36	0.67	0.51	0.50
query37	0.08	0.06	0.07
query38	0.05	0.04	0.03
query39	0.03	0.03	0.02
query40	0.17	0.14	0.14
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 102.68 s
Total hot run time: 29.49 s

@cambyzju cambyzju force-pushed the improve-master-0606 branch from b7fe422 to 29c4471 Compare June 9, 2025 06:27
@cambyzju
Copy link
Contributor Author

cambyzju commented Jun 9, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25687	5076	5015	5015
q2	1965	267	180	180
q3	10280	1207	680	680
q4	10231	1006	521	521
q5	7507	2339	2291	2291
q6	185	165	134	134
q7	872	726	615	615
q8	9297	1209	981	981
q9	6794	5067	5088	5067
q10	7024	2385	1949	1949
q11	496	293	270	270
q12	359	362	221	221
q13	17817	3671	3091	3091
q14	225	232	209	209
q15	590	496	494	494
q16	431	426	364	364
q17	586	834	350	350
q18	7511	7239	7176	7176
q19	1665	939	539	539
q20	329	329	212	212
q21	3715	2531	2292	2292
q22	1043	1029	975	975
Total cold run time: 114609 ms
Total hot run time: 33626 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5158	5066	5059	5059
q2	236	312	223	223
q3	2149	2594	2305	2305
q4	1350	1799	1341	1341
q5	4350	4336	4379	4336
q6	213	172	129	129
q7	2015	1933	1745	1745
q8	2583	2552	2516	2516
q9	7172	7090	7062	7062
q10	2965	3222	2751	2751
q11	589	507	502	502
q12	676	737	584	584
q13	3525	3894	3248	3248
q14	293	301	264	264
q15	545	488	485	485
q16	456	492	461	461
q17	1158	1459	1380	1380
q18	7738	7570	7404	7404
q19	789	777	897	777
q20	1997	2113	1867	1867
q21	4866	4607	4470	4470
q22	1111	1077	1030	1030
Total cold run time: 51934 ms
Total hot run time: 49939 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192976 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 29c447110f62e7faf9ef5dc9f7e8ba052f525e5d, data reload: false

query1	1413	1081	1046	1046
query2	6288	1830	1813	1813
query3	11146	4621	4624	4621
query4	52460	25160	23252	23252
query5	5125	558	472	472
query6	330	189	183	183
query7	4864	493	286	286
query8	282	222	210	210
query9	5446	2613	2635	2613
query10	429	349	286	286
query11	15113	15001	15130	15001
query12	159	106	109	106
query13	1029	521	415	415
query14	10172	6534	6502	6502
query15	198	195	178	178
query16	7082	656	517	517
query17	1083	738	609	609
query18	1561	421	312	312
query19	200	195	159	159
query20	124	124	130	124
query21	208	128	105	105
query22	4308	4442	4165	4165
query23	34340	33739	33591	33591
query24	6549	2435	2418	2418
query25	455	499	399	399
query26	732	273	155	155
query27	2317	515	344	344
query28	3184	2160	2167	2160
query29	592	581	430	430
query30	273	220	190	190
query31	879	874	781	781
query32	73	65	59	59
query33	454	367	303	303
query34	779	871	546	546
query35	797	812	737	737
query36	939	1005	906	906
query37	124	97	75	75
query38	4187	4275	4276	4275
query39	1506	1447	1474	1447
query40	215	125	103	103
query41	62	63	60	60
query42	127	112	116	112
query43	518	516	470	470
query44	1341	859	875	859
query45	188	173	168	168
query46	867	1026	652	652
query47	1819	1858	1781	1781
query48	389	420	318	318
query49	657	467	388	388
query50	677	704	418	418
query51	4277	4256	4221	4221
query52	120	107	97	97
query53	225	257	186	186
query54	592	565	520	520
query55	90	84	84	84
query56	330	313	292	292
query57	1175	1217	1171	1171
query58	275	264	265	264
query59	2698	2856	2669	2669
query60	333	333	338	333
query61	121	125	135	125
query62	752	751	688	688
query63	228	195	196	195
query64	1618	1139	807	807
query65	4252	4155	4120	4120
query66	726	398	299	299
query67	15910	15723	15586	15586
query68	7065	897	532	532
query69	545	304	269	269
query70	1211	1067	1081	1067
query71	502	310	310	310
query72	5887	4880	4999	4880
query73	1518	694	360	360
query74	8954	9173	8676	8676
query75	3936	3203	2656	2656
query76	4230	1177	821	821
query77	660	365	295	295
query78	10105	10068	9315	9315
query79	3501	822	565	565
query80	646	498	439	439
query81	491	255	223	223
query82	486	122	95	95
query83	317	253	236	236
query84	297	119	87	87
query85	855	340	317	317
query86	392	313	294	294
query87	4464	4409	4204	4204
query88	3644	2332	2284	2284
query89	437	317	283	283
query90	1916	210	216	210
query91	140	141	114	114
query92	79	60	67	60
query93	2891	927	588	588
query94	651	412	307	307
query95	366	286	293	286
query96	490	569	282	282
query97	2741	2740	2660	2660
query98	224	204	233	204
query99	1461	1446	1280	1280
Total cold run time: 298884 ms
Total hot run time: 192976 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.04
query2	0.12	0.11	0.11
query3	0.24	0.19	0.20
query4	1.59	0.19	0.20
query5	0.47	0.43	0.43
query6	1.19	0.66	0.65
query7	0.02	0.02	0.01
query8	0.05	0.04	0.04
query9	0.57	0.52	0.51
query10	0.57	0.60	0.57
query11	0.15	0.11	0.11
query12	0.14	0.12	0.11
query13	0.60	0.60	0.60
query14	0.79	0.81	0.80
query15	0.88	0.86	0.88
query16	0.37	0.38	0.38
query17	1.05	1.06	1.06
query18	0.23	0.21	0.21
query19	1.92	1.84	1.86
query20	0.02	0.01	0.01
query21	15.40	0.91	0.53
query22	0.76	1.30	0.72
query23	14.75	1.36	0.65
query24	7.16	1.09	1.24
query25	0.50	0.30	0.20
query26	0.57	0.16	0.13
query27	0.06	0.04	0.05
query28	10.28	0.83	0.44
query29	12.56	4.12	3.45
query30	0.27	0.09	0.07
query31	2.84	0.60	0.39
query32	3.23	0.55	0.47
query33	2.95	3.07	3.07
query34	15.74	5.15	4.52
query35	4.54	4.56	4.55
query36	0.67	0.51	0.48
query37	0.08	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.16	0.14	0.13
query41	0.08	0.02	0.02
query42	0.03	0.03	0.02
query43	0.04	0.03	0.02
Total cold run time: 103.76 s
Total hot run time: 29.83 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 0.00% (0/8) 🎉
Increment coverage report
Complete coverage report

@cambyzju
Copy link
Contributor Author

cambyzju commented Jun 9, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	25846	4996	4951	4951
q2	1940	264	187	187
q3	10296	1209	682	682
q4	10223	982	511	511
q5	7527	2308	2270	2270
q6	183	162	131	131
q7	892	722	625	625
q8	9307	1273	1029	1029
q9	6744	5054	5090	5054
q10	7061	2301	1884	1884
q11	481	290	273	273
q12	341	338	214	214
q13	17806	3602	3078	3078
q14	232	229	229	229
q15	572	500	473	473
q16	416	440	381	381
q17	585	844	363	363
q18	7436	7070	7146	7070
q19	1611	952	543	543
q20	340	331	225	225
q21	3640	3142	2346	2346
q22	1044	1018	970	970
Total cold run time: 114523 ms
Total hot run time: 33489 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5117	5004	5051	5004
q2	232	324	226	226
q3	2117	2652	2298	2298
q4	1332	1739	1349	1349
q5	4316	4324	4371	4324
q6	217	170	128	128
q7	1977	1922	1767	1767
q8	2550	2626	2518	2518
q9	7129	7158	7034	7034
q10	2948	3227	2790	2790
q11	593	517	503	503
q12	678	748	628	628
q13	3442	3809	3241	3241
q14	280	303	272	272
q15	518	473	484	473
q16	451	493	438	438
q17	1147	1486	1362	1362
q18	7820	7528	7357	7357
q19	802	846	918	846
q20	2020	2048	1938	1938
q21	4766	4453	4514	4453
q22	1106	1053	1019	1019
Total cold run time: 51558 ms
Total hot run time: 49968 ms

@doris-robot
Copy link

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

query1	1416	1084	1064	1064
query2	6473	1847	1851	1847
query3	10982	4477	4400	4400
query4	54594	25838	23670	23670
query5	5102	519	453	453
query6	320	207	211	207
query7	4879	488	288	288
query8	294	234	219	219
query9	5754	2632	2629	2629
query10	452	333	277	277
query11	15075	14982	14828	14828
query12	159	107	106	106
query13	1041	514	416	416
query14	10332	6335	6283	6283
query15	203	196	198	196
query16	7051	652	479	479
query17	1089	737	636	636
query18	1560	435	329	329
query19	205	216	181	181
query20	129	123	131	123
query21	210	125	110	110
query22	4243	4357	4304	4304
query23	34317	33325	33355	33325
query24	6558	2458	2395	2395
query25	455	458	414	414
query26	751	276	153	153
query27	2360	510	349	349
query28	2860	2191	2157	2157
query29	583	568	447	447
query30	272	219	203	203
query31	854	866	790	790
query32	73	62	64	62
query33	449	348	304	304
query34	797	865	532	532
query35	776	810	778	778
query36	917	988	911	911
query37	111	111	78	78
query38	4291	4265	4277	4265
query39	1496	1473	1441	1441
query40	232	118	105	105
query41	64	64	62	62
query42	123	113	105	105
query43	514	543	485	485
query44	1310	849	838	838
query45	178	170	168	168
query46	850	1048	667	667
query47	1839	1871	1797	1797
query48	391	410	330	330
query49	651	480	402	402
query50	658	693	415	415
query51	4192	4363	4188	4188
query52	108	108	102	102
query53	234	254	190	190
query54	595	591	529	529
query55	91	88	87	87
query56	299	297	293	293
query57	1199	1239	1143	1143
query58	271	263	265	263
query59	2696	2848	2710	2710
query60	322	328	305	305
query61	129	126	123	123
query62	749	828	685	685
query63	231	191	191	191
query64	1794	1047	709	709
query65	4256	4173	4145	4145
query66	722	394	306	306
query67	16074	15662	15354	15354
query68	7133	879	531	531
query69	535	302	273	273
query70	1195	1117	1070	1070
query71	514	326	293	293
query72	5874	4765	5003	4765
query73	1424	658	363	363
query74	8902	9220	8997	8997
query75	3815	3182	2719	2719
query76	4284	1287	757	757
query77	643	365	283	283
query78	10137	10013	9304	9304
query79	3402	796	577	577
query80	645	520	463	463
query81	479	257	231	231
query82	488	123	99	99
query83	345	244	236	236
query84	293	109	82	82
query85	794	398	312	312
query86	381	306	297	297
query87	4400	4463	4324	4324
query88	3522	2321	2288	2288
query89	410	309	286	286
query90	1909	210	208	208
query91	137	144	110	110
query92	71	63	59	59
query93	2434	942	581	581
query94	664	420	302	302
query95	367	303	292	292
query96	494	562	277	277
query97	2763	2719	2675	2675
query98	232	198	202	198
query99	1436	1422	1272	1272
Total cold run time: 300377 ms
Total hot run time: 192870 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 cbb4d2dbbbc9eb4d34a11830cf4110338db418f3, data reload: false

query1	0.03	0.04	0.03
query2	0.12	0.11	0.12
query3	0.26	0.19	0.20
query4	1.59	0.20	0.21
query5	0.45	0.46	0.46
query6	1.19	0.67	0.66
query7	0.02	0.02	0.01
query8	0.05	0.04	0.04
query9	0.59	0.52	0.52
query10	0.57	0.58	0.56
query11	0.16	0.11	0.10
query12	0.15	0.11	0.11
query13	0.62	0.62	0.60
query14	0.79	0.82	0.82
query15	0.88	0.86	0.86
query16	0.38	0.40	0.39
query17	1.01	1.06	1.03
query18	0.23	0.21	0.21
query19	1.89	1.78	1.83
query20	0.01	0.01	0.01
query21	15.39	0.88	0.53
query22	0.76	1.15	0.70
query23	14.94	1.39	0.64
query24	6.80	1.98	1.01
query25	0.49	0.31	0.06
query26	0.56	0.16	0.15
query27	0.06	0.05	0.04
query28	9.51	0.85	0.45
query29	12.54	4.04	3.42
query30	0.25	0.09	0.06
query31	2.83	0.59	0.40
query32	3.23	0.55	0.47
query33	3.04	3.10	3.07
query34	15.83	5.11	4.46
query35	4.49	4.52	4.48
query36	0.65	0.49	0.48
query37	0.09	0.06	0.07
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.16	0.13	0.14
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.03	0.04	0.03
Total cold run time: 102.83 s
Total hot run time: 29.43 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 0.00% (0/8) 🎉
Increment coverage report
Complete coverage report

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants