doris icon indicating copy to clipboard operation
doris copied to clipboard

[clear](fe) update minimum meta version required to 140

Open morrySnow opened this issue 6 months ago • 24 comments

What problem does this PR solve?

  • Update minimum meta version required to 140
  • Remove the readFields, read, and write methods used for compatibility with meta versions earlier than 140.

Release note

None

Check List (For Author)

  • Test

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

    • [x] No.
    • [ ] Yes.
  • Does this need documentation?

    • [x] No.
    • [ ] Yes.

Check List (For Reviewer who merge this PR)

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

morrySnow avatar Jun 05 '25 10:06 morrySnow

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?

Thearas avatar Jun 05 '25 10:06 Thearas

run buildall

morrySnow avatar Jun 05 '25 10:06 morrySnow

run buildall

morrySnow avatar Jun 05 '25 10:06 morrySnow

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

------ Round 1 ----------------------------------
q1	26082	5140	5020	5020
q2	1980	281	185	185
q3	10615	1281	709	709
q4	10277	1018	541	541
q5	8635	2423	2321	2321
q6	181	163	135	135
q7	906	738	609	609
q8	9309	1278	1113	1113
q9	6801	5111	5093	5093
q10	6847	2320	1906	1906
q11	482	292	280	280
q12	350	350	220	220
q13	17763	3697	3170	3170
q14	225	231	218	218
q15	570	485	474	474
q16	435	429	373	373
q17	600	850	365	365
q18	7669	7123	7082	7082
q19	1775	984	575	575
q20	331	331	221	221
q21	3874	3197	2435	2435
q22	1067	1031	957	957
Total cold run time: 116774 ms
Total hot run time: 34002 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5171	5088	5062	5062
q2	238	318	221	221
q3	2165	2634	2265	2265
q4	1329	1769	1475	1475
q5	4518	4456	4361	4361
q6	210	172	124	124
q7	1919	1883	1767	1767
q8	2594	2488	2388	2388
q9	7059	7142	7049	7049
q10	3000	3151	2718	2718
q11	597	530	474	474
q12	697	739	623	623
q13	3518	3898	3306	3306
q14	288	302	273	273
q15	514	473	467	467
q16	445	491	458	458
q17	1195	1489	1392	1392
q18	7531	7461	7477	7461
q19	825	846	971	846
q20	1998	2025	1837	1837
q21	4855	4431	4303	4303
q22	1068	1040	1019	1019
Total cold run time: 51734 ms
Total hot run time: 49889 ms

doris-robot avatar Jun 05 '25 11:06 doris-robot

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

query1	998	484	528	484
query2	6594	1822	1799	1799
query3	6750	228	229	228
query4	25895	23801	23037	23037
query5	4327	610	476	476
query6	316	222	202	202
query7	4629	486	298	298
query8	280	228	210	210
query9	8646	2644	2663	2644
query10	498	352	277	277
query11	15413	15346	15006	15006
query12	193	104	108	104
query13	1645	507	398	398
query14	10024	6308	6222	6222
query15	198	208	163	163
query16	7639	611	489	489
query17	1277	764	561	561
query18	2015	394	296	296
query19	185	176	161	161
query20	118	121	116	116
query21	212	118	108	108
query22	4017	4059	4042	4042
query23	34072	33197	33149	33149
query24	8366	2360	2520	2360
query25	524	449	386	386
query26	1227	268	148	148
query27	2778	500	338	338
query28	4289	2127	2127	2127
query29	718	580	455	455
query30	284	217	189	189
query31	941	839	751	751
query32	81	70	64	64
query33	581	384	323	323
query34	790	839	541	541
query35	782	822	739	739
query36	947	984	880	880
query37	109	105	83	83
query38	4064	4078	4046	4046
query39	1513	1422	1381	1381
query40	210	131	113	113
query41	71	66	70	66
query42	126	106	109	106
query43	499	511	475	475
query44	1346	820	817	817
query45	179	183	166	166
query46	824	1015	624	624
query47	1749	1765	1744	1744
query48	383	439	305	305
query49	730	480	406	406
query50	622	668	405	405
query51	4164	4166	4153	4153
query52	114	109	98	98
query53	220	253	187	187
query54	568	569	535	535
query55	87	85	90	85
query56	317	297	270	270
query57	1147	1118	1088	1088
query58	274	255	255	255
query59	2546	2673	2557	2557
query60	323	309	312	309
query61	129	127	126	126
query62	811	710	645	645
query63	228	183	183	183
query64	4226	999	683	683
query65	4202	4129	4170	4129
query66	1062	416	311	311
query67	15961	15650	15427	15427
query68	8453	893	522	522
query69	465	302	266	266
query70	1157	1125	1140	1125
query71	468	324	294	294
query72	5755	4787	4762	4762
query73	727	637	344	344
query74	8916	8795	9108	8795
query75	3902	3251	2695	2695
query76	3684	1183	765	765
query77	785	384	294	294
query78	10085	10055	9447	9447
query79	2811	824	604	604
query80	638	525	479	479
query81	480	257	221	221
query82	459	126	103	103
query83	293	256	247	247
query84	355	103	103	103
query85	790	352	318	318
query86	397	291	278	278
query87	4469	4417	4340	4340
query88	3205	2289	2293	2289
query89	408	317	285	285
query90	1991	210	209	209
query91	143	140	111	111
query92	82	59	60	59
query93	2223	935	589	589
query94	676	411	276	276
query95	380	296	281	281
query96	491	574	284	284
query97	2719	2782	2666	2666
query98	241	209	206	206
query99	1430	1400	1286	1286
Total cold run time: 276131 ms
Total hot run time: 186092 ms

doris-robot avatar Jun 05 '25 11:06 doris-robot

ClickBench: Total hot run time: 29.35 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit c4e5d8e90db8c0d49c7e552206b7ac9898a3684e, 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.61	0.20	0.19
query5	0.45	0.45	0.43
query6	1.40	0.65	0.66
query7	0.02	0.02	0.01
query8	0.04	0.05	0.03
query9	0.57	0.52	0.53
query10	0.56	0.59	0.56
query11	0.16	0.11	0.12
query12	0.15	0.12	0.12
query13	0.62	0.60	0.60
query14	0.79	0.81	0.80
query15	0.88	0.85	0.86
query16	0.39	0.39	0.38
query17	1.02	1.03	1.06
query18	0.23	0.21	0.21
query19	1.93	1.78	1.84
query20	0.01	0.01	0.01
query21	15.43	0.91	0.54
query22	0.77	1.16	0.64
query23	14.96	1.37	0.63
query24	7.20	1.21	1.07
query25	0.50	0.26	0.11
query26	0.53	0.16	0.13
query27	0.06	0.05	0.04
query28	9.70	0.93	0.43
query29	12.55	3.96	3.34
query30	0.25	0.09	0.07
query31	2.81	0.60	0.39
query32	3.22	0.56	0.47
query33	3.04	3.07	3.09
query34	15.75	5.10	4.53
query35	4.46	4.54	4.47
query36	0.68	0.49	0.49
query37	0.09	0.06	0.06
query38	0.06	0.04	0.04
query39	0.03	0.03	0.02
query40	0.17	0.14	0.13
query41	0.07	0.03	0.03
query42	0.03	0.03	0.02
query43	0.04	0.04	0.03
Total cold run time: 103.65 s
Total hot run time: 29.35 s

doris-robot avatar Jun 05 '25 11:06 doris-robot

FE UT Coverage Report

Increment line coverage 49.64% (68/137) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Jun 05 '25 12:06 hello-stephen

run buildall

morrySnow avatar Jun 10 '25 06:06 morrySnow

run buildall

morrySnow avatar Jun 13 '25 08:06 morrySnow

run buildall

morrySnow avatar Jun 17 '25 06:06 morrySnow

FE UT Coverage Report

Increment line coverage 50.75% (68/134) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Jun 17 '25 08:06 hello-stephen

run buildall

morrySnow avatar Jun 18 '25 04:06 morrySnow

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

------ Round 1 ----------------------------------
q1	17601	5173	5009	5009
q2	1931	289	184	184
q3	10301	1334	733	733
q4	10213	1023	513	513
q5	7501	2397	2288	2288
q6	183	167	131	131
q7	901	748	600	600
q8	9318	1373	1068	1068
q9	6887	5072	5142	5072
q10	6888	2393	1964	1964
q11	505	287	292	287
q12	347	356	213	213
q13	17776	3724	3138	3138
q14	228	238	214	214
q15	554	503	490	490
q16	432	432	373	373
q17	584	877	368	368
q18	7530	7248	7247	7247
q19	1097	975	551	551
q20	326	340	229	229
q21	4147	3238	2990	2990
q22	1080	1009	985	985
Total cold run time: 106330 ms
Total hot run time: 34647 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5091	5061	5034	5034
q2	245	323	227	227
q3	2165	2695	2289	2289
q4	1377	1859	1354	1354
q5	4253	4100	4468	4100
q6	216	166	129	129
q7	1967	1949	1826	1826
q8	2640	2600	2503	2503
q9	7169	7089	7186	7089
q10	3083	3285	2864	2864
q11	578	515	499	499
q12	693	761	603	603
q13	3471	3882	3351	3351
q14	305	289	280	280
q15	557	524	511	511
q16	451	500	444	444
q17	1145	1547	1424	1424
q18	7727	7472	7343	7343
q19	811	813	878	813
q20	2034	2046	1911	1911
q21	4979	4532	4282	4282
q22	1086	1041	981	981
Total cold run time: 52043 ms
Total hot run time: 49857 ms

doris-robot avatar Jun 18 '25 07:06 doris-robot

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

query1	988	400	376	376
query2	6535	1900	1850	1850
query3	6741	228	212	212
query4	26575	23440	23466	23440
query5	4370	648	480	480
query6	301	208	194	194
query7	4622	498	298	298
query8	273	228	219	219
query9	8631	2693	2703	2693
query10	471	343	285	285
query11	15467	15054	14913	14913
query12	152	109	107	107
query13	1669	554	420	420
query14	8758	6266	6237	6237
query15	206	205	174	174
query16	7425	666	490	490
query17	1238	718	587	587
query18	1981	409	323	323
query19	208	190	172	172
query20	128	119	125	119
query21	218	187	110	110
query22	4076	4149	4112	4112
query23	33992	33037	33201	33037
query24	8416	2350	2379	2350
query25	543	450	414	414
query26	1237	268	152	152
query27	2725	503	350	350
query28	4288	2172	2148	2148
query29	736	571	427	427
query30	289	219	189	189
query31	922	859	728	728
query32	72	65	69	65
query33	557	376	331	331
query34	801	850	552	552
query35	781	827	730	730
query36	942	994	873	873
query37	116	98	80	80
query38	4074	4099	3991	3991
query39	1478	1411	1416	1411
query40	211	121	103	103
query41	62	71	70	70
query42	123	110	115	110
query43	487	510	488	488
query44	1299	837	808	808
query45	178	172	168	168
query46	839	1020	629	629
query47	1724	1779	1732	1732
query48	384	433	307	307
query49	754	485	423	423
query50	646	670	399	399
query51	4140	4156	4153	4153
query52	110	108	102	102
query53	223	250	186	186
query54	581	593	508	508
query55	84	78	82	78
query56	309	306	312	306
query57	1157	1228	1109	1109
query58	276	263	257	257
query59	2725	2674	2678	2674
query60	334	321	311	311
query61	122	127	124	124
query62	819	747	635	635
query63	226	184	188	184
query64	4281	1011	659	659
query65	4280	4163	4218	4163
query66	1147	419	321	321
query67	15984	15485	15684	15485
query68	8079	893	535	535
query69	482	304	274	274
query70	1193	1076	1122	1076
query71	484	315	302	302
query72	5351	4738	4793	4738
query73	721	614	351	351
query74	8929	8853	8847	8847
query75	3894	3204	2673	2673
query76	3730	1190	773	773
query77	775	377	293	293
query78	9996	10168	9352	9352
query79	2757	833	586	586
query80	625	511	459	459
query81	470	269	233	233
query82	472	134	100	100
query83	282	259	241	241
query84	289	108	83	83
query85	783	370	318	318
query86	339	325	299	299
query87	4417	4461	4261	4261
query88	3070	2302	2261	2261
query89	405	324	284	284
query90	1947	273	209	209
query91	149	145	111	111
query92	72	70	63	63
query93	1498	944	590	590
query94	681	418	311	311
query95	379	297	283	283
query96	506	579	280	280
query97	2706	2774	2684	2684
query98	218	211	204	204
query99	1454	1406	1255	1255
Total cold run time: 273660 ms
Total hot run time: 186460 ms

doris-robot avatar Jun 18 '25 07:06 doris-robot

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

query1	0.04	0.04	0.03
query2	0.06	0.04	0.03
query3	0.24	0.08	0.06
query4	1.62	0.10	0.10
query5	0.42	0.42	0.40
query6	1.17	0.67	0.66
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.58	0.54	0.51
query10	0.57	0.58	0.57
query11	0.16	0.11	0.11
query12	0.16	0.11	0.12
query13	0.62	0.61	0.62
query14	0.80	0.80	0.83
query15	0.90	0.87	0.88
query16	0.40	0.39	0.38
query17	1.04	1.08	1.06
query18	0.23	0.22	0.21
query19	1.98	1.89	1.86
query20	0.01	0.01	0.01
query21	15.41	0.93	0.54
query22	0.75	1.20	0.67
query23	14.95	1.37	0.64
query24	7.35	1.60	0.75
query25	0.48	0.22	0.06
query26	0.52	0.17	0.13
query27	0.07	0.06	0.06
query28	9.89	0.86	0.43
query29	12.53	3.96	3.35
query30	0.26	0.09	0.06
query31	2.82	0.61	0.38
query32	3.23	0.54	0.48
query33	3.14	3.12	3.10
query34	16.09	5.47	4.82
query35	4.86	4.92	4.86
query36	0.68	0.49	0.49
query37	0.09	0.07	0.07
query38	0.05	0.04	0.04
query39	0.03	0.03	0.02
query40	0.18	0.14	0.13
query41	0.08	0.02	0.02
query42	0.03	0.03	0.02
query43	0.04	0.04	0.03
Total cold run time: 104.59 s
Total hot run time: 29.58 s

doris-robot avatar Jun 18 '25 07:06 doris-robot

run performance

hello-stephen avatar Jun 18 '25 12:06 hello-stephen

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

------ Round 1 ----------------------------------
q1	17687	5269	5022	5022
q2	1931	294	191	191
q3	10595	1337	689	689
q4	10248	1017	540	540
q5	7894	2343	2331	2331
q6	183	162	130	130
q7	877	724	623	623
q8	9303	1280	1036	1036
q9	6732	5068	5115	5068
q10	6888	2387	1963	1963
q11	514	286	278	278
q12	351	345	211	211
q13	17787	3681	3043	3043
q14	242	232	205	205
q15	560	479	479	479
q16	423	439	371	371
q17	605	836	388	388
q18	8217	7225	7363	7225
q19	1429	931	545	545
q20	331	329	227	227
q21	3747	3187	2342	2342
q22	1029	1013	970	970
Total cold run time: 107573 ms
Total hot run time: 33877 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5073	5002	5054	5002
q2	242	326	226	226
q3	2176	2624	2269	2269
q4	1322	1775	1385	1385
q5	4189	4073	4356	4073
q6	225	173	128	128
q7	1993	1883	1705	1705
q8	2536	2577	2427	2427
q9	7065	7096	7069	7069
q10	3067	3245	2817	2817
q11	582	502	508	502
q12	659	771	604	604
q13	3494	3883	3359	3359
q14	285	295	275	275
q15	515	482	473	473
q16	476	469	444	444
q17	1112	1568	1387	1387
q18	7504	7052	7113	7052
q19	745	733	885	733
q20	1892	1992	1869	1869
q21	4723	4262	4231	4231
q22	1062	1017	973	973
Total cold run time: 50937 ms
Total hot run time: 49003 ms

doris-robot avatar Jun 18 '25 13:06 doris-robot

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

query1	978	384	378	378
query2	6524	1818	1807	1807
query3	6758	225	226	225
query4	26470	23768	23299	23299
query5	4310	624	480	480
query6	301	210	211	210
query7	4636	491	286	286
query8	269	222	223	222
query9	8632	2617	2598	2598
query10	494	327	275	275
query11	15697	15017	14896	14896
query12	159	109	104	104
query13	1657	528	428	428
query14	9429	6205	6245	6205
query15	199	195	171	171
query16	7466	630	483	483
query17	1213	733	569	569
query18	1997	420	311	311
query19	196	189	170	170
query20	124	115	118	115
query21	214	123	115	115
query22	4126	4286	4008	4008
query23	34097	32875	33008	32875
query24	8405	2355	2351	2351
query25	538	452	401	401
query26	1239	266	152	152
query27	2752	501	343	343
query28	4318	2107	2089	2089
query29	754	547	438	438
query30	284	217	187	187
query31	950	855	758	758
query32	71	63	59	59
query33	555	356	317	317
query34	791	868	526	526
query35	782	805	724	724
query36	953	977	876	876
query37	105	96	72	72
query38	4086	4076	4054	4054
query39	1479	1438	1397	1397
query40	214	124	105	105
query41	68	58	61	58
query42	122	112	104	104
query43	493	482	446	446
query44	1286	821	825	821
query45	183	172	166	166
query46	833	1038	618	618
query47	1755	1821	1708	1708
query48	375	413	305	305
query49	739	468	403	403
query50	638	672	398	398
query51	4075	4245	4090	4090
query52	113	111	95	95
query53	222	246	189	189
query54	562	564	494	494
query55	82	85	85	85
query56	324	306	289	289
query57	1191	1189	1127	1127
query58	273	251	246	246
query59	2579	2767	2542	2542
query60	332	342	297	297
query61	127	124	129	124
query62	828	713	660	660
query63	221	184	182	182
query64	4311	1004	677	677
query65	4268	4192	4212	4192
query66	1103	405	327	327
query67	15929	15573	15498	15498
query68	8248	877	534	534
query69	470	304	278	278
query70	1153	1100	1118	1100
query71	469	323	301	301
query72	5854	4790	4905	4790
query73	761	683	430	430
query74	8830	8904	8709	8709
query75	3849	3175	2698	2698
query76	3717	1177	758	758
query77	808	378	290	290
query78	9945	10038	9338	9338
query79	3016	829	577	577
query80	657	570	428	428
query81	504	258	224	224
query82	482	141	94	94
query83	282	252	233	233
query84	295	105	91	91
query85	798	356	316	316
query86	390	309	279	279
query87	4338	4404	4305	4305
query88	3420	2257	2245	2245
query89	395	317	282	282
query90	1870	201	205	201
query91	146	151	115	115
query92	74	60	60	60
query93	2393	940	587	587
query94	665	410	294	294
query95	367	290	284	284
query96	483	564	278	278
query97	2704	2740	2666	2666
query98	234	208	209	208
query99	1439	1408	1294	1294
Total cold run time: 276310 ms
Total hot run time: 185507 ms

doris-robot avatar Jun 18 '25 13:06 doris-robot

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

query1	0.03	0.03	0.02
query2	0.11	0.05	0.05
query3	0.29	0.06	0.07
query4	1.60	0.08	0.09
query5	0.42	0.41	0.40
query6	1.17	0.66	0.66
query7	0.02	0.02	0.02
query8	0.05	0.05	0.05
query9	0.61	0.52	0.53
query10	0.57	0.59	0.56
query11	0.24	0.13	0.13
query12	0.26	0.14	0.14
query13	0.64	0.63	0.62
query14	0.81	0.82	0.84
query15	1.00	0.89	0.88
query16	0.39	0.40	0.36
query17	1.08	1.09	1.09
query18	0.24	0.23	0.23
query19	2.02	1.85	1.83
query20	0.01	0.01	0.01
query21	15.40	0.98	0.66
query22	0.92	1.07	0.78
query23	14.74	1.57	0.77
query24	5.47	0.59	0.29
query25	0.16	0.09	0.09
query26	0.56	0.22	0.18
query27	0.09	0.08	0.08
query28	11.05	1.27	0.59
query29	12.55	4.23	3.44
query30	0.27	0.08	0.06
query31	2.82	0.65	0.43
query32	3.23	0.60	0.51
query33	3.13	3.13	3.10
query34	16.62	5.49	4.71
query35	4.77	4.74	4.74
query36	0.65	0.52	0.50
query37	0.20	0.17	0.17
query38	0.17	0.16	0.15
query39	0.06	0.04	0.05
query40	0.21	0.17	0.17
query41	0.11	0.06	0.05
query42	0.06	0.05	0.05
query43	0.05	0.04	0.05
Total cold run time: 104.85 s
Total hot run time: 30.13 s

doris-robot avatar Jun 18 '25 13:06 doris-robot

run buildall

morrySnow avatar Jun 19 '25 02:06 morrySnow

run buildall

morrySnow avatar Jun 19 '25 02:06 morrySnow

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

------ Round 1 ----------------------------------
q1	17688	5227	5031	5031
q2	1937	299	186	186
q3	10525	1300	724	724
q4	10245	1009	523	523
q5	7691	2395	2250	2250
q6	182	162	131	131
q7	911	740	623	623
q8	9306	1266	1137	1137
q9	6734	5079	5087	5079
q10	6915	2376	1980	1980
q11	502	291	277	277
q12	347	359	225	225
q13	17792	3700	3134	3134
q14	227	234	216	216
q15	564	476	492	476
q16	447	448	379	379
q17	598	862	377	377
q18	7670	7133	7217	7133
q19	1910	969	583	583
q20	356	337	223	223
q21	3699	3158	2445	2445
q22	1043	1009	974	974
Total cold run time: 107289 ms
Total hot run time: 34106 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5171	4998	5075	4998
q2	245	324	223	223
q3	2138	2645	2314	2314
q4	1381	1802	1422	1422
q5	4279	4147	4439	4147
q6	214	173	133	133
q7	2024	1886	1788	1788
q8	2582	2504	2523	2504
q9	7127	7043	7135	7043
q10	3138	3287	2832	2832
q11	577	541	504	504
q12	691	771	652	652
q13	3525	3922	3312	3312
q14	278	313	282	282
q15	526	492	469	469
q16	450	496	436	436
q17	1156	1483	1394	1394
q18	7296	7174	7130	7130
q19	824	826	842	826
q20	1895	1975	1865	1865
q21	4816	4346	4315	4315
q22	1035	1002	995	995
Total cold run time: 51368 ms
Total hot run time: 49584 ms

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

TPC-DS: Total hot run time: 186517 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 49c28b284333707f2a0f95536d2aabbd8ee05fc8, data reload: false

query1	1000	395	398	395
query2	6536	2005	1917	1917
query3	6759	223	221	221
query4	26557	23373	23146	23146
query5	4386	628	468	468
query6	312	210	200	200
query7	4638	508	310	310
query8	279	231	227	227
query9	8635	2666	2678	2666
query10	512	337	272	272
query11	15890	15052	14855	14855
query12	166	108	106	106
query13	1645	546	405	405
query14	9618	6349	6144	6144
query15	207	187	181	181
query16	7501	637	445	445
query17	1177	705	578	578
query18	2013	391	312	312
query19	199	187	162	162
query20	124	117	112	112
query21	215	132	112	112
query22	4143	4044	4113	4044
query23	34101	33138	33086	33086
query24	8503	2395	2410	2395
query25	538	457	395	395
query26	1233	279	154	154
query27	2767	518	356	356
query28	4316	2158	2147	2147
query29	748	562	438	438
query30	296	230	193	193
query31	930	875	758	758
query32	72	62	66	62
query33	565	366	339	339
query34	795	846	549	549
query35	790	835	704	704
query36	960	969	888	888
query37	105	102	76	76
query38	4114	4205	4110	4110
query39	1489	1412	1402	1402
query40	213	124	111	111
query41	66	60	58	58
query42	126	114	115	114
query43	529	515	498	498
query44	1374	849	842	842
query45	179	183	170	170
query46	849	1027	636	636
query47	1760	1798	1763	1763
query48	401	470	319	319
query49	762	516	422	422
query50	675	667	419	419
query51	4161	4149	4093	4093
query52	114	111	100	100
query53	232	258	193	193
query54	581	571	501	501
query55	88	84	87	84
query56	308	289	301	289
query57	1212	1190	1131	1131
query58	266	284	263	263
query59	2802	2761	2701	2701
query60	354	321	312	312
query61	127	130	131	130
query62	802	730	666	666
query63	236	207	197	197
query64	4413	1109	778	778
query65	4287	4159	4199	4159
query66	1119	434	346	346
query67	15805	15515	15232	15232
query68	7832	909	548	548
query69	495	326	343	326
query70	1182	1156	1156	1156
query71	442	330	310	310
query72	5580	4827	5037	4827
query73	725	696	367	367
query74	8917	9111	8622	8622
query75	3621	3188	2695	2695
query76	3385	1194	754	754
query77	748	396	305	305
query78	10097	10299	9342	9342
query79	2285	840	585	585
query80	585	514	487	487
query81	507	269	221	221
query82	481	131	101	101
query83	266	255	232	232
query84	260	112	95	95
query85	812	354	315	315
query86	389	322	299	299
query87	4428	4486	4521	4486
query88	4015	2344	2302	2302
query89	393	308	295	295
query90	1947	221	212	212
query91	144	144	114	114
query92	72	64	58	58
query93	1872	1000	615	615
query94	717	405	304	304
query95	384	299	293	293
query96	503	578	289	289
query97	2713	2776	2651	2651
query98	237	216	206	206
query99	1561	1412	1248	1248
Total cold run time: 276270 ms
Total hot run time: 186517 ms

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

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

query1	0.04	0.03	0.03
query2	0.11	0.04	0.05
query3	0.30	0.06	0.06
query4	1.62	0.08	0.07
query5	0.42	0.41	0.41
query6	1.16	0.67	0.67
query7	0.02	0.02	0.02
query8	0.06	0.05	0.05
query9	0.64	0.53	0.55
query10	0.58	0.59	0.58
query11	0.25	0.13	0.12
query12	0.25	0.13	0.13
query13	0.65	0.63	0.63
query14	0.81	0.86	0.84
query15	1.00	0.89	0.89
query16	0.38	0.38	0.39
query17	1.08	1.07	1.11
query18	0.25	0.23	0.23
query19	2.00	1.85	1.88
query20	0.01	0.01	0.02
query21	15.41	0.96	0.67
query22	0.95	1.04	0.86
query23	14.68	1.49	0.78
query24	5.28	0.59	0.30
query25	0.16	0.10	0.09
query26	0.56	0.22	0.18
query27	0.09	0.09	0.08
query28	11.05	1.23	0.60
query29	12.56	4.16	3.47
query30	0.29	0.09	0.07
query31	2.83	0.62	0.43
query32	3.24	0.59	0.51
query33	3.09	3.14	3.12
query34	16.79	5.42	4.75
query35	4.80	4.75	4.77
query36	0.64	0.51	0.54
query37	0.20	0.17	0.16
query38	0.17	0.17	0.16
query39	0.05	0.05	0.04
query40	0.20	0.17	0.17
query41	0.11	0.05	0.06
query42	0.06	0.06	0.05
query43	0.06	0.05	0.05
Total cold run time: 104.9 s
Total hot run time: 30.46 s

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

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

github-actions[bot] avatar Jun 19 '25 07:06 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Jun 19 '25 07:06 github-actions[bot]