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

[refactor]Delete useless code check_set_nullable() #41739

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

[refactor]Delete useless code check_set_nullable() #41739

wants to merge 36 commits into from
+499 −140

Conversation

Yoruet
Copy link
Contributor

@Yoruet Yoruet commented Oct 11, 2024

Proposed changes

Issue Number: close #xxx

Yoruet and others added 23 commits September 24, 2024 20:49
@Yoruet
add regr_intercept and regr_slope aggregate functions
96d4a20
@Yoruet
delete unused files
5882639
@Yoruet
fix bug in regr_slope and regr_intercept
7d3d24e
@Yoruet
update RegrSlope and RegrIntercept to be nullable
5bc299e
@Yoruet
change the implementation of RegrSlope and RegrIntercept
19829a7
@Yoruet
update the be of regr_slope and regr_intercept
875fb28
@Yoruet
Modification details
4207554
@Yoruet
fix bug in be of regr_slope and regr_intercept
2a35625
@zhiqiang-hhhh
X
64711ad
@zhiqiang-hhhh
Merge branch 'master' of https://github.com/yoruet/doris into pr/Yoru…
86ed7a3 
…et/41240
@Yoruet
update doris-cluster.conf
567f5e3
@Yoruet
Merge branch 'zhiqiang-hhhh-regr_intercept' and change other files
2ca9f40
@Yoruet
Code Formatter / Clang Formatter
40b3f80
@Yoruet
fix fe of regr_slope and add test_regr_slope.groovy
13d4676
@Yoruet
union regr_slope and regr_intercept to regr_union
29f6e52
@Yoruet
using sub class in regr_slope and regr_intercept
43c58df
@Yoruet
code format
9b85156
@Yoruet
Move get_slope method to parent class
72c33e2
@Yoruet
code format
68d8d74
@Yoruet
refactor: delete useless code check_set_nullable
4c0fbd0
@Yoruet
Merge branch 'apache:master' into master
507b2ae
@Yoruet
update
0534a2e
@Yoruet
Merge branch 'temp'
4c3d0d1
@doris-robot
Copy link

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website.
See Doris Document.

@github-actions GitHub Actions
Copy link
Contributor

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

@github-actions GitHub Actions
Copy link
Contributor

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

@doris-robot
Copy link

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

query1	0.04	0.03	0.02
query2	0.06	0.03	0.02
query3	0.23	0.06	0.06
query4	1.63	0.10	0.10
query5	0.52	0.52	0.51
query6	1.13	0.73	0.73
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.55	0.49	0.49
query10	0.55	0.54	0.54
query11	0.14	0.12	0.11
query12	0.14	0.11	0.11
query13	0.61	0.60	0.61
query14	2.82	2.73	2.73
query15	0.89	0.82	0.82
query16	0.37	0.38	0.37
query17	1.05	1.06	1.01
query18	0.20	0.20	0.20
query19	1.97	1.88	2.01
query20	0.01	0.01	0.01
query21	15.37	0.58	0.59
query22	2.96	1.93	2.81
query23	16.99	0.91	0.85
query24	3.23	0.79	1.88
query25	0.30	0.20	0.04
query26	0.48	0.13	0.15
query27	0.05	0.04	0.03
query28	10.10	1.09	1.09
query29	12.58	3.16	3.18
query30	0.26	0.06	0.05
query31	2.87	0.38	0.37
query32	3.27	0.47	0.46
query33	2.95	3.01	3.10
query34	16.88	4.49	4.43
query35	4.49	4.50	4.57
query36	0.67	0.49	0.48
query37	0.09	0.06	0.05
query38	0.04	0.03	0.03
query39	0.03	0.02	0.02
query40	0.15	0.12	0.12
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.02	0.03
Total cold run time: 106.88 s
Total hot run time: 32.54 s

@github-actions GitHub Actions
Copy link
Contributor

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

@Yoruet
Copy link
Contributor Author

Yoruet commented Oct 13, 2024

run buildall

@github-actions GitHub Actions
Copy link
Contributor

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

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17568	7408	7225	7225
q2	2028	280	275	275
q3	12094	1037	1146	1037
q4	10591	714	714	714
q5	7739	2869	2852	2852
q6	238	152	153	152
q7	994	624	604	604
q8	9357	1880	1961	1880
q9	6486	6383	6373	6373
q10	6958	2306	2332	2306
q11	429	249	245	245
q12	423	229	224	224
q13	17790	2983	2983	2983
q14	238	211	215	211
q15	569	520	519	519
q16	649	582	563	563
q17	975	479	591	479
q18	7201	6648	6789	6648
q19	1350	1005	901	901
q20	488	198	204	198
q21	4012	3299	3315	3299
q22	1081	988	990	988
Total cold run time: 109258 ms
Total hot run time: 40676 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7282	7340	7256	7256
q2	335	229	234	229
q3	2970	2940	3024	2940
q4	2042	1826	1785	1785
q5	5779	5737	5739	5737
q6	242	147	144	144
q7	2239	1881	1816	1816
q8	3362	3578	3467	3467
q9	8908	8859	8875	8859
q10	3582	3564	3517	3517
q11	590	494	498	494
q12	884	637	614	614
q13	10114	3224	3181	3181
q14	316	275	283	275
q15	586	529	524	524
q16	698	693	654	654
q17	1835	1611	1578	1578
q18	8234	7807	7444	7444
q19	1741	1518	1503	1503
q20	2124	1874	1904	1874
q21	5585	5448	5500	5448
q22	1102	1050	1039	1039
Total cold run time: 70550 ms
Total hot run time: 60378 ms

@doris-robot
Copy link

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

query1	936	398	398	398
query2	6245	2084	2115	2084
query3	8694	198	204	198
query4	33923	23527	23442	23442
query5	3521	491	484	484
query6	257	160	158	158
query7	4185	320	301	301
query8	289	230	223	223
query9	9267	2652	2624	2624
query10	474	281	271	271
query11	17705	15119	15420	15119
query12	153	102	94	94
query13	1582	460	440	440
query14	9110	7463	7229	7229
query15	256	167	173	167
query16	7854	457	462	457
query17	1653	644	603	603
query18	2046	335	318	318
query19	380	155	155	155
query20	119	115	107	107
query21	215	105	105	105
query22	4718	4424	4416	4416
query23	36171	34513	34103	34103
query24	11071	2884	2852	2852
query25	529	425	419	419
query26	721	155	171	155
query27	2411	301	303	301
query28	7445	2396	2377	2377
query29	656	450	434	434
query30	269	158	157	157
query31	1062	819	790	790
query32	91	56	55	55
query33	758	289	305	289
query34	894	512	504	504
query35	929	745	724	724
query36	1072	943	949	943
query37	141	83	92	83
query38	3958	4026	3809	3809
query39	1473	1433	1415	1415
query40	215	99	96	96
query41	48	44	48	44
query42	120	100	102	100
query43	542	499	488	488
query44	1264	817	811	811
query45	199	165	167	165
query46	1159	727	712	712
query47	1942	1798	1870	1798
query48	445	358	333	333
query49	920	417	415	415
query50	837	416	432	416
query51	7029	6803	7038	6803
query52	98	90	89	89
query53	258	181	182	181
query54	1198	477	497	477
query55	82	77	76	76
query56	292	278	273	273
query57	1274	1154	1156	1154
query58	303	247	267	247
query59	3155	2952	2934	2934
query60	306	265	272	265
query61	105	102	97	97
query62	849	663	669	663
query63	228	195	186	186
query64	3919	633	611	611
query65	3246	3203	3201	3201
query66	832	304	314	304
query67	15791	15699	15650	15650
query68	4336	584	557	557
query69	531	305	304	304
query70	1164	1118	1149	1118
query71	356	292	282	282
query72	7201	3912	3910	3910
query73	769	358	347	347
query74	10188	8943	9031	8943
query75	3506	2688	2684	2684
query76	3057	973	902	902
query77	620	285	305	285
query78	10391	9621	9562	9562
query79	1524	596	608	596
query80	1125	463	468	463
query81	562	241	245	241
query82	744	141	136	136
query83	301	134	129	129
query84	278	70	81	70
query85	1393	299	282	282
query86	407	301	297	297
query87	4542	4318	4367	4318
query88	3548	2385	2367	2367
query89	406	289	288	288
query90	1885	186	184	184
query91	153	104	103	103
query92	62	48	49	48
query93	1091	547	536	536
query94	992	263	290	263
query95	356	247	254	247
query96	611	273	284	273
query97	3239	3109	3125	3109
query98	210	194	190	190
query99	1663	1295	1286	1286
Total cold run time: 297100 ms
Total hot run time: 191712 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 32.33 s 
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit dd70803f8035f7204c86f05a867bba9d02fcda30, 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.64	0.10	0.10
query5	0.51	0.49	0.51
query6	1.13	0.73	0.72
query7	0.02	0.01	0.02
query8	0.03	0.03	0.04
query9	0.57	0.51	0.50
query10	0.57	0.56	0.54
query11	0.14	0.11	0.10
query12	0.14	0.10	0.11
query13	0.61	0.59	0.59
query14	2.76	2.70	2.91
query15	0.90	0.83	0.82
query16	0.40	0.38	0.38
query17	1.01	0.98	1.04
query18	0.20	0.20	0.20
query19	1.88	1.87	2.06
query20	0.01	0.01	0.01
query21	15.36	0.60	0.59
query22	3.01	1.79	1.88
query23	17.05	0.93	0.88
query24	2.41	0.75	1.54
query25	0.27	0.09	0.13
query26	0.49	0.15	0.13
query27	0.05	0.04	0.03
query28	10.93	1.10	1.07
query29	12.58	3.20	3.20
query30	0.24	0.06	0.05
query31	2.88	0.38	0.38
query32	3.26	0.47	0.45
query33	2.98	2.95	3.09
query34	16.83	4.43	4.52
query35	4.49	4.52	4.50
query36	0.66	0.49	0.51
query37	0.07	0.06	0.06
query38	0.05	0.03	0.02
query39	0.02	0.02	0.02
query40	0.16	0.13	0.13
query41	0.07	0.02	0.02
query42	0.03	0.02	0.01
query43	0.03	0.03	0.03
Total cold run time: 106.78 s
Total hot run time: 32.33 s

@github-actions GitHub Actions
Copy link
Contributor

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

@Yoruet
Copy link
Contributor Author

Yoruet commented Oct 13, 2024

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 37.41% (9671/25848)
Line Coverage: 28.64% (80141/279843)
Region Coverage: 28.08% (41457/147638)
Branch Coverage: 24.66% (21072/85440)
Coverage Report: http://coverage.selectdb-in.cc/coverage/a48cea8a0d3b50a83afac69a710fc5625018b4e1_a48cea8a0d3b50a83afac69a710fc5625018b4e1/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17571	7648	7245	7245
q2	2028	281	271	271
q3	11961	1093	1219	1093
q4	10574	735	718	718
q5	7739	2863	2820	2820
q6	234	155	149	149
q7	990	633	597	597
q8	9345	1886	1966	1886
q9	6512	6454	6389	6389
q10	6966	2304	2331	2304
q11	432	236	240	236
q12	405	216	215	215
q13	17802	3021	3005	3005
q14	249	215	204	204
q15	551	519	523	519
q16	643	592	589	589
q17	949	495	588	495
q18	7108	6625	6699	6625
q19	1353	934	959	934
q20	484	200	198	198
q21	3957	3177	3109	3109
q22	1092	990	990	990
Total cold run time: 108945 ms
Total hot run time: 40591 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7233	7291	7183	7183
q2	328	232	237	232
q3	2930	2921	2910	2910
q4	2050	1826	1864	1826
q5	5739	5694	5723	5694
q6	228	146	142	142
q7	2261	1875	1852	1852
q8	3348	3527	3489	3489
q9	8928	8943	8843	8843
q10	3583	3536	3526	3526
q11	576	504	501	501
q12	822	668	656	656
q13	8737	3149	3184	3149
q14	303	287	277	277
q15	560	520	530	520
q16	664	655	642	642
q17	1829	1613	1596	1596
q18	8205	7622	7631	7622
q19	1698	1498	1621	1498
q20	2090	1872	1919	1872
q21	5619	5367	5804	5367
q22	1111	1075	1028	1028
Total cold run time: 68842 ms
Total hot run time: 60425 ms

@doris-robot
Copy link

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

query1	946	390	410	390
query2	6238	2084	2104	2084
query3	8684	195	207	195
query4	33702	23474	23428	23428
query5	3370	487	474	474
query6	256	161	161	161
query7	4185	307	313	307
query8	288	228	208	208
query9	9437	2675	2642	2642
query10	426	270	266	266
query11	17785	15145	15138	15138
query12	134	103	94	94
query13	1585	457	458	457
query14	9372	7007	7150	7007
query15	244	169	176	169
query16	7546	473	432	432
query17	1613	568	576	568
query18	2027	318	333	318
query19	232	164	154	154
query20	120	114	113	113
query21	213	108	110	108
query22	4793	4549	4540	4540
query23	35723	34116	33986	33986
query24	11133	2883	2797	2797
query25	601	423	413	413
query26	1124	163	164	163
query27	2567	307	302	302
query28	7570	2434	2418	2418
query29	726	438	422	422
query30	257	156	155	155
query31	1033	796	798	796
query32	100	58	53	53
query33	759	295	293	293
query34	920	496	514	496
query35	879	742	718	718
query36	1127	891	967	891
query37	146	89	86	86
query38	4054	3859	3878	3859
query39	1479	1424	1567	1424
query40	257	98	99	98
query41	46	46	44	44
query42	123	96	94	94
query43	537	499	480	480
query44	1259	808	830	808
query45	194	164	167	164
query46	1124	709	719	709
query47	1909	1825	1847	1825
query48	431	348	351	348
query49	939	417	402	402
query50	815	420	398	398
query51	7029	7035	6996	6996
query52	100	86	89	86
query53	247	181	189	181
query54	1218	483	474	474
query55	80	75	83	75
query56	299	274	263	263
query57	1270	1168	1197	1168
query58	243	250	261	250
query59	3271	3127	2871	2871
query60	280	279	261	261
query61	108	104	105	104
query62	894	674	675	674
query63	208	188	182	182
query64	4592	636	608	608
query65	3234	3178	3220	3178
query66	1352	312	306	306
query67	15945	15509	15733	15509
query68	4437	577	568	568
query69	479	295	296	295
query70	1171	1097	1160	1097
query71	366	263	269	263
query72	7113	3989	3931	3931
query73	772	348	355	348
query74	9812	8999	9009	8999
query75	3403	2683	2666	2666
query76	2863	823	927	823
query77	429	304	298	298
query78	10504	9604	9488	9488
query79	1302	594	600	594
query80	1994	451	458	451
query81	560	240	238	238
query82	756	131	140	131
query83	269	137	131	131
query84	261	73	75	73
query85	1466	302	292	292
query86	383	257	294	257
query87	4469	4296	4375	4296
query88	3188	2410	2344	2344
query89	402	279	297	279
query90	2240	184	184	184
query91	157	115	112	112
query92	61	48	49	48
query93	1073	550	551	550
query94	1143	295	276	276
query95	357	256	250	250
query96	598	277	281	277
query97	3215	3129	3077	3077
query98	217	189	194	189
query99	1634	1323	1309	1309
Total cold run time: 298492 ms
Total hot run time: 191215 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.06	0.03	0.03
query3	0.23	0.06	0.06
query4	1.64	0.10	0.10
query5	0.52	0.52	0.50
query6	1.14	0.72	0.73
query7	0.02	0.01	0.02
query8	0.04	0.03	0.04
query9	0.58	0.51	0.51
query10	0.56	0.55	0.56
query11	0.14	0.11	0.11
query12	0.14	0.12	0.11
query13	0.60	0.60	0.58
query14	2.73	2.72	2.82
query15	0.88	0.82	0.84
query16	0.38	0.38	0.37
query17	1.02	1.04	1.04
query18	0.19	0.19	0.20
query19	1.94	1.80	1.98
query20	0.02	0.01	0.01
query21	15.37	0.60	0.61
query22	2.26	2.81	2.03
query23	16.99	1.06	0.72
query24	3.03	0.58	1.07
query25	0.30	0.11	0.12
query26	0.37	0.14	0.13
query27	0.04	0.04	0.04
query28	11.04	1.09	1.06
query29	12.58	3.16	3.16
query30	0.25	0.05	0.06
query31	2.87	0.37	0.38
query32	3.30	0.46	0.45
query33	3.03	2.98	3.01
query34	16.96	4.49	4.47
query35	4.54	4.50	4.46
query36	0.67	0.48	0.49
query37	0.08	0.06	0.06
query38	0.04	0.03	0.03
query39	0.02	0.02	0.02
query40	0.15	0.13	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: 106.9 s
Total hot run time: 32.29 s

zclllyybb
zclllyybb reviewed Oct 13, 2024
View reviewed changes
.gitignore Outdated
@@ -143,3 +143,4 @@ docker/runtime/be/resource/apache-doris/
compile_commands.json
.github

core
Copy link
Contributor

Choose a reason for hiding this comment

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

don't commit this too. or just core-* may be acceptable

regression-test/suites/nereids_syntax_p0/test_regexp_replace.groovy Outdated
// under the License.

suite("test_regexp_replace") {
sql "SET enable_nereids_planner=true"
Copy link
Contributor

Choose a reason for hiding this comment

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

u don't need to set these to session variables now. in master branch now we only have nereids planner and no other

@github-actions GitHub Actions
Copy link
Contributor

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

1 similar comment
@github-actions GitHub Actions
Copy link
Contributor

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

@github-actions GitHub Actions
Copy link
Contributor

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

@Yoruet Yoruet requested a review from zclllyybb October 13, 2024 11:39
@Yoruet
Copy link
Contributor Author

Yoruet commented Oct 13, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17585	7429	7280	7280
q2	2013	291	290	290
q3	12090	1108	1156	1108
q4	10584	807	746	746
q5	7757	2872	2830	2830
q6	234	149	148	148
q7	987	650	626	626
q8	9347	1955	1890	1890
q9	6572	6441	6428	6428
q10	6948	2316	2309	2309
q11	449	254	248	248
q12	412	222	222	222
q13	17793	2983	2936	2936
q14	233	210	210	210
q15	571	532	515	515
q16	636	607	578	578
q17	980	519	651	519
q18	7352	6871	6784	6784
q19	1354	1000	977	977
q20	491	204	198	198
q21	4259	3185	3291	3185
q22	1093	989	982	982
Total cold run time: 109740 ms
Total hot run time: 41009 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7256	7198	7272	7198
q2	330	229	247	229
q3	3059	2955	2933	2933
q4	2099	1863	1733	1733
q5	5772	5784	5768	5768
q6	234	144	146	144
q7	2242	1842	1795	1795
q8	3363	3564	3470	3470
q9	8987	8919	8889	8889
q10	3612	3577	3518	3518
q11	587	507	507	507
q12	808	642	642	642
q13	8295	3204	3171	3171
q14	302	274	293	274
q15	580	520	523	520
q16	673	661	632	632
q17	1864	1621	1594	1594
q18	8397	7732	7675	7675
q19	1694	1383	1532	1383
q20	2074	1870	1862	1862
q21	5492	5390	5327	5327
q22	1141	1071	1091	1071
Total cold run time: 68861 ms
Total hot run time: 60335 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 37.41% (9671/25848)
Line Coverage: 28.64% (80139/279845)
Region Coverage: 28.08% (41455/147637)
Branch Coverage: 24.66% (21069/85438)
Coverage Report: http://coverage.selectdb-in.cc/coverage/64c102c40edfcbdecda51a2c4889d4de4b895993_64c102c40edfcbdecda51a2c4889d4de4b895993/report/index.html

@doris-robot
Copy link

TPC-DS: Total hot run time: 191413 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 64c102c40edfcbdecda51a2c4889d4de4b895993, data reload: false

query1	896	381	406	381
query2	6269	2063	2003	2003
query3	8683	207	206	206
query4	33829	23714	23319	23319
query5	3546	497	471	471
query6	275	173	170	170
query7	4194	314	308	308
query8	290	233	237	233
query9	9108	2673	2693	2673
query10	458	279	285	279
query11	17639	15035	15066	15035
query12	154	99	99	99
query13	1581	462	464	462
query14	9381	7342	7268	7268
query15	255	163	171	163
query16	8062	479	451	451
query17	1648	605	552	552
query18	2129	326	310	310
query19	372	146	141	141
query20	117	113	113	113
query21	213	106	105	105
query22	4825	4536	4454	4454
query23	35238	34084	33925	33925
query24	10991	2858	2865	2858
query25	603	388	394	388
query26	1126	158	165	158
query27	2243	297	302	297
query28	7545	2427	2419	2419
query29	805	406	406	406
query30	273	147	162	147
query31	1023	773	798	773
query32	94	51	50	50
query33	753	279	284	279
query34	921	507	498	498
query35	836	738	738	738
query36	1092	953	925	925
query37	160	85	80	80
query38	4077	3890	3838	3838
query39	1484	1537	1398	1398
query40	206	93	100	93
query41	50	45	47	45
query42	125	97	96	96
query43	541	495	486	486
query44	1201	801	818	801
query45	196	164	162	162
query46	1110	701	713	701
query47	1901	1860	1851	1851
query48	420	329	342	329
query49	931	394	379	379
query50	815	414	418	414
query51	7069	6978	6892	6892
query52	95	83	86	83
query53	253	176	180	176
query54	1215	469	473	469
query55	74	79	78	78
query56	279	253	246	246
query57	1268	1178	1148	1148
query58	235	238	232	232
query59	3122	2995	2985	2985
query60	305	275	274	274
query61	126	130	125	125
query62	867	685	670	670
query63	219	192	187	187
query64	4082	717	703	703
query65	3224	3202	3221	3202
query66	834	321	315	315
query67	15966	15651	15548	15548
query68	3615	612	586	586
query69	462	297	296	296
query70	1214	1162	1128	1128
query71	349	271	282	271
query72	6186	4105	4095	4095
query73	768	353	346	346
query74	9867	8926	9022	8926
query75	3408	2677	2665	2665
query76	2468	931	837	837
query77	463	296	289	289
query78	10484	9582	9550	9550
query79	2924	616	614	614
query80	1337	444	443	443
query81	589	237	232	232
query82	621	135	139	135
query83	234	132	134	132
query84	246	81	74	74
query85	1385	302	281	281
query86	454	289	304	289
query87	4486	4294	4322	4294
query88	4208	2390	2352	2352
query89	413	290	282	282
query90	1892	182	183	182
query91	138	107	106	106
query92	71	50	48	48
query93	2587	559	554	554
query94	909	290	257	257
query95	351	252	254	252
query96	637	280	269	269
query97	3268	3094	3116	3094
query98	221	196	189	189
query99	1721	1282	1301	1282
Total cold run time: 297893 ms
Total hot run time: 191413 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.02
query2	0.06	0.03	0.03
query3	0.22	0.06	0.06
query4	1.65	0.10	0.10
query5	0.53	0.51	0.51
query6	1.13	0.72	0.73
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.56	0.50	0.50
query10	0.54	0.55	0.54
query11	0.14	0.10	0.10
query12	0.14	0.11	0.11
query13	0.61	0.60	0.60
query14	2.70	2.72	2.83
query15	0.90	0.82	0.82
query16	0.39	0.38	0.41
query17	0.99	0.99	0.97
query18	0.20	0.19	0.20
query19	1.84	1.87	1.83
query20	0.02	0.02	0.01
query21	15.36	0.57	0.58
query22	2.68	2.55	1.47
query23	17.22	0.92	0.84
query24	3.29	0.88	2.00
query25	0.24	0.07	0.21
query26	0.49	0.14	0.13
query27	0.05	0.05	0.05
query28	9.95	1.10	1.06
query29	12.58	3.25	3.26
query30	0.25	0.06	0.05
query31	2.87	0.38	0.37
query32	3.28	0.45	0.47
query33	3.00	3.00	3.03
query34	17.03	4.45	4.49
query35	4.51	4.45	4.48
query36	0.67	0.48	0.48
query37	0.08	0.05	0.06
query38	0.04	0.03	0.04
query39	0.03	0.02	0.02
query40	0.15	0.13	0.12
query41	0.07	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.62 s
Total hot run time: 32.12 s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@zclllyybb zclllyybb Awaiting requested review from zclllyybb

At least 1 approving review is required to merge this pull request.

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
4 participants
@Yoruet @doris-robot @zclllyybb @zhiqiang-hhhh