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

[enhance](paimon) opt count pushdown for paimon #46911

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

[enhance](paimon) opt count pushdown for paimon #46911

wants to merge 13 commits into from

Conversation

suxiaogang223
Copy link
Contributor

What problem does this PR solve?

Related PR: #44038

Obtain directly from statistics for select count(*) from paimon_table

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?

@suxiaogang223 suxiaogang223 marked this pull request as draft January 13, 2025 10:53
@suxiaogang223 suxiaogang223 marked this pull request as ready for review February 20, 2025 11:15
@suxiaogang223
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TeamCity cloud ut coverage result:
Function Coverage: 82.25% (1061/1290)
Line Coverage: 65.79% (17595/26746)
Region Coverage: 65.33% (8670/13271)
Branch Coverage: 55.24% (4674/8462)
Coverage Report: http://coverage.selectdb-in.cc/coverage/ef33aa70f28e0294d2512e30c7eac3eabec8e8f0_ef33aa70f28e0294d2512e30c7eac3eabec8e8f0_cloud/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17624	5347	5167	5167
q2	2053	300	189	189
q3	10387	1312	734	734
q4	10219	1018	537	537
q5	7552	2963	2325	2325
q6	206	170	136	136
q7	947	772	642	642
q8	9321	1363	1208	1208
q9	4947	4529	4534	4529
q10	6852	2332	1873	1873
q11	487	281	253	253
q12	349	360	221	221
q13	17776	3699	3183	3183
q14	246	226	215	215
q15	534	479	458	458
q16	623	627	580	580
q17	638	912	344	344
q18	7280	6274	6029	6029
q19	1543	972	583	583
q20	321	325	194	194
q21	2850	2118	1947	1947
q22	361	335	315	315
Total cold run time: 103116 ms
Total hot run time: 31662 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5236	5203	5231	5203
q2	244	336	247	247
q3	2205	2686	2341	2341
q4	1410	1821	1334	1334
q5	4262	4157	4181	4157
q6	217	167	127	127
q7	1896	1866	1791	1791
q8	2648	2601	2555	2555
q9	7208	7087	7091	7087
q10	3024	3194	2755	2755
q11	581	515	507	507
q12	665	778	602	602
q13	3514	3886	3316	3316
q14	276	295	284	284
q15	496	461	472	461
q16	636	666	622	622
q17	1148	1620	1348	1348
q18	7525	7324	7372	7324
q19	797	839	1038	839
q20	1966	2002	1898	1898
q21	5545	5027	4870	4870
q22	602	592	550	550
Total cold run time: 52101 ms
Total hot run time: 50218 ms

@doris-robot
Copy link

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

query1	1031	381	366	366
query2	6517	1922	1881	1881
query3	6794	211	209	209
query4	26313	23800	23671	23671
query5	4326	683	531	531
query6	313	197	187	187
query7	4608	504	304	304
query8	304	245	237	237
query9	8620	2591	2592	2591
query10	486	304	251	251
query11	15653	15127	15218	15127
query12	156	115	110	110
query13	1664	545	390	390
query14	9741	6217	6624	6217
query15	212	207	179	179
query16	7673	646	459	459
query17	1201	736	588	588
query18	1992	413	310	310
query19	197	220	162	162
query20	123	122	117	117
query21	209	131	111	111
query22	4323	4374	4463	4374
query23	34725	33228	32929	32929
query24	7729	2405	2370	2370
query25	532	443	380	380
query26	801	282	157	157
query27	2123	511	321	321
query28	3870	2415	2409	2409
query29	667	536	425	425
query30	233	190	161	161
query31	912	828	764	764
query32	74	64	61	61
query33	549	394	301	301
query34	768	868	515	515
query35	787	824	743	743
query36	963	989	875	875
query37	119	99	100	99
query38	4353	4147	4164	4147
query39	1438	1571	1388	1388
query40	214	118	110	110
query41	57	51	49	49
query42	122	101	104	101
query43	521	513	472	472
query44	1342	800	774	774
query45	178	173	159	159
query46	879	1051	650	650
query47	1770	1771	1723	1723
query48	394	429	304	304
query49	739	487	413	413
query50	694	748	431	431
query51	4203	4196	4099	4099
query52	107	111	93	93
query53	231	260	198	198
query54	493	499	411	411
query55	86	84	78	78
query56	258	264	248	248
query57	1110	1161	1049	1049
query58	256	238	244	238
query59	2621	2946	2572	2572
query60	288	272	254	254
query61	121	119	119	119
query62	812	735	669	669
query63	241	191	197	191
query64	3554	990	652	652
query65	3264	3149	3153	3149
query66	916	409	308	308
query67	15789	15527	15253	15253
query68	8117	792	515	515
query69	485	295	281	281
query70	1232	1132	1092	1092
query71	464	305	281	281
query72	5765	3593	3683	3593
query73	736	766	356	356
query74	9282	9156	9015	9015
query75	3339	3173	2768	2768
query76	3214	1187	763	763
query77	708	414	296	296
query78	9955	10147	9262	9262
query79	2078	832	634	634
query80	675	545	478	478
query81	493	282	236	236
query82	652	127	96	96
query83	192	167	154	154
query84	288	92	77	77
query85	771	352	312	312
query86	348	321	284	284
query87	4407	4438	4332	4332
query88	2905	2261	2239	2239
query89	413	322	294	294
query90	1910	202	196	196
query91	138	138	109	109
query92	75	61	57	57
query93	1153	1002	590	590
query94	699	410	303	303
query95	354	273	256	256
query96	510	546	281	281
query97	2802	2840	2743	2743
query98	227	208	199	199
query99	1422	1394	1266	1266
Total cold run time: 270168 ms
Total hot run time: 184542 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.04
query2	0.08	0.03	0.03
query3	0.24	0.06	0.06
query4	1.62	0.10	0.10
query5	0.43	0.41	0.40
query6	1.17	0.66	0.66
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.61	0.52	0.51
query10	0.57	0.59	0.57
query11	0.16	0.11	0.10
query12	0.14	0.11	0.12
query13	0.62	0.60	0.61
query14	2.67	2.69	2.69
query15	0.91	0.86	0.87
query16	0.38	0.38	0.38
query17	1.00	1.00	1.03
query18	0.22	0.19	0.20
query19	1.90	1.96	1.75
query20	0.01	0.01	0.02
query21	15.36	0.90	0.55
query22	0.77	1.12	0.89
query23	14.72	1.38	0.62
query24	7.65	0.96	1.06
query25	0.50	0.32	0.18
query26	0.60	0.16	0.16
query27	0.06	0.05	0.05
query28	9.46	0.86	0.44
query29	12.55	3.89	3.25
query30	0.25	0.09	0.07
query31	2.81	0.58	0.38
query32	3.22	0.54	0.46
query33	2.98	3.01	3.07
query34	15.68	5.15	4.48
query35	4.50	4.52	4.56
query36	0.66	0.53	0.48
query37	0.09	0.07	0.06
query38	0.06	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.14	0.14
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.03	0.04	0.03
Total cold run time: 105.1 s
Total hot run time: 30.93 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 44.34% (11701/26392)
Line Coverage: 33.92% (98005/288946)
Region Coverage: 33.00% (50183/152081)
Branch Coverage: 28.65% (25225/88042)
Coverage Report: http://coverage.selectdb-in.cc/coverage/ef33aa70f28e0294d2512e30c7eac3eabec8e8f0_ef33aa70f28e0294d2512e30c7eac3eabec8e8f0/report/index.html

@suxiaogang223
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TeamCity cloud ut coverage result:
Function Coverage: 82.25% (1061/1290)
Line Coverage: 65.79% (17596/26746)
Region Coverage: 65.34% (8671/13271)
Branch Coverage: 55.24% (4674/8462)
Coverage Report: http://coverage.selectdb-in.cc/coverage/0fcde840e4f6632e1428501f1f8fbd37fe6878ba_0fcde840e4f6632e1428501f1f8fbd37fe6878ba_cloud/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17577	5403	5085	5085
q2	2043	294	167	167
q3	10421	1233	747	747
q4	10201	1006	516	516
q5	7499	2442	2299	2299
q6	190	169	131	131
q7	894	723	602	602
q8	9306	1333	1179	1179
q9	4853	4630	4679	4630
q10	6833	2300	1868	1868
q11	457	285	257	257
q12	347	356	218	218
q13	17765	3687	3173	3173
q14	245	228	210	210
q15	518	467	471	467
q16	626	618	590	590
q17	550	841	324	324
q18	6822	6137	6364	6137
q19	1215	952	534	534
q20	314	325	182	182
q21	2782	2145	1940	1940
q22	365	331	309	309
Total cold run time: 101823 ms
Total hot run time: 31565 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5103	5137	5129	5129
q2	233	332	240	240
q3	2149	2705	2262	2262
q4	1432	1825	1368	1368
q5	4256	4158	4151	4151
q6	208	164	126	126
q7	1871	1826	1653	1653
q8	2592	2630	2568	2568
q9	7198	7189	7132	7132
q10	3033	3176	2794	2794
q11	580	533	494	494
q12	681	763	606	606
q13	3535	3845	3333	3333
q14	279	301	274	274
q15	508	463	472	463
q16	645	690	629	629
q17	1137	1572	1336	1336
q18	7616	7361	7270	7270
q19	786	828	877	828
q20	1959	2018	1895	1895
q21	5407	5028	4836	4836
q22	607	584	548	548
Total cold run time: 51815 ms
Total hot run time: 49935 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190729 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 0fcde840e4f6632e1428501f1f8fbd37fe6878ba, data reload: false

query1	1304	958	920	920
query2	6243	1932	1867	1867
query3	10950	4392	4479	4392
query4	53918	24591	23370	23370
query5	5168	551	490	490
query6	367	183	181	181
query7	5123	494	288	288
query8	318	240	236	236
query9	6413	2579	2583	2579
query10	426	300	270	270
query11	15245	15185	14972	14972
query12	173	114	110	110
query13	1145	534	389	389
query14	10641	6697	6659	6659
query15	203	199	188	188
query16	7110	662	461	461
query17	1079	738	608	608
query18	1530	433	322	322
query19	225	204	185	185
query20	131	129	133	129
query21	213	122	111	111
query22	4573	4283	4410	4283
query23	33945	33352	33257	33257
query24	5757	2426	2455	2426
query25	502	464	391	391
query26	677	276	162	162
query27	1922	487	339	339
query28	2841	2498	2460	2460
query29	565	552	426	426
query30	206	195	156	156
query31	876	891	792	792
query32	76	61	62	61
query33	466	363	294	294
query34	737	858	514	514
query35	824	858	760	760
query36	959	1001	902	902
query37	125	99	74	74
query38	4357	4351	4316	4316
query39	1488	1483	1464	1464
query40	203	112	100	100
query41	50	48	56	48
query42	125	111	102	102
query43	507	523	497	497
query44	1352	800	798	798
query45	181	174	163	163
query46	891	1065	662	662
query47	1836	1894	1796	1796
query48	388	432	322	322
query49	689	505	428	428
query50	714	755	446	446
query51	4242	4310	4261	4261
query52	108	99	95	95
query53	238	257	184	184
query54	479	505	422	422
query55	88	81	83	81
query56	285	282	272	272
query57	1170	1205	1119	1119
query58	242	247	274	247
query59	2792	2810	2789	2789
query60	299	286	264	264
query61	127	119	111	111
query62	725	746	727	727
query63	238	192	196	192
query64	1487	1044	680	680
query65	3257	3158	3135	3135
query66	713	395	319	319
query67	15900	15735	15596	15596
query68	5243	766	517	517
query69	509	297	258	258
query70	1183	1077	1129	1077
query71	422	297	262	262
query72	6022	3616	3703	3616
query73	1040	744	352	352
query74	9062	9149	8938	8938
query75	3202	3238	2695	2695
query76	3753	1175	739	739
query77	563	355	273	273
query78	10243	10187	9270	9270
query79	1951	850	605	605
query80	820	537	454	454
query81	534	285	234	234
query82	398	126	91	91
query83	188	167	158	158
query84	289	97	73	73
query85	811	342	301	301
query86	366	294	281	281
query87	4590	4500	4434	4434
query88	2973	2222	2204	2204
query89	390	316	292	292
query90	1679	191	194	191
query91	139	138	108	108
query92	64	58	55	55
query93	2160	1018	575	575
query94	652	383	302	302
query95	344	268	255	255
query96	492	537	267	267
query97	2776	2845	2729	2729
query98	216	198	209	198
query99	1307	1401	1265	1265
Total cold run time: 292528 ms
Total hot run time: 190729 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.11	0.05	0.05
query3	0.28	0.05	0.05
query4	1.61	0.07	0.08
query5	0.40	0.50	0.40
query6	1.16	0.65	0.65
query7	0.02	0.02	0.02
query8	0.05	0.05	0.05
query9	0.63	0.52	0.52
query10	0.58	0.58	0.57
query11	0.25	0.13	0.13
query12	0.25	0.13	0.13
query13	0.62	0.61	0.62
query14	2.67	2.71	2.75
query15	0.98	0.90	0.89
query16	0.38	0.36	0.36
query17	1.06	1.04	1.03
query18	0.18	0.20	0.19
query19	1.98	1.85	2.02
query20	0.01	0.02	0.01
query21	15.37	0.97	0.66
query22	0.92	1.05	0.76
query23	14.76	1.58	0.75
query24	5.60	0.55	0.28
query25	0.17	0.10	0.08
query26	0.56	0.22	0.18
query27	0.08	0.09	0.08
query28	11.00	1.13	0.55
query29	12.54	4.13	3.45
query30	0.27	0.08	0.06
query31	2.81	0.60	0.42
query32	3.24	0.59	0.48
query33	3.06	3.07	3.16
query34	16.46	5.06	4.37
query35	4.46	4.45	4.45
query36	0.64	0.50	0.50
query37	0.21	0.18	0.16
query38	0.17	0.15	0.16
query39	0.05	0.04	0.04
query40	0.19	0.15	0.16
query41	0.10	0.06	0.05
query42	0.06	0.05	0.05
query43	0.05	0.05	0.05
Total cold run time: 106.03 s
Total hot run time: 31.11 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 44.51% (11753/26408)
Line Coverage: 33.99% (98246/289005)
Region Coverage: 33.08% (50334/152141)
Branch Coverage: 28.73% (25303/88078)
Coverage Report: http://coverage.selectdb-in.cc/coverage/0fcde840e4f6632e1428501f1f8fbd37fe6878ba_0fcde840e4f6632e1428501f1f8fbd37fe6878ba/report/index.html

@suxiaogang223
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

TeamCity cloud ut coverage result:
Function Coverage: 82.25% (1061/1290)
Line Coverage: 65.73% (17579/26746)
Region Coverage: 65.27% (8662/13271)
Branch Coverage: 55.19% (4670/8462)
Coverage Report: http://coverage.selectdb-in.cc/coverage/4e16169f539dda137d97de17ac1c97988f92af3e_4e16169f539dda137d97de17ac1c97988f92af3e_cloud/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17618	5416	5136	5136
q2	2062	285	168	168
q3	10753	1275	769	769
q4	10335	1041	517	517
q5	8833	2425	2285	2285
q6	202	168	139	139
q7	916	750	608	608
q8	9320	1350	1183	1183
q9	4887	4552	4728	4552
q10	6809	2307	1896	1896
q11	498	285	260	260
q12	358	359	227	227
q13	17760	3682	3021	3021
q14	227	236	210	210
q15	522	467	466	466
q16	622	621	586	586
q17	568	925	339	339
q18	6680	6224	6109	6109
q19	2011	968	562	562
q20	304	319	186	186
q21	2779	2128	1967	1967
q22	376	346	289	289
Total cold run time: 104440 ms
Total hot run time: 31475 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5240	5176	5087	5087
q2	230	324	234	234
q3	2165	2698	2284	2284
q4	1449	1807	1328	1328
q5	4234	4120	4145	4120
q6	212	166	123	123
q7	1870	1866	1743	1743
q8	2620	2500	2569	2500
q9	7248	7200	7181	7181
q10	3006	3241	2771	2771
q11	579	504	492	492
q12	708	757	637	637
q13	3293	3876	3260	3260
q14	277	288	287	287
q15	504	494	462	462
q16	631	680	633	633
q17	1130	1569	1359	1359
q18	7616	7359	7356	7356
q19	781	834	991	834
q20	1979	2030	1884	1884
q21	5497	4995	4703	4703
q22	606	586	547	547
Total cold run time: 51875 ms
Total hot run time: 49825 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 44.51% (11753/26408)
Line Coverage: 34.00% (98271/289005)
Region Coverage: 33.08% (50325/152141)
Branch Coverage: 28.72% (25293/88078)
Coverage Report: http://coverage.selectdb-in.cc/coverage/4e16169f539dda137d97de17ac1c97988f92af3e_4e16169f539dda137d97de17ac1c97988f92af3e/report/index.html

@doris-robot
Copy link

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

query1	1334	973	928	928
query2	6210	1916	1930	1916
query3	11104	4682	4489	4489
query4	57198	24707	23120	23120
query5	5170	502	483	483
query6	375	200	187	187
query7	5225	492	287	287
query8	332	241	235	235
query9	6672	2590	2593	2590
query10	424	316	256	256
query11	15196	15258	14904	14904
query12	159	108	110	108
query13	1174	538	380	380
query14	10530	6291	6359	6291
query15	208	202	189	189
query16	7076	675	529	529
query17	1090	726	582	582
query18	1535	418	326	326
query19	196	202	175	175
query20	137	178	126	126
query21	214	125	115	115
query22	4571	4668	4327	4327
query23	33940	33247	33359	33247
query24	5729	2428	2460	2428
query25	454	463	406	406
query26	667	282	153	153
query27	1887	504	334	334
query28	2818	2501	2448	2448
query29	544	555	427	427
query30	214	184	151	151
query31	892	881	846	846
query32	77	61	64	61
query33	468	360	308	308
query34	753	856	516	516
query35	829	831	733	733
query36	950	972	902	902
query37	123	98	74	74
query38	4350	4338	4186	4186
query39	1494	1428	1462	1428
query40	202	121	103	103
query41	61	55	52	52
query42	122	101	121	101
query43	504	541	489	489
query44	1303	799	801	799
query45	178	183	167	167
query46	886	1094	658	658
query47	1895	1842	1793	1793
query48	419	428	305	305
query49	691	518	419	419
query50	724	740	427	427
query51	4237	4329	4255	4255
query52	108	105	97	97
query53	226	261	186	186
query54	496	493	410	410
query55	80	76	83	76
query56	262	274	253	253
query57	1155	1188	1102	1102
query58	238	235	251	235
query59	2945	2970	2774	2774
query60	298	272	263	263
query61	117	114	112	112
query62	729	727	697	697
query63	240	190	192	190
query64	1450	1031	677	677
query65	3240	3119	3116	3116
query66	706	385	291	291
query67	16032	15650	15426	15426
query68	5244	781	512	512
query69	517	292	268	268
query70	1167	1106	1104	1104
query71	437	279	260	260
query72	6328	3653	3671	3653
query73	994	742	367	367
query74	9158	9097	8932	8932
query75	3485	3141	2688	2688
query76	3787	1156	717	717
query77	522	351	277	277
query78	9983	10050	9313	9313
query79	2100	794	592	592
query80	636	517	429	429
query81	499	282	239	239
query82	332	124	98	98
query83	179	173	146	146
query84	291	95	69	69
query85	738	405	301	301
query86	350	313	292	292
query87	4463	4493	4474	4474
query88	3130	2214	2162	2162
query89	383	313	293	293
query90	1936	193	188	188
query91	138	144	114	114
query92	72	59	57	57
query93	2685	988	568	568
query94	639	414	292	292
query95	337	259	329	259
query96	497	531	265	265
query97	2859	2842	2667	2667
query98	226	203	204	203
query99	1311	1364	1309	1309
Total cold run time: 297286 ms
Total hot run time: 189772 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.10	0.05	0.05
query3	0.28	0.05	0.05
query4	1.59	0.09	0.07
query5	0.41	0.39	0.40
query6	1.18	0.65	0.64
query7	0.02	0.01	0.01
query8	0.05	0.05	0.05
query9	0.61	0.53	0.52
query10	0.59	0.59	0.56
query11	0.25	0.13	0.12
query12	0.24	0.12	0.13
query13	0.62	0.61	0.61
query14	2.67	2.73	2.71
query15	0.98	0.86	0.86
query16	0.36	0.36	0.36
query17	1.04	1.08	1.03
query18	0.19	0.18	0.19
query19	2.00	1.83	2.05
query20	0.02	0.01	0.02
query21	15.35	0.96	0.67
query22	0.92	1.04	0.79
query23	14.70	1.56	0.74
query24	5.15	0.61	0.30
query25	0.16	0.10	0.09
query26	0.55	0.21	0.18
query27	0.09	0.09	0.08
query28	11.03	1.17	0.55
query29	12.51	4.11	3.44
query30	0.27	0.07	0.05
query31	2.85	0.60	0.40
query32	3.24	0.58	0.48
query33	3.01	3.08	3.03
query34	16.71	5.15	4.49
query35	4.54	4.52	4.50
query36	0.63	0.51	0.51
query37	0.21	0.18	0.16
query38	0.17	0.16	0.15
query39	0.05	0.04	0.04
query40	0.19	0.16	0.15
query41	0.10	0.05	0.05
query42	0.06	0.04	0.05
query43	0.05	0.04	0.04
Total cold run time: 105.78 s
Total hot run time: 31.13 s

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
@suxiaogang223 @hello-stephen @doris-robot