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

Support for global dictionary functions. #45536

Draft
wants to merge 6 commits into
base: master
Choose a base branch
from
Draft

Support for global dictionary functions. #45536

wants to merge 6 commits into from

Conversation

Mryange
Copy link
Contributor

@Mryange Mryange commented Dec 17, 2024

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?

@Mryange
Copy link
Contributor Author

Mryange commented Dec 17, 2024

run buildall

@github-actions GitHub Actions
Copy link
Contributor

clang-tidy review says "All clean, LGTM! 👍"

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.82% (10131/26096)
Line Coverage: 29.76% (85174/286222)
Region Coverage: 28.80% (43662/151587)
Branch Coverage: 25.35% (22177/87498)
Coverage Report: http://coverage.selectdb-in.cc/coverage/4a9bcd5a4a5b78e59c1103b61fc98ea27b4a28a9_4a9bcd5a4a5b78e59c1103b61fc98ea27b4a28a9/report/index.html

@Mryange
Copy link
Contributor Author

Mryange commented Dec 17, 2024

run buildall

@github-actions GitHub Actions
Copy link
Contributor

clang-tidy review says "All clean, LGTM! 👍"

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.83% (10134/26098)
Line Coverage: 29.74% (85136/286249)
Region Coverage: 28.80% (43660/151600)
Branch Coverage: 25.34% (22176/87508)
Coverage Report: http://coverage.selectdb-in.cc/coverage/ac46b0c32ad044fc265d48f1b41373eed743037b_ac46b0c32ad044fc265d48f1b41373eed743037b/report/index.html

@Mryange Mryange force-pushed the doris-dictionary-hashmap branch from ac46b0c to 6af8679 Compare December 18, 2024 03:49
@Mryange
Copy link
Contributor Author

Mryange commented Dec 18, 2024

run buildall

@github-actions GitHub Actions
Copy link
Contributor

clang-tidy review says "All clean, LGTM! 👍"

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.84% (10135/26097)
Line Coverage: 29.75% (85151/286238)
Region Coverage: 28.81% (43677/151592)
Branch Coverage: 25.35% (22178/87500)
Coverage Report: http://coverage.selectdb-in.cc/coverage/6af86799c2ce615e62b5f704afffcd515ff18a80_6af86799c2ce615e62b5f704afffcd515ff18a80/report/index.html

@Mryange Mryange force-pushed the doris-dictionary-hashmap branch from 6af8679 to b3f78c7 Compare December 23, 2024 11:42
@Mryange
Copy link
Contributor Author

Mryange commented Dec 23, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17601	7611	7273	7273
q2	2062	183	171	171
q3	10636	1103	1194	1103
q4	10509	772	830	772
q5	7628	2737	2715	2715
q6	244	145	144	144
q7	982	629	600	600
q8	9247	1902	1971	1902
q9	6724	6496	6463	6463
q10	7019	2303	2326	2303
q11	471	265	266	265
q12	429	219	217	217
q13	17789	2984	2916	2916
q14	248	215	216	215
q15	557	503	503	503
q16	642	589	590	589
q17	1001	536	589	536
q18	7326	6830	6595	6595
q19	1329	1076	1071	1071
q20	468	190	185	185
q21	4042	3271	3337	3271
q22	370	326	305	305
Total cold run time: 107324 ms
Total hot run time: 40114 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7295	7239	7230	7230
q2	331	234	233	233
q3	2958	2871	2981	2871
q4	2080	1799	1832	1799
q5	5629	5700	5632	5632
q6	230	143	146	143
q7	2217	1844	1798	1798
q8	3397	3585	3561	3561
q9	8978	9057	9050	9050
q10	3614	3531	3527	3527
q11	622	506	506	506
q12	851	654	594	594
q13	12676	3179	3130	3130
q14	315	275	279	275
q15	569	514	501	501
q16	690	642	658	642
q17	1858	1614	1616	1614
q18	8435	7783	7718	7718
q19	1750	1493	1586	1493
q20	2112	1897	1871	1871
q21	5519	5472	5541	5472
q22	648	588	595	588
Total cold run time: 72774 ms
Total hot run time: 60248 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.74% (10097/26066)
Line Coverage: 29.72% (85166/286517)
Region Coverage: 28.86% (43464/150601)
Branch Coverage: 25.40% (22156/87226)
Coverage Report: http://coverage.selectdb-in.cc/coverage/b3f78c792dcaf4117d45e85aa9e3fe8e2bf4bbf6_b3f78c792dcaf4117d45e85aa9e3fe8e2bf4bbf6/report/index.html

@doris-robot
Copy link

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

query1	1314	976	906	906
query2	6254	2509	2384	2384
query3	11129	4742	4650	4650
query4	33263	23359	23468	23359
query5	4226	473	489	473
query6	293	193	185	185
query7	3999	315	310	310
query8	302	227	242	227
query9	9523	2769	2776	2769
query10	439	247	248	247
query11	17854	15022	15100	15022
query12	154	106	100	100
query13	1577	433	410	410
query14	8882	7146	6859	6859
query15	250	233	206	206
query16	7332	486	462	462
query17	1556	601	595	595
query18	1216	306	318	306
query19	216	154	156	154
query20	126	109	113	109
query21	216	111	116	111
query22	4894	4526	4532	4526
query23	35097	33863	33751	33751
query24	11156	2599	2539	2539
query25	600	392	408	392
query26	708	153	153	153
query27	2803	339	335	335
query28	6943	2527	2496	2496
query29	714	452	468	452
query30	234	153	157	153
query31	1055	866	835	835
query32	96	58	61	58
query33	683	314	328	314
query34	949	560	532	532
query35	918	778	755	755
query36	1151	979	962	962
query37	124	86	80	80
query38	4365	4387	4165	4165
query39	1531	1485	1494	1485
query40	214	111	106	106
query41	50	49	46	46
query42	127	109	113	109
query43	540	493	513	493
query44	1245	853	832	832
query45	186	183	170	170
query46	1197	722	757	722
query47	2095	1946	1977	1946
query48	424	340	335	335
query49	908	383	385	383
query50	839	395	399	395
query51	7274	7070	7212	7070
query52	102	97	94	94
query53	271	185	185	185
query54	1040	471	424	424
query55	84	77	83	77
query56	276	255	264	255
query57	1293	1212	1176	1176
query58	261	213	226	213
query59	3272	3192	3262	3192
query60	286	253	253	253
query61	108	102	145	102
query62	851	702	695	695
query63	217	194	192	192
query64	3670	733	660	660
query65	3297	3225	3264	3225
query66	708	321	315	315
query67	16609	15633	15466	15466
query68	7433	560	566	560
query69	493	246	267	246
query70	1223	1082	1138	1082
query71	506	252	257	252
query72	6947	4091	4026	4026
query73	805	370	368	368
query74	10040	8816	8880	8816
query75	3838	2637	2674	2637
query76	4629	1010	1054	1010
query77	675	280	279	279
query78	10560	9495	9320	9320
query79	1115	599	591	591
query80	697	427	419	419
query81	512	228	222	222
query82	212	127	121	121
query83	164	146	142	142
query84	290	69	73	69
query85	1030	300	299	299
query86	410	305	294	294
query87	4666	4462	4381	4381
query88	4105	2248	2232	2232
query89	441	293	288	288
query90	2233	191	189	189
query91	135	107	106	106
query92	64	51	52	51
query93	2374	557	557	557
query94	1005	285	288	285
query95	349	278	280	278
query96	625	285	294	285
query97	2865	2630	2639	2630
query98	219	198	193	193
query99	1546	1303	1323	1303
Total cold run time: 303792 ms
Total hot run time: 196489 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.08	0.03	0.03
query3	0.25	0.07	0.07
query4	1.60	0.10	0.10
query5	0.43	0.39	0.42
query6	1.18	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.57	0.50	0.50
query10	0.56	0.57	0.55
query11	0.14	0.10	0.10
query12	0.14	0.11	0.10
query13	0.62	0.61	0.60
query14	2.81	2.75	2.86
query15	0.90	0.82	0.82
query16	0.39	0.38	0.40
query17	1.03	1.01	1.04
query18	0.21	0.22	0.21
query19	1.90	1.86	1.96
query20	0.02	0.01	0.01
query21	15.37	0.61	0.58
query22	2.51	2.00	1.59
query23	17.06	0.90	0.81
query24	2.94	1.46	1.39
query25	0.13	0.23	0.10
query26	0.53	0.14	0.13
query27	0.05	0.04	0.04
query28	9.90	1.11	1.08
query29	12.60	3.24	3.21
query30	0.25	0.06	0.06
query31	2.85	0.38	0.38
query32	3.25	0.47	0.46
query33	3.09	3.04	3.13
query34	17.10	4.49	4.51
query35	4.58	4.52	4.55
query36	0.68	0.48	0.48
query37	0.10	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.03
query40	0.17	0.13	0.13
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.32 s
Total hot run time: 32.87 s

@Mryange
Copy link
Contributor Author

Mryange commented Dec 23, 2024

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.73% (10095/26066)
Line Coverage: 29.72% (85160/286523)
Region Coverage: 28.86% (43462/150601)
Branch Coverage: 25.40% (22157/87226)
Coverage Report: http://coverage.selectdb-in.cc/coverage/958f59bcf8c7c45e42ba3afb9d1f9fedecca3287_958f59bcf8c7c45e42ba3afb9d1f9fedecca3287/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17594	7374	7251	7251
q2	2050	175	169	169
q3	10646	1053	1136	1053
q4	10569	751	758	751
q5	7583	2679	2640	2640
q6	236	155	161	155
q7	980	623	624	623
q8	9253	1846	1886	1846
q9	6560	6350	6392	6350
q10	7026	2239	2298	2239
q11	470	268	263	263
q12	424	224	224	224
q13	17783	2944	2951	2944
q14	254	219	216	216
q15	554	498	502	498
q16	665	601	581	581
q17	988	597	564	564
q18	7241	6655	6680	6655
q19	1348	1043	970	970
q20	466	182	189	182
q21	4051	3277	3211	3211
q22	376	314	317	314
Total cold run time: 107117 ms
Total hot run time: 39699 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7333	7266	7309	7266
q2	340	227	235	227
q3	2970	2903	3017	2903
q4	2092	1835	1804	1804
q5	5621	5651	5624	5624
q6	219	149	150	149
q7	2270	1808	1852	1808
q8	3369	3542	3513	3513
q9	8847	8980	8907	8907
q10	3582	3507	3533	3507
q11	596	517	518	517
q12	797	592	619	592
q13	13396	3127	3139	3127
q14	303	270	279	270
q15	556	512	493	493
q16	681	642	656	642
q17	1850	1605	1612	1605
q18	8269	7700	7726	7700
q19	2100	1544	1495	1495
q20	2067	1844	1856	1844
q21	5612	5388	5449	5388
q22	659	611	578	578
Total cold run time: 73529 ms
Total hot run time: 59959 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 196684 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 958f59bcf8c7c45e42ba3afb9d1f9fedecca3287, data reload: false

query1	1313	979	906	906
query2	6256	2411	2467	2411
query3	10938	4813	4580	4580
query4	32956	23369	23312	23312
query5	4365	463	448	448
query6	270	185	186	185
query7	3987	305	301	301
query8	287	243	232	232
query9	9542	2781	2741	2741
query10	475	243	252	243
query11	17898	15210	15278	15210
query12	143	101	104	101
query13	1567	408	399	399
query14	10172	6716	6846	6716
query15	260	199	213	199
query16	8009	479	481	479
query17	1548	605	615	605
query18	2167	337	335	335
query19	229	169	185	169
query20	140	122	117	117
query21	203	109	111	109
query22	4876	4531	4613	4531
query23	34493	33645	34743	33645
query24	10443	2522	2605	2522
query25	647	429	487	429
query26	1255	159	154	154
query27	2550	340	326	326
query28	7749	2518	2495	2495
query29	840	416	417	416
query30	232	164	157	157
query31	1019	821	903	821
query32	97	62	64	62
query33	778	287	293	287
query34	1203	537	556	537
query35	883	781	779	779
query36	1136	957	974	957
query37	146	83	80	80
query38	4339	4152	4188	4152
query39	1497	1482	1470	1470
query40	211	101	103	101
query41	44	46	43	43
query42	126	106	102	102
query43	541	507	501	501
query44	1320	848	843	843
query45	197	169	169	169
query46	1200	739	725	725
query47	2034	1923	1912	1912
query48	424	333	336	333
query49	975	397	383	383
query50	828	401	397	397
query51	7354	7172	7290	7172
query52	104	93	99	93
query53	257	184	188	184
query54	1093	436	428	428
query55	87	81	81	81
query56	268	253	240	240
query57	1262	1198	1160	1160
query58	248	223	219	219
query59	3425	3221	3186	3186
query60	285	261	246	246
query61	111	105	104	104
query62	842	710	688	688
query63	225	224	190	190
query64	4015	703	665	665
query65	3347	3310	3275	3275
query66	740	304	316	304
query67	16454	15562	15672	15562
query68	6130	556	566	556
query69	502	255	248	248
query70	1218	1127	1134	1127
query71	482	248	250	248
query72	7059	4129	4046	4046
query73	800	354	384	354
query74	10096	8803	8874	8803
query75	3845	2662	2645	2645
query76	3983	1115	1096	1096
query77	606	278	277	277
query78	10326	9605	9518	9518
query79	1869	616	617	616
query80	1184	431	427	427
query81	510	256	228	228
query82	523	127	122	122
query83	184	142	146	142
query84	278	76	71	71
query85	1247	311	293	293
query86	407	304	304	304
query87	4449	4302	4474	4302
query88	3669	2236	2222	2222
query89	413	286	292	286
query90	2009	189	193	189
query91	137	113	104	104
query92	71	49	56	49
query93	2801	553	543	543
query94	685	256	286	256
query95	353	259	251	251
query96	617	281	275	275
query97	2872	2667	2694	2667
query98	215	195	197	195
query99	1606	1300	1310	1300
Total cold run time: 306071 ms
Total hot run time: 196684 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.05
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.62	0.10	0.10
query5	0.41	0.42	0.39
query6	1.18	0.66	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.51	0.50
query10	0.56	0.58	0.55
query11	0.15	0.11	0.11
query12	0.14	0.12	0.11
query13	0.61	0.60	0.60
query14	2.69	2.81	2.88
query15	0.91	0.84	0.83
query16	0.39	0.38	0.39
query17	1.00	0.98	1.06
query18	0.23	0.21	0.21
query19	1.83	1.77	1.95
query20	0.02	0.01	0.02
query21	15.36	0.60	0.60
query22	2.50	2.43	1.28
query23	16.86	1.01	0.89
query24	3.44	0.75	1.21
query25	0.24	0.29	0.10
query26	0.31	0.14	0.13
query27	0.05	0.05	0.04
query28	10.85	1.08	1.07
query29	12.60	3.24	3.24
query30	0.25	0.07	0.07
query31	2.87	0.40	0.39
query32	3.22	0.47	0.47
query33	3.20	3.20	3.22
query34	17.16	4.41	4.46
query35	4.44	4.46	4.47
query36	0.68	0.50	0.51
query37	0.10	0.07	0.06
query38	0.05	0.03	0.03
query39	0.03	0.03	0.03
query40	0.16	0.13	0.12
query41	0.07	0.02	0.02
query42	0.04	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 107.24 s
Total hot run time: 32.1 s

@Mryange Mryange force-pushed the doris-dictionary-hashmap branch from 958f59b to 501cf70 Compare December 24, 2024 07:55
@Mryange
Copy link
Contributor Author

Mryange commented Dec 24, 2024

run buildall

@Mryange Mryange force-pushed the doris-dictionary-hashmap branch from 501cf70 to b1f1e96 Compare December 24, 2024 08:04
@Mryange
Copy link
Contributor Author

Mryange commented Dec 24, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17581	7459	7250	7250
q2	2057	176	171	171
q3	10617	1072	1210	1072
q4	10543	708	768	708
q5	7605	2754	2711	2711
q6	245	152	156	152
q7	981	635	625	625
q8	9243	1826	1902	1826
q9	6712	6403	6455	6403
q10	7034	2272	2354	2272
q11	465	269	259	259
q12	445	230	231	230
q13	17797	2955	3042	2955
q14	247	226	231	226
q15	558	506	504	504
q16	669	575	600	575
q17	974	507	553	507
q18	7346	6651	6800	6651
q19	1353	978	903	903
q20	477	194	192	192
q21	4066	3350	3293	3293
q22	376	319	304	304
Total cold run time: 107391 ms
Total hot run time: 39789 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7320	7266	7212	7212
q2	329	224	238	224
q3	2930	2816	2979	2816
q4	2132	1873	1891	1873
q5	5661	5695	5606	5606
q6	234	148	151	148
q7	2276	1871	1832	1832
q8	3437	3547	3512	3512
q9	8805	9023	8980	8980
q10	3646	3615	3583	3583
q11	593	502	499	499
q12	834	625	606	606
q13	11142	3198	3171	3171
q14	304	267	273	267
q15	569	503	505	503
q16	702	648	647	647
q17	1862	1627	1617	1617
q18	8376	7902	7773	7773
q19	3515	1517	1518	1517
q20	2053	1935	1862	1862
q21	5659	5543	5549	5543
q22	671	569	596	569
Total cold run time: 73050 ms
Total hot run time: 60360 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.73% (10097/26067)
Line Coverage: 29.72% (85145/286515)
Region Coverage: 28.87% (43476/150603)
Branch Coverage: 25.40% (22158/87224)
Coverage Report: http://coverage.selectdb-in.cc/coverage/b1f1e9699bd72af34c776fe77d88614a232ac11e_b1f1e9699bd72af34c776fe77d88614a232ac11e/report/index.html

@doris-robot
Copy link

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

query1	1270	982	920	920
query2	6263	2426	2395	2395
query3	11135	4766	4814	4766
query4	32925	23444	23527	23444
query5	4131	465	432	432
query6	281	199	175	175
query7	3993	310	300	300
query8	306	232	238	232
query9	9438	2764	2756	2756
query10	471	253	249	249
query11	17849	15116	15304	15116
query12	154	102	102	102
query13	1561	450	443	443
query14	9366	6889	7094	6889
query15	268	206	189	189
query16	8009	490	439	439
query17	1571	597	573	573
query18	2154	303	309	303
query19	203	162	185	162
query20	130	109	114	109
query21	203	113	111	111
query22	4782	4512	4559	4512
query23	34586	33950	33564	33564
query24	11364	2550	2585	2550
query25	590	391	394	391
query26	720	155	154	154
query27	3097	338	345	338
query28	6711	2519	2546	2519
query29	815	441	460	441
query30	236	155	156	155
query31	1118	877	834	834
query32	102	78	56	56
query33	652	306	296	296
query34	963	524	517	517
query35	920	761	779	761
query36	1126	948	974	948
query37	133	78	79	78
query38	4378	4300	4272	4272
query39	1520	1475	1451	1451
query40	203	105	106	105
query41	47	43	43	43
query42	117	107	100	100
query43	562	517	515	515
query44	1223	837	842	837
query45	202	183	171	171
query46	1183	730	723	723
query47	2040	1990	1929	1929
query48	429	351	336	336
query49	908	398	432	398
query50	854	409	422	409
query51	7407	7098	7141	7098
query52	108	102	93	93
query53	270	191	197	191
query54	1049	439	431	431
query55	88	80	79	79
query56	262	252	263	252
query57	1307	1180	1187	1180
query58	230	212	228	212
query59	3609	3298	3200	3200
query60	292	249	261	249
query61	105	107	106	106
query62	906	749	765	749
query63	221	195	206	195
query64	3736	707	724	707
query65	3318	3341	3285	3285
query66	799	294	318	294
query67	15983	15517	15604	15517
query68	4522	639	576	576
query69	487	265	258	258
query70	1184	1112	1177	1112
query71	420	250	251	250
query72	6642	4120	4057	4057
query73	858	374	365	365
query74	10065	8959	8912	8912
query75	3473	2607	2713	2607
query76	3257	1116	1083	1083
query77	575	286	282	282
query78	10415	9622	9449	9449
query79	1649	620	602	602
query80	812	433	420	420
query81	509	236	232	232
query82	512	124	128	124
query83	191	140	141	140
query84	279	69	84	69
query85	1292	300	310	300
query86	448	301	303	301
query87	4673	4472	4372	4372
query88	4393	2281	2286	2281
query89	441	299	302	299
query90	1988	195	196	195
query91	140	114	105	105
query92	71	59	52	52
query93	2361	574	574	574
query94	857	293	291	291
query95	352	256	252	252
query96	674	289	277	277
query97	2846	2684	2708	2684
query98	214	204	194	194
query99	1725	1456	1434	1434
Total cold run time: 301277 ms
Total hot run time: 197495 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.05
query2	0.08	0.03	0.03
query3	0.23	0.08	0.07
query4	1.61	0.10	0.10
query5	0.41	0.42	0.42
query6	1.14	0.66	0.65
query7	0.02	0.02	0.02
query8	0.05	0.04	0.03
query9	0.57	0.52	0.50
query10	0.56	0.57	0.56
query11	0.15	0.10	0.10
query12	0.13	0.11	0.11
query13	0.61	0.61	0.60
query14	2.73	2.72	2.72
query15	0.89	0.82	0.82
query16	0.40	0.39	0.36
query17	1.06	1.04	1.06
query18	0.22	0.21	0.21
query19	1.98	1.84	1.92
query20	0.01	0.01	0.01
query21	15.37	0.58	0.57
query22	2.27	2.20	2.03
query23	17.00	0.96	0.92
query24	3.03	0.83	0.86
query25	0.23	0.05	0.12
query26	0.44	0.14	0.14
query27	0.06	0.04	0.04
query28	11.18	1.09	1.07
query29	12.54	3.27	3.26
query30	0.24	0.06	0.06
query31	2.84	0.38	0.37
query32	3.25	0.47	0.46
query33	3.12	3.08	3.24
query34	17.16	4.47	4.51
query35	4.57	4.52	4.50
query36	0.66	0.48	0.47
query37	0.09	0.06	0.06
query38	0.04	0.04	0.03
query39	0.04	0.03	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.04	0.03	0.03
Total cold run time: 107.33 s
Total hot run time: 32.84 s

@Mryange
Copy link
Contributor Author

Mryange commented Dec 24, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17597	6074	6043	6043
q2	2069	304	162	162
q3	10411	1280	755	755
q4	10203	868	428	428
q5	7525	2215	2046	2046
q6	205	182	144	144
q7	901	757	602	602
q8	9241	1409	1181	1181
q9	5264	4948	4906	4906
q10	6769	2338	1870	1870
q11	470	274	249	249
q12	353	359	226	226
q13	17753	3562	2988	2988
q14	228	241	218	218
q15	568	521	509	509
q16	639	642	596	596
q17	567	853	327	327
q18	7293	6591	6514	6514
q19	2032	968	560	560
q20	295	305	186	186
q21	3073	2163	1995	1995
q22	361	344	304	304
Total cold run time: 103817 ms
Total hot run time: 32809 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6287	6214	6193	6193
q2	230	321	227	227
q3	2285	2715	2287	2287
q4	1420	1820	1386	1386
q5	4342	4767	4930	4767
q6	190	179	141	141
q7	2085	1991	1831	1831
q8	2638	2833	2697	2697
q9	7364	7289	7385	7289
q10	3114	3346	2732	2732
q11	572	524	498	498
q12	689	792	637	637
q13	3374	3727	3108	3108
q14	289	313	307	307
q15	589	512	501	501
q16	645	673	654	654
q17	1257	1726	1263	1263
q18	7745	7368	7357	7357
q19	814	1150	1095	1095
q20	2009	2079	1911	1911
q21	5690	5289	4945	4945
q22	637	612	543	543
Total cold run time: 54265 ms
Total hot run time: 52369 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.73% (10098/26070)
Line Coverage: 29.72% (85173/286609)
Region Coverage: 28.87% (43497/150643)
Branch Coverage: 25.41% (22172/87254)
Coverage Report: http://coverage.selectdb-in.cc/coverage/9152c40ab568d847643018fccf3921b26dc3025a_9152c40ab568d847643018fccf3921b26dc3025a/report/index.html

@doris-robot
Copy link

TPC-DS: Total hot run time: 197025 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 9152c40ab568d847643018fccf3921b26dc3025a, data reload: false

query1	1301	1000	923	923
query2	6482	2572	2392	2392
query3	10975	4748	4745	4745
query4	32676	23624	23345	23345
query5	3878	583	440	440
query6	271	192	179	179
query7	3985	492	298	298
query8	291	247	248	247
query9	9234	2738	2704	2704
query10	440	289	254	254
query11	17839	15498	15430	15430
query12	156	107	98	98
query13	1573	551	398	398
query14	10234	7151	7119	7119
query15	248	209	206	206
query16	7953	625	461	461
query17	1577	733	571	571
query18	2074	404	317	317
query19	208	183	171	171
query20	125	118	109	109
query21	211	124	104	104
query22	4786	4634	4300	4300
query23	34499	33963	33788	33788
query24	6534	2417	2298	2298
query25	478	481	391	391
query26	792	276	148	148
query27	2037	464	343	343
query28	5435	2488	2467	2467
query29	611	587	443	443
query30	213	192	158	158
query31	1032	915	859	859
query32	73	60	62	60
query33	501	386	294	294
query34	772	854	518	518
query35	809	842	785	785
query36	1014	1057	972	972
query37	110	97	73	73
query38	4184	4318	4136	4136
query39	1509	1528	1459	1459
query40	211	112	102	102
query41	46	46	46	46
query42	146	103	105	103
query43	533	546	511	511
query44	1388	821	812	812
query45	189	178	166	166
query46	888	1054	653	653
query47	2049	2039	2010	2010
query48	387	403	333	333
query49	726	472	404	404
query50	624	682	417	417
query51	7174	7303	7170	7170
query52	105	98	87	87
query53	226	256	184	184
query54	494	532	419	419
query55	91	85	79	79
query56	282	284	263	263
query57	1260	1229	1185	1185
query58	262	235	236	235
query59	3387	3273	3294	3273
query60	288	293	264	264
query61	146	104	107	104
query62	875	824	769	769
query63	219	188	204	188
query64	3092	1030	666	666
query65	3382	3303	3269	3269
query66	962	411	300	300
query67	16646	15737	15501	15501
query68	9208	756	516	516
query69	477	288	250	250
query70	1199	1152	1117	1117
query71	431	282	262	262
query72	6291	3861	3925	3861
query73	652	746	356	356
query74	10412	9175	8973	8973
query75	4579	3153	2682	2682
query76	5275	1176	797	797
query77	974	367	274	274
query78	11028	10216	9290	9290
query79	3033	842	595	595
query80	713	510	423	423
query81	488	263	223	223
query82	319	148	118	118
query83	196	169	152	152
query84	273	89	68	68
query85	742	465	309	309
query86	357	307	304	304
query87	4605	4616	4380	4380
query88	3321	2261	2242	2242
query89	423	318	293	293
query90	2044	189	190	189
query91	132	135	105	105
query92	61	56	53	53
query93	995	714	529	529
query94	663	410	290	290
query95	333	266	249	249
query96	477	599	277	277
query97	2734	2811	2681	2681
query98	218	197	190	190
query99	1691	1550	1461	1461
Total cold run time: 297542 ms
Total hot run time: 197025 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.09	0.04	0.04
query3	0.23	0.06	0.06
query4	1.66	0.09	0.09
query5	0.43	0.41	0.39
query6	1.13	0.68	0.68
query7	0.03	0.02	0.01
query8	0.05	0.05	0.04
query9	0.55	0.49	0.52
query10	0.55	0.58	0.56
query11	0.17	0.12	0.12
query12	0.15	0.12	0.13
query13	0.61	0.60	0.59
query14	2.73	2.84	2.74
query15	0.92	0.84	0.84
query16	0.38	0.37	0.38
query17	1.08	1.06	1.06
query18	0.19	0.19	0.20
query19	1.84	1.79	2.04
query20	0.02	0.02	0.01
query21	15.40	0.97	0.66
query22	0.77	0.79	0.71
query23	14.90	1.45	0.67
query24	2.24	0.38	0.23
query25	0.15	0.09	0.09
query26	0.28	0.19	0.18
query27	0.08	0.08	0.08
query28	13.46	1.78	1.14
query29	12.60	4.17	3.46
query30	0.26	0.07	0.06
query31	2.85	0.60	0.41
query32	3.23	0.59	0.49
query33	3.14	3.16	3.18
query34	16.71	5.13	4.52
query35	4.51	4.51	4.55
query36	0.63	0.49	0.51
query37	0.19	0.16	0.15
query38	0.15	0.15	0.16
query39	0.06	0.04	0.04
query40	0.16	0.14	0.13
query41	0.10	0.07	0.05
query42	0.07	0.06	0.05
query43	0.05	0.05	0.05
Total cold run time: 104.83 s
Total hot run time: 31.7 s

@Mryange Mryange force-pushed the doris-dictionary-hashmap branch from 9152c40 to 8861fd6 Compare December 25, 2024 08:29
@Mryange
Copy link
Contributor Author

Mryange commented Dec 25, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17577	6168	6039	6039
q2	2054	310	168	168
q3	10490	1287	727	727
q4	10216	874	428	428
q5	7633	2193	2004	2004
q6	202	176	144	144
q7	918	1375	621	621
q8	9243	1377	1154	1154
q9	5302	4881	4930	4881
q10	6751	2275	1877	1877
q11	479	274	255	255
q12	355	353	214	214
q13	17768	3638	3004	3004
q14	226	248	216	216
q15	573	515	496	496
q16	634	615	603	603
q17	572	858	320	320
q18	7383	6421	6487	6421
q19	2664	975	560	560
q20	300	313	178	178
q21	2817	2210	1963	1963
q22	367	336	321	321
Total cold run time: 104524 ms
Total hot run time: 32594 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6286	6210	6209	6209
q2	238	323	230	230
q3	2278	2649	2333	2333
q4	1475	1837	1384	1384
q5	4407	4754	4719	4719
q6	173	170	142	142
q7	2016	1844	1754	1754
q8	2531	2707	2616	2616
q9	6998	6883	6890	6883
q10	2960	3198	2709	2709
q11	587	540	486	486
q12	641	720	581	581
q13	3261	3609	3042	3042
q14	273	283	275	275
q15	572	511	502	502
q16	649	665	662	662
q17	1177	1681	1221	1221
q18	7349	7185	7091	7091
q19	811	1153	1045	1045
q20	1944	1949	1789	1789
q21	5426	5081	4857	4857
q22	609	626	586	586
Total cold run time: 52661 ms
Total hot run time: 51116 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 189843 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 95ffe104487b7eb58b6276b11757348cf8aa2418, data reload: false

query1	996	377	365	365
query2	6539	2323	2367	2323
query3	6710	207	210	207
query4	33911	23525	23561	23525
query5	4326	611	462	462
query6	289	191	181	181
query7	4627	499	304	304
query8	307	250	236	236
query9	9723	2771	2758	2758
query10	465	322	251	251
query11	18355	15350	15116	15116
query12	156	111	108	108
query13	1663	537	410	410
query14	11974	7279	7780	7279
query15	257	195	187	187
query16	8753	657	462	462
query17	1645	766	565	565
query18	2148	426	282	282
query19	228	184	155	155
query20	112	110	110	110
query21	207	117	125	117
query22	4303	4342	4207	4207
query23	35080	33314	33248	33248
query24	6127	2229	2292	2229
query25	492	441	382	382
query26	1195	270	152	152
query27	2014	469	326	326
query28	5255	2487	2482	2482
query29	758	539	415	415
query30	228	178	154	154
query31	981	908	841	841
query32	90	57	55	55
query33	504	339	288	288
query34	759	848	513	513
query35	823	800	743	743
query36	1039	1064	968	968
query37	120	104	85	85
query38	4299	4072	4232	4072
query39	1488	1465	1589	1465
query40	202	113	100	100
query41	52	43	44	43
query42	114	100	97	97
query43	518	514	500	500
query44	1277	811	802	802
query45	186	171	166	166
query46	867	1034	635	635
query47	1871	1886	1837	1837
query48	379	415	326	326
query49	764	489	372	372
query50	626	650	374	374
query51	7303	7056	6878	6878
query52	102	101	90	90
query53	224	253	184	184
query54	486	482	404	404
query55	82	79	78	78
query56	249	255	238	238
query57	1178	1169	1097	1097
query58	241	227	224	224
query59	2978	3012	3019	3012
query60	267	274	248	248
query61	109	116	107	107
query62	880	811	723	723
query63	223	187	190	187
query64	4250	1003	637	637
query65	3306	3191	3273	3191
query66	896	430	304	304
query67	15889	15782	15432	15432
query68	9174	763	581	581
query69	453	295	249	249
query70	1248	1167	1149	1149
query71	431	273	249	249
query72	5886	3765	3872	3765
query73	684	774	365	365
query74	9830	9170	8837	8837
query75	4678	3133	2671	2671
query76	5411	1173	776	776
query77	955	383	268	268
query78	10048	10267	9384	9384
query79	4950	879	575	575
query80	728	558	441	441
query81	489	282	226	226
query82	331	151	123	123
query83	197	166	154	154
query84	283	86	71	71
query85	746	361	303	303
query86	358	289	287	287
query87	4479	4573	4647	4573
query88	3756	2225	2198	2198
query89	436	340	306	306
query90	2126	193	187	187
query91	135	130	108	108
query92	71	56	50	50
query93	2872	875	527	527
query94	681	393	285	285
query95	327	271	262	262
query96	495	609	281	281
query97	2670	2850	2645	2645
query98	219	203	197	197
query99	1671	1541	1436	1436
Total cold run time: 301283 ms
Total hot run time: 189843 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.82% (10118/26066)
Line Coverage: 29.82% (85464/286622)
Region Coverage: 28.95% (43612/150649)
Branch Coverage: 25.49% (22239/87244)
Coverage Report: http://coverage.selectdb-in.cc/coverage/95ffe104487b7eb58b6276b11757348cf8aa2418_95ffe104487b7eb58b6276b11757348cf8aa2418/report/index.html

@doris-robot
Copy link

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

query1	0.04	0.03	0.02
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.61	0.11	0.11
query5	0.44	0.39	0.42
query6	1.17	0.64	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.56	0.48	0.52
query10	0.54	0.57	0.56
query11	0.14	0.10	0.10
query12	0.14	0.11	0.10
query13	0.60	0.60	0.58
query14	2.72	2.82	2.81
query15	0.88	0.82	0.82
query16	0.38	0.39	0.37
query17	0.99	1.02	1.06
query18	0.23	0.21	0.20
query19	1.97	1.90	2.00
query20	0.01	0.02	0.01
query21	15.37	0.91	0.58
query22	0.76	0.78	0.66
query23	15.29	1.35	0.59
query24	3.02	0.77	1.44
query25	0.14	0.26	0.16
query26	0.29	0.15	0.13
query27	0.06	0.06	0.05
query28	14.28	1.53	1.04
query29	12.57	3.95	3.26
query30	0.25	0.09	0.07
query31	2.81	0.59	0.38
query32	3.22	0.54	0.46
query33	3.09	3.05	3.03
query34	16.72	5.14	4.54
query35	4.51	4.54	4.47
query36	0.66	0.51	0.47
query37	0.09	0.06	0.06
query38	0.04	0.04	0.03
query39	0.03	0.02	0.03
query40	0.18	0.13	0.12
query41	0.07	0.03	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.31 s
Total hot run time: 31.22 s

@Mryange
Copy link
Contributor Author

Mryange commented Dec 25, 2024

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.81% (10116/26066)
Line Coverage: 29.81% (85445/286615)
Region Coverage: 28.95% (43607/150648)
Branch Coverage: 25.49% (22236/87244)
Coverage Report: http://coverage.selectdb-in.cc/coverage/5b98ebd17802e9f0e22cfa1a77101e6b9c3e43e7_5b98ebd17802e9f0e22cfa1a77101e6b9c3e43e7/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17782	6173	6264	6173
q2	2048	315	172	172
q3	10623	1270	756	756
q4	10294	899	453	453
q5	9010	2239	2084	2084
q6	221	182	145	145
q7	931	770	605	605
q8	9242	1487	1304	1304
q9	5337	4974	5091	4974
q10	6794	2338	1853	1853
q11	475	287	260	260
q12	357	389	225	225
q13	17787	3677	2967	2967
q14	247	232	217	217
q15	555	505	510	505
q16	656	607	577	577
q17	586	899	343	343
q18	7060	6571	6492	6492
q19	1944	1055	608	608
q20	317	338	189	189
q21	2944	2273	2026	2026
q22	377	338	309	309
Total cold run time: 105587 ms
Total hot run time: 33237 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6495	6450	6495	6450
q2	252	329	233	233
q3	2237	2677	2339	2339
q4	1427	1847	1387	1387
q5	4368	4865	5013	4865
q6	208	177	145	145
q7	2069	2032	1840	1840
q8	2705	2888	2790	2790
q9	7353	7339	7402	7339
q10	3116	3245	2750	2750
q11	606	531	516	516
q12	684	776	614	614
q13	3485	3822	3154	3154
q14	293	306	289	289
q15	572	518	494	494
q16	648	697	641	641
q17	1268	1738	1264	1264
q18	7833	7429	7288	7288
q19	941	1268	1240	1240
q20	2035	2060	1842	1842
q21	5803	5280	5129	5129
q22	631	638	574	574
Total cold run time: 55029 ms
Total hot run time: 53183 ms

@doris-robot
Copy link

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

query1	1284	945	958	945
query2	6496	2375	2285	2285
query3	11123	4774	4892	4774
query4	33181	23904	23499	23499
query5	3837	617	453	453
query6	287	206	200	200
query7	4001	502	303	303
query8	307	256	239	239
query9	9279	2782	2769	2769
query10	460	315	256	256
query11	17995	15628	15127	15127
query12	168	110	107	107
query13	1593	565	434	434
query14	10465	7248	7068	7068
query15	254	229	182	182
query16	8020	634	446	446
query17	1591	785	593	593
query18	2128	414	327	327
query19	219	199	169	169
query20	120	118	111	111
query21	210	138	140	138
query22	4660	4622	4579	4579
query23	34277	33619	33479	33479
query24	6479	2443	2331	2331
query25	466	480	384	384
query26	997	281	153	153
query27	2155	484	342	342
query28	5416	2532	2528	2528
query29	613	568	456	456
query30	212	184	155	155
query31	968	932	849	849
query32	76	61	60	60
query33	490	369	305	305
query34	777	879	511	511
query35	818	833	772	772
query36	1030	1037	982	982
query37	118	92	92	92
query38	4191	4266	4147	4147
query39	1520	1522	1472	1472
query40	208	120	106	106
query41	44	43	45	43
query42	118	102	106	102
query43	541	549	518	518
query44	1371	837	843	837
query45	192	171	172	171
query46	902	1069	672	672
query47	1989	2017	1930	1930
query48	388	411	324	324
query49	720	481	404	404
query50	657	671	418	418
query51	7450	7156	7034	7034
query52	107	104	96	96
query53	241	266	193	193
query54	495	505	429	429
query55	83	85	81	81
query56	267	271	237	237
query57	1236	1244	1165	1165
query58	237	222	222	222
query59	3220	3338	3273	3273
query60	275	276	265	265
query61	113	120	114	114
query62	881	827	752	752
query63	226	192	224	192
query64	3362	1021	685	685
query65	3337	3252	3273	3252
query66	826	415	322	322
query67	16688	15625	15392	15392
query68	9861	761	522	522
query69	480	302	247	247
query70	1238	1177	1151	1151
query71	452	288	302	288
query72	6210	3785	3875	3785
query73	1168	762	365	365
query74	10406	9184	9245	9184
query75	4507	3150	2654	2654
query76	5579	1193	772	772
query77	978	371	278	278
query78	10137	10191	9323	9323
query79	2372	901	602	602
query80	729	540	433	433
query81	478	271	235	235
query82	209	150	124	124
query83	194	159	142	142
query84	281	93	73	73
query85	741	361	303	303
query86	362	284	295	284
query87	4664	4487	4391	4391
query88	3769	2251	2237	2237
query89	432	338	295	295
query90	2082	187	190	187
query91	134	133	106	106
query92	68	57	52	52
query93	1990	912	538	538
query94	672	382	295	295
query95	332	265	250	250
query96	497	610	278	278
query97	2721	2807	2668	2668
query98	229	201	205	201
query99	1638	1554	1446	1446
Total cold run time: 300065 ms
Total hot run time: 196960 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.08	0.05	0.04
query3	0.23	0.05	0.06
query4	1.65	0.09	0.08
query5	0.43	0.39	0.42
query6	1.17	0.66	0.65
query7	0.02	0.02	0.03
query8	0.05	0.04	0.05
query9	0.54	0.49	0.50
query10	0.56	0.58	0.56
query11	0.17	0.12	0.12
query12	0.16	0.13	0.12
query13	0.62	0.60	0.59
query14	2.71	2.75	2.86
query15	0.91	0.85	0.84
query16	0.38	0.39	0.38
query17	1.09	1.09	1.08
query18	0.19	0.19	0.20
query19	1.97	1.92	2.07
query20	0.02	0.01	0.01
query21	15.35	0.96	0.66
query22	0.77	0.78	0.69
query23	15.00	1.48	0.66
query24	2.19	0.38	0.22
query25	0.15	0.09	0.09
query26	0.29	0.19	0.18
query27	0.08	0.09	0.09
query28	13.39	1.81	1.14
query29	12.67	4.08	3.42
query30	0.24	0.08	0.06
query31	2.84	0.62	0.40
query32	3.22	0.57	0.47
query33	3.24	3.12	3.12
query34	16.66	5.21	4.54
query35	4.59	4.53	4.65
query36	0.62	0.48	0.49
query37	0.19	0.16	0.15
query38	0.16	0.15	0.16
query39	0.05	0.04	0.04
query40	0.17	0.13	0.12
query41	0.11	0.06	0.06
query42	0.06	0.05	0.06
query43	0.05	0.05	0.05
Total cold run time: 105.08 s
Total hot run time: 31.72 s

@Mryange
Copy link
Contributor Author

Mryange commented Dec 27, 2024

run buildall

1 similar comment
@Mryange
Copy link
Contributor Author

Mryange commented Dec 28, 2024

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.91% (10145/26072)
Line Coverage: 29.92% (85813/286844)
Region Coverage: 29.06% (43822/150815)
Branch Coverage: 25.60% (22362/87366)
Coverage Report: http://coverage.selectdb-in.cc/coverage/52361ffb5ff6ce52f2e9a91bf8b24c4e54e3ace6_52361ffb5ff6ce52f2e9a91bf8b24c4e54e3ace6/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
@Mryange @hello-stephen @doris-robot