[fix](nereids) not use cte split multi distinct when agg has source repeat #55907

feiniaofeiafei · 2025-09-11T06:25:17Z

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #54079

Problem Summary:
There may be some issues in scenarios where the grouping() function is present. When merging a project,

-- Upper level project output:
projections : "GROUPING_PREFIX_publish_date#36 originExpression=Grouping(publish_date#6) AS `dim_207`#32"
--Lower level project output: 
projections : "GROUP PING_PREVIX_publish_date # 79 AS ` GROUP PING_PREVIX_publish_date ` # 36"

In theory, it should be rewritten as GROUPPING_PREVIX_publish_date# 79 AS dim_207# 32, but there is a problem here:
The map generated by the lower level project is: key : GROUPING_PREFIX_publish_date#36 , value: GROUPING_PREFIX_publish_date#79
Dealing with upper level projects GROUPING_PREFIX_publish_date#36 originExpression=Grouping(publish_date#6) AS dim_207#32 In the upper level project, the 'virtual slot' is used, and the 'key' in the map is' slot '. Although the ExprId is the same, it cannot be hit, resulting in an error.

So temporarily disable the use of CTE splitting to handle grouping+multiple counts (distinctions) scenarios.

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

hello-stephen · 2025-09-11T06:25:22Z

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:

What problem was fixed (it's best to include specific error reporting information). How it was fixed.
Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
What features were added. Why was this function added?
Which code was refactored and why was this part of the code refactored?
Which functions were optimized and what is the difference before and after the optimization?

morrySnow · 2025-09-11T06:26:59Z

add related PR and but detail in desc

feiniaofeiafei · 2025-09-11T06:34:16Z

run buildall

doris-robot · 2025-09-11T07:05:01Z

TPC-H: Total hot run time: 34632 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 5d684f062d7623f8c9ada57cf363b58b55533352, data reload: false

------ Round 1 ----------------------------------
q1	17607	5233	5047	5047
q2	1994	323	207	207
q3	10247	1317	721	721
q4	10252	1047	534	534
q5	7546	2433	2346	2346
q6	181	165	139	139
q7	930	761	624	624
q8	9361	1350	1088	1088
q9	7000	5181	5200	5181
q10	6939	2409	2002	2002
q11	484	301	272	272
q12	361	383	234	234
q13	17771	3638	3018	3018
q14	250	248	221	221
q15	575	492	490	490
q16	1010	992	946	946
q17	621	873	351	351
q18	7598	7213	7029	7029
q19	1563	982	559	559
q20	352	351	235	235
q21	3714	2630	2394	2394
q22	1073	1051	994	994
Total cold run time: 107429 ms
Total hot run time: 34632 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5510	5104	5089	5089
q2	251	325	243	243
q3	2187	2654	2252	2252
q4	1369	1772	1354	1354
q5	4235	4614	4549	4549
q6	215	166	129	129
q7	2130	2020	1847	1847
q8	2680	2544	2664	2544
q9	7459	7278	7342	7278
q10	3247	3342	2852	2852
q11	592	526	521	521
q12	972	762	630	630
q13	3435	3956	3377	3377
q14	290	304	296	296
q15	522	485	484	484
q16	1076	1079	1066	1066
q17	1225	1571	1388	1388
q18	8075	7920	7477	7477
q19	814	809	905	809
q20	1884	1963	1791	1791
q21	4730	4255	4290	4255
q22	1090	1026	1019	1019
Total cold run time: 53988 ms
Total hot run time: 51250 ms

feiniaofeiafei · 2025-09-11T09:06:19Z

run buildall

doris-robot · 2025-09-11T09:25:56Z

TPC-H: Total hot run time: 34601 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 4ead0e50b9c9c137078915f4d8c15ac860145e32, data reload: false

------ Round 1 ----------------------------------
q1	17610	5223	5074	5074
q2	1987	318	235	235
q3	10239	1319	719	719
q4	10236	1032	526	526
q5	7543	2463	2337	2337
q6	183	165	136	136
q7	932	751	640	640
q8	9360	1359	1101	1101
q9	6971	5046	5305	5046
q10	6890	2409	1996	1996
q11	489	308	285	285
q12	363	362	222	222
q13	17764	3680	3061	3061
q14	239	244	223	223
q15	545	506	486	486
q16	1035	1015	955	955
q17	599	887	353	353
q18	7625	7045	7185	7045
q19	1241	962	552	552
q20	346	341	233	233
q21	3988	3252	2388	2388
q22	1078	1040	988	988
Total cold run time: 107263 ms
Total hot run time: 34601 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5137	5096	5054	5054
q2	248	337	235	235
q3	2154	2709	2297	2297
q4	1341	1754	1318	1318
q5	4242	4651	4606	4606
q6	223	185	139	139
q7	2043	1999	1859	1859
q8	2639	2645	2657	2645
q9	7538	7507	7542	7507
q10	3097	3240	2877	2877
q11	584	538	515	515
q12	705	759	631	631
q13	3605	4117	3305	3305
q14	289	305	269	269
q15	493	472	488	472
q16	1092	1178	1098	1098
q17	1210	1612	1369	1369
q18	7998	7776	7594	7594
q19	839	903	1044	903
q20	2057	2092	1891	1891
q21	5087	4642	4430	4430
q22	1071	1060	984	984
Total cold run time: 53692 ms
Total hot run time: 51998 ms

doris-robot · 2025-09-11T09:37:43Z

TPC-DS: Total hot run time: 188982 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 4ead0e50b9c9c137078915f4d8c15ac860145e32, data reload: false

query1	1058	477	416	416
query2	6568	1699	1680	1680
query3	6754	226	238	226
query4	26235	23745	22824	22824
query5	5331	682	511	511
query6	362	242	219	219
query7	4701	516	300	300
query8	316	248	245	245
query9	8622	2935	2953	2935
query10	534	363	293	293
query11	15610	15025	14855	14855
query12	173	118	115	115
query13	1688	555	428	428
query14	11070	9433	9501	9433
query15	211	191	184	184
query16	7535	657	488	488
query17	1210	779	659	659
query18	2048	439	352	352
query19	212	206	190	190
query20	141	133	128	128
query21	214	135	122	122
query22	4204	4090	4043	4043
query23	34233	33136	32941	32941
query24	8216	2417	2485	2417
query25	636	559	503	503
query26	1246	289	178	178
query27	2735	533	356	356
query28	4394	2339	2257	2257
query29	802	630	520	520
query30	300	224	198	198
query31	915	827	730	730
query32	100	88	83	83
query33	580	467	361	361
query34	813	869	520	520
query35	814	821	750	750
query36	982	1016	923	923
query37	133	114	89	89
query38	3521	3535	3578	3535
query39	1490	1486	1427	1427
query40	231	138	128	128
query41	68	61	63	61
query42	130	118	125	118
query43	530	484	461	461
query44	1371	872	882	872
query45	193	180	173	173
query46	862	1018	643	643
query47	1772	1803	1751	1751
query48	401	449	321	321
query49	735	523	410	410
query50	655	675	398	398
query51	3893	4008	3864	3864
query52	121	115	117	115
query53	251	283	203	203
query54	631	613	542	542
query55	102	90	96	90
query56	369	336	322	322
query57	1199	1194	1127	1127
query58	299	291	284	284
query59	2537	2648	2517	2517
query60	367	355	343	343
query61	176	168	166	166
query62	810	759	719	719
query63	227	210	197	197
query64	4433	1184	829	829
query65	4058	4000	3992	3992
query66	1191	445	359	359
query67	15633	15321	14926	14926
query68	9137	940	585	585
query69	520	334	297	297
query70	1323	1285	1302	1285
query71	577	350	335	335
query72	5865	5011	5133	5011
query73	764	649	362	362
query74	9143	8841	9040	8841
query75	4541	3330	2761	2761
query76	3744	1153	757	757
query77	820	415	339	339
query78	9569	9912	8863	8863
query79	2011	803	585	585
query80	669	581	523	523
query81	469	266	299	266
query82	426	162	154	154
query83	299	267	262	262
query84	300	113	94	94
query85	856	467	436	436
query86	343	317	312	312
query87	3769	3783	3652	3652
query88	2971	2278	2186	2186
query89	401	321	287	287
query90	1938	237	222	222
query91	163	162	138	138
query92	87	87	74	74
query93	1135	989	659	659
query94	695	417	327	327
query95	418	346	333	333
query96	480	593	281	281
query97	2940	2972	2887	2887
query98	242	220	221	220
query99	1452	1439	1283	1283
Total cold run time: 278019 ms
Total hot run time: 188982 ms

doris-robot · 2025-09-11T09:43:13Z

ClickBench: Total hot run time: 29.94 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 4ead0e50b9c9c137078915f4d8c15ac860145e32, data reload: false

query1	0.06	0.06	0.05
query2	0.10	0.05	0.06
query3	0.26	0.09	0.08
query4	1.61	0.12	0.12
query5	0.28	0.26	0.25
query6	1.17	0.65	0.65
query7	0.03	0.03	0.03
query8	0.06	0.04	0.04
query9	0.65	0.53	0.51
query10	0.58	0.58	0.57
query11	0.17	0.11	0.12
query12	0.15	0.12	0.12
query13	0.64	0.63	0.62
query14	1.04	1.05	1.04
query15	0.89	0.84	0.85
query16	0.41	0.43	0.40
query17	1.07	1.05	1.03
query18	0.22	0.20	0.20
query19	1.97	1.90	1.87
query20	0.01	0.01	0.01
query21	15.41	1.06	0.58
query22	0.75	1.08	0.71
query23	15.03	1.39	0.62
query24	7.04	1.14	0.81
query25	0.50	0.08	0.22
query26	0.61	0.18	0.15
query27	0.08	0.05	0.06
query28	10.15	0.93	0.43
query29	12.56	3.90	3.20
query30	0.28	0.13	0.11
query31	2.83	0.60	0.40
query32	3.24	0.55	0.48
query33	3.16	3.08	3.09
query34	16.05	5.51	4.88
query35	4.93	4.88	4.97
query36	0.68	0.50	0.50
query37	0.11	0.07	0.07
query38	0.07	0.05	0.05
query39	0.04	0.03	0.03
query40	0.18	0.15	0.15
query41	0.09	0.03	0.03
query42	0.04	0.04	0.03
query43	0.05	0.03	0.03
Total cold run time: 105.25 s
Total hot run time: 29.94 s

feiniaofeiafei · 2025-09-11T11:23:51Z

run cloud_p0

feiniaofeiafei · 2025-09-11T11:25:38Z

run buildall

hello-stephen · 2025-09-11T11:34:41Z

FE Regression Coverage Report

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

doris-robot · 2025-09-11T11:48:10Z

TPC-H: Total hot run time: 34492 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f41921246aa765c3b64bbc3d130e01c225fd479a, data reload: false

------ Round 1 ----------------------------------
q1	17596	5215	5048	5048
q2	2001	325	207	207
q3	10279	1263	688	688
q4	10216	1032	523	523
q5	7529	2409	2308	2308
q6	181	168	137	137
q7	932	766	631	631
q8	9347	1329	1143	1143
q9	6932	5163	5128	5128
q10	6940	2397	1955	1955
q11	479	317	282	282
q12	357	362	234	234
q13	17803	3648	3042	3042
q14	241	239	215	215
q15	573	496	485	485
q16	1010	1007	956	956
q17	596	870	353	353
q18	7361	7244	7047	7047
q19	1492	948	553	553
q20	350	336	238	238
q21	3699	3115	2302	2302
q22	1074	1033	1017	1017
Total cold run time: 106988 ms
Total hot run time: 34492 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5216	5063	5059	5059
q2	254	330	229	229
q3	2194	2654	2299	2299
q4	1383	1735	1351	1351
q5	4190	4415	4528	4415
q6	221	171	142	142
q7	2066	1998	1901	1901
q8	2691	2671	2552	2552
q9	7373	7252	7276	7252
q10	3162	3302	2903	2903
q11	579	517	515	515
q12	678	853	655	655
q13	3764	3942	3306	3306
q14	309	298	296	296
q15	525	478	476	476
q16	1046	1099	1053	1053
q17	1168	1531	1391	1391
q18	8115	7625	7857	7625
q19	788	795	829	795
q20	1992	2095	1926	1926
q21	4754	4338	4190	4190
q22	1112	1072	999	999
Total cold run time: 53580 ms
Total hot run time: 51330 ms

doris-robot · 2025-09-11T11:59:56Z

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

query1	1071	436	432	432
query2	6557	1662	1675	1662
query3	6781	222	222	222
query4	26436	23597	22852	22852
query5	4403	631	509	509
query6	339	249	232	232
query7	4670	529	307	307
query8	307	261	264	261
query9	8709	2936	2880	2880
query10	499	360	322	322
query11	15699	15201	14742	14742
query12	176	129	120	120
query13	1687	572	480	480
query14	10242	9275	9192	9192
query15	213	197	172	172
query16	7442	645	492	492
query17	1258	768	636	636
query18	2012	455	352	352
query19	216	257	179	179
query20	136	129	122	122
query21	217	129	117	117
query22	4366	4395	4220	4220
query23	33871	33056	33191	33056
query24	8182	2349	2399	2349
query25	594	529	456	456
query26	815	272	166	166
query27	2726	521	357	357
query28	4383	2245	2256	2245
query29	744	613	495	495
query30	298	225	192	192
query31	889	828	720	720
query32	88	87	76	76
query33	570	405	350	350
query34	796	858	517	517
query35	810	810	760	760
query36	972	1033	899	899
query37	125	115	92	92
query38	3548	3543	3506	3506
query39	1489	1413	1431	1413
query40	222	138	124	124
query41	65	61	61	61
query42	128	127	123	123
query43	526	502	453	453
query44	1330	884	859	859
query45	184	175	171	171
query46	845	1008	640	640
query47	1801	1819	1765	1765
query48	400	424	303	303
query49	731	502	419	419
query50	649	696	415	415
query51	3913	3957	3854	3854
query52	112	110	108	108
query53	241	276	202	202
query54	602	617	536	536
query55	105	100	89	89
query56	338	331	334	331
query57	1206	1196	1152	1152
query58	310	281	276	276
query59	2580	2678	2579	2579
query60	356	353	350	350
query61	159	157	157	157
query62	841	756	666	666
query63	229	196	194	194
query64	3666	1180	827	827
query65	4056	3983	3962	3962
query66	1039	433	352	352
query67	15637	15436	15216	15216
query68	9384	936	582	582
query69	501	327	299	299
query70	1371	1335	1338	1335
query71	571	355	327	327
query72	5671	4943	5056	4943
query73	764	645	363	363
query74	8960	9308	8770	8770
query75	4515	3243	2787	2787
query76	3739	1152	740	740
query77	973	396	337	337
query78	9507	9915	8943	8943
query79	3630	835	572	572
query80	679	571	519	519
query81	500	261	220	220
query82	563	173	139	139
query83	280	256	259	256
query84	296	116	93	93
query85	856	465	432	432
query86	357	323	281	281
query87	3763	3869	3657	3657
query88	2812	2204	2283	2204
query89	450	327	297	297
query90	1935	234	226	226
query91	162	160	133	133
query92	97	74	76	74
query93	2175	970	656	656
query94	690	419	314	314
query95	408	330	336	330
query96	473	594	275	275
query97	2947	2969	2905	2905
query98	246	227	224	224
query99	1460	1404	1337	1337
Total cold run time: 277342 ms
Total hot run time: 188906 ms

doris-robot · 2025-09-11T12:05:26Z

ClickBench: Total hot run time: 30.06 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit f41921246aa765c3b64bbc3d130e01c225fd479a, data reload: false

query1	0.06	0.05	0.04
query2	0.08	0.05	0.06
query3	0.26	0.08	0.08
query4	1.60	0.12	0.11
query5	0.28	0.27	0.26
query6	1.18	0.66	0.63
query7	0.03	0.03	0.02
query8	0.05	0.04	0.04
query9	0.62	0.53	0.53
query10	0.58	0.57	0.57
query11	0.16	0.12	0.11
query12	0.15	0.12	0.12
query13	0.62	0.63	0.62
query14	1.01	1.05	1.03
query15	0.88	0.85	0.85
query16	0.39	0.40	0.40
query17	1.04	1.09	1.02
query18	0.21	0.20	0.20
query19	1.99	1.82	1.82
query20	0.01	0.01	0.01
query21	15.42	0.97	0.60
query22	0.77	1.15	0.76
query23	14.89	1.39	0.58
query24	6.62	2.05	0.85
query25	0.52	0.24	0.21
query26	0.60	0.16	0.13
query27	0.06	0.06	0.05
query28	9.98	0.94	0.42
query29	12.56	3.97	3.27
query30	0.28	0.13	0.11
query31	2.82	0.58	0.39
query32	3.25	0.57	0.48
query33	3.06	3.11	3.13
query34	15.81	5.51	4.83
query35	4.98	4.88	4.95
query36	0.70	0.51	0.50
query37	0.10	0.07	0.08
query38	0.07	0.05	0.04
query39	0.04	0.03	0.03
query40	0.18	0.15	0.14
query41	0.08	0.04	0.03
query42	0.03	0.03	0.03
query43	0.04	0.04	0.04
Total cold run time: 104.06 s
Total hot run time: 30.06 s

hello-stephen · 2025-09-11T12:33:28Z

FE UT Coverage Report

Increment line coverage 42.86% (3/7) 🎉
Increment coverage report
Complete coverage report

hello-stephen · 2025-09-11T17:09:14Z

FE Regression Coverage Report

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

feiniaofeiafei · 2025-09-12T02:26:10Z

run external

feiniaofeiafei · 2025-09-12T03:16:38Z

run external

feiniaofeiafei · 2025-09-12T08:49:52Z

run buildall

doris-robot · 2025-09-12T09:21:53Z

TPC-H: Total hot run time: 34521 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1fe6e60cd1f1001a5ca4b5624a2f1660b4aadf86, data reload: false

------ Round 1 ----------------------------------
q1	17594	5220	5056	5056
q2	2006	319	208	208
q3	10250	1319	694	694
q4	10229	1030	510	510
q5	7566	2425	2377	2377
q6	183	167	136	136
q7	935	762	631	631
q8	9332	1330	1104	1104
q9	6829	5173	5178	5173
q10	6942	2409	1967	1967
q11	504	295	278	278
q12	362	373	226	226
q13	17775	3591	2976	2976
q14	248	243	214	214
q15	568	486	502	486
q16	1000	995	950	950
q17	604	860	350	350
q18	7468	7049	7123	7049
q19	1380	956	554	554
q20	351	338	225	225
q21	3651	2557	2365	2365
q22	1053	1043	992	992
Total cold run time: 106830 ms
Total hot run time: 34521 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5192	5130	5107	5107
q2	249	336	226	226
q3	2185	2641	2292	2292
q4	1329	1748	1345	1345
q5	4191	4395	4498	4395
q6	236	177	133	133
q7	2052	1962	1828	1828
q8	2694	2622	2593	2593
q9	7251	7252	7310	7252
q10	3141	3322	2852	2852
q11	608	530	504	504
q12	682	802	602	602
q13	3475	3875	3323	3323
q14	277	301	282	282
q15	530	481	512	481
q16	1091	1130	1098	1098
q17	1203	1543	1428	1428
q18	7861	7714	7837	7714
q19	846	808	901	808
q20	2046	1976	1832	1832
q21	4714	4373	4262	4262
q22	1100	1045	987	987
Total cold run time: 52953 ms
Total hot run time: 51344 ms

doris-robot · 2025-09-12T09:33:37Z

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

query1	1061	480	410	410
query2	6590	1681	1730	1681
query3	6746	225	214	214
query4	26177	23482	22916	22916
query5	4393	632	469	469
query6	327	238	220	220
query7	4676	510	313	313
query8	296	259	242	242
query9	8673	2613	2610	2610
query10	473	341	273	273
query11	15790	15186	15376	15186
query12	167	115	111	111
query13	1676	564	441	441
query14	10604	9412	9228	9228
query15	215	200	176	176
query16	7687	666	527	527
query17	1229	751	661	661
query18	1994	423	329	329
query19	206	200	184	184
query20	130	133	119	119
query21	214	144	115	115
query22	4278	4250	4363	4250
query23	33942	33014	33012	33012
query24	8454	2349	2362	2349
query25	564	508	430	430
query26	1245	271	163	163
query27	2753	513	358	358
query28	4388	2242	2222	2222
query29	835	641	547	547
query30	291	228	204	204
query31	895	810	713	713
query32	84	74	74	74
query33	592	365	337	337
query34	801	856	522	522
query35	800	821	745	745
query36	977	1048	920	920
query37	117	109	86	86
query38	3478	3552	3505	3505
query39	1493	1401	1405	1401
query40	224	129	123	123
query41	62	60	61	60
query42	125	113	118	113
query43	510	498	460	460
query44	1327	841	829	829
query45	182	181	171	171
query46	855	1018	654	654
query47	1813	1833	1767	1767
query48	400	418	325	325
query49	775	500	410	410
query50	656	677	398	398
query51	3940	3915	3877	3877
query52	113	110	108	108
query53	235	284	186	186
query54	592	612	519	519
query55	88	84	84	84
query56	327	316	308	308
query57	1202	1219	1121	1121
query58	286	276	273	273
query59	2544	2688	2476	2476
query60	367	344	375	344
query61	183	168	172	168
query62	831	727	654	654
query63	223	191	190	190
query64	4566	1157	826	826
query65	4025	3941	3969	3941
query66	1172	440	334	334
query67	15538	15263	15390	15263
query68	6383	943	581	581
query69	503	321	272	272
query70	1314	1242	1212	1212
query71	523	336	321	321
query72	6137	5267	5439	5267
query73	690	671	359	359
query74	9233	9112	9075	9075
query75	3321	3320	2833	2833
query76	3174	1159	721	721
query77	525	395	322	322
query78	9766	9670	8992	8992
query79	2773	827	593	593
query80	856	557	515	515
query81	499	263	242	242
query82	779	162	132	132
query83	269	262	356	262
query84	253	104	93	93
query85	922	471	446	446
query86	417	318	303	303
query87	3741	3697	3610	3610
query88	3977	2205	2201	2201
query89	404	327	292	292
query90	1897	212	213	212
query91	166	171	136	136
query92	78	67	61	61
query93	2552	996	633	633
query94	824	445	323	323
query95	396	319	307	307
query96	485	571	272	272
query97	2942	3026	2872	2872
query98	247	219	223	219
query99	1344	1464	1385	1385
Total cold run time: 275862 ms
Total hot run time: 189309 ms

doris-robot · 2025-09-12T09:39:07Z

ClickBench: Total hot run time: 30.18 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 1fe6e60cd1f1001a5ca4b5624a2f1660b4aadf86, data reload: false

query1	0.06	0.05	0.05
query2	0.08	0.05	0.06
query3	0.25	0.08	0.08
query4	1.60	0.12	0.12
query5	0.28	0.28	0.26
query6	1.20	0.65	0.66
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.60	0.53	0.52
query10	0.58	0.58	0.58
query11	0.16	0.11	0.11
query12	0.15	0.12	0.12
query13	0.63	0.63	0.61
query14	1.04	1.04	1.02
query15	0.88	0.85	0.84
query16	0.40	0.40	0.40
query17	1.06	1.05	1.06
query18	0.21	0.20	0.20
query19	1.94	1.81	1.82
query20	0.02	0.01	0.02
query21	15.39	0.94	0.58
query22	0.77	1.10	0.60
query23	15.11	1.38	0.65
query24	7.69	1.31	1.15
query25	0.49	0.24	0.08
query26	0.67	0.16	0.13
query27	0.06	0.06	0.05
query28	9.73	0.86	0.44
query29	12.59	3.94	3.28
query30	0.28	0.13	0.10
query31	2.84	0.61	0.39
query32	3.24	0.58	0.50
query33	3.09	3.06	3.13
query34	16.17	5.49	4.85
query35	4.93	4.93	4.91
query36	0.69	0.51	0.50
query37	0.10	0.07	0.08
query38	0.06	0.04	0.04
query39	0.04	0.03	0.03
query40	0.19	0.15	0.14
query41	0.08	0.02	0.03
query42	0.04	0.03	0.03
query43	0.04	0.04	0.03
Total cold run time: 105.51 s
Total hot run time: 30.18 s

hello-stephen · 2025-09-12T09:49:00Z

FE UT Coverage Report

Increment line coverage 42.86% (3/7) 🎉
Increment coverage report
Complete coverage report

hello-stephen · 2025-09-12T11:57:29Z

FE Regression Coverage Report

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

feiniaofeiafei · 2025-09-12T14:04:51Z

run p0

feiniaofeiafei · 2025-09-14T08:13:14Z

run buildall

doris-robot · 2025-09-14T08:50:54Z

TPC-H: Total hot run time: 35041 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 5bf7f11536fccdee31474bb3beb06b99bc03bca0, data reload: false

------ Round 1 ----------------------------------
q1	17608	5230	5100	5100
q2	2031	348	214	214
q3	10209	1315	739	739
q4	10246	1028	551	551
q5	7526	2442	2400	2400
q6	189	175	140	140
q7	932	771	648	648
q8	9349	1327	1173	1173
q9	6893	5216	5082	5082
q10	6963	2395	1988	1988
q11	503	305	278	278
q12	353	371	236	236
q13	17775	3742	3069	3069
q14	251	241	224	224
q15	572	494	500	494
q16	997	1016	954	954
q17	612	892	380	380
q18	7546	7221	7115	7115
q19	1310	965	587	587
q20	361	345	234	234
q21	3880	3172	2415	2415
q22	1058	1031	1020	1020
Total cold run time: 107164 ms
Total hot run time: 35041 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5191	5150	5128	5128
q2	253	333	232	232
q3	2169	2649	2270	2270
q4	1451	1770	1369	1369
q5	4227	4580	4510	4510
q6	224	171	141	141
q7	2106	1977	1850	1850
q8	2695	2522	2529	2522
q9	7403	7390	7226	7226
q10	3089	3386	2883	2883
q11	606	527	529	527
q12	731	824	629	629
q13	3734	3847	3377	3377
q14	303	323	297	297
q15	530	545	618	545
q16	1117	1097	1067	1067
q17	1226	1537	1385	1385
q18	8053	7783	7564	7564
q19	836	801	854	801
q20	2058	2035	1825	1825
q21	4745	4474	4360	4360
q22	1122	1071	1006	1006
Total cold run time: 53869 ms
Total hot run time: 51514 ms

doris-robot · 2025-09-14T09:02:44Z

TPC-DS: Total hot run time: 189760 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 5bf7f11536fccdee31474bb3beb06b99bc03bca0, data reload: false

query1	1070	429	404	404
query2	6740	1717	1712	1712
query3	6786	234	232	232
query4	26417	24051	23687	23687
query5	4441	671	480	480
query6	365	253	243	243
query7	4670	532	326	326
query8	335	274	249	249
query9	8699	2644	2651	2644
query10	488	365	293	293
query11	15896	14995	14820	14820
query12	189	122	116	116
query13	1706	593	445	445
query14	11361	9514	9536	9514
query15	206	193	192	192
query16	7685	709	519	519
query17	1215	739	647	647
query18	2059	422	335	335
query19	217	210	174	174
query20	141	131	127	127
query21	217	141	120	120
query22	4086	4123	4129	4123
query23	33891	33014	33043	33014
query24	8576	2433	2492	2433
query25	581	521	434	434
query26	1237	293	166	166
query27	2716	518	365	365
query28	4384	2226	2191	2191
query29	779	623	498	498
query30	299	229	198	198
query31	923	798	731	731
query32	95	85	80	80
query33	591	396	329	329
query34	807	887	547	547
query35	840	863	775	775
query36	988	1050	926	926
query37	125	115	89	89
query38	3528	3562	3572	3562
query39	1510	1414	1604	1414
query40	229	137	124	124
query41	68	68	62	62
query42	129	112	127	112
query43	539	512	456	456
query44	1394	862	853	853
query45	197	186	173	173
query46	931	1096	679	679
query47	1791	1818	1720	1720
query48	402	443	329	329
query49	804	514	425	425
query50	697	793	407	407
query51	3941	4067	3909	3909
query52	125	118	104	104
query53	254	286	192	192
query54	597	593	527	527
query55	89	87	82	82
query56	334	341	309	309
query57	1201	1200	1124	1124
query58	287	281	278	278
query59	2638	2678	2614	2614
query60	353	358	328	328
query61	166	160	158	158
query62	817	743	683	683
query63	243	202	200	200
query64	4399	1196	807	807
query65	4074	4023	3988	3988
query66	1105	451	346	346
query67	15619	15292	14904	14904
query68	8217	963	593	593
query69	564	324	296	296
query70	1403	1324	1335	1324
query71	588	371	314	314
query72	6005	5043	5184	5043
query73	738	695	364	364
query74	9363	9074	8760	8760
query75	4032	3418	2829	2829
query76	3694	1217	800	800
query77	814	419	316	316
query78	9630	9789	8911	8911
query79	2358	874	616	616
query80	754	565	510	510
query81	501	265	227	227
query82	469	169	146	146
query83	280	270	259	259
query84	260	117	93	93
query85	889	522	427	427
query86	394	311	328	311
query87	3772	3780	3625	3625
query88	3513	2250	2259	2250
query89	409	339	310	310
query90	1858	233	228	228
query91	170	180	133	133
query92	85	71	66	66
query93	1810	1008	654	654
query94	701	450	326	326
query95	407	327	313	313
query96	494	584	285	285
query97	2982	2970	2881	2881
query98	261	223	209	209
query99	1659	1458	1294	1294
Total cold run time: 279356 ms
Total hot run time: 189760 ms

doris-robot · 2025-09-14T09:08:14Z

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 5bf7f11536fccdee31474bb3beb06b99bc03bca0, data reload: false

query1	0.06	0.06	0.05
query2	0.10	0.06	0.06
query3	0.25	0.08	0.09
query4	1.61	0.12	0.12
query5	0.29	0.27	0.27
query6	1.21	0.65	0.65
query7	0.04	0.03	0.03
query8	0.06	0.05	0.05
query9	0.63	0.53	0.50
query10	0.59	0.57	0.59
query11	0.17	0.11	0.11
query12	0.15	0.12	0.12
query13	0.65	0.64	0.63
query14	1.04	1.06	1.04
query15	0.89	0.85	0.85
query16	0.42	0.40	0.41
query17	1.09	1.08	1.05
query18	0.22	0.20	0.20
query19	1.95	1.83	1.86
query20	0.01	0.02	0.01
query21	15.40	0.97	0.59
query22	0.75	1.36	0.80
query23	14.77	1.39	0.64
query24	7.18	2.07	0.84
query25	0.48	0.21	0.06
query26	0.57	0.18	0.13
query27	0.07	0.06	0.05
query28	9.86	0.81	0.44
query29	12.56	3.93	3.28
query30	0.29	0.13	0.12
query31	2.84	0.59	0.39
query32	3.24	0.58	0.48
query33	3.07	3.20	3.06
query34	16.13	5.54	4.89
query35	4.91	4.96	4.89
query36	0.69	0.52	0.51
query37	0.11	0.07	0.07
query38	0.07	0.05	0.04
query39	0.04	0.03	0.04
query40	0.18	0.14	0.14
query41	0.08	0.04	0.03
query42	0.03	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 104.79 s
Total hot run time: 30.16 s

hello-stephen · 2025-09-14T09:26:13Z

FE UT Coverage Report

Increment line coverage 42.86% (3/7) 🎉
Increment coverage report
Complete coverage report

hello-stephen · 2025-09-14T10:55:46Z

FE Regression Coverage Report

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

github-actions · 2025-09-15T03:40:43Z

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

github-actions · 2025-09-15T03:40:45Z

PR approved by anyone and no changes requested.

feiniaofeiafei force-pushed the fix_user_case branch from 4ead0e5 to f419212 Compare September 11, 2025 11:25

feiniaofeiafei force-pushed the fix_user_case branch from f419212 to 1fe6e60 Compare September 12, 2025 08:49

feiniaofeiafei added 2 commits September 14, 2025 16:12

fix

aa78eea

fix

5bf7f11

feiniaofeiafei force-pushed the fix_user_case branch from 1fe6e60 to 5bf7f11 Compare September 14, 2025 08:12

924060929 approved these changes Sep 15, 2025

View reviewed changes

github-actions bot added the approved Indicates a PR has been approved by one committer. label Sep 15, 2025

github-actions bot added the reviewed label Sep 15, 2025

morrySnow approved these changes Sep 15, 2025

View reviewed changes

924060929 merged commit d8224c4 into apache:master Sep 15, 2025
27 of 30 checks passed

[fix](nereids) not use cte split multi distinct when agg has source repeat #55907

[fix](nereids) not use cte split multi distinct when agg has source repeat #55907

Uh oh!

Conversation

feiniaofeiafei commented Sep 11, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

What problem does this PR solve?

Release note

Check List (For Author)

Check List (For Reviewer who merge this PR)

Uh oh!

hello-stephen commented Sep 11, 2025

Uh oh!

morrySnow commented Sep 11, 2025

Uh oh!

feiniaofeiafei commented Sep 11, 2025

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

feiniaofeiafei commented Sep 11, 2025

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

feiniaofeiafei commented Sep 11, 2025

Uh oh!

feiniaofeiafei commented Sep 11, 2025

Uh oh!

hello-stephen commented Sep 11, 2025

FE Regression Coverage Report

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

doris-robot commented Sep 11, 2025

Uh oh!

hello-stephen commented Sep 11, 2025

FE UT Coverage Report

Uh oh!

hello-stephen commented Sep 11, 2025

FE Regression Coverage Report

Uh oh!

feiniaofeiafei commented Sep 12, 2025

Uh oh!

feiniaofeiafei commented Sep 12, 2025

Uh oh!

feiniaofeiafei commented Sep 12, 2025

Uh oh!

doris-robot commented Sep 12, 2025

Uh oh!

doris-robot commented Sep 12, 2025

Uh oh!

doris-robot commented Sep 12, 2025

Uh oh!

hello-stephen commented Sep 12, 2025

FE UT Coverage Report

Uh oh!

hello-stephen commented Sep 12, 2025

FE Regression Coverage Report

Uh oh!

feiniaofeiafei commented Sep 12, 2025

Uh oh!

feiniaofeiafei commented Sep 14, 2025

Uh oh!

doris-robot commented Sep 14, 2025

Uh oh!

doris-robot commented Sep 14, 2025

Uh oh!

doris-robot commented Sep 14, 2025

Uh oh!

hello-stephen commented Sep 14, 2025

FE UT Coverage Report

Uh oh!

hello-stephen commented Sep 14, 2025

FE Regression Coverage Report

Uh oh!

feiniaofeiafei commented Sep 11, 2025 •

edited

Loading