[Exec] (performance) support stream agg topn

[HappenLee]

What problem does this PR solve?

Before query cost: 2s

after query cost: 1s

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]

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?

[HappenLee]

run buildall

[doris-robot]

TPC-H: Total hot run time: 34392 ms

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

------ Round 1 ----------------------------------
q1	17610	4178	4044	4044
q2	2068	361	245	245
q3	10136	1290	730	730
q4	10243	937	347	347
q5	7575	2128	1894	1894
q6	187	169	138	138
q7	925	794	662	662
q8	9272	1380	1105	1105
q9	6834	5160	5136	5136
q10	6734	1813	1409	1409
q11	498	309	293	293
q12	702	721	589	589
q13	17778	3778	3067	3067
q14	281	294	275	275
q15	577	509	502	502
q16	708	678	649	649
q17	711	735	647	647
q18	7301	7342	7336	7336
q19	1101	979	590	590
q20	387	366	255	255
q21	4273	3921	3504	3504
q22	1062	1048	975	975
Total cold run time: 106963 ms
Total hot run time: 34392 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4133	4090	4021	4021
q2	325	393	315	315
q3	2103	2605	2188	2188
q4	1317	1729	1290	1290
q5	4042	3992	4736	3992
q6	214	183	129	129
q7	2102	1946	1790	1790
q8	2564	2373	2395	2373
q9	7202	7237	7182	7182
q10	2430	2690	2355	2355
q11	543	492	446	446
q12	706	767	628	628
q13	3561	4077	3387	3387
q14	292	295	287	287
q15	531	495	512	495
q16	671	718	651	651
q17	1150	1283	1460	1283
q18	8162	7759	8239	7759
q19	910	900	911	900
q20	1961	2051	1879	1879
q21	4901	4567	4165	4165
q22	1126	1058	1002	1002
Total cold run time: 50946 ms
Total hot run time: 48517 ms

[doris-robot]

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

query5	4411	564	426	426
query6	327	246	218	218
query7	4225	470	272	272
query8	331	257	250	250
query9	8767	2629	2638	2629
query10	527	369	318	318
query11	15180	15096	14891	14891
query12	177	115	112	112
query13	1289	523	392	392
query14	6048	3000	2751	2751
query14_1	2685	2544	2567	2544
query15	198	184	174	174
query16	983	460	438	438
query17	1083	653	570	570
query18	2420	429	328	328
query19	223	219	198	198
query20	121	121	113	113
query21	218	138	122	122
query22	4188	4385	4209	4209
query23	16044	15644	15380	15380
query23_1	15616	15491	15462	15462
query24	7419	1588	1224	1224
query24_1	1203	1214	1191	1191
query25	536	450	418	418
query26	1246	269	167	167
query27	2759	455	292	292
query28	4524	2210	2212	2210
query29	853	550	458	458
query30	308	243	217	217
query31	813	640	565	565
query32	76	73	71	71
query33	546	341	306	306
query34	927	891	541	541
query35	760	797	700	700
query36	889	858	771	771
query37	129	95	80	80
query38	2684	2725	2675	2675
query39	782	764	731	731
query39_1	729	746	722	722
query40	222	140	124	124
query41	72	73	66	66
query42	112	110	103	103
query43	481	472	435	435
query44	1355	771	768	768
query45	192	188	179	179
query46	877	953	617	617
query47	1376	1497	1330	1330
query48	324	334	266	266
query49	617	425	348	348
query50	638	269	214	214
query51	3730	3724	3748	3724
query52	103	108	98	98
query53	287	335	272	272
query54	306	268	256	256
query55	78	80	73	73
query56	308	312	306	306
query57	1055	1071	940	940
query58	271	257	262	257
query59	2036	2189	2185	2185
query60	329	328	307	307
query61	212	196	209	196
query62	403	364	346	346
query63	295	265	272	265
query64	5048	1301	1031	1031
query65	3848	3734	3761	3734
query66	1445	422	304	304
query67	15219	15149	15064	15064
query68	7578	1012	720	720
query69	496	345	314	314
query70	998	939	932	932
query71	360	305	272	272
query72	6250	4776	4921	4776
query73	707	603	310	310
query74	8785	8739	8574	8574
query75	2892	2906	2500	2500
query76	3796	1059	653	653
query77	515	363	295	295
query78	9779	10068	9246	9246
query79	1249	918	608	608
query80	613	562	471	471
query81	494	265	233	233
query82	224	144	111	111
query83	265	252	236	236
query84	253	109	105	105
query85	911	510	476	476
query86	328	306	317	306
query87	2867	2826	2758	2758
query88	3222	2273	2265	2265
query89	381	346	321	321
query90	2007	151	147	147
query91	172	159	142	142
query92	72	68	65	65
query93	1030	905	563	563
query94	587	326	280	280
query95	582	386	298	298
query96	590	465	214	214
query97	2313	2401	2381	2381
query98	232	195	192	192
query99	616	582	547	547
Total cold run time: 253794 ms
Total hot run time: 175409 ms

[doris-robot]

ClickBench: Total hot run time: 27.24 s

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

query1	0.05	0.05	0.05
query2	0.11	0.05	0.04
query3	0.26	0.08	0.08
query4	1.62	0.11	0.10
query5	0.27	0.26	0.27
query6	1.14	0.66	0.66
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.56	0.50	0.50
query10	0.54	0.56	0.56
query11	0.15	0.12	0.11
query12	0.16	0.12	0.12
query13	0.61	0.60	0.59
query14	1.00	0.97	0.98
query15	0.80	0.80	0.80
query16	0.40	0.42	0.41
query17	0.98	1.08	1.03
query18	0.23	0.22	0.22
query19	1.89	1.79	1.78
query20	0.02	0.01	0.02
query21	15.44	0.28	0.14
query22	4.79	0.05	0.05
query23	16.05	0.28	0.11
query24	1.28	0.54	0.92
query25	0.09	0.09	0.09
query26	0.14	0.13	0.13
query27	0.06	0.06	0.04
query28	4.93	1.04	0.88
query29	12.58	3.95	3.12
query30	0.28	0.13	0.11
query31	2.81	0.61	0.38
query32	3.24	0.55	0.45
query33	3.20	3.07	3.01
query34	16.78	5.13	4.50
query35	4.54	4.50	4.52
query36	0.67	0.49	0.49
query37	0.10	0.06	0.06
query38	0.08	0.04	0.04
query39	0.05	0.03	0.03
query40	0.17	0.13	0.12
query41	0.08	0.03	0.03
query42	0.05	0.03	0.03
query43	0.04	0.03	0.03
Total cold run time: 98.32 s
Total hot run time: 27.24 s

[hello-stephen]

FE UT Coverage Report

Increment line coverage 0.00% (0/1) 🎉
Increment coverage report
Complete coverage report

[hello-stephen]

FE Regression Coverage Report

Increment line coverage 0.00% (0/1) 🎉
Increment coverage report
Complete coverage report

[HappenLee]

run buildall

[doris-robot]

TPC-H: Total hot run time: 33920 ms

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

------ Round 1 ----------------------------------
q1	17606	4166	4049	4049
q2	2020	337	239	239
q3	10208	1276	718	718
q4	10224	877	320	320
q5	7537	2107	1920	1920
q6	185	168	137	137
q7	924	781	662	662
q8	9290	1379	1166	1166
q9	6769	5175	5063	5063
q10	6777	1802	1421	1421
q11	489	305	286	286
q12	669	730	573	573
q13	17777	3798	3058	3058
q14	292	295	266	266
q15	573	511	501	501
q16	689	682	617	617
q17	725	731	616	616
q18	7950	7309	7007	7007
q19	1139	963	619	619
q20	397	375	264	264
q21	4173	3964	3442	3442
q22	1040	1029	976	976
Total cold run time: 107453 ms
Total hot run time: 33920 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4120	4040	4050	4040
q2	339	395	313	313
q3	2063	2605	2193	2193
q4	1280	1761	1277	1277
q5	4088	4022	4723	4022
q6	243	183	142	142
q7	1971	1988	1754	1754
q8	2521	2342	2320	2320
q9	7186	7168	7130	7130
q10	2567	2775	2243	2243
q11	528	471	456	456
q12	689	770	602	602
q13	3639	4038	3307	3307
q14	311	345	305	305
q15	541	524	497	497
q16	647	736	684	684
q17	1114	1403	1300	1300
q18	8012	7564	7870	7564
q19	861	860	877	860
q20	1929	2048	1846	1846
q21	4476	4285	4093	4093
q22	1117	1038	1002	1002
Total cold run time: 50242 ms
Total hot run time: 47950 ms

[doris-robot]

TPC-DS: Total hot run time: 173991 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 390ef9c923eab9e70addf70fc422055023ce2f11, data reload: false

query5	4369	580	423	423
query6	324	216	227	216
query7	4212	456	275	275
query8	348	257	240	240
query9	8779	2645	2623	2623
query10	516	363	324	324
query11	15186	15185	14792	14792
query12	175	114	113	113
query13	1253	506	415	415
query14	6032	2974	2719	2719
query14_1	2650	2599	2641	2599
query15	214	203	174	174
query16	1001	470	454	454
query17	1101	693	588	588
query18	2430	447	394	394
query19	226	226	198	198
query20	124	118	110	110
query21	228	146	129	129
query22	3993	4109	3878	3878
query23	16101	15642	15402	15402
query23_1	15503	15429	15313	15313
query24	7366	1590	1200	1200
query24_1	1216	1199	1190	1190
query25	533	440	409	409
query26	1238	259	159	159
query27	2768	464	290	290
query28	4590	2179	2182	2179
query29	769	515	418	418
query30	306	235	210	210
query31	788	652	591	591
query32	89	67	64	64
query33	528	329	272	272
query34	912	910	531	531
query35	750	780	706	706
query36	864	905	815	815
query37	135	95	81	81
query38	2711	2679	2702	2679
query39	748	757	738	738
query39_1	708	724	715	715
query40	220	128	113	113
query41	67	63	62	62
query42	104	102	99	99
query43	466	477	426	426
query44	1349	756	745	745
query45	185	182	174	174
query46	864	948	634	634
query47	1438	1452	1234	1234
query48	313	317	238	238
query49	604	414	323	323
query50	629	280	202	202
query51	3764	3765	3767	3765
query52	100	105	95	95
query53	296	332	270	270
query54	286	250	244	244
query55	77	75	73	73
query56	290	290	287	287
query57	1042	1027	905	905
query58	266	248	246	246
query59	2165	2239	2004	2004
query60	315	310	286	286
query61	156	159	157	157
query62	377	350	302	302
query63	298	262	268	262
query64	5034	1314	987	987
query65	3717	3640	3763	3640
query66	1434	437	308	308
query67	15024	15222	14931	14931
query68	3181	1045	772	772
query69	487	358	316	316
query70	1058	978	948	948
query71	351	290	279	279
query72	6305	4679	4728	4679
query73	532	566	302	302
query74	8748	8786	8678	8678
query75	2844	2851	2517	2517
query76	3590	1055	639	639
query77	519	359	287	287
query78	9655	9848	9151	9151
query79	986	919	629	629
query80	1157	579	474	474
query81	530	263	229	229
query82	402	141	106	106
query83	394	259	239	239
query84	253	124	103	103
query85	975	499	453	453
query86	401	326	318	318
query87	2871	2819	2735	2735
query88	3215	2304	2307	2304
query89	390	339	324	324
query90	1978	152	147	147
query91	171	159	138	138
query92	69	65	66	65
query93	1038	925	566	566
query94	642	335	293	293
query95	559	377	304	304
query96	591	466	205	205
query97	2324	2348	2294	2294
query98	216	199	194	194
query99	583	567	559	559
Total cold run time: 248915 ms
Total hot run time: 173991 ms

[doris-robot]

ClickBench: Total hot run time: 26.88 s

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

query1	0.06	0.05	0.05
query2	0.10	0.05	0.05
query3	0.26	0.08	0.08
query4	1.60	0.11	0.11
query5	0.26	0.24	0.25
query6	1.15	0.65	0.64
query7	0.03	0.03	0.03
query8	0.06	0.04	0.04
query9	0.56	0.50	0.50
query10	0.54	0.53	0.56
query11	0.15	0.11	0.11
query12	0.16	0.13	0.13
query13	0.61	0.60	0.60
query14	0.98	0.97	0.98
query15	0.80	0.79	0.79
query16	0.42	0.41	0.40
query17	1.03	1.07	1.02
query18	0.22	0.22	0.21
query19	1.89	1.85	1.78
query20	0.02	0.01	0.01
query21	15.43	0.29	0.14
query22	4.72	0.05	0.05
query23	16.17	0.28	0.12
query24	1.32	0.29	0.61
query25	0.13	0.11	0.08
query26	0.15	0.14	0.14
query27	0.06	0.05	0.05
query28	4.87	1.04	0.87
query29	12.60	4.02	3.22
query30	0.27	0.13	0.12
query31	2.81	0.61	0.37
query32	3.25	0.55	0.46
query33	3.03	2.98	3.01
query34	16.82	5.10	4.44
query35	4.39	4.46	4.45
query36	0.65	0.50	0.48
query37	0.11	0.06	0.06
query38	0.06	0.04	0.04
query39	0.04	0.03	0.02
query40	0.17	0.14	0.13
query41	0.09	0.03	0.03
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 98.12 s
Total hot run time: 26.88 s

[hello-stephen]

FE UT Coverage Report

Increment line coverage 0.00% (0/1) 🎉
Increment coverage report
Complete coverage report

[hello-stephen]

BE UT Coverage Report

Increment line coverage 10.94% (29/265) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.35% (18950/35518)
Line Coverage	39.23% (175776/448071)
Region Coverage	33.80% (135990/402317)
Branch Coverage	34.73% (58718/169051)

[HappenLee]

run buildall

[doris-robot]

TPC-H: Total hot run time: 34485 ms

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

------ Round 1 ----------------------------------
q1	17630	4232	4029	4029
q2	2077	357	237	237
q3	10120	1278	744	744
q4	10231	887	325	325
q5	7556	2062	1991	1991
q6	189	169	141	141
q7	944	786	662	662
q8	9281	1422	1196	1196
q9	6740	5156	5147	5147
q10	6797	1820	1397	1397
q11	501	310	302	302
q12	682	747	573	573
q13	17794	3851	3145	3145
q14	294	298	276	276
q15	593	514	511	511
q16	696	670	626	626
q17	697	741	663	663
q18	7423	7379	7206	7206
q19	1108	972	641	641
q20	419	385	258	258
q21	4221	3882	3441	3441
q22	1058	1012	974	974
Total cold run time: 107051 ms
Total hot run time: 34485 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4113	4086	4065	4065
q2	318	404	327	327
q3	2056	2580	2256	2256
q4	1352	1787	1312	1312
q5	4092	4017	4897	4017
q6	234	178	161	161
q7	2081	1861	1788	1788
q8	2572	2420	2400	2400
q9	7032	7035	7166	7035
q10	2515	2636	2314	2314
q11	550	465	448	448
q12	720	805	691	691
q13	3750	4087	3468	3468
q14	296	322	306	306
q15	571	516	505	505
q16	668	707	653	653
q17	1156	1364	1405	1364
q18	8092	7839	7672	7672
q19	979	981	947	947
q20	2039	2059	1975	1975
q21	4972	4415	4157	4157
q22	1082	1044	982	982
Total cold run time: 51240 ms
Total hot run time: 48843 ms

[doris-robot]

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

query5	4946	580	451	451
query6	326	231	212	212
query7	4212	444	275	275
query8	344	237	234	234
query9	8767	2610	2630	2610
query10	520	369	304	304
query11	15260	15233	14891	14891
query12	175	111	110	110
query13	1249	508	376	376
query14	6292	3012	2733	2733
query14_1	2680	2793	2667	2667
query15	200	193	175	175
query16	976	465	460	460
query17	1081	710	606	606
query18	2533	422	338	338
query19	238	225	202	202
query20	121	116	114	114
query21	219	137	120	120
query22	3922	3865	3923	3865
query23	16110	15585	15306	15306
query23_1	15306	15236	15257	15236
query24	7390	1584	1190	1190
query24_1	1217	1192	1226	1192
query25	527	443	400	400
query26	1245	269	158	158
query27	2766	450	301	301
query28	4520	2186	2166	2166
query29	779	555	430	430
query30	308	240	212	212
query31	799	623	559	559
query32	73	77	69	69
query33	527	319	275	275
query34	896	874	548	548
query35	752	784	703	703
query36	854	877	817	817
query37	127	92	72	72
query38	2673	2621	2634	2621
query39	775	751	724	724
query39_1	703	713	706	706
query40	214	134	112	112
query41	65	61	64	61
query42	103	103	105	103
query43	472	437	418	418
query44	1366	764	757	757
query45	187	183	170	170
query46	869	971	634	634
query47	1509	1481	1321	1321
query48	326	331	251	251
query49	637	436	348	348
query50	641	277	223	223
query51	3802	3822	3898	3822
query52	103	111	105	105
query53	303	333	278	278
query54	307	271	265	265
query55	83	82	74	74
query56	292	310	310	310
query57	1019	1002	897	897
query58	280	252	266	252
query59	1985	2258	2117	2117
query60	338	329	319	319
query61	199	199	182	182
query62	382	364	331	331
query63	304	266	274	266
query64	5092	1470	1004	1004
query65	3776	3713	3693	3693
query66	1431	442	312	312
query67	14988	15796	14922	14922
query68	8024	1002	738	738
query69	492	348	310	310
query70	1045	970	903	903
query71	375	303	276	276
query72	6168	4824	5280	4824
query73	758	666	312	312
query74	8742	8781	8553	8553
query75	2948	2922	2518	2518
query76	3783	1057	662	662
query77	517	365	277	277
query78	9806	9833	9094	9094
query79	1167	922	615	615
query80	994	599	502	502
query81	525	267	236	236
query82	406	144	110	110
query83	278	256	232	232
query84	257	111	105	105
query85	892	508	463	463
query86	371	324	325	324
query87	2860	2837	2754	2754
query88	3249	2286	2250	2250
query89	377	359	330	330
query90	1955	151	145	145
query91	172	170	142	142
query92	70	63	63	63
query93	1105	908	566	566
query94	639	325	301	301
query95	589	374	308	308
query96	597	483	206	206
query97	2316	2392	2309	2309
query98	221	200	195	195
query99	583	581	507	507
Total cold run time: 254906 ms
Total hot run time: 174240 ms

[doris-robot]

ClickBench: Total hot run time: 26.95 s

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.05
query3	0.26	0.09	0.09
query4	1.61	0.12	0.11
query5	0.27	0.26	0.27
query6	1.16	0.66	0.65
query7	0.03	0.02	0.02
query8	0.05	0.04	0.05
query9	0.58	0.50	0.51
query10	0.56	0.55	0.55
query11	0.16	0.11	0.11
query12	0.16	0.13	0.13
query13	0.62	0.60	0.59
query14	0.97	0.99	1.00
query15	0.80	0.78	0.82
query16	0.40	0.40	0.40
query17	1.02	1.01	1.04
query18	0.23	0.22	0.21
query19	1.88	1.87	1.89
query20	0.02	0.01	0.02
query21	15.43	0.30	0.13
query22	4.90	0.05	0.04
query23	16.11	0.28	0.10
query24	1.25	0.89	0.21
query25	0.08	0.09	0.08
query26	0.16	0.13	0.12
query27	0.08	0.05	0.06
query28	4.63	1.05	0.88
query29	12.57	3.94	3.23
query30	0.27	0.14	0.13
query31	2.82	0.61	0.38
query32	3.23	0.54	0.46
query33	3.00	3.01	3.01
query34	16.36	5.11	4.42
query35	4.44	4.48	4.47
query36	0.66	0.49	0.48
query37	0.11	0.07	0.06
query38	0.07	0.04	0.04
query39	0.05	0.03	0.03
query40	0.17	0.13	0.13
query41	0.10	0.03	0.03
query42	0.04	0.02	0.03
query43	0.04	0.03	0.04
Total cold run time: 97.5 s
Total hot run time: 26.95 s

[doris-robot]

BE UT Coverage Report

Increment line coverage 7.14% (18/252) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	53.35% (18950/35518)
Line Coverage	39.23% (175794/448072)
Region Coverage	33.80% (135981/402317)
Branch Coverage	34.74% (58726/169051)

[hello-stephen]

FE UT Coverage Report

Increment line coverage 0.00% (0/1) 🎉
Increment coverage report
Complete coverage report

[hello-stephen]

BE Regression && UT Coverage Report

Increment line coverage 78.57% (198/252) 🎉

Increment coverage report
Complete coverage report

Category	Coverage
Function Coverage	72.16% (25057/34723)
Line Coverage	58.92% (263280/446880)
Region Coverage	53.80% (218675/406482)
Branch Coverage	55.29% (93778/169615)