Skip to content

[Enhancement](udf) clear cache when droping function#60630

Open
linrrzqqq wants to merge 2 commits intoapache:masterfrom
linrrzqqq:pyudf-drop-func-cache
Open

[Enhancement](udf) clear cache when droping function#60630
linrrzqqq wants to merge 2 commits intoapache:masterfrom
linrrzqqq:pyudf-drop-func-cache

Conversation

@linrrzqqq
Copy link
Contributor

@linrrzqqq linrrzqqq commented Feb 9, 2026

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

  1. drop python udf file cache when drop function
  2. Fixed the issue where the same-named module from two different paths would incorrectly use the cache.
-- same1(x) -> x + 1
-- same2(x) -> x + 2

Doris> CREATE FUNCTION same1(INT)
    -> RETURNS INT
    -> PROPERTIES (
    ->     "type" = "PYTHON_UDF",
    ->     "file" = "file:///mnt/disk7/linzhenqi/d2/same_name_py_test/1/1.zip",
    ->     "symbol" = "same_name.same_name",
    ->     "runtime_version" = "3.9.18",
    ->     "always_nullable" = "false"
    -> );
Query OK, 0 rows affected (0.04 sec)Doris> select same1(1);
+----------+
| same1(1) |
+----------+
|        2 |
+----------+
1 row in set (6.25 sec)
Doris> CREATE FUNCTION same2(INT)
    -> RETURNS INT
    -> PROPERTIES (
    ->     "type" = "PYTHON_UDF",
    ->     "file" = "file:///mnt/disk7/linzhenqi/d2/same_name_py_test/2/2.zip",
    ->     "symbol" = "same_name.same_name",
    ->     "runtime_version" = "3.9.18",
    ->     "always_nullable" = "false"
    -> );
Query OK, 0 rows affected (0.00 sec)

-- due to the same module name, it incorrectly hit the cache of same1.
Doris> select same2(1);
+----------+
| same2(1) |
+----------+
|        2 |
+----------+
1 row in set (0.09 sec)

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 Feb 9, 2026

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?

@linrrzqqq linrrzqqq force-pushed the pyudf-drop-func-cache branch from 9dec43a to 0eb2920 Compare February 9, 2026 18:17
@linrrzqqq
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.35% (1795/2262)
Line Coverage 64.91% (31981/49269)
Region Coverage 65.58% (15952/24323)
Branch Coverage 56.16% (8488/15114)

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17626	4505	4382	4382
q2	2009	343	231	231
q3	10602	1380	749	749
q4	10338	785	332	332
q5	9579	2181	1999	1999
q6	228	183	152	152
q7	898	740	624	624
q8	9285	1454	1237	1237
q9	4971	4596	4684	4596
q10	6876	1927	1550	1550
q11	537	300	288	288
q12	405	375	230	230
q13	17807	4068	3262	3262
q14	246	245	215	215
q15	905	823	806	806
q16	671	676	643	643
q17	712	820	535	535
q18	7050	5768	5806	5768
q19	1099	993	625	625
q20	511	487	396	396
q21	2568	1812	1793	1793
q22	359	318	278	278
Total cold run time: 105282 ms
Total hot run time: 30691 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4416	4371	4417	4371
q2	250	344	257	257
q3	2124	2707	2184	2184
q4	1364	1761	1334	1334
q5	4335	4267	4355	4267
q6	205	180	141	141
q7	1886	1806	2060	1806
q8	2740	2515	2452	2452
q9	7456	7555	7559	7555
q10	2954	3024	2645	2645
q11	572	507	466	466
q12	704	753	718	718
q13	3924	4445	3624	3624
q14	306	309	280	280
q15	856	805	802	802
q16	763	740	659	659
q17	1175	1497	1403	1403
q18	8094	7673	7936	7673
q19	933	979	871	871
q20	2024	2142	1991	1991
q21	4982	4429	4090	4090
q22	562	521	482	482
Total cold run time: 52625 ms
Total hot run time: 50071 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.05
query2	0.14	0.08	0.07
query3	0.32	0.08	0.08
query4	1.61	0.10	0.10
query5	0.26	0.25	0.23
query6	1.14	0.64	0.64
query7	0.03	0.03	0.03
query8	0.08	0.06	0.06
query9	0.58	0.50	0.50
query10	0.54	0.56	0.54
query11	0.27	0.14	0.14
query12	0.26	0.14	0.14
query13	0.62	0.62	0.60
query14	0.97	0.98	0.97
query15	0.92	0.83	0.82
query16	0.39	0.39	0.39
query17	1.06	0.99	1.06
query18	0.28	0.23	0.23
query19	1.94	1.87	1.84
query20	0.02	0.02	0.02
query21	15.39	0.34	0.30
query22	4.92	0.12	0.12
query23	15.33	0.48	0.28
query24	2.29	0.58	0.39
query25	0.12	0.10	0.12
query26	0.18	0.18	0.18
query27	0.11	0.11	0.10
query28	3.65	1.17	0.98
query29	12.51	4.10	3.30
query30	0.32	0.13	0.12
query31	2.80	0.71	0.44
query32	3.23	0.63	0.50
query33	2.98	3.01	3.03
query34	15.87	5.16	4.45
query35	4.49	4.48	4.41
query36	0.61	0.50	0.49
query37	0.32	0.09	0.08
query38	0.27	0.06	0.06
query39	0.07	0.05	0.06
query40	0.20	0.18	0.18
query41	0.13	0.06	0.07
query42	0.08	0.05	0.05
query43	0.07	0.05	0.06
Total cold run time: 97.42 s
Total hot run time: 28.13 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 17.07% (7/41) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.76% (19459/36883)
Line Coverage 36.25% (181228/499936)
Region Coverage 32.60% (140569/431191)
Branch Coverage 33.64% (60919/181072)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 29.27% (12/41) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 73.36% (26511/36139)
Line Coverage 56.41% (281320/498698)
Region Coverage 54.03% (235335/435573)
Branch Coverage 55.71% (101268/181776)

@hello-stephen
Copy link
Contributor

FE Regression Coverage Report

Increment line coverage 100.00% (23/23) 🎉
Increment coverage report
Complete coverage report

@linrrzqqq linrrzqqq force-pushed the pyudf-drop-func-cache branch 2 times, most recently from 06484c7 to 1b7f644 Compare February 10, 2026 18:39
@linrrzqqq
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.35% (1795/2262)
Line Coverage 64.85% (31952/49269)
Region Coverage 65.56% (15947/24323)
Branch Coverage 56.10% (8479/15114)

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 39.13% (9/23) 🎉
Increment coverage report
Complete coverage report

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17674	4520	4308	4308
q2	2008	336	226	226
q3	10496	1366	750	750
q4	10383	783	309	309
q5	9556	2233	1940	1940
q6	217	177	146	146
q7	912	766	619	619
q8	9280	1434	1277	1277
q9	4881	4645	4646	4645
q10	6878	1943	1554	1554
q11	474	265	245	245
q12	403	366	226	226
q13	17792	4081	3222	3222
q14	236	239	218	218
q15	907	794	804	794
q16	691	666	616	616
q17	709	832	517	517
q18	6670	5923	5677	5677
q19	1205	994	600	600
q20	500	494	372	372
q21	2558	1789	1772	1772
q22	323	288	244	244
Total cold run time: 104753 ms
Total hot run time: 30277 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4405	4345	4346	4345
q2	259	330	255	255
q3	2061	2672	2223	2223
q4	1350	1724	1301	1301
q5	4259	4182	4183	4182
q6	218	181	133	133
q7	1876	1797	1663	1663
q8	2877	2435	2512	2435
q9	7681	7419	7628	7419
q10	2862	2943	2593	2593
q11	516	473	439	439
q12	690	785	615	615
q13	3879	4426	3854	3854
q14	297	304	267	267
q15	849	795	788	788
q16	657	750	677	677
q17	1229	1301	1293	1293
q18	8430	7865	8047	7865
q19	901	859	853	853
q20	2063	2122	1986	1986
q21	4725	4429	4144	4144
q22	501	474	407	407
Total cold run time: 52585 ms
Total hot run time: 49737 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190951 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 1b7f644fa27615f1d28890b9ac9d33fa29aabd50, data reload: false

query5	4303	608	487	487
query6	325	211	197	197
query7	4206	477	268	268
query8	351	242	239	239
query9	8720	2749	2751	2749
query10	511	362	335	335
query11	16515	16326	16136	16136
query12	183	124	119	119
query13	1266	450	357	357
query14	5990	3251	2965	2965
query14_1	2849	2775	2747	2747
query15	202	193	174	174
query16	957	474	455	455
query17	1093	696	592	592
query18	2446	447	334	334
query19	207	208	183	183
query20	138	125	121	121
query21	221	143	135	135
query22	4830	4878	4854	4854
query23	19189	18516	18309	18309
query23_1	18580	18443	18460	18443
query24	7121	1593	1182	1182
query24_1	1226	1237	1229	1229
query25	553	456	418	418
query26	1254	269	155	155
query27	2773	462	290	290
query28	4480	1886	1893	1886
query29	809	563	472	472
query30	320	258	215	215
query31	822	757	660	660
query32	87	82	78	78
query33	525	346	284	284
query34	904	912	574	574
query35	652	683	619	619
query36	1123	1144	1023	1023
query37	147	101	89	89
query38	2916	2905	2836	2836
query39	947	910	907	907
query39_1	903	898	886	886
query40	221	136	122	122
query41	73	86	67	67
query42	106	103	101	101
query43	451	450	399	399
query44	1310	723	757	723
query45	193	192	182	182
query46	880	988	605	605
query47	2102	2155	2152	2152
query48	320	324	225	225
query49	599	422	350	350
query50	660	273	201	201
query51	4075	4193	4022	4022
query52	101	104	93	93
query53	290	325	271	271
query54	281	259	247	247
query55	84	79	77	77
query56	299	308	328	308
query57	1399	1354	1313	1313
query58	271	254	257	254
query59	1995	2207	2039	2039
query60	334	338	309	309
query61	145	144	145	144
query62	600	560	511	511
query63	297	267	264	264
query64	4977	1267	949	949
query65	4477	4420	4451	4420
query66	1432	439	333	333
query67	16309	16400	16277	16277
query68	2404	1068	737	737
query69	386	304	287	287
query70	1035	991	972	972
query71	315	311	285	285
query72	2902	2714	2494	2494
query73	514	553	309	309
query74	9657	9588	9491	9491
query75	2787	2763	2437	2437
query76	2275	1053	656	656
query77	349	403	294	294
query78	11319	11426	10901	10901
query79	1068	901	596	596
query80	1256	567	493	493
query81	562	272	257	257
query82	974	151	112	112
query83	327	257	239	239
query84	249	128	106	106
query85	893	482	409	409
query86	414	317	301	301
query87	3095	3103	2971	2971
query88	3538	2673	2649	2649
query89	394	342	335	335
query90	1978	176	170	170
query91	163	154	128	128
query92	73	83	72	72
query93	940	859	472	472
query94	652	325	300	300
query95	581	395	328	328
query96	642	513	226	226
query97	2450	2490	2413	2413
query98	218	212	206	206
query99	967	926	829	829
Total cold run time: 261535 ms
Total hot run time: 190951 ms

@doris-robot
Copy link

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

query1	0.06	0.05	0.05
query2	0.14	0.07	0.06
query3	0.32	0.08	0.08
query4	1.60	0.10	0.10
query5	0.26	0.24	0.24
query6	1.15	0.65	0.64
query7	0.03	0.03	0.03
query8	0.08	0.06	0.07
query9	0.57	0.51	0.51
query10	0.56	0.55	0.55
query11	0.26	0.13	0.13
query12	0.26	0.15	0.15
query13	0.62	0.61	0.59
query14	0.99	0.97	0.99
query15	0.92	0.83	0.83
query16	0.44	0.43	0.39
query17	1.01	1.04	1.01
query18	0.25	0.23	0.23
query19	1.94	1.77	1.76
query20	0.03	0.02	0.02
query21	15.41	0.34	0.29
query22	4.88	0.12	0.13
query23	15.32	0.46	0.28
query24	2.24	0.60	0.40
query25	0.11	0.10	0.11
query26	0.19	0.18	0.19
query27	0.11	0.10	0.11
query28	3.84	1.16	0.98
query29	12.52	4.12	3.32
query30	0.31	0.12	0.10
query31	2.80	0.67	0.46
query32	3.23	0.63	0.51
query33	3.02	3.05	3.05
query34	16.28	5.11	4.43
query35	4.50	4.42	4.49
query36	0.61	0.50	0.50
query37	0.31	0.08	0.09
query38	0.28	0.06	0.05
query39	0.08	0.05	0.05
query40	0.20	0.17	0.16
query41	0.13	0.06	0.07
query42	0.09	0.05	0.05
query43	0.06	0.06	0.05
Total cold run time: 98.01 s
Total hot run time: 28.14 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 7.22% (7/97) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.70% (19450/36905)
Line Coverage 36.18% (181075/500430)
Region Coverage 32.54% (140481/431776)
Branch Coverage 33.61% (60932/181312)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 12.37% (12/97) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 73.37% (26530/36160)
Line Coverage 56.45% (281779/499191)
Region Coverage 53.99% (235488/436156)
Branch Coverage 55.72% (101423/182016)

@hello-stephen
Copy link
Contributor

FE Regression Coverage Report

Increment line coverage 100.00% (23/23) 🎉
Increment coverage report
Complete coverage report

@linrrzqqq linrrzqqq marked this pull request as draft February 11, 2026 03:22
@linrrzqqq linrrzqqq force-pushed the pyudf-drop-func-cache branch 2 times, most recently from f5d215c to c4f7c86 Compare February 11, 2026 11:23
@linrrzqqq linrrzqqq marked this pull request as ready for review February 11, 2026 11:23
@linrrzqqq
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17436	4587	4322	4322
q2	2040	378	239	239
q3	10022	1314	737	737
q4	10191	776	312	312
q5	7558	2243	1931	1931
q6	197	184	154	154
q7	875	746	608	608
q8	9276	1392	1082	1082
q9	4715	4705	4696	4696
q10	6891	1958	1545	1545
q11	493	258	255	255
q12	337	390	223	223
q13	17783	4075	3279	3279
q14	235	235	220	220
q15	878	805	809	805
q16	702	693	625	625
q17	693	807	592	592
q18	6714	6007	6463	6007
q19	1488	1071	653	653
q20	571	548	401	401
q21	2797	1980	1965	1965
q22	362	297	260	260
Total cold run time: 102254 ms
Total hot run time: 30911 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4659	4582	4696	4582
q2	265	370	266	266
q3	2410	2848	2493	2493
q4	1565	1922	1431	1431
q5	4634	4529	4722	4529
q6	237	191	143	143
q7	1987	1890	1734	1734
q8	2593	2403	2539	2403
q9	7550	7516	7413	7413
q10	2890	3020	2638	2638
q11	530	428	432	428
q12	669	734	617	617
q13	3892	4474	3308	3308
q14	262	295	258	258
q15	824	772	778	772
q16	691	689	638	638
q17	1120	1274	1360	1274
q18	7628	7519	7320	7320
q19	870	781	783	781
q20	1946	2010	1880	1880
q21	4533	4328	4074	4074
q22	474	465	415	415
Total cold run time: 52229 ms
Total hot run time: 49397 ms

@doris-robot
Copy link

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

query5	4334	632	496	496
query6	338	223	199	199
query7	4207	475	262	262
query8	346	251	242	242
query9	8712	2742	2714	2714
query10	536	387	352	352
query11	16574	16563	16207	16207
query12	182	121	122	121
query13	1262	444	358	358
query14	6212	3245	2953	2953
query14_1	2754	2750	2730	2730
query15	209	193	176	176
query16	993	503	457	457
query17	1094	691	593	593
query18	2517	442	340	340
query19	213	208	182	182
query20	131	126	126	126
query21	217	148	127	127
query22	4988	5196	4955	4955
query23	19260	18741	18455	18455
query23_1	18597	18451	18424	18424
query24	7261	1599	1213	1213
query24_1	1213	1238	1234	1234
query25	556	463	425	425
query26	1244	276	163	163
query27	2764	464	297	297
query28	4499	1865	1871	1865
query29	831	561	456	456
query30	320	241	222	222
query31	880	746	680	680
query32	96	78	77	77
query33	547	353	300	300
query34	928	918	564	564
query35	660	681	597	597
query36	1114	1141	1012	1012
query37	141	111	86	86
query38	2999	2941	2844	2844
query39	950	916	909	909
query39_1	860	887	884	884
query40	225	138	125	125
query41	75	67	68	67
query42	142	99	97	97
query43	417	421	374	374
query44	1314	727	713	713
query45	192	186	188	186
query46	869	979	603	603
query47	2102	2170	2111	2111
query48	300	311	224	224
query49	608	436	336	336
query50	668	267	206	206
query51	4109	4068	4112	4068
query52	96	105	89	89
query53	290	329	271	271
query54	292	285	250	250
query55	83	81	78	78
query56	297	315	306	306
query57	1407	1362	1302	1302
query58	270	286	258	258
query59	2002	2202	1897	1897
query60	331	326	328	326
query61	146	147	143	143
query62	589	562	492	492
query63	294	272	260	260
query64	4961	1221	917	917
query65	4555	4464	4459	4459
query66	1427	448	336	336
query67	16511	16562	16300	16300
query68	2426	1066	722	722
query69	393	314	276	276
query70	1019	876	970	876
query71	328	314	294	294
query72	2987	2734	2525	2525
query73	527	538	309	309
query74	9674	9621	9477	9477
query75	2803	2754	2445	2445
query76	2301	1066	651	651
query77	339	369	302	302
query78	11372	11483	10849	10849
query79	1063	910	596	596
query80	764	564	502	502
query81	520	284	268	268
query82	1328	150	113	113
query83	353	260	243	243
query84	251	126	93	93
query85	895	468	414	414
query86	392	306	308	306
query87	3145	3087	2980	2980
query88	3550	2660	2648	2648
query89	378	341	328	328
query90	1803	172	170	170
query91	167	155	129	129
query92	74	72	72	72
query93	877	855	488	488
query94	576	315	297	297
query95	567	389	311	311
query96	644	517	230	230
query97	2516	2522	2404	2404
query98	218	219	205	205
query99	972	923	895	895
Total cold run time: 262487 ms
Total hot run time: 190705 ms

@doris-robot
Copy link

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.05
query3	0.26	0.09	0.08
query4	1.61	0.11	0.11
query5	0.28	0.26	0.25
query6	1.17	0.67	0.66
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.56	0.52	0.49
query10	0.55	0.55	0.55
query11	0.15	0.09	0.10
query12	0.14	0.10	0.10
query13	0.63	0.62	0.62
query14	1.07	1.06	1.06
query15	0.86	0.86	0.88
query16	0.38	0.38	0.38
query17	1.08	1.14	1.06
query18	0.22	0.20	0.20
query19	2.10	1.95	2.11
query20	0.02	0.02	0.01
query21	15.45	0.26	0.15
query22	4.81	0.06	0.06
query23	15.75	0.27	0.11
query24	2.35	0.33	0.21
query25	0.07	0.09	0.08
query26	0.15	0.14	0.13
query27	0.10	0.06	0.07
query28	4.03	1.15	0.97
query29	12.56	3.93	3.17
query30	0.29	0.14	0.11
query31	2.83	0.63	0.40
query32	3.24	0.59	0.49
query33	3.24	3.31	3.19
query34	16.50	5.34	4.71
query35	4.71	5.38	5.32
query36	0.68	0.54	0.56
query37	0.10	0.07	0.07
query38	0.07	0.05	0.04
query39	0.04	0.03	0.03
query40	0.19	0.17	0.16
query41	0.10	0.03	0.03
query42	0.04	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 98.65 s
Total hot run time: 28.72 s

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.32% (1795/2263)
Line Coverage 64.82% (31958/49300)
Region Coverage 65.54% (15947/24330)
Branch Coverage 56.06% (8478/15124)

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 6.93% (7/101) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.76% (19474/36908)
Line Coverage 36.24% (181451/500643)
Region Coverage 32.60% (140618/431344)
Branch Coverage 33.65% (61012/181324)

@linrrzqqq linrrzqqq force-pushed the pyudf-drop-func-cache branch from cd7ce97 to 14420bd Compare February 14, 2026 08:49
@linrrzqqq linrrzqqq force-pushed the pyudf-drop-func-cache branch from 14420bd to 6c43ea5 Compare February 14, 2026 08:50
@linrrzqqq
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.33% (1796/2264)
Line Coverage 64.79% (31986/49372)
Region Coverage 65.51% (15969/24378)
Branch Coverage 55.95% (8485/15164)

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
============================================
q1	17621	4548	4302	4302
q2	q3	10648	813	529	529
q4	4682	356	254	254
q5	7541	1242	1029	1029
q6	185	180	148	148
q7	795	835	670	670
q8	9288	1503	1389	1389
q9	5408	4770	4771	4770
q10	6840	1895	1645	1645
q11	456	260	243	243
q12	745	570	487	487
q13	17768	4267	3404	3404
q14	232	228	216	216
q15	942	797	812	797
q16	779	744	692	692
q17	740	862	430	430
q18	6122	5316	5277	5277
q19	1124	995	639	639
q20	521	490	394	394
q21	4868	2067	1534	1534
q22	411	327	262	262
Total cold run time: 97716 ms
Total hot run time: 29111 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	4669	4667	4687	4667
q2	q3	1839	2237	1805	1805
q4	884	1224	772	772
q5	4068	4358	4330	4330
q6	182	171	142	142
q7	1840	1648	1534	1534
q8	2504	2710	2609	2609
q9	7430	7320	7471	7320
q10	2666	2825	2397	2397
q11	519	423	420	420
q12	522	609	465	465
q13	4030	4665	3613	3613
q14	297	308	273	273
q15	848	822	799	799
q16	710	775	697	697
q17	1159	1524	1359	1359
q18	7031	6851	6619	6619
q19	896	1048	867	867
q20	2107	2136	2032	2032
q21	4061	3507	3284	3284
q22	471	481	397	397
Total cold run time: 48733 ms
Total hot run time: 46401 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 184529 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 6c43ea51433ef98baa06829e0cecef1240df846e, data reload: false

query5	4746	650	528	528
query6	349	233	217	217
query7	4210	489	282	282
query8	355	252	246	246
query9	8780	2787	2778	2778
query10	538	390	346	346
query11	16991	17446	17468	17446
query12	201	132	125	125
query13	1250	498	362	362
query14	7277	3437	3106	3106
query14_1	3191	2952	2932	2932
query15	213	202	182	182
query16	1016	514	524	514
query17	1081	748	636	636
query18	3338	477	390	390
query19	206	214	181	181
query20	149	130	154	130
query21	215	147	128	128
query22	5392	5274	4916	4916
query23	17293	16809	16561	16561
query23_1	16659	16677	16714	16677
query24	7186	1606	1211	1211
query24_1	1218	1246	1209	1209
query25	550	452	394	394
query26	1237	268	156	156
query27	2764	485	284	284
query28	4472	1839	1841	1839
query29	789	560	475	475
query30	313	246	208	208
query31	866	740	645	645
query32	81	73	71	71
query33	524	343	281	281
query34	919	903	566	566
query35	637	680	593	593
query36	1083	1133	954	954
query37	130	96	85	85
query38	2970	2907	2949	2907
query39	913	872	852	852
query39_1	828	838	816	816
query40	229	154	135	135
query41	65	59	57	57
query42	104	103	100	100
query43	380	382	365	365
query44	
query45	198	189	184	184
query46	889	980	616	616
query47	2120	2140	2036	2036
query48	309	310	227	227
query49	632	476	375	375
query50	718	275	222	222
query51	4087	4052	4030	4030
query52	109	107	94	94
query53	287	338	287	287
query54	310	271	265	265
query55	84	88	81	81
query56	327	298	316	298
query57	1382	1343	1292	1292
query58	294	284	288	284
query59	2617	2716	2541	2541
query60	336	342	312	312
query61	152	148	154	148
query62	632	586	528	528
query63	310	281	270	270
query64	4891	1273	1020	1020
query65	
query66	1425	460	351	351
query67	16349	16439	16452	16439
query68	
query69	399	316	306	306
query70	977	925	937	925
query71	341	305	321	305
query72	2934	2834	2670	2670
query73	538	541	311	311
query74	10005	9965	9738	9738
query75	2848	2750	2487	2487
query76	2306	1023	687	687
query77	362	374	315	315
query78	11288	11432	10711	10711
query79	1274	822	594	594
query80	1341	626	528	528
query81	568	276	253	253
query82	1013	149	114	114
query83	337	260	245	245
query84	254	124	94	94
query85	882	474	435	435
query86	420	302	309	302
query87	3128	3133	3009	3009
query88	3561	2620	2634	2620
query89	430	367	345	345
query90	2045	178	174	174
query91	164	157	154	154
query92	78	75	71	71
query93	1029	814	505	505
query94	650	323	283	283
query95	591	337	377	337
query96	650	510	225	225
query97	2489	2508	2415	2415
query98	239	214	219	214
query99	1029	980	915	915
Total cold run time: 256052 ms
Total hot run time: 184529 ms

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 7.07% (7/99) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.67% (19531/37079)
Line Coverage 36.24% (182164/502631)
Region Coverage 32.61% (141421/433712)
Branch Coverage 33.63% (61264/182188)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 7.07% (7/99) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.75% (26071/36338)
Line Coverage 54.42% (272877/501404)
Region Coverage 51.97% (227687/438111)
Branch Coverage 53.39% (97658/182916)

@hello-stephen
Copy link
Contributor

FE Regression Coverage Report

Increment line coverage 100.00% (23/23) 🎉
Increment coverage report
Complete coverage report

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 39.13% (9/23) 🎉
Increment coverage report
Complete coverage report

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 7.07% (7/99) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.76% (26076/36338)
Line Coverage 54.43% (272923/501404)
Region Coverage 51.97% (227680/438111)
Branch Coverage 53.41% (97694/182916)

@hello-stephen
Copy link
Contributor

FE Regression Coverage Report

Increment line coverage 100.00% (23/23) 🎉
Increment coverage report
Complete coverage report

@linrrzqqq
Copy link
Contributor Author

run feut

Copy link
Contributor

@HappenLee HappenLee left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Feb 18, 2026
@github-actions
Copy link
Contributor

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

@github-actions
Copy link
Contributor

PR approved by anyone and no changes requested.

Copy link
Member

@mrhhsg mrhhsg left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@linrrzqqq
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

Cloud UT Coverage Report

Increment line coverage 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 79.33% (1796/2264)
Line Coverage 64.76% (31989/49393)
Region Coverage 65.50% (15971/24383)
Branch Coverage 55.97% (8490/15168)

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 39.13% (9/23) 🎉
Increment coverage report
Complete coverage report

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
============================================
q1	17637	4553	4268	4268
q2	q3	10642	806	545	545
q4	4684	369	253	253
q5	7558	1209	1018	1018
q6	172	179	147	147
q7	804	855	684	684
q8	9285	1511	1358	1358
q9	4849	4764	4731	4731
q10	6845	1878	1657	1657
q11	468	263	240	240
q12	704	581	472	472
q13	17767	4311	3429	3429
q14	234	228	213	213
q15	963	799	791	791
q16	809	718	679	679
q17	750	861	421	421
q18	6103	5287	5419	5287
q19	1106	989	624	624
q20	505	492	409	409
q21	4817	2053	1525	1525
q22	424	316	273	273
Total cold run time: 97126 ms
Total hot run time: 29024 ms

----- Round 2, with runtime_filter_mode=off -----
============================================
q1	4678	4516	4531	4516
q2	q3	1803	2272	1770	1770
q4	897	1202	781	781
q5	4064	4393	4369	4369
q6	192	174	137	137
q7	1781	1606	1520	1520
q8	2517	2765	2557	2557
q9	7682	7615	7347	7347
q10	2658	2860	2407	2407
q11	522	425	416	416
q12	528	600	452	452
q13	3964	4530	3644	3644
q14	278	298	263	263
q15	846	795	778	778
q16	694	758	719	719
q17	1164	1498	1285	1285
q18	7188	6889	6678	6678
q19	915	890	924	890
q20	2128	2152	2119	2119
q21	4012	3535	3405	3405
q22	470	423	377	377
Total cold run time: 48981 ms
Total hot run time: 46430 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 184718 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 6c43ea51433ef98baa06829e0cecef1240df846e, data reload: false

query5	4905	630	515	515
query6	323	215	197	197
query7	4206	477	276	276
query8	359	247	242	242
query9	8765	2756	2728	2728
query10	498	347	336	336
query11	17013	16835	16631	16631
query12	184	124	119	119
query13	1261	449	328	328
query14	6376	3230	3000	3000
query14_1	2875	2763	2802	2763
query15	208	192	175	175
query16	1014	477	479	477
query17	1078	721	621	621
query18	2573	452	350	350
query19	210	210	186	186
query20	137	152	128	128
query21	218	147	118	118
query22	5114	5976	5638	5638
query23	17588	17247	16981	16981
query23_1	17039	16821	16688	16688
query24	7143	1613	1226	1226
query24_1	1221	1229	1215	1215
query25	536	464	434	434
query26	1232	255	152	152
query27	2788	468	292	292
query28	4517	1867	1874	1867
query29	820	584	487	487
query30	321	244	214	214
query31	891	726	658	658
query32	83	73	77	73
query33	533	338	291	291
query34	916	923	569	569
query35	656	677	607	607
query36	1048	1129	1028	1028
query37	140	104	86	86
query38	2962	2908	2892	2892
query39	943	864	852	852
query39_1	819	821	828	821
query40	242	157	144	144
query41	67	64	63	63
query42	106	104	102	102
query43	384	405	361	361
query44	
query45	202	191	183	183
query46	875	970	609	609
query47	2090	2132	2081	2081
query48	320	327	230	230
query49	646	476	413	413
query50	684	285	226	226
query51	4087	4063	4166	4063
query52	110	110	99	99
query53	296	337	295	295
query54	308	273	273	273
query55	94	85	83	83
query56	322	325	316	316
query57	1393	1345	1290	1290
query58	307	301	274	274
query59	2606	2753	2605	2605
query60	361	355	335	335
query61	176	171	168	168
query62	616	610	548	548
query63	326	280	278	278
query64	5021	1252	995	995
query65	
query66	1424	451	346	346
query67	16419	16472	16410	16410
query68	
query69	417	305	291	291
query70	928	983	976	976
query71	351	312	300	300
query72	2815	2659	2470	2470
query73	542	547	337	337
query74	9985	9968	9819	9819
query75	2830	2725	2431	2431
query76	2306	1014	695	695
query77	362	370	311	311
query78	11206	11403	10670	10670
query79	1190	812	588	588
query80	1350	621	541	541
query81	570	274	251	251
query82	975	147	113	113
query83	348	260	240	240
query84	248	114	97	97
query85	930	469	440	440
query86	426	316	299	299
query87	3146	3093	3015	3015
query88	3598	2667	2661	2661
query89	426	371	351	351
query90	1973	178	167	167
query91	171	155	133	133
query92	77	75	75	75
query93	988	832	497	497
query94	643	321	287	287
query95	593	408	330	330
query96	661	522	227	227
query97	2460	2527	2395	2395
query98	235	219	219	219
query99	994	980	897	897
Total cold run time: 254084 ms
Total hot run time: 184718 ms

@linrrzqqq
Copy link
Contributor Author

run p0

@linrrzqqq
Copy link
Contributor Author

run nonConcurrent

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 7.07% (7/99) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 52.55% (19597/37293)
Line Coverage 36.13% (182648/505572)
Region Coverage 32.46% (141748/436650)
Branch Coverage 33.42% (61449/183852)

@hello-stephen
Copy link
Contributor

BE Regression && UT Coverage Report

Increment line coverage 7.07% (7/99) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 71.46% (26103/36526)
Line Coverage 54.17% (273034/504072)
Region Coverage 51.64% (227655/440818)
Branch Coverage 52.95% (97659/184438)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

approved Indicates a PR has been approved by one committer. dev/4.1.x reviewed

Projects

None yet

Development

Successfully merging this pull request may close these issues.

7 participants