Skip to content

Conversation

@felixwluo
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #51735

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

@Thearas
Copy link
Contributor

Thearas commented Jun 16, 2025

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?

@felixwluo
Copy link
Contributor Author

run buildall

@felixwluo felixwluo requested a review from xinyiZzz June 16, 2025 08:05
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17642	5198	5099	5099
q2	1952	314	180	180
q3	10321	1278	739	739
q4	10248	1012	531	531
q5	7830	2346	2349	2346
q6	178	160	140	140
q7	891	733	614	614
q8	9313	1307	1127	1127
q9	6909	5103	5099	5099
q10	6891	2314	1892	1892
q11	488	300	269	269
q12	352	389	219	219
q13	17790	3627	3121	3121
q14	225	231	221	221
q15	583	476	481	476
q16	449	433	399	399
q17	615	847	358	358
q18	7576	7266	7252	7252
q19	1630	945	599	599
q20	340	334	229	229
q21	3767	3234	2450	2450
q22	1075	1028	958	958
Total cold run time: 107065 ms
Total hot run time: 34318 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5163	5073	5027	5027
q2	245	317	222	222
q3	2166	2662	2276	2276
q4	1390	1823	1366	1366
q5	4254	4170	4376	4170
q6	218	176	137	137
q7	1976	1948	1782	1782
q8	2602	2493	2512	2493
q9	7208	7146	7201	7146
q10	3037	3158	2716	2716
q11	586	530	492	492
q12	670	761	611	611
q13	3615	3913	3272	3272
q14	285	314	273	273
q15	534	481	492	481
q16	454	496	441	441
q17	1177	1604	1346	1346
q18	7885	7631	7498	7498
q19	839	844	959	844
q20	1978	2033	1960	1960
q21	4965	4427	4508	4427
q22	1086	1041	1039	1039
Total cold run time: 52333 ms
Total hot run time: 50019 ms

@doris-robot
Copy link

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

query1	1389	1019	1002	1002
query2	6272	1816	1812	1812
query3	11130	4532	4730	4532
query4	54260	25481	23103	23103
query5	5304	528	477	477
query6	392	214	202	202
query7	5031	526	290	290
query8	306	228	226	226
query9	6388	2672	2650	2650
query10	460	338	295	295
query11	15366	14976	14784	14784
query12	164	109	114	109
query13	1098	548	403	403
query14	10187	6292	6221	6221
query15	206	193	187	187
query16	7014	661	464	464
query17	1089	793	612	612
query18	1554	407	323	323
query19	203	195	172	172
query20	135	143	123	123
query21	208	131	108	108
query22	4469	4454	4298	4298
query23	34439	33652	33593	33593
query24	6776	2445	2487	2445
query25	466	485	430	430
query26	735	274	158	158
query27	2477	531	361	361
query28	2977	2238	2221	2221
query29	594	553	448	448
query30	270	219	192	192
query31	885	877	787	787
query32	76	61	62	61
query33	453	394	323	323
query34	829	870	538	538
query35	801	827	769	769
query36	970	987	918	918
query37	113	105	87	87
query38	4340	4320	4286	4286
query39	1512	1480	1452	1452
query40	215	124	122	122
query41	61	62	54	54
query42	128	119	117	117
query43	525	538	469	469
query44	1386	861	866	861
query45	185	174	167	167
query46	869	1044	678	678
query47	1841	1898	1776	1776
query48	413	448	330	330
query49	674	478	408	408
query50	706	715	416	416
query51	4207	4253	4243	4243
query52	124	112	112	112
query53	256	275	197	197
query54	601	602	537	537
query55	93	95	97	95
query56	332	315	296	296
query57	1210	1256	1160	1160
query58	290	278	260	260
query59	2701	2792	2674	2674
query60	343	330	325	325
query61	132	131	128	128
query62	722	748	689	689
query63	247	206	208	206
query64	1761	1070	732	732
query65	4295	4137	4122	4122
query66	726	393	311	311
query67	16146	15656	15386	15386
query68	7199	910	537	537
query69	546	309	279	279
query70	1195	1190	1090	1090
query71	521	329	302	302
query72	5780	4729	4784	4729
query73	1196	647	356	356
query74	9288	8847	8685	8685
query75	3736	3186	2679	2679
query76	4229	1190	773	773
query77	625	389	306	306
query78	10075	10147	9366	9366
query79	2455	833	598	598
query80	657	517	462	462
query81	486	254	224	224
query82	458	135	101	101
query83	349	255	244	244
query84	294	104	106	104
query85	807	360	316	316
query86	406	304	269	269
query87	4434	4515	4380	4380
query88	3276	2386	2403	2386
query89	403	312	290	290
query90	1883	217	213	213
query91	141	146	109	109
query92	72	60	55	55
query93	1922	954	587	587
query94	673	418	313	313
query95	376	304	307	304
query96	530	581	290	290
query97	2773	2757	2642	2642
query98	238	207	208	207
query99	1434	1412	1292	1292
Total cold run time: 300984 ms
Total hot run time: 192821 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.04
query3	0.24	0.07	0.07
query4	1.60	0.10	0.10
query5	0.47	0.42	0.41
query6	1.15	0.66	0.68
query7	0.02	0.02	0.01
query8	0.04	0.04	0.04
query9	0.59	0.55	0.52
query10	0.57	0.60	0.57
query11	0.16	0.10	0.11
query12	0.15	0.11	0.12
query13	0.61	0.59	0.60
query14	0.80	0.81	0.81
query15	0.90	0.87	0.89
query16	0.39	0.38	0.38
query17	1.08	1.09	1.05
query18	0.24	0.21	0.21
query19	1.94	1.84	1.87
query20	0.02	0.01	0.02
query21	15.40	0.92	0.54
query22	0.76	1.26	0.74
query23	14.77	1.38	0.63
query24	7.60	1.14	0.39
query25	0.27	0.11	0.15
query26	0.59	0.18	0.15
query27	0.06	0.05	0.06
query28	8.17	0.90	0.46
query29	12.55	4.06	3.42
query30	0.26	0.09	0.06
query31	2.82	0.59	0.40
query32	3.24	0.55	0.47
query33	3.04	3.04	3.13
query34	15.89	5.15	4.50
query35	4.59	4.57	4.49
query36	0.67	0.50	0.49
query37	0.10	0.07	0.06
query38	0.06	0.04	0.04
query39	0.03	0.03	0.03
query40	0.17	0.15	0.14
query41	0.08	0.03	0.03
query42	0.03	0.03	0.03
query43	0.05	0.04	0.03
Total cold run time: 102.28 s
Total hot run time: 28.72 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 56.42% (15070/26711)
Line Coverage 45.18% (134749/298263)
Region Coverage 44.30% (67792/153016)
Branch Coverage 38.87% (34775/89458)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.76% (20967/26288)
Line Coverage 72.71% (216759/298105)
Region Coverage 71.02% (127829/179989)
Branch Coverage 64.69% (66157/102264)

@felixwluo
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17652	5135	5056	5056
q2	1974	325	183	183
q3	10242	1253	800	800
q4	10253	1031	539	539
q5	7649	2473	2378	2378
q6	195	161	132	132
q7	935	775	597	597
q8	9338	1423	1320	1320
q9	6821	5160	5101	5101
q10	7006	2387	1980	1980
q11	497	305	292	292
q12	366	387	228	228
q13	17795	3710	3159	3159
q14	239	228	215	215
q15	564	491	477	477
q16	437	450	388	388
q17	638	894	393	393
q18	7456	7093	7192	7093
q19	2027	968	597	597
q20	357	369	234	234
q21	4224	3861	3155	3155
q22	1092	1005	1013	1005
Total cold run time: 107757 ms
Total hot run time: 35322 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5197	5000	5013	5000
q2	253	320	226	226
q3	2194	2699	2326	2326
q4	1362	1784	1371	1371
q5	4272	4352	4385	4352
q6	260	169	133	133
q7	2105	1981	1806	1806
q8	2634	2690	2657	2657
q9	7147	7197	7194	7194
q10	3045	3223	2939	2939
q11	608	520	521	520
q12	722	794	610	610
q13	3614	4637	3374	3374
q14	281	304	288	288
q15	517	472	475	472
q16	454	495	458	458
q17	1208	1567	1368	1368
q18	7690	7493	7495	7493
q19	878	857	961	857
q20	2031	2042	1991	1991
q21	4848	4542	4462	4462
q22	1125	1047	1038	1038
Total cold run time: 52445 ms
Total hot run time: 50935 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 194907 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 71a6cd0628c83bff3de7f6806d9eabc461a74fd9, data reload: false

query1	1433	1013	1004	1004
query2	6202	1939	1937	1937
query3	11015	4263	4634	4263
query4	55732	24642	23650	23650
query5	5013	601	491	491
query6	361	216	205	205
query7	4881	543	305	305
query8	293	245	226	226
query9	5656	2840	2873	2840
query10	449	345	283	283
query11	15439	14987	14808	14808
query12	158	109	107	107
query13	1038	552	441	441
query14	10179	6437	6291	6291
query15	219	204	183	183
query16	7120	667	521	521
query17	1098	764	595	595
query18	1578	451	344	344
query19	225	217	186	186
query20	141	125	128	125
query21	211	134	110	110
query22	4523	4378	4457	4378
query23	34483	33576	33640	33576
query24	6750	2452	2538	2452
query25	484	497	431	431
query26	731	285	161	161
query27	2323	527	361	361
query28	3162	2352	2322	2322
query29	598	581	455	455
query30	284	230	198	198
query31	873	846	778	778
query32	77	62	63	62
query33	444	402	353	353
query34	822	956	575	575
query35	814	841	760	760
query36	1009	1049	944	944
query37	110	97	77	77
query38	4356	4307	4399	4307
query39	1525	1488	1480	1480
query40	214	128	116	116
query41	66	58	62	58
query42	143	120	116	116
query43	532	539	527	527
query44	1402	906	913	906
query45	191	178	170	170
query46	907	1051	677	677
query47	1850	1923	1834	1834
query48	417	442	340	340
query49	680	482	409	409
query50	701	736	437	437
query51	4375	4283	4199	4199
query52	115	123	108	108
query53	243	273	204	204
query54	634	616	547	547
query55	96	86	91	86
query56	300	334	332	332
query57	1284	1286	1175	1175
query58	287	278	283	278
query59	2825	2903	2937	2903
query60	350	368	343	343
query61	126	128	126	126
query62	736	758	639	639
query63	232	198	197	197
query64	2032	1015	714	714
query65	4278	4177	4201	4177
query66	803	400	305	305
query67	16208	15859	15505	15505
query68	6964	894	578	578
query69	532	318	277	277
query70	1229	1171	1161	1161
query71	538	363	325	325
query72	5758	4759	4963	4759
query73	1440	646	394	394
query74	9014	9132	8691	8691
query75	4043	3233	2693	2693
query76	4212	1222	781	781
query77	726	379	298	298
query78	10255	10259	9388	9388
query79	2648	903	628	628
query80	636	550	465	465
query81	497	260	224	224
query82	442	130	103	103
query83	318	268	246	246
query84	303	107	89	89
query85	785	369	353	353
query86	375	306	288	288
query87	4583	4531	4376	4376
query88	3695	2482	2424	2424
query89	413	328	293	293
query90	1837	214	210	210
query91	144	143	114	114
query92	77	63	69	63
query93	2012	999	623	623
query94	665	422	312	312
query95	384	310	301	301
query96	533	599	296	296
query97	2813	2779	2662	2662
query98	246	215	210	210
query99	1473	1396	1269	1269
Total cold run time: 303426 ms
Total hot run time: 194907 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 71a6cd0628c83bff3de7f6806d9eabc461a74fd9, data reload: false

query1	0.04	0.04	0.03
query2	0.08	0.04	0.04
query3	0.24	0.07	0.07
query4	1.60	0.11	0.11
query5	0.44	0.40	0.43
query6	1.17	0.67	0.68
query7	0.03	0.02	0.02
query8	0.05	0.03	0.04
query9	0.58	0.54	0.53
query10	0.58	0.60	0.57
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.83	0.82
query15	0.91	0.87	0.89
query16	0.40	0.39	0.40
query17	1.12	1.07	1.07
query18	0.25	0.22	0.22
query19	1.96	1.91	1.85
query20	0.02	0.02	0.02
query21	15.40	0.92	0.55
query22	0.76	1.22	1.04
query23	14.71	1.42	0.63
query24	7.17	2.17	0.38
query25	0.27	0.12	0.09
query26	0.66	0.17	0.14
query27	0.06	0.06	0.06
query28	8.96	0.92	0.46
query29	12.56	4.13	3.41
query30	0.26	0.09	0.06
query31	2.83	0.62	0.40
query32	3.24	0.56	0.49
query33	3.08	3.14	3.15
query34	15.88	5.40	4.77
query35	4.85	4.85	4.83
query36	0.72	0.51	0.49
query37	0.10	0.07	0.07
query38	0.06	0.04	0.04
query39	0.04	0.02	0.02
query40	0.19	0.14	0.15
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 103.17 s
Total hot run time: 29.83 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 56.38% (15048/26690)
Line Coverage 45.15% (134578/298078)
Region Coverage 44.27% (67696/152906)
Branch Coverage 38.83% (34721/89410)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.79% (20959/26267)
Line Coverage 72.77% (216802/297920)
Region Coverage 71.02% (127742/179865)
Branch Coverage 64.72% (66154/102210)

@felixwluo
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17591	5285	5040	5040
q2	1929	272	202	202
q3	10301	1262	711	711
q4	10228	998	510	510
q5	7484	2384	2327	2327
q6	177	159	132	132
q7	912	723	604	604
q8	9312	1253	1049	1049
q9	6824	5121	5130	5121
q10	6869	2390	1961	1961
q11	504	294	265	265
q12	351	357	222	222
q13	17749	3673	3137	3137
q14	240	232	213	213
q15	544	505	497	497
q16	442	427	371	371
q17	589	855	364	364
q18	7711	7274	7025	7025
q19	1227	935	549	549
q20	351	329	228	228
q21	3980	2637	2407	2407
q22	999	1028	983	983
Total cold run time: 106314 ms
Total hot run time: 33918 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5071	5366	5089	5089
q2	240	328	225	225
q3	2165	2654	2288	2288
q4	1416	1828	1377	1377
q5	4260	4105	4131	4105
q6	201	167	126	126
q7	1855	1793	1689	1689
q8	2474	2485	2391	2391
q9	6743	6750	6791	6750
q10	2952	3163	2721	2721
q11	567	501	476	476
q12	640	731	596	596
q13	3365	3786	3050	3050
q14	289	290	257	257
q15	532	493	487	487
q16	417	466	431	431
q17	1099	1537	1322	1322
q18	7219	7147	6980	6980
q19	768	748	790	748
q20	1956	1952	1816	1816
q21	4787	4444	4484	4444
q22	1087	1027	1009	1009
Total cold run time: 50103 ms
Total hot run time: 48377 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 185872 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 53b85365b697634da747067fc28e9f4ce73719b1, data reload: false

query1	994	410	391	391
query2	6523	1830	1843	1830
query3	6744	223	224	223
query4	26578	23778	22884	22884
query5	4882	640	475	475
query6	319	214	196	196
query7	4625	489	298	298
query8	267	231	215	215
query9	8651	2663	2661	2661
query10	520	361	261	261
query11	15684	15006	14844	14844
query12	178	103	109	103
query13	1650	545	411	411
query14	9594	6355	6513	6355
query15	198	201	171	171
query16	7667	629	479	479
query17	1239	749	581	581
query18	2038	414	304	304
query19	205	189	172	172
query20	133	115	116	115
query21	215	125	108	108
query22	4080	4090	4120	4090
query23	33879	32888	33011	32888
query24	8452	2391	2381	2381
query25	524	481	394	394
query26	1237	278	152	152
query27	2712	512	359	359
query28	4292	2151	2120	2120
query29	725	552	435	435
query30	286	205	194	194
query31	956	835	745	745
query32	70	61	62	61
query33	565	389	315	315
query34	811	854	526	526
query35	797	820	734	734
query36	956	997	887	887
query37	107	101	76	76
query38	4116	4075	4094	4075
query39	1492	1429	1391	1391
query40	209	122	108	108
query41	65	60	63	60
query42	125	110	109	109
query43	518	511	481	481
query44	1395	818	821	818
query45	179	175	165	165
query46	866	1046	647	647
query47	1725	1790	1717	1717
query48	399	435	308	308
query49	754	474	406	406
query50	672	697	397	397
query51	4102	4186	4145	4145
query52	108	103	101	101
query53	228	265	191	191
query54	584	571	506	506
query55	83	80	82	80
query56	315	306	282	282
query57	1173	1193	1116	1116
query58	269	262	259	259
query59	2602	2739	2564	2564
query60	348	324	317	317
query61	128	136	130	130
query62	819	718	648	648
query63	224	189	192	189
query64	4276	1035	675	675
query65	4246	4138	4204	4138
query66	1080	410	315	315
query67	15721	15391	15505	15391
query68	8314	909	530	530
query69	466	298	268	268
query70	1210	1115	1077	1077
query71	480	319	295	295
query72	5558	4666	4677	4666
query73	696	633	360	360
query74	8892	9132	9040	9040
query75	3863	3190	2747	2747
query76	3719	1204	791	791
query77	780	388	297	297
query78	10080	10114	9470	9470
query79	2601	797	588	588
query80	644	507	454	454
query81	498	257	229	229
query82	443	130	102	102
query83	286	258	227	227
query84	297	157	88	88
query85	770	342	308	308
query86	382	308	292	292
query87	4499	4388	4306	4306
query88	3516	2278	2272	2272
query89	392	320	297	297
query90	1882	215	214	214
query91	142	137	110	110
query92	75	63	61	61
query93	1958	963	597	597
query94	660	413	310	310
query95	389	297	286	286
query96	494	579	284	284
query97	2746	2800	2637	2637
query98	231	208	209	208
query99	1476	1402	1298	1298
Total cold run time: 276613 ms
Total hot run time: 185872 ms

@doris-robot
Copy link

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 53b85365b697634da747067fc28e9f4ce73719b1, data reload: false

query1	0.03	0.03	0.03
query2	0.08	0.04	0.03
query3	0.24	0.07	0.06
query4	1.61	0.10	0.10
query5	0.42	0.44	0.42
query6	1.19	0.65	0.67
query7	0.03	0.02	0.02
query8	0.05	0.04	0.03
query9	0.58	0.52	0.50
query10	0.57	0.57	0.57
query11	0.15	0.11	0.11
query12	0.14	0.12	0.11
query13	0.63	0.61	0.61
query14	0.80	0.82	0.80
query15	0.88	0.86	0.89
query16	0.40	0.38	0.38
query17	1.04	1.03	1.12
query18	0.23	0.21	0.21
query19	1.94	1.89	1.84
query20	0.02	0.01	0.01
query21	15.40	0.89	0.53
query22	0.75	1.16	0.66
query23	14.93	1.37	0.62
query24	7.63	1.12	0.56
query25	0.46	0.14	0.19
query26	0.63	0.16	0.15
query27	0.06	0.05	0.05
query28	9.43	0.93	0.45
query29	12.53	3.97	3.30
query30	0.26	0.09	0.07
query31	2.84	0.61	0.40
query32	3.23	0.55	0.48
query33	3.09	3.11	3.05
query34	16.04	5.41	4.82
query35	4.83	4.90	4.87
query36	0.69	0.51	0.52
query37	0.09	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.03	0.02
query40	0.18	0.15	0.15
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.02	0.02
Total cold run time: 104.32 s
Total hot run time: 29.35 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 56.34% (15050/26712)
Line Coverage 45.11% (134596/298384)
Region Coverage 44.25% (67698/152994)
Branch Coverage 38.82% (34725/89450)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 61.58% (16190/26289)
Line Coverage 51.04% (152208/298226)
Region Coverage 48.47% (87231/179963)
Branch Coverage 41.95% (42898/102254)

@dataroaring
Copy link
Contributor

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17654	5292	5031	5031
q2	2029	330	214	214
q3	10243	1309	731	731
q4	10240	1033	546	546
q5	7604	2363	2423	2363
q6	185	170	138	138
q7	916	791	645	645
q8	9356	1337	1122	1122
q9	6948	5085	5175	5085
q10	6893	2406	1982	1982
q11	518	313	294	294
q12	354	372	231	231
q13	17777	3677	3053	3053
q14	247	239	219	219
q15	574	493	487	487
q16	1004	995	951	951
q17	629	885	372	372
q18	7694	7187	7102	7102
q19	1249	961	575	575
q20	357	346	243	243
q21	3846	3277	3090	3090
q22	1029	1042	1002	1002
Total cold run time: 107346 ms
Total hot run time: 35476 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5146	5140	5109	5109
q2	260	329	234	234
q3	2203	2673	2281	2281
q4	1353	1792	1356	1356
q5	4323	4616	4534	4534
q6	232	185	137	137
q7	2067	2049	1829	1829
q8	2658	2659	2632	2632
q9	7459	7292	7372	7292
q10	3117	3372	2886	2886
q11	596	507	574	507
q12	673	791	637	637
q13	3700	3842	3399	3399
q14	294	322	287	287
q15	539	508	494	494
q16	1082	1163	1074	1074
q17	1175	1616	1401	1401
q18	7781	8034	7481	7481
q19	790	850	996	850
q20	2035	2072	1921	1921
q21	4996	4414	4309	4309
q22	1080	1047	1010	1010
Total cold run time: 53559 ms
Total hot run time: 51660 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 188194 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 5041aa394b13c5348101b8ddf596f5bb5a37d63f, data reload: false

query1	1057	461	413	413
query2	6585	1737	1755	1737
query3	6756	225	221	221
query4	26099	23533	22958	22958
query5	4422	639	466	466
query6	357	245	227	227
query7	4650	515	297	297
query8	312	269	252	252
query9	8684	2628	2641	2628
query10	497	336	289	289
query11	15408	14985	14720	14720
query12	168	127	114	114
query13	1701	593	454	454
query14	10473	9405	9394	9394
query15	216	196	175	175
query16	7826	680	528	528
query17	1261	755	636	636
query18	2050	449	400	400
query19	202	196	167	167
query20	128	124	117	117
query21	215	129	114	114
query22	4213	4179	4138	4138
query23	34063	33059	33155	33059
query24	8467	2396	2409	2396
query25	562	499	443	443
query26	1242	273	160	160
query27	2725	513	360	360
query28	4391	2248	2211	2211
query29	774	625	477	477
query30	294	231	205	205
query31	923	841	725	725
query32	80	72	67	67
query33	575	380	335	335
query34	801	863	518	518
query35	796	834	754	754
query36	969	1029	903	903
query37	125	106	85	85
query38	3500	3553	3530	3530
query39	1497	1416	1425	1416
query40	219	130	119	119
query41	64	62	64	62
query42	129	113	108	108
query43	504	518	471	471
query44	1381	864	848	848
query45	182	181	168	168
query46	868	1025	649	649
query47	1758	1810	1719	1719
query48	393	435	320	320
query49	760	507	389	389
query50	645	693	412	412
query51	3867	3957	3912	3912
query52	111	108	102	102
query53	233	265	205	205
query54	612	587	533	533
query55	95	85	86	85
query56	320	339	320	320
query57	1217	1199	1115	1115
query58	276	266	267	266
query59	2514	2684	2522	2522
query60	343	344	335	335
query61	165	155	158	155
query62	860	735	679	679
query63	230	190	195	190
query64	4385	1137	800	800
query65	4062	3976	3964	3964
query66	1093	423	332	332
query67	15390	15425	15157	15157
query68	9361	935	580	580
query69	493	314	279	279
query70	1335	1279	1261	1261
query71	575	337	320	320
query72	5559	4923	5079	4923
query73	698	603	358	358
query74	9227	9243	8716	8716
query75	4494	3335	2773	2773
query76	3904	1169	750	750
query77	988	405	316	316
query78	9720	9860	8806	8806
query79	1409	852	588	588
query80	661	566	491	491
query81	486	260	234	234
query82	233	158	134	134
query83	298	278	276	276
query84	304	123	98	98
query85	850	443	407	407
query86	353	324	292	292
query87	3952	3826	3665	3665
query88	2859	2259	2291	2259
query89	380	321	308	308
query90	2056	228	217	217
query91	164	163	133	133
query92	88	70	62	62
query93	1130	996	645	645
query94	693	445	336	336
query95	398	318	302	302
query96	490	573	280	280
query97	2909	2986	2850	2850
query98	230	213	210	210
query99	1435	1407	1299	1299
Total cold run time: 275472 ms
Total hot run time: 188194 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.05
query2	0.09	0.05	0.06
query3	0.26	0.09	0.08
query4	1.61	0.12	0.12
query5	0.29	0.26	0.25
query6	1.19	0.66	0.65
query7	0.03	0.03	0.02
query8	0.06	0.05	0.05
query9	0.63	0.54	0.52
query10	0.59	0.57	0.58
query11	0.17	0.12	0.11
query12	0.15	0.12	0.12
query13	0.62	0.63	0.62
query14	1.03	1.04	1.02
query15	0.88	0.85	0.88
query16	0.44	0.39	0.42
query17	1.04	1.04	1.09
query18	0.21	0.20	0.20
query19	1.90	1.84	1.87
query20	0.02	0.01	0.02
query21	15.40	0.93	0.58
query22	0.76	1.23	0.99
query23	14.76	1.39	0.61
query24	6.77	1.26	1.63
query25	0.44	0.30	0.16
query26	0.60	0.16	0.14
query27	0.07	0.05	0.05
query28	9.63	0.85	0.43
query29	12.55	3.88	3.27
query30	0.28	0.13	0.11
query31	2.83	0.61	0.40
query32	3.26	0.58	0.47
query33	3.09	3.10	3.09
query34	16.30	5.50	4.86
query35	4.91	4.95	4.91
query36	0.71	0.52	0.52
query37	0.11	0.07	0.07
query38	0.06	0.05	0.04
query39	0.04	0.04	0.03
query40	0.20	0.15	0.15
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.05	0.03	0.03
Total cold run time: 104.2 s
Total hot run time: 30.77 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.20% (17426/33382)
Line Coverage 37.43% (158382/423105)
Region Coverage 32.02% (120837/377409)
Branch Coverage 33.38% (53000/158790)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 60.00% (9/15) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.72% (23411/32643)
Line Coverage 58.61% (247404/422093)
Region Coverage 54.88% (209877/382402)
Branch Coverage 55.91% (89179/159491)

@felixwluo
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17655	5295	5057	5057
q2	2077	328	219	219
q3	10215	1287	720	720
q4	10223	1032	524	524
q5	7565	2390	2378	2378
q6	183	171	140	140
q7	938	798	658	658
q8	9365	1339	1132	1132
q9	6908	5150	5201	5150
q10	6925	2384	1997	1997
q11	487	301	281	281
q12	343	367	238	238
q13	17780	3647	3058	3058
q14	251	241	221	221
q15	550	491	502	491
q16	1004	1011	951	951
q17	588	858	363	363
q18	7598	7170	7170	7170
q19	1224	955	566	566
q20	356	334	249	249
q21	3845	2585	2360	2360
q22	1071	1043	989	989
Total cold run time: 107151 ms
Total hot run time: 34912 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5116	5107	5099	5099
q2	248	328	224	224
q3	2148	2706	2297	2297
q4	1368	1822	1372	1372
q5	4225	4606	4609	4606
q6	230	177	137	137
q7	2078	1935	1821	1821
q8	2642	2565	2617	2565
q9	7450	7151	7345	7151
q10	3121	3316	2940	2940
q11	573	539	529	529
q12	699	833	661	661
q13	3604	3888	3245	3245
q14	280	312	298	298
q15	539	511	513	511
q16	1174	1151	1035	1035
q17	1218	1577	1381	1381
q18	7904	7791	7569	7569
q19	832	794	866	794
q20	2035	2022	1932	1932
q21	5037	4448	4300	4300
q22	1091	1070	1010	1010
Total cold run time: 53612 ms
Total hot run time: 51477 ms

@doris-robot
Copy link

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

query1	1075	462	408	408
query2	6549	1712	1773	1712
query3	6755	220	221	220
query4	26228	23608	23334	23334
query5	4422	635	495	495
query6	342	249	232	232
query7	4661	526	303	303
query8	309	264	268	264
query9	8692	2639	2646	2639
query10	478	362	305	305
query11	15708	15107	15054	15054
query12	175	114	110	110
query13	1682	541	418	418
query14	11242	9124	9118	9118
query15	209	202	179	179
query16	7700	666	490	490
query17	1219	744	657	657
query18	2041	424	328	328
query19	220	210	172	172
query20	127	131	121	121
query21	219	133	113	113
query22	4055	4127	4043	4043
query23	34060	32951	33021	32951
query24	8435	2372	2375	2372
query25	577	500	441	441
query26	1231	269	158	158
query27	2763	501	399	399
query28	4352	2237	2209	2209
query29	800	596	485	485
query30	290	225	202	202
query31	919	801	745	745
query32	79	72	70	70
query33	575	381	322	322
query34	835	866	521	521
query35	808	826	755	755
query36	978	1032	932	932
query37	121	102	83	83
query38	3515	3587	3499	3499
query39	1497	1426	1433	1426
query40	214	130	114	114
query41	66	63	63	63
query42	125	119	117	117
query43	491	515	484	484
query44	1323	863	845	845
query45	197	181	170	170
query46	862	1023	654	654
query47	1778	1831	1757	1757
query48	399	418	317	317
query49	771	530	409	409
query50	651	702	421	421
query51	3988	4036	3894	3894
query52	122	114	105	105
query53	242	275	188	188
query54	597	582	544	544
query55	94	87	88	87
query56	356	332	330	330
query57	1210	1213	1159	1159
query58	310	274	271	271
query59	2658	2643	2630	2630
query60	333	333	324	324
query61	172	156	159	156
query62	838	732	658	658
query63	228	195	191	191
query64	4434	1138	806	806
query65	4045	3975	3978	3975
query66	1106	436	341	341
query67	15438	15262	15185	15185
query68	6154	946	582	582
query69	492	312	288	288
query70	1312	1215	1232	1215
query71	533	342	306	306
query72	5962	4980	5218	4980
query73	685	621	366	366
query74	9112	9254	8935	8935
query75	3325	3360	2711	2711
query76	3246	1158	722	722
query77	501	396	303	303
query78	9586	9636	8879	8879
query79	2287	856	591	591
query80	613	548	500	500
query81	508	265	228	228
query82	372	157	137	137
query83	278	274	265	265
query84	270	118	109	109
query85	995	541	519	519
query86	378	404	293	293
query87	3818	3776	3627	3627
query88	3849	2220	2203	2203
query89	387	343	288	288
query90	1934	209	207	207
query91	170	164	133	133
query92	88	69	64	64
query93	1898	1001	638	638
query94	696	434	329	329
query95	387	315	377	315
query96	481	565	278	278
query97	2913	2995	2866	2866
query98	245	212	211	211
query99	1363	1408	1314	1314
Total cold run time: 273829 ms
Total hot run time: 188882 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190632 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 95bad35e3f8117ae103211c2a06162c377ec74f3, data reload: false

query1	1064	448	405	405
query2	6568	1697	1665	1665
query3	6758	224	225	224
query4	26441	23236	23479	23236
query5	4737	669	491	491
query6	342	252	240	240
query7	4679	503	313	313
query8	320	272	261	261
query9	8727	2608	2595	2595
query10	491	353	316	316
query11	15263	15020	14799	14799
query12	188	129	115	115
query13	1696	582	460	460
query14	11504	9442	9415	9415
query15	203	191	179	179
query16	7700	656	528	528
query17	1632	760	611	611
query18	2030	447	365	365
query19	226	277	194	194
query20	147	140	128	128
query21	232	144	117	117
query22	4606	4583	4585	4583
query23	34556	33975	33838	33838
query24	8480	2530	2567	2530
query25	611	558	500	500
query26	1444	274	164	164
query27	2761	539	376	376
query28	4378	2257	2207	2207
query29	802	667	519	519
query30	302	238	204	204
query31	933	850	790	790
query32	91	82	70	70
query33	618	436	344	344
query34	847	905	548	548
query35	817	912	811	811
query36	984	1096	999	999
query37	129	116	88	88
query38	3594	3644	3461	3461
query39	1476	1403	1408	1403
query40	219	131	119	119
query41	61	60	59	59
query42	118	113	116	113
query43	489	517	480	480
query44	1320	855	827	827
query45	183	180	174	174
query46	848	1010	627	627
query47	1774	1796	1743	1743
query48	400	443	318	318
query49	771	498	415	415
query50	641	698	400	400
query51	3870	4059	3985	3985
query52	109	114	101	101
query53	241	272	205	205
query54	606	593	522	522
query55	95	94	92	92
query56	362	327	324	324
query57	1195	1204	1123	1123
query58	282	283	274	274
query59	2629	2647	2588	2588
query60	356	353	337	337
query61	154	155	154	154
query62	807	785	672	672
query63	233	199	195	195
query64	4407	1120	830	830
query65	4050	3948	4006	3948
query66	1088	438	326	326
query67	15537	15407	15049	15049
query68	7948	923	598	598
query69	495	348	291	291
query70	1412	1283	1310	1283
query71	462	340	328	328
query72	5930	4809	4906	4809
query73	641	575	364	364
query74	9158	9039	8834	8834
query75	3755	3400	2845	2845
query76	3438	1177	758	758
query77	819	407	321	321
query78	9363	9604	8914	8914
query79	2738	814	600	600
query80	624	566	517	517
query81	516	267	225	225
query82	454	171	135	135
query83	299	276	265	265
query84	300	118	97	97
query85	929	471	422	422
query86	389	340	322	322
query87	3727	3782	3713	3713
query88	3847	2242	2234	2234
query89	429	347	300	300
query90	1984	224	221	221
query91	170	166	133	133
query92	82	71	68	68
query93	2107	969	637	637
query94	711	441	330	330
query95	410	323	325	323
query96	497	582	286	286
query97	2935	2980	2860	2860
query98	242	216	211	211
query99	1434	1427	1296	1296
Total cold run time: 279467 ms
Total hot run time: 190632 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.09	0.05	0.05
query3	0.26	0.09	0.08
query4	1.60	0.12	0.12
query5	0.28	0.26	0.25
query6	1.18	0.68	0.64
query7	0.03	0.03	0.03
query8	0.06	0.04	0.05
query9	0.64	0.53	0.51
query10	0.58	0.60	0.57
query11	0.17	0.11	0.11
query12	0.16	0.13	0.13
query13	0.64	0.62	0.62
query14	1.05	1.05	1.06
query15	0.87	0.85	0.85
query16	0.41	0.42	0.41
query17	1.07	1.07	1.06
query18	0.22	0.20	0.20
query19	1.92	1.87	1.86
query20	0.02	0.01	0.02
query21	15.42	0.92	0.58
query22	0.77	1.15	0.74
query23	14.88	1.38	0.67
query24	7.22	1.72	0.55
query25	0.49	0.22	0.07
query26	0.51	0.17	0.13
query27	0.07	0.06	0.06
query28	9.47	1.37	0.93
query29	12.55	3.98	3.30
query30	0.30	0.14	0.12
query31	2.83	0.60	0.39
query32	3.27	0.55	0.49
query33	3.18	3.32	3.07
query34	16.26	5.42	4.85
query35	4.93	4.91	4.91
query36	0.67	0.50	0.50
query37	0.11	0.08	0.07
query38	0.07	0.05	0.04
query39	0.04	0.03	0.04
query40	0.19	0.15	0.15
query41	0.09	0.04	0.03
query42	0.04	0.04	0.03
query43	0.04	0.04	0.03
Total cold run time: 104.71 s
Total hot run time: 30.38 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 66.67% (12/18) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.57% (17788/33834)
Line Coverage 37.77% (161685/428029)
Region Coverage 32.23% (123359/382692)
Branch Coverage 33.65% (54170/161003)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 66.67% (12/18) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.23% (23625/33166)
Line Coverage 57.66% (246661/427772)
Region Coverage 52.72% (204379/387639)
Branch Coverage 54.60% (88397/161892)

@felixwluo
Copy link
Contributor Author

run cloud_p0

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 66.67% (12/18) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.23% (23625/33166)
Line Coverage 57.66% (246661/427772)
Region Coverage 52.72% (204379/387639)
Branch Coverage 54.60% (88397/161892)

@dataroaring
Copy link
Contributor

run buildall

RETURN_IF_ERROR(_rowset_builder->init());
_rowset_writer = _rowset_builder->rowset_writer();

auto tablet_res = ExecEnv::get_tablet(_req.tablet_id);
Copy link
Contributor

Choose a reason for hiding this comment

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

u are absolutely right!

However, personally, for variables that are only used within an if statement, I would adopt this approach:
if (auto tablet_res = ExecEnv::get_tablet(_req.tablet_id); tablet_res.has_value()) {...}

if u think so, u can rewrite it~

Copy link
Contributor Author

Choose a reason for hiding this comment

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

That's a very good suggestion, I will modify it.

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 66.67% (12/18) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.81% (18285/34621)
Line Coverage 38.19% (166282/435450)
Region Coverage 33.18% (129274/389587)
Branch Coverage 33.91% (55462/163578)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 66.67% (12/18) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.57% (24349/34021)
Line Coverage 58.06% (253193/436126)
Region Coverage 53.42% (211071/395098)
Branch Coverage 54.73% (90107/164653)

@felixwluo
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17872	5289	5080	5080
q2	2022	310	201	201
q3	10253	1284	721	721
q4	10244	957	398	398
q5	7574	2469	2313	2313
q6	180	167	136	136
q7	953	776	640	640
q8	9349	1354	1134	1134
q9	6877	5062	5090	5062
q10	6876	2231	1832	1832
q11	493	307	285	285
q12	337	374	244	244
q13	17785	3656	3028	3028
q14	234	246	213	213
q15	596	524	515	515
q16	1000	991	947	947
q17	594	874	358	358
q18	7392	7403	7510	7403
q19	1388	995	578	578
q20	357	362	238	238
q21	4794	3525	3224	3224
q22	1124	1088	1052	1052
Total cold run time: 108294 ms
Total hot run time: 35602 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5481	5468	5432	5432
q2	253	338	239	239
q3	2411	3164	2467	2467
q4	1434	1863	1481	1481
q5	4597	4493	4410	4410
q6	210	162	127	127
q7	1966	1888	1812	1812
q8	2642	2518	2812	2518
q9	7538	7195	7133	7133
q10	2936	3095	2676	2676
q11	577	511	500	500
q12	659	714	560	560
q13	3339	3667	3064	3064
q14	294	282	260	260
q15	544	506	491	491
q16	1006	1037	997	997
q17	1102	1479	1337	1337
q18	7223	7130	7000	7000
q19	804	821	833	821
q20	1891	1945	1803	1803
q21	4772	4430	4328	4328
q22	1091	1047	1007	1007
Total cold run time: 52770 ms
Total hot run time: 50463 ms

@doris-robot
Copy link

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

query1	1022	407	399	399
query2	6593	1708	1689	1689
query3	6754	225	233	225
query4	26234	23772	23125	23125
query5	4482	637	484	484
query6	343	237	217	217
query7	4649	495	296	296
query8	306	252	244	244
query9	8726	2597	2575	2575
query10	521	347	284	284
query11	15780	15077	14762	14762
query12	182	127	112	112
query13	1672	561	443	443
query14	10829	9436	9252	9252
query15	195	185	177	177
query16	7239	692	522	522
query17	1245	780	638	638
query18	2025	431	335	335
query19	228	207	186	186
query20	132	128	120	120
query21	219	137	115	115
query22	3945	4025	4031	4025
query23	33752	33085	32852	32852
query24	8500	2453	2392	2392
query25	595	519	440	440
query26	1241	271	164	164
query27	2755	502	357	357
query28	4407	2192	2194	2192
query29	832	603	486	486
query30	301	226	198	198
query31	926	810	741	741
query32	80	75	72	72
query33	592	371	325	325
query34	802	835	528	528
query35	819	818	758	758
query36	953	1010	903	903
query37	121	110	85	85
query38	3488	3538	3471	3471
query39	1462	1467	1409	1409
query40	229	124	119	119
query41	62	60	61	60
query42	130	115	119	115
query43	504	496	449	449
query44	1248	748	742	742
query45	185	179	176	176
query46	872	984	646	646
query47	1758	1782	1679	1679
query48	396	421	329	329
query49	781	492	395	395
query50	645	720	411	411
query51	3925	3916	3943	3916
query52	120	114	104	104
query53	245	270	188	188
query54	303	303	272	272
query55	89	87	82	82
query56	332	323	343	323
query57	1164	1170	1126	1126
query58	297	281	278	278
query59	2504	2669	2561	2561
query60	346	328	328	328
query61	158	162	158	158
query62	812	713	692	692
query63	239	200	207	200
query64	4538	1161	983	983
query65	4013	3940	3940	3940
query66	1176	464	372	372
query67	15341	15049	14998	14998
query68	5347	959	615	615
query69	509	329	296	296
query70	1333	1289	1284	1284
query71	441	349	327	327
query72	6085	4970	4886	4886
query73	660	613	374	374
query74	9028	8984	8688	8688
query75	3301	3300	2758	2758
query76	3296	1122	738	738
query77	522	442	314	314
query78	9422	9646	8898	8898
query79	2229	858	603	603
query80	719	561	506	506
query81	490	268	230	230
query82	210	163	134	134
query83	262	268	253	253
query84	261	113	91	91
query85	873	482	436	436
query86	385	329	281	281
query87	3787	3744	3607	3607
query88	3255	2271	2263	2263
query89	372	325	292	292
query90	1982	225	220	220
query91	168	163	143	143
query92	85	73	65	65
query93	2238	1012	647	647
query94	709	448	331	331
query95	409	325	316	316
query96	496	566	280	280
query97	2924	2982	2844	2844
query98	236	213	216	213
query99	1312	1413	1360	1360
Total cold run time: 270705 ms
Total hot run time: 187533 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.05
query2	0.09	0.05	0.05
query3	0.26	0.09	0.09
query4	1.61	0.12	0.11
query5	0.28	0.25	0.25
query6	1.18	0.65	0.64
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.59	0.53	0.53
query10	0.57	0.58	0.57
query11	0.17	0.12	0.11
query12	0.15	0.12	0.12
query13	0.63	0.61	0.59
query14	1.00	0.99	1.00
query15	0.85	0.82	0.84
query16	0.40	0.39	0.39
query17	1.06	1.04	1.04
query18	0.21	0.20	0.19
query19	1.95	1.87	1.82
query20	0.02	0.01	0.01
query21	15.44	0.21	0.13
query22	5.10	0.07	0.05
query23	15.73	0.27	0.10
query24	2.97	1.32	0.44
query25	0.08	0.07	0.04
query26	0.14	0.12	0.14
query27	0.08	0.06	0.05
query28	4.91	1.15	0.92
query29	12.57	3.92	3.24
query30	0.28	0.14	0.11
query31	2.81	0.60	0.38
query32	3.23	0.55	0.47
query33	3.01	3.02	3.12
query34	15.89	5.16	4.63
query35	4.54	4.55	4.55
query36	0.67	0.49	0.49
query37	0.09	0.07	0.07
query38	0.07	0.04	0.04
query39	0.03	0.03	0.04
query40	0.17	0.14	0.13
query41	0.09	0.03	0.04
query42	0.04	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 99.13 s
Total hot run time: 27.54 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 64.71% (11/17) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.81% (18285/34621)
Line Coverage 38.19% (166281/435457)
Region Coverage 33.19% (129313/389600)
Branch Coverage 33.91% (55466/163590)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 64.71% (11/17) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.61% (24363/34021)
Line Coverage 58.12% (253486/436131)
Region Coverage 53.59% (211727/395111)
Branch Coverage 54.81% (90261/164665)

@felixwluo
Copy link
Contributor Author

run cloud_p0

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 64.71% (11/17) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.61% (24363/34021)
Line Coverage 58.12% (253486/436131)
Region Coverage 53.59% (211727/395111)
Branch Coverage 54.81% (90261/164665)

@dataroaring
Copy link
Contributor

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17618	4249	4056	4056
q2	2036	367	266	266
q3	10117	1350	722	722
q4	10235	913	320	320
q5	7525	2107	1854	1854
q6	229	167	139	139
q7	938	792	656	656
q8	9297	1429	1201	1201
q9	4922	4655	4589	4589
q10	6860	1819	1427	1427
q11	517	300	288	288
q12	734	718	640	640
q13	17774	3863	3092	3092
q14	295	301	266	266
q15	599	517	499	499
q16	691	690	644	644
q17	675	809	536	536
q18	6765	6351	6821	6351
q19	1200	1041	682	682
q20	435	412	266	266
q21	3289	2612	2514	2514
q22	1165	1098	1026	1026
Total cold run time: 103916 ms
Total hot run time: 32034 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4265	4271	4210	4210
q2	328	429	314	314
q3	2208	2816	2437	2437
q4	1429	1913	1410	1410
q5	4842	4252	4243	4243
q6	218	173	127	127
q7	1999	2013	1764	1764
q8	2538	2409	2334	2334
q9	7247	7208	6992	6992
q10	2836	2662	2234	2234
q11	601	490	459	459
q12	704	755	598	598
q13	3639	4309	3222	3222
q14	269	279	260	260
q15	524	491	472	472
q16	624	661	597	597
q17	1119	1370	1392	1370
q18	7355	7305	7245	7245
q19	856	837	789	789
q20	1870	1941	1793	1793
q21	4576	4289	4130	4130
q22	1053	996	971	971
Total cold run time: 51100 ms
Total hot run time: 47971 ms

@doris-robot
Copy link

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

query5	4420	584	456	456
query6	370	236	227	227
query7	4225	454	263	263
query8	347	249	250	249
query9	8758	2655	2685	2655
query10	495	378	313	313
query11	15284	14999	14791	14791
query12	174	114	112	112
query13	1258	486	392	392
query14	6157	3010	2751	2751
query14_1	2716	2649	2655	2649
query15	203	195	177	177
query16	1050	488	455	455
query17	1111	694	584	584
query18	2455	437	347	347
query19	233	230	199	199
query20	124	122	120	120
query21	219	147	122	122
query22	3823	4099	3797	3797
query23	15964	15443	15314	15314
query23_1	15420	15396	15386	15386
query24	7321	1544	1191	1191
query24_1	1183	1186	1194	1186
query25	533	451	383	383
query26	1240	261	153	153
query27	2780	444	287	287
query28	4544	2134	2116	2116
query29	761	528	432	432
query30	309	237	207	207
query31	786	678	573	573
query32	76	72	65	65
query33	527	328	278	278
query34	904	913	526	526
query35	725	751	672	672
query36	852	872	820	820
query37	132	91	80	80
query38	2781	2707	2772	2707
query39	790	744	714	714
query39_1	706	700	709	700
query40	216	132	113	113
query41	65	66	64	64
query42	107	108	105	105
query43	446	486	432	432
query44	1365	723	721	721
query45	186	177	175	175
query46	863	948	587	587
query47	1345	1376	1369	1369
query48	308	317	236	236
query49	600	449	325	325
query50	659	268	202	202
query51	3730	3762	3853	3762
query52	110	110	100	100
query53	299	320	271	271
query54	282	263	250	250
query55	77	75	75	75
query56	281	298	292	292
query57	1029	1004	937	937
query58	270	246	256	246
query59	2021	2185	2009	2009
query60	316	321	301	301
query61	170	163	164	163
query62	392	352	316	316
query63	305	269	277	269
query64	4961	1307	1010	1010
query65	3769	3716	3728	3716
query66	1457	435	320	320
query67	14909	15632	14505	14505
query68	3261	1041	716	716
query69	509	358	322	322
query70	1044	937	944	937
query71	351	310	286	286
query72	6294	3499	3474	3474
query73	707	718	299	299
query74	8863	8952	8554	8554
query75	2835	2841	2438	2438
query76	3648	1068	665	665
query77	522	369	288	288
query78	9731	9816	9135	9135
query79	1720	900	576	576
query80	1589	571	499	499
query81	559	266	234	234
query82	410	145	109	109
query83	353	259	235	235
query84	268	119	99	99
query85	952	526	481	481
query86	391	331	324	324
query87	2881	2923	2756	2756
query88	3230	2217	2213	2213
query89	385	344	335	335
query90	1964	156	153	153
query91	178	165	144	144
query92	72	70	63	63
query93	1083	899	526	526
query94	660	332	293	293
query95	570	378	315	315
query96	588	466	206	206
query97	2356	2334	2293	2293
query98	228	197	200	197
query99	593	577	507	507
Total cold run time: 250285 ms
Total hot run time: 172402 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.10	0.04	0.04
query3	0.26	0.09	0.08
query4	1.60	0.11	0.12
query5	0.27	0.27	0.26
query6	1.14	0.67	0.65
query7	0.03	0.02	0.03
query8	0.06	0.04	0.04
query9	0.57	0.50	0.48
query10	0.55	0.55	0.55
query11	0.15	0.09	0.10
query12	0.14	0.11	0.11
query13	0.60	0.58	0.59
query14	0.95	0.94	0.95
query15	0.79	0.79	0.78
query16	0.41	0.41	0.39
query17	1.07	1.05	1.02
query18	0.23	0.21	0.22
query19	1.93	1.90	1.85
query20	0.01	0.02	0.01
query21	15.44	0.27	0.13
query22	5.07	0.06	0.05
query23	15.87	0.30	0.10
query24	1.43	0.66	0.32
query25	0.08	0.08	0.06
query26	0.15	0.14	0.13
query27	0.09	0.05	0.06
query28	3.90	1.05	0.88
query29	12.64	3.97	3.13
query30	0.28	0.14	0.12
query31	2.82	0.64	0.39
query32	3.23	0.56	0.45
query33	2.91	3.07	3.05
query34	16.88	5.12	4.42
query35	4.45	4.51	4.52
query36	0.67	0.49	0.50
query37	0.11	0.07	0.06
query38	0.08	0.04	0.04
query39	0.04	0.03	0.03
query40	0.17	0.14	0.13
query41	0.09	0.04	0.03
query42	0.04	0.02	0.03
query43	0.04	0.03	0.03
Total cold run time: 97.4 s
Total hot run time: 26.88 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 64.71% (11/17) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 53.08% (18978/35754)
Line Coverage 39.10% (175741/449481)
Region Coverage 33.66% (136128/404473)
Branch Coverage 34.63% (58752/169655)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 64.71% (11/17) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 73.76% (25800/34980)
Line Coverage 61.12% (274183/448627)
Region Coverage 56.14% (229385/408596)
Branch Coverage 57.94% (98639/170249)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

[Bug] be disk usage out of control, because of memtable on sink

7 participants