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.

Sign up for GitHub

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

Jump to bottom

[UT](local merge) Add case for local merge exchanger #47838

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

[UT](local merge) Add case for local merge exchanger #47838

wants to merge 1 commit into from

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

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

------ Round 1 ----------------------------------
q1	17574	5192	5036	5036
q2	2044	295	183	183
q3	10450	1256	727	727
q4	10200	1025	571	571
q5	7515	2445	2334	2334
q6	190	168	132	132
q7	928	748	591	591
q8	9308	1357	1056	1056
q9	4928	4798	4848	4798
q10	6862	2310	1890	1890
q11	466	274	263	263
q12	341	356	212	212
q13	17764	3660	3095	3095
q14	225	223	210	210
q15	529	464	459	459
q16	645	619	574	574
q17	578	865	338	338
q18	6818	6345	6150	6150
q19	1657	963	549	549
q20	307	330	184	184
q21	2693	2218	1895	1895
q22	360	328	311	311
Total cold run time: 102382 ms
Total hot run time: 31558 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5161	5103	5090	5090
q2	227	321	224	224
q3	2142	2691	2265	2265
q4	1448	1877	1401	1401
q5	4241	4126	4133	4126
q6	211	163	123	123
q7	1864	1799	1671	1671
q8	2610	2745	2525	2525
q9	7277	7196	7158	7158
q10	3027	3180	2761	2761
q11	576	536	492	492
q12	688	793	642	642
q13	3403	3901	3253	3253
q14	287	314	274	274
q15	506	466	460	460
q16	678	689	641	641
q17	1128	1572	1380	1380
q18	7612	7522	7333	7333
q19	781	839	887	839
q20	1982	2037	1864	1864
q21	5402	4998	4741	4741
q22	590	620	535	535
Total cold run time: 51841 ms
Total hot run time: 49798 ms

@doris-robot
Copy link

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

query1	1312	979	945	945
query2	6192	1850	1841	1841
query3	11115	4702	4550	4550
query4	54532	24266	22901	22901
query5	5114	588	497	497
query6	342	188	176	176
query7	4931	541	310	310
query8	321	237	230	230
query9	5765	2477	2489	2477
query10	419	312	238	238
query11	15226	15097	15153	15097
query12	152	118	110	110
query13	1068	502	393	393
query14	10506	6859	6327	6327
query15	200	196	202	196
query16	7025	651	509	509
query17	1048	729	560	560
query18	1494	418	307	307
query19	202	185	163	163
query20	127	122	116	116
query21	209	128	107	107
query22	4502	4580	4411	4411
query23	34059	33462	33453	33453
query24	5654	2417	2420	2417
query25	446	463	395	395
query26	676	276	163	163
query27	1764	491	337	337
query28	2726	2442	2430	2430
query29	567	566	481	481
query30	216	189	157	157
query31	891	907	826	826
query32	78	66	65	65
query33	452	369	307	307
query34	761	863	520	520
query35	842	843	771	771
query36	991	1007	938	938
query37	126	98	86	86
query38	4243	4295	4249	4249
query39	1525	1421	1443	1421
query40	217	124	109	109
query41	58	56	53	53
query42	118	111	109	109
query43	483	501	503	501
query44	1298	816	823	816
query45	185	184	166	166
query46	896	1070	669	669
query47	1901	1935	1797	1797
query48	377	421	323	323
query49	692	521	425	425
query50	712	749	403	403
query51	4229	4285	4248	4248
query52	110	108	93	93
query53	236	258	203	203
query54	486	502	424	424
query55	79	76	82	76
query56	253	288	247	247
query57	1183	1182	1102	1102
query58	257	267	232	232
query59	2786	2952	2805	2805
query60	285	276	263	263
query61	121	110	120	110
query62	764	721	682	682
query63	224	188	192	188
query64	1453	1043	677	677
query65	3318	3293	3267	3267
query66	781	405	299	299
query67	15951	15579	15460	15460
query68	5057	773	530	530
query69	496	296	262	262
query70	1189	1114	1143	1114
query71	432	297	266	266
query72	6049	3611	3748	3611
query73	1220	753	357	357
query74	8928	9201	8739	8739
query75	3139	3168	2711	2711
query76	3761	1175	732	732
query77	527	352	290	290
query78	9982	10057	9288	9288
query79	2640	812	593	593
query80	655	518	462	462
query81	504	277	239	239
query82	480	127	93	93
query83	177	180	157	157
query84	296	94	76	76
query85	776	341	298	298
query86	367	296	290	290
query87	4567	4547	4536	4536
query88	3582	2213	2200	2200
query89	412	322	280	280
query90	1759	194	192	192
query91	138	134	110	110
query92	72	60	56	56
query93	2094	1013	587	587
query94	704	402	293	293
query95	342	264	256	256
query96	477	566	268	268
query97	2814	2839	2712	2712
query98	227	213	210	210
query99	1299	1409	1282	1282
Total cold run time: 292434 ms
Total hot run time: 190314 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.99% (11314/26316)
Line Coverage: 32.91% (94968/288597)
Region Coverage: 32.07% (48692/151829)
Branch Coverage: 27.92% (24555/87944)
Coverage Report: http://coverage.selectdb-in.cc/coverage/f0fa95e78063f8d55e4dd07f494ffb05034feb06_f0fa95e78063f8d55e4dd07f494ffb05034feb06/report/index.html

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.06	0.04	0.02
query3	0.23	0.07	0.07
query4	1.62	0.10	0.10
query5	0.41	0.44	0.40
query6	1.17	0.66	0.64
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.52	0.51
query10	0.57	0.59	0.56
query11	0.16	0.11	0.10
query12	0.14	0.11	0.12
query13	0.61	0.60	0.60
query14	2.67	2.75	2.72
query15	0.91	0.84	0.85
query16	0.38	0.38	0.36
query17	1.04	1.01	1.03
query18	0.22	0.21	0.19
query19	1.86	1.79	1.98
query20	0.02	0.01	0.02
query21	15.36	0.86	0.54
query22	0.74	1.27	0.64
query23	14.91	1.35	0.65
query24	7.98	1.13	0.62
query25	0.48	0.14	0.18
query26	0.68	0.16	0.14
query27	0.05	0.05	0.05
query28	9.46	0.83	0.41
query29	12.54	3.95	3.33
query30	0.24	0.08	0.06
query31	2.84	0.57	0.40
query32	3.22	0.56	0.46
query33	2.97	3.01	3.03
query34	15.80	5.18	4.56
query35	4.55	4.56	4.57
query36	0.65	0.50	0.48
query37	0.09	0.06	0.06
query38	0.04	0.04	0.04
query39	0.03	0.02	0.03
query40	0.18	0.13	0.13
query41	0.08	0.02	0.03
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.71 s
Total hot run time: 30.48 s

@Gabriel39
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.99% (11313/26316)
Line Coverage: 32.90% (94957/288618)
Region Coverage: 32.06% (48680/151842)
Branch Coverage: 27.92% (24552/87952)
Coverage Report: http://coverage.selectdb-in.cc/coverage/f0fa95e78063f8d55e4dd07f494ffb05034feb06_f0fa95e78063f8d55e4dd07f494ffb05034feb06/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17572	5304	5095	5095
q2	2056	301	192	192
q3	10384	1246	763	763
q4	10208	1014	543	543
q5	7510	2336	2356	2336
q6	184	168	136	136
q7	896	759	600	600
q8	9321	1332	1040	1040
q9	4855	4734	4691	4691
q10	6809	2317	1891	1891
q11	482	283	260	260
q12	355	347	219	219
q13	17763	3713	3185	3185
q14	248	237	220	220
q15	496	460	459	459
q16	618	632	579	579
q17	583	892	328	328
q18	6499	6192	6225	6192
q19	1488	938	537	537
q20	322	327	193	193
q21	2995	2154	1944	1944
q22	380	342	309	309
Total cold run time: 102024 ms
Total hot run time: 31712 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5386	5170	5128	5128
q2	237	325	230	230
q3	2139	2665	2258	2258
q4	1423	1810	1346	1346
q5	4265	4140	4181	4140
q6	205	163	127	127
q7	1829	1804	1666	1666
q8	2577	2609	2549	2549
q9	7208	7138	7069	7069
q10	3025	3216	2760	2760
q11	577	516	493	493
q12	711	791	629	629
q13	3582	3993	3299	3299
q14	287	308	267	267
q15	516	452	469	452
q16	654	672	645	645
q17	1146	1608	1318	1318
q18	7421	7348	7247	7247
q19	806	827	829	827
q20	1976	2061	1845	1845
q21	5448	4907	4814	4814
q22	622	600	534	534
Total cold run time: 52040 ms
Total hot run time: 49643 ms

@doris-robot
Copy link

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

query1	1321	930	920	920
query2	6228	1892	1842	1842
query3	10958	4497	4534	4497
query4	53262	25812	22968	22968
query5	4995	607	503	503
query6	319	199	219	199
query7	4884	513	291	291
query8	297	253	238	238
query9	5266	2565	2531	2531
query10	426	309	258	258
query11	15195	15078	14904	14904
query12	155	110	105	105
query13	1024	509	382	382
query14	10386	6454	6454	6454
query15	211	217	182	182
query16	7045	659	500	500
query17	1038	717	549	549
query18	1534	409	320	320
query19	215	194	160	160
query20	131	125	131	125
query21	212	126	107	107
query22	4592	4601	4424	4424
query23	34018	33152	33352	33152
query24	6044	2473	2424	2424
query25	482	474	453	453
query26	679	280	163	163
query27	1874	486	334	334
query28	3182	2474	2403	2403
query29	558	548	423	423
query30	220	192	153	153
query31	890	870	824	824
query32	71	66	66	66
query33	436	355	299	299
query34	784	849	511	511
query35	816	824	774	774
query36	993	986	917	917
query37	127	102	73	73
query38	4345	4376	4250	4250
query39	1699	1488	1421	1421
query40	201	122	105	105
query41	53	50	49	49
query42	127	106	112	106
query43	505	516	501	501
query44	1307	806	817	806
query45	178	169	165	165
query46	874	1060	665	665
query47	1847	1878	1812	1812
query48	394	419	306	306
query49	701	524	413	413
query50	734	769	415	415
query51	4406	4279	4201	4201
query52	105	106	95	95
query53	242	264	195	195
query54	478	503	435	435
query55	83	76	77	76
query56	268	274	259	259
query57	1153	1146	1105	1105
query58	247	250	246	246
query59	2828	2941	2859	2859
query60	310	300	273	273
query61	144	146	145	145
query62	739	767	655	655
query63	233	198	190	190
query64	1459	1039	725	725
query65	3185	3147	3129	3129
query66	760	382	301	301
query67	15731	15467	15548	15467
query68	4071	794	507	507
query69	508	289	262	262
query70	1214	1128	1104	1104
query71	445	303	266	266
query72	6380	3664	3712	3664
query73	759	757	351	351
query74	9169	9180	8975	8975
query75	3178	3162	2711	2711
query76	3325	1157	743	743
query77	498	386	282	282
query78	9954	9999	9277	9277
query79	2100	786	588	588
query80	768	516	438	438
query81	496	291	234	234
query82	469	122	94	94
query83	172	165	149	149
query84	288	95	69	69
query85	757	359	309	309
query86	373	306	297	297
query87	4413	4549	4394	4394
query88	2921	2176	2172	2172
query89	406	317	289	289
query90	1704	191	192	191
query91	138	138	109	109
query92	74	60	57	57
query93	2704	1028	579	579
query94	713	417	302	302
query95	413	274	259	259
query96	474	551	277	277
query97	2813	2861	2757	2757
query98	223	212	195	195
query99	1299	1413	1252	1252
Total cold run time: 289423 ms
Total hot run time: 189951 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.08	0.04	0.05
query3	0.24	0.07	0.07
query4	1.62	0.10	0.11
query5	0.42	0.41	0.41
query6	1.15	0.65	0.66
query7	0.02	0.02	0.02
query8	0.05	0.03	0.03
query9	0.58	0.52	0.50
query10	0.57	0.57	0.57
query11	0.15	0.10	0.10
query12	0.13	0.11	0.12
query13	0.63	0.60	0.60
query14	2.71	2.79	2.70
query15	0.91	0.85	0.85
query16	0.38	0.39	0.37
query17	1.00	1.01	1.02
query18	0.22	0.19	0.19
query19	1.94	1.80	1.99
query20	0.02	0.02	0.01
query21	15.35	0.89	0.54
query22	0.75	1.28	0.73
query23	14.76	1.37	0.62
query24	7.27	1.93	0.57
query25	0.50	0.19	0.07
query26	0.47	0.17	0.13
query27	0.05	0.06	0.04
query28	9.34	0.88	0.44
query29	12.52	3.99	3.29
query30	0.26	0.09	0.06
query31	2.82	0.58	0.38
query32	3.23	0.56	0.47
query33	3.00	3.03	2.99
query34	15.75	5.09	4.45
query35	4.47	4.50	4.48
query36	0.65	0.49	0.50
query37	0.10	0.06	0.07
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.13	0.13
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 104.55 s
Total hot run time: 30.23 s

@Gabriel39
Copy link
Contributor Author

run buildall

@Gabriel39
Copy link
Contributor Author

run buildall

1 similar comment
@Gabriel39
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17583	5248	5045	5045
q2	2046	297	168	168
q3	10523	1351	703	703
q4	10306	1012	521	521
q5	8585	2367	2368	2367
q6	189	169	135	135
q7	894	741	602	602
q8	9310	1336	1113	1113
q9	4906	4822	4764	4764
q10	6835	2297	1895	1895
q11	472	274	249	249
q12	344	354	212	212
q13	17775	3713	3045	3045
q14	239	229	202	202
q15	518	462	454	454
q16	621	624	592	592
q17	565	876	346	346
q18	6863	6202	6201	6201
q19	1348	954	530	530
q20	307	320	191	191
q21	2700	2186	1916	1916
q22	366	327	308	308
Total cold run time: 103295 ms
Total hot run time: 31559 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5171	5394	5087	5087
q2	236	331	238	238
q3	2173	2672	2335	2335
q4	1418	1826	1363	1363
q5	4246	4185	4150	4150
q6	207	164	122	122
q7	1864	1823	1771	1771
q8	2655	2803	2667	2667
q9	7317	7027	7166	7027
q10	3029	3192	2801	2801
q11	586	503	473	473
q12	670	806	632	632
q13	3511	3864	3247	3247
q14	296	307	290	290
q15	502	475	460	460
q16	627	685	666	666
q17	1127	1565	1370	1370
q18	7653	7260	7257	7257
q19	766	776	802	776
q20	1952	2019	1894	1894
q21	5874	4922	4893	4893
q22	628	603	531	531
Total cold run time: 52508 ms
Total hot run time: 50050 ms

@Gabriel39
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17588	5163	5001	5001
q2	2064	299	163	163
q3	10410	1271	727	727
q4	10212	1018	533	533
q5	7523	2386	2342	2342
q6	187	164	134	134
q7	914	743	591	591
q8	9300	1327	1059	1059
q9	4853	4696	4698	4696
q10	6845	2319	1865	1865
q11	468	281	247	247
q12	356	350	213	213
q13	17753	3696	3067	3067
q14	224	226	215	215
q15	522	457	457	457
q16	629	610	568	568
q17	583	866	333	333
q18	6820	6262	6191	6191
q19	1397	941	537	537
q20	308	329	189	189
q21	2858	2078	1958	1958
q22	361	324	294	294
Total cold run time: 102175 ms
Total hot run time: 31380 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5076	5393	5068	5068
q2	237	327	231	231
q3	2124	2645	2312	2312
q4	1448	1822	1354	1354
q5	4217	4106	4141	4106
q6	208	164	124	124
q7	1864	1820	1666	1666
q8	2619	2505	2545	2505
q9	7246	7219	7167	7167
q10	3025	3211	2769	2769
q11	580	519	494	494
q12	672	764	617	617
q13	3541	3818	3275	3275
q14	277	311	278	278
q15	495	468	460	460
q16	658	673	644	644
q17	1110	1581	1346	1346
q18	7604	7388	7361	7361
q19	785	828	874	828
q20	1977	2040	1896	1896
q21	5419	4871	4810	4810
q22	619	563	525	525
Total cold run time: 51801 ms
Total hot run time: 49836 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 189663 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 14ce699057b4651e60b89bd1176c56237c0d33d0, data reload: false

query1	1305	954	941	941
query2	6234	1840	1851	1840
query3	11110	4491	4616	4491
query4	54660	25669	23530	23530
query5	4979	546	471	471
query6	300	190	191	190
query7	4872	522	293	293
query8	322	246	228	228
query9	5714	2580	2587	2580
query10	439	313	254	254
query11	15096	15102	14784	14784
query12	156	112	104	104
query13	1044	516	397	397
query14	10071	6356	6615	6356
query15	204	199	187	187
query16	7055	676	466	466
query17	1046	709	560	560
query18	1539	416	320	320
query19	188	185	179	179
query20	125	121	119	119
query21	209	125	105	105
query22	4724	4529	4417	4417
query23	33926	33644	33210	33210
query24	5747	2395	2406	2395
query25	461	457	415	415
query26	707	278	157	157
query27	2056	468	337	337
query28	2905	2460	2440	2440
query29	575	571	415	415
query30	211	196	161	161
query31	909	863	822	822
query32	82	68	58	58
query33	439	359	334	334
query34	759	877	505	505
query35	804	835	745	745
query36	956	1000	897	897
query37	119	94	77	77
query38	4328	4268	4259	4259
query39	1493	1589	1425	1425
query40	203	111	115	111
query41	51	48	48	48
query42	122	103	104	103
query43	508	510	476	476
query44	1323	825	803	803
query45	179	173	166	166
query46	865	1047	656	656
query47	1878	1891	1844	1844
query48	382	413	310	310
query49	688	496	426	426
query50	721	752	420	420
query51	4240	4299	4208	4208
query52	114	109	104	104
query53	238	261	195	195
query54	469	476	414	414
query55	84	83	85	83
query56	283	274	270	270
query57	1161	1195	1085	1085
query58	256	247	260	247
query59	2787	2975	2858	2858
query60	293	281	263	263
query61	117	116	117	116
query62	773	744	672	672
query63	239	195	200	195
query64	1476	1020	657	657
query65	3318	3216	3167	3167
query66	716	401	289	289
query67	15786	15499	15409	15409
query68	3549	788	525	525
query69	481	302	261	261
query70	1185	1097	1096	1096
query71	391	293	265	265
query72	6255	3554	3750	3554
query73	740	747	348	348
query74	8881	8960	8759	8759
query75	3122	3118	2661	2661
query76	2620	1158	727	727
query77	550	357	272	272
query78	9908	10018	9188	9188
query79	2204	810	596	596
query80	865	525	449	449
query81	518	274	237	237
query82	416	128	96	96
query83	181	171	154	154
query84	298	92	82	82
query85	771	344	328	328
query86	358	415	290	290
query87	4299	4365	4325	4325
query88	2794	2205	2171	2171
query89	390	308	276	276
query90	1650	193	190	190
query91	199	146	104	104
query92	60	61	56	56
query93	1433	977	573	573
query94	651	395	289	289
query95	347	263	254	254
query96	487	554	268	268
query97	2807	2878	2736	2736
query98	234	207	201	201
query99	1294	1412	1273	1273
Total cold run time: 287077 ms
Total hot run time: 189663 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.07
query4	1.62	0.10	0.10
query5	0.40	0.41	0.39
query6	1.16	0.68	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.50	0.53
query10	0.58	0.58	0.56
query11	0.16	0.10	0.10
query12	0.15	0.11	0.11
query13	0.61	0.61	0.61
query14	2.70	2.82	2.80
query15	0.92	0.86	0.86
query16	0.38	0.38	0.37
query17	1.04	1.05	1.03
query18	0.21	0.20	0.20
query19	1.88	1.76	1.98
query20	0.02	0.01	0.01
query21	15.36	0.86	0.54
query22	0.75	1.13	0.73
query23	14.88	1.39	0.66
query24	11.04	1.16	0.39
query25	0.50	0.36	0.09
query26	0.90	0.18	0.14
query27	0.04	0.04	0.04
query28	6.49	0.78	0.42
query29	12.56	3.94	3.28
query30	0.25	0.10	0.05
query31	2.82	0.60	0.38
query32	3.23	0.55	0.46
query33	3.03	3.02	2.92
query34	15.66	5.15	4.49
query35	4.56	4.54	4.55
query36	0.66	0.48	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.03	0.02
query40	0.16	0.14	0.12
query41	0.08	0.03	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.05 s
Total hot run time: 30.15 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 43.02% (11323/26318)
Line Coverage: 32.93% (95043/288613)
Region Coverage: 32.08% (48708/151851)
Branch Coverage: 27.92% (24560/87960)
Coverage Report: http://coverage.selectdb-in.cc/coverage/14ce699057b4651e60b89bd1176c56237c0d33d0_14ce699057b4651e60b89bd1176c56237c0d33d0/report/index.html

@Gabriel39
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17632	5224	5037	5037
q2	2055	305	179	179
q3	10895	1253	737	737
q4	10208	995	529	529
q5	7532	2380	2297	2297
q6	187	169	132	132
q7	884	733	602	602
q8	9276	1258	1079	1079
q9	4896	4587	4527	4527
q10	6805	2306	1889	1889
q11	483	273	264	264
q12	335	349	212	212
q13	17792	3666	3049	3049
q14	226	224	208	208
q15	498	451	466	451
q16	631	620	569	569
q17	560	858	340	340
q18	7020	6155	6139	6139
q19	1201	927	542	542
q20	308	329	186	186
q21	2708	2232	1943	1943
q22	360	331	300	300
Total cold run time: 102492 ms
Total hot run time: 31211 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5071	5068	5081	5068
q2	242	330	234	234
q3	2148	2686	2268	2268
q4	1399	1797	1378	1378
q5	4223	4100	4144	4100
q6	209	165	126	126
q7	1841	1806	1629	1629
q8	2543	2611	2526	2526
q9	7118	7122	7138	7122
q10	2989	3199	2757	2757
q11	568	526	507	507
q12	695	802	624	624
q13	3537	3762	3281	3281
q14	288	304	274	274
q15	510	464	466	464
q16	660	687	636	636
q17	1103	1596	1335	1335
q18	7488	7216	7263	7216
q19	787	816	806	806
q20	1993	2053	1849	1849
q21	5317	4910	4917	4910
q22	667	569	562	562
Total cold run time: 51396 ms
Total hot run time: 49672 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 189592 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 335506188a3ac74c97824624baf749406153883c, data reload: false

query1	1287	949	968	949
query2	6217	1817	1815	1815
query3	10960	4494	4510	4494
query4	55802	25367	23399	23399
query5	5226	565	480	480
query6	335	190	182	182
query7	4944	502	292	292
query8	312	239	227	227
query9	5830	2585	2559	2559
query10	416	297	247	247
query11	15305	15001	14845	14845
query12	159	110	109	109
query13	1043	502	397	397
query14	10080	6184	6544	6184
query15	187	193	189	189
query16	7029	671	459	459
query17	1065	705	554	554
query18	1500	408	293	293
query19	196	187	153	153
query20	123	120	118	118
query21	213	122	107	107
query22	4373	4402	4289	4289
query23	34001	33458	33200	33200
query24	5824	2450	2411	2411
query25	493	478	424	424
query26	676	284	156	156
query27	1785	468	336	336
query28	2944	2491	2456	2456
query29	608	584	441	441
query30	214	192	156	156
query31	909	875	839	839
query32	71	61	56	56
query33	447	377	289	289
query34	783	846	499	499
query35	824	834	779	779
query36	951	1004	909	909
query37	116	106	79	79
query38	4219	4368	4251	4251
query39	1473	1407	1418	1407
query40	205	113	102	102
query41	54	49	49	49
query42	125	147	110	110
query43	488	509	486	486
query44	1312	828	808	808
query45	186	177	162	162
query46	867	1061	655	655
query47	1887	1901	1822	1822
query48	396	420	303	303
query49	680	514	467	467
query50	704	757	420	420
query51	4271	4278	4266	4266
query52	109	100	102	100
query53	221	263	200	200
query54	471	484	409	409
query55	91	87	90	87
query56	265	267	277	267
query57	1158	1189	1109	1109
query58	248	226	246	226
query59	2619	2774	2732	2732
query60	275	282	284	282
query61	127	119	119	119
query62	753	742	673	673
query63	264	200	184	184
query64	1400	1042	704	704
query65	3258	3193	3144	3144
query66	747	384	297	297
query67	15831	15526	15364	15364
query68	5464	765	507	507
query69	542	303	260	260
query70	1209	1118	1104	1104
query71	430	333	269	269
query72	6322	3849	3799	3799
query73	992	746	342	342
query74	8951	9121	8911	8911
query75	3169	3130	2677	2677
query76	3838	1162	740	740
query77	538	363	275	275
query78	9992	9941	9328	9328
query79	2435	796	586	586
query80	583	568	452	452
query81	491	266	237	237
query82	457	124	92	92
query83	180	174	151	151
query84	283	98	73	73
query85	770	341	310	310
query86	373	298	282	282
query87	4503	4405	4318	4318
query88	3506	2186	2146	2146
query89	401	331	284	284
query90	1725	187	188	187
query91	130	133	107	107
query92	68	57	55	55
query93	1944	1007	577	577
query94	729	381	288	288
query95	338	268	249	249
query96	467	557	263	263
query97	2816	2894	2719	2719
query98	221	207	204	204
query99	1341	1378	1224	1224
Total cold run time: 293160 ms
Total hot run time: 189592 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 43.03% (11324/26318)
Line Coverage: 32.94% (95059/288609)
Region Coverage: 32.07% (48702/151848)
Branch Coverage: 27.93% (24568/87958)
Coverage Report: http://coverage.selectdb-in.cc/coverage/335506188a3ac74c97824624baf749406153883c_335506188a3ac74c97824624baf749406153883c/report/index.html

@doris-robot
Copy link

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 335506188a3ac74c97824624baf749406153883c, data reload: false

query1	0.03	0.03	0.03
query2	0.07	0.03	0.03
query3	0.24	0.07	0.06
query4	1.64	0.10	0.10
query5	0.42	0.42	0.38
query6	1.16	0.66	0.66
query7	0.03	0.02	0.01
query8	0.04	0.03	0.03
query9	0.59	0.51	0.51
query10	0.58	0.58	0.57
query11	0.15	0.10	0.11
query12	0.15	0.11	0.11
query13	0.62	0.60	0.60
query14	2.68	2.73	2.69
query15	0.91	0.85	0.86
query16	0.37	0.39	0.39
query17	1.03	1.04	1.04
query18	0.22	0.20	0.19
query19	1.92	1.81	1.99
query20	0.01	0.01	0.01
query21	15.37	0.90	0.54
query22	0.76	1.19	0.77
query23	14.83	1.41	0.65
query24	11.74	0.91	0.32
query25	0.31	0.12	0.07
query26	0.96	0.18	0.13
query27	0.05	0.05	0.04
query28	6.64	0.75	0.42
query29	12.57	3.92	3.33
query30	0.26	0.09	0.07
query31	2.82	0.57	0.38
query32	3.23	0.55	0.46
query33	2.97	3.09	3.00
query34	15.90	5.14	4.51
query35	4.53	4.52	4.51
query36	0.67	0.49	0.49
query37	0.09	0.07	0.06
query38	0.05	0.03	0.03
query39	0.03	0.03	0.02
query40	0.17	0.14	0.13
query41	0.08	0.02	0.03
query42	0.03	0.03	0.02
query43	0.04	0.03	0.02
Total cold run time: 106.96 s
Total hot run time: 30.16 s

@Gabriel39
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17603	5454	5051	5051
q2	2055	289	165	165
q3	10431	1214	751	751
q4	10246	997	513	513
q5	7887	2344	2319	2319
q6	187	165	133	133
q7	900	744	589	589
q8	9291	1269	1106	1106
q9	4826	4950	4761	4761
q10	6796	2284	1873	1873
q11	474	272	256	256
q12	340	346	220	220
q13	17794	3676	3181	3181
q14	227	227	201	201
q15	495	460	451	451
q16	615	628	571	571
q17	574	866	326	326
q18	6550	6233	6174	6174
q19	1212	941	545	545
q20	319	320	196	196
q21	2673	2123	1909	1909
q22	355	338	298	298
Total cold run time: 101850 ms
Total hot run time: 31589 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5100	5088	5084	5084
q2	234	323	229	229
q3	2128	2640	2286	2286
q4	1396	1792	1336	1336
q5	4221	4107	4138	4107
q6	204	167	125	125
q7	1853	1807	1637	1637
q8	2558	2589	2552	2552
q9	7198	7170	7106	7106
q10	3004	3215	2759	2759
q11	566	514	511	511
q12	687	796	620	620
q13	3561	3832	3306	3306
q14	281	300	275	275
q15	499	474	457	457
q16	665	699	632	632
q17	1122	1571	1349	1349
q18	7517	7274	7426	7274
q19	780	839	959	839
q20	1961	2016	1920	1920
q21	5436	5053	4695	4695
q22	610	564	540	540
Total cold run time: 51581 ms
Total hot run time: 49639 ms

@doris-robot
Copy link

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

query1	1290	923	922	922
query2	6229	1855	1806	1806
query3	10986	4437	4243	4243
query4	53202	25827	23434	23434
query5	5067	586	486	486
query6	316	170	189	170
query7	4893	492	286	286
query8	287	218	242	218
query9	5520	2570	2546	2546
query10	429	319	255	255
query11	15144	14961	14903	14903
query12	165	114	107	107
query13	1041	521	390	390
query14	10789	6276	6736	6276
query15	205	199	179	179
query16	7082	674	475	475
query17	1076	708	560	560
query18	1535	398	307	307
query19	197	185	158	158
query20	122	130	120	120
query21	206	117	104	104
query22	4406	4300	4467	4300
query23	34062	33323	33357	33323
query24	5633	2423	2443	2423
query25	469	471	401	401
query26	701	281	159	159
query27	1663	500	333	333
query28	2797	2473	2446	2446
query29	607	607	417	417
query30	221	191	152	152
query31	884	838	837	837
query32	71	64	61	61
query33	466	348	292	292
query34	754	846	504	504
query35	802	837	742	742
query36	977	1022	895	895
query37	121	101	75	75
query38	4229	4293	4176	4176
query39	1514	1446	1453	1446
query40	212	119	105	105
query41	50	53	47	47
query42	121	104	102	102
query43	477	499	473	473
query44	1329	793	793	793
query45	184	185	165	165
query46	869	1063	647	647
query47	1829	1929	1786	1786
query48	396	411	317	317
query49	694	533	446	446
query50	728	749	406	406
query51	4240	4304	4333	4304
query52	111	107	94	94
query53	233	256	185	185
query54	506	477	423	423
query55	84	78	85	78
query56	267	264	259	259
query57	1137	1179	1140	1140
query58	244	246	248	246
query59	2678	2771	2686	2686
query60	308	264	255	255
query61	119	138	127	127
query62	758	794	682	682
query63	229	193	193	193
query64	1521	1026	664	664
query65	3293	3092	3137	3092
query66	713	412	306	306
query67	15747	15398	15319	15319
query68	2754	786	539	539
query69	436	298	262	262
query70	1168	1085	1055	1055
query71	324	287	269	269
query72	6215	3583	3757	3583
query73	629	746	347	347
query74	9034	9200	8907	8907
query75	3097	3235	2707	2707
query76	1645	1166	740	740
query77	380	357	315	315
query78	9966	10171	9339	9339
query79	1176	800	575	575
query80	1032	518	468	468
query81	515	274	236	236
query82	825	125	94	94
query83	225	168	147	147
query84	285	94	69	69
query85	790	352	297	297
query86	393	293	286	286
query87	4490	4368	4481	4368
query88	2818	2200	2154	2154
query89	375	326	288	288
query90	1701	191	193	191
query91	131	138	108	108
query92	64	60	56	56
query93	1293	1020	581	581
query94	648	397	307	307
query95	356	272	255	255
query96	488	545	270	270
query97	2786	2788	2718	2718
query98	219	211	205	205
query99	1292	1398	1298	1298
Total cold run time: 282785 ms
Total hot run time: 189301 ms

@doris-robot
Copy link

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

query1	0.04	0.05	0.03
query2	0.08	0.03	0.03
query3	0.24	0.06	0.07
query4	1.62	0.10	0.10
query5	0.40	0.42	0.39
query6	1.19	0.66	0.66
query7	0.02	0.01	0.01
query8	0.04	0.03	0.02
query9	0.58	0.51	0.54
query10	0.56	0.58	0.58
query11	0.15	0.11	0.11
query12	0.14	0.11	0.12
query13	0.61	0.60	0.61
query14	2.78	2.69	2.71
query15	0.92	0.85	0.84
query16	0.39	0.38	0.37
query17	1.02	1.03	1.04
query18	0.22	0.21	0.20
query19	1.93	1.80	2.01
query20	0.02	0.02	0.01
query21	15.36	0.90	0.54
query22	0.74	0.98	0.60
query23	15.18	1.40	0.65
query24	11.58	1.06	0.40
query25	0.30	0.14	0.11
query26	0.93	0.19	0.13
query27	0.05	0.05	0.04
query28	6.17	0.78	0.43
query29	12.64	3.92	3.28
query30	0.25	0.09	0.06
query31	2.84	0.58	0.39
query32	3.22	0.55	0.47
query33	2.98	2.99	3.15
query34	15.86	5.04	4.50
query35	4.54	4.55	4.52
query36	0.66	0.49	0.50
query37	0.09	0.06	0.07
query38	0.05	0.05	0.04
query39	0.03	0.03	0.02
query40	0.17	0.14	0.13
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: 106.74 s
Total hot run time: 30.06 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 43.03% (11325/26318)
Line Coverage: 32.94% (95073/288619)
Region Coverage: 32.07% (48704/151850)
Branch Coverage: 27.93% (24570/87960)
Coverage Report: http://coverage.selectdb-in.cc/coverage/a3c042a1c1a6add5f8bf306df6df7df8ff99727b_a3c042a1c1a6add5f8bf306df6df7df8ff99727b/report/index.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
3 participants
@Gabriel39 @hello-stephen @doris-robot