Skip to content

branch-3.1: [opt](iceberg)support drop tag and branch #52453 - #52961

Merged
morrySnow merged 1 commit into
apache:branch-3.1from
morningman:31_bp52453
Jul 9, 2025
Merged

branch-3.1: [opt](iceberg)support drop tag and branch #52453#52961
morrySnow merged 1 commit into
apache:branch-3.1from
morningman:31_bp52453

Conversation

@morningman

@morningman morningman commented Jul 8, 2025

Copy link
Copy Markdown
Contributor

bp #52453

@morningman
morningman requested a review from morrySnow as a code owner July 8, 2025 12:36
@Thearas

Thearas commented Jul 8, 2025

Copy link
Copy Markdown
Contributor

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?

@wuwenchi wuwenchi.wwc @morningman
[opt](iceberg)support drop tag and branch (apache#52453)
149f7c3 
Related Issue: apache#48285

Problem Summary:

support drop tag and branch:
```sql
alter table tb1 drop branch b1;
alter table tb1 drop branch if exists b2;

alter table tb1 drop tag t1;
alter table tb1 drop tag if exists t2;
```

Co-authored-by: wuwenchi.wwc <[email protected]>
@morningman

morningman commented Jul 8, 2025

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Jul 8, 2025

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

------ Round 1 ----------------------------------
q1	17593	7131	6630	6630
q2	2083	228	175	175
q3	10462	1139	1166	1139
q4	10216	763	695	695
q5	7756	2863	2784	2784
q6	214	135	142	135
q7	989	632	624	624
q8	9369	1973	1981	1973
q9	6727	6397	6405	6397
q10	7000	2245	2287	2245
q11	455	264	266	264
q12	400	210	209	209
q13	17781	2970	2943	2943
q14	236	218	216	216
q15	499	470	475	470
q16	443	378	383	378
q17	979	548	554	548
q18	7255	6744	6727	6727
q19	1217	1050	962	962
q20	396	201	196	196
q21	4052	3102	3245	3102
q22	1072	997	1002	997
Total cold run time: 107194 ms
Total hot run time: 39809 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6595	6577	6552	6552
q2	327	235	236	235
q3	2900	2901	2934	2901
q4	2064	1785	1826	1785
q5	5632	5718	5673	5673
q6	204	128	125	125
q7	2207	1819	1772	1772
q8	3316	3451	3461	3451
q9	8818	8814	8791	8791
q10	3558	3524	3502	3502
q11	597	495	488	488
q12	800	595	642	595
q13	3848	3222	3099	3099
q14	299	272	275	272
q15	519	461	457	457
q16	491	467	454	454
q17	1823	1606	1573	1573
q18	8202	7815	7711	7711
q19	1679	1610	1448	1448
q20	2101	1917	1878	1878
q21	5181	4823	4763	4763
q22	1103	998	981	981
Total cold run time: 62264 ms
Total hot run time: 58506 ms

@doris-robot

doris-robot commented Jul 8, 2025

Copy link
Copy Markdown
TPC-DS: Total hot run time: 190061 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 149f7c39ecd008d33c4770eb02845e2f7ea4105e, data reload: false

query1	954	366	370	366
query2	6506	1953	1970	1953
query3	6708	216	224	216
query4	34011	23416	23238	23238
query5	4371	457	463	457
query6	277	174	174	174
query7	4626	306	313	306
query8	293	227	233	227
query9	9744	2573	2563	2563
query10	486	274	261	261
query11	18030	15219	15168	15168
query12	158	104	106	104
query13	1652	444	426	426
query14	9348	6506	6558	6506
query15	247	178	185	178
query16	8065	458	464	458
query17	1626	588	574	574
query18	2132	337	306	306
query19	215	161	159	159
query20	122	108	110	108
query21	206	108	103	103
query22	4710	4317	4155	4155
query23	34241	33839	33519	33519
query24	12442	2895	2857	2857
query25	713	417	414	414
query26	1890	171	173	171
query27	3083	348	349	348
query28	8028	2116	2122	2116
query29	1090	446	447	446
query30	323	159	157	157
query31	1005	793	787	787
query32	103	62	61	61
query33	827	317	309	309
query34	922	498	529	498
query35	845	728	727	727
query36	1104	951	951	951
query37	292	77	74	74
query38	3965	3790	3847	3790
query39	1467	1424	1421	1421
query40	296	106	105	105
query41	56	54	52	52
query42	114	100	100	100
query43	523	492	486	486
query44	1346	801	795	795
query45	185	174	174	174
query46	1154	726	710	710
query47	1964	1874	1885	1874
query48	450	364	359	359
query49	1320	426	405	405
query50	826	423	410	410
query51	7305	7219	7211	7211
query52	101	94	94	94
query53	258	185	185	185
query54	1213	471	472	471
query55	85	103	77	77
query56	274	261	258	258
query57	1335	1180	1153	1153
query58	234	215	217	215
query59	3201	2901	2822	2822
query60	282	268	250	250
query61	110	109	117	109
query62	886	670	671	670
query63	214	189	190	189
query64	5217	666	629	629
query65	3274	3177	3177	3177
query66	1409	312	303	303
query67	15931	15629	15542	15542
query68	4590	577	573	573
query69	446	277	266	266
query70	1150	1066	1132	1066
query71	419	258	256	256
query72	6646	3992	4061	3992
query73	777	351	370	351
query74	10567	9016	9151	9016
query75	3421	2661	2657	2657
query76	3011	1120	1163	1120
query77	441	274	286	274
query78	10463	9651	9609	9609
query79	1124	600	617	600
query80	794	443	428	428
query81	520	218	220	218
query82	1275	92	91	91
query83	245	150	154	150
query84	241	80	81	80
query85	1145	324	288	288
query86	310	298	307	298
query87	4393	4239	4260	4239
query88	3554	2406	2360	2360
query89	402	299	293	293
query90	2063	188	184	184
query91	137	108	108	108
query92	64	53	52	52
query93	1067	577	555	555
query94	784	291	289	289
query95	352	255	256	255
query96	616	287	284	284
query97	3311	3148	3164	3148
query98	209	205	201	201
query99	1491	1314	1283	1283
Total cold run time: 302418 ms
Total hot run time: 190061 ms

@doris-robot

doris-robot commented Jul 8, 2025

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

query1	0.03	0.02	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.06
query4	1.63	0.11	0.10
query5	0.52	0.52	0.51
query6	1.13	0.73	0.73
query7	0.04	0.02	0.02
query8	0.04	0.04	0.03
query9	0.58	0.51	0.50
query10	0.55	0.55	0.56
query11	0.14	0.10	0.10
query12	0.14	0.12	0.11
query13	0.62	0.60	0.58
query14	0.76	0.80	0.80
query15	0.83	0.84	0.83
query16	0.37	0.38	0.38
query17	1.08	1.06	1.06
query18	0.23	0.21	0.22
query19	1.95	1.77	1.86
query20	0.01	0.01	0.01
query21	15.51	0.58	0.58
query22	2.59	1.87	1.68
query23	17.18	0.86	0.84
query24	3.42	1.10	1.34
query25	0.19	0.15	0.09
query26	0.59	0.13	0.13
query27	0.04	0.03	0.04
query28	9.98	0.47	0.44
query29	12.57	3.26	3.23
query30	0.25	0.06	0.05
query31	2.86	0.38	0.39
query32	3.25	0.46	0.46
query33	2.99	3.05	2.99
query34	16.83	4.49	4.47
query35	4.48	4.50	4.44
query36	0.66	0.47	0.49
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.04	0.02	0.02
query40	0.16	0.12	0.13
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 104.83 s
Total hot run time: 30.07 s

@morrySnow morrySnow changed the title branch-3.1: [opt](iceberg)support drop tag and branch (#52453) branch-3.1: [opt](iceberg)support drop tag and branch #52453 Jul 9, 2025
@morrySnow
morrySnow merged commit 0c9a36e into apache:branch-3.1 Jul 9, 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.

5 participants

@morningman @Thearas @doris-robot @morrySnow @wuwenchi