You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "gavinchou (via GitHub)" <gi...@apache.org> on 2024/06/09 18:44:27 UTC

[PR] [fix](cloud) Fix replication_num properties when create table and MTVM [doris]

gavinchou opened a new pull request, #36080:
URL: https://github.com/apache/doris/pull/36080

   The properties rewrite policy is not applied for CreateTableStmt and CreateMTMVStmt because the `analyze()` of CreateTableStmt is not called when executed by nereids.
   
   There are some properties, e.g. replication_num, are not correctly processed in cloud mode, which will cause the following error
   
   ```
   2024-06-09 02:30:42,602 WARN (mtmv-task-execute-1-thread-1|139) [OlapInsertExecutor.onFail():218] insert [label_87cd2cb386774f4a_a14a00e9c7d93a51] with query id 87cd2cb386774f4a-a14a00e9c7d93a51 failed
   org.apache.doris.nereids.exceptions.AnalysisException: errCode = 3, detailMessage = tablet 469525 alive replica num 1 < load required replica num 2, alive backends: [10002], detail: Visible Replicas:Visible version: 1, Replicas: [replicaId=469526, backendId=-1, backend=null, version=1, state=NORMAL]. or you may not have permission to access the current cluster = gavin_cluster_name0
           at org.apache.doris.nereids.trees.plans.commands.insert.OlapInsertExecutor.finalizeSink(OlapInsertExecutor.java:152) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.initPlan(InsertIntoTableCommand.java:200) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.runInternal(InsertIntoTableCommand.java:219) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.InsertIntoTableCommand.run(InsertIntoTableCommand.java:103) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.runInsertCommand(InsertOverwriteTableCommand.java:185) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.insertInto(InsertOverwriteTableCommand.java:235) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.InsertOverwriteTableCommand.run(InsertOverwriteTableCommand.java:164) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.job.extensions.mtmv.MTMVTask.exec(MTMVTask.java:235) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.job.extensions.mtmv.MTMVTask.run(MTMVTask.java:200) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.job.task.AbstractTask.runTask(AbstractTask.java:167) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.job.extensions.mtmv.MTMVTask.runTask(MTMVTask.java:310) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.job.executor.DefaultTaskExecutorHandler.onEvent(DefaultTaskExecutorHandler.java:50) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.job.executor.DefaultTaskExecutorHandler.onEvent(DefaultTaskExecutorHandler.java:33) ~[doris-fe.jar:1.2-SNAPSHOT]
           at com.lmax.disruptor.WorkProcessor.run(WorkProcessor.java:143) ~[disruptor-3.4.4.jar:?]
           at java.lang.Thread.run(Thread.java:833) ~[?:?]
   Caused by: org.apache.doris.common.UserException: errCode = 3, detailMessage = tablet 469525 alive replica num 1 < load required replica num 2, alive backends: [10002], detail: Visible Replicas:Visible version: 1, Replicas: [replicaId=469526, backendId=-1, backend=null, version=1, state=NORMAL]. or you may not have permission to access the current cluster = gavin_cluster_name0
           at org.apache.doris.planner.OlapTableSink.createLocation(OlapTableSink.java:642) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.planner.OlapTableSink.complete(OlapTableSink.java:226) ~[doris-fe.jar:1.2-SNAPSHOT]
           at org.apache.doris.nereids.trees.plans.commands.insert.OlapInsertExecutor.finalizeSink(OlapInsertExecutor.java:126) ~[doris-fe.jar:1.2-SNAPSHOT]
           ... 14 more
   ```


-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.01 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 f155a5c93880990c3f75dd97d4e811f4c612523f, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.04	0.03
   query3	0.22	0.06	0.06
   query4	1.65	0.09	0.08
   query5	0.50	0.49	0.49
   query6	1.14	0.73	0.73
   query7	0.02	0.01	0.01
   query8	0.05	0.04	0.05
   query9	0.54	0.51	0.49
   query10	0.55	0.56	0.54
   query11	0.16	0.12	0.11
   query12	0.15	0.12	0.12
   query13	0.59	0.57	0.59
   query14	0.77	0.79	0.78
   query15	0.84	0.81	0.82
   query16	0.35	0.34	0.37
   query17	0.95	0.96	1.00
   query18	0.23	0.25	0.22
   query19	1.78	1.69	1.72
   query20	0.02	0.01	0.01
   query21	15.41	0.67	0.65
   query22	4.90	7.46	1.47
   query23	18.31	1.30	1.27
   query24	2.16	0.22	0.22
   query25	0.15	0.07	0.08
   query26	0.28	0.18	0.18
   query27	0.08	0.08	0.08
   query28	13.21	1.02	0.99
   query29	12.65	3.31	3.25
   query30	0.26	0.06	0.06
   query31	2.86	0.39	0.38
   query32	3.30	0.47	0.46
   query33	2.85	2.84	2.94
   query34	17.01	4.44	4.41
   query35	4.51	4.52	4.56
   query36	0.65	0.46	0.48
   query37	0.18	0.15	0.15
   query38	0.15	0.14	0.14
   query39	0.04	0.03	0.04
   query40	0.17	0.14	0.14
   query41	0.10	0.05	0.05
   query42	0.06	0.05	0.04
   query43	0.04	0.04	0.04
   Total cold run time: 109.96 s
   Total hot run time: 30.01 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39850 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 f155a5c93880990c3f75dd97d4e811f4c612523f, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17655	4340	4252	4252
   q2	2028	198	210	198
   q3	10427	1177	1116	1116
   q4	10184	814	793	793
   q5	7452	2661	2670	2661
   q6	220	136	137	136
   q7	951	607	599	599
   q8	9223	2058	2076	2058
   q9	8938	6500	6465	6465
   q10	8943	3742	3692	3692
   q11	445	238	241	238
   q12	440	233	231	231
   q13	17761	2970	2967	2967
   q14	268	218	221	218
   q15	529	480	486	480
   q16	525	385	377	377
   q17	959	668	790	668
   q18	7941	7382	7445	7382
   q19	6210	1468	1568	1468
   q20	654	316	313	313
   q21	4839	3196	4051	3196
   q22	406	342	346	342
   Total cold run time: 116998 ms
   Total hot run time: 39850 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4455	4260	4243	4243
   q2	375	273	267	267
   q3	2931	2898	2911	2898
   q4	1974	1651	1730	1651
   q5	5631	5500	5444	5444
   q6	220	133	136	133
   q7	2296	1858	1886	1858
   q8	3336	3462	3423	3423
   q9	8784	8893	8893	8893
   q10	4249	3783	3851	3783
   q11	617	491	502	491
   q12	832	685	607	607
   q13	15990	3271	3204	3204
   q14	322	293	281	281
   q15	548	487	485	485
   q16	521	440	440	440
   q17	1824	1562	1507	1507
   q18	8114	8071	8201	8071
   q19	1844	1687	1649	1649
   q20	3302	1939	1948	1939
   q21	5296	5235	4970	4970
   q22	692	599	582	582
   Total cold run time: 74153 ms
   Total hot run time: 56819 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](cloud) Fix replication_num properties when create table and MTMV [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2164233538

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


-- 
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](cloud) Fix replication_num properties when create table and MTVM [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173493 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 b4904729c8bc3d64965c90ba9fa24203601489bb, data reload: false
   
   query1	813	383	377	377
   query2	6405	2504	2515	2504
   query3	6400	206	208	206
   query4	20073	17510	17236	17236
   query5	3891	472	452	452
   query6	244	163	177	163
   query7	4462	297	290	290
   query8	321	286	287	286
   query9	8282	2399	2378	2378
   query10	569	329	285	285
   query11	10634	10062	10004	10004
   query12	142	89	85	85
   query13	1572	366	358	358
   query14	9774	7169	7598	7169
   query15	242	210	182	182
   query16	7727	265	261	261
   query17	1670	547	508	508
   query18	1880	275	277	275
   query19	189	150	152	150
   query20	88	83	83	83
   query21	209	125	120	120
   query22	4307	4148	4020	4020
   query23	33635	33606	33360	33360
   query24	11055	2782	2776	2776
   query25	610	354	347	347
   query26	1382	154	150	150
   query27	2926	316	315	315
   query28	7461	2061	2053	2053
   query29	934	620	602	602
   query30	245	151	152	151
   query31	931	739	737	737
   query32	94	57	56	56
   query33	768	297	297	297
   query34	866	486	471	471
   query35	738	657	622	622
   query36	1089	953	949	949
   query37	151	73	73	73
   query38	2843	2718	2735	2718
   query39	861	794	804	794
   query40	217	133	133	133
   query41	58	55	56	55
   query42	126	102	100	100
   query43	612	565	552	552
   query44	1200	745	729	729
   query45	200	166	162	162
   query46	1084	787	702	702
   query47	1854	1776	1776	1776
   query48	386	295	293	293
   query49	868	417	402	402
   query50	767	395	379	379
   query51	6817	6669	6655	6655
   query52	100	102	92	92
   query53	360	296	298	296
   query54	834	456	446	446
   query55	76	74	82	74
   query56	280	258	267	258
   query57	1171	1018	1089	1018
   query58	267	312	268	268
   query59	3581	3445	3136	3136
   query60	299	275	277	275
   query61	89	89	91	89
   query62	633	440	443	440
   query63	320	290	293	290
   query64	8815	2226	1751	1751
   query65	3187	3151	3092	3092
   query66	1325	323	327	323
   query67	15427	14946	14966	14946
   query68	4506	538	542	538
   query69	608	452	421	421
   query70	1146	1120	1142	1120
   query71	421	273	286	273
   query72	7253	5613	5529	5529
   query73	775	320	318	318
   query74	5800	5482	5508	5482
   query75	3307	2656	2664	2656
   query76	2247	885	896	885
   query77	480	296	302	296
   query78	10189	9846	9723	9723
   query79	2421	518	529	518
   query80	1695	483	460	460
   query81	575	223	225	223
   query82	948	110	103	103
   query83	279	169	168	168
   query84	247	93	96	93
   query85	1476	274	269	269
   query86	481	316	347	316
   query87	3237	3081	3078	3078
   query88	4277	2355	2363	2355
   query89	471	374	382	374
   query90	1835	191	193	191
   query91	142	110	109	109
   query92	68	52	54	52
   query93	1686	503	495	495
   query94	1252	198	198	198
   query95	414	326	326	326
   query96	586	275	267	267
   query97	3205	3034	3126	3034
   query98	228	203	195	195
   query99	1075	845	833	833
   Total cold run time: 270766 ms
   Total hot run time: 173493 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 174837 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 f155a5c93880990c3f75dd97d4e811f4c612523f, data reload: false
   
   query1	930	383	378	378
   query2	6447	2412	2399	2399
   query3	6633	205	205	205
   query4	19816	17369	17281	17281
   query5	3720	481	464	464
   query6	240	158	155	155
   query7	4585	302	293	293
   query8	312	287	299	287
   query9	8598	2399	2365	2365
   query10	557	293	281	281
   query11	10396	10047	10058	10047
   query12	126	88	83	83
   query13	1634	362	351	351
   query14	10076	7819	7948	7819
   query15	297	206	188	188
   query16	8083	258	259	258
   query17	1917	528	517	517
   query18	2062	298	265	265
   query19	286	152	154	152
   query20	91	85	81	81
   query21	213	124	130	124
   query22	4633	4009	4212	4009
   query23	33889	33822	33729	33729
   query24	10851	2840	2819	2819
   query25	596	387	378	378
   query26	721	162	164	162
   query27	2192	331	322	322
   query28	6475	2108	2098	2098
   query29	887	618	628	618
   query30	251	152	153	152
   query31	939	757	750	750
   query32	102	56	56	56
   query33	764	287	299	287
   query34	1093	493	471	471
   query35	791	669	659	659
   query36	1141	987	966	966
   query37	150	72	75	72
   query38	2952	2825	2794	2794
   query39	925	823	820	820
   query40	208	133	133	133
   query41	57	53	51	51
   query42	123	96	103	96
   query43	613	561	562	561
   query44	1189	730	730	730
   query45	205	171	165	165
   query46	1068	713	721	713
   query47	1845	1801	1767	1767
   query48	366	286	297	286
   query49	843	410	407	407
   query50	770	390	404	390
   query51	6791	6708	6712	6708
   query52	100	91	91	91
   query53	357	294	285	285
   query54	937	453	443	443
   query55	75	75	73	73
   query56	280	252	272	252
   query57	1120	1018	1044	1018
   query58	252	244	255	244
   query59	3356	3271	3164	3164
   query60	295	281	295	281
   query61	113	111	106	106
   query62	620	439	444	439
   query63	326	304	303	303
   query64	8760	2339	1831	1831
   query65	3345	3142	3110	3110
   query66	723	333	333	333
   query67	15488	14955	14897	14897
   query68	4625	540	548	540
   query69	595	460	425	425
   query70	1126	1149	1062	1062
   query71	426	283	274	274
   query72	8377	5925	5473	5473
   query73	753	319	322	319
   query74	5842	5509	5521	5509
   query75	3496	2693	2657	2657
   query76	2706	967	899	899
   query77	680	308	307	307
   query78	10537	9768	9770	9768
   query79	2986	522	515	515
   query80	1558	470	465	465
   query81	553	227	226	226
   query82	981	107	111	107
   query83	348	171	168	168
   query84	269	90	86	86
   query85	2029	288	276	276
   query86	473	321	305	305
   query87	3294	3097	3107	3097
   query88	4229	2342	2331	2331
   query89	488	378	379	378
   query90	1880	192	185	185
   query91	129	100	97	97
   query92	62	49	51	49
   query93	4775	509	503	503
   query94	1243	187	180	180
   query95	409	319	316	316
   query96	604	280	271	271
   query97	3190	2983	2986	2983
   query98	212	195	198	195
   query99	1281	839	848	839
   Total cold run time: 276752 ms
   Total hot run time: 174837 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40326 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 6c66027c0dc705063fc06331aa5e59d08c9cb95e, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17606	4308	4272	4272
   q2	2023	189	191	189
   q3	10467	1164	1144	1144
   q4	10182	727	798	727
   q5	7493	2671	2647	2647
   q6	217	134	133	133
   q7	958	608	591	591
   q8	9211	2065	2044	2044
   q9	8846	6509	6447	6447
   q10	9006	3747	3700	3700
   q11	458	245	244	244
   q12	502	241	233	233
   q13	17770	2976	2966	2966
   q14	264	225	222	222
   q15	522	475	473	473
   q16	515	373	367	367
   q17	957	702	661	661
   q18	7905	7508	7360	7360
   q19	6116	1543	1457	1457
   q20	659	318	335	318
   q21	4916	3799	3907	3799
   q22	397	336	332	332
   Total cold run time: 116990 ms
   Total hot run time: 40326 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4372	4220	4222	4220
   q2	366	268	268	268
   q3	2972	2923	2868	2868
   q4	2013	1703	1762	1703
   q5	5538	5502	5421	5421
   q6	217	134	128	128
   q7	2154	1892	1820	1820
   q8	3292	3406	3409	3406
   q9	8701	8701	8783	8701
   q10	4079	3765	3770	3765
   q11	624	494	503	494
   q12	809	648	638	638
   q13	17113	3152	3136	3136
   q14	295	295	292	292
   q15	537	486	462	462
   q16	493	439	447	439
   q17	1793	1506	1493	1493
   q18	8057	7840	7684	7684
   q19	1799	1652	1577	1577
   q20	2159	1889	1835	1835
   q21	5078	4909	4854	4854
   q22	624	534	569	534
   Total cold run time: 73085 ms
   Total hot run time: 55738 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41087 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 b4904729c8bc3d64965c90ba9fa24203601489bb, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17601	4343	4332	4332
   q2	2040	200	201	200
   q3	10438	1093	1121	1093
   q4	10196	784	718	718
   q5	7490	2716	2617	2617
   q6	223	143	139	139
   q7	951	610	621	610
   q8	9252	2067	2087	2067
   q9	8814	6489	6458	6458
   q10	8993	3805	3703	3703
   q11	461	240	239	239
   q12	455	239	231	231
   q13	17766	3043	2990	2990
   q14	257	218	223	218
   q15	544	494	498	494
   q16	531	393	380	380
   q17	972	727	630	630
   q18	8539	8075	7952	7952
   q19	7717	1467	1381	1381
   q20	704	327	328	327
   q21	5261	3956	4062	3956
   q22	429	352	365	352
   Total cold run time: 119634 ms
   Total hot run time: 41087 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4599	4482	4432	4432
   q2	365	263	271	263
   q3	3128	2888	2906	2888
   q4	1965	1670	1722	1670
   q5	5538	5594	5556	5556
   q6	227	133	128	128
   q7	2193	1869	1857	1857
   q8	3301	3417	3439	3417
   q9	8754	8769	8751	8751
   q10	4092	3856	3826	3826
   q11	600	496	502	496
   q12	862	668	620	620
   q13	17177	3044	3186	3044
   q14	339	276	271	271
   q15	525	483	501	483
   q16	486	449	424	424
   q17	1791	1522	1485	1485
   q18	8035	7833	7775	7775
   q19	1753	1745	1612	1612
   q20	2111	1865	1874	1865
   q21	5127	4984	4888	4888
   q22	663	561	593	561
   Total cold run time: 73631 ms
   Total hot run time: 56312 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   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](cloud) Fix replication_num properties when create table and MTVM [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156995327

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


-- 
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](cloud) Fix replication_num properties when create table and MTVM [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 170914 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 7a054761489f02b4cff16b4b39928f35e19d838a, data reload: false
   
   query1	923	375	382	375
   query2	6448	2408	2391	2391
   query3	6635	205	206	205
   query4	18798	17029	17242	17029
   query5	3574	466	482	466
   query6	241	161	158	158
   query7	4580	303	297	297
   query8	315	283	273	273
   query9	8389	2378	2369	2369
   query10	572	300	287	287
   query11	10387	10063	9859	9859
   query12	122	86	84	84
   query13	1653	358	364	358
   query14	10377	7777	7726	7726
   query15	270	184	192	184
   query16	8025	279	265	265
   query17	1891	563	543	543
   query18	2104	280	280	280
   query19	202	157	154	154
   query20	91	83	86	83
   query21	210	132	130	130
   query22	4288	4146	3934	3934
   query23	33902	33703	33655	33655
   query24	10858	2858	2906	2858
   query25	599	444	348	348
   query26	713	150	157	150
   query27	2262	327	329	327
   query28	6082	2134	2104	2104
   query29	863	611	605	605
   query30	253	158	158	158
   query31	982	769	753	753
   query32	99	52	54	52
   query33	685	278	274	274
   query34	871	476	485	476
   query35	745	637	644	637
   query36	1118	973	983	973
   query37	141	72	71	71
   query38	2949	2809	2832	2809
   query39	901	841	843	841
   query40	230	129	124	124
   query41	59	51	50	50
   query42	106	101	101	101
   query43	617	562	543	543
   query44	1087	730	719	719
   query45	203	164	174	164
   query46	1080	736	716	716
   query47	1844	1785	1792	1785
   query48	360	293	288	288
   query49	823	395	408	395
   query50	772	391	395	391
   query51	6777	6741	6655	6655
   query52	107	90	93	90
   query53	352	297	294	294
   query54	861	453	451	451
   query55	76	77	75	75
   query56	273	253	252	252
   query57	1111	1070	1013	1013
   query58	261	250	239	239
   query59	3525	3259	3116	3116
   query60	292	289	279	279
   query61	89	87	88	87
   query62	599	442	443	442
   query63	318	298	289	289
   query64	8537	2245	1712	1712
   query65	3312	3055	3162	3055
   query66	746	321	375	321
   query67	16378	14902	14836	14836
   query68	8445	542	544	542
   query69	623	454	387	387
   query70	1175	1046	1062	1046
   query71	483	283	272	272
   query72	7403	5290	2733	2733
   query73	1238	320	325	320
   query74	5816	5556	5435	5435
   query75	4254	2652	2688	2652
   query76	4290	999	952	952
   query77	679	295	306	295
   query78	10298	9801	9777	9777
   query79	1921	508	529	508
   query80	2048	471	473	471
   query81	573	216	222	216
   query82	269	102	104	102
   query83	251	164	176	164
   query84	278	83	83	83
   query85	829	278	258	258
   query86	348	327	312	312
   query87	3297	3151	3040	3040
   query88	3878	2338	2318	2318
   query89	491	390	399	390
   query90	1843	190	192	190
   query91	174	98	99	98
   query92	60	49	50	49
   query93	3811	504	499	499
   query94	1201	193	187	187
   query95	398	317	311	311
   query96	596	259	258	258
   query97	3190	3079	3002	3002
   query98	212	200	188	188
   query99	1312	842	836	836
   Total cold run time: 276597 ms
   Total hot run time: 170914 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](cloud) Fix replication_num properties when create table and MTVM [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.4 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 7a054761489f02b4cff16b4b39928f35e19d838a, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.08	0.03	0.04
   query3	0.23	0.06	0.06
   query4	1.66	0.09	0.10
   query5	0.50	0.48	0.50
   query6	1.13	0.73	0.73
   query7	0.02	0.01	0.01
   query8	0.05	0.04	0.04
   query9	0.55	0.50	0.48
   query10	0.54	0.54	0.53
   query11	0.14	0.12	0.12
   query12	0.15	0.12	0.12
   query13	0.59	0.60	0.60
   query14	0.78	0.79	0.77
   query15	0.83	0.81	0.83
   query16	0.34	0.37	0.40
   query17	1.01	0.99	0.96
   query18	0.22	0.24	0.27
   query19	1.78	1.72	1.72
   query20	0.02	0.01	0.01
   query21	15.40	0.66	0.65
   query22	4.63	7.40	1.73
   query23	18.30	1.39	1.26
   query24	2.15	0.21	0.21
   query25	0.16	0.08	0.10
   query26	0.26	0.17	0.17
   query27	0.08	0.09	0.07
   query28	13.31	1.01	0.99
   query29	12.59	3.36	3.33
   query30	0.26	0.07	0.05
   query31	2.86	0.38	0.39
   query32	3.27	0.49	0.47
   query33	2.89	2.87	2.88
   query34	17.09	4.41	4.42
   query35	4.40	4.51	4.50
   query36	0.65	0.47	0.45
   query37	0.18	0.15	0.15
   query38	0.14	0.14	0.15
   query39	0.04	0.03	0.03
   query40	0.18	0.14	0.15
   query41	0.10	0.05	0.05
   query42	0.05	0.04	0.04
   query43	0.04	0.03	0.04
   Total cold run time: 109.69 s
   Total hot run time: 30.4 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](cloud) Fix replication_num properties when create table and MTVM [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39734 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 7a054761489f02b4cff16b4b39928f35e19d838a, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17629	4318	4254	4254
   q2	2026	199	191	191
   q3	10459	1188	1104	1104
   q4	10182	823	787	787
   q5	7439	2697	2630	2630
   q6	221	138	134	134
   q7	958	611	602	602
   q8	9217	2062	2094	2062
   q9	8970	6491	6454	6454
   q10	8972	3709	3712	3709
   q11	448	229	236	229
   q12	419	231	225	225
   q13	18833	3002	3002	3002
   q14	263	220	221	220
   q15	519	483	474	474
   q16	493	389	372	372
   q17	960	659	702	659
   q18	7997	7438	7300	7300
   q19	4392	1478	1526	1478
   q20	647	312	317	312
   q21	4948	3208	3982	3208
   q22	395	328	337	328
   Total cold run time: 116387 ms
   Total hot run time: 39734 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4312	4224	4220	4220
   q2	363	257	256	256
   q3	2951	2852	2925	2852
   q4	1990	1707	1649	1649
   q5	5635	5509	5453	5453
   q6	227	133	132	132
   q7	2168	1871	1859	1859
   q8	3255	3421	3510	3421
   q9	8673	8701	8795	8701
   q10	4147	3783	3725	3725
   q11	583	487	487	487
   q12	842	639	633	633
   q13	16064	3202	3137	3137
   q14	302	271	286	271
   q15	548	474	476	474
   q16	499	441	433	433
   q17	1808	1504	1485	1485
   q18	8090	7951	7729	7729
   q19	2167	1594	1689	1594
   q20	2078	1885	1863	1863
   q21	5238	4956	4774	4774
   q22	623	576	559	559
   Total cold run time: 72563 ms
   Total hot run time: 55707 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](cloud) Fix replication_num properties when create table and MTVM [doris]

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

   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](cloud) Fix replication_num properties when create table and MTVM [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2156995350

   PR approved by anyone and no changes requested.


-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173498 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 6c66027c0dc705063fc06331aa5e59d08c9cb95e, data reload: false
   
   query1	935	391	364	364
   query2	6583	2365	2451	2365
   query3	6643	205	205	205
   query4	19910	17072	17284	17072
   query5	3604	460	461	460
   query6	245	168	160	160
   query7	4581	295	297	295
   query8	314	298	305	298
   query9	8391	2461	2440	2440
   query10	547	283	303	283
   query11	10450	9976	10027	9976
   query12	127	91	87	87
   query13	1652	379	364	364
   query14	10195	7590	7698	7590
   query15	237	188	190	188
   query16	7780	268	263	263
   query17	1911	533	513	513
   query18	1841	277	279	277
   query19	192	150	146	146
   query20	86	81	82	81
   query21	212	126	122	122
   query22	4342	4025	3960	3960
   query23	33808	33472	33435	33435
   query24	10900	2871	2849	2849
   query25	586	388	368	368
   query26	704	157	157	157
   query27	2286	326	350	326
   query28	6004	2144	2162	2144
   query29	886	654	648	648
   query30	257	154	157	154
   query31	994	751	783	751
   query32	92	51	58	51
   query33	696	290	312	290
   query34	897	493	477	477
   query35	754	645	634	634
   query36	1143	949	987	949
   query37	145	71	74	71
   query38	2886	2819	2824	2819
   query39	892	857	825	825
   query40	223	130	122	122
   query41	63	51	51	51
   query42	110	105	107	105
   query43	622	558	570	558
   query44	1114	735	740	735
   query45	197	163	174	163
   query46	1084	772	680	680
   query47	1818	1757	1782	1757
   query48	370	286	303	286
   query49	841	434	407	407
   query50	767	400	407	400
   query51	6807	6587	6646	6587
   query52	103	88	91	88
   query53	374	279	281	279
   query54	882	448	458	448
   query55	72	74	71	71
   query56	274	254	270	254
   query57	1114	1057	1023	1023
   query58	232	266	235	235
   query59	3410	3123	3163	3123
   query60	293	272	272	272
   query61	94	95	89	89
   query62	616	442	450	442
   query63	314	286	292	286
   query64	8728	2239	1760	1760
   query65	3209	3071	3089	3071
   query66	743	321	320	320
   query67	15426	15053	14827	14827
   query68	5250	538	536	536
   query69	622	471	376	376
   query70	1201	1129	1011	1011
   query71	451	271	275	271
   query72	7278	5380	5441	5380
   query73	774	326	329	326
   query74	5870	5477	5448	5448
   query75	3643	2671	2684	2671
   query76	3129	941	992	941
   query77	611	293	302	293
   query78	10314	9808	9683	9683
   query79	1684	524	516	516
   query80	1962	542	477	477
   query81	608	216	217	216
   query82	444	101	102	101
   query83	301	172	182	172
   query84	269	84	87	84
   query85	1002	278	268	268
   query86	454	333	320	320
   query87	3221	3031	3079	3031
   query88	3752	2465	2458	2458
   query89	476	377	371	371
   query90	1605	190	190	190
   query91	132	100	107	100
   query92	61	51	51	51
   query93	2081	502	506	502
   query94	1057	186	188	186
   query95	398	315	315	315
   query96	592	278	274	274
   query97	3176	3013	3093	3013
   query98	233	200	197	197
   query99	1178	824	827	824
   Total cold run time: 268437 ms
   Total hot run time: 173498 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](cloud) Fix replication_num properties when create table and MTMV [doris]

Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #36080:
URL: https://github.com/apache/doris/pull/36080


-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.11 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 b4904729c8bc3d64965c90ba9fa24203601489bb, data reload: false
   
   query1	0.05	0.03	0.04
   query2	0.08	0.04	0.04
   query3	0.24	0.05	0.05
   query4	1.67	0.10	0.10
   query5	0.49	0.47	0.48
   query6	1.13	0.72	0.74
   query7	0.02	0.01	0.02
   query8	0.05	0.04	0.04
   query9	0.54	0.49	0.47
   query10	0.53	0.54	0.53
   query11	0.16	0.11	0.11
   query12	0.14	0.13	0.12
   query13	0.59	0.59	0.62
   query14	0.77	0.79	0.81
   query15	0.84	0.81	0.81
   query16	0.36	0.36	0.36
   query17	0.96	1.05	1.04
   query18	0.22	0.26	0.25
   query19	1.75	1.72	1.73
   query20	0.02	0.01	0.01
   query21	15.41	0.65	0.64
   query22	4.83	6.01	2.03
   query23	18.32	1.37	1.36
   query24	2.07	0.23	0.22
   query25	0.14	0.09	0.08
   query26	0.28	0.17	0.18
   query27	0.09	0.08	0.08
   query28	13.28	1.02	0.99
   query29	12.60	3.27	3.31
   query30	0.29	0.07	0.06
   query31	2.86	0.39	0.39
   query32	3.25	0.49	0.47
   query33	2.88	2.96	2.97
   query34	17.13	4.64	4.67
   query35	4.81	4.64	4.45
   query36	0.66	0.46	0.49
   query37	0.18	0.15	0.16
   query38	0.15	0.14	0.14
   query39	0.04	0.04	0.03
   query40	0.16	0.14	0.14
   query41	0.08	0.04	0.04
   query42	0.06	0.05	0.05
   query43	0.04	0.04	0.03
   Total cold run time: 110.22 s
   Total hot run time: 31.11 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   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](cloud) Fix replication_num properties when create table and MTMV [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36080:
URL: https://github.com/apache/doris/pull/36080#issuecomment-2168033082

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


-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40120 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 d4644652148ea8971a4e5780eac8141de7096cd0, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17626	4297	4231	4231
   q2	2029	196	191	191
   q3	10447	1095	1106	1095
   q4	10197	793	737	737
   q5	7458	2640	2573	2573
   q6	217	139	133	133
   q7	947	598	589	589
   q8	9231	2047	2036	2036
   q9	9001	6459	6462	6459
   q10	8972	3696	3691	3691
   q11	458	240	238	238
   q12	525	225	228	225
   q13	17759	2962	2963	2962
   q14	264	230	240	230
   q15	523	482	475	475
   q16	522	393	379	379
   q17	953	743	673	673
   q18	8232	8067	7839	7839
   q19	8082	1565	1432	1432
   q20	691	337	325	325
   q21	5060	3261	4077	3261
   q22	407	349	346	346
   Total cold run time: 119601 ms
   Total hot run time: 40120 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4649	4457	4358	4358
   q2	378	274	264	264
   q3	3056	2938	2937	2937
   q4	2044	1754	1677	1677
   q5	5571	5558	5556	5556
   q6	226	126	133	126
   q7	2159	1852	1777	1777
   q8	3224	3367	3381	3367
   q9	8667	8623	8638	8623
   q10	4066	3874	3873	3873
   q11	624	489	491	489
   q12	828	616	615	615
   q13	15903	2976	3122	2976
   q14	315	270	263	263
   q15	513	474	503	474
   q16	507	418	431	418
   q17	1814	1520	1462	1462
   q18	7956	7676	7542	7542
   q19	1749	1501	1576	1501
   q20	3344	1857	1884	1857
   q21	8525	4636	4838	4636
   q22	653	565	580	565
   Total cold run time: 76771 ms
   Total hot run time: 55356 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.45 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 d4644652148ea8971a4e5780eac8141de7096cd0, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.04	0.04
   query3	0.22	0.05	0.04
   query4	1.68	0.07	0.07
   query5	0.50	0.47	0.47
   query6	1.13	0.73	0.72
   query7	0.02	0.01	0.02
   query8	0.05	0.04	0.04
   query9	0.55	0.48	0.48
   query10	0.55	0.55	0.54
   query11	0.15	0.11	0.11
   query12	0.15	0.13	0.11
   query13	0.60	0.59	0.61
   query14	0.80	0.76	0.78
   query15	0.82	0.81	0.81
   query16	0.35	0.37	0.37
   query17	0.99	1.06	0.95
   query18	0.23	0.22	0.26
   query19	1.94	1.75	1.70
   query20	0.01	0.00	0.00
   query21	15.40	0.65	0.65
   query22	3.76	5.52	3.95
   query23	18.34	1.31	1.33
   query24	2.19	0.21	0.22
   query25	0.16	0.09	0.09
   query26	0.27	0.17	0.17
   query27	0.09	0.08	0.08
   query28	13.23	1.02	0.99
   query29	12.62	3.30	3.26
   query30	0.26	0.06	0.07
   query31	2.86	0.40	0.38
   query32	3.27	0.48	0.47
   query33	2.94	2.88	2.89
   query34	16.93	4.41	4.39
   query35	4.49	4.51	4.44
   query36	0.66	0.48	0.48
   query37	0.19	0.16	0.15
   query38	0.15	0.14	0.14
   query39	0.04	0.03	0.03
   query40	0.18	0.14	0.15
   query41	0.09	0.05	0.05
   query42	0.06	0.05	0.04
   query43	0.04	0.03	0.04
   Total cold run time: 109.08 s
   Total hot run time: 32.45 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   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](cloud) Fix replication_num properties when create table and MTMV [doris]

Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on code in PR #36080:
URL: https://github.com/apache/doris/pull/36080#discussion_r1636731462


##########
fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java:
##########
@@ -189,6 +189,7 @@ public CreateTableStmt(boolean ifNotExists, boolean isExternal, TableName tableN
         this.partitionDesc = partitionDesc;
         this.distributionDesc = distributionDesc;
         this.properties = properties;
+        PropertyAnalyzer.getInstance().rewriteForceProperties(this.properties);

Review Comment:
   Try to rewrite properties in all possible path.



-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on code in PR #36080:
URL: https://github.com/apache/doris/pull/36080#discussion_r1635723868


##########
fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java:
##########
@@ -189,6 +189,7 @@ public CreateTableStmt(boolean ifNotExists, boolean isExternal, TableName tableN
         this.partitionDesc = partitionDesc;
         this.distributionDesc = distributionDesc;
         this.properties = properties;
+        PropertyAnalyzer.getInstance().rewriteForceProperties(this.properties);

Review Comment:
   better to rewrite them in Nereids CreateTableCommand



-- 
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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.39 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 6c66027c0dc705063fc06331aa5e59d08c9cb95e, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.03	0.03
   query3	0.24	0.05	0.05
   query4	1.66	0.08	0.09
   query5	0.50	0.49	0.48
   query6	1.13	0.72	0.72
   query7	0.02	0.01	0.01
   query8	0.05	0.04	0.04
   query9	0.56	0.50	0.48
   query10	0.54	0.54	0.52
   query11	0.15	0.12	0.11
   query12	0.15	0.12	0.12
   query13	0.60	0.59	0.60
   query14	0.78	0.81	0.78
   query15	0.84	0.82	0.82
   query16	0.34	0.36	0.36
   query17	1.01	1.01	0.99
   query18	0.23	0.25	0.23
   query19	1.81	1.71	1.70
   query20	0.01	0.00	0.01
   query21	15.46	0.65	0.64
   query22	3.95	7.68	1.77
   query23	18.29	1.38	1.30
   query24	2.08	0.23	0.21
   query25	0.15	0.09	0.08
   query26	0.27	0.17	0.17
   query27	0.08	0.09	0.08
   query28	13.24	1.01	1.01
   query29	12.66	3.27	3.26
   query30	0.26	0.06	0.08
   query31	2.84	0.40	0.39
   query32	3.25	0.48	0.48
   query33	2.90	2.93	2.88
   query34	17.15	4.44	4.43
   query35	4.45	4.47	4.45
   query36	0.65	0.46	0.46
   query37	0.18	0.15	0.15
   query38	0.15	0.14	0.14
   query39	0.05	0.03	0.03
   query40	0.18	0.14	0.14
   query41	0.09	0.04	0.05
   query42	0.05	0.05	0.05
   query43	0.04	0.03	0.04
   Total cold run time: 109.16 s
   Total hot run time: 30.39 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](cloud) Fix replication_num properties when create table and MTMV [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 172875 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 d4644652148ea8971a4e5780eac8141de7096cd0, data reload: false
   
   query1	818	390	380	380
   query2	6336	2334	2458	2334
   query3	6399	203	205	203
   query4	20162	17356	17329	17329
   query5	3739	471	486	471
   query6	242	161	153	153
   query7	4459	298	296	296
   query8	335	283	293	283
   query9	8321	2393	2386	2386
   query10	570	305	286	286
   query11	10626	10093	10021	10021
   query12	139	90	85	85
   query13	1582	370	369	369
   query14	10041	7606	6926	6926
   query15	236	183	187	183
   query16	7809	269	260	260
   query17	1858	533	520	520
   query18	1924	270	275	270
   query19	193	152	150	150
   query20	93	86	82	82
   query21	206	122	123	122
   query22	4201	3993	4193	3993
   query23	33689	33403	33496	33403
   query24	10856	2777	2764	2764
   query25	576	378	354	354
   query26	711	157	149	149
   query27	2208	321	324	321
   query28	5861	2036	2044	2036
   query29	863	625	617	617
   query30	250	148	151	148
   query31	958	719	711	711
   query32	97	52	55	52
   query33	756	273	278	273
   query34	910	479	460	460
   query35	725	644	620	620
   query36	1093	957	948	948
   query37	135	67	70	67
   query38	2927	2762	2723	2723
   query39	864	806	811	806
   query40	200	128	133	128
   query41	56	53	54	53
   query42	118	98	103	98
   query43	620	559	540	540
   query44	1189	731	733	731
   query45	194	166	161	161
   query46	1060	725	688	688
   query47	1877	1792	1825	1792
   query48	357	298	302	298
   query49	860	411	399	399
   query50	757	388	385	385
   query51	6780	6755	6640	6640
   query52	111	88	95	88
   query53	351	285	289	285
   query54	895	451	436	436
   query55	77	74	78	74
   query56	280	249	316	249
   query57	1166	1056	1063	1056
   query58	251	246	237	237
   query59	3296	3303	3238	3238
   query60	291	276	276	276
   query61	99	89	89	89
   query62	630	436	452	436
   query63	322	292	295	292
   query64	8547	2290	1777	1777
   query65	3148	3144	3076	3076
   query66	782	324	330	324
   query67	15376	14807	14861	14807
   query68	4506	540	537	537
   query69	585	464	421	421
   query70	1187	1052	1150	1052
   query71	402	280	283	280
   query72	7488	5746	5547	5547
   query73	771	321	319	319
   query74	5941	5445	5478	5445
   query75	3401	2707	2667	2667
   query76	2404	907	971	907
   query77	519	303	302	302
   query78	10144	10047	9670	9670
   query79	2120	515	515	515
   query80	1062	463	453	453
   query81	584	215	215	215
   query82	823	100	98	98
   query83	235	164	158	158
   query84	239	84	82	82
   query85	1860	271	269	269
   query86	481	309	326	309
   query87	3267	3047	3087	3047
   query88	4157	2365	2342	2342
   query89	480	396	375	375
   query90	1859	189	186	186
   query91	130	95	100	95
   query92	60	50	48	48
   query93	2274	511	501	501
   query94	1256	188	189	188
   query95	407	314	308	308
   query96	590	272	260	260
   query97	3268	3046	3031	3031
   query98	213	192	196	192
   query99	1260	867	849	849
   Total cold run time: 267431 ms
   Total hot run time: 172875 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