Skip to content

Conversation

@freemandealer
Copy link
Contributor

This is a prototype commit to achieve the goal. The user interface must
be refined in the future, use session vars or warm up properties.

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

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 Jan 4, 2026

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?

@freemandealer
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17631	4183	4055	4055
q2	2018	375	245	245
q3	10144	1290	758	758
q4	10232	939	341	341
q5	7883	2155	1907	1907
q6	239	184	144	144
q7	948	809	662	662
q8	9296	1434	1124	1124
q9	5481	4791	4678	4678
q10	6821	1814	1425	1425
q11	505	318	286	286
q12	755	759	599	599
q13	17777	3811	3083	3083
q14	302	305	275	275
q15	597	530	516	516
q16	693	697	636	636
q17	703	738	608	608
q18	6592	6608	6480	6480
q19	1099	965	609	609
q20	431	363	259	259
q21	3104	2573	2408	2408
q22	1090	1027	1014	1014
Total cold run time: 104341 ms
Total hot run time: 32112 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4090	4026	4055	4026
q2	337	404	313	313
q3	2079	2624	2243	2243
q4	1310	1749	1344	1344
q5	4074	4082	4043	4043
q6	211	174	133	133
q7	1894	1947	1929	1929
q8	2587	2446	2371	2371
q9	7337	7110	7139	7110
q10	2526	2790	2318	2318
q11	542	499	460	460
q12	740	761	611	611
q13	3612	4017	3620	3620
q14	290	324	292	292
q15	537	501	493	493
q16	659	699	658	658
q17	1152	1363	1364	1363
q18	7934	7938	7904	7904
q19	957	953	954	953
q20	1947	2075	2030	2030
q21	5006	4571	4159	4159
q22	1123	1023	1007	1007
Total cold run time: 50944 ms
Total hot run time: 49380 ms

@doris-robot
Copy link

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

query5	4583	592	427	427
query6	329	233	207	207
query7	4227	455	266	266
query8	331	248	231	231
query9	8775	2676	2690	2676
query10	483	371	321	321
query11	15431	15276	14918	14918
query12	183	113	110	110
query13	1252	484	399	399
query14	6098	2954	2708	2708
query14_1	2583	2582	2589	2582
query15	200	194	171	171
query16	999	462	430	430
query17	1074	692	576	576
query18	2497	433	338	338
query19	254	213	191	191
query20	120	117	115	115
query21	220	136	123	123
query22	4084	4175	4241	4175
query23	16063	15600	15359	15359
query23_1	15483	15405	15652	15405
query24	7492	1595	1232	1232
query24_1	1210	1201	1246	1201
query25	532	443	388	388
query26	1230	264	155	155
query27	2769	451	293	293
query28	4578	2211	2201	2201
query29	747	511	419	419
query30	309	241	211	211
query31	801	633	556	556
query32	80	70	62	62
query33	520	336	302	302
query34	895	887	559	559
query35	748	797	740	740
query36	849	914	797	797
query37	127	91	81	81
query38	2661	2702	2718	2702
query39	793	752	738	738
query39_1	702	710	726	710
query40	227	138	135	135
query41	89	82	87	82
query42	106	115	110	110
query43	465	442	402	402
query44	1399	772	765	765
query45	186	186	179	179
query46	931	983	622	622
query47	1463	1464	1323	1323
query48	313	328	263	263
query49	649	402	328	328
query50	655	277	225	225
query51	3847	3762	3916	3762
query52	100	105	94	94
query53	295	324	272	272
query54	285	265	244	244
query55	79	79	70	70
query56	282	307	283	283
query57	1030	1005	912	912
query58	265	257	254	254
query59	2062	2200	2052	2052
query60	318	309	299	299
query61	159	164	162	162
query62	408	351	328	328
query63	297	265	276	265
query64	4948	1297	980	980
query65	3749	3769	3722	3722
query66	1429	425	317	317
query67	15646	15176	15566	15176
query68	2773	1049	775	775
query69	438	366	312	312
query70	1010	916	925	916
query71	315	300	271	271
query72	6134	3524	3934	3524
query73	612	729	323	323
query74	8893	8733	8547	8547
query75	2820	2846	2542	2542
query76	2871	1080	686	686
query77	364	394	296	296
query78	9870	9926	9115	9115
query79	1092	986	641	641
query80	727	649	536	536
query81	500	271	233	233
query82	1347	146	112	112
query83	369	262	247	247
query84	258	133	111	111
query85	1005	515	470	470
query86	374	289	299	289
query87	2910	2839	2755	2755
query88	3389	2323	2310	2310
query89	408	353	321	321
query90	1866	154	160	154
query91	172	166	139	139
query92	76	67	66	66
query93	985	962	568	568
query94	449	332	297	297
query95	579	378	302	302
query96	609	478	210	210
query97	2336	2338	2271	2271
query98	208	207	220	207
query99	588	587	533	533
Total cold run time: 249364 ms
Total hot run time: 173962 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.09	0.05	0.05
query3	0.26	0.08	0.09
query4	1.60	0.11	0.10
query5	0.27	0.26	0.24
query6	1.14	0.66	0.65
query7	0.03	0.02	0.02
query8	0.06	0.04	0.04
query9	0.57	0.50	0.49
query10	0.53	0.55	0.55
query11	0.15	0.10	0.10
query12	0.17	0.13	0.13
query13	0.62	0.60	0.60
query14	0.99	0.99	0.98
query15	0.79	0.80	0.80
query16	0.42	0.40	0.42
query17	1.03	1.10	1.06
query18	0.24	0.22	0.22
query19	1.90	1.78	1.86
query20	0.01	0.02	0.02
query21	15.53	0.30	0.14
query22	4.78	0.04	0.04
query23	16.10	0.29	0.11
query24	1.00	0.30	0.18
query25	0.12	0.06	0.05
query26	0.13	0.13	0.14
query27	0.09	0.04	0.05
query28	3.04	1.04	0.89
query29	12.57	3.87	3.17
query30	0.27	0.16	0.11
query31	2.82	0.62	0.38
query32	3.24	0.55	0.46
query33	3.01	3.03	3.06
query34	16.86	5.12	4.54
query35	4.50	4.44	4.48
query36	0.67	0.50	0.49
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.04	0.04	0.04
query40	0.16	0.14	0.13
query41	0.09	0.04	0.03
query42	0.04	0.02	0.02
query43	0.04	0.03	0.04
Total cold run time: 96.21 s
Total hot run time: 26.92 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 0.00% (0/3) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 53.39% (18964/35518)
Line Coverage 39.27% (175989/448156)
Region Coverage 33.81% (136070/402511)
Branch Coverage 34.76% (58803/169160)

@freemandealer
Copy link
Contributor Author

run external

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.16% (25056/34723)
Line Coverage 58.90% (263289/446984)
Region Coverage 53.75% (218582/406680)
Branch Coverage 55.32% (93894/169728)

@freemandealer
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17630	4301	4091	4091
q2	2053	369	249	249
q3	10365	1334	732	732
q4	10336	868	318	318
q5	9291	2112	1882	1882
q6	210	176	138	138
q7	915	791	657	657
q8	9299	1439	1138	1138
q9	5156	4637	4563	4563
q10	6845	1806	1418	1418
q11	540	305	281	281
q12	730	738	579	579
q13	17807	3864	3135	3135
q14	301	303	285	285
q15	584	521	501	501
q16	684	682	625	625
q17	867	832	463	463
q18	6699	6263	7143	6263
q19	1519	1073	649	649
q20	413	388	263	263
q21	3234	2710	2565	2565
q22	1119	1130	1043	1043
Total cold run time: 106597 ms
Total hot run time: 31838 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4385	4311	4173	4173
q2	322	423	333	333
q3	2349	2862	2451	2451
q4	1432	1820	1469	1469
q5	4440	4292	4490	4292
q6	223	169	127	127
q7	1932	1928	1758	1758
q8	2725	2357	2424	2357
q9	7129	7230	7195	7195
q10	2435	2764	2306	2306
q11	567	500	471	471
q12	705	707	625	625
q13	3352	3790	3045	3045
q14	262	278	253	253
q15	530	499	485	485
q16	617	652	605	605
q17	1094	1314	1375	1314
q18	7547	7493	7298	7298
q19	835	816	809	809
q20	1866	1945	1819	1819
q21	4516	4308	4138	4138
q22	1058	1048	979	979
Total cold run time: 50321 ms
Total hot run time: 48302 ms

@doris-robot
Copy link

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

query5	4393	599	466	466
query6	347	242	218	218
query7	4219	460	263	263
query8	339	244	237	237
query9	8768	2615	2640	2615
query10	539	378	328	328
query11	15264	15345	14842	14842
query12	175	115	111	111
query13	1269	508	390	390
query14	6156	2983	2761	2761
query14_1	2693	2633	2694	2633
query15	202	195	177	177
query16	1018	479	458	458
query17	1112	687	592	592
query18	2495	439	346	346
query19	233	225	201	201
query20	121	116	116	116
query21	221	140	119	119
query22	4000	3941	3898	3898
query23	16196	15676	15213	15213
query23_1	15614	15302	15273	15273
query24	7561	1558	1187	1187
query24_1	1207	1190	1221	1190
query25	566	482	431	431
query26	1242	265	160	160
query27	2762	458	291	291
query28	4529	2145	2137	2137
query29	784	559	461	461
query30	317	252	213	213
query31	807	626	575	575
query32	86	76	71	71
query33	557	343	300	300
query34	910	875	545	545
query35	755	840	704	704
query36	877	879	756	756
query37	127	95	74	74
query38	2753	2778	2661	2661
query39	767	752	752	752
query39_1	730	727	683	683
query40	225	133	116	116
query41	67	61	63	61
query42	110	101	102	101
query43	465	483	443	443
query44	1319	764	730	730
query45	189	182	177	177
query46	855	951	602	602
query47	1391	1489	1306	1306
query48	320	331	242	242
query49	607	410	320	320
query50	646	278	206	206
query51	3810	3765	3761	3761
query52	110	109	94	94
query53	291	334	275	275
query54	281	256	246	246
query55	78	75	79	75
query56	286	298	305	298
query57	1027	979	955	955
query58	258	250	242	242
query59	2143	2134	2172	2134
query60	321	325	303	303
query61	155	162	156	156
query62	393	349	305	305
query63	298	268	272	268
query64	4909	1303	1002	1002
query65	3795	3720	3720	3720
query66	1432	419	300	300
query67	15099	15062	15444	15062
query68	7293	984	700	700
query69	495	347	303	303
query70	1017	972	957	957
query71	377	305	290	290
query72	6068	3355	3431	3355
query73	768	720	312	312
query74	8836	8783	8575	8575
query75	2813	2812	2458	2458
query76	3887	1060	652	652
query77	534	375	276	276
query78	9814	9861	9223	9223
query79	1484	910	598	598
query80	681	591	500	500
query81	516	268	233	233
query82	216	143	108	108
query83	263	256	238	238
query84	261	121	101	101
query85	901	509	456	456
query86	393	325	325	325
query87	2833	2880	2769	2769
query88	3135	2221	2204	2204
query89	395	356	337	337
query90	2160	151	153	151
query91	175	164	141	141
query92	85	74	63	63
query93	1281	892	534	534
query94	611	327	286	286
query95	580	370	300	300
query96	569	455	205	205
query97	2324	2364	2311	2311
query98	233	199	202	199
query99	577	570	509	509
Total cold run time: 254153 ms
Total hot run time: 172883 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.09	0.05	0.04
query3	0.26	0.08	0.08
query4	1.61	0.11	0.11
query5	0.27	0.25	0.28
query6	1.14	0.68	0.65
query7	0.03	0.03	0.02
query8	0.05	0.04	0.05
query9	0.57	0.50	0.50
query10	0.56	0.55	0.54
query11	0.14	0.10	0.10
query12	0.14	0.11	0.11
query13	0.61	0.59	0.59
query14	0.95	0.95	0.96
query15	0.79	0.78	0.79
query16	0.42	0.41	0.42
query17	0.99	1.02	1.07
query18	0.23	0.22	0.21
query19	1.90	1.87	1.84
query20	0.02	0.01	0.01
query21	15.43	0.27	0.14
query22	5.42	0.05	0.05
query23	16.03	0.28	0.10
query24	0.94	0.25	0.72
query25	0.10	0.08	0.06
query26	0.15	0.13	0.14
query27	0.08	0.05	0.06
query28	4.17	1.06	0.88
query29	12.64	3.88	3.15
query30	0.28	0.15	0.12
query31	2.81	0.65	0.40
query32	3.23	0.56	0.46
query33	3.02	3.00	3.06
query34	16.84	5.13	4.49
query35	4.47	4.44	4.49
query36	0.65	0.50	0.48
query37	0.10	0.06	0.06
query38	0.07	0.04	0.03
query39	0.05	0.03	0.04
query40	0.18	0.13	0.14
query41	0.09	0.04	0.03
query42	0.04	0.03	0.02
query43	0.05	0.04	0.03
Total cold run time: 97.67 s
Total hot run time: 26.83 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 0.00% (0/3) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 53.30% (18978/35605)
Line Coverage 39.25% (176061/448576)
Region Coverage 33.78% (136245/403299)
Branch Coverage 34.75% (58829/169310)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.22% (25069/34713)
Line Coverage 58.94% (263417/446951)
Region Coverage 53.78% (218704/406670)
Branch Coverage 55.35% (93941/169728)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.04% (25083/34816)
Line Coverage 58.72% (262761/447489)
Region Coverage 53.50% (218085/407630)
Branch Coverage 55.11% (93653/169938)

@freemandealer
Copy link
Contributor Author

run cloud_p0

@freemandealer
Copy link
Contributor Author

run vault_p0

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.05% (25086/34816)
Line Coverage 58.72% (262779/447489)
Region Coverage 53.52% (218158/407630)
Branch Coverage 55.12% (93676/169938)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.06% (25087/34816)
Line Coverage 58.73% (262802/447489)
Region Coverage 53.52% (218179/407630)
Branch Coverage 55.13% (93680/169938)

1 similar comment
@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.06% (25087/34816)
Line Coverage 58.73% (262802/447489)
Region Coverage 53.52% (218179/407630)
Branch Coverage 55.13% (93680/169938)

@freemandealer
Copy link
Contributor Author

run p0

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.08% (25097/34816)
Line Coverage 58.78% (263016/447489)
Region Coverage 53.56% (218324/407630)
Branch Coverage 55.17% (93756/169938)

this is a prototype commit to achieve the goal.
the user interface must be refined in the future,
use session vars or warm up properties.

Signed-off-by: zhengyu <[email protected]>
Signed-off-by: zhengyu <[email protected]>
@freemandealer
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17636	4209	4071	4071
q2	2071	359	253	253
q3	10102	1293	711	711
q4	10225	917	322	322
q5	7528	2139	1873	1873
q6	240	172	139	139
q7	967	796	656	656
q8	9283	1439	1183	1183
q9	5123	4579	4541	4541
q10	6838	1803	1415	1415
q11	527	301	283	283
q12	734	748	602	602
q13	17774	3780	3073	3073
q14	286	298	268	268
q15	586	512	499	499
q16	670	675	625	625
q17	678	792	562	562
q18	6952	6488	6986	6488
q19	1467	988	612	612
q20	409	397	270	270
q21	3241	2676	2508	2508
q22	1171	1114	1079	1079
Total cold run time: 104508 ms
Total hot run time: 32033 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4371	4342	4294	4294
q2	325	398	325	325
q3	2247	2749	2404	2404
q4	1385	1910	1436	1436
q5	4582	4473	4538	4473
q6	216	168	127	127
q7	1993	2130	1748	1748
q8	2545	2408	2355	2355
q9	7187	7075	7080	7075
q10	2570	2721	2228	2228
q11	564	474	464	464
q12	698	728	632	632
q13	3492	3824	3115	3115
q14	268	301	267	267
q15	539	498	485	485
q16	649	664	616	616
q17	1114	1270	1288	1270
q18	7407	7337	7274	7274
q19	868	813	820	813
q20	1886	1973	1798	1798
q21	4506	4244	4105	4105
q22	1087	1022	988	988
Total cold run time: 50499 ms
Total hot run time: 48292 ms

@doris-robot
Copy link

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

query5	4429	576	436	436
query6	373	243	223	223
query7	4220	464	260	260
query8	351	264	243	243
query9	8780	2666	2660	2660
query10	532	376	330	330
query11	15329	15054	14877	14877
query12	173	119	113	113
query13	1276	477	421	421
query14	5984	2954	2738	2738
query14_1	2669	2599	2616	2599
query15	203	199	175	175
query16	997	474	469	469
query17	1108	679	579	579
query18	2522	442	355	355
query19	236	229	199	199
query20	129	118	119	118
query21	224	147	124	124
query22	4018	4051	3858	3858
query23	15992	15426	15225	15225
query23_1	15456	15582	15614	15582
query24	7500	1554	1157	1157
query24_1	1189	1205	1194	1194
query25	561	489	425	425
query26	1245	270	157	157
query27	2757	479	289	289
query28	4576	2169	2132	2132
query29	836	565	465	465
query30	316	242	212	212
query31	827	652	558	558
query32	79	72	69	69
query33	551	347	302	302
query34	926	899	533	533
query35	744	777	764	764
query36	844	867	771	771
query37	128	91	75	75
query38	2723	2688	2667	2667
query39	777	751	718	718
query39_1	708	713	717	713
query40	217	137	114	114
query41	66	63	63	63
query42	105	101	99	99
query43	432	434	423	423
query44	1295	727	720	720
query45	186	184	172	172
query46	857	941	596	596
query47	1465	1404	1409	1404
query48	309	337	242	242
query49	602	424	327	327
query50	629	269	195	195
query51	3777	3842	3764	3764
query52	107	108	93	93
query53	290	326	268	268
query54	280	252	246	246
query55	76	79	73	73
query56	312	285	285	285
query57	1013	965	938	938
query58	272	254	281	254
query59	2179	2165	2055	2055
query60	328	323	306	306
query61	158	151	156	151
query62	401	333	298	298
query63	296	265	262	262
query64	5053	1304	1001	1001
query65	3823	3748	3686	3686
query66	1427	432	292	292
query67	16277	15214	14762	14762
query68	6878	982	709	709
query69	499	350	309	309
query70	1052	964	908	908
query71	367	310	282	282
query72	6012	3431	3409	3409
query73	771	723	299	299
query74	8701	8723	8585	8585
query75	2806	2825	2457	2457
query76	3868	1046	642	642
query77	543	389	287	287
query78	9731	9892	9131	9131
query79	1585	852	603	603
query80	725	546	473	473
query81	540	266	228	228
query82	416	149	112	112
query83	261	260	248	248
query84	256	121	98	98
query85	914	507	452	452
query86	441	298	296	296
query87	2831	2859	2773	2773
query88	3238	2260	2240	2240
query89	381	355	331	331
query90	2061	152	151	151
query91	171	166	144	144
query92	81	71	60	60
query93	1408	914	535	535
query94	611	328	294	294
query95	573	389	300	300
query96	590	458	204	204
query97	2328	2390	2297	2297
query98	247	199	198	198
query99	566	571	502	502
Total cold run time: 255076 ms
Total hot run time: 172662 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.05
query2	0.09	0.04	0.04
query3	0.26	0.09	0.09
query4	1.61	0.11	0.12
query5	0.28	0.25	0.28
query6	1.15	0.65	0.65
query7	0.04	0.02	0.03
query8	0.05	0.04	0.05
query9	0.58	0.51	0.49
query10	0.54	0.57	0.56
query11	0.15	0.10	0.10
query12	0.15	0.11	0.11
query13	0.60	0.59	0.58
query14	0.97	0.95	0.94
query15	0.80	0.78	0.79
query16	0.40	0.40	0.41
query17	1.07	1.06	1.06
query18	0.24	0.21	0.21
query19	1.92	1.85	1.83
query20	0.02	0.01	0.01
query21	15.48	0.22	0.14
query22	5.80	0.05	0.05
query23	16.58	0.28	0.11
query24	0.95	0.34	0.65
query25	0.06	0.08	0.09
query26	0.15	0.14	0.14
query27	0.09	0.05	0.06
query28	4.05	1.07	0.88
query29	12.61	4.00	3.21
query30	0.28	0.14	0.12
query31	2.82	0.66	0.40
query32	3.23	0.55	0.46
query33	2.95	2.97	3.08
query34	16.86	5.14	4.47
query35	4.50	4.52	4.53
query36	0.65	0.50	0.49
query37	0.11	0.06	0.06
query38	0.07	0.04	0.03
query39	0.05	0.03	0.03
query40	0.16	0.14	0.13
query41	0.08	0.03	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 98.58 s
Total hot run time: 27.08 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 0.00% (0/3) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 53.21% (18964/35637)
Line Coverage 39.22% (176008/448802)
Region Coverage 33.73% (136169/403698)
Branch Coverage 34.70% (58747/169318)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 72.23% (25162/34838)
Line Coverage 59.00% (264065/447605)
Region Coverage 53.83% (219522/407824)
Branch Coverage 55.45% (94203/169873)

@freemandealer
Copy link
Contributor Author

run vault_p0

@freemandealer
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17692	4223	4026	4026
q2	2006	367	239	239
q3	10168	1296	768	768
q4	10204	869	324	324
q5	7491	2176	1999	1999
q6	206	180	145	145
q7	940	799	661	661
q8	9280	1428	1202	1202
q9	5210	4585	4657	4585
q10	6871	1823	1395	1395
q11	531	298	296	296
q12	750	745	590	590
q13	17802	3915	3174	3174
q14	286	290	276	276
q15	598	504	513	504
q16	707	681	628	628
q17	682	826	544	544
q18	6637	6589	6346	6346
q19	1102	1001	634	634
q20	407	363	253	253
q21	3142	2563	2370	2370
q22	1026	1026	971	971
Total cold run time: 103738 ms
Total hot run time: 31930 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4144	4047	4051	4047
q2	320	393	330	330
q3	2085	2596	2208	2208
q4	1345	1751	1317	1317
q5	4152	4027	3995	3995
q6	216	171	137	137
q7	1902	1827	2080	1827
q8	2667	2437	2500	2437
q9	7192	7147	7036	7036
q10	2590	2825	2245	2245
q11	573	489	463	463
q12	713	740	624	624
q13	3875	4207	3349	3349
q14	369	337	296	296
q15	564	505	516	505
q16	641	685	644	644
q17	1159	1455	1478	1455
q18	8290	7837	7809	7809
q19	955	888	944	888
q20	1988	2135	1950	1950
q21	5010	4469	4180	4180
q22	1068	1017	994	994
Total cold run time: 51818 ms
Total hot run time: 48736 ms

@doris-robot
Copy link

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

query5	4404	584	431	431
query6	336	237	219	219
query7	4201	465	261	261
query8	339	254	242	242
query9	8777	2657	2687	2657
query10	495	383	314	314
query11	15137	15122	14874	14874
query12	185	113	111	111
query13	1255	491	386	386
query14	6106	2968	2735	2735
query14_1	2675	2616	2625	2616
query15	199	193	178	178
query16	991	463	464	463
query17	1116	681	587	587
query18	2439	444	339	339
query19	230	221	200	200
query20	123	117	116	116
query21	213	141	121	121
query22	3901	4040	3999	3999
query23	15859	15763	15245	15245
query23_1	15531	15547	15385	15385
query24	7384	1570	1181	1181
query24_1	1187	1156	1159	1156
query25	569	484	415	415
query26	1252	270	158	158
query27	2761	454	285	285
query28	4541	2151	2129	2129
query29	859	570	463	463
query30	312	280	209	209
query31	806	609	542	542
query32	74	68	63	63
query33	526	329	277	277
query34	879	856	502	502
query35	748	793	698	698
query36	903	869	824	824
query37	129	86	75	75
query38	2717	2737	2579	2579
query39	776	772	741	741
query39_1	688	711	708	708
query40	212	126	114	114
query41	66	61	61	61
query42	105	99	99	99
query43	470	437	430	430
query44	1313	717	716	716
query45	186	181	178	178
query46	838	952	580	580
query47	1415	1460	1269	1269
query48	309	315	244	244
query49	605	406	360	360
query50	628	281	193	193
query51	3803	3854	3803	3803
query52	104	112	94	94
query53	296	326	271	271
query54	284	246	248	246
query55	73	78	70	70
query56	286	289	304	289
query57	994	964	951	951
query58	271	254	255	254
query59	2095	2158	1983	1983
query60	311	311	297	297
query61	164	167	163	163
query62	372	352	333	333
query63	293	264	262	262
query64	5098	1317	987	987
query65	3784	3730	3691	3691
query66	1441	418	303	303
query67	14995	15379	14832	14832
query68	6901	964	699	699
query69	503	347	305	305
query70	1070	933	973	933
query71	339	305	282	282
query72	6056	3413	3454	3413
query73	766	736	298	298
query74	8796	8862	8584	8584
query75	3070	2801	2482	2482
query76	3779	1047	625	625
query77	520	367	293	293
query78	9731	9895	9172	9172
query79	1010	858	571	571
query80	616	564	461	461
query81	505	256	228	228
query82	213	141	108	108
query83	268	253	234	234
query84	262	117	106	106
query85	884	503	452	452
query86	347	324	330	324
query87	2841	2879	2740	2740
query88	3090	2211	2181	2181
query89	383	348	329	329
query90	1960	150	149	149
query91	175	171	140	140
query92	71	68	64	64
query93	959	865	529	529
query94	557	326	297	297
query95	575	326	302	302
query96	575	451	206	206
query97	2316	2394	2276	2276
query98	214	193	198	193
query99	602	569	518	518
Total cold run time: 251554 ms
Total hot run time: 172037 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.04
query2	0.09	0.04	0.04
query3	0.25	0.09	0.08
query4	1.61	0.11	0.11
query5	0.29	0.26	0.25
query6	1.16	0.67	0.66
query7	0.03	0.02	0.02
query8	0.05	0.04	0.04
query9	0.56	0.50	0.50
query10	0.54	0.55	0.55
query11	0.15	0.10	0.10
query12	0.15	0.11	0.11
query13	0.60	0.59	0.60
query14	0.95	0.95	0.96
query15	0.79	0.77	0.77
query16	0.41	0.39	0.42
query17	1.06	1.04	1.08
query18	0.23	0.21	0.22
query19	1.91	1.87	1.79
query20	0.02	0.02	0.02
query21	15.46	0.26	0.14
query22	5.08	0.06	0.05
query23	15.90	0.29	0.10
query24	1.61	0.75	0.30
query25	0.12	0.06	0.07
query26	0.14	0.15	0.13
query27	0.09	0.05	0.05
query28	5.23	1.04	0.88
query29	12.63	4.02	3.22
query30	0.28	0.14	0.12
query31	2.83	0.66	0.41
query32	3.24	0.57	0.45
query33	3.03	2.99	3.07
query34	16.94	5.18	4.38
query35	4.51	4.55	4.47
query36	0.63	0.50	0.48
query37	0.10	0.06	0.06
query38	0.07	0.04	0.03
query39	0.04	0.02	0.03
query40	0.18	0.15	0.14
query41	0.09	0.03	0.03
query42	0.04	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 99.18 s
Total hot run time: 26.82 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 0.00% (0/3) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 53.23% (18974/35644)
Line Coverage 39.19% (175746/448428)
Region Coverage 33.76% (136219/403516)
Branch Coverage 34.72% (58761/169222)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 0.00% (0/125) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 70.22% (24468/34844)
Line Coverage 56.59% (253075/447229)
Region Coverage 51.32% (209209/407641)
Branch Coverage 52.72% (89503/169777)

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.

5 participants