Skip to content

branch-3.1: [enhancement](time_series) increase the version limit for the time series table #51371 #52073

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 1 commit into from
Jun 23, 2025
Merged

branch-3.1: [enhancement](time_series) increase the version limit for the time series table #51371 #52073

morrySnow merged 1 commit into from
Jun 23, 2025

Conversation

@luwei16
Copy link
Contributor

@luwei16 luwei16 commented Jun 20, 2025

pick master #51371

@luwei16 luwei16 requested a review from morrySnow as a code owner June 20, 2025 09:37
@Thearas
Copy link
Contributor

Thearas commented Jun 20, 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?

@luwei16
Copy link
Contributor Author

luwei16 commented Jun 20, 2025

run buildall

@doris-robot
Copy link

doris-robot commented Jun 20, 2025

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

------ Round 1 ----------------------------------
q1	17846	6884	6600	6600
q2	2081	168	163	163
q3	10723	1085	1187	1085
q4	10574	769	805	769
q5	7741	2870	2845	2845
q6	214	135	130	130
q7	967	609	606	606
q8	9355	1940	1979	1940
q9	6652	6401	6465	6401
q10	6968	2244	2252	2244
q11	458	252	262	252
q12	389	207	206	206
q13	17781	2982	3005	2982
q14	239	203	201	201
q15	512	475	478	475
q16	481	384	371	371
q17	989	552	511	511
q18	7309	6685	6678	6678
q19	1431	1036	975	975
q20	467	201	207	201
q21	3914	3115	3099	3099
q22	1097	1017	993	993
Total cold run time: 108188 ms
Total hot run time: 39727 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6610	6571	6621	6571
q2	327	231	235	231
q3	2960	2806	2871	2806
q4	2034	1778	1712	1712
q5	5798	5759	5745	5745
q6	211	128	128	128
q7	2241	1790	1773	1773
q8	3325	3576	3507	3507
q9	9005	8783	8887	8783
q10	3578	3513	3491	3491
q11	603	493	484	484
q12	812	596	634	596
q13	9314	3081	3102	3081
q14	305	269	291	269
q15	518	464	461	461
q16	469	439	451	439
q17	1859	1586	1625	1586
q18	8098	7908	7811	7811
q19	1700	1642	1613	1613
q20	2115	1904	1821	1821
q21	4946	4920	5030	4920
q22	1113	1039	1043	1039
Total cold run time: 67941 ms
Total hot run time: 58867 ms

@doris-robot
Copy link

doris-robot commented Jun 20, 2025

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

query1	1273	918	898	898
query2	6284	1912	1791	1791
query3	10836	4485	4294	4294
query4	61542	29706	23381	23381
query5	5171	447	461	447
query6	405	178	181	178
query7	5443	313	314	313
query8	326	231	222	222
query9	8602	2562	2577	2562
query10	462	270	267	267
query11	17911	15122	15702	15122
query12	159	118	99	99
query13	1398	440	435	435
query14	9724	7176	7087	7087
query15	191	176	172	172
query16	7194	436	444	436
query17	1191	577	601	577
query18	1979	324	316	316
query19	210	157	163	157
query20	118	108	113	108
query21	209	104	109	104
query22	4750	4534	4541	4534
query23	34481	33998	34339	33998
query24	6129	2933	2957	2933
query25	521	416	412	412
query26	648	164	171	164
query27	1782	361	359	359
query28	4219	2151	2148	2148
query29	700	470	457	457
query30	232	161	157	157
query31	984	798	835	798
query32	69	58	61	58
query33	440	305	301	301
query34	912	499	509	499
query35	849	765	745	745
query36	1077	927	968	927
query37	117	74	84	74
query38	4044	3991	3984	3984
query39	1566	1471	1461	1461
query40	198	101	99	99
query41	48	47	48	47
query42	115	103	106	103
query43	534	476	493	476
query44	1194	817	804	804
query45	185	164	181	164
query46	1146	711	710	710
query47	2036	1935	1979	1935
query48	482	370	380	370
query49	733	389	388	388
query50	821	429	426	426
query51	7631	7351	7321	7321
query52	98	92	88	88
query53	265	187	189	187
query54	568	489	455	455
query55	77	80	76	76
query56	260	247	250	247
query57	1314	1226	1220	1220
query58	222	204	208	204
query59	3228	2932	2985	2932
query60	286	265	259	259
query61	129	108	105	105
query62	766	677	668	668
query63	212	181	180	180
query64	1373	652	622	622
query65	3244	3199	3164	3164
query66	712	292	294	292
query67	16130	15644	15642	15642
query68	4199	591	570	570
query69	430	263	257	257
query70	1167	1094	1087	1087
query71	338	243	238	238
query72	6419	3986	3990	3986
query73	750	358	345	345
query74	10363	9292	8946	8946
query75	3373	2668	2674	2668
query76	2018	1035	1153	1035
query77	495	264	257	257
query78	10609	9563	9507	9507
query79	1355	591	583	583
query80	877	424	426	424
query81	504	219	215	215
query82	1268	91	85	85
query83	239	146	141	141
query84	286	81	79	79
query85	941	293	282	282
query86	321	293	295	293
query87	4362	4213	4220	4213
query88	3507	2350	2327	2327
query89	415	295	291	291
query90	2002	186	181	181
query91	180	147	145	145
query92	66	48	48	48
query93	1859	545	550	545
query94	733	279	295	279
query95	343	252	252	252
query96	612	286	282	282
query97	3309	3140	3135	3135
query98	217	201	197	197
query99	1912	1336	1310	1310
Total cold run time: 313624 ms
Total hot run time: 196362 ms

@doris-robot
Copy link

doris-robot commented Jun 20, 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 ae4b6ad7640d2f357968c26f25ba312b210c4e93, data reload: false

query1	0.03	0.02	0.02
query2	0.07	0.03	0.02
query3	0.23	0.06	0.06
query4	1.62	0.10	0.10
query5	0.52	0.50	0.51
query6	1.14	0.72	0.72
query7	0.02	0.02	0.03
query8	0.04	0.04	0.03
query9	0.57	0.49	0.50
query10	0.55	0.55	0.56
query11	0.14	0.10	0.11
query12	0.14	0.11	0.11
query13	0.60	0.60	0.60
query14	0.79	0.79	0.79
query15	0.83	0.83	0.82
query16	0.41	0.41	0.39
query17	1.05	1.00	1.02
query18	0.24	0.22	0.22
query19	1.96	1.77	1.79
query20	0.01	0.01	0.02
query21	15.42	0.56	0.58
query22	2.52	1.96	1.69
query23	16.82	0.84	0.77
query24	3.30	0.97	1.58
query25	0.16	0.05	0.14
query26	0.61	0.14	0.13
query27	0.04	0.05	0.04
query28	9.65	0.52	0.51
query29	12.60	3.19	3.23
query30	0.25	0.06	0.06
query31	2.85	0.38	0.37
query32	3.25	0.46	0.45
query33	2.99	3.00	3.06
query34	16.87	4.45	4.47
query35	4.54	4.51	4.50
query36	0.67	0.47	0.46
query37	0.09	0.06	0.07
query38	0.05	0.04	0.04
query39	0.04	0.02	0.02
query40	0.16	0.12	0.12
query41	0.09	0.02	0.03
query42	0.03	0.02	0.02
query43	0.03	0.04	0.03
Total cold run time: 103.99 s
Total hot run time: 29.83 s

@doris-robot
Copy link

doris-robot commented Jun 20, 2025

BE UT Coverage Report

Increment line coverage 35.29% (12/34) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 41.16% (10904/26491)
Line Coverage 31.98% (93331/291855)
Region Coverage 31.04% (48107/154992)
Branch Coverage 27.52% (24651/89588)

@morrySnow morrySnow merged commit b2a9fce into apache:branch-3.1 Jun 23, 2025
20 of 22 checks passed
@morrySnow morrySnow changed the title [enhancement](time_series) increase the version limit for the time series table (#51371) branch-3.1: [enhancement](time_series) increase the version limit for the time series table #51371 Jun 23, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@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.

4 participants

@luwei16 @Thearas @doris-robot @morrySnow