Skip to content

[Chore] (nereids) remove CancelStmt #51848

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.

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

Open
wants to merge 5 commits into
base: master
Choose a base branch
from

Conversation

yx-keith
Copy link
Contributor

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 Jun 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?

@yx-keith
Copy link
Contributor Author

run buildall

@yx-keith yx-keith changed the title [Enhancement] (nereids) remove CancelStmt [Chore] (nereids) remove CancelStmt Jun 18, 2025
@yx-keith
Copy link
Contributor Author

run buildall

@yx-keith
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17592	5233	5028	5028
q2	1964	307	162	162
q3	10289	1260	779	779
q4	10211	1009	527	527
q5	7513	2333	2306	2306
q6	175	168	133	133
q7	901	766	602	602
q8	9313	1294	1159	1159
q9	6773	5074	5052	5052
q10	6926	2361	1949	1949
q11	488	290	283	283
q12	338	343	217	217
q13	17755	3705	3135	3135
q14	221	239	218	218
q15	564	493	489	489
q16	426	436	374	374
q17	603	858	362	362
q18	7645	7279	7036	7036
q19	1217	941	576	576
q20	341	342	232	232
q21	3735	3187	2350	2350
q22	1073	1025	959	959
Total cold run time: 106063 ms
Total hot run time: 33928 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5090	4999	5073	4999
q2	240	321	225	225
q3	2197	2645	2297	2297
q4	1403	1785	1324	1324
q5	4252	4086	4253	4086
q6	213	171	130	130
q7	2049	1924	1752	1752
q8	2622	2692	2557	2557
q9	7183	7109	7146	7109
q10	3094	3302	2853	2853
q11	568	517	492	492
q12	656	752	634	634
q13	3604	3878	3354	3354
q14	288	295	285	285
q15	527	478	473	473
q16	435	501	439	439
q17	1151	1538	1384	1384
q18	7756	7436	7442	7436
q19	839	829	938	829
q20	1972	2114	1923	1923
q21	5030	4609	4372	4372
q22	1061	1030	1066	1030
Total cold run time: 52230 ms
Total hot run time: 49983 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192607 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 828904f254ca4c07cd264760b1194127f78e3cc8, data reload: false

query1	1435	1019	1008	1008
query2	6327	1869	1845	1845
query3	11016	4517	4398	4398
query4	54028	25386	23134	23134
query5	5296	479	447	447
query6	383	203	183	183
query7	5088	508	285	285
query8	296	219	201	201
query9	6519	2698	2690	2690
query10	425	329	277	277
query11	15288	14970	14724	14724
query12	161	108	105	105
query13	1131	543	417	417
query14	10102	6389	6393	6389
query15	209	199	198	198
query16	7051	656	509	509
query17	1135	710	577	577
query18	1557	406	321	321
query19	214	211	176	176
query20	134	155	120	120
query21	208	124	106	106
query22	4351	4317	4272	4272
query23	34343	33757	33483	33483
query24	6541	2445	2449	2445
query25	480	468	416	416
query26	664	282	155	155
query27	2125	502	347	347
query28	2961	2199	2198	2198
query29	632	594	462	462
query30	280	229	189	189
query31	874	849	784	784
query32	77	64	68	64
query33	505	381	341	341
query34	773	872	553	553
query35	812	851	776	776
query36	942	1002	893	893
query37	157	104	77	77
query38	4166	4268	4175	4175
query39	1542	1460	1474	1460
query40	221	123	112	112
query41	64	59	57	57
query42	131	120	124	120
query43	524	525	497	497
query44	1455	853	858	853
query45	178	183	174	174
query46	872	1023	681	681
query47	1863	1859	1808	1808
query48	404	425	341	341
query49	665	489	418	418
query50	673	716	417	417
query51	4247	4240	4183	4183
query52	119	111	104	104
query53	237	264	182	182
query54	591	592	523	523
query55	85	86	82	82
query56	329	316	299	299
query57	1229	1233	1146	1146
query58	286	273	252	252
query59	2720	2842	2687	2687
query60	346	342	313	313
query61	129	119	129	119
query62	783	729	686	686
query63	241	208	202	202
query64	1459	1003	762	762
query65	4250	4220	4126	4126
query66	759	469	314	314
query67	15777	15955	15291	15291
query68	7744	903	539	539
query69	556	306	263	263
query70	1182	1127	1086	1086
query71	514	332	299	299
query72	5685	4795	4866	4795
query73	1278	664	365	365
query74	8953	9171	9099	9099
query75	3728	3188	2665	2665
query76	4235	1192	752	752
query77	630	385	287	287
query78	10166	10289	9361	9361
query79	2098	828	589	589
query80	582	510	438	438
query81	494	266	219	219
query82	459	125	95	95
query83	259	248	238	238
query84	298	110	83	83
query85	799	368	313	313
query86	419	306	285	285
query87	4368	4405	4307	4307
query88	3514	2294	2280	2280
query89	411	316	282	282
query90	1794	217	216	216
query91	136	139	111	111
query92	80	58	58	58
query93	1858	956	591	591
query94	701	422	305	305
query95	356	289	283	283
query96	496	585	281	281
query97	2718	2726	2699	2699
query98	255	208	206	206
query99	1332	1369	1268	1268
Total cold run time: 298963 ms
Total hot run time: 192607 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.07
query4	1.63	0.10	0.11
query5	0.44	0.42	0.42
query6	1.16	0.65	0.66
query7	0.02	0.02	0.02
query8	0.05	0.03	0.04
query9	0.57	0.53	0.51
query10	0.57	0.58	0.57
query11	0.16	0.11	0.11
query12	0.15	0.12	0.11
query13	0.63	0.61	0.61
query14	0.82	0.82	0.81
query15	0.89	0.85	0.88
query16	0.40	0.38	0.39
query17	1.09	1.06	1.06
query18	0.23	0.22	0.21
query19	2.04	1.87	1.84
query20	0.02	0.01	0.02
query21	15.40	0.89	0.58
query22	0.75	1.31	0.79
query23	14.76	1.40	0.65
query24	6.82	0.72	0.94
query25	0.46	0.21	0.08
query26	0.65	0.16	0.15
query27	0.07	0.05	0.06
query28	9.62	0.91	0.44
query29	12.66	4.07	3.42
query30	0.25	0.09	0.06
query31	2.82	0.60	0.40
query32	3.24	0.55	0.47
query33	3.03	3.12	3.21
query34	16.05	5.39	4.77
query35	4.87	4.84	4.82
query36	0.69	0.50	0.51
query37	0.08	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.03	0.02
query40	0.18	0.14	0.14
query41	0.09	0.03	0.03
query42	0.03	0.02	0.03
query43	0.04	0.03	0.02
Total cold run time: 103.85 s
Total hot run time: 29.77 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 100% (0/0) 🎉
Increment coverage report
Complete coverage report

@yx-keith
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17582	5092	4965	4965
q2	1931	277	195	195
q3	10307	1260	699	699
q4	10218	982	516	516
q5	7520	2416	2344	2344
q6	174	164	128	128
q7	902	726	600	600
q8	9309	1238	1142	1142
q9	6821	5052	5074	5052
q10	6886	2386	1965	1965
q11	485	283	273	273
q12	351	340	209	209
q13	17761	3614	3061	3061
q14	231	221	214	214
q15	557	480	486	480
q16	432	428	386	386
q17	607	850	376	376
q18	7556	7118	7169	7118
q19	1281	956	549	549
q20	344	337	232	232
q21	3757	3263	2375	2375
q22	1053	994	951	951
Total cold run time: 106065 ms
Total hot run time: 33830 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5051	4988	4976	4976
q2	238	318	222	222
q3	2146	2660	2318	2318
q4	1357	1760	1340	1340
q5	4205	4120	4265	4120
q6	205	171	127	127
q7	2010	1899	1731	1731
q8	2562	2522	2443	2443
q9	7198	7009	7132	7009
q10	3065	3246	2797	2797
q11	573	515	489	489
q12	664	771	617	617
q13	3503	3885	3287	3287
q14	286	336	275	275
q15	510	474	487	474
q16	444	475	432	432
q17	1147	1484	1355	1355
q18	7571	7234	7199	7199
q19	763	733	775	733
q20	1940	2006	1814	1814
q21	4783	4391	4309	4309
q22	1069	995	1017	995
Total cold run time: 51290 ms
Total hot run time: 49062 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 185751 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 43e0e5038bb7ac71be3af9045f102d2d3213c8ee, data reload: false

query1	1014	400	398	398
query2	6537	1833	1789	1789
query3	6749	230	230	230
query4	26550	23563	23310	23310
query5	4376	618	476	476
query6	307	207	218	207
query7	4618	486	285	285
query8	264	213	206	206
query9	8648	2613	2617	2613
query10	480	323	265	265
query11	15261	15024	14704	14704
query12	157	111	108	108
query13	1653	532	423	423
query14	8726	6084	6066	6066
query15	202	188	175	175
query16	7282	612	491	491
query17	1213	721	578	578
query18	1994	419	313	313
query19	202	194	166	166
query20	125	119	114	114
query21	213	140	110	110
query22	4170	4311	4161	4161
query23	33847	33064	33128	33064
query24	8465	2373	2392	2373
query25	525	465	380	380
query26	826	275	150	150
query27	2728	510	331	331
query28	4298	2111	2100	2100
query29	692	559	437	437
query30	292	220	200	200
query31	900	840	753	753
query32	118	62	62	62
query33	547	374	322	322
query34	786	841	529	529
query35	770	801	712	712
query36	935	977	857	857
query37	114	104	79	79
query38	4031	4119	4027	4027
query39	1484	1403	1412	1403
query40	205	117	104	104
query41	62	86	63	63
query42	114	104	109	104
query43	491	493	484	484
query44	1310	838	825	825
query45	173	173	174	173
query46	852	1016	622	622
query47	1768	1787	1750	1750
query48	400	410	310	310
query49	704	480	390	390
query50	641	660	390	390
query51	4090	4088	4182	4088
query52	111	111	100	100
query53	217	253	184	184
query54	569	559	500	500
query55	88	80	86	80
query56	307	298	276	276
query57	1160	1196	1151	1151
query58	269	254	258	254
query59	2566	2623	2572	2572
query60	323	315	302	302
query61	142	122	121	121
query62	785	733	657	657
query63	221	184	185	184
query64	3496	993	667	667
query65	4245	4224	4148	4148
query66	1015	407	302	302
query67	15603	15599	15510	15510
query68	8004	890	522	522
query69	479	301	269	269
query70	1251	1123	1098	1098
query71	464	330	305	305
query72	5582	4781	4932	4781
query73	731	663	359	359
query74	9198	9088	8962	8962
query75	3906	3206	2707	2707
query76	3646	1192	735	735
query77	781	378	280	280
query78	10094	10222	9359	9359
query79	1990	822	579	579
query80	603	519	459	459
query81	489	255	223	223
query82	468	125	97	97
query83	244	255	233	233
query84	249	115	90	90
query85	788	349	309	309
query86	336	294	282	282
query87	4368	4487	4264	4264
query88	3515	2293	2351	2293
query89	386	322	284	284
query90	1936	215	211	211
query91	140	142	110	110
query92	81	63	58	58
query93	1215	959	592	592
query94	695	408	313	313
query95	374	286	286	286
query96	493	562	284	284
query97	2747	2799	2658	2658
query98	227	210	205	205
query99	1428	1420	1266	1266
Total cold run time: 270934 ms
Total hot run time: 185751 ms

@doris-robot
Copy link

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

query1	0.03	0.04	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.06
query4	1.61	0.10	0.11
query5	0.43	0.42	0.40
query6	1.16	0.66	0.64
query7	0.02	0.02	0.01
query8	0.05	0.04	0.04
query9	0.59	0.52	0.52
query10	0.58	0.57	0.58
query11	0.16	0.11	0.11
query12	0.15	0.12	0.11
query13	0.63	0.61	0.61
query14	0.81	0.82	0.79
query15	0.89	0.84	0.86
query16	0.38	0.38	0.38
query17	1.04	1.06	1.11
query18	0.23	0.21	0.22
query19	1.92	1.86	1.85
query20	0.01	0.01	0.02
query21	15.41	0.89	0.52
query22	0.78	1.23	0.67
query23	14.88	1.40	0.63
query24	6.96	1.56	0.56
query25	0.52	0.17	0.06
query26	0.64	0.16	0.13
query27	0.06	0.06	0.05
query28	9.16	0.95	0.46
query29	12.54	3.98	3.30
query30	0.25	0.09	0.06
query31	2.84	0.61	0.40
query32	3.29	0.55	0.52
query33	3.10	3.09	3.07
query34	16.04	5.41	4.78
query35	4.84	4.84	4.78
query36	0.68	0.50	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.03	0.03
query40	0.17	0.16	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: 103.48 s
Total hot run time: 29.16 s

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 100% (0/0) 🎉
Increment coverage report
Complete coverage report

@yx-keith
Copy link
Contributor Author

run buildall

1 similar comment
@yx-keith
Copy link
Contributor Author

run buildall

@hello-stephen
Copy link
Contributor

FE UT Coverage Report

Increment line coverage 100% (0/0) 🎉
Increment coverage report
Complete coverage report

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants