Skip to content

[feat](table) let compress type be configable #56074

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
dataroaring merged 4 commits into from
Sep 17, 2025
Merged

[feat](table) let compress type be configable #56074

dataroaring merged 4 commits into from
Sep 17, 2025

Conversation

@dataroaring
Copy link
Contributor

@dataroaring dataroaring commented Sep 15, 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

@Thearas
Copy link
Contributor

Thearas commented Sep 15, 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?

@dataroaring
Copy link
Contributor Author

dataroaring commented Sep 15, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Sep 15, 2025

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

------ Round 1 ----------------------------------
q1	17602	5168	5118	5118
q2	2015	320	214	214
q3	10263	1292	732	732
q4	10236	1039	533	533
q5	7537	2387	2346	2346
q6	194	174	139	139
q7	912	784	645	645
q8	9354	1400	1154	1154
q9	6914	5129	5126	5126
q10	6981	2372	2014	2014
q11	506	326	281	281
q12	354	381	240	240
q13	17795	3726	3084	3084
q14	239	243	227	227
q15	569	494	491	491
q16	1014	1021	948	948
q17	604	860	363	363
q18	7457	7085	7007	7007
q19	1475	968	593	593
q20	351	346	241	241
q21	4002	3265	2414	2414
q22	1071	1032	981	981
Total cold run time: 107445 ms
Total hot run time: 34891 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5172	5128	5126	5126
q2	254	338	230	230
q3	2173	2660	2309	2309
q4	1364	1764	1351	1351
q5	4231	4615	4572	4572
q6	224	181	132	132
q7	2071	2006	1897	1897
q8	2735	2739	2621	2621
q9	7399	7284	7340	7284
q10	3170	3324	2897	2897
q11	606	515	514	514
q12	717	811	660	660
q13	3476	3979	3448	3448
q14	315	305	270	270
q15	533	497	482	482
q16	1119	1115	1090	1090
q17	1222	1537	1422	1422
q18	8035	7819	7602	7602
q19	821	826	892	826
q20	1924	1969	1830	1830
q21	4868	4376	4315	4315
q22	1100	1036	979	979
Total cold run time: 53529 ms
Total hot run time: 51857 ms

@doris-robot
Copy link

doris-robot commented Sep 15, 2025

TPC-DS: Total hot run time: 188192 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 3a45f154de8f863553146f89eba43b5c6586df47, data reload: false

query1	1112	452	414	414
query2	6542	1699	1736	1699
query3	6770	221	219	219
query4	26084	23262	22928	22928
query5	4459	646	484	484
query6	357	241	228	228
query7	4656	521	306	306
query8	305	265	262	262
query9	8687	2663	2647	2647
query10	516	352	292	292
query11	15372	15413	14837	14837
query12	176	116	113	113
query13	1686	577	452	452
query14	10996	9198	9226	9198
query15	226	213	189	189
query16	7741	708	496	496
query17	1254	760	658	658
query18	2064	509	330	330
query19	204	199	177	177
query20	136	125	119	119
query21	214	132	122	122
query22	4025	4106	4043	4043
query23	34131	32993	32954	32954
query24	8450	2421	2437	2421
query25	569	523	452	452
query26	770	284	163	163
query27	2688	507	371	371
query28	4327	2213	2223	2213
query29	716	608	487	487
query30	293	231	199	199
query31	925	818	792	792
query32	89	72	80	72
query33	584	382	340	340
query34	807	848	534	534
query35	784	829	741	741
query36	981	1015	905	905
query37	121	112	89	89
query38	3539	3475	3455	3455
query39	1465	1434	1432	1432
query40	216	136	121	121
query41	66	63	62	62
query42	134	120	123	120
query43	523	525	491	491
query44	1380	858	848	848
query45	187	192	179	179
query46	849	1045	660	660
query47	1737	1814	1730	1730
query48	398	429	331	331
query49	728	533	409	409
query50	673	685	414	414
query51	3998	3967	3848	3848
query52	115	108	103	103
query53	252	271	201	201
query54	607	588	532	532
query55	91	85	82	82
query56	352	339	295	295
query57	1187	1183	1134	1134
query58	282	268	276	268
query59	2530	2613	2542	2542
query60	374	338	336	336
query61	173	157	160	157
query62	874	745	664	664
query63	236	204	190	190
query64	3439	1133	806	806
query65	4125	3958	3971	3958
query66	887	504	336	336
query67	15552	15442	15165	15165
query68	8364	952	592	592
query69	490	316	286	286
query70	1377	1229	1267	1229
query71	561	343	310	310
query72	6125	5026	5198	5026
query73	751	683	364	364
query74	9122	9111	8699	8699
query75	4023	3302	2771	2771
query76	3588	1174	728	728
query77	806	415	336	336
query78	9614	9773	8872	8872
query79	2293	853	590	590
query80	717	585	501	501
query81	480	264	237	237
query82	426	158	133	133
query83	306	264	250	250
query84	307	117	103	103
query85	885	476	502	476
query86	351	335	317	317
query87	3784	3764	3633	3633
query88	2969	2244	2230	2230
query89	400	340	294	294
query90	1940	212	210	210
query91	169	166	136	136
query92	79	69	61	61
query93	1211	1008	657	657
query94	696	412	343	343
query95	407	318	308	308
query96	485	574	280	280
query97	2966	2990	2870	2870
query98	252	209	210	209
query99	1467	1437	1326	1326
Total cold run time: 274197 ms
Total hot run time: 188192 ms

@doris-robot
Copy link

doris-robot commented Sep 15, 2025

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

query1	0.06	0.05	0.05
query2	0.09	0.06	0.06
query3	0.25	0.08	0.09
query4	1.61	0.12	0.11
query5	0.27	0.27	0.25
query6	1.17	0.66	0.65
query7	0.03	0.02	0.02
query8	0.05	0.05	0.04
query9	0.63	0.51	0.53
query10	0.59	0.58	0.58
query11	0.16	0.12	0.12
query12	0.15	0.12	0.12
query13	0.66	0.63	0.62
query14	1.06	1.06	1.02
query15	0.88	0.86	0.86
query16	0.42	0.41	0.41
query17	1.05	1.04	1.06
query18	0.21	0.21	0.20
query19	1.95	1.83	1.82
query20	0.02	0.01	0.01
query21	15.42	0.96	0.60
query22	0.76	1.27	0.70
query23	14.80	1.43	0.71
query24	7.22	1.65	0.74
query25	0.52	0.25	0.12
query26	0.51	0.16	0.15
query27	0.08	0.06	0.06
query28	10.06	0.88	0.44
query29	12.57	3.94	3.27
query30	0.28	0.13	0.11
query31	2.84	0.60	0.38
query32	3.24	0.57	0.48
query33	3.08	3.19	3.16
query34	16.06	5.52	4.85
query35	5.00	4.92	4.92
query36	0.71	0.52	0.51
query37	0.11	0.08	0.08
query38	0.06	0.05	0.05
query39	0.04	0.04	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.05	0.04	0.04
Total cold run time: 105.03 s
Total hot run time: 30.16 s

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 15, 2025

FE Regression Coverage Report

Increment line coverage 50.00% (7/14) 🎉
Increment coverage report
Complete coverage report

@dataroaring
Copy link
Contributor Author

dataroaring commented Sep 16, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

------ Round 1 ----------------------------------
q1	17610	5245	5103	5103
q2	2012	319	207	207
q3	10289	1289	738	738
q4	10240	1033	526	526
q5	7570	2470	2378	2378
q6	188	169	136	136
q7	929	783	643	643
q8	9350	1414	1173	1173
q9	6804	5062	5146	5062
q10	6987	2416	2001	2001
q11	490	313	270	270
q12	348	370	232	232
q13	17781	3728	3055	3055
q14	253	245	215	215
q15	583	500	498	498
q16	1012	1007	934	934
q17	600	875	371	371
q18	7926	7072	6937	6937
q19	1479	959	589	589
q20	350	344	234	234
q21	3777	3256	2402	2402
q22	1058	1030	968	968
Total cold run time: 107636 ms
Total hot run time: 34672 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5226	5129	5099	5099
q2	254	338	240	240
q3	2202	2662	2277	2277
q4	1340	1808	1374	1374
q5	4296	4603	4510	4510
q6	221	179	137	137
q7	2049	2082	1769	1769
q8	2694	2818	2649	2649
q9	7339	7352	7296	7296
q10	3113	3309	2872	2872
q11	584	564	511	511
q12	714	790	633	633
q13	3521	4089	3461	3461
q14	293	309	301	301
q15	534	490	490	490
q16	1043	1077	1089	1077
q17	1257	1604	1467	1467
q18	8153	7995	7529	7529
q19	837	862	980	862
q20	1939	1948	1843	1843
q21	4802	4308	4353	4308
q22	1098	1059	992	992
Total cold run time: 53509 ms
Total hot run time: 51697 ms

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

query1	1059	448	406	406
query2	6570	1730	1713	1713
query3	6747	217	225	217
query4	26428	23867	23162	23162
query5	4405	624	475	475
query6	335	262	227	227
query7	4651	526	305	305
query8	315	267	266	266
query9	8688	2634	2673	2634
query10	509	366	325	325
query11	15708	15011	14843	14843
query12	169	119	116	116
query13	1691	571	461	461
query14	10941	9206	9287	9206
query15	206	202	176	176
query16	7724	695	514	514
query17	1215	738	634	634
query18	2042	431	335	335
query19	256	203	178	178
query20	134	140	128	128
query21	215	138	118	118
query22	3998	4151	3934	3934
query23	33915	33061	32842	32842
query24	8428	2432	2429	2429
query25	560	510	444	444
query26	1232	277	166	166
query27	2743	512	358	358
query28	4370	2218	2194	2194
query29	834	626	483	483
query30	289	227	201	201
query31	932	786	714	714
query32	83	74	75	74
query33	597	379	355	355
query34	819	857	525	525
query35	818	834	736	736
query36	985	1050	906	906
query37	126	113	88	88
query38	3530	3549	3540	3540
query39	1529	1471	1478	1471
query40	232	136	132	132
query41	66	66	73	66
query42	130	121	117	117
query43	519	510	478	478
query44	1385	846	851	846
query45	188	181	178	178
query46	894	1052	672	672
query47	1802	1802	1729	1729
query48	397	433	322	322
query49	771	508	436	436
query50	701	708	412	412
query51	3931	3907	3875	3875
query52	109	119	107	107
query53	255	276	191	191
query54	606	600	566	566
query55	92	86	86	86
query56	323	340	321	321
query57	1205	1195	1129	1129
query58	274	274	266	266
query59	2584	2641	2548	2548
query60	349	349	332	332
query61	168	161	160	160
query62	836	747	645	645
query63	235	203	205	203
query64	4457	1156	818	818
query65	4045	3988	3967	3967
query66	1080	439	339	339
query67	15695	15260	15088	15088
query68	7988	952	587	587
query69	489	334	293	293
query70	1357	1337	1237	1237
query71	594	338	316	316
query72	6295	4982	4919	4919
query73	637	609	355	355
query74	8956	9257	9003	9003
query75	3498	3319	2808	2808
query76	3384	1201	789	789
query77	672	402	315	315
query78	9735	9711	8869	8869
query79	2744	892	590	590
query80	688	558	499	499
query81	503	263	237	237
query82	539	159	132	132
query83	265	277	259	259
query84	261	116	98	98
query85	965	463	425	425
query86	387	314	331	314
query87	3690	3789	3675	3675
query88	3955	2234	2249	2234
query89	403	346	318	318
query90	1899	217	223	217
query91	180	171	137	137
query92	89	70	63	63
query93	2411	998	641	641
query94	740	444	333	333
query95	402	322	314	314
query96	492	570	279	279
query97	2947	2974	2902	2902
query98	247	214	208	208
query99	1414	1401	1311	1311
Total cold run time: 277951 ms
Total hot run time: 188605 ms

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

query1	0.06	0.04	0.05
query2	0.10	0.05	0.06
query3	0.25	0.09	0.09
query4	1.61	0.12	0.12
query5	0.27	0.26	0.25
query6	1.22	0.64	0.64
query7	0.04	0.03	0.02
query8	0.05	0.04	0.05
query9	0.62	0.53	0.52
query10	0.59	0.57	0.58
query11	0.16	0.12	0.11
query12	0.16	0.12	0.13
query13	0.63	0.62	0.63
query14	1.05	1.06	1.02
query15	0.88	0.85	0.87
query16	0.40	0.39	0.40
query17	1.04	1.08	1.03
query18	0.21	0.20	0.20
query19	1.90	1.85	1.84
query20	0.02	0.01	0.02
query21	15.43	0.93	0.58
query22	0.76	1.23	0.64
query23	14.91	1.40	0.63
query24	6.61	1.60	1.25
query25	0.51	0.20	0.07
query26	0.48	0.17	0.13
query27	0.07	0.05	0.05
query28	10.12	0.88	0.45
query29	12.59	3.89	3.26
query30	0.27	0.13	0.12
query31	2.83	0.59	0.37
query32	3.24	0.56	0.50
query33	3.17	3.05	3.05
query34	16.04	5.45	4.90
query35	4.90	4.90	4.94
query36	0.73	0.53	0.51
query37	0.10	0.07	0.08
query38	0.06	0.05	0.05
query39	0.04	0.03	0.02
query40	0.18	0.15	0.14
query41	0.08	0.03	0.04
query42	0.04	0.03	0.03
query43	0.05	0.04	0.03
Total cold run time: 104.47 s
Total hot run time: 30.31 s

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 16, 2025

FE UT Coverage Report

Increment line coverage 50.00% (7/14) 🎉
Increment coverage report
Complete coverage report

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 16, 2025

FE Regression Coverage Report

Increment line coverage 50.00% (7/14) 🎉
Increment coverage report
Complete coverage report

@dataroaring
Copy link
Contributor Author

dataroaring commented Sep 16, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

------ Round 1 ----------------------------------
q1	17607	5219	5068	5068
q2	2027	326	233	233
q3	10263	1332	743	743
q4	10250	1037	542	542
q5	7526	2451	2419	2419
q6	183	170	143	143
q7	975	804	652	652
q8	9372	1344	1160	1160
q9	7040	5072	5136	5072
q10	6917	2409	1966	1966
q11	492	315	279	279
q12	358	393	232	232
q13	17806	3671	3060	3060
q14	250	253	236	236
q15	566	488	489	488
q16	1024	1015	950	950
q17	637	881	362	362
q18	7676	7278	7043	7043
q19	1236	980	574	574
q20	352	356	235	235
q21	3916	3268	2399	2399
q22	1042	1042	970	970
Total cold run time: 107515 ms
Total hot run time: 34826 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5236	5117	5115	5115
q2	262	333	235	235
q3	2241	2686	2304	2304
q4	1329	1828	1342	1342
q5	4299	4658	4596	4596
q6	229	187	136	136
q7	2066	1997	1849	1849
q8	2652	2576	2549	2549
q9	7458	7291	7252	7252
q10	3146	3383	2898	2898
q11	606	535	549	535
q12	717	789	642	642
q13	3513	3949	3477	3477
q14	287	315	315	315
q15	521	496	510	496
q16	1099	1118	1024	1024
q17	1182	1647	1445	1445
q18	8002	7677	7508	7508
q19	825	911	994	911
q20	2093	2163	1941	1941
q21	5214	4640	4423	4423
q22	1073	1044	992	992
Total cold run time: 54050 ms
Total hot run time: 51985 ms

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

query1	1082	460	404	404
query2	6556	1772	1721	1721
query3	6759	231	219	219
query4	26321	23625	22920	22920
query5	4397	628	472	472
query6	334	240	230	230
query7	4643	523	299	299
query8	308	260	240	240
query9	8693	2641	2640	2640
query10	488	329	288	288
query11	15885	15090	14864	14864
query12	166	121	110	110
query13	1677	567	437	437
query14	10569	9173	9199	9173
query15	207	195	177	177
query16	7161	698	507	507
query17	989	754	634	634
query18	2016	424	346	346
query19	217	207	183	183
query20	134	128	124	124
query21	218	135	116	116
query22	4066	4275	3910	3910
query23	34022	32783	32907	32783
query24	8468	2451	2466	2451
query25	598	557	470	470
query26	1249	283	166	166
query27	2742	508	373	373
query28	4406	2254	2222	2222
query29	847	624	518	518
query30	294	293	207	207
query31	926	816	736	736
query32	86	73	70	70
query33	589	378	325	325
query34	800	852	522	522
query35	826	844	732	732
query36	991	1036	915	915
query37	122	109	87	87
query38	3565	3509	3492	3492
query39	1495	1434	1504	1434
query40	224	136	124	124
query41	63	62	62	62
query42	132	111	113	111
query43	506	511	488	488
query44	1353	868	853	853
query45	186	179	174	174
query46	859	1067	637	637
query47	1761	1799	1697	1697
query48	396	423	326	326
query49	772	504	416	416
query50	662	686	414	414
query51	3877	3914	3913	3913
query52	111	113	100	100
query53	239	270	207	207
query54	605	586	529	529
query55	91	85	83	83
query56	323	326	297	297
query57	1193	1210	1103	1103
query58	280	274	263	263
query59	2619	2696	2527	2527
query60	365	329	326	326
query61	181	159	158	158
query62	832	770	680	680
query63	233	194	195	194
query64	4541	1197	839	839
query65	4036	3986	3966	3966
query66	1174	435	385	385
query67	15715	15355	15141	15141
query68	9375	929	580	580
query69	487	320	283	283
query70	1422	1261	1266	1261
query71	583	341	303	303
query72	6023	5001	2722	2722
query73	780	614	367	367
query74	9081	9165	9029	9029
query75	4365	3290	2806	2806
query76	4172	1164	738	738
query77	1007	422	315	315
query78	9635	9736	8824	8824
query79	3257	916	614	614
query80	685	583	536	536
query81	486	259	229	229
query82	529	161	129	129
query83	308	270	256	256
query84	299	116	100	100
query85	884	462	423	423
query86	343	313	308	308
query87	3760	3768	3646	3646
query88	2847	2237	2264	2237
query89	441	335	302	302
query90	1952	229	222	222
query91	168	164	138	138
query92	85	73	65	65
query93	2225	1037	662	662
query94	704	453	337	337
query95	400	317	317	317
query96	480	570	281	281
query97	2956	2959	2902	2902
query98	251	216	209	209
query99	1468	1456	1291	1291
Total cold run time: 279699 ms
Total hot run time: 185962 ms

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

query1	0.06	0.05	0.04
query2	0.09	0.05	0.06
query3	0.25	0.08	0.08
query4	1.61	0.12	0.12
query5	0.28	0.28	0.25
query6	1.16	0.65	0.64
query7	0.03	0.04	0.03
query8	0.05	0.04	0.04
query9	0.61	0.53	0.53
query10	0.60	0.58	0.57
query11	0.16	0.12	0.12
query12	0.16	0.12	0.12
query13	0.63	0.63	0.63
query14	1.02	1.02	1.05
query15	0.88	0.86	0.88
query16	0.41	0.43	0.42
query17	1.07	1.06	1.07
query18	0.22	0.21	0.20
query19	1.96	1.81	1.80
query20	0.02	0.02	0.01
query21	15.45	0.94	0.60
query22	0.76	1.21	0.64
query23	14.96	1.37	0.64
query24	7.11	0.88	0.90
query25	0.46	0.30	0.07
query26	0.51	0.16	0.13
query27	0.08	0.06	0.06
query28	9.35	0.95	0.44
query29	12.56	4.03	3.27
query30	0.29	0.15	0.11
query31	2.83	0.63	0.39
query32	3.25	0.55	0.47
query33	3.09	3.16	3.08
query34	16.04	5.48	4.83
query35	4.97	4.91	4.92
query36	0.68	0.51	0.50
query37	0.11	0.07	0.07
query38	0.06	0.05	0.04
query39	0.04	0.03	0.03
query40	0.18	0.14	0.14
query41	0.09	0.03	0.03
query42	0.04	0.03	0.03
query43	0.05	0.03	0.03
Total cold run time: 104.23 s
Total hot run time: 29.98 s

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 16, 2025

FE UT Coverage Report

Increment line coverage 56.25% (9/16) 🎉
Increment coverage report
Complete coverage report

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 16, 2025

FE Regression Coverage Report

Increment line coverage 56.25% (9/16) 🎉
Increment coverage report
Complete coverage report

@dataroaring
Copy link
Contributor Author

dataroaring commented Sep 16, 2025

run buildall

1 similar comment
@dataroaring
Copy link
Contributor Author

dataroaring commented Sep 16, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

------ Round 1 ----------------------------------
q1	17653	5187	5053	5053
q2	1995	317	207	207
q3	10300	1280	704	704
q4	10233	1021	536	536
q5	7559	2401	2350	2350
q6	186	169	138	138
q7	927	765	637	637
q8	9360	1283	1113	1113
q9	6847	5182	5178	5178
q10	6951	2411	2007	2007
q11	510	305	298	298
q12	353	364	232	232
q13	17781	3638	3049	3049
q14	233	260	217	217
q15	605	484	503	484
q16	984	1020	947	947
q17	614	857	349	349
q18	7390	7034	7021	7021
q19	1153	958	547	547
q20	343	339	223	223
q21	3667	2572	2386	2386
q22	1086	1061	1029	1029
Total cold run time: 106730 ms
Total hot run time: 34705 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5134	5056	5130	5056
q2	250	331	227	227
q3	2163	2643	2324	2324
q4	1347	1791	1341	1341
q5	4241	4370	4499	4370
q6	221	171	157	157
q7	2057	2005	1885	1885
q8	2628	2608	2620	2608
q9	7260	7384	7285	7285
q10	3107	3337	2922	2922
q11	587	541	504	504
q12	694	835	658	658
q13	3716	3858	3228	3228
q14	298	319	287	287
q15	528	502	507	502
q16	1130	1112	1079	1079
q17	1208	1573	1398	1398
q18	7894	7857	7593	7593
q19	778	901	1059	901
q20	1969	1999	1789	1789
q21	4810	4304	4384	4304
q22	1107	1079	1023	1023
Total cold run time: 53127 ms
Total hot run time: 51441 ms

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

query1	1087	461	404	404
query2	6548	1740	1751	1740
query3	6748	225	225	225
query4	26044	23498	22882	22882
query5	4397	608	454	454
query6	334	263	252	252
query7	4653	518	306	306
query8	346	271	248	248
query9	9192	2608	2631	2608
query10	514	389	304	304
query11	15624	15284	14953	14953
query12	166	114	112	112
query13	1675	567	423	423
query14	10793	9515	9449	9449
query15	215	196	176	176
query16	7669	683	511	511
query17	1261	767	683	683
query18	2051	431	339	339
query19	216	212	188	188
query20	138	129	127	127
query21	224	135	117	117
query22	4134	4260	3996	3996
query23	34266	33017	33204	33017
query24	8512	2500	2504	2500
query25	601	546	485	485
query26	1237	280	168	168
query27	2717	507	369	369
query28	4343	2214	2186	2186
query29	786	593	491	491
query30	291	230	206	206
query31	910	828	738	738
query32	79	75	73	73
query33	574	365	447	365
query34	800	865	527	527
query35	807	854	739	739
query36	969	1051	947	947
query37	121	113	86	86
query38	3531	3561	3550	3550
query39	1489	1450	1441	1441
query40	222	137	119	119
query41	63	63	64	63
query42	131	113	111	111
query43	521	526	477	477
query44	1352	837	847	837
query45	188	186	170	170
query46	875	1033	669	669
query47	1797	1790	1712	1712
query48	398	431	319	319
query49	756	507	415	415
query50	676	702	409	409
query51	3977	4023	3935	3935
query52	117	116	101	101
query53	232	265	207	207
query54	621	589	518	518
query55	89	87	85	85
query56	330	335	320	320
query57	1195	1193	1124	1124
query58	281	270	268	268
query59	2647	2655	2520	2520
query60	332	336	314	314
query61	169	155	158	155
query62	830	698	679	679
query63	231	207	191	191
query64	4463	1159	890	890
query65	4068	3998	3957	3957
query66	1129	457	335	335
query67	15318	15442	14921	14921
query68	8859	944	588	588
query69	491	321	283	283
query70	1388	1302	1336	1302
query71	554	336	313	313
query72	5862	4953	5064	4953
query73	726	622	364	364
query74	9016	9263	8590	8590
query75	4389	3328	2846	2846
query76	3715	1184	758	758
query77	815	435	335	335
query78	9754	9672	8933	8933
query79	2704	822	587	587
query80	716	636	498	498
query81	471	261	236	236
query82	494	156	127	127
query83	300	276	250	250
query84	309	108	88	88
query85	898	531	433	433
query86	351	303	309	303
query87	3768	3750	3578	3578
query88	3488	2252	2246	2246
query89	426	349	291	291
query90	1950	221	219	219
query91	181	174	140	140
query92	88	69	62	62
query93	2055	1011	658	658
query94	693	433	323	323
query95	397	321	304	304
query96	494	563	277	277
query97	2948	3000	2892	2892
query98	239	223	216	216
query99	1522	1438	1329	1329
Total cold run time: 279131 ms
Total hot run time: 188528 ms

@doris-robot
Copy link

doris-robot commented Sep 16, 2025

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

query1	0.05	0.05	0.05
query2	0.09	0.05	0.05
query3	0.27	0.09	0.08
query4	1.60	0.12	0.11
query5	0.28	0.28	0.25
query6	1.22	0.66	0.65
query7	0.03	0.03	0.03
query8	0.06	0.05	0.05
query9	0.62	0.52	0.52
query10	0.59	0.58	0.57
query11	0.17	0.12	0.12
query12	0.16	0.13	0.12
query13	0.63	0.63	0.62
query14	1.04	1.02	1.05
query15	0.90	0.86	0.88
query16	0.40	0.41	0.40
query17	1.03	1.07	1.04
query18	0.21	0.19	0.20
query19	1.99	1.88	1.82
query20	0.01	0.01	0.01
query21	15.45	0.92	0.57
query22	0.76	1.21	0.62
query23	14.97	1.38	0.60
query24	7.06	0.79	1.10
query25	0.47	0.25	0.09
query26	0.59	0.16	0.13
query27	0.07	0.05	0.06
query28	9.89	0.90	0.45
query29	12.56	3.96	3.27
query30	0.27	0.14	0.12
query31	2.83	0.60	0.40
query32	3.24	0.57	0.49
query33	3.08	3.13	3.11
query34	15.89	5.49	4.81
query35	4.94	4.93	4.92
query36	0.69	0.52	0.50
query37	0.10	0.08	0.07
query38	0.07	0.05	0.04
query39	0.04	0.03	0.02
query40	0.18	0.15	0.14
query41	0.09	0.04	0.03
query42	0.04	0.03	0.02
query43	0.05	0.03	0.03
Total cold run time: 104.68 s
Total hot run time: 29.83 s

@hello-stephen
Copy link
Contributor

hello-stephen commented Sep 16, 2025

FE Regression Coverage Report

Increment line coverage 56.25% (9/16) 🎉
Increment coverage report
Complete coverage report

@github-actions
Copy link
Contributor

github-actions bot commented Sep 17, 2025

PR approved by at least one committer and no changes requested.

@github-actions github-actions bot added approved Indicates a PR has been approved by one committer. reviewed labels Sep 17, 2025
@github-actions
Copy link
Contributor

github-actions bot commented Sep 17, 2025

PR approved by anyone and no changes requested.

@dataroaring dataroaring merged commit 173e248 into apache:master Sep 17, 2025
27 of 29 checks passed
github-actions bot pushed a commit that referenced this pull request Sep 22, 2025
@dataroaring
[feat](table) let compress type be configable (#56074)
eed2d71
@github-actions github-actions bot mentioned this pull request Sep 22, 2025
Merged
morrySnow pushed a commit that referenced this pull request Sep 25, 2025
@github-actions @dataroaring
branch-3.1: [feat](table) let compress type be configable #56074 (#56276
29fb03f 
)

Cherry-picked from #56074

Co-authored-by: Yongqiang YANG <yangyongqiang@selectdb.com>
yiguolei pushed a commit to yiguolei/incubator-doris that referenced this pull request Sep 28, 2025
@selectdb-robot @dataroaring
branch-selectdb-doris-3.0: [feat](table) let compress type be configa…
08511c6 
…ble apache#56074 (apache#4666)

cherry-picks from apache#56074
Related to apache#4562

Co-authored-by: Yongqiang YANG <yangyongqiang@selectdb.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@gavinchou gavinchou gavinchou approved these changes

@luwei16 luwei16 luwei16 approved these changes

Assignees

No one assigned

Labels

approved Indicates a PR has been approved by one committer. dev/3.1.2-merged reviewed

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

7 participants

@dataroaring @Thearas @doris-robot @hello-stephen @gavinchou @luwei16 @morrySnow