Skip to content

branch-3.1:[opt](properties) remove old dlf properties #55555 #56196

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
Merged
morrySnow merged 2 commits into from
Sep 25, 2025
Merged

branch-3.1:[opt](properties) remove old dlf properties #55555 #56196

morrySnow merged 2 commits into from
Sep 25, 2025

Conversation

@CalvinKirs
Copy link
Member

@CalvinKirs CalvinKirs commented Sep 18, 2025

cherry pick #55555

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 18, 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?

@CalvinKirs
Copy link
Member Author

CalvinKirs commented Sep 18, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Sep 18, 2025

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

------ Round 1 ----------------------------------
q1	17592	5486	5415	5415
q2	2030	379	276	276
q3	11822	1258	732	732
q4	10506	866	456	456
q5	9489	2385	2117	2117
q6	187	163	132	132
q7	888	741	606	606
q8	9328	1404	1128	1128
q9	5182	4950	4856	4856
q10	6776	2260	1821	1821
q11	470	290	262	262
q12	334	351	214	214
q13	17776	3590	3004	3004
q14	238	233	220	220
q15	528	459	464	459
q16	439	433	374	374
q17	609	847	361	361
q18	6827	6427	6292	6292
q19	1202	951	533	533
q20	327	342	210	210
q21	2864	2132	1951	1951
q22	1039	1016	964	964
Total cold run time: 106453 ms
Total hot run time: 32383 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5562	5505	5495	5495
q2	235	336	232	232
q3	2180	2599	2314	2314
q4	1378	1783	1432	1432
q5	4389	4952	4958	4952
q6	171	159	131	131
q7	2084	1992	1834	1834
q8	2663	2822	2692	2692
q9	7366	7370	7310	7310
q10	3076	3363	2775	2775
q11	566	523	514	514
q12	711	817	597	597
q13	3405	3744	3130	3130
q14	281	307	272	272
q15	524	471	474	471
q16	438	496	434	434
q17	1197	1743	1272	1272
q18	7671	7311	7306	7306
q19	806	992	1113	992
q20	2037	2065	1895	1895
q21	5468	4856	4511	4511
q22	1052	1032	1027	1027
Total cold run time: 53260 ms
Total hot run time: 51588 ms

@doris-robot
Copy link

doris-robot commented Sep 18, 2025

TPC-DS: Total hot run time: 192131 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 0d78a1f4f9b6e46ff29e8c2ea4d223c277f3e6d0, data reload: false

query1	952	399	404	399
query2	6199	1942	1944	1942
query3	8688	219	207	207
query4	33484	24234	23316	23316
query5	4076	611	446	446
query6	292	189	196	189
query7	4208	488	318	318
query8	320	264	248	248
query9	9221	2606	2578	2578
query10	473	331	262	262
query11	17911	15492	15141	15141
query12	152	109	101	101
query13	1551	552	415	415
query14	9560	7031	6466	6466
query15	235	196	182	182
query16	8016	681	501	501
query17	1575	759	593	593
query18	2147	420	328	328
query19	249	189	164	164
query20	125	118	120	118
query21	201	133	109	109
query22	4595	4648	4468	4468
query23	35205	34202	34052	34052
query24	7488	2675	2670	2670
query25	513	497	432	432
query26	811	298	178	178
query27	2106	498	376	376
query28	5500	2256	2196	2196
query29	725	601	455	455
query30	246	198	177	177
query31	972	964	838	838
query32	87	62	58	58
query33	505	364	332	332
query34	746	871	541	541
query35	773	808	730	730
query36	1034	1084	994	994
query37	128	95	70	70
query38	4085	3993	4020	3993
query39	1539	1495	1476	1476
query40	231	125	117	117
query41	66	58	67	58
query42	138	120	117	117
query43	528	528	487	487
query44	1376	856	872	856
query45	198	185	187	185
query46	904	1098	704	704
query47	1999	2033	1979	1979
query48	444	442	368	368
query49	736	498	411	411
query50	699	709	448	448
query51	7357	7232	7212	7212
query52	118	118	101	101
query53	248	278	205	205
query54	578	565	482	482
query55	95	92	93	92
query56	292	296	269	269
query57	1271	1264	1231	1231
query58	252	237	231	231
query59	3125	3189	3045	3045
query60	319	268	290	268
query61	117	109	120	109
query62	791	772	688	688
query63	228	193	189	189
query64	3620	1019	644	644
query65	3368	3295	3335	3295
query66	891	411	315	315
query67	16546	16038	15768	15768
query68	7638	836	548	548
query69	489	299	268	268
query70	1176	1106	1137	1106
query71	387	307	267	267
query72	5812	3784	3800	3784
query73	644	740	354	354
query74	10034	9206	9118	9118
query75	3141	3122	2686	2686
query76	2995	1170	762	762
query77	532	371	281	281
query78	10321	10406	9555	9555
query79	3251	846	606	606
query80	662	521	428	428
query81	506	256	223	223
query82	571	116	87	87
query83	167	163	144	144
query84	284	102	74	74
query85	776	413	304	304
query86	343	326	295	295
query87	4267	4308	4217	4217
query88	4902	2420	2402	2402
query89	412	333	299	299
query90	1796	189	185	185
query91	160	142	110	110
query92	66	56	51	51
query93	1897	903	565	565
query94	687	400	313	313
query95	337	278	270	270
query96	498	619	283	283
query97	3194	3267	3113	3113
query98	220	214	199	199
query99	1551	1416	1301	1301
Total cold run time: 292944 ms
Total hot run time: 192131 ms

@doris-robot
Copy link

doris-robot commented Sep 18, 2025

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.02
query3	0.24	0.06	0.07
query4	1.63	0.10	0.10
query5	0.53	0.52	0.51
query6	1.13	0.74	0.73
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.56	0.48	0.50
query10	0.57	0.55	0.55
query11	0.14	0.10	0.10
query12	0.13	0.10	0.11
query13	0.61	0.61	0.59
query14	0.79	0.78	0.79
query15	0.84	0.84	0.83
query16	0.39	0.39	0.41
query17	1.05	1.00	0.99
query18	0.23	0.23	0.22
query19	1.84	1.78	1.70
query20	0.01	0.01	0.02
query21	15.40	0.94	0.60
query22	0.75	0.97	0.66
query23	14.90	1.49	0.67
query24	3.52	1.93	1.11
query25	0.19	0.25	0.09
query26	0.34	0.14	0.13
query27	0.06	0.03	0.04
query28	13.45	0.97	0.43
query29	12.58	3.85	3.22
query30	0.25	0.10	0.09
query31	2.81	0.57	0.37
query32	3.23	0.55	0.46
query33	2.98	2.98	3.05
query34	16.50	5.21	4.53
query35	4.58	4.54	4.61
query36	0.64	0.50	0.48
query37	0.08	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.03	0.02
query40	0.17	0.14	0.13
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 103.52 s
Total hot run time: 28.93 s

@morrySnow morrySnow changed the title branch-3.1:[opt](properties) remove old dlf properties (#55555) #55555 branch-3.1:[opt](properties) remove old dlf properties #55555 Sep 25, 2025
@morrySnow morrySnow merged commit 247bab2 into apache:branch-3.1 Sep 25, 2025
24 checks passed
@CalvinKirs CalvinKirs deleted the branch-3.1-55625 branch September 26, 2025 03:15
@morrySnow morrySnow mentioned this pull request Oct 23, 2025
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@morningman morningman morningman approved these changes

@morrySnow morrySnow morrySnow approved these changes

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@CalvinKirs @hello-stephen @doris-robot @morningman @morrySnow