Skip to content

[refine](mysql output) Remove text-mode usage of MysqlRowBuffer — it will now be used only for the binary format. #58425

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
wants to merge 4 commits into
base: master
Choose a base branch
from
Open

[refine](mysql output) Remove text-mode usage of MysqlRowBuffer — it will now be used only for the binary format. #58425

wants to merge 4 commits into from
+277 −1,640

Conversation

@Mryange
Copy link
Contributor

@Mryange Mryange commented Nov 26, 2025 •
edited
Loading

What problem does this PR solve?

For other textual outputs to MySQL, the values will be cast to strings using the appropriate cast-to-string.

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 Nov 26, 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?

@Mryange
Copy link
Contributor Author

Mryange commented Nov 26, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Nov 26, 2025

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

------ Round 1 ----------------------------------
q1	17677	5051	4972	4972
q2	2064	323	208	208
q3	10230	1339	728	728
q4	10224	912	365	365
q5	7508	2408	2396	2396
q6	183	171	135	135
q7	934	790	666	666
q8	9358	1378	1137	1137
q9	7126	5311	5373	5311
q10	6912	2266	1837	1837
q11	503	316	279	279
q12	373	376	242	242
q13	17811	3713	3014	3014
q14	243	238	217	217
q15	582	500	516	500
q16	1056	1056	978	978
q17	611	876	363	363
q18	7424	7157	7076	7076
q19	1087	962	540	540
q20	349	356	235	235
q21	3851	3258	2356	2356
q22	1038	1006	977	977
Total cold run time: 107144 ms
Total hot run time: 34532 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4997	4972	4984	4972
q2	328	396	329	329
q3	2189	2704	2307	2307
q4	1357	1808	1354	1354
q5	4234	4592	4690	4592
q6	212	175	129	129
q7	2132	2027	1911	1911
q8	2671	2596	2528	2528
q9	7556	7475	7592	7475
q10	3076	3299	2849	2849
q11	598	528	494	494
q12	687	774	613	613
q13	3510	3963	3293	3293
q14	319	316	294	294
q15	569	528	538	528
q16	1059	1142	1091	1091
q17	1246	1550	1377	1377
q18	7913	7762	7446	7446
q19	792	790	852	790
q20	2024	2099	2004	2004
q21	4977	4371	4128	4128
q22	1110	1055	1024	1024
Total cold run time: 53556 ms
Total hot run time: 51528 ms

@doris-robot
Copy link

doris-robot commented Nov 26, 2025

TPC-DS: Total hot run time: 185264 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 3896cd0510fd24ae73ef96f23cacea8e75ffff2a, data reload: false

query1	1048	409	436	409
query2	6565	1606	1609	1606
query3	6767	231	221	221
query4	25554	23439	22842	22842
query5	5537	616	486	486
query6	363	246	220	220
query7	4648	511	314	314
query8	308	257	255	255
query9	8712	2642	2610	2610
query10	586	364	314	314
query11	15144	14829	14549	14549
query12	179	120	113	113
query13	1673	602	478	478
query14	10921	8948	8844	8844
query15	209	202	181	181
query16	7634	676	482	482
query17	1182	762	623	623
query18	2029	434	327	327
query19	203	204	176	176
query20	131	130	119	119
query21	218	137	117	117
query22	3897	3959	3835	3835
query23	32964	32104	32063	32063
query24	8474	2433	2415	2415
query25	603	515	484	484
query26	1229	272	164	164
query27	2744	494	365	365
query28	4420	2202	2195	2195
query29	773	641	497	497
query30	304	240	220	220
query31	834	707	640	640
query32	86	70	75	70
query33	598	367	335	335
query34	807	895	549	549
query35	816	814	758	758
query36	900	980	891	891
query37	132	110	87	87
query38	3327	3298	3286	3286
query39	1533	1424	1407	1407
query40	240	131	119	119
query41	65	65	63	63
query42	131	114	118	114
query43	473	479	446	446
query44	1255	792	777	777
query45	202	197	185	185
query46	900	1005	646	646
query47	1704	1734	1703	1703
query48	408	441	343	343
query49	784	501	446	446
query50	652	695	405	405
query51	3907	3940	3897	3897
query52	116	115	105	105
query53	245	271	197	197
query54	323	310	274	274
query55	95	104	92	92
query56	337	339	326	326
query57	1153	1204	1089	1089
query58	299	279	277	277
query59	2442	2537	2358	2358
query60	365	356	353	353
query61	165	156	163	156
query62	786	700	661	661
query63	236	195	199	195
query64	4468	1200	1001	1001
query65	4041	4030	3942	3942
query66	1081	454	360	360
query67	15314	15122	14888	14888
query68	4610	935	668	668
query69	517	350	324	324
query70	1313	1268	1264	1264
query71	427	353	318	318
query72	6333	5212	5106	5106
query73	637	585	349	349
query74	8994	8594	8505	8505
query75	3341	3361	2827	2827
query76	3213	1155	708	708
query77	513	422	324	324
query78	9615	9837	8943	8943
query79	2178	813	598	598
query80	1752	588	489	489
query81	586	273	242	242
query82	401	159	132	132
query83	368	264	249	249
query84	263	115	104	104
query85	938	490	452	452
query86	473	312	285	285
query87	3626	3577	3333	3333
query88	2850	2299	2294	2294
query89	377	328	293	293
query90	1860	219	229	219
query91	175	165	155	155
query92	75	70	69	69
query93	1644	1003	669	669
query94	758	446	341	341
query95	483	422	392	392
query96	505	574	280	280
query97	2897	2982	2847	2847
query98	239	211	205	205
query99	1289	1417	1315	1315
Total cold run time: 269489 ms
Total hot run time: 185264 ms

@doris-robot
Copy link

doris-robot commented Nov 26, 2025

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

query1	0.05	0.05	0.06
query2	0.10	0.05	0.05
query3	0.25	0.08	0.09
query4	1.61	0.11	0.10
query5	0.26	0.26	0.24
query6	1.17	0.66	0.63
query7	0.03	0.02	0.03
query8	0.05	0.04	0.04
query9	0.58	0.53	0.51
query10	0.59	0.57	0.59
query11	0.15	0.12	0.11
query12	0.15	0.12	0.12
query13	0.63	0.61	0.62
query14	1.04	1.00	1.00
query15	0.85	0.85	0.85
query16	0.39	0.39	0.40
query17	1.02	1.01	1.02
query18	0.21	0.23	0.21
query19	1.96	1.83	1.82
query20	0.02	0.01	0.01
query21	15.44	0.18	0.14
query22	5.10	0.07	0.05
query23	15.65	0.26	0.10
query24	2.55	1.44	0.61
query25	0.08	0.06	0.06
query26	0.14	0.12	0.13
query27	0.06	0.06	0.06
query28	4.40	1.14	0.93
query29	12.59	3.86	3.21
query30	0.28	0.14	0.11
query31	2.82	0.58	0.39
query32	3.23	0.56	0.46
query33	3.13	3.11	3.02
query34	15.86	5.15	4.52
query35	4.59	4.60	4.62
query36	0.68	0.51	0.49
query37	0.10	0.06	0.07
query38	0.07	0.04	0.04
query39	0.04	0.03	0.03
query40	0.18	0.13	0.14
query41	0.08	0.04	0.03
query42	0.04	0.03	0.03
query43	0.05	0.03	0.04
Total cold run time: 98.27 s
Total hot run time: 27.64 s

@Mryange Mryange force-pushed the refine-mysql-output-part-3 branch from 3896cd0 to 14f8d73 Compare November 27, 2025 09:05
@Mryange
Copy link
Contributor Author

Mryange commented Nov 27, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Nov 27, 2025

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

------ Round 1 ----------------------------------
q1	17659	5172	4985	4985
q2	2043	318	205	205
q3	10250	1287	761	761
q4	10222	940	380	380
q5	7541	2449	2383	2383
q6	197	176	141	141
q7	952	803	643	643
q8	9353	1377	1237	1237
q9	7229	5262	5293	5262
q10	6931	2251	1816	1816
q11	503	300	278	278
q12	371	372	223	223
q13	17779	3650	3025	3025
q14	224	245	212	212
q15	598	525	510	510
q16	1057	1033	952	952
q17	603	863	404	404
q18	7799	7228	7013	7013
q19	1100	965	596	596
q20	358	349	225	225
q21	4013	3326	2420	2420
q22	1059	1038	975	975
Total cold run time: 107841 ms
Total hot run time: 34646 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5062	5059	4984	4984
q2	345	409	335	335
q3	2192	2709	2326	2326
q4	1373	1780	1303	1303
q5	4330	4589	4565	4565
q6	214	190	144	144
q7	2080	1927	1885	1885
q8	2719	2615	2594	2594
q9	7559	7517	7595	7517
q10	3030	3315	2812	2812
q11	595	517	499	499
q12	927	758	600	600
q13	3508	3873	3314	3314
q14	292	321	376	321
q15	561	507	507	507
q16	1131	1128	1097	1097
q17	1185	1595	1377	1377
q18	7949	7685	7743	7685
q19	862	901	1041	901
q20	2057	2062	1961	1961
q21	4938	4397	4315	4315
q22	1135	1052	1002	1002
Total cold run time: 54044 ms
Total hot run time: 52044 ms

@doris-robot
Copy link

doris-robot commented Nov 27, 2025

TPC-DS: Total hot run time: 184733 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 14f8d73c80743bce76a6c0cc20886a7c5b72e8c0, data reload: false

query1	1038	414	401	401
query2	6621	1641	1586	1586
query3	6760	224	220	220
query4	26095	22787	22544	22544
query5	4468	636	486	486
query6	338	239	227	227
query7	4650	516	307	307
query8	297	257	250	250
query9	8712	2585	2580	2580
query10	544	356	296	296
query11	15203	14932	14621	14621
query12	178	119	114	114
query13	1685	580	458	458
query14	10258	9151	9220	9151
query15	219	207	189	189
query16	7197	678	529	529
query17	1238	751	627	627
query18	1995	422	325	325
query19	208	202	180	180
query20	130	124	119	119
query21	210	133	115	115
query22	3853	4009	3774	3774
query23	33332	32035	32060	32035
query24	8551	2458	2448	2448
query25	592	556	450	450
query26	1232	268	165	165
query27	2748	499	353	353
query28	4377	2142	2117	2117
query29	825	637	488	488
query30	310	238	207	207
query31	865	741	629	629
query32	85	74	70	70
query33	596	402	337	337
query34	814	878	538	538
query35	806	825	739	739
query36	945	945	872	872
query37	127	111	93	93
query38	3359	3304	3324	3304
query39	1482	1436	1414	1414
query40	226	133	123	123
query41	67	63	63	63
query42	126	112	117	112
query43	458	485	432	432
query44	1294	762	757	757
query45	200	188	187	187
query46	900	1008	639	639
query47	1699	1696	1656	1656
query48	397	448	323	323
query49	778	495	454	454
query50	675	700	415	415
query51	3890	3860	3983	3860
query52	116	118	108	108
query53	252	281	210	210
query54	302	310	295	295
query55	95	96	94	94
query56	343	332	354	332
query57	1174	1188	1092	1092
query58	303	290	289	289
query59	2326	2467	2388	2388
query60	371	370	358	358
query61	190	194	190	190
query62	816	709	646	646
query63	238	205	202	202
query64	4652	1323	1021	1021
query65	4065	3970	3973	3970
query66	1236	431	335	335
query67	15178	15111	14783	14783
query68	8227	895	622	622
query69	522	348	309	309
query70	1262	1277	1274	1274
query71	452	345	315	315
query72	6025	4907	4920	4907
query73	661	612	353	353
query74	8912	8550	8515	8515
query75	3584	3312	2784	2784
query76	3374	1128	717	717
query77	747	419	315	315
query78	9588	9769	8914	8914
query79	1980	811	584	584
query80	666	579	503	503
query81	516	274	235	235
query82	237	171	135	135
query83	269	262	249	249
query84	267	114	95	95
query85	912	486	445	445
query86	314	295	269	269
query87	3510	3527	3466	3466
query88	2861	2296	2260	2260
query89	382	321	294	294
query90	1835	227	220	220
query91	176	176	142	142
query92	77	70	64	64
query93	1136	975	654	654
query94	666	457	323	323
query95	489	427	415	415
query96	503	567	285	285
query97	2884	3018	2882	2882
query98	233	215	219	215
query99	1300	1400	1281	1281
Total cold run time: 269877 ms
Total hot run time: 184733 ms

@doris-robot
Copy link

doris-robot commented Nov 27, 2025

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

query1	0.06	0.05	0.05
query2	0.09	0.05	0.06
query3	0.24	0.08	0.08
query4	1.60	0.11	0.11
query5	0.26	0.26	0.26
query6	1.18	0.66	0.65
query7	0.03	0.03	0.03
query8	0.06	0.04	0.04
query9	0.58	0.52	0.52
query10	0.57	0.58	0.57
query11	0.16	0.11	0.10
query12	0.14	0.12	0.12
query13	0.62	0.61	0.60
query14	1.01	1.00	1.01
query15	0.85	0.83	0.83
query16	0.39	0.39	0.39
query17	1.06	1.04	1.03
query18	0.21	0.20	0.19
query19	1.88	1.85	1.83
query20	0.01	0.01	0.02
query21	15.45	0.17	0.12
query22	5.17	0.08	0.05
query23	15.66	0.26	0.10
query24	2.35	0.78	0.49
query25	0.07	0.06	0.06
query26	0.14	0.14	0.13
query27	0.07	0.05	0.05
query28	4.14	1.13	0.92
query29	12.57	3.85	3.19
query30	0.28	0.13	0.11
query31	2.82	0.58	0.38
query32	3.23	0.54	0.47
query33	3.00	3.10	3.04
query34	15.88	5.22	4.51
query35	4.54	4.52	4.57
query36	0.67	0.50	0.49
query37	0.10	0.07	0.06
query38	0.06	0.04	0.03
query39	0.04	0.03	0.03
query40	0.18	0.15	0.14
query41	0.09	0.03	0.03
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 97.59 s
Total hot run time: 27.43 s

@Mryange Mryange changed the title [only test now] [refine](mysql output) remove text MysqlRowBuffer , now only binary MysqlRowBuffer Nov 27, 2025
@Mryange Mryange changed the title [refine](mysql output) remove text MysqlRowBuffer , now only binary MysqlRowBuffer [refine](mysql output) Remove text-mode usage of MysqlRowBuffer — it will now be used only for the binary format. Nov 27, 2025
@Mryange Mryange marked this pull request as ready for review November 27, 2025 15:10
@Mryange
Copy link
Contributor Author

Mryange commented Nov 27, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Nov 27, 2025

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

------ Round 1 ----------------------------------
q1	17661	5049	4911	4911
q2	2042	322	208	208
q3	10262	1326	749	749
q4	10237	921	372	372
q5	7554	2536	2265	2265
q6	186	166	133	133
q7	967	789	642	642
q8	9359	1432	1035	1035
q9	7162	5334	5337	5334
q10	6909	2271	1837	1837
q11	524	313	294	294
q12	392	374	224	224
q13	17789	3657	2999	2999
q14	227	241	218	218
q15	582	516	521	516
q16	1052	1013	962	962
q17	608	737	525	525
q18	7461	7174	7170	7170
q19	1094	954	576	576
q20	338	344	226	226
q21	4021	2649	2300	2300
q22	1084	983	943	943
Total cold run time: 107511 ms
Total hot run time: 34439 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5019	4983	4953	4953
q2	325	411	319	319
q3	2182	2693	2247	2247
q4	1283	1776	1313	1313
q5	4216	4420	4594	4420
q6	226	183	134	134
q7	2047	2005	1756	1756
q8	2749	2635	2602	2602
q9	7414	7484	7584	7484
q10	3029	3352	2821	2821
q11	592	534	497	497
q12	665	763	631	631
q13	3664	3975	3360	3360
q14	305	316	272	272
q15	550	514	510	510
q16	1106	1130	1077	1077
q17	1155	1454	1436	1436
q18	7899	7628	7588	7588
q19	795	747	767	747
q20	1901	1976	1844	1844
q21	4605	4208	4138	4138
q22	1079	1034	996	996
Total cold run time: 52806 ms
Total hot run time: 51145 ms

@doris-robot
Copy link

doris-robot commented Nov 27, 2025

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

query1	1057	408	406	406
query2	6594	1569	1575	1569
query3	6747	237	221	221
query4	25439	23203	22504	22504
query5	4906	641	465	465
query6	351	238	237	237
query7	4655	504	305	305
query8	342	253	244	244
query9	8722	2570	2573	2570
query10	545	361	306	306
query11	15151	15226	14871	14871
query12	191	118	113	113
query13	1700	572	444	444
query14	11037	8841	8765	8765
query15	212	201	180	180
query16	7641	691	539	539
query17	1184	740	620	620
query18	2036	420	324	324
query19	214	202	171	171
query20	129	120	119	119
query21	222	133	113	113
query22	3950	3938	3821	3821
query23	33017	32158	32042	32042
query24	8492	2365	2390	2365
query25	585	512	479	479
query26	1244	282	168	168
query27	2723	489	365	365
query28	4393	2162	2111	2111
query29	791	627	495	495
query30	307	232	213	213
query31	819	691	635	635
query32	81	75	72	72
query33	617	383	320	320
query34	817	886	533	533
query35	797	821	740	740
query36	879	923	852	852
query37	124	110	90	90
query38	3339	3377	3358	3358
query39	1477	1414	1407	1407
query40	228	130	120	120
query41	63	60	60	60
query42	126	118	110	110
query43	446	445	425	425
query44	1270	743	742	742
query45	198	204	183	183
query46	866	998	635	635
query47	1735	1714	1660	1660
query48	413	418	331	331
query49	761	490	407	407
query50	647	682	404	404
query51	3897	3894	3925	3894
query52	114	116	115	115
query53	231	253	191	191
query54	302	294	277	277
query55	90	96	92	92
query56	338	318	330	318
query57	1110	1180	1086	1086
query58	284	267	268	267
query59	2336	2461	2317	2317
query60	353	355	346	346
query61	164	185	159	159
query62	778	711	671	671
query63	223	192	191	191
query64	4578	1198	916	916
query65	4075	3968	4008	3968
query66	1136	443	346	346
query67	15386	15052	14963	14963
query68	4634	968	633	633
query69	534	353	314	314
query70	1263	1192	1218	1192
query71	425	339	313	313
query72	6240	5128	5004	5004
query73	662	600	341	341
query74	8678	8801	8651	8651
query75	3306	3337	2829	2829
query76	3314	1106	702	702
query77	522	418	312	312
query78	9615	9864	8901	8901
query79	1829	846	577	577
query80	1644	568	508	508
query81	568	277	238	238
query82	416	158	130	130
query83	367	260	251	251
query84	256	119	98	98
query85	907	480	456	456
query86	384	309	295	295
query87	3524	3497	3522	3497
query88	2887	2241	2414	2241
query89	491	382	292	292
query90	1746	229	217	217
query91	197	172	139	139
query92	71	69	67	67
query93	1194	992	658	658
query94	720	447	346	346
query95	496	407	404	404
query96	509	536	287	287
query97	2934	3010	2898	2898
query98	237	216	211	211
query99	1307	1383	1311	1311
Total cold run time: 267552 ms
Total hot run time: 184659 ms

@doris-robot
Copy link

doris-robot commented Nov 27, 2025

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.04
query3	0.25	0.09	0.08
query4	1.60	0.11	0.11
query5	0.27	0.27	0.26
query6	1.16	0.66	0.63
query7	0.03	0.02	0.02
query8	0.06	0.04	0.04
query9	0.58	0.51	0.50
query10	0.56	0.56	0.56
query11	0.16	0.11	0.11
query12	0.15	0.11	0.13
query13	0.64	0.60	0.61
query14	0.99	1.00	0.96
query15	0.81	0.81	0.81
query16	0.42	0.39	0.39
query17	1.00	1.00	1.00
query18	0.25	0.22	0.21
query19	1.84	1.88	1.83
query20	0.01	0.02	0.01
query21	15.44	0.28	0.15
query22	4.76	0.05	0.05
query23	15.92	0.27	0.10
query24	0.92	0.55	0.61
query25	0.07	0.09	0.06
query26	0.15	0.14	0.13
query27	0.06	0.05	0.05
query28	4.45	1.21	1.02
query29	12.60	3.90	3.24
query30	0.28	0.14	0.14
query31	2.81	0.60	0.40
query32	3.23	0.55	0.47
query33	3.08	3.02	3.15
query34	16.92	5.20	4.50
query35	4.53	4.51	4.57
query36	0.65	0.49	0.49
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.04	0.02	0.03
query40	0.18	0.14	0.13
query41	0.08	0.04	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 97.36 s
Total hot run time: 27.55 s

@Mryange
Copy link
Contributor Author

Mryange commented Nov 28, 2025

run beut

@doris-robot
Copy link

doris-robot commented Nov 28, 2025

BE UT Coverage Report

Increment line coverage 16.67% (23/138) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.78% (18446/34946)
Line Coverage 38.33% (169010/440918)
Region Coverage 33.13% (131163/395874)
Branch Coverage 34.09% (56513/165753)

@hello-stephen
Copy link
Contributor

hello-stephen commented Nov 28, 2025

BE Regression && UT Coverage Report

Increment line coverage 69.57% (96/138) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.62% (24542/34265)
Line Coverage 58.13% (256071/440528)
Region Coverage 53.15% (212979/400685)
Branch Coverage 54.63% (91039/166648)

@Mryange
Copy link
Contributor Author

Mryange commented Dec 1, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 1, 2025

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

------ Round 1 ----------------------------------
q1	17640	5263	4903	4903
q2	2091	311	213	213
q3	10241	1307	748	748
q4	10198	776	311	311
q5	7498	2434	2121	2121
q6	189	175	142	142
q7	948	802	641	641
q8	9348	1339	1048	1048
q9	7357	5254	5345	5254
q10	6852	2206	1770	1770
q11	508	300	295	295
q12	401	365	222	222
q13	17775	3660	3062	3062
q14	246	236	216	216
q15	587	529	523	523
q16	863	855	788	788
q17	608	785	547	547
q18	7985	7261	7135	7135
q19	1104	965	576	576
q20	344	330	238	238
q21	3600	3222	2291	2291
q22	1022	1028	933	933
Total cold run time: 107405 ms
Total hot run time: 33977 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4925	4928	4896	4896
q2	321	395	301	301
q3	2160	2680	2282	2282
q4	1305	1748	1315	1315
q5	4249	4398	4540	4398
q6	214	173	136	136
q7	2095	1915	1843	1843
q8	2762	2629	2497	2497
q9	7534	7576	7433	7433
q10	3116	3342	2796	2796
q11	611	523	517	517
q12	717	782	656	656
q13	3635	3869	3322	3322
q14	333	318	282	282
q15	560	514	507	507
q16	911	927	878	878
q17	1182	1446	1356	1356
q18	7797	7575	7594	7575
q19	813	767	787	767
q20	2003	1969	1838	1838
q21	4556	4233	4112	4112
q22	1033	1034	993	993
Total cold run time: 52832 ms
Total hot run time: 50700 ms

@doris-robot
Copy link

doris-robot commented Dec 1, 2025

TPC-DS: Total hot run time: 182184 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 0686243ee2ab0eb4668bb28523f7866b5efa0680, data reload: false

query1	1023	417	416	416
query2	6571	1188	1174	1174
query3	6743	231	224	224
query4	25143	22922	23020	22922
query5	4930	681	503	503
query6	331	241	226	226
query7	4692	516	304	304
query8	304	248	246	246
query9	8726	2632	2639	2632
query10	524	351	304	304
query11	15466	15241	14946	14946
query12	183	119	117	117
query13	1688	569	441	441
query14	9635	5985	5983	5983
query15	224	201	182	182
query16	7571	716	547	547
query17	1217	781	639	639
query18	2047	444	345	345
query19	217	206	187	187
query20	137	129	123	123
query21	220	141	116	116
query22	3847	4060	3874	3874
query23	32823	31990	31993	31990
query24	8517	2427	2410	2410
query25	645	558	499	499
query26	811	289	173	173
query27	2702	493	356	356
query28	4348	2184	2180	2180
query29	796	656	521	521
query30	319	247	211	211
query31	847	723	650	650
query32	88	76	76	76
query33	609	393	346	346
query34	828	865	548	548
query35	771	845	789	789
query36	872	920	826	826
query37	117	109	87	87
query38	3912	3836	3901	3836
query39	1455	1395	1416	1395
query40	235	136	125	125
query41	66	66	61	61
query42	128	117	116	116
query43	442	448	406	406
query44	1278	759	753	753
query45	196	195	188	188
query46	882	1009	641	641
query47	1709	1743	1673	1673
query48	409	413	335	335
query49	752	477	440	440
query50	659	705	418	418
query51	3871	3889	3886	3886
query52	114	116	108	108
query53	244	255	195	195
query54	323	308	293	293
query55	95	94	91	91
query56	329	333	335	333
query57	1137	1191	1123	1123
query58	291	280	280	280
query59	2343	2341	2332	2332
query60	359	355	349	349
query61	165	162	164	162
query62	778	722	676	676
query63	236	190	194	190
query64	3699	1269	896	896
query65	4047	3976	3986	3976
query66	962	435	334	334
query67	15066	15133	14743	14743
query68	8359	966	630	630
query69	534	347	308	308
query70	1094	1044	1033	1033
query71	475	337	322	322
query72	5855	4901	4917	4901
query73	720	586	349	349
query74	9104	8883	8534	8534
query75	3670	3019	2547	2547
query76	3672	1141	727	727
query77	827	402	307	307
query78	9576	9870	8797	8797
query79	1463	865	613	613
query80	651	593	507	507
query81	520	273	239	239
query82	196	146	111	111
query83	271	268	252	252
query84	267	122	98	98
query85	923	504	450	450
query86	383	306	285	285
query87	4088	4041	3967	3967
query88	2857	2296	2290	2290
query89	387	347	300	300
query90	1936	217	226	217
query91	168	176	142	142
query92	87	71	69	69
query93	1813	1016	650	650
query94	685	458	346	346
query95	514	406	422	406
query96	516	534	286	286
query97	2591	2696	2571	2571
query98	242	219	218	218
query99	1304	1434	1245	1245
Total cold run time: 268462 ms
Total hot run time: 182184 ms

@doris-robot
Copy link

doris-robot commented Dec 1, 2025

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

query1	0.06	0.05	0.05
query2	0.10	0.05	0.05
query3	0.25	0.09	0.09
query4	1.61	0.12	0.12
query5	0.28	0.24	0.25
query6	1.18	0.64	0.62
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.56	0.50	0.50
query10	0.55	0.56	0.55
query11	0.16	0.11	0.11
query12	0.14	0.13	0.12
query13	0.61	0.60	0.60
query14	1.00	1.01	0.97
query15	0.82	0.82	0.83
query16	0.40	0.42	0.39
query17	1.08	1.04	1.02
query18	0.25	0.22	0.22
query19	1.98	1.86	1.77
query20	0.02	0.01	0.01
query21	15.47	0.26	0.14
query22	4.97	0.05	0.05
query23	15.97	0.25	0.11
query24	1.04	0.24	0.40
query25	0.08	0.06	0.07
query26	0.14	0.13	0.13
query27	0.07	0.07	0.04
query28	3.75	1.23	1.04
query29	12.59	3.87	3.21
query30	0.29	0.15	0.11
query31	2.81	0.61	0.40
query32	3.24	0.54	0.48
query33	3.12	3.07	3.13
query34	16.96	5.19	4.53
query35	4.59	4.59	4.56
query36	0.67	0.50	0.49
query37	0.11	0.07	0.06
query38	0.07	0.04	0.03
query39	0.05	0.03	0.03
query40	0.19	0.14	0.14
query41	0.09	0.03	0.02
query42	0.04	0.03	0.03
query43	0.05	0.03	0.04
Total cold run time: 97.49 s
Total hot run time: 27.32 s

@doris-robot
Copy link

doris-robot commented Dec 1, 2025

BE UT Coverage Report

Increment line coverage 16.16% (32/198) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.73% (18435/34962)
Line Coverage 38.28% (168866/441149)
Region Coverage 33.09% (131133/396283)
Branch Coverage 34.05% (56464/165851)

@hello-stephen
Copy link
Contributor

hello-stephen commented Dec 1, 2025

BE Regression && UT Coverage Report

Increment line coverage 78.28% (155/198) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.64% (24559/34279)
Line Coverage 58.17% (256401/440756)
Region Coverage 53.32% (213883/401094)
Branch Coverage 54.81% (91399/166748)

@Mryange
Copy link
Contributor Author

Mryange commented Dec 2, 2025

run buildall

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

Reviewers

No reviews

Assignees

No one assigned

Labels

dev/4.0.x

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@Mryange @Thearas @doris-robot @hello-stephen @yiguolei