Skip to content
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

[refactor](pipeline) refactor local merge sort operator #48360

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

Conversation

Mryange
Copy link
Contributor

@Mryange Mryange commented Feb 26, 2025

What problem does this PR solve?

  1. Remove the old local merge implementation because it is mixed with the local shuffle logic, resulting in a lot of specializations needed for local shuffle due to this local merge.
  2. Introduce a separate operator to implement local merge, replacing the original sort source with local merge sort source. Compared to the previous implementation, there is no need to maintain an additional data queue.
          |                        |                        |               
          |                        |                        |               
          |merge and output        |  eos                   | eos           
          |                        |                        |               
          |                        |                        |               
   +----------------+     +----------------+       +----------------+       
   |local merge sort|     |local merge sort|       |local merge sort|       
   +---------|------+     +----------------+       +----------------+       
 main_source |               other_source               other_source        
 task_id = 0 |               task_id > 0                task_id > 0         
             |                                                              
             |                                                              
             ---------------------+----------------------+                  
             |                    |                      |                  
             |                    |                      |                  
             |                    |                      |                  
       +-----------+        +-----------+          +-----------+            
       | sort sink |        | sort sink |          | sort sink |            
       +-----------+        +-----------+          +-----------+   

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 Feb 26, 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?

@Mryange
Copy link
Contributor Author

Mryange commented Feb 26, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17595	5281	5075	5075
q2	2055	319	176	176
q3	10377	1255	772	772
q4	10202	1009	529	529
q5	7534	2370	2328	2328
q6	191	165	139	139
q7	928	750	616	616
q8	9417	1296	1055	1055
q9	5031	4705	4779	4705
q10	6849	2304	1888	1888
q11	478	284	251	251
q12	350	363	232	232
q13	17780	3769	3064	3064
q14	222	242	210	210
q15	529	481	474	474
q16	621	618	597	597
q17	581	846	329	329
q18	6593	6322	6128	6128
q19	1712	952	556	556
q20	318	312	190	190
q21	2747	2259	1979	1979
q22	361	333	300	300
Total cold run time: 102471 ms
Total hot run time: 31593 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5199	5208	5200	5200
q2	234	327	229	229
q3	2125	2644	2270	2270
q4	1429	1836	1375	1375
q5	4219	4094	4172	4094
q6	220	163	125	125
q7	1862	1823	1715	1715
q8	2566	2626	2533	2533
q9	7181	7109	7126	7109
q10	3002	3230	2793	2793
q11	576	504	493	493
q12	679	764	678	678
q13	3496	3868	3309	3309
q14	278	293	270	270
q15	506	467	478	467
q16	634	717	646	646
q17	1128	1614	1342	1342
q18	7557	7371	7207	7207
q19	830	871	945	871
q20	1944	2086	1929	1929
q21	5490	5153	4585	4585
q22	625	563	562	562
Total cold run time: 51780 ms
Total hot run time: 49802 ms

@doris-robot
Copy link

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

query1	1302	923	947	923
query2	6094	1886	1871	1871
query3	11111	4573	4564	4564
query4	54945	25573	22955	22955
query5	5179	598	478	478
query6	336	182	179	179
query7	4872	493	289	289
query8	306	234	232	232
query9	5419	2624	2614	2614
query10	433	304	251	251
query11	15118	15618	14882	14882
query12	158	110	108	108
query13	1016	509	381	381
query14	10304	6835	6859	6835
query15	213	205	201	201
query16	7123	603	495	495
query17	1055	721	573	573
query18	1518	415	304	304
query19	197	194	163	163
query20	129	124	125	124
query21	209	132	108	108
query22	4365	4373	4263	4263
query23	33951	33382	33421	33382
query24	5892	2438	2423	2423
query25	480	483	398	398
query26	680	272	160	160
query27	1870	495	331	331
query28	2776	2489	2501	2489
query29	577	559	430	430
query30	211	192	160	160
query31	884	860	836	836
query32	93	65	66	65
query33	463	374	316	316
query34	794	889	529	529
query35	795	826	762	762
query36	972	1016	900	900
query37	126	104	80	80
query38	4221	4197	4225	4197
query39	1435	1466	1431	1431
query40	215	154	104	104
query41	51	53	51	51
query42	130	106	109	106
query43	516	523	487	487
query44	1347	805	810	805
query45	180	171	166	166
query46	896	1055	664	664
query47	1841	1876	1794	1794
query48	392	461	303	303
query49	688	507	413	413
query50	711	750	412	412
query51	4341	4297	4275	4275
query52	139	107	97	97
query53	229	263	190	190
query54	492	488	437	437
query55	82	82	83	82
query56	264	286	265	265
query57	1160	1175	1125	1125
query58	258	245	252	245
query59	2817	3033	2679	2679
query60	300	267	277	267
query61	121	120	123	120
query62	726	724	680	680
query63	232	190	188	188
query64	1459	1041	708	708
query65	3354	3232	3288	3232
query66	735	413	305	305
query67	15773	15586	15262	15262
query68	5897	886	505	505
query69	534	305	256	256
query70	1195	1129	1023	1023
query71	436	307	278	278
query72	5860	3713	3742	3713
query73	1365	753	353	353
query74	9072	9274	8843	8843
query75	3182	3129	2704	2704
query76	3803	1193	743	743
query77	543	388	329	329
query78	9980	10114	9269	9269
query79	2562	828	587	587
query80	663	544	463	463
query81	518	286	239	239
query82	372	125	96	96
query83	179	172	159	159
query84	294	94	81	81
query85	730	351	307	307
query86	354	314	282	282
query87	4465	4381	4346	4346
query88	3685	2230	2219	2219
query89	402	326	289	289
query90	1726	199	220	199
query91	138	137	117	117
query92	86	60	56	56
query93	2538	1062	572	572
query94	674	411	309	309
query95	354	278	259	259
query96	499	577	277	277
query97	3314	3411	3287	3287
query98	232	204	218	204
query99	1346	1394	1260	1260
Total cold run time: 294069 ms
Total hot run time: 190768 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 44.76% (11935/26667)
Line Coverage: 34.20% (99836/291928)
Region Coverage: 33.36% (51110/153208)
Branch Coverage: 28.91% (25660/88760)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d19bfa18288812c1923a1830824b7cd6d0ceb129_d19bfa18288812c1923a1830824b7cd6d0ceb129/report/index.html
Increment Report: http://coverage.selectdb-in.cc/coverage/d19bfa18288812c1923a1830824b7cd6d0ceb129_d19bfa18288812c1923a1830824b7cd6d0ceb129/increment_report/index.html

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.06	0.04	0.03
query3	0.24	0.07	0.07
query4	1.62	0.10	0.10
query5	0.58	0.55	0.57
query6	1.22	0.72	0.72
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.53	0.53
query10	0.56	0.56	0.56
query11	0.16	0.10	0.11
query12	0.15	0.11	0.11
query13	0.60	0.60	0.59
query14	2.78	2.81	2.72
query15	0.92	0.84	0.84
query16	0.39	0.39	0.39
query17	1.07	1.05	1.05
query18	0.21	0.20	0.20
query19	1.97	1.77	1.93
query20	0.01	0.02	0.01
query21	15.36	0.87	0.55
query22	0.75	1.19	0.66
query23	14.98	1.40	0.59
query24	6.65	1.16	1.50
query25	0.49	0.17	0.18
query26	0.59	0.16	0.13
query27	0.05	0.05	0.05
query28	9.51	0.88	0.42
query29	12.57	4.03	3.38
query30	0.25	0.10	0.07
query31	2.82	0.61	0.38
query32	3.23	0.55	0.48
query33	2.95	3.03	3.06
query34	15.85	5.19	4.55
query35	4.56	4.57	4.55
query36	0.67	0.50	0.49
query37	0.09	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.03
query40	0.17	0.13	0.12
query41	0.09	0.03	0.02
query42	0.04	0.02	0.03
query43	0.04	0.03	0.03
Total cold run time: 105.02 s
Total hot run time: 31.38 s

@Mryange
Copy link
Contributor Author

Mryange commented Feb 26, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17563	5323	5116	5116
q2	2046	304	166	166
q3	10570	1285	758	758
q4	10217	1043	537	537
q5	7530	2398	2411	2398
q6	189	165	130	130
q7	913	738	612	612
q8	9298	1309	1110	1110
q9	4845	4883	4692	4692
q10	6846	2317	1891	1891
q11	481	281	261	261
q12	352	349	225	225
q13	17762	3704	3052	3052
q14	228	230	210	210
q15	522	464	450	450
q16	649	612	586	586
q17	609	875	364	364
q18	7031	6170	6242	6170
q19	1439	964	546	546
q20	332	334	194	194
q21	2894	2146	1934	1934
q22	372	335	312	312
Total cold run time: 102688 ms
Total hot run time: 31714 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5188	5162	5471	5162
q2	248	330	235	235
q3	2134	2705	2302	2302
q4	1424	1873	1412	1412
q5	4294	4148	4194	4148
q6	209	168	125	125
q7	1845	1839	1779	1779
q8	2603	2687	2563	2563
q9	7238	7269	7185	7185
q10	3006	3225	2819	2819
q11	575	541	487	487
q12	685	776	653	653
q13	3432	3909	3301	3301
q14	279	294	267	267
q15	504	466	466	466
q16	664	678	651	651
q17	1176	1646	1325	1325
q18	7585	7521	7415	7415
q19	887	953	959	953
q20	1991	2046	1870	1870
q21	5616	5015	4726	4726
q22	625	597	566	566
Total cold run time: 52208 ms
Total hot run time: 50410 ms

@doris-robot
Copy link

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

query1	1307	947	928	928
query2	6168	1926	1860	1860
query3	11122	4545	4562	4545
query4	56551	25862	23226	23226
query5	5156	523	485	485
query6	355	198	188	188
query7	5063	506	298	298
query8	317	252	239	239
query9	5996	2614	2618	2614
query10	425	321	263	263
query11	15132	15155	14853	14853
query12	154	109	105	105
query13	1078	546	392	392
query14	10655	7336	6852	6852
query15	207	212	188	188
query16	7123	650	491	491
query17	1086	740	608	608
query18	949	409	332	332
query19	221	207	183	183
query20	138	168	119	119
query21	207	123	114	114
query22	4431	4604	4460	4460
query23	33909	33573	33332	33332
query24	5733	2427	2455	2427
query25	462	476	413	413
query26	708	279	167	167
query27	1770	512	334	334
query28	2837	2480	2467	2467
query29	526	547	427	427
query30	213	200	161	161
query31	893	880	806	806
query32	74	67	64	64
query33	464	365	290	290
query34	782	942	513	513
query35	811	854	751	751
query36	939	987	927	927
query37	126	99	81	81
query38	4180	4191	4280	4191
query39	1496	1442	1477	1442
query40	209	119	99	99
query41	53	52	47	47
query42	135	107	102	102
query43	510	516	487	487
query44	1361	806	793	793
query45	178	197	165	165
query46	891	1073	669	669
query47	1853	1880	1770	1770
query48	403	424	303	303
query49	721	520	420	420
query50	735	763	431	431
query51	4170	4327	4237	4237
query52	116	116	99	99
query53	251	268	193	193
query54	478	519	426	426
query55	89	86	85	85
query56	274	269	274	269
query57	1149	1165	1119	1119
query58	243	242	245	242
query59	2643	2763	2659	2659
query60	293	283	272	272
query61	124	117	126	117
query62	720	772	720	720
query63	238	194	192	192
query64	1952	1039	728	728
query65	3321	3251	3237	3237
query66	713	384	297	297
query67	15819	15394	15367	15367
query68	7820	884	493	493
query69	532	306	261	261
query70	1210	1141	1118	1118
query71	486	289	270	270
query72	5746	3580	3725	3580
query73	1435	751	351	351
query74	9058	9195	8759	8759
query75	3601	3179	2680	2680
query76	4159	1177	755	755
query77	618	376	278	278
query78	10064	10205	9320	9320
query79	2575	816	586	586
query80	731	517	451	451
query81	504	278	245	245
query82	680	124	91	91
query83	175	171	163	163
query84	288	98	69	69
query85	782	350	306	306
query86	416	286	276	276
query87	4409	4600	4519	4519
query88	3787	2224	2292	2224
query89	402	321	287	287
query90	1783	195	199	195
query91	134	136	108	108
query92	77	61	56	56
query93	1918	1047	572	572
query94	655	410	310	310
query95	357	278	251	251
query96	484	553	274	274
query97	3306	3370	3289	3289
query98	231	198	205	198
query99	1706	1410	1235	1235
Total cold run time: 299535 ms
Total hot run time: 191251 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.07	0.03	0.03
query3	0.23	0.07	0.06
query4	1.62	0.10	0.10
query5	0.56	0.55	0.55
query6	1.20	0.72	0.72
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.60	0.54	0.52
query10	0.57	0.58	0.58
query11	0.15	0.10	0.10
query12	0.14	0.11	0.11
query13	0.62	0.62	0.60
query14	2.83	2.82	2.68
query15	0.92	0.86	0.86
query16	0.39	0.38	0.38
query17	1.02	1.02	1.04
query18	0.21	0.19	0.19
query19	1.89	1.82	1.96
query20	0.01	0.01	0.01
query21	15.37	0.92	0.55
query22	0.76	1.22	0.80
query23	14.79	1.35	0.60
query24	6.52	1.88	0.80
query25	0.51	0.22	0.13
query26	0.70	0.15	0.14
query27	0.06	0.05	0.05
query28	10.48	0.86	0.45
query29	12.57	3.93	3.33
query30	0.25	0.09	0.07
query31	2.84	0.62	0.38
query32	3.23	0.54	0.46
query33	2.97	3.07	3.02
query34	15.69	5.19	4.54
query35	4.56	4.58	4.53
query36	0.65	0.49	0.49
query37	0.09	0.07	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.03
query40	0.17	0.14	0.12
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.02
Total cold run time: 105.56 s
Total hot run time: 31.05 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 44.75% (11937/26673)
Line Coverage: 34.21% (99897/292017)
Region Coverage: 33.36% (51126/153247)
Branch Coverage: 28.91% (25666/88786)
Coverage Report: http://coverage.selectdb-in.cc/coverage/b88403d677d7157e5d1f3e678991c1431fd2c348_b88403d677d7157e5d1f3e678991c1431fd2c348/report/index.html
Increment Report: http://coverage.selectdb-in.cc/coverage/b88403d677d7157e5d1f3e678991c1431fd2c348_b88403d677d7157e5d1f3e678991c1431fd2c348/increment_report/index.html

@Mryange
Copy link
Contributor Author

Mryange commented Feb 27, 2025

run buildall

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 0.00% (0/253) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 44.78% (11942/26669)
Line Coverage 34.23% (99958/292031)
Region Coverage 33.37% (51141/153246)
Branch Coverage 28.93% (25684/88782)

@Mryange Mryange force-pushed the Refactor-local-merge branch from e0b3ac6 to 16ed064 Compare February 27, 2025 07:10
@Mryange
Copy link
Contributor Author

Mryange commented Feb 27, 2025

run buildall

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 0.00% (0/255) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 44.78% (11942/26669)
Line Coverage 34.23% (99963/292038)
Region Coverage 33.37% (51144/153248)
Branch Coverage 28.92% (25675/88784)

@Mryange Mryange force-pushed the Refactor-local-merge branch from 16ed064 to 6f4744a Compare February 27, 2025 09:08
@Mryange
Copy link
Contributor Author

Mryange commented Feb 27, 2025

run buildall

@Mryange Mryange force-pushed the Refactor-local-merge branch from 6f4744a to 4b06182 Compare February 27, 2025 09:32
@Mryange
Copy link
Contributor Author

Mryange commented Feb 27, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17600	5235	5102	5102
q2	2058	314	181	181
q3	10563	1368	729	729
q4	10303	1036	539	539
q5	8423	2429	2384	2384
q6	194	170	136	136
q7	915	773	613	613
q8	9322	1337	1111	1111
q9	5058	4667	4679	4667
q10	6816	2347	1885	1885
q11	484	280	266	266
q12	349	353	222	222
q13	17763	3694	3066	3066
q14	236	229	212	212
q15	508	470	470	470
q16	658	648	584	584
q17	587	871	351	351
q18	6579	6331	6209	6209
q19	1415	952	547	547
q20	318	316	193	193
q21	2915	2205	1956	1956
q22	363	347	317	317
Total cold run time: 103427 ms
Total hot run time: 31740 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5151	5114	5138	5114
q2	243	335	230	230
q3	2146	2655	2274	2274
q4	1433	1820	1410	1410
q5	4259	4148	4186	4148
q6	213	160	121	121
q7	1865	1801	1805	1801
q8	2637	2629	2592	2592
q9	7412	7181	7223	7181
q10	3038	3239	2789	2789
q11	569	514	492	492
q12	710	779	605	605
q13	3540	3899	3274	3274
q14	273	304	264	264
q15	505	465	455	455
q16	662	688	636	636
q17	1140	1616	1332	1332
q18	7600	7224	7379	7224
q19	816	897	908	897
q20	1965	2023	1866	1866
q21	5508	5041	4844	4844
q22	656	575	541	541
Total cold run time: 52341 ms
Total hot run time: 50090 ms

@doris-robot
Copy link

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

query1	998	391	381	381
query2	6556	1899	1890	1890
query3	6802	213	213	213
query4	26160	23788	23367	23367
query5	4493	669	504	504
query6	304	218	189	189
query7	4630	527	294	294
query8	304	259	234	234
query9	8655	2595	2594	2594
query10	463	302	274	274
query11	15792	15178	14945	14945
query12	158	109	104	104
query13	1658	524	385	385
query14	10269	6322	6281	6281
query15	206	192	182	182
query16	7681	657	476	476
query17	1161	680	571	571
query18	1987	398	297	297
query19	190	192	156	156
query20	121	111	116	111
query21	220	124	106	106
query22	4155	4411	4361	4361
query23	33802	33030	32994	32994
query24	7801	2430	2427	2427
query25	553	489	422	422
query26	1244	276	163	163
query27	2212	510	335	335
query28	4007	2422	2404	2404
query29	746	582	446	446
query30	239	198	160	160
query31	946	882	779	779
query32	79	69	68	68
query33	583	393	304	304
query34	800	861	496	496
query35	795	855	765	765
query36	964	1012	924	924
query37	124	104	78	78
query38	4128	4180	4209	4180
query39	1510	1393	1368	1368
query40	209	119	106	106
query41	54	54	51	51
query42	124	107	103	103
query43	513	525	484	484
query44	1311	785	796	785
query45	183	171	161	161
query46	867	1037	646	646
query47	1745	1767	1720	1720
query48	378	414	315	315
query49	777	543	424	424
query50	702	719	423	423
query51	4215	4160	4120	4120
query52	107	107	94	94
query53	234	266	188	188
query54	503	492	407	407
query55	84	79	81	79
query56	272	262	260	260
query57	1113	1139	1085	1085
query58	253	271	251	251
query59	2675	2673	2671	2671
query60	279	277	266	266
query61	130	119	153	119
query62	816	713	660	660
query63	248	199	209	199
query64	4318	999	695	695
query65	3218	3153	3160	3153
query66	1060	425	316	316
query67	15868	15694	15458	15458
query68	8434	902	500	500
query69	472	303	271	271
query70	1203	1109	1061	1061
query71	458	318	270	270
query72	5717	3609	3774	3609
query73	786	759	346	346
query74	9108	9135	8843	8843
query75	3806	3203	2682	2682
query76	3672	1168	750	750
query77	789	398	291	291
query78	10012	10246	9348	9348
query79	2378	848	586	586
query80	664	533	455	455
query81	492	279	258	258
query82	697	131	99	99
query83	180	181	156	156
query84	239	99	73	73
query85	811	363	316	316
query86	346	293	301	293
query87	4465	4636	4495	4495
query88	3474	2235	2213	2213
query89	401	323	365	323
query90	1945	197	200	197
query91	143	139	112	112
query92	76	62	61	61
query93	1583	1069	577	577
query94	679	412	301	301
query95	361	276	265	265
query96	495	570	270	270
query97	3323	3428	3264	3264
query98	229	206	198	198
query99	1439	1430	1294	1294
Total cold run time: 274629 ms
Total hot run time: 185244 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.04
query3	0.24	0.07	0.07
query4	1.60	0.10	0.11
query5	0.56	0.54	0.55
query6	1.18	0.72	0.72
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.56	0.54	0.52
query10	0.57	0.58	0.57
query11	0.16	0.11	0.11
query12	0.14	0.11	0.12
query13	0.62	0.61	0.60
query14	2.82	2.68	2.66
query15	0.93	0.86	0.88
query16	0.37	0.37	0.38
query17	1.04	1.08	1.02
query18	0.21	0.19	0.19
query19	1.86	1.81	2.04
query20	0.01	0.02	0.02
query21	15.41	0.91	0.54
query22	0.76	1.04	0.60
query23	15.14	1.40	0.61
query24	6.88	1.41	0.44
query25	0.50	0.29	0.15
query26	0.54	0.16	0.14
query27	0.05	0.06	0.05
query28	9.91	0.91	0.44
query29	12.54	4.00	3.28
query30	0.25	0.11	0.07
query31	2.81	0.60	0.40
query32	3.23	0.56	0.47
query33	3.00	3.02	2.98
query34	15.62	5.14	4.53
query35	4.61	4.56	4.57
query36	0.67	0.49	0.50
query37	0.09	0.06	0.07
query38	0.06	0.04	0.04
query39	0.03	0.02	0.03
query40	0.17	0.13	0.12
query41	0.08	0.02	0.02
query42	0.03	0.02	0.03
query43	0.04	0.03	0.02
Total cold run time: 105.46 s
Total hot run time: 30.44 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 0.00% (0/246) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 44.78% (11943/26668)
Line Coverage 34.24% (99979/292019)
Region Coverage 33.38% (51152/153242)
Branch Coverage 28.93% (25686/88780)

@Mryange
Copy link
Contributor Author

Mryange commented Feb 28, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17604	5449	5087	5087
q2	2059	317	170	170
q3	10447	1284	735	735
q4	10252	1044	531	531
q5	7596	2402	2353	2353
q6	196	171	148	148
q7	936	745	600	600
q8	9303	1315	1121	1121
q9	4931	4799	4580	4580
q10	6834	2302	1878	1878
q11	466	282	269	269
q12	353	370	226	226
q13	17765	3678	3189	3189
q14	241	234	215	215
q15	510	478	468	468
q16	617	631	592	592
q17	586	879	345	345
q18	6992	6197	6228	6197
q19	1209	959	573	573
q20	321	336	193	193
q21	2823	2207	1967	1967
q22	375	342	303	303
Total cold run time: 102416 ms
Total hot run time: 31740 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5465	5125	5075	5075
q2	249	335	232	232
q3	2172	2727	2285	2285
q4	1446	1890	1374	1374
q5	4218	4164	4145	4145
q6	206	163	125	125
q7	1885	1851	1743	1743
q8	2638	2725	2620	2620
q9	7095	7198	7258	7198
q10	3026	3194	2733	2733
q11	568	505	498	498
q12	663	801	635	635
q13	3600	3974	3288	3288
q14	280	314	283	283
q15	514	466	472	466
q16	647	709	663	663
q17	1175	1640	1286	1286
q18	7610	7330	7323	7323
q19	849	922	889	889
q20	1973	2027	1886	1886
q21	5534	4811	4810	4810
q22	632	628	565	565
Total cold run time: 52445 ms
Total hot run time: 50122 ms

@doris-robot
Copy link

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

query1	1346	960	914	914
query2	6349	1903	1909	1903
query3	10999	4439	4319	4319
query4	54743	25841	23182	23182
query5	5156	544	491	491
query6	378	198	189	189
query7	5041	499	298	298
query8	321	255	244	244
query9	6416	2648	2613	2613
query10	402	301	261	261
query11	15220	14981	14774	14774
query12	154	111	103	103
query13	1136	504	384	384
query14	10844	7121	6352	6352
query15	211	199	170	170
query16	7191	653	467	467
query17	1054	716	554	554
query18	1682	448	314	314
query19	203	206	170	170
query20	137	122	133	122
query21	214	130	112	112
query22	4233	4672	4297	4297
query23	34037	33210	33568	33210
query24	6195	2435	2465	2435
query25	499	494	418	418
query26	710	337	152	152
query27	2099	509	334	334
query28	2922	2461	2440	2440
query29	559	561	426	426
query30	217	194	159	159
query31	873	887	779	779
query32	80	109	61	61
query33	453	387	289	289
query34	790	858	506	506
query35	823	857	764	764
query36	958	995	903	903
query37	123	105	75	75
query38	4176	4105	4168	4105
query39	1491	1548	1430	1430
query40	204	120	105	105
query41	60	57	49	49
query42	119	112	108	108
query43	511	515	492	492
query44	1359	827	815	815
query45	182	175	170	170
query46	881	1054	671	671
query47	1796	1828	1750	1750
query48	390	424	312	312
query49	724	516	436	436
query50	734	756	407	407
query51	4363	4345	4226	4226
query52	115	107	110	107
query53	238	262	192	192
query54	485	515	424	424
query55	86	88	79	79
query56	283	273	250	250
query57	1186	1166	1099	1099
query58	254	241	239	239
query59	2917	2683	2720	2683
query60	273	260	248	248
query61	119	121	118	118
query62	741	743	648	648
query63	215	187	183	183
query64	1790	1037	719	719
query65	3237	3112	3158	3112
query66	795	382	302	302
query67	15848	15707	15513	15513
query68	6608	864	507	507
query69	530	292	262	262
query70	1208	1139	1101	1101
query71	510	312	251	251
query72	5954	3637	3773	3637
query73	1385	751	346	346
query74	9017	9177	8822	8822
query75	3789	3181	2702	2702
query76	4261	1173	729	729
query77	676	335	290	290
query78	9975	10046	9329	9329
query79	2590	822	607	607
query80	652	541	459	459
query81	500	271	243	243
query82	727	126	93	93
query83	303	171	156	156
query84	278	95	74	74
query85	786	353	312	312
query86	372	295	311	295
query87	4391	4471	4342	4342
query88	3508	2216	2226	2216
query89	415	326	287	287
query90	1892	199	192	192
query91	136	135	107	107
query92	71	63	57	57
query93	1579	1050	573	573
query94	658	406	301	301
query95	353	270	266	266
query96	483	563	265	265
query97	3341	3383	3236	3236
query98	229	213	201	201
query99	1463	1375	1273	1273
Total cold run time: 298980 ms
Total hot run time: 189707 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.07	0.04	0.04
query3	0.23	0.07	0.06
query4	1.61	0.10	0.10
query5	0.57	0.55	0.57
query6	1.21	0.73	0.71
query7	0.03	0.02	0.01
query8	0.03	0.04	0.03
query9	0.59	0.52	0.54
query10	0.57	0.58	0.57
query11	0.16	0.11	0.11
query12	0.15	0.13	0.11
query13	0.60	0.60	0.60
query14	2.82	2.79	2.82
query15	0.93	0.85	0.84
query16	0.39	0.38	0.38
query17	1.06	1.01	1.03
query18	0.21	0.19	0.19
query19	1.91	1.86	1.92
query20	0.02	0.01	0.01
query21	15.37	0.94	0.55
query22	0.74	1.19	0.62
query23	15.01	1.38	0.59
query24	7.34	1.45	1.23
query25	0.50	0.37	0.08
query26	0.49	0.17	0.15
query27	0.05	0.05	0.05
query28	9.77	0.86	0.43
query29	12.54	3.96	3.36
query30	0.26	0.09	0.08
query31	2.80	0.60	0.39
query32	3.22	0.56	0.47
query33	3.11	3.10	3.01
query34	15.74	5.13	4.50
query35	4.52	4.52	4.46
query36	0.66	0.49	0.49
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.02	0.02	0.02
query40	0.17	0.14	0.13
query41	0.07	0.02	0.03
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 105.8 s
Total hot run time: 31.29 s

@Mryange Mryange force-pushed the Refactor-local-merge branch from 5cee9b1 to fd64cf9 Compare March 2, 2025 11:53
@Mryange Mryange changed the title [refactor] local merge sort (only test now) [refactor](pipeline) refactor local merge sort operator Mar 2, 2025
@Mryange
Copy link
Contributor Author

Mryange commented Mar 2, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17592	5595	5061	5061
q2	2045	304	171	171
q3	10396	1333	752	752
q4	10234	1017	534	534
q5	7501	2339	2388	2339
q6	202	173	139	139
q7	892	750	616	616
q8	9292	1255	1084	1084
q9	4940	4702	4845	4702
q10	6811	2288	1903	1903
q11	461	275	264	264
q12	348	354	222	222
q13	17755	3693	3149	3149
q14	231	230	214	214
q15	502	464	462	462
q16	638	616	581	581
q17	584	868	336	336
q18	7104	6200	6147	6147
q19	1210	963	553	553
q20	313	336	199	199
q21	2805	2169	1997	1997
q22	361	335	304	304
Total cold run time: 102217 ms
Total hot run time: 31729 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5198	5062	5132	5062
q2	237	324	231	231
q3	2154	2637	2266	2266
q4	1472	1831	1416	1416
q5	4261	4110	4167	4110
q6	202	162	124	124
q7	1860	1836	1710	1710
q8	2586	2501	2506	2501
q9	7310	7124	7144	7124
q10	2950	3182	2743	2743
q11	563	495	499	495
q12	694	754	624	624
q13	3562	3860	3213	3213
q14	271	285	262	262
q15	496	447	464	447
q16	627	699	646	646
q17	1148	1614	1300	1300
q18	7412	7448	7231	7231
q19	786	824	826	824
q20	1947	2015	1867	1867
q21	5450	4932	4945	4932
q22	665	593	546	546
Total cold run time: 51851 ms
Total hot run time: 49674 ms

@doris-robot
Copy link

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

query1	1005	391	386	386
query2	6553	1883	1921	1883
query3	6800	219	206	206
query4	26038	23741	22869	22869
query5	4440	681	517	517
query6	310	202	205	202
query7	4626	501	306	306
query8	314	255	235	235
query9	8648	2536	2565	2536
query10	474	323	296	296
query11	15300	15199	14909	14909
query12	169	109	104	104
query13	1653	508	405	405
query14	10240	6493	7194	6493
query15	212	197	171	171
query16	7669	639	485	485
query17	1317	693	559	559
query18	1979	392	303	303
query19	193	188	154	154
query20	120	129	117	117
query21	208	125	103	103
query22	4210	4184	4019	4019
query23	33898	33117	33093	33093
query24	7681	2360	2438	2360
query25	520	466	391	391
query26	1222	265	161	161
query27	2104	512	337	337
query28	3872	2426	2382	2382
query29	716	576	440	440
query30	236	189	157	157
query31	949	850	774	774
query32	78	66	68	66
query33	555	377	303	303
query34	805	848	523	523
query35	788	829	733	733
query36	966	988	879	879
query37	117	102	74	74
query38	4068	4175	4031	4031
query39	1440	1440	1383	1383
query40	212	122	105	105
query41	55	51	51	51
query42	127	103	105	103
query43	498	513	483	483
query44	1274	804	793	793
query45	179	178	166	166
query46	869	1034	665	665
query47	1737	1781	1698	1698
query48	372	413	314	314
query49	794	493	431	431
query50	678	750	438	438
query51	4195	4172	4116	4116
query52	108	108	96	96
query53	230	266	187	187
query54	500	519	414	414
query55	87	76	81	76
query56	283	292	243	243
query57	1154	1143	1076	1076
query58	257	244	254	244
query59	2667	2798	2569	2569
query60	292	276	275	275
query61	125	119	118	118
query62	824	737	677	677
query63	237	189	209	189
query64	4326	1010	676	676
query65	3251	3157	3107	3107
query66	1033	423	320	320
query67	15696	15209	15359	15209
query68	5389	884	511	511
query69	471	302	268	268
query70	1199	1132	1066	1066
query71	391	302	257	257
query72	5600	3592	3860	3592
query73	765	756	359	359
query74	9086	9114	8944	8944
query75	3182	3157	2703	2703
query76	3225	1158	749	749
query77	466	383	276	276
query78	9862	10165	9303	9303
query79	1109	841	590	590
query80	659	550	470	470
query81	488	278	250	250
query82	196	136	104	104
query83	187	191	160	160
query84	237	102	71	71
query85	745	357	305	305
query86	318	306	305	305
query87	4359	4408	4504	4408
query88	2978	2249	2227	2227
query89	383	329	290	290
query90	1736	203	195	195
query91	131	138	109	109
query92	71	63	58	58
query93	1092	1044	579	579
query94	617	377	303	303
query95	357	274	264	264
query96	487	557	267	267
query97	3229	3400	3302	3302
query98	222	209	197	197
query99	1334	1377	1283	1283
Total cold run time: 265124 ms
Total hot run time: 183949 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.06
query4	1.63	0.11	0.10
query5	0.56	0.57	0.55
query6	1.19	0.72	0.73
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.59	0.52	0.51
query10	0.57	0.58	0.57
query11	0.15	0.11	0.11
query12	0.15	0.12	0.12
query13	0.62	0.61	0.59
query14	2.79	2.68	2.79
query15	0.93	0.85	0.86
query16	0.38	0.38	0.36
query17	1.04	1.02	1.02
query18	0.22	0.21	0.19
query19	1.88	1.80	1.99
query20	0.02	0.01	0.02
query21	15.35	0.91	0.55
query22	0.75	1.12	0.72
query23	14.93	1.38	0.63
query24	7.29	1.77	0.84
query25	0.49	0.16	0.19
query26	0.72	0.17	0.13
query27	0.05	0.05	0.05
query28	8.83	0.89	0.43
query29	12.52	4.00	3.37
query30	0.26	0.09	0.06
query31	2.83	0.59	0.38
query32	3.23	0.54	0.47
query33	3.01	2.96	3.00
query34	15.64	5.07	4.50
query35	4.48	4.54	4.50
query36	0.71	0.49	0.49
query37	0.09	0.06	0.07
query38	0.04	0.04	0.04
query39	0.03	0.03	0.03
query40	0.17	0.13	0.13
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 104.72 s
Total hot run time: 30.9 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 2.54% (7/276) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 44.88% (11972/26676)
Line Coverage 34.41% (100635/292440)
Region Coverage 33.60% (51552/153421)
Branch Coverage 29.38% (26079/88776)

@Mryange
Copy link
Contributor Author

Mryange commented Mar 2, 2025

run cloud_p0

@Mryange Mryange marked this pull request as ready for review March 2, 2025 15:16
Copy link
Contributor

@Gabriel39 Gabriel39 left a comment

Choose a reason for hiding this comment

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

Add some UT cases

RETURN_IF_ERROR(_vsort_exec_exprs.prepare(state, _child->row_desc(), _row_descriptor));
RETURN_IF_ERROR(_vsort_exec_exprs.open(state));
for (int i = 1; i < _parallel_tasks; ++i) {
auto dep = Dependency::create_shared(operator_id(), node_id(),
Copy link
Contributor

Choose a reason for hiding this comment

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

Attach each instance ID to the dep's name

}
return deps;
} else {
return {_dependency};
Copy link
Contributor

Choose a reason for hiding this comment

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

Why we still need a dependency for other tasks?

auto& local_state = get_local_state(state);
DCHECK(_other_source_deps.contains(local_state._task_idx));
_sorters[local_state._task_idx] = local_state._shared_state->sorter;
_other_source_deps[local_state._task_idx]->set_ready();
Copy link
Contributor

Choose a reason for hiding this comment

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

Why need to set ready here?

@@ -1513,8 +1493,12 @@ Status PipelineFragmentContext::_create_operator(ObjectPool* pool, const TPlanNo
case TPlanNodeType::SORT_NODE: {
const auto should_spill = _runtime_state->enable_spill() &&
tnode.sort_node.algorithm == TSortAlgorithm::FULL_SORT;
const bool use_local_merge =
tnode.sort_node.merge_by_exchange && _runtime_state->enable_local_merge_sort();
Copy link
Contributor

Choose a reason for hiding this comment

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

Set tnode.sort_node.merge_by_exchange if enable_local_merge_sort is true by FE. Here we just need to decide whether to use local merge by tnode.sort_node.merge_by_exchange

@Mryange Mryange force-pushed the Refactor-local-merge branch from fc0ebec to 3fe9c17 Compare March 5, 2025 07:21
@Mryange
Copy link
Contributor Author

Mryange commented Mar 5, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17630	5293	5051	5051
q2	2061	314	186	186
q3	10371	1292	759	759
q4	10201	1033	529	529
q5	7526	2388	2370	2370
q6	194	169	132	132
q7	906	754	610	610
q8	9307	1356	1155	1155
q9	4971	4732	4727	4727
q10	6834	2315	1891	1891
q11	492	275	257	257
q12	345	350	219	219
q13	17787	3734	3085	3085
q14	222	219	204	204
q15	544	494	480	480
q16	625	619	581	581
q17	580	853	348	348
q18	6972	6538	6304	6304
q19	1674	964	548	548
q20	328	324	198	198
q21	2890	2121	1928	1928
q22	1038	987	962	962
Total cold run time: 103498 ms
Total hot run time: 32524 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5174	5097	5526	5097
q2	246	327	233	233
q3	2163	2674	2308	2308
q4	1450	1832	1390	1390
q5	4225	4140	4145	4140
q6	205	165	126	126
q7	1889	1967	1775	1775
q8	2634	2592	2543	2543
q9	7234	7256	7237	7237
q10	3060	3243	2768	2768
q11	576	514	477	477
q12	676	761	589	589
q13	3439	3930	3294	3294
q14	286	309	277	277
q15	539	506	492	492
q16	660	684	665	665
q17	1148	1638	1315	1315
q18	7856	7673	7418	7418
q19	843	864	963	864
q20	1982	2002	1901	1901
q21	5397	5033	4714	4714
q22	1114	1076	1043	1043
Total cold run time: 52796 ms
Total hot run time: 50666 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 191432 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 3fe9c177864cfb9a39dc0c36846bcc21f774a1e8, data reload: false

query1	1400	1040	1034	1034
query2	6511	1820	1865	1820
query3	10989	4339	4352	4339
query4	52836	25540	22910	22910
query5	5222	542	503	503
query6	361	209	188	188
query7	4987	495	288	288
query8	313	245	233	233
query9	5961	2560	2540	2540
query10	425	319	261	261
query11	15071	15041	14945	14945
query12	155	112	113	112
query13	1097	512	392	392
query14	10557	6354	6715	6354
query15	203	186	178	178
query16	7028	661	501	501
query17	1092	727	587	587
query18	1561	412	332	332
query19	206	201	174	174
query20	132	172	125	125
query21	215	124	110	110
query22	4541	4636	4348	4348
query23	33989	33476	33458	33458
query24	5748	2423	2398	2398
query25	465	467	389	389
query26	740	286	163	163
query27	1885	513	338	338
query28	2781	2510	2491	2491
query29	588	593	444	444
query30	274	223	197	197
query31	886	831	816	816
query32	81	66	58	58
query33	478	373	305	305
query34	773	843	507	507
query35	821	837	767	767
query36	965	960	903	903
query37	119	100	76	76
query38	4302	4180	4255	4180
query39	1540	1486	1405	1405
query40	205	110	99	99
query41	55	49	48	48
query42	126	107	103	103
query43	497	505	473	473
query44	1317	807	810	807
query45	181	171	167	167
query46	863	1043	635	635
query47	1868	1918	1819	1819
query48	390	433	309	309
query49	697	522	416	416
query50	727	754	407	407
query51	4343	4302	4236	4236
query52	111	109	93	93
query53	235	255	181	181
query54	478	501	437	437
query55	89	78	80	78
query56	290	284	243	243
query57	1166	1196	1130	1130
query58	247	250	234	234
query59	2784	2834	2675	2675
query60	316	272	310	272
query61	118	123	130	123
query62	770	753	709	709
query63	234	188	187	187
query64	2130	1035	671	671
query65	4491	4442	4421	4421
query66	734	400	299	299
query67	15880	15801	15524	15524
query68	7200	881	503	503
query69	533	305	266	266
query70	1228	1103	1137	1103
query71	495	293	263	263
query72	5516	3643	3759	3643
query73	1370	739	344	344
query74	9060	9159	8813	8813
query75	3754	3121	2696	2696
query76	4288	1163	761	761
query77	614	390	289	289
query78	10062	10128	9378	9378
query79	1442	892	579	579
query80	617	519	444	444
query81	478	256	218	218
query82	509	127	94	94
query83	169	170	150	150
query84	274	97	71	71
query85	749	359	296	296
query86	324	298	277	277
query87	4458	4487	4346	4346
query88	2756	2186	2165	2165
query89	400	313	280	280
query90	2033	191	192	191
query91	134	136	110	110
query92	68	61	55	55
query93	1189	1042	580	580
query94	688	389	297	297
query95	343	262	257	257
query96	489	567	262	262
query97	3376	3438	3255	3255
query98	216	201	198	198
query99	1464	1374	1283	1283
Total cold run time: 294936 ms
Total hot run time: 191432 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.04	0.03
query3	0.24	0.07	0.07
query4	1.62	0.11	0.10
query5	0.59	0.54	0.56
query6	1.20	0.72	0.72
query7	0.03	0.02	0.01
query8	0.04	0.04	0.04
query9	0.60	0.54	0.54
query10	0.58	0.58	0.58
query11	0.15	0.11	0.11
query12	0.14	0.12	0.11
query13	0.62	0.60	0.60
query14	2.67	2.69	2.80
query15	0.92	0.85	0.85
query16	0.38	0.38	0.39
query17	1.02	1.00	1.02
query18	0.20	0.20	0.20
query19	1.83	1.73	2.00
query20	0.02	0.00	0.02
query21	15.35	0.87	0.54
query22	0.76	1.09	0.72
query23	14.98	1.38	0.62
query24	7.02	1.17	1.48
query25	0.48	0.27	0.14
query26	0.56	0.17	0.13
query27	0.05	0.05	0.04
query28	9.85	0.81	0.41
query29	12.52	3.88	3.25
query30	0.25	0.08	0.06
query31	2.83	0.61	0.38
query32	3.22	0.53	0.46
query33	3.06	3.06	3.03
query34	15.67	5.13	4.52
query35	4.55	4.48	4.53
query36	0.67	0.48	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.16	0.13	0.13
query41	0.09	0.02	0.03
query42	0.04	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 105.27 s
Total hot run time: 31.06 s

@Mryange
Copy link
Contributor Author

Mryange commented Mar 5, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17613	5262	5088	5088
q2	2059	312	180	180
q3	10476	1380	733	733
q4	10251	1030	540	540
q5	7722	2462	2312	2312
q6	191	168	132	132
q7	909	743	601	601
q8	9304	1298	1092	1092
q9	5002	4575	4808	4575
q10	6803	2305	1901	1901
q11	487	282	253	253
q12	344	348	212	212
q13	17751	3675	3093	3093
q14	241	229	215	215
q15	536	484	487	484
q16	643	619	587	587
q17	588	879	343	343
q18	6848	6410	6377	6377
q19	1653	959	556	556
q20	315	336	195	195
q21	2881	2127	1941	1941
q22	1100	1044	1003	1003
Total cold run time: 103717 ms
Total hot run time: 32413 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5220	5151	5155	5151
q2	241	329	238	238
q3	2189	2687	2291	2291
q4	1438	1898	1417	1417
q5	4218	4107	4165	4107
q6	209	163	123	123
q7	1880	1957	1795	1795
q8	2619	2692	2629	2629
q9	7204	7158	7161	7158
q10	3013	3181	2796	2796
q11	583	501	511	501
q12	671	756	609	609
q13	3434	3881	3247	3247
q14	282	289	266	266
q15	524	494	499	494
q16	659	688	659	659
q17	1147	1608	1333	1333
q18	7794	7567	7414	7414
q19	839	795	948	795
q20	1981	2008	1863	1863
q21	5445	4926	4903	4903
q22	1144	1102	1005	1005
Total cold run time: 52734 ms
Total hot run time: 50794 ms

@doris-robot
Copy link

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

query1	1000	395	399	395
query2	6547	1878	1887	1878
query3	6803	210	207	207
query4	26523	23209	23358	23209
query5	4388	657	494	494
query6	289	203	193	193
query7	4615	497	296	296
query8	296	245	236	236
query9	8615	2538	2552	2538
query10	474	329	252	252
query11	15572	15215	14930	14930
query12	165	106	108	106
query13	1661	523	415	415
query14	10015	6622	6235	6235
query15	209	195	174	174
query16	7478	667	453	453
query17	1200	730	576	576
query18	1982	401	301	301
query19	196	184	157	157
query20	118	115	117	115
query21	213	169	101	101
query22	4354	4115	4153	4115
query23	33960	32800	32857	32800
query24	7765	2346	2401	2346
query25	516	452	404	404
query26	1244	261	152	152
query27	2118	495	329	329
query28	3905	2437	2407	2407
query29	728	546	438	438
query30	279	222	189	189
query31	926	855	752	752
query32	79	62	63	62
query33	585	344	301	301
query34	788	840	493	493
query35	784	802	736	736
query36	928	997	864	864
query37	116	94	74	74
query38	4258	4275	4038	4038
query39	1441	1416	1486	1416
query40	207	120	101	101
query41	53	49	50	49
query42	121	101	103	101
query43	495	506	471	471
query44	1252	774	780	774
query45	175	167	161	161
query46	844	1013	626	626
query47	1730	1799	1732	1732
query48	360	396	301	301
query49	774	511	425	425
query50	671	733	416	416
query51	4192	4221	4115	4115
query52	110	105	93	93
query53	236	255	186	186
query54	502	489	412	412
query55	94	83	81	81
query56	263	278	258	258
query57	1115	1141	1052	1052
query58	239	229	247	229
query59	2713	2733	2607	2607
query60	274	270	266	266
query61	120	118	132	118
query62	813	707	666	666
query63	233	185	192	185
query64	4281	1002	649	649
query65	4404	4302	4294	4294
query66	1121	400	309	309
query67	15652	15320	15205	15205
query68	8135	867	508	508
query69	462	282	261	261
query70	1204	1118	1100	1100
query71	483	307	262	262
query72	5440	3595	3553	3553
query73	797	723	338	338
query74	8886	8983	8677	8677
query75	3814	3117	2681	2681
query76	3730	1166	734	734
query77	792	373	286	286
query78	10051	10099	9313	9313
query79	2673	819	580	580
query80	627	516	445	445
query81	493	261	218	218
query82	694	124	92	92
query83	168	174	160	160
query84	245	97	73	73
query85	769	357	305	305
query86	388	324	266	266
query87	4536	4379	4417	4379
query88	3695	2152	2233	2152
query89	394	322	284	284
query90	1834	194	182	182
query91	139	142	114	114
query92	74	61	59	59
query93	1832	1033	585	585
query94	661	411	308	308
query95	346	262	256	256
query96	486	560	267	267
query97	3329	3398	3294	3294
query98	225	201	201	201
query99	1540	1396	1273	1273
Total cold run time: 275119 ms
Total hot run time: 184265 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.62	0.10	0.10
query5	0.56	0.55	0.56
query6	1.19	0.72	0.72
query7	0.02	0.02	0.02
query8	0.05	0.04	0.03
query9	0.59	0.53	0.51
query10	0.56	0.58	0.56
query11	0.15	0.11	0.11
query12	0.14	0.11	0.11
query13	0.62	0.60	0.59
query14	2.69	2.81	2.68
query15	0.93	0.84	0.85
query16	0.38	0.36	0.37
query17	1.00	1.00	1.04
query18	0.20	0.19	0.20
query19	1.89	1.80	1.95
query20	0.01	0.02	0.01
query21	15.39	0.91	0.54
query22	0.75	1.08	0.75
query23	14.91	1.34	0.62
query24	7.35	1.29	0.74
query25	0.48	0.22	0.13
query26	0.66	0.16	0.13
query27	0.05	0.06	0.04
query28	8.54	0.82	0.41
query29	12.55	3.94	3.31
query30	0.25	0.10	0.06
query31	2.81	0.60	0.38
query32	3.24	0.56	0.46
query33	2.99	2.97	3.05
query34	15.72	5.16	4.52
query35	4.54	4.57	4.54
query36	0.65	0.48	0.48
query37	0.08	0.06	0.06
query38	0.05	0.04	0.03
query39	0.02	0.02	0.02
query40	0.16	0.13	0.12
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 104.28 s
Total hot run time: 30.68 s

@hello-stephen
Copy link
Contributor

BE UT Coverage Report

Increment line coverage 29.13% (90/309) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 45.90% (12264/26717)
Line Coverage 35.38% (103556/292737)
Region Coverage 34.54% (53050/153585)
Branch Coverage 30.23% (26853/88840)

@Mryange
Copy link
Contributor Author

Mryange commented Mar 5, 2025

run external

@Mryange
Copy link
Contributor Author

Mryange commented Mar 5, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17604	5146	5107	5107
q2	2045	292	177	177
q3	10405	1309	713	713
q4	10224	1004	528	528
q5	7529	2446	2355	2355
q6	190	173	137	137
q7	915	757	604	604
q8	9311	1324	1136	1136
q9	4914	4753	4943	4753
q10	6823	2310	1877	1877
q11	484	294	255	255
q12	342	353	214	214
q13	17771	3694	3039	3039
q14	222	224	210	210
q15	544	477	467	467
q16	633	616	594	594
q17	597	861	352	352
q18	6847	6472	6377	6377
q19	1351	960	542	542
q20	321	325	185	185
q21	2904	2112	1956	1956
q22	1090	1000	980	980
Total cold run time: 103066 ms
Total hot run time: 32558 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5156	5088	5089	5088
q2	234	334	231	231
q3	2184	2685	2263	2263
q4	1439	1830	1364	1364
q5	4246	4117	4175	4117
q6	205	161	122	122
q7	1892	1941	1836	1836
q8	2579	2672	2677	2672
q9	7202	7123	7164	7123
q10	3023	3153	2784	2784
q11	585	491	476	476
q12	688	756	604	604
q13	3535	3817	3269	3269
q14	286	284	269	269
q15	522	478	474	474
q16	634	667	630	630
q17	1145	1591	1344	1344
q18	7775	7450	7568	7450
q19	831	832	946	832
q20	1973	2075	1843	1843
q21	5413	4942	4838	4838
q22	1129	1070	1016	1016
Total cold run time: 52676 ms
Total hot run time: 50645 ms

@doris-robot
Copy link

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

query1	996	372	401	372
query2	6515	1932	1929	1929
query3	6787	209	211	209
query4	26242	23733	23097	23097
query5	4365	720	493	493
query6	298	200	195	195
query7	4618	502	298	298
query8	302	246	249	246
query9	8610	2550	2537	2537
query10	448	340	259	259
query11	15329	15529	14918	14918
query12	171	110	105	105
query13	1672	535	417	417
query14	10077	6714	6558	6558
query15	206	190	180	180
query16	7659	672	471	471
query17	1194	733	567	567
query18	1985	413	309	309
query19	195	189	158	158
query20	122	117	115	115
query21	209	120	104	104
query22	4269	4275	4278	4275
query23	34059	32905	33071	32905
query24	7699	2356	2409	2356
query25	517	454	389	389
query26	1211	273	149	149
query27	2110	507	323	323
query28	3874	2411	2424	2411
query29	702	547	415	415
query30	281	214	197	197
query31	941	859	757	757
query32	73	64	64	64
query33	560	356	324	324
query34	785	842	491	491
query35	790	805	769	769
query36	962	1001	869	869
query37	125	99	78	78
query38	4244	4140	4192	4140
query39	1472	1381	1415	1381
query40	211	117	102	102
query41	57	58	49	49
query42	121	106	104	104
query43	499	514	498	498
query44	1316	784	786	784
query45	176	171	162	162
query46	842	1012	617	617
query47	1770	1788	1697	1697
query48	374	414	295	295
query49	790	514	410	410
query50	678	738	401	401
query51	4214	4152	4117	4117
query52	110	111	97	97
query53	231	258	187	187
query54	519	480	415	415
query55	83	80	80	80
query56	270	261	251	251
query57	1138	1134	1038	1038
query58	242	227	231	227
query59	2692	2790	2618	2618
query60	283	275	257	257
query61	123	121	119	119
query62	798	711	658	658
query63	230	194	195	194
query64	4235	1019	658	658
query65	4392	4305	4356	4305
query66	1095	430	299	299
query67	15805	15527	15173	15173
query68	7958	887	516	516
query69	463	305	271	271
query70	1186	1143	1120	1120
query71	500	289	282	282
query72	5560	3555	3736	3555
query73	785	733	339	339
query74	9166	9077	8935	8935
query75	3739	3144	2713	2713
query76	3696	1174	754	754
query77	814	384	281	281
query78	10023	10089	9338	9338
query79	2449	835	581	581
query80	657	535	451	451
query81	480	257	220	220
query82	665	126	93	93
query83	179	170	154	154
query84	266	94	74	74
query85	795	359	307	307
query86	334	318	276	276
query87	4418	4684	4400	4400
query88	3409	2183	2185	2183
query89	390	317	286	286
query90	1953	193	195	193
query91	138	142	113	113
query92	133	62	55	55
query93	1170	1044	583	583
query94	671	419	300	300
query95	356	266	265	265
query96	488	568	268	268
query97	3330	3375	3300	3300
query98	230	206	197	197
query99	1438	1379	1287	1287
Total cold run time: 273807 ms
Total hot run time: 185332 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.07	0.03	0.03
query3	0.24	0.06	0.06
query4	1.62	0.10	0.11
query5	0.54	0.56	0.55
query6	1.19	0.73	0.73
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.59	0.54	0.53
query10	0.57	0.59	0.58
query11	0.15	0.11	0.11
query12	0.15	0.11	0.11
query13	0.61	0.60	0.59
query14	2.67	2.68	2.72
query15	0.93	0.84	0.83
query16	0.39	0.38	0.39
query17	0.99	1.03	1.02
query18	0.21	0.20	0.19
query19	1.94	1.96	1.78
query20	0.01	0.01	0.01
query21	15.40	0.90	0.54
query22	0.76	1.35	0.74
query23	14.73	1.38	0.61
query24	7.23	1.59	1.05
query25	0.51	0.22	0.15
query26	0.56	0.16	0.14
query27	0.05	0.05	0.04
query28	9.99	0.85	0.43
query29	12.57	3.99	3.31
query30	0.25	0.10	0.07
query31	2.80	0.60	0.40
query32	3.23	0.54	0.46
query33	3.01	3.09	3.00
query34	15.82	5.05	4.45
query35	4.50	4.54	4.50
query36	0.65	0.48	0.49
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.18	0.13	0.13
query41	0.08	0.02	0.02
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.51 s
Total hot run time: 31.05 s

@doris-robot
Copy link

BE UT Coverage Report

Increment line coverage 29.13% (90/309) 🎉

Increment coverage report
Complete coverage report

Category Coverage
Function Coverage 45.90% (12263/26717)
Line Coverage 35.37% (103558/292767)
Region Coverage 34.54% (53043/153590)
Branch Coverage 30.22% (26850/88838)

@Mryange
Copy link
Contributor Author

Mryange commented Mar 6, 2025

run buildall

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.

5 participants