You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yukang-Lian (via GitHub)" <gi...@apache.org> on 2024/03/11 12:05:58 UTC

[PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Yukang-Lian opened a new pull request, #32068:
URL: https://github.com/apache/doris/pull/32068

   Problem: With group commit enabled, connecting to a non-master node and inserting data through subqueries like 'insert into test select 6;' results in the data being inserted in regular insert mode rather than group commit mode.
   
   Reason: An insert into statement with a subquery is forwarded to the master node, and group commit, being a session variable, is not forwarded during this process. This results in the final insert being in the normal insert into mode.
   
   Solution: Make the group commit setting a forwardable variable.
   
   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1988354534

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37928 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e3c39686d64bc006ab6ba3a1293b2877dbd773fc, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17651	4012	4000	4000
   q2	2017	156	140	140
   q3	10551	978	923	923
   q4	4659	931	927	927
   q5	7611	2818	2980	2818
   q6	193	124	126	124
   q7	1296	836	805	805
   q8	9483	2079	2076	2076
   q9	7232	6492	6464	6464
   q10	8229	2565	2572	2565
   q11	422	225	218	218
   q12	775	328	309	309
   q13	17975	2987	2983	2983
   q14	278	255	261	255
   q15	527	472	452	452
   q16	476	388	403	388
   q17	944	865	869	865
   q18	6646	5887	5927	5887
   q19	1560	1516	1512	1512
   q20	574	290	279	279
   q21	7533	3694	3644	3644
   q22	812	325	294	294
   Total cold run time: 107444 ms
   Total hot run time: 37928 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4001	3999	3998	3998
   q2	313	226	236	226
   q3	2944	2937	2894	2894
   q4	1870	1779	1824	1779
   q5	5247	5230	5229	5229
   q6	200	118	117	117
   q7	2253	1859	1850	1850
   q8	3180	3235	3225	3225
   q9	8541	8512	8470	8470
   q10	6111	3763	3700	3700
   q11	534	444	457	444
   q12	692	562	561	561
   q13	11676	2827	2820	2820
   q14	279	252	270	252
   q15	480	460	450	450
   q16	460	407	410	407
   q17	1684	1664	1665	1664
   q18	7844	7468	7225	7225
   q19	1643	1598	1612	1598
   q20	1871	1682	1724	1682
   q21	5032	4718	4890	4718
   q22	516	446	433	433
   Total cold run time: 67371 ms
   Total hot run time: 53742 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Do not forward to master when enable group commit [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1991513080

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186297 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 173eafc92db66016768f055b8a6ca1a602fa24d1, data reload: false
   
   query1	925	354	345	345
   query2	7427	2000	1936	1936
   query3	6702	218	217	217
   query4	31273	20676	20454	20454
   query5	4297	392	419	392
   query6	266	177	187	177
   query7	4626	296	285	285
   query8	222	165	166	165
   query9	9862	2238	2209	2209
   query10	470	236	244	236
   query11	14554	14148	14023	14023
   query12	131	86	114	86
   query13	1644	429	433	429
   query14	10893	10582	10722	10582
   query15	234	231	200	200
   query16	7919	259	255	255
   query17	1941	545	522	522
   query18	2027	277	264	264
   query19	200	150	147	147
   query20	93	79	86	79
   query21	200	127	119	119
   query22	4692	4392	4447	4392
   query23	31618	31126	31071	31071
   query24	10982	2794	2790	2790
   query25	640	377	377	377
   query26	1300	155	157	155
   query27	3001	358	347	347
   query28	8114	1886	1839	1839
   query29	914	646	621	621
   query30	306	160	148	148
   query31	979	733	734	733
   query32	95	59	56	56
   query33	759	255	248	248
   query34	1095	458	468	458
   query35	840	612	607	607
   query36	973	872	881	872
   query37	146	78	79	78
   query38	3280	3177	3103	3103
   query39	1413	1381	1395	1381
   query40	205	148	108	108
   query41	51	47	46	46
   query42	105	96	100	96
   query43	495	442	459	442
   query44	1244	714	715	714
   query45	268	265	254	254
   query46	1072	683	694	683
   query47	1651	1570	1615	1570
   query48	429	352	353	352
   query49	1144	347	327	327
   query50	742	361	369	361
   query51	6795	6797	6645	6645
   query52	106	86	95	86
   query53	340	273	275	273
   query54	307	241	247	241
   query55	90	82	78	78
   query56	241	226	237	226
   query57	1094	1012	1011	1011
   query58	230	200	219	200
   query59	2788	2752	2695	2695
   query60	287	253	247	247
   query61	113	111	112	111
   query62	583	401	409	401
   query63	292	274	275	274
   query64	5619	3964	3931	3931
   query65	3035	2999	2986	2986
   query66	867	337	332	332
   query67	14859	14480	14261	14261
   query68	9365	533	531	531
   query69	653	390	383	383
   query70	1389	1130	1130	1130
   query71	537	282	282	282
   query72	7007	2646	2479	2479
   query73	1614	317	317	317
   query74	7738	6579	6540	6540
   query75	9594	8013	7958	7958
   query76	5555	797	957	797
   query77	660	258	252	252
   query78	10141	9540	9600	9540
   query79	11131	522	505	505
   query80	2283	383	378	378
   query81	490	207	216	207
   query82	347	203	196	196
   query83	247	145	142	142
   query84	282	76	76	76
   query85	1239	318	310	310
   query86	347	285	298	285
   query87	3387	3313	3232	3232
   query88	5261	2238	2240	2238
   query89	477	367	355	355
   query90	2421	175	172	172
   query91	163	134	128	128
   query92	63	47	47	47
   query93	6942	491	472	472
   query94	1529	174	176	174
   query95	435	336	326	326
   query96	602	287	262	262
   query97	4380	4271	4282	4271
   query98	233	225	219	219
   query99	962	803	744	744
   Total cold run time: 319579 ms
   Total hot run time: 186297 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1988376439

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186374 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit e3c39686d64bc006ab6ba3a1293b2877dbd773fc, data reload: false
   
   query1	910	341	340	340
   query2	7378	2026	1911	1911
   query3	6720	220	215	215
   query4	24393	20859	20918	20859
   query5	4277	445	2426	445
   query6	268	178	178	178
   query7	4638	320	309	309
   query8	237	172	161	161
   query9	8427	2261	2294	2261
   query10	457	242	251	242
   query11	14977	14480	14380	14380
   query12	133	90	89	89
   query13	1654	432	456	432
   query14	11164	9941	10398	9941
   query15	232	200	199	199
   query16	7850	272	270	270
   query17	1884	592	571	571
   query18	2119	294	283	283
   query19	201	170	169	169
   query20	114	87	92	87
   query21	209	131	126	126
   query22	4608	4457	4479	4457
   query23	31476	31071	30848	30848
   query24	10468	3056	3040	3040
   query25	656	387	389	387
   query26	1123	167	170	167
   query27	2425	377	356	356
   query28	6232	1840	1811	1811
   query29	973	628	576	576
   query30	302	146	158	146
   query31	907	715	729	715
   query32	103	58	55	55
   query33	754	266	252	252
   query34	1059	454	493	454
   query35	852	632	627	627
   query36	921	806	822	806
   query37	123	73	76	73
   query38	3262	3157	3197	3157
   query39	1405	1407	1383	1383
   query40	201	112	114	112
   query41	64	62	61	61
   query42	101	99	110	99
   query43	424	407	411	407
   query44	1055	698	698	698
   query45	262	241	251	241
   query46	1056	781	738	738
   query47	1599	1564	1569	1564
   query48	419	352	341	341
   query49	1123	331	323	323
   query50	780	376	379	376
   query51	6729	6639	6644	6639
   query52	101	94	101	94
   query53	347	280	288	280
   query54	283	236	242	236
   query55	89	85	86	85
   query56	239	234	235	234
   query57	1065	1003	1002	1002
   query58	236	210	220	210
   query59	2446	2249	2359	2249
   query60	264	235	248	235
   query61	99	96	96	96
   query62	649	421	408	408
   query63	302	278	283	278
   query64	5048	3471	3196	3196
   query65	3012	3038	3019	3019
   query66	848	331	332	331
   query67	15090	14323	14381	14323
   query68	5165	573	564	564
   query69	561	385	382	382
   query70	1167	1111	1132	1111
   query71	475	289	283	283
   query72	6450	2816	2656	2656
   query73	715	327	325	325
   query74	6848	6573	6515	6515
   query75	8860	8056	8025	8025
   query76	3470	1070	1150	1070
   query77	446	277	265	265
   query78	10381	9651	9514	9514
   query79	8936	520	517	517
   query80	2110	411	402	402
   query81	561	215	216	215
   query82	1339	194	197	194
   query83	269	149	145	145
   query84	288	76	80	76
   query85	1942	323	322	322
   query86	491	278	278	278
   query87	3451	3245	3245	3245
   query88	4393	2341	2337	2337
   query89	550	359	356	356
   query90	2017	181	178	178
   query91	156	126	133	126
   query92	62	49	53	49
   query93	6428	543	521	521
   query94	1233	189	189	189
   query95	449	341	355	341
   query96	597	259	260	259
   query97	4383	4273	4285	4273
   query98	240	214	209	209
   query99	1182	780	779	779
   Total cold run time: 295437 ms
   Total hot run time: 186374 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1988392962

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit e3c39686d64bc006ab6ba3a1293b2877dbd773fc with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       17.8 seconds inserted 10000000 Rows, about 561K ops/s
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Do not forward to master when enable group commit [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1991491952

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 36385 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 173eafc92db66016768f055b8a6ca1a602fa24d1, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17645	4117	4088	4088
   q2	2017	147	142	142
   q3	10587	892	870	870
   q4	4651	662	703	662
   q5	7589	2779	2747	2747
   q6	182	128	125	125
   q7	1172	832	792	792
   q8	9472	2063	2010	2010
   q9	7354	6454	6432	6432
   q10	8201	2513	2483	2483
   q11	434	217	219	217
   q12	703	292	290	290
   q13	17959	2983	3023	2983
   q14	276	250	251	250
   q15	486	451	447	447
   q16	494	389	393	389
   q17	943	515	531	515
   q18	6597	5808	5802	5802
   q19	1548	1374	1433	1374
   q20	537	296	283	283
   q21	7430	3184	3248	3184
   q22	795	300	307	300
   Total cold run time: 107072 ms
   Total hot run time: 36385 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4097	4048	4084	4048
   q2	329	223	222	222
   q3	2957	2806	2830	2806
   q4	1819	1552	1518	1518
   q5	5158	5223	5237	5223
   q6	194	116	116	116
   q7	2242	1835	1851	1835
   q8	3151	3273	3279	3273
   q9	8525	8548	8564	8548
   q10	6097	3638	3697	3638
   q11	518	436	427	427
   q12	726	549	566	549
   q13	13626	2877	2833	2833
   q14	269	256	258	256
   q15	485	450	451	450
   q16	450	411	414	411
   q17	1700	1472	1452	1452
   q18	7700	7134	7074	7074
   q19	6169	1517	1455	1455
   q20	1903	1699	1688	1688
   q21	4896	4646	4683	4646
   q22	527	448	440	440
   Total cold run time: 73538 ms
   Total hot run time: 52908 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1988288946

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Do not forward to master when enable group commit [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1991522314

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.53 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 173eafc92db66016768f055b8a6ca1a602fa24d1, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.06	0.02	0.02
   query3	0.23	0.06	0.06
   query4	1.67	0.10	0.10
   query5	0.52	0.50	0.48
   query6	1.19	0.63	0.62
   query7	0.01	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.55	0.50	0.49
   query10	0.55	0.54	0.53
   query11	0.12	0.08	0.09
   query12	0.11	0.09	0.10
   query13	0.58	0.56	0.56
   query14	0.73	0.76	0.74
   query15	0.80	0.77	0.77
   query16	0.37	0.41	0.42
   query17	0.95	0.95	0.98
   query18	0.20	0.23	0.26
   query19	1.75	1.70	1.68
   query20	0.01	0.00	0.01
   query21	15.40	0.55	0.56
   query22	2.33	1.98	1.91
   query23	17.16	0.77	0.71
   query24	3.06	2.20	2.30
   query25	0.15	0.29	0.18
   query26	0.67	0.12	0.12
   query27	0.04	0.03	0.03
   query28	9.32	0.86	0.88
   query29	12.58	3.21	3.09
   query30	0.69	0.57	0.57
   query31	2.79	0.33	0.35
   query32	3.40	0.44	0.43
   query33	2.79	2.78	2.82
   query34	16.21	4.37	4.31
   query35	4.31	4.31	4.35
   query36	1.06	1.00	0.99
   query37	0.07	0.05	0.06
   query38	0.04	0.03	0.04
   query39	0.03	0.02	0.02
   query40	0.17	0.13	0.13
   query41	0.07	0.02	0.02
   query42	0.02	0.02	0.01
   query43	0.03	0.03	0.02
   Total cold run time: 102.87 s
   Total hot run time: 31.53 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Do not forward to master when enable group commit [doris]

Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1991453613

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Do not forward to master when enable group commit [doris]

Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian closed pull request #32068: [Fix](group commit) Do not forward to master when enable group commit
URL: https://github.com/apache/doris/pull/32068


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1988289053

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Do not forward to master when enable group commit [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1991527718

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 173eafc92db66016768f055b8a6ca1a602fa24d1 with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       17.1 seconds inserted 10000000 Rows, about 584K ops/s
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [Fix](group commit) Make group commit a forwardable variable [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32068:
URL: https://github.com/apache/doris/pull/32068#issuecomment-1988386803

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.68 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e3c39686d64bc006ab6ba3a1293b2877dbd773fc, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.06	0.02	0.02
   query3	0.24	0.06	0.06
   query4	1.68	0.09	0.10
   query5	0.52	0.51	0.49
   query6	1.32	0.67	0.65
   query7	0.02	0.02	0.02
   query8	0.04	0.03	0.03
   query9	0.55	0.53	0.50
   query10	0.56	0.56	0.57
   query11	0.14	0.10	0.10
   query12	0.13	0.10	0.11
   query13	0.58	0.58	0.57
   query14	0.75	0.76	0.75
   query15	0.83	0.80	0.82
   query16	0.40	0.38	0.36
   query17	1.00	1.01	0.98
   query18	0.25	0.27	0.25
   query19	1.81	1.69	1.72
   query20	0.01	0.01	0.02
   query21	15.40	0.62	0.64
   query22	3.10	3.54	2.42
   query23	17.46	0.98	0.89
   query24	2.10	0.41	0.58
   query25	0.24	0.09	0.04
   query26	0.21	0.14	0.15
   query27	0.03	0.04	0.03
   query28	12.18	0.83	0.81
   query29	12.54	3.46	3.21
   query30	0.64	0.57	0.62
   query31	2.79	0.34	0.35
   query32	3.38	0.44	0.44
   query33	2.86	2.88	2.80
   query34	15.60	4.31	4.31
   query35	4.30	4.30	4.31
   query36	1.08	1.03	1.02
   query37	0.06	0.05	0.06
   query38	0.04	0.03	0.03
   query39	0.03	0.02	0.01
   query40	0.16	0.13	0.12
   query41	0.08	0.02	0.02
   query42	0.02	0.02	0.02
   query43	0.03	0.03	0.02
   Total cold run time: 105.26 s
   Total hot run time: 30.68 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org