Skip to content

[complex_type_data_nullable_check] #59380

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
Draft
Mryange wants to merge 3 commits into
base: master
Choose a base branch
from
Draft

[complex_type_data_nullable_check] #59380

Mryange wants to merge 3 commits into from
+59 −1

Conversation

@Mryange
Copy link
Contributor

@Mryange Mryange commented Dec 26, 2025

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

@hello-stephen
Copy link
Contributor

hello-stephen commented Dec 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 Dec 26, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 26, 2025

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

------ Round 1 ----------------------------------
q1	17644	4220	4093	4093
q2	1994	353	229	229
q3	10279	1308	740	740
q4	10293	884	324	324
q5	8928	2213	1946	1946
q6	224	172	135	135
q7	1015	858	714	714
q8	9393	1475	1219	1219
q9	7278	5350	5264	5264
q10	6893	2394	1992	1992
q11	531	340	300	300
q12	698	746	589	589
q13	17804	3663	3024	3024
q14	290	298	271	271
q15	603	517	508	508
q16	709	664	657	657
q17	692	833	512	512
q18	7804	7122	7143	7122
q19	1401	955	605	605
q20	407	365	246	246
q21	4292	3939	3651	3651
q22	1064	1007	970	970
Total cold run time: 110236 ms
Total hot run time: 35111 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4140	4054	4085	4054
q2	328	399	308	308
q3	2101	2673	2297	2297
q4	1335	1754	1284	1284
q5	4305	4745	4842	4745
q6	232	171	128	128
q7	2109	1960	1773	1773
q8	2697	2559	2649	2559
q9	7616	7601	7516	7516
q10	3017	3307	2994	2994
q11	653	536	548	536
q12	687	924	575	575
q13	3456	3764	3386	3386
q14	313	322	312	312
q15	573	504	510	504
q16	653	694	637	637
q17	1173	1361	1378	1361
q18	8018	7583	7558	7558
q19	870	855	861	855
q20	1958	2072	1977	1977
q21	4770	4245	4168	4168
q22	1098	1035	968	968
Total cold run time: 52102 ms
Total hot run time: 50495 ms

@doris-robot
Copy link

doris-robot commented Dec 26, 2025

TPC-DS: Total hot run time: 179194 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 32b0fd6ee1c9037929d57433c018fc277a7ea256, data reload: false

query5	4805	588	455	455
query6	326	230	221	221
query7	4216	472	267	267
query8	297	289	232	232
query9	8734	2574	2523	2523
query10	533	361	331	331
query11	15528	14949	14849	14849
query12	172	116	112	112
query13	1247	500	387	387
query14	5864	3033	2785	2785
query14_1	2599	2586	2624	2586
query15	209	191	182	182
query16	816	402	461	402
query17	1119	727	600	600
query18	2435	442	349	349
query19	238	231	205	205
query20	119	119	113	113
query21	222	142	120	120
query22	4166	3977	3815	3815
query23	16717	16187	16018	16018
query23_1	16081	16139	16092	16092
query24	7332	1643	1238	1238
query24_1	1273	1218	1244	1218
query25	583	533	444	444
query26	1251	278	163	163
query27	2749	474	302	302
query28	4505	2125	2131	2125
query29	850	571	483	483
query30	321	244	217	217
query31	798	707	635	635
query32	78	72	72	72
query33	560	354	288	288
query34	891	894	534	534
query35	788	797	729	729
query36	858	894	844	844
query37	132	95	85	85
query38	2936	3073	2864	2864
query39	751	757	725	725
query39_1	702	716	697	697
query40	233	140	123	123
query41	73	77	68	68
query42	118	103	103	103
query43	421	422	414	414
query44	1301	743	737	737
query45	197	192	181	181
query46	884	972	616	616
query47	1675	1703	1625	1625
query48	320	333	248	248
query49	627	443	371	371
query50	669	314	221	221
query51	3917	3796	3871	3796
query52	108	108	106	106
query53	325	346	292	292
query54	303	279	275	275
query55	82	76	69	69
query56	359	297	300	297
query57	1152	1165	1103	1103
query58	275	260	261	260
query59	2451	2483	2371	2371
query60	316	309	288	288
query61	164	162	160	160
query62	715	716	680	680
query63	333	306	300	300
query64	5058	1314	1018	1018
query65	4019	3957	3946	3946
query66	1470	434	315	315
query67	15199	15021	14729	14729
query68	7301	986	723	723
query69	495	344	305	305
query70	1097	985	1055	985
query71	372	310	277	277
query72	6105	4912	5083	4912
query73	678	618	312	312
query74	9057	8828	8835	8828
query75	3205	3159	2798	2798
query76	3823	1143	730	730
query77	534	394	294	294
query78	9433	9507	8794	8794
query79	1271	950	602	602
query80	715	651	562	562
query81	506	273	237	237
query82	211	131	105	105
query83	264	255	245	245
query84	257	122	107	107
query85	905	519	467	467
query86	384	309	284	284
query87	3160	3371	3229	3229
query88	3257	2314	2285	2285
query89	471	427	397	397
query90	2194	159	155	155
query91	172	172	163	163
query92	84	69	66	66
query93	1380	921	558	558
query94	485	316	273	273
query95	567	387	302	302
query96	588	462	211	211
query97	2254	2288	2230	2230
query98	211	198	195	195
query99	1305	1312	1268	1268
Total cold run time: 259629 ms
Total hot run time: 179194 ms

@doris-robot
Copy link

doris-robot commented Dec 26, 2025

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

query1	0.05	0.05	0.04
query2	0.10	0.05	0.04
query3	0.26	0.08	0.08
query4	1.60	0.11	0.11
query5	0.26	0.25	0.26
query6	1.16	0.64	0.62
query7	0.03	0.02	0.03
query8	0.05	0.04	0.04
query9	0.56	0.50	0.50
query10	0.53	0.55	0.54
query11	0.16	0.11	0.10
query12	0.14	0.12	0.12
query13	0.62	0.60	0.60
query14	0.99	0.98	0.96
query15	0.81	0.80	0.81
query16	0.38	0.40	0.42
query17	1.01	1.10	1.04
query18	0.23	0.21	0.22
query19	1.83	1.74	1.82
query20	0.02	0.01	0.01
query21	15.42	0.31	0.14
query22	4.94	0.05	0.04
query23	16.07	0.28	0.10
query24	1.32	0.47	0.18
query25	0.08	0.08	0.08
query26	0.14	0.13	0.14
query27	0.09	0.05	0.05
query28	4.09	1.22	1.03
query29	12.55	3.99	3.25
query30	0.30	0.15	0.11
query31	2.83	0.63	0.39
query32	3.23	0.55	0.45
query33	2.94	3.04	3.05
query34	16.84	5.11	4.52
query35	4.65	4.56	4.53
query36	0.68	0.49	0.49
query37	0.11	0.07	0.06
query38	0.07	0.05	0.04
query39	0.04	0.03	0.03
query40	0.17	0.15	0.14
query41	0.08	0.03	0.03
query42	0.04	0.03	0.03
query43	0.05	0.03	0.03
Total cold run time: 97.52 s
Total hot run time: 27.11 s

@Mryange
Copy link
Contributor Author

Mryange commented Dec 29, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 29, 2025

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

------ Round 1 ----------------------------------
q1	17650	4174	4015	4015
q2	2059	369	238	238
q3	10194	1264	726	726
q4	10214	856	311	311
q5	7515	2145	1975	1975
q6	184	168	137	137
q7	963	793	667	667
q8	9296	1441	1150	1150
q9	6907	5151	5225	5151
q10	6837	1818	1404	1404
q11	491	319	287	287
q12	697	723	565	565
q13	17840	3690	3019	3019
q14	296	289	271	271
q15	582	516	506	506
q16	696	699	628	628
q17	709	784	602	602
q18	7297	7457	7906	7457
q19	1357	1091	671	671
q20	413	377	255	255
q21	4540	4181	3787	3787
q22	1116	1047	1061	1047
Total cold run time: 107853 ms
Total hot run time: 34869 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4336	4280	4221	4221
q2	335	430	328	328
q3	2318	2992	2474	2474
q4	1411	1850	1438	1438
q5	4653	4320	4244	4244
q6	215	167	126	126
q7	2020	1917	1770	1770
q8	2561	2485	2475	2475
q9	7246	7198	7253	7198
q10	2314	2560	2085	2085
q11	554	467	444	444
q12	627	702	556	556
q13	3279	3622	3038	3038
q14	273	304	264	264
q15	530	505	482	482
q16	616	656	601	601
q17	1115	1297	1320	1297
q18	7403	7324	7248	7248
q19	897	819	815	815
q20	1971	1942	1795	1795
q21	4433	4098	4016	4016
q22	1087	1052	983	983
Total cold run time: 50194 ms
Total hot run time: 47898 ms

@doris-robot
Copy link

doris-robot commented Dec 29, 2025

TPC-DS: Total hot run time: 171482 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 06bb6931e167dece2539b05ac19bd4fd6c02b422, data reload: false

query5	4418	578	418	418
query6	344	239	222	222
query7	4217	472	273	273
query8	348	250	249	249
query9	8780	2539	2528	2528
query10	488	379	314	314
query11	15105	15219	14896	14896
query12	173	115	130	115
query13	1284	499	406	406
query14	6178	3010	2700	2700
query14_1	2633	2607	2611	2607
query15	210	200	173	173
query16	1028	455	388	388
query17	1144	706	595	595
query18	2531	447	346	346
query19	228	230	197	197
query20	122	118	118	118
query21	215	138	125	125
query22	3962	4119	4091	4091
query23	16166	15716	15354	15354
query23_1	15509	15609	15542	15542
query24	7448	1592	1199	1199
query24_1	1184	1175	1190	1175
query25	575	440	395	395
query26	1248	260	153	153
query27	2777	448	287	287
query28	4545	2121	2104	2104
query29	741	521	423	423
query30	303	239	221	221
query31	824	639	554	554
query32	75	70	62	62
query33	519	324	280	280
query34	881	878	528	528
query35	748	789	700	700
query36	834	892	840	840
query37	128	89	71	71
query38	2742	2680	2666	2666
query39	776	747	720	720
query39_1	736	705	702	702
query40	212	131	153	131
query41	66	62	61	61
query42	104	99	103	99
query43	460	479	410	410
query44	1325	747	715	715
query45	190	183	173	173
query46	850	954	607	607
query47	1329	1455	1290	1290
query48	316	320	242	242
query49	605	403	341	341
query50	632	271	207	207
query51	3780	3786	3735	3735
query52	105	104	92	92
query53	295	329	270	270
query54	285	255	258	255
query55	79	72	80	72
query56	291	285	287	285
query57	1021	965	958	958
query58	269	247	242	242
query59	2019	2063	2096	2063
query60	322	315	300	300
query61	173	165	161	161
query62	401	358	313	313
query63	301	268	266	266
query64	4937	1340	1018	1018
query65	3778	3715	3692	3692
query66	1434	431	313	313
query67	15414	15466	14588	14588
query68	3691	1036	728	728
query69	504	346	308	308
query70	1023	890	930	890
query71	362	317	269	269
query72	6257	5017	2617	2617
query73	691	575	309	309
query74	8864	8772	8552	8552
query75	2946	2910	2506	2506
query76	3772	1016	646	646
query77	526	363	280	280
query78	9901	9953	9255	9255
query79	1674	906	591	591
query80	1572	580	491	491
query81	584	268	233	233
query82	415	149	107	107
query83	360	256	242	242
query84	263	122	102	102
query85	950	510	461	461
query86	466	300	315	300
query87	2922	2800	2776	2776
query88	3267	2243	2225	2225
query89	399	361	338	338
query90	1803	153	150	150
query91	178	169	140	140
query92	78	67	67	67
query93	1215	908	545	545
query94	648	336	287	287
query95	572	380	299	299
query96	592	462	209	209
query97	2320	2363	2305	2305
query98	216	199	197	197
query99	604	588	517	517
Total cold run time: 252054 ms
Total hot run time: 171482 ms

@doris-robot
Copy link

doris-robot commented Dec 29, 2025

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

query1	0.05	0.04	0.05
query2	0.10	0.05	0.05
query3	0.27	0.09	0.09
query4	1.61	0.11	0.11
query5	0.27	0.27	0.25
query6	1.15	0.67	0.65
query7	0.03	0.03	0.02
query8	0.06	0.04	0.06
query9	0.58	0.51	0.51
query10	0.56	0.56	0.55
query11	0.15	0.11	0.11
query12	0.15	0.11	0.12
query13	0.61	0.60	0.61
query14	0.98	0.98	0.97
query15	0.82	0.79	0.80
query16	0.39	0.39	0.39
query17	1.02	1.04	1.04
query18	0.23	0.22	0.22
query19	1.91	1.84	1.79
query20	0.02	0.01	0.01
query21	15.46	0.27	0.13
query22	4.93	0.06	0.05
query23	16.02	0.28	0.10
query24	0.97	0.31	0.19
query25	0.09	0.11	0.06
query26	0.14	0.13	0.14
query27	0.08	0.06	0.07
query28	3.14	1.23	1.03
query29	12.60	3.99	3.23
query30	0.28	0.14	0.12
query31	2.82	0.61	0.40
query32	3.24	0.54	0.44
query33	2.96	3.05	3.02
query34	16.88	5.22	4.55
query35	4.57	4.52	4.55
query36	0.69	0.50	0.49
query37	0.11	0.07	0.06
query38	0.07	0.04	0.04
query39	0.04	0.03	0.02
query40	0.17	0.14	0.14
query41	0.09	0.04	0.03
query42	0.04	0.02	0.02
query43	0.05	0.03	0.03
Total cold run time: 96.4 s
Total hot run time: 27.2 s

@Mryange Mryange force-pushed the test-complex_type_data_nullable_check branch from 06bb693 to dd29813 Compare December 31, 2025 06:45
@Mryange
Copy link
Contributor Author

Mryange commented Dec 31, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

------ Round 1 ----------------------------------
q1	17581	4211	4097	4097
q2	2053	352	244	244
q3	10188	1314	734	734
q4	10207	851	322	322
q5	7481	2168	1934	1934
q6	192	171	139	139
q7	984	807	656	656
q8	9313	1416	1160	1160
q9	6848	5201	5200	5200
q10	6846	1787	1406	1406
q11	505	300	308	300
q12	748	721	593	593
q13	17826	3827	3105	3105
q14	285	292	267	267
q15	580	506	507	506
q16	702	701	637	637
q17	709	764	614	614
q18	7453	7445	7995	7445
q19	1399	1008	670	670
q20	463	405	280	280
q21	4591	4218	4206	4206
q22	1125	1114	1026	1026
Total cold run time: 108079 ms
Total hot run time: 35541 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4279	4273	4346	4273
q2	306	392	341	341
q3	2465	2803	2438	2438
q4	1417	1871	1434	1434
q5	4437	4334	4276	4276
q6	212	166	132	132
q7	2001	1918	1837	1837
q8	2547	2395	2334	2334
q9	7219	6803	6627	6627
q10	2338	2523	2153	2153
q11	527	467	436	436
q12	688	710	598	598
q13	3333	3845	3106	3106
q14	286	277	259	259
q15	538	486	487	486
q16	633	686	624	624
q17	1098	1233	1266	1233
q18	7364	7264	7367	7264
q19	883	838	888	838
q20	1926	1991	1796	1796
q21	4552	4299	4228	4228
q22	1104	1027	968	968
Total cold run time: 50153 ms
Total hot run time: 47681 ms

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

query5	4892	580	435	435
query6	336	221	202	202
query7	4206	453	265	265
query8	345	279	263	263
query9	8796	2645	2653	2645
query10	556	369	309	309
query11	15284	15026	14919	14919
query12	190	117	111	111
query13	1274	512	395	395
query14	6406	2961	2734	2734
query14_1	2644	2581	2611	2581
query15	200	194	172	172
query16	992	458	445	445
query17	1078	692	602	602
query18	2637	444	346	346
query19	228	220	198	198
query20	123	116	121	116
query21	227	147	123	123
query22	4065	4239	3961	3961
query23	16114	15509	15439	15439
query23_1	15528	15437	15332	15332
query24	7380	1588	1196	1196
query24_1	1204	1199	1226	1199
query25	558	475	435	435
query26	1238	263	162	162
query27	2762	465	305	305
query28	4512	2189	2175	2175
query29	779	558	447	447
query30	318	243	215	215
query31	775	642	566	566
query32	78	73	65	65
query33	544	377	290	290
query34	880	891	529	529
query35	743	798	712	712
query36	830	874	808	808
query37	181	92	75	75
query38	2772	2694	2674	2674
query39	780	752	722	722
query39_1	715	690	693	690
query40	221	129	117	117
query41	64	66	64	64
query42	104	101	105	101
query43	450	442	427	427
query44	1363	759	737	737
query45	189	184	173	173
query46	870	956	608	608
query47	1448	1473	1353	1353
query48	321	319	251	251
query49	594	422	325	325
query50	633	269	195	195
query51	3752	3797	3736	3736
query52	102	105	93	93
query53	293	321	266	266
query54	284	267	245	245
query55	79	75	69	69
query56	288	299	293	293
query57	1029	1021	920	920
query58	269	250	246	246
query59	2145	2143	2143	2143
query60	323	308	301	301
query61	199	161	156	156
query62	383	362	323	323
query63	291	262	265	262
query64	4907	1312	991	991
query65	3814	3719	3719	3719
query66	1395	433	314	314
query67	15253	15901	15139	15139
query68	6980	1001	725	725
query69	503	344	309	309
query70	1072	953	937	937
query71	396	302	273	273
query72	6230	4781	4995	4781
query73	735	687	308	308
query74	8805	8841	8581	8581
query75	2896	2885	2485	2485
query76	3891	1053	642	642
query77	514	398	289	289
query78	9648	10001	9132	9132
query79	1231	915	607	607
query80	626	570	471	471
query81	508	266	229	229
query82	216	145	115	115
query83	257	253	242	242
query84	262	124	104	104
query85	905	505	466	466
query86	393	301	332	301
query87	2847	2840	2769	2769
query88	3277	2267	2314	2267
query89	399	350	329	329
query90	2202	147	144	144
query91	173	166	145	145
query92	85	67	61	61
query93	1682	923	566	566
query94	569	312	306	306
query95	577	376	309	309
query96	582	463	210	210
query97	2292	2371	2311	2311
query98	242	216	200	200
query99	597	602	525	525
Total cold run time: 254699 ms
Total hot run time: 174798 ms

@doris-robot
Copy link

doris-robot commented Dec 31, 2025

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.05
query3	0.25	0.09	0.09
query4	1.61	0.12	0.11
query5	0.26	0.28	0.25
query6	1.14	0.64	0.64
query7	0.03	0.02	0.02
query8	0.05	0.04	0.05
query9	0.56	0.52	0.53
query10	0.56	0.55	0.54
query11	0.18	0.11	0.12
query12	0.15	0.13	0.13
query13	0.63	0.60	0.59
query14	0.99	0.98	0.97
query15	0.80	0.80	0.80
query16	0.43	0.43	0.42
query17	1.03	1.06	1.06
query18	0.23	0.21	0.21
query19	1.98	1.89	1.88
query20	0.02	0.01	0.01
query21	15.44	0.27	0.15
query22	4.80	0.06	0.05
query23	16.11	0.28	0.10
query24	1.35	1.32	0.95
query25	0.10	0.08	0.06
query26	0.13	0.14	0.13
query27	0.06	0.07	0.06
query28	5.92	1.03	0.87
query29	12.56	3.92	3.18
query30	0.27	0.14	0.11
query31	2.83	0.61	0.38
query32	3.23	0.56	0.46
query33	3.06	3.02	3.00
query34	16.58	5.14	4.48
query35	4.43	4.51	4.50
query36	0.68	0.50	0.50
query37	0.12	0.08	0.06
query38	0.07	0.05	0.04
query39	0.04	0.02	0.02
query40	0.18	0.15	0.14
query41	0.09	0.03	0.04
query42	0.05	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 99.19 s
Total hot run time: 27.82 s

@Mryange
Copy link
Contributor Author

Mryange commented Jan 1, 2026

run buildall

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

------ Round 1 ----------------------------------
q1	17624	4240	4083	4083
q2	2033	355	239	239
q3	10168	1278	766	766
q4	10202	847	326	326
q5	7582	2191	1918	1918
q6	215	165	139	139
q7	982	822	656	656
q8	9321	1437	1194	1194
q9	5517	4667	4752	4667
q10	6854	1840	1412	1412
q11	524	306	294	294
q12	759	757	611	611
q13	17824	3854	3094	3094
q14	290	294	279	279
q15	592	515	515	515
q16	682	681	653	653
q17	722	763	674	674
q18	7381	6378	7387	6378
q19	1197	1009	657	657
q20	433	399	256	256
q21	3468	2776	2783	2776
q22	1150	1107	1025	1025
Total cold run time: 105520 ms
Total hot run time: 32612 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4431	4277	4337	4277
q2	340	394	312	312
q3	2322	2809	2391	2391
q4	1461	1839	1528	1528
q5	4548	4399	4197	4197
q6	222	170	131	131
q7	2019	2108	1747	1747
q8	2565	2346	2273	2273
q9	7063	7018	7077	7018
q10	2537	3015	2253	2253
q11	547	471	456	456
q12	694	742	624	624
q13	3626	4079	3069	3069
q14	261	294	251	251
q15	526	491	477	477
q16	643	672	598	598
q17	1115	1358	1361	1358
q18	7430	7307	7259	7259
q19	856	845	884	845
q20	1915	1977	1801	1801
q21	4627	4409	4259	4259
q22	1112	1023	1002	1002
Total cold run time: 50860 ms
Total hot run time: 48126 ms

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

query5	4572	590	445	445
query6	328	239	211	211
query7	4223	447	263	263
query8	334	249	248	248
query9	8782	2601	2605	2601
query10	513	382	292	292
query11	15392	15089	15057	15057
query12	160	115	116	115
query13	1245	478	387	387
query14	6096	3040	2710	2710
query14_1	2697	2637	2622	2622
query15	204	191	168	168
query16	993	457	438	438
query17	1077	670	566	566
query18	2476	438	368	368
query19	218	223	184	184
query20	119	111	110	110
query21	215	135	116	116
query22	3881	4141	3739	3739
query23	16102	15774	15329	15329
query23_1	15345	15490	15427	15427
query24	7406	1574	1183	1183
query24_1	1221	1205	1222	1205
query25	541	446	393	393
query26	1239	256	162	162
query27	2768	458	292	292
query28	4554	2197	2193	2193
query29	773	539	430	430
query30	324	259	224	224
query31	824	627	550	550
query32	81	76	72	72
query33	547	344	311	311
query34	898	889	550	550
query35	795	788	693	693
query36	821	873	739	739
query37	125	99	74	74
query38	2778	2681	2601	2601
query39	780	764	733	733
query39_1	720	727	711	711
query40	219	130	113	113
query41	66	62	61	61
query42	104	101	101	101
query43	437	450	422	422
query44	1355	757	756	756
query45	187	183	180	180
query46	872	970	609	609
query47	1365	1394	1318	1318
query48	316	323	266	266
query49	607	397	336	336
query50	647	278	207	207
query51	3854	3786	3753	3753
query52	102	107	96	96
query53	304	329	270	270
query54	282	248	243	243
query55	78	73	74	73
query56	286	295	277	277
query57	1040	1002	951	951
query58	260	248	247	247
query59	2108	2213	2159	2159
query60	315	302	298	298
query61	183	159	158	158
query62	410	352	306	306
query63	308	261	265	261
query64	4932	1302	982	982
query65	3805	3643	3690	3643
query66	1431	429	309	309
query67	14954	14954	15592	14954
query68	2758	1063	757	757
query69	435	346	318	318
query70	990	962	980	962
query71	326	294	262	262
query72	6143	3751	3665	3665
query73	608	724	324	324
query74	8818	8805	8600	8600
query75	2821	2864	2520	2520
query76	2857	1060	684	684
query77	382	385	287	287
query78	9889	10017	9108	9108
query79	1139	934	636	636
query80	1339	639	545	545
query81	545	262	227	227
query82	1091	142	109	109
query83	338	248	237	237
query84	252	121	106	106
query85	934	502	468	468
query86	417	318	293	293
query87	2840	2942	2818	2818
query88	3335	2309	2282	2282
query89	401	360	329	329
query90	1933	157	141	141
query91	171	177	148	148
query92	68	68	59	59
query93	1011	906	563	563
query94	644	331	274	274
query95	562	336	304	304
query96	588	480	212	212
query97	2324	2381	2277	2277
query98	210	199	197	197
query99	593	573	511	511
Total cold run time: 248825 ms
Total hot run time: 173219 ms

@doris-robot
Copy link

doris-robot commented Jan 1, 2026

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

query1	0.05	0.05	0.05
query2	0.11	0.05	0.05
query3	0.26	0.09	0.08
query4	1.61	0.12	0.11
query5	0.28	0.26	0.26
query6	1.14	0.67	0.65
query7	0.04	0.03	0.02
query8	0.06	0.04	0.04
query9	0.55	0.49	0.48
query10	0.54	0.55	0.54
query11	0.15	0.11	0.11
query12	0.16	0.12	0.12
query13	0.61	0.59	0.60
query14	0.98	0.98	0.97
query15	0.81	0.80	0.79
query16	0.41	0.39	0.41
query17	0.96	1.04	1.00
query18	0.23	0.22	0.22
query19	1.80	1.85	1.73
query20	0.01	0.02	0.02
query21	15.42	0.28	0.15
query22	4.93	0.05	0.05
query23	16.19	0.29	0.10
query24	2.24	0.32	0.41
query25	0.09	0.09	0.07
query26	0.15	0.13	0.13
query27	0.06	0.04	0.05
query28	4.08	1.05	0.87
query29	12.65	3.91	3.18
query30	0.28	0.15	0.11
query31	2.82	0.62	0.38
query32	3.23	0.55	0.47
query33	2.99	3.06	3.05
query34	16.95	5.17	4.50
query35	4.45	4.48	4.44
query36	0.65	0.49	0.48
query37	0.11	0.07	0.07
query38	0.08	0.04	0.04
query39	0.04	0.02	0.03
query40	0.18	0.14	0.13
query41	0.10	0.04	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 98.53 s
Total hot run time: 26.91 s

@Mryange
Copy link
Contributor Author

Mryange commented Jan 2, 2026

run buildall

@doris-robot
Copy link

doris-robot commented Jan 2, 2026

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

------ Round 1 ----------------------------------
q1	17689	4236	4037	4037
q2	2359	363	243	243
q3	10187	1273	716	716
q4	10218	838	320	320
q5	7498	2128	1911	1911
q6	188	169	136	136
q7	960	801	671	671
q8	9270	1395	1149	1149
q9	5270	4834	4694	4694
q10	6836	1768	1413	1413
q11	514	315	307	307
q12	696	732	585	585
q13	17802	3818	3078	3078
q14	295	278	308	278
q15	636	521	516	516
q16	705	698	629	629
q17	709	751	671	671
q18	6651	6528	7268	6528
q19	1175	1012	654	654
q20	480	441	263	263
q21	3416	2756	2672	2672
q22	1195	1133	1052	1052
Total cold run time: 104749 ms
Total hot run time: 32523 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4305	4308	4243	4243
q2	333	418	327	327
q3	2312	2828	2448	2448
q4	1440	1857	1497	1497
q5	4542	4441	4305	4305
q6	211	176	132	132
q7	1955	1976	1777	1777
q8	2547	2409	2621	2409
q9	7106	7105	7162	7105
q10	2459	2730	2328	2328
q11	537	462	458	458
q12	717	782	629	629
q13	3342	3762	3146	3146
q14	281	284	256	256
q15	520	496	487	487
q16	619	651	596	596
q17	1086	1201	1269	1201
q18	7493	7389	7074	7074
q19	885	843	859	843
q20	1926	1967	1839	1839
q21	4516	4322	4194	4194
q22	1045	1051	996	996
Total cold run time: 50177 ms
Total hot run time: 48290 ms

@doris-robot
Copy link

doris-robot commented Jan 2, 2026

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

query5	4923	581	456	456
query6	330	228	202	202
query7	4207	464	271	271
query8	324	245	246	245
query9	8755	2620	2653	2620
query10	542	364	315	315
query11	15181	15176	14979	14979
query12	195	118	111	111
query13	1255	486	402	402
query14	6378	3342	2700	2700
query14_1	2629	2611	2618	2611
query15	213	198	175	175
query16	997	487	458	458
query17	1088	693	581	581
query18	2608	449	383	383
query19	215	218	192	192
query20	125	115	114	114
query21	214	134	116	116
query22	4138	4123	3850	3850
query23	15947	15607	15315	15315
query23_1	15333	15399	15481	15399
query24	7436	1597	1209	1209
query24_1	1208	1196	1215	1196
query25	526	435	389	389
query26	1010	263	159	159
query27	2752	454	294	294
query28	4533	2189	2163	2163
query29	770	597	456	456
query30	312	241	210	210
query31	779	649	569	569
query32	79	68	65	65
query33	530	327	280	280
query34	873	906	555	555
query35	763	782	691	691
query36	852	881	819	819
query37	127	95	79	79
query38	2745	2747	2739	2739
query39	757	754	740	740
query39_1	696	697	737	697
query40	214	133	115	115
query41	68	66	64	64
query42	104	102	102	102
query43	448	462	408	408
query44	1337	758	750	750
query45	188	180	176	176
query46	874	979	614	614
query47	1335	1488	1368	1368
query48	314	326	239	239
query49	599	418	330	330
query50	639	282	211	211
query51	3697	3830	3801	3801
query52	102	107	101	101
query53	297	331	283	283
query54	289	252	246	246
query55	77	83	78	78
query56	290	294	308	294
query57	1011	1065	942	942
query58	271	262	251	251
query59	2139	2244	2221	2221
query60	317	314	295	295
query61	164	161	162	161
query62	384	387	303	303
query63	297	264	275	264
query64	4627	1420	1098	1098
query65	3777	3751	3727	3727
query66	1376	446	331	331
query67	15155	14876	15476	14876
query68	4775	1044	753	753
query69	506	358	314	314
query70	1030	972	939	939
query71	362	302	281	281
query72	6379	3422	3427	3422
query73	781	730	312	312
query74	8787	8717	8716	8716
query75	2859	2898	2496	2496
query76	3836	1059	666	666
query77	509	375	278	278
query78	9874	9946	9141	9141
query79	1248	865	602	602
query80	1565	577	495	495
query81	555	272	233	233
query82	427	154	112	112
query83	365	254	234	234
query84	264	120	107	107
query85	948	507	452	452
query86	395	309	293	293
query87	2902	2890	2795	2795
query88	3234	2302	2319	2302
query89	377	354	328	328
query90	1829	152	144	144
query91	176	169	144	144
query92	74	64	63	63
query93	1125	950	575	575
query94	645	314	284	284
query95	574	381	306	306
query96	606	465	211	211
query97	2324	2370	2299	2299
query98	229	195	201	195
query99	579	577	499	499
Total cold run time: 251927 ms
Total hot run time: 173681 ms

@doris-robot
Copy link

doris-robot commented Jan 2, 2026

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.05
query3	0.25	0.10	0.09
query4	1.61	0.12	0.12
query5	0.28	0.27	0.26
query6	1.15	0.67	0.65
query7	0.04	0.03	0.03
query8	0.05	0.04	0.04
query9	0.56	0.49	0.51
query10	0.54	0.54	0.55
query11	0.15	0.12	0.11
query12	0.16	0.12	0.12
query13	0.62	0.60	0.59
query14	0.97	1.00	0.98
query15	0.81	0.78	0.79
query16	0.41	0.40	0.42
query17	1.07	1.05	1.08
query18	0.23	0.21	0.22
query19	1.93	1.86	1.84
query20	0.02	0.01	0.01
query21	15.43	0.30	0.14
query22	4.83	0.06	0.05
query23	15.98	0.28	0.11
query24	1.06	0.92	0.91
query25	0.10	0.07	0.10
query26	0.14	0.14	0.14
query27	0.07	0.07	0.06
query28	5.43	1.05	0.88
query29	12.60	3.94	3.16
query30	0.28	0.14	0.12
query31	2.81	0.63	0.38
query32	3.23	0.55	0.45
query33	3.04	2.98	3.17
query34	16.69	5.16	4.40
query35	4.51	4.51	4.47
query36	0.65	0.50	0.49
query37	0.11	0.07	0.07
query38	0.07	0.04	0.04
query39	0.05	0.03	0.03
query40	0.16	0.14	0.13
query41	0.09	0.03	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 98.41 s
Total hot run time: 27.58 s

@Mryange
Copy link
Contributor Author

Mryange commented Jan 2, 2026

run buildall

@doris-robot
Copy link

doris-robot commented Jan 2, 2026

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

------ Round 1 ----------------------------------
q1	17609	4254	4022	4022
q2	2026	367	233	233
q3	10145	1263	744	744
q4	10215	875	317	317
q5	7522	2103	1913	1913
q6	181	163	135	135
q7	949	797	662	662
q8	9266	1364	1114	1114
q9	5205	4802	4746	4746
q10	6796	1812	1409	1409
q11	521	304	278	278
q12	685	741	605	605
q13	17783	3805	3091	3091
q14	286	300	266	266
q15	581	509	512	509
q16	672	692	632	632
q17	701	724	619	619
q18	7108	6505	6885	6505
q19	1150	987	641	641
q20	442	410	272	272
q21	3302	2884	2722	2722
q22	1161	1088	1046	1046
Total cold run time: 104306 ms
Total hot run time: 32481 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4419	4273	4248	4248
q2	327	415	321	321
q3	2304	2773	2466	2466
q4	1420	1991	1421	1421
q5	4534	4474	4406	4406
q6	232	167	134	134
q7	1944	1907	1827	1827
q8	2515	2302	2399	2302
q9	7361	7054	6945	6945
q10	2557	2706	2253	2253
q11	557	475	450	450
q12	738	745	601	601
q13	3515	3739	3086	3086
q14	262	281	262	262
q15	530	487	487	487
q16	596	654	602	602
q17	1071	1218	1269	1218
q18	7454	7462	7128	7128
q19	868	833	872	833
q20	1904	1972	1781	1781
q21	4510	4318	4122	4122
q22	1093	1021	1006	1006
Total cold run time: 50711 ms
Total hot run time: 47899 ms

@doris-robot
Copy link

doris-robot commented Jan 2, 2026

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

query5	4858	600	467	467
query6	328	228	223	223
query7	4223	460	275	275
query8	339	260	241	241
query9	8786	2622	2611	2611
query10	512	379	313	313
query11	15138	15222	14840	14840
query12	172	113	116	113
query13	1268	539	394	394
query14	6340	2931	2729	2729
query14_1	2622	2590	2608	2590
query15	208	190	183	183
query16	978	461	448	448
query17	1070	677	587	587
query18	2542	440	352	352
query19	228	225	193	193
query20	130	117	114	114
query21	214	139	119	119
query22	3817	4036	4060	4036
query23	16190	15535	15337	15337
query23_1	15496	15385	15441	15385
query24	7427	1611	1205	1205
query24_1	1227	1217	1206	1206
query25	570	481	430	430
query26	1246	269	166	166
query27	2754	457	297	297
query28	4501	2196	2169	2169
query29	798	563	459	459
query30	313	241	219	219
query31	813	623	552	552
query32	82	65	66	65
query33	549	335	324	324
query34	883	874	521	521
query35	751	789	708	708
query36	864	905	831	831
query37	136	99	125	99
query38	2801	2744	2621	2621
query39	786	749	732	732
query39_1	711	711	700	700
query40	211	135	112	112
query41	64	61	63	61
query42	100	103	103	103
query43	435	457	430	430
query44	1298	748	751	748
query45	183	193	175	175
query46	878	961	596	596
query47	1413	1405	1304	1304
query48	322	320	244	244
query49	601	414	322	322
query50	630	279	212	212
query51	3791	3723	3740	3723
query52	101	108	98	98
query53	292	322	274	274
query54	284	250	240	240
query55	81	75	69	69
query56	280	284	292	284
query57	1043	1027	929	929
query58	262	252	251	251
query59	2141	2052	2020	2020
query60	305	308	297	297
query61	159	196	159	159
query62	392	356	332	332
query63	300	266	268	266
query64	4957	1295	969	969
query65	3766	3682	3673	3673
query66	1434	429	309	309
query67	15019	15937	15133	15133
query68	8285	1010	722	722
query69	501	340	309	309
query70	1041	932	921	921
query71	368	297	272	272
query72	6018	3338	3400	3338
query73	789	746	304	304
query74	8781	8887	8637	8637
query75	2861	2799	2487	2487
query76	3792	1064	651	651
query77	491	376	282	282
query78	9697	9839	9150	9150
query79	1377	911	604	604
query80	603	580	475	475
query81	518	258	231	231
query82	235	145	111	111
query83	261	265	238	238
query84	248	115	105	105
query85	880	529	456	456
query86	330	322	312	312
query87	2873	2869	2721	2721
query88	4014	2231	2281	2231
query89	376	352	333	333
query90	2222	157	147	147
query91	165	168	140	140
query92	81	68	62	62
query93	1418	915	558	558
query94	564	315	294	294
query95	570	328	304	304
query96	579	470	207	207
query97	2320	2370	2256	2256
query98	212	199	195	195
query99	590	580	491	491
Total cold run time: 257130 ms
Total hot run time: 173306 ms

@doris-robot
Copy link

doris-robot commented Jan 2, 2026

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

query1	0.06	0.05	0.05
query2	0.10	0.05	0.05
query3	0.26	0.09	0.09
query4	1.62	0.12	0.11
query5	0.29	0.26	0.25
query6	1.14	0.68	0.66
query7	0.03	0.03	0.03
query8	0.05	0.05	0.04
query9	0.57	0.50	0.50
query10	0.56	0.55	0.55
query11	0.15	0.10	0.11
query12	0.16	0.12	0.13
query13	0.61	0.59	0.60
query14	1.00	0.98	0.98
query15	0.81	0.80	0.80
query16	0.42	0.38	0.42
query17	1.04	1.06	1.08
query18	0.23	0.23	0.21
query19	1.92	1.83	1.75
query20	0.02	0.01	0.02
query21	15.48	0.30	0.14
query22	4.58	0.05	0.04
query23	16.03	0.30	0.11
query24	0.94	0.60	0.47
query25	0.11	0.06	0.06
query26	0.15	0.14	0.14
query27	0.06	0.06	0.06
query28	4.78	1.04	0.88
query29	12.61	3.95	3.16
query30	0.28	0.15	0.14
query31	2.82	0.62	0.39
query32	3.24	0.56	0.46
query33	3.03	3.18	2.97
query34	16.74	5.13	4.45
query35	4.57	4.53	4.48
query36	0.65	0.52	0.50
query37	0.12	0.07	0.06
query38	0.07	0.05	0.04
query39	0.04	0.03	0.03
query40	0.18	0.14	0.14
query41	0.09	0.04	0.03
query42	0.04	0.03	0.03
query43	0.04	0.03	0.04
Total cold run time: 97.69 s
Total hot run time: 27.14 s

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

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

3 participants

@Mryange @hello-stephen @doris-robot