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

[UT](exchanger) Add UT case for shuffle exchanger #47598

Merged
merged 1 commit into from
Feb 8, 2025

Conversation

Gabriel39
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

  • Test

    • Regression test
    • Unit Test
    • Manual test (add detailed scripts or steps below)
    • No need to test or manual test. Explain why:
      • This is a refactor/code format and no logic has been changed.
      • Previous test can cover this change.
      • No code files have been changed.
      • Other reason
  • Behavior changed:

    • No.
    • Yes.
  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@hello-stephen
Copy link
Contributor

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?

@Gabriel39
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.27% (11069/26189)
Line Coverage: 32.45% (93332/287578)
Region Coverage: 31.63% (47873/151360)
Branch Coverage: 27.60% (24196/87662)
Coverage Report: http://coverage.selectdb-in.cc/coverage/46d570f92879afa26d1fbeea2a9ef89f25a53663_46d570f92879afa26d1fbeea2a9ef89f25a53663/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17620	5171	5070	5070
q2	2040	297	167	167
q3	10418	1262	725	725
q4	10217	1017	558	558
q5	7541	2338	2348	2338
q6	187	166	135	135
q7	890	744	595	595
q8	9303	1274	1157	1157
q9	4982	4604	4810	4604
q10	6823	2332	1861	1861
q11	486	276	253	253
q12	341	350	218	218
q13	17764	3715	3111	3111
q14	232	244	213	213
q15	506	462	471	462
q16	639	622	600	600
q17	572	851	341	341
q18	6645	6352	6232	6232
q19	1207	947	536	536
q20	331	327	192	192
q21	2815	2161	1974	1974
q22	369	338	312	312
Total cold run time: 101928 ms
Total hot run time: 31654 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5596	5224	5214	5214
q2	243	334	230	230
q3	2186	2649	2321	2321
q4	1474	1837	1389	1389
q5	4297	4179	4210	4179
q6	217	173	125	125
q7	1879	1845	1738	1738
q8	2644	2554	2578	2554
q9	7360	7186	7217	7186
q10	3060	3245	2855	2855
q11	581	531	506	506
q12	695	803	660	660
q13	3757	4213	3576	3576
q14	300	340	296	296
q15	542	480	489	480
q16	661	677	678	677
q17	1195	1697	1364	1364
q18	7889	7400	7456	7400
q19	1047	837	940	837
q20	2071	2063	1874	1874
q21	5380	4991	4876	4876
q22	619	584	555	555
Total cold run time: 53693 ms
Total hot run time: 50892 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190600 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 46d570f92879afa26d1fbeea2a9ef89f25a53663, data reload: false

query1	1324	954	938	938
query2	6430	1870	1893	1870
query3	11113	4657	4644	4644
query4	54176	25839	23165	23165
query5	4941	570	502	502
query6	335	201	200	200
query7	4931	512	300	300
query8	306	245	222	222
query9	5304	2509	2500	2500
query10	425	316	265	265
query11	15530	15073	15014	15014
query12	156	112	106	106
query13	1036	509	397	397
query14	10689	6829	6915	6829
query15	198	197	188	188
query16	7125	696	465	465
query17	1061	731	551	551
query18	1562	401	309	309
query19	191	194	156	156
query20	122	125	132	125
query21	209	130	105	105
query22	4428	4560	4337	4337
query23	33978	33376	33323	33323
query24	5665	2436	2420	2420
query25	481	456	394	394
query26	713	276	155	155
query27	1767	509	340	340
query28	2866	2432	2431	2431
query29	578	572	424	424
query30	218	200	160	160
query31	899	852	802	802
query32	74	64	62	62
query33	458	354	305	305
query34	788	846	504	504
query35	815	839	739	739
query36	976	1013	934	934
query37	128	114	82	82
query38	4253	4328	4139	4139
query39	1494	1436	1453	1436
query40	217	115	102	102
query41	52	51	65	51
query42	118	106	109	106
query43	505	506	510	506
query44	1307	804	826	804
query45	187	176	174	174
query46	911	1069	663	663
query47	1844	1882	1817	1817
query48	400	407	312	312
query49	687	525	448	448
query50	709	744	432	432
query51	4272	4324	4244	4244
query52	108	105	98	98
query53	239	258	188	188
query54	506	486	411	411
query55	81	79	83	79
query56	250	252	275	252
query57	1157	1182	1110	1110
query58	255	238	262	238
query59	2795	2952	2717	2717
query60	291	271	262	262
query61	119	118	119	118
query62	753	748	668	668
query63	224	191	198	191
query64	1490	1087	661	661
query65	3300	3265	3247	3247
query66	717	397	293	293
query67	15965	15743	15512	15512
query68	3893	789	522	522
query69	532	318	256	256
query70	1207	1153	1137	1137
query71	404	287	268	268
query72	6300	3673	3798	3673
query73	753	764	344	344
query74	8911	9153	8766	8766
query75	3168	3156	2668	2668
query76	2769	1165	733	733
query77	521	366	276	276
query78	10069	10332	9268	9268
query79	931	902	654	654
query80	685	531	464	464
query81	524	276	234	234
query82	425	157	124	124
query83	184	178	166	166
query84	291	102	71	71
query85	752	359	316	316
query86	373	304	291	291
query87	4432	4557	4361	4361
query88	2819	2188	2171	2171
query89	412	315	292	292
query90	1622	265	193	193
query91	136	147	112	112
query92	63	64	57	57
query93	1246	1010	579	579
query94	632	415	296	296
query95	350	276	267	267
query96	487	553	267	267
query97	2775	2855	2756	2756
query98	223	201	212	201
query99	1311	1416	1275	1275
Total cold run time: 286402 ms
Total hot run time: 190600 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.04
query3	0.23	0.07	0.06
query4	1.63	0.10	0.11
query5	0.40	0.42	0.41
query6	1.17	0.67	0.66
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.61	0.51	0.52
query10	0.57	0.58	0.56
query11	0.16	0.11	0.11
query12	0.14	0.11	0.11
query13	0.61	0.60	0.61
query14	2.72	2.71	2.81
query15	0.93	0.86	0.86
query16	0.37	0.38	0.38
query17	1.02	1.01	1.04
query18	0.22	0.20	0.20
query19	1.86	1.83	1.94
query20	0.01	0.01	0.01
query21	15.34	0.90	0.54
query22	0.75	1.24	0.72
query23	14.86	1.39	0.65
query24	7.00	1.68	0.56
query25	0.51	0.28	0.06
query26	0.47	0.17	0.15
query27	0.05	0.05	0.06
query28	9.28	0.85	0.44
query29	12.56	3.96	3.30
query30	0.26	0.09	0.06
query31	2.83	0.59	0.38
query32	3.22	0.54	0.48
query33	2.98	2.99	3.09
query34	15.72	5.14	4.51
query35	4.59	4.56	4.53
query36	0.67	0.50	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.16	0.12	0.13
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 104.38 s
Total hot run time: 30.46 s

@Gabriel39 Gabriel39 merged commit c3a64aa into apache:master Feb 8, 2025
26 of 27 checks passed
Copy link
Contributor

github-actions bot commented Feb 8, 2025

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

@github-actions github-actions bot added approved Indicates a PR has been approved by one committer. reviewed labels Feb 8, 2025
Copy link
Contributor

github-actions bot commented Feb 8, 2025

PR approved by anyone and no changes requested.

lzyy2024 pushed a commit to lzyy2024/doris that referenced this pull request Feb 21, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
approved Indicates a PR has been approved by one committer. reviewed
Projects
None yet
Development

Successfully merging this pull request may close these issues.

5 participants