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

[Fix](group commit) Fix table not found fault when disable group commit #39731

Merged
merged 5 commits into from
Aug 28, 2024
Merged

[Fix](group commit) Fix table not found fault when disable group commit #39731

merged 5 commits into from
Aug 28, 2024

Conversation

Yukang-Lian
Copy link
Collaborator

@Yukang-Lian Yukang-Lian commented Aug 21, 2024 •
edited
Loading

Proposed changes

selectRedirectBackend param table id is only needed by group commit. In non group commit mode, if table id is null, we need to ignore it.

@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.

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17858	4349	4264	4264
q2	2060	226	221	221
q3	11679	1051	1140	1051
q4	10548	810	771	771
q5	7761	2851	2808	2808
q6	264	160	160	160
q7	1001	646	644	644
q8	9597	2072	2132	2072
q9	8778	6501	6557	6501
q10	7067	2242	2236	2236
q11	498	266	270	266
q12	425	250	253	250
q13	17813	2972	3018	2972
q14	294	251	255	251
q15	562	525	518	518
q16	530	414	401	401
q17	993	688	740	688
q18	7330	6776	6686	6686
q19	6905	1047	1094	1047
q20	693	361	355	355
q21	3915	2933	3006	2933
q22	1132	1043	1035	1035
Total cold run time: 117703 ms
Total hot run time: 38130 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4575	4290	4273	4273
q2	415	302	302	302
q3	2879	2645	2707	2645
q4	1980	1743	1684	1684
q5	5661	5690	5632	5632
q6	238	153	154	153
q7	2202	1828	1766	1766
q8	3261	3459	3451	3451
q9	8732	8801	8765	8765
q10	3556	3391	3323	3323
q11	634	523	532	523
q12	839	669	677	669
q13	15787	3164	3209	3164
q14	337	306	293	293
q15	561	515	508	508
q16	485	441	453	441
q17	1798	1548	1561	1548
q18	8779	8047	7742	7742
q19	8303	1586	1612	1586
q20	2124	1881	1899	1881
q21	13936	5359	5357	5357
q22	1161	1081	1097	1081
Total cold run time: 88243 ms
Total hot run time: 56787 ms

@doris-robot
Copy link

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

query1	1366	915	902	902
query2	6570	2033	1930	1930
query3	10637	3897	3616	3616
query4	58249	23955	23431	23431
query5	6205	721	720	720
query6	545	214	210	210
query7	6439	339	339	339
query8	540	434	447	434
query9	9316	2544	2540	2540
query10	599	360	339	339
query11	17133	14993	15278	14993
query12	195	167	131	131
query13	1697	438	433	433
query14	12289	7197	7155	7155
query15	263	196	192	192
query16	7691	545	536	536
query17	1165	630	606	606
query18	2188	357	341	341
query19	295	173	172	172
query20	149	138	140	138
query21	261	165	165	165
query22	4606	4547	4416	4416
query23	34659	33762	33760	33760
query24	5824	2988	3018	2988
query25	578	432	425	425
query26	708	182	185	182
query27	1785	311	313	311
query28	3962	2207	2197	2197
query29	770	454	491	454
query30	232	205	192	192
query31	1030	851	822	822
query32	111	77	80	77
query33	560	352	336	336
query34	893	516	512	512
query35	855	768	795	768
query36	1102	963	950	950
query37	158	103	105	103
query38	3997	3847	3849	3847
query39	1574	1460	1454	1454
query40	235	156	159	156
query41	142	139	139	139
query42	139	117	117	117
query43	531	503	511	503
query44	1109	776	781	776
query45	219	193	195	193
query46	1131	783	779	779
query47	1931	1884	1875	1875
query48	407	346	328	328
query49	908	595	591	591
query50	884	471	470	470
query51	7214	7190	7089	7089
query52	121	109	106	106
query53	303	234	228	228
query54	598	504	499	499
query55	96	91	90	90
query56	326	312	318	312
query57	1226	1108	1124	1108
query58	306	304	297	297
query59	2960	2916	2779	2779
query60	353	331	342	331
query61	152	148	153	148
query62	783	696	670	670
query63	253	233	226	226
query64	4248	2337	1871	1871
query65	3237	3166	3177	3166
query66	1002	688	680	680
query67	15566	15186	14956	14956
query68	8236	596	610	596
query69	647	448	344	344
query70	1236	1127	1192	1127
query71	538	321	328	321
query72	6681	2305	2096	2096
query73	860	352	362	352
query74	9205	8806	8871	8806
query75	3735	2787	2780	2780
query76	4343	1049	1054	1049
query77	871	439	448	439
query78	9898	9202	9360	9202
query79	2973	565	569	565
query80	2695	610	615	610
query81	601	261	262	261
query82	689	156	157	156
query83	363	227	271	227
query84	301	96	100	96
query85	926	365	356	356
query86	390	333	328	328
query87	4356	4244	4209	4209
query88	4206	2457	2457	2457
query89	453	326	317	317
query90	2074	228	228	228
query91	159	129	128	128
query92	90	76	76	76
query93	4079	551	549	549
query94	844	332	329	329
query95	383	305	295	295
query96	618	287	292	287
query97	3245	3110	3021	3021
query98	251	228	216	216
query99	1623	1276	1331	1276
Total cold run time: 331145 ms
Total hot run time: 196699 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 beb02faef3c370565cfbc60e0baee6c409a6a666, data reload: false

query1	0.04	0.05	0.04
query2	0.08	0.04	0.04
query3	0.23	0.05	0.06
query4	1.66	0.08	0.08
query5	0.50	0.49	0.49
query6	1.12	0.74	0.72
query7	0.02	0.02	0.01
query8	0.06	0.05	0.06
query9	0.55	0.50	0.49
query10	0.55	0.54	0.57
query11	0.16	0.12	0.13
query12	0.16	0.13	0.12
query13	0.62	0.60	0.61
query14	0.76	0.82	0.81
query15	0.84	0.83	0.83
query16	0.38	0.37	0.38
query17	0.98	1.02	0.97
query18	0.22	0.20	0.20
query19	1.91	1.77	1.77
query20	0.01	0.01	0.01
query21	15.40	0.67	0.66
query22	4.47	6.90	1.72
query23	18.28	1.31	1.25
query24	2.05	0.22	0.23
query25	0.16	0.09	0.08
query26	0.28	0.19	0.18
query27	0.08	0.08	0.08
query28	13.35	1.03	1.00
query29	12.67	3.38	3.33
query30	0.45	0.25	0.24
query31	2.81	0.42	0.41
query32	3.24	0.49	0.49
query33	2.92	2.97	2.95
query34	17.14	4.33	4.39
query35	4.39	4.44	4.44
query36	0.66	0.49	0.50
query37	0.20	0.18	0.18
query38	0.19	0.17	0.16
query39	0.06	0.06	0.06
query40	0.18	0.15	0.16
query41	0.12	0.07	0.08
query42	0.07	0.07	0.07
query43	0.07	0.06	0.06
Total cold run time: 110.09 s
Total hot run time: 30.93 s

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17865	4488	4290	4290
q2	2059	215	211	211
q3	11668	1006	1169	1006
q4	10550	891	705	705
q5	7782	2819	2797	2797
q6	264	156	157	156
q7	1001	652	659	652
q8	9389	2088	2129	2088
q9	7088	6601	6636	6601
q10	7067	2191	2252	2191
q11	515	276	275	275
q12	428	262	267	262
q13	18918	3056	3084	3056
q14	313	259	260	259
q15	583	522	544	522
q16	528	439	408	408
q17	1005	704	691	691
q18	7230	6823	6807	6807
q19	1440	1104	1043	1043
q20	690	363	356	356
q21	3894	2960	3035	2960
q22	1148	1045	1046	1045
Total cold run time: 111425 ms
Total hot run time: 38381 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4369	4346	4321	4321
q2	396	310	309	309
q3	2874	2632	2613	2613
q4	1923	1656	1729	1656
q5	5621	5640	5697	5640
q6	241	154	147	147
q7	2242	1843	1846	1843
q8	3331	3444	3429	3429
q9	8860	8810	8800	8800
q10	3590	3321	3363	3321
q11	669	562	545	545
q12	878	706	733	706
q13	17224	3220	3247	3220
q14	338	301	309	301
q15	590	527	547	527
q16	518	449	449	449
q17	1786	1552	1542	1542
q18	8130	7918	7755	7755
q19	4832	1658	1633	1633
q20	2138	1931	1962	1931
q21	5700	5413	5436	5413
q22	1182	1111	1098	1098
Total cold run time: 77432 ms
Total hot run time: 57199 ms

@doris-robot
Copy link

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

query1	1308	895	881	881
query2	6442	2017	2118	2017
query3	10621	4200	3975	3975
query4	59442	25357	23251	23251
query5	5579	724	731	724
query6	451	203	204	203
query7	5808	333	334	333
query8	527	430	430	430
query9	8929	2561	2535	2535
query10	565	361	332	332
query11	18394	15111	15493	15111
query12	217	132	132	132
query13	1624	451	486	451
query14	11374	7568	7455	7455
query15	239	193	188	188
query16	7598	496	503	496
query17	1199	616	627	616
query18	2014	362	342	342
query19	317	171	175	171
query20	147	142	141	141
query21	248	149	144	144
query22	4612	4491	4514	4491
query23	34402	33790	33900	33790
query24	6107	3048	2977	2977
query25	584	430	440	430
query26	709	181	184	181
query27	1744	308	308	308
query28	3882	2186	2131	2131
query29	746	447	452	447
query30	234	199	186	186
query31	1034	864	851	851
query32	111	79	84	79
query33	546	355	360	355
query34	908	517	528	517
query35	873	768	772	768
query36	1103	973	971	971
query37	174	107	103	103
query38	4021	3917	3906	3906
query39	1523	1471	1450	1450
query40	239	153	154	153
query41	137	138	137	137
query42	139	119	116	116
query43	558	512	515	512
query44	1135	791	788	788
query45	228	208	197	197
query46	1156	784	771	771
query47	1967	1856	1856	1856
query48	416	342	338	338
query49	912	596	606	596
query50	885	471	480	471
query51	7269	6965	7098	6965
query52	117	117	109	109
query53	328	225	223	223
query54	620	507	505	505
query55	93	89	88	88
query56	330	313	322	313
query57	1198	1115	1118	1115
query58	291	300	315	300
query59	3167	2929	2869	2869
query60	361	330	326	326
query61	156	149	149	149
query62	799	710	716	710
query63	261	224	230	224
query64	4006	2321	1877	1877
query65	3259	3222	3185	3185
query66	1019	667	677	667
query67	15339	15105	15344	15105
query68	4486	600	594	594
query69	465	331	320	320
query70	1250	1150	1190	1150
query71	394	319	319	319
query72	6445	2309	2113	2113
query73	803	365	365	365
query74	9308	8845	9032	8845
query75	3479	2839	2761	2761
query76	1891	1082	1061	1061
query77	636	442	439	439
query78	9973	9141	9227	9141
query79	1101	575	563	563
query80	1063	624	608	608
query81	607	259	262	259
query82	314	157	158	157
query83	248	210	214	210
query84	299	102	95	95
query85	954	358	355	355
query86	409	311	323	311
query87	4503	4395	4407	4395
query88	3456	2575	2516	2516
query89	426	337	330	330
query90	1879	227	227	227
query91	148	126	126	126
query92	85	76	77	76
query93	1267	553	552	552
query94	756	325	316	316
query95	393	298	306	298
query96	609	291	287	287
query97	3229	3099	3090	3090
query98	249	224	229	224
query99	1635	1310	1301	1301
Total cold run time: 315501 ms
Total hot run time: 197938 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 beb02faef3c370565cfbc60e0baee6c409a6a666, data reload: false

query1	0.05	0.04	0.04
query2	0.08	0.04	0.04
query3	0.22	0.06	0.05
query4	1.67	0.09	0.09
query5	0.53	0.50	0.51
query6	1.13	0.73	0.72
query7	0.02	0.02	0.02
query8	0.06	0.05	0.05
query9	0.55	0.48	0.47
query10	0.55	0.54	0.54
query11	0.16	0.12	0.12
query12	0.16	0.13	0.13
query13	0.62	0.59	0.58
query14	0.78	0.82	0.76
query15	0.84	0.81	0.84
query16	0.37	0.38	0.38
query17	1.00	1.06	1.04
query18	0.22	0.20	0.20
query19	1.93	1.81	1.75
query20	0.01	0.02	0.01
query21	15.40	0.66	0.66
query22	4.02	6.10	2.90
query23	18.31	1.28	1.20
query24	2.06	0.24	0.23
query25	0.16	0.09	0.08
query26	0.27	0.19	0.18
query27	0.08	0.08	0.08
query28	13.23	1.04	1.01
query29	12.64	3.47	3.42
query30	0.43	0.24	0.25
query31	2.81	0.41	0.40
query32	3.24	0.49	0.48
query33	3.00	2.96	2.97
query34	17.11	4.38	4.34
query35	4.50	4.40	4.47
query36	0.67	0.49	0.50
query37	0.21	0.17	0.17
query38	0.18	0.16	0.18
query39	0.06	0.05	0.06
query40	0.19	0.16	0.15
query41	0.11	0.07	0.07
query42	0.09	0.08	0.07
query43	0.07	0.06	0.06
Total cold run time: 109.79 s
Total hot run time: 32.1 s

dataroaring
dataroaring previously approved these changes Aug 22, 2024
View reviewed changes
Copy link
Contributor

@dataroaring dataroaring left a comment

Choose a reason for hiding this comment

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

LGTM

@github-actions GitHub Actions
Copy link
Contributor

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

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Aug 22, 2024
@github-actions GitHub Actions
Copy link
Contributor

PR approved by anyone and no changes requested.

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@github-actions github-actions bot removed the approved Indicates a PR has been approved by one committer. label Aug 22, 2024
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17612	4826	4369	4369
q2	2026	185	179	179
q3	11595	942	1089	942
q4	10351	745	772	745
q5	7748	2870	2778	2778
q6	226	140	140	140
q7	1003	604	605	604
q8	9324	2075	2090	2075
q9	7133	6563	6623	6563
q10	6991	2262	2297	2262
q11	476	254	243	243
q12	399	228	225	225
q13	17772	3051	3036	3036
q14	277	241	234	234
q15	514	477	490	477
q16	485	408	401	401
q17	997	621	749	621
q18	7661	6797	6910	6797
q19	1382	1075	1134	1075
q20	710	326	330	326
q21	3845	3165	2910	2910
q22	1139	1027	1036	1027
Total cold run time: 109666 ms
Total hot run time: 38029 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4420	4292	4307	4292
q2	375	281	275	275
q3	2921	2716	2633	2633
q4	1930	1646	1641	1641
q5	5638	5705	5761	5705
q6	237	139	134	134
q7	2248	1837	1818	1818
q8	3326	3434	3478	3434
q9	8831	8799	8859	8799
q10	3585	3423	3373	3373
q11	597	506	516	506
q12	836	661	647	647
q13	14624	3232	3285	3232
q14	320	291	294	291
q15	551	499	492	492
q16	499	485	433	433
q17	1870	1556	1538	1538
q18	8068	7695	8125	7695
q19	1737	1541	1568	1541
q20	2153	1931	1928	1928
q21	5747	5437	5546	5437
q22	1166	1065	1047	1047
Total cold run time: 71679 ms
Total hot run time: 56891 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192189 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 72374d611cd2bd992dd87b57a9373dc49a24f99f, data reload: false

query1	1266	882	876	876
query2	6189	1937	1913	1913
query3	10553	4052	3911	3911
query4	60134	26235	23302	23302
query5	5397	500	519	500
query6	413	174	194	174
query7	5799	290	291	290
query8	292	216	214	214
query9	9077	2460	2459	2459
query10	507	274	265	265
query11	18236	14934	15441	14934
query12	157	106	105	105
query13	1582	415	390	390
query14	11350	7399	7419	7399
query15	237	177	176	176
query16	7558	468	448	448
query17	1151	559	581	559
query18	1993	337	298	298
query19	277	155	156	155
query20	119	110	112	110
query21	207	127	112	112
query22	4636	4394	4522	4394
query23	34328	33537	33387	33387
query24	5942	2844	2885	2844
query25	527	380	377	377
query26	685	161	151	151
query27	1789	290	280	280
query28	3899	2016	2034	2016
query29	686	410	401	401
query30	228	156	155	155
query31	935	756	737	737
query32	82	55	56	55
query33	453	301	297	297
query34	881	470	479	470
query35	871	725	703	703
query36	1070	942	910	910
query37	136	82	82	82
query38	3941	3952	3942	3942
query39	1446	1406	1386	1386
query40	205	116	119	116
query41	47	47	44	44
query42	119	98	96	96
query43	509	462	454	454
query44	1108	748	758	748
query45	194	165	168	165
query46	1107	758	735	735
query47	1878	1788	1813	1788
query48	365	289	294	289
query49	766	428	429	428
query50	841	417	425	417
query51	7185	6984	6936	6936
query52	100	89	87	87
query53	263	181	176	176
query54	558	446	458	446
query55	76	77	82	77
query56	271	260	278	260
query57	1179	1048	1082	1048
query58	222	218	236	218
query59	2979	2821	2797	2797
query60	301	268	276	268
query61	103	100	99	99
query62	759	659	661	659
query63	219	186	178	178
query64	4120	2318	1882	1882
query65	3265	3201	3241	3201
query66	661	340	337	337
query67	15569	15267	15320	15267
query68	2975	586	603	586
query69	402	278	282	278
query70	1193	1118	1054	1054
query71	371	285	284	284
query72	2616	2137	2071	2071
query73	715	322	330	322
query74	9305	8795	8745	8745
query75	3372	2704	2672	2672
query76	1397	1013	995	995
query77	527	324	325	324
query78	10538	9420	9003	9003
query79	1037	537	535	535
query80	681	496	495	495
query81	513	239	232	232
query82	299	140	135	135
query83	176	158	160	158
query84	256	86	83	83
query85	784	306	286	286
query86	317	292	303	292
query87	4411	4294	4318	4294
query88	2987	2394	2386	2386
query89	376	297	285	285
query90	1901	206	200	200
query91	121	96	103	96
query92	59	51	55	51
query93	1036	536	529	529
query94	707	299	284	284
query95	316	272	268	268
query96	593	273	278	273
query97	3211	3109	3103	3103
query98	219	205	205	205
query99	1526	1277	1272	1272
Total cold run time: 304935 ms
Total hot run time: 192189 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.04
query2	0.08	0.04	0.04
query3	0.24	0.05	0.06
query4	1.66	0.07	0.08
query5	0.51	0.51	0.51
query6	1.13	0.73	0.74
query7	0.01	0.01	0.01
query8	0.05	0.04	0.05
query9	0.55	0.48	0.50
query10	0.55	0.55	0.53
query11	0.17	0.12	0.11
query12	0.15	0.12	0.12
query13	0.61	0.59	0.59
query14	0.78	0.79	0.79
query15	0.88	0.82	0.84
query16	0.37	0.37	0.37
query17	1.04	1.05	1.07
query18	0.20	0.21	0.21
query19	1.95	1.90	1.74
query20	0.01	0.01	0.02
query21	15.39	0.67	0.67
query22	4.85	7.55	1.40
query23	18.26	1.39	1.21
query24	2.12	0.25	0.21
query25	0.15	0.09	0.08
query26	0.26	0.18	0.18
query27	0.07	0.08	0.07
query28	13.25	1.01	1.00
query29	12.61	3.39	3.36
query30	0.24	0.06	0.05
query31	2.88	0.42	0.40
query32	3.23	0.48	0.46
query33	3.00	3.02	3.02
query34	17.13	4.45	4.38
query35	4.52	4.43	4.44
query36	0.66	0.47	0.50
query37	0.19	0.16	0.15
query38	0.16	0.15	0.15
query39	0.04	0.04	0.04
query40	0.16	0.13	0.13
query41	0.10	0.05	0.05
query42	0.06	0.05	0.06
query43	0.05	0.05	0.04
Total cold run time: 110.37 s
Total hot run time: 30.31 s

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17611	4355	4331	4331
q2	2022	184	179	179
q3	11822	909	1172	909
q4	10510	741	730	730
q5	7764	2840	2801	2801
q6	228	138	140	138
q7	974	628	607	607
q8	9333	2062	2108	2062
q9	7204	6485	6507	6485
q10	6988	2188	2145	2145
q11	476	253	254	253
q12	394	227	229	227
q13	18797	3023	3050	3023
q14	281	249	243	243
q15	519	483	501	483
q16	501	397	392	392
q17	990	728	718	718
q18	7312	6752	6759	6752
q19	1390	964	1156	964
q20	674	343	331	331
q21	4402	3168	2865	2865
q22	1127	1032	1049	1032
Total cold run time: 111319 ms
Total hot run time: 37670 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4357	4246	4297	4246
q2	379	278	267	267
q3	2859	2620	2619	2619
q4	1926	1673	1638	1638
q5	5586	5653	5695	5653
q6	223	141	136	136
q7	2216	1804	1801	1801
q8	3288	3422	3458	3422
q9	8946	8889	8879	8879
q10	3585	3456	3351	3351
q11	615	515	516	515
q12	855	656	651	651
q13	14464	3170	3243	3170
q14	311	292	308	292
q15	536	511	507	507
q16	495	429	435	429
q17	1854	1575	1527	1527
q18	8058	7877	7831	7831
q19	1745	1578	1575	1575
q20	2162	1903	1920	1903
q21	5741	5623	5509	5509
q22	1136	1071	1025	1025
Total cold run time: 71337 ms
Total hot run time: 56946 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192254 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 85e79aa6b8d6838511783de92c7b1f711ffa1bb5, data reload: false

query1	1275	908	871	871
query2	6321	2040	1950	1950
query3	10606	3945	3879	3879
query4	60200	23932	23114	23114
query5	5482	515	509	509
query6	433	169	178	169
query7	5900	296	304	296
query8	297	209	224	209
query9	8719	2451	2441	2441
query10	499	276	265	265
query11	17957	15082	15329	15082
query12	164	108	104	104
query13	1552	402	411	402
query14	11244	6990	7451	6990
query15	233	169	171	169
query16	7710	468	414	414
query17	1215	596	577	577
query18	2066	312	296	296
query19	285	146	163	146
query20	121	107	113	107
query21	203	101	106	101
query22	4754	4354	4398	4354
query23	34162	33743	33535	33535
query24	5922	2929	2914	2914
query25	525	377	405	377
query26	689	165	167	165
query27	1765	289	289	289
query28	3870	2037	2010	2010
query29	696	411	413	411
query30	239	150	145	145
query31	934	761	758	758
query32	84	55	56	55
query33	471	307	299	299
query34	880	489	490	489
query35	848	743	731	731
query36	1056	954	918	918
query37	143	84	86	84
query38	3969	3866	3887	3866
query39	1454	1431	1415	1415
query40	205	123	118	118
query41	50	48	48	48
query42	122	102	101	101
query43	531	484	464	464
query44	1133	754	754	754
query45	204	170	174	170
query46	1117	774	746	746
query47	1871	1796	1787	1787
query48	390	303	303	303
query49	787	444	455	444
query50	839	434	427	427
query51	7141	7009	7056	7009
query52	109	97	95	95
query53	266	187	182	182
query54	584	479	469	469
query55	81	81	84	81
query56	304	278	270	270
query57	1172	1076	1101	1076
query58	257	251	238	238
query59	3029	2995	2801	2801
query60	309	284	288	284
query61	131	126	122	122
query62	755	651	648	648
query63	235	202	196	196
query64	3610	2001	1871	1871
query65	3199	3181	3136	3136
query66	675	348	351	348
query67	15468	15330	15137	15137
query68	3290	574	590	574
query69	403	292	287	287
query70	1126	1058	1122	1058
query71	385	297	286	286
query72	6095	2448	2252	2252
query73	796	325	330	325
query74	9125	8762	8779	8762
query75	3381	2699	2721	2699
query76	1485	1011	957	957
query77	558	318	321	318
query78	10003	9137	9038	9038
query79	2337	550	537	537
query80	910	527	522	522
query81	557	231	227	227
query82	410	137	135	135
query83	224	146	150	146
query84	262	77	111	77
query85	978	294	292	292
query86	416	292	297	292
query87	4405	4346	4280	4280
query88	4189	2393	2384	2384
query89	393	289	291	289
query90	2030	201	198	198
query91	129	105	99	99
query92	61	52	50	50
query93	2313	563	559	559
query94	991	302	285	285
query95	360	277	272	272
query96	631	273	275	273
query97	3208	3083	3109	3083
query98	221	206	204	204
query99	1547	1309	1263	1263
Total cold run time: 312736 ms
Total hot run time: 192254 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.05
query2	0.08	0.04	0.04
query3	0.22	0.05	0.04
query4	1.68	0.08	0.07
query5	0.50	0.49	0.48
query6	1.13	0.73	0.72
query7	0.02	0.01	0.02
query8	0.05	0.04	0.05
query9	0.56	0.48	0.49
query10	0.53	0.55	0.51
query11	0.16	0.12	0.12
query12	0.15	0.12	0.12
query13	0.61	0.59	0.59
query14	0.77	0.80	0.78
query15	0.88	0.82	0.81
query16	0.35	0.36	0.40
query17	1.02	0.97	1.06
query18	0.22	0.20	0.20
query19	1.96	1.85	1.86
query20	0.01	0.02	0.01
query21	15.39	0.67	0.66
query22	4.72	7.57	1.54
query23	18.34	1.41	1.37
query24	2.10	0.22	0.23
query25	0.14	0.09	0.08
query26	0.27	0.18	0.17
query27	0.08	0.08	0.08
query28	13.26	1.02	1.00
query29	12.61	3.35	3.33
query30	0.24	0.06	0.06
query31	2.88	0.40	0.39
query32	3.26	0.47	0.47
query33	2.94	2.98	3.05
query34	17.01	4.38	4.42
query35	4.46	4.43	4.47
query36	0.66	0.46	0.48
query37	0.20	0.17	0.16
query38	0.16	0.15	0.15
query39	0.05	0.03	0.04
query40	0.17	0.13	0.13
query41	0.09	0.05	0.04
query42	0.06	0.04	0.05
query43	0.05	0.04	0.04
Total cold run time: 110.08 s
Total hot run time: 30.45 s

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17635	4884	4290	4290
q2	2034	185	177	177
q3	11924	965	1115	965
q4	10518	711	771	711
q5	7742	2845	2826	2826
q6	225	136	132	132
q7	954	618	590	590
q8	9333	2045	2059	2045
q9	7058	6536	6494	6494
q10	7024	2180	2233	2180
q11	564	253	252	252
q12	395	228	226	226
q13	18039	3015	3012	3012
q14	283	231	236	231
q15	516	478	495	478
q16	477	394	390	390
q17	979	601	737	601
q18	7254	6802	6837	6802
q19	1385	1068	1072	1068
q20	669	343	325	325
q21	4017	3122	3171	3122
q22	1135	1028	1041	1028
Total cold run time: 110160 ms
Total hot run time: 37945 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4361	4408	4268	4268
q2	384	275	261	261
q3	2916	2689	2706	2689
q4	1933	1671	1691	1671
q5	5578	5627	5695	5627
q6	229	133	132	132
q7	2231	1816	1826	1816
q8	3276	3387	3429	3387
q9	8822	8835	8824	8824
q10	3613	3405	3379	3379
q11	629	515	504	504
q12	838	652	645	645
q13	15765	3164	3209	3164
q14	312	286	292	286
q15	523	492	482	482
q16	485	434	438	434
q17	1823	1542	1537	1537
q18	8016	7815	7842	7815
q19	1703	1440	1496	1440
q20	2138	1930	1916	1916
q21	5828	5541	5660	5541
q22	1166	1051	1027	1027
Total cold run time: 72569 ms
Total hot run time: 56845 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 191480 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 85e79aa6b8d6838511783de92c7b1f711ffa1bb5, data reload: false

query1	1237	885	872	872
query2	6253	1935	1881	1881
query3	10754	4092	4102	4092
query4	60475	26869	23047	23047
query5	5401	510	491	491
query6	406	164	163	163
query7	5777	299	288	288
query8	287	214	223	214
query9	8975	2451	2471	2451
query10	485	290	276	276
query11	18300	15019	15448	15019
query12	161	106	104	104
query13	1593	420	400	400
query14	10649	7376	7278	7278
query15	245	172	173	172
query16	7552	470	505	470
query17	1118	563	581	563
query18	2015	304	277	277
query19	274	146	151	146
query20	118	112	122	112
query21	206	104	101	101
query22	4759	4412	4388	4388
query23	34734	33230	33544	33230
query24	5980	2756	2791	2756
query25	518	372	391	372
query26	676	154	155	154
query27	1775	281	282	281
query28	3865	2055	2025	2025
query29	683	407	398	398
query30	223	156	157	156
query31	927	773	765	765
query32	88	56	57	56
query33	438	298	286	286
query34	848	475	476	475
query35	831	714	723	714
query36	1065	898	959	898
query37	146	87	82	82
query38	3924	3825	3794	3794
query39	1479	1391	1397	1391
query40	202	122	119	119
query41	49	47	47	47
query42	115	100	141	100
query43	531	492	474	474
query44	1118	748	754	748
query45	193	167	162	162
query46	1066	760	757	757
query47	1855	1820	1826	1820
query48	378	297	292	292
query49	756	420	430	420
query50	818	408	407	407
query51	7141	6924	7127	6924
query52	102	86	91	86
query53	254	183	179	179
query54	564	461	464	461
query55	79	78	76	76
query56	281	260	257	257
query57	1151	1072	1069	1069
query58	221	235	246	235
query59	2968	2887	2850	2850
query60	292	272	302	272
query61	105	103	102	102
query62	733	649	636	636
query63	206	181	185	181
query64	3158	1769	1744	1744
query65	3204	3144	3166	3144
query66	605	322	338	322
query67	15342	15311	15157	15157
query68	3004	587	573	573
query69	396	296	276	276
query70	1201	1039	1113	1039
query71	335	275	277	275
query72	2641	2075	2097	2075
query73	706	325	331	325
query74	9078	8784	8819	8784
query75	3301	2684	2730	2684
query76	1375	957	983	957
query77	545	323	316	316
query78	9572	9002	9034	9002
query79	1028	542	528	528
query80	661	519	508	508
query81	529	235	225	225
query82	286	135	137	135
query83	169	146	149	146
query84	254	75	83	75
query85	682	283	289	283
query86	314	307	307	307
query87	4314	4367	4405	4367
query88	3075	2479	2388	2388
query89	389	288	284	284
query90	1972	197	198	197
query91	138	113	114	113
query92	60	53	60	53
query93	1026	535	620	535
query94	662	299	293	293
query95	314	265	266	265
query96	581	275	273	273
query97	3203	3054	3078	3054
query98	218	205	195	195
query99	1523	1287	1271	1271
Total cold run time: 302279 ms
Total hot run time: 191480 ms

@doris-robot
Copy link

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

query1	0.04	0.05	0.04
query2	0.08	0.04	0.04
query3	0.22	0.05	0.05
query4	1.67	0.07	0.07
query5	0.50	0.47	0.48
query6	1.12	0.73	0.75
query7	0.02	0.01	0.02
query8	0.06	0.05	0.05
query9	0.55	0.48	0.48
query10	0.54	0.53	0.54
query11	0.15	0.12	0.12
query12	0.15	0.12	0.12
query13	0.61	0.59	0.58
query14	0.77	0.79	0.78
query15	0.86	0.81	0.82
query16	0.38	0.38	0.35
query17	1.06	0.98	1.06
query18	0.22	0.20	0.23
query19	1.90	1.86	1.85
query20	0.02	0.01	0.01
query21	15.40	0.67	0.66
query22	3.58	8.20	1.79
query23	18.27	1.40	1.31
query24	2.13	0.23	0.22
query25	0.16	0.08	0.08
query26	0.26	0.18	0.17
query27	0.08	0.07	0.08
query28	13.23	1.04	1.02
query29	12.61	3.32	3.29
query30	0.24	0.06	0.05
query31	2.88	0.40	0.38
query32	3.27	0.47	0.47
query33	2.95	3.02	3.03
query34	17.08	4.39	4.40
query35	4.46	4.43	4.47
query36	0.66	0.47	0.52
query37	0.20	0.16	0.16
query38	0.15	0.16	0.15
query39	0.04	0.04	0.04
query40	0.15	0.13	0.13
query41	0.10	0.06	0.05
query42	0.06	0.05	0.04
query43	0.04	0.04	0.05
Total cold run time: 108.92 s
Total hot run time: 30.7 s

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17611	4304	4268	4268
q2	2022	186	176	176
q3	11849	938	1126	938
q4	10517	736	663	663
q5	7774	2783	2825	2783
q6	222	136	137	136
q7	981	607	602	602
q8	9520	2055	2063	2055
q9	7292	6486	6541	6486
q10	6996	2267	2247	2247
q11	464	243	246	243
q12	390	220	223	220
q13	18898	3013	2988	2988
q14	286	236	241	236
q15	524	478	488	478
q16	499	404	385	385
q17	977	659	706	659
q18	7265	6821	6928	6821
q19	1381	959	1042	959
q20	665	339	334	334
q21	4141	3053	2821	2821
q22	1096	1023	1018	1018
Total cold run time: 111370 ms
Total hot run time: 37516 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4311	4239	4238	4238
q2	377	273	264	264
q3	2885	2656	2630	2630
q4	1928	1659	1723	1659
q5	5569	5638	5691	5638
q6	235	133	134	133
q7	2235	1755	1796	1755
q8	3285	3400	3440	3400
q9	8807	8816	8818	8816
q10	3573	3370	3364	3364
q11	601	524	529	524
q12	808	641	654	641
q13	12597	3264	3228	3228
q14	326	304	287	287
q15	534	484	510	484
q16	501	438	449	438
q17	1816	1516	1533	1516
q18	8011	7719	7823	7719
q19	1731	1540	1600	1540
q20	2148	1879	1894	1879
q21	5626	5524	5471	5471
q22	1204	1109	1022	1022
Total cold run time: 69108 ms
Total hot run time: 56646 ms

@doris-robot
Copy link

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

query1	1242	870	857	857
query2	6263	1987	1858	1858
query3	10600	4023	3961	3961
query4	59267	23727	23193	23193
query5	5448	496	494	494
query6	407	163	160	160
query7	5793	291	305	291
query8	292	212	209	209
query9	9067	2440	2458	2440
query10	502	277	270	270
query11	17945	15118	15352	15118
query12	160	103	111	103
query13	1580	409	400	400
query14	10945	7345	7237	7237
query15	225	171	173	171
query16	7488	490	427	427
query17	1138	584	595	584
query18	1880	333	299	299
query19	290	156	151	151
query20	118	113	112	112
query21	203	103	103	103
query22	4434	4434	4485	4434
query23	34345	33541	33457	33457
query24	5950	2942	2820	2820
query25	539	389	418	389
query26	681	160	160	160
query27	1762	285	284	284
query28	3652	2027	2022	2022
query29	674	418	419	418
query30	210	151	148	148
query31	950	762	748	748
query32	78	56	56	56
query33	432	298	291	291
query34	867	477	489	477
query35	847	723	707	707
query36	1052	941	917	917
query37	145	83	80	80
query38	4013	3844	3896	3844
query39	1444	1361	1414	1361
query40	206	128	118	118
query41	48	48	45	45
query42	111	97	95	95
query43	506	483	484	483
query44	1110	749	759	749
query45	194	167	166	166
query46	1076	748	736	736
query47	1894	1763	1820	1763
query48	364	302	302	302
query49	776	430	446	430
query50	828	409	420	409
query51	7144	7083	7104	7083
query52	102	87	89	87
query53	251	182	180	180
query54	564	461	460	460
query55	79	76	77	76
query56	281	270	263	263
query57	1200	1055	1067	1055
query58	234	232	243	232
query59	3030	2806	2799	2799
query60	388	280	268	268
query61	97	111	94	94
query62	730	634	649	634
query63	210	183	177	177
query64	3061	1718	1757	1718
query65	3184	3125	3126	3125
query66	664	330	330	330
query67	15489	15058	15163	15058
query68	4458	576	559	559
query69	430	299	284	284
query70	1106	1085	1027	1027
query71	405	281	275	275
query72	6454	2284	2073	2073
query73	767	322	325	322
query74	9295	8799	8715	8715
query75	3348	2641	2687	2641
query76	1551	987	995	987
query77	554	317	316	316
query78	10721	9049	9052	9049
query79	2425	536	541	536
query80	1109	484	484	484
query81	539	222	226	222
query82	1227	132	130	130
query83	294	144	142	142
query84	250	72	77	72
query85	891	301	282	282
query86	428	297	309	297
query87	4352	4252	4172	4172
query88	3065	2403	2489	2403
query89	392	282	284	282
query90	1853	194	196	194
query91	125	100	93	93
query92	60	49	56	49
query93	2803	540	537	537
query94	781	295	295	295
query95	352	267	266	266
query96	664	275	270	270
query97	3182	3074	3080	3074
query98	219	203	197	197
query99	1580	1268	1244	1244
Total cold run time: 312429 ms
Total hot run time: 191475 ms

@doris-robot
Copy link

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

query1	0.04	0.05	0.04
query2	0.08	0.04	0.04
query3	0.22	0.05	0.06
query4	1.66	0.08	0.09
query5	0.50	0.50	0.48
query6	1.12	0.72	0.73
query7	0.02	0.01	0.01
query8	0.05	0.04	0.05
query9	0.54	0.49	0.47
query10	0.54	0.55	0.54
query11	0.15	0.12	0.11
query12	0.14	0.12	0.11
query13	0.62	0.59	0.58
query14	0.76	0.80	0.77
query15	0.88	0.81	0.82
query16	0.34	0.35	0.38
query17	0.99	1.03	1.05
query18	0.22	0.21	0.21
query19	1.82	1.72	1.73
query20	0.01	0.01	0.01
query21	15.77	0.66	0.66
query22	4.91	6.29	2.01
query23	18.28	1.39	1.27
query24	2.11	0.22	0.22
query25	0.16	0.08	0.08
query26	0.27	0.18	0.18
query27	0.08	0.07	0.08
query28	13.26	1.01	1.00
query29	12.65	3.33	3.30
query30	0.24	0.06	0.05
query31	2.88	0.40	0.39
query32	3.27	0.48	0.47
query33	2.97	2.95	3.01
query34	16.95	4.40	4.37
query35	4.45	4.43	4.48
query36	0.66	0.48	0.48
query37	0.19	0.15	0.16
query38	0.16	0.15	0.14
query39	0.05	0.04	0.04
query40	0.16	0.13	0.12
query41	0.10	0.05	0.05
query42	0.06	0.05	0.04
query43	0.05	0.04	0.04
Total cold run time: 110.38 s
Total hot run time: 30.68 s

@Yukang-Lian
Copy link
Collaborator Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17613	4612	4241	4241
q2	2019	195	183	183
q3	11779	965	1164	965
q4	10514	810	651	651
q5	7745	2825	2820	2820
q6	222	136	137	136
q7	970	617	595	595
q8	9533	2067	2053	2053
q9	7909	6514	6520	6514
q10	6993	2165	2186	2165
q11	456	242	240	240
q12	388	231	230	230
q13	17791	3047	3018	3018
q14	290	245	237	237
q15	520	474	488	474
q16	507	417	399	399
q17	979	668	740	668
q18	7309	6771	6849	6771
q19	1389	1110	1010	1010
q20	701	341	340	340
q21	3895	3012	3008	3008
q22	1146	1032	1019	1019
Total cold run time: 110668 ms
Total hot run time: 37737 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4336	4320	4272	4272
q2	385	270	269	269
q3	2887	2634	2644	2634
q4	1931	1675	1676	1675
q5	5598	5676	5709	5676
q6	227	142	137	137
q7	2236	1868	1828	1828
q8	3289	3478	3475	3475
q9	8932	8837	8825	8825
q10	3641	3414	3336	3336
q11	617	504	501	501
q12	824	689	661	661
q13	13074	3166	3282	3166
q14	321	304	313	304
q15	537	483	489	483
q16	515	457	436	436
q17	1824	1525	1525	1525
q18	8052	7711	7762	7711
q19	1755	1628	1550	1550
q20	2160	1945	1897	1897
q21	5735	5460	5360	5360
q22	1125	1061	1058	1058
Total cold run time: 70001 ms
Total hot run time: 56779 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 192231 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 66698bd9ba346686e7241eca861100c3628abafa, data reload: false

query1	1275	897	872	872
query2	6330	1979	1859	1859
query3	10735	4148	3967	3967
query4	60325	26330	23278	23278
query5	5523	492	503	492
query6	406	163	159	159
query7	5852	292	293	292
query8	285	208	213	208
query9	9028	2508	2477	2477
query10	502	268	259	259
query11	17848	15126	15421	15126
query12	154	101	98	98
query13	1579	396	391	391
query14	11160	7299	7395	7299
query15	231	176	177	176
query16	7102	472	467	467
query17	1130	567	555	555
query18	1932	309	294	294
query19	282	148	148	148
query20	128	117	120	117
query21	206	102	105	102
query22	4621	4321	4636	4321
query23	34375	33590	34148	33590
query24	5898	2897	2811	2811
query25	511	403	399	399
query26	680	159	158	158
query27	1763	290	298	290
query28	3709	2051	2025	2025
query29	658	432	432	432
query30	239	156	154	154
query31	927	784	760	760
query32	79	58	57	57
query33	447	337	285	285
query34	835	480	495	480
query35	821	737	719	719
query36	1063	918	926	918
query37	151	79	77	77
query38	3977	3939	3809	3809
query39	1433	1399	1394	1394
query40	199	117	112	112
query41	47	45	46	45
query42	111	96	98	96
query43	512	466	462	462
query44	1088	745	735	735
query45	198	165	164	164
query46	1080	762	757	757
query47	1909	1840	1812	1812
query48	371	289	295	289
query49	770	424	452	424
query50	822	416	436	416
query51	7174	7028	7077	7028
query52	101	90	86	86
query53	255	179	184	179
query54	568	458	471	458
query55	79	76	78	76
query56	283	244	250	244
query57	1164	1126	1068	1068
query58	215	230	242	230
query59	2905	2804	2674	2674
query60	305	271	275	271
query61	101	98	96	96
query62	763	659	668	659
query63	213	186	190	186
query64	3648	2084	1757	1757
query65	3171	3150	3154	3150
query66	644	335	335	335
query67	15498	15388	15395	15388
query68	3036	587	577	577
query69	404	291	283	283
query70	1145	1123	1118	1118
query71	389	273	275	273
query72	2484	2057	2073	2057
query73	703	320	323	320
query74	9136	8832	8755	8755
query75	3325	2706	2743	2706
query76	1460	1036	955	955
query77	559	330	311	311
query78	9670	9049	9481	9049
query79	1030	554	522	522
query80	685	523	502	502
query81	455	224	220	220
query82	296	145	139	139
query83	168	144	146	144
query84	252	78	76	76
query85	675	298	284	284
query86	300	297	303	297
query87	4355	4222	4252	4222
query88	3050	2353	2350	2350
query89	380	293	286	286
query90	1767	198	198	198
query91	123	100	100	100
query92	59	122	52	52
query93	1058	539	533	533
query94	559	304	304	304
query95	347	273	271	271
query96	586	270	273	270
query97	3220	3105	3118	3105
query98	216	206	197	197
query99	1507	1243	1281	1243
Total cold run time: 301793 ms
Total hot run time: 192231 ms

@doris-robot
Copy link

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

query1	0.05	0.04	0.04
query2	0.08	0.04	0.04
query3	0.24	0.05	0.05
query4	1.66	0.08	0.09
query5	0.50	0.48	0.50
query6	1.13	0.73	0.73
query7	0.02	0.02	0.02
query8	0.05	0.05	0.05
query9	0.54	0.49	0.50
query10	0.53	0.54	0.53
query11	0.17	0.12	0.11
query12	0.14	0.12	0.12
query13	0.61	0.59	0.60
query14	0.76	0.81	0.77
query15	0.88	0.82	0.83
query16	0.38	0.37	0.38
query17	1.06	1.04	1.04
query18	0.23	0.21	0.21
query19	1.95	1.78	1.78
query20	0.01	0.01	0.02
query21	15.41	0.67	0.66
query22	4.61	7.06	1.88
query23	18.22	1.40	1.33
query24	2.07	0.23	0.23
query25	0.16	0.08	0.08
query26	0.27	0.19	0.19
query27	0.08	0.08	0.08
query28	13.28	1.03	1.01
query29	12.64	3.40	3.38
query30	0.24	0.06	0.06
query31	2.87	0.40	0.39
query32	3.25	0.48	0.48
query33	3.00	3.00	2.97
query34	17.07	4.41	4.41
query35	4.55	4.45	4.48
query36	0.65	0.46	0.50
query37	0.20	0.16	0.16
query38	0.16	0.15	0.15
query39	0.04	0.03	0.04
query40	0.15	0.13	0.14
query41	0.08	0.04	0.04
query42	0.05	0.06	0.06
query43	0.04	0.04	0.04
Total cold run time: 110.08 s
Total hot run time: 31 s

@Yukang-Lian
Copy link
Collaborator Author

run feut

dataroaring
dataroaring approved these changes Aug 26, 2024
View reviewed changes
Copy link
Contributor

@dataroaring dataroaring left a comment

Choose a reason for hiding this comment

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

LGTM

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Aug 26, 2024
@github-actions GitHub Actions
Copy link
Contributor

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

@Yukang-Lian
Copy link
Collaborator Author

run feut

@dataroaring dataroaring merged commit d91a6c9 into apache:master Aug 28, 2024
28 of 30 checks passed
dataroaring pushed a commit that referenced this pull request Aug 28, 2024
@Yukang-Lian @dataroaring
[Fix](group commit) Fix table not found fault when disable group comm…
0d6cd53 
…it (#39731)

## Proposed changes

<!--Describe your changes.-->

selectRedirectBackend param table id is only needed by group commit. In
non group commit mode, if table id is null, we need to ignore it.
Yukang-Lian added a commit to Yukang-Lian/doris that referenced this pull request Sep 3, 2024
@Yukang-Lian
[Fix](group commit) Fix table not found fault when disable group comm…
7108b23 
…it (apache#39731)

<!--Describe your changes.-->

selectRedirectBackend param table id is only needed by group commit. In
non group commit mode, if table id is null, we need to ignore it.
@Yukang-Lian Yukang-Lian mentioned this pull request Sep 3, 2024
Merged
yiguolei pushed a commit to Yukang-Lian/doris that referenced this pull request Sep 5, 2024
@Yukang-Lian @yiguolei
[Fix](group commit) Fix table not found fault when disable group comm…
d03917f 
…it (apache#39731)

<!--Describe your changes.-->

selectRedirectBackend param table id is only needed by group commit. In
non group commit mode, if table id is null, we need to ignore it.
yiguolei pushed a commit that referenced this pull request Sep 5, 2024
@Yukang-Lian
[cherry-pick](branch-2.1) Pick "[Fix](group commit) Fix table not fou…
88750e7 
…nd fault when disable group commit (#39731)" (#40323)

<!--Describe your changes.-->

## Proposed changes

Pick #39731 

<!--Describe your changes.-->
@gavinchou gavinchou mentioned this pull request Oct 13, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@dataroaring dataroaring dataroaring approved these changes

@mymeiyi mymeiyi mymeiyi approved these changes

Assignees
No one assigned
Labels
approved Indicates a PR has been approved by one committer. dev/2.1.6-merged dev/3.0.2-merged reviewed
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
5 participants
@Yukang-Lian @doris-robot @mymeiyi @dataroaring @yiguolei