You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "chuang-wang-pre (via GitHub)" <gi...@apache.org> on 2025/04/08 02:09:48 UTC

[PR] Feat/replica property duplicate checking [doris]

chuang-wang-pre opened a new pull request, #49856:
URL: https://github.com/apache/doris/pull/49856

   ### What problem does this PR solve?
   
   Issue Number: close #32577
   
   Problem Summary:
   When create a table in doris with two properties: "replication_allocation" and "replication_num",
   for example:
   
   CREATE TABLE demo.test_table
   (
       k1 DATE,
       k2 DECIMAL(10, 2) DEFAULT "10.5"
   )
   DUPLICATE KEY(k1, k2)
   COMMENT "test table"
   DISTRIBUTED BY HASH(k1) BUCKETS 8
   PROPERTIES (
       "replication_num" = "1",
       "replication_allocation" = "tag.location.default: 1"
   );
   doris reports an unknown property error:
   errCode = 2, detailMessage = Unknown properties: {replication_allocation=tag.location.default: 1}
   
   it should report a duplicated properties or if duplicated properties have same value, doris should just ignore it.
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
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] [Enhancement] (fe) duplicated properties of replica checking [doris]

Posted by "chuang-wang-pre (via GitHub)" <gi...@apache.org>.
chuang-wang-pre commented on code in PR #49856:
URL: https://github.com/apache/doris/pull/49856#discussion_r2040563738


##########
fe/fe-core/src/main/java/org/apache/doris/common/util/PropertyAnalyzer.java:
##########
@@ -1340,7 +1342,7 @@ public static Map<String, String> analyzeBackendTagsProperties(Map<String, Strin
             if (keyParts.length != 2) {
                 continue;
             }
-            String val = entry.getValue().replaceAll(" ", "");
+            String val = entry.getValue().replace(" ", "");

Review Comment:
   > Please explain the reason.
   
   If the first argument is not a real regular expression, String::replace does exactly the same thing as String::replaceAll without the performance drawback of the regex.



-- 
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] [Enhancement] (fe) duplicated properties of replica checking [doris]

Posted by "chuang-wang-pre (via GitHub)" <gi...@apache.org>.
chuang-wang-pre commented on PR #49856:
URL: https://github.com/apache/doris/pull/49856#issuecomment-2785052247

   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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 191794 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 d4303e053c66eb3dac9059945a39236a89885806, data reload: false
   
   query1	1405	1101	1099	1099
   query2	6026	1778	1807	1778
   query3	11027	4602	4540	4540
   query4	25745	23308	23303	23303
   query5	4786	613	450	450
   query6	315	227	239	227
   query7	3999	501	284	284
   query8	316	253	244	244
   query9	8517	2551	2577	2551
   query10	500	314	262	262
   query11	15556	15089	14702	14702
   query12	170	116	106	106
   query13	1564	517	396	396
   query14	9637	6087	6142	6087
   query15	209	185	172	172
   query16	7645	627	486	486
   query17	1168	767	616	616
   query18	2036	424	330	330
   query19	206	203	165	165
   query20	127	125	124	124
   query21	212	137	113	113
   query22	4517	4572	4269	4269
   query23	34238	33594	33399	33399
   query24	8382	2397	2464	2397
   query25	519	455	385	385
   query26	1161	268	148	148
   query27	2828	513	333	333
   query28	4650	2188	2176	2176
   query29	677	564	429	429
   query30	283	219	187	187
   query31	880	858	775	775
   query32	73	58	64	58
   query33	544	390	324	324
   query34	806	918	531	531
   query35	822	839	762	762
   query36	983	998	885	885
   query37	121	102	74	74
   query38	4212	4178	4180	4178
   query39	1499	1445	1453	1445
   query40	208	124	108	108
   query41	54	56	53	53
   query42	125	104	109	104
   query43	493	500	484	484
   query44	1301	817	828	817
   query45	180	176	168	168
   query46	836	1020	633	633
   query47	1801	1935	1806	1806
   query48	384	420	326	326
   query49	750	553	425	425
   query50	657	699	400	400
   query51	4266	4270	4250	4250
   query52	110	116	105	105
   query53	228	261	178	178
   query54	578	591	504	504
   query55	86	79	81	79
   query56	308	303	305	303
   query57	1169	1175	1114	1114
   query58	264	260	275	260
   query59	2636	2794	2583	2583
   query60	342	329	307	307
   query61	138	128	132	128
   query62	786	750	656	656
   query63	214	186	183	183
   query64	4627	1011	681	681
   query65	4430	4428	4372	4372
   query66	956	456	318	318
   query67	16062	15517	15323	15323
   query68	8521	916	512	512
   query69	479	301	263	263
   query70	1215	1045	1088	1045
   query71	475	308	286	286
   query72	5757	4687	4653	4653
   query73	729	608	351	351
   query74	9074	9142	8890	8890
   query75	3885	3197	2711	2711
   query76	3694	1184	725	725
   query77	796	374	281	281
   query78	10011	9969	9269	9269
   query79	2680	814	561	561
   query80	636	490	415	415
   query81	485	258	218	218
   query82	443	124	99	99
   query83	273	246	225	225
   query84	293	108	168	108
   query85	765	345	309	309
   query86	338	306	283	283
   query87	4451	4475	4284	4284
   query88	2891	2232	2205	2205
   query89	435	312	281	281
   query90	1885	203	209	203
   query91	155	139	108	108
   query92	76	61	55	55
   query93	1926	938	564	564
   query94	678	402	273	273
   query95	379	289	359	289
   query96	485	547	266	266
   query97	3125	3228	3134	3134
   query98	220	206	197	197
   query99	1442	1399	1273	1273
   Total cold run time: 281047 ms
   Total hot run time: 191794 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] Feat/replica property duplicate checking [doris]

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

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and after the optimization?
       


-- 
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] [Enhancement] (fe) duplicated properties of replica checking [doris]

Posted by "chuang-wang-pre (via GitHub)" <gi...@apache.org>.
chuang-wang-pre commented on PR #49856:
URL: https://github.com/apache/doris/pull/49856#issuecomment-2809264265

   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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33961 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 2e5957ecb888d523fcf72a052becbc066b6c6b43, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	25861	5033	5021	5021
   q2	2060	275	182	182
   q3	10400	1280	664	664
   q4	10215	993	509	509
   q5	7552	2325	2387	2325
   q6	186	160	128	128
   q7	895	730	607	607
   q8	9637	1315	1110	1110
   q9	6929	5088	5170	5088
   q10	6876	2323	1879	1879
   q11	493	292	270	270
   q12	358	350	216	216
   q13	17802	3651	3062	3062
   q14	248	219	210	210
   q15	524	516	482	482
   q16	611	632	594	594
   q17	599	852	361	361
   q18	7549	7161	7198	7161
   q19	1494	954	538	538
   q20	340	341	229	229
   q21	3881	3390	2351	2351
   q22	1056	1016	974	974
   Total cold run time: 115566 ms
   Total hot run time: 33961 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5157	5120	5101	5101
   q2	232	325	229	229
   q3	2121	2616	2267	2267
   q4	1392	1814	1391	1391
   q5	4448	4381	4346	4346
   q6	212	172	126	126
   q7	1982	1921	1736	1736
   q8	2570	2542	2504	2504
   q9	7277	7221	7043	7043
   q10	2964	3159	2733	2733
   q11	570	497	505	497
   q12	667	759	610	610
   q13	3475	3869	3245	3245
   q14	272	316	298	298
   q15	514	461	471	461
   q16	659	672	660	660
   q17	1136	1544	1406	1406
   q18	7658	7611	7541	7541
   q19	805	946	992	946
   q20	1911	1929	1793	1793
   q21	5307	4840	4817	4817
   q22	1093	1029	1004	1004
   Total cold run time: 52422 ms
   Total hot run time: 50754 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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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


##########
fe/fe-core/src/main/java/org/apache/doris/common/util/PropertyAnalyzer.java:
##########
@@ -1340,7 +1342,7 @@ public static Map<String, String> analyzeBackendTagsProperties(Map<String, Strin
             if (keyParts.length != 2) {
                 continue;
             }
-            String val = entry.getValue().replaceAll(" ", "");
+            String val = entry.getValue().replace(" ", "");

Review Comment:
   Please explain the reason.



-- 
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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33864 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 d4303e053c66eb3dac9059945a39236a89885806, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26136	5144	5021	5021
   q2	2062	281	183	183
   q3	10385	1259	703	703
   q4	10231	992	548	548
   q5	7514	2386	2325	2325
   q6	181	168	131	131
   q7	917	745	619	619
   q8	9313	1245	1100	1100
   q9	6830	5142	5082	5082
   q10	6863	2286	1879	1879
   q11	495	290	268	268
   q12	348	356	221	221
   q13	17801	3693	3113	3113
   q14	241	243	234	234
   q15	534	485	470	470
   q16	458	444	405	405
   q17	581	846	362	362
   q18	7579	7196	7067	7067
   q19	1886	994	562	562
   q20	329	327	226	226
   q21	3935	2696	2377	2377
   q22	1014	1013	968	968
   Total cold run time: 115633 ms
   Total hot run time: 33864 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5198	5061	5077	5061
   q2	235	328	229	229
   q3	2135	2692	2295	2295
   q4	1398	1780	1346	1346
   q5	4506	4353	4440	4353
   q6	227	172	123	123
   q7	2027	1952	1740	1740
   q8	2556	2566	2560	2560
   q9	7288	7190	6947	6947
   q10	3017	3205	2757	2757
   q11	573	519	500	500
   q12	694	745	590	590
   q13	3510	3913	3264	3264
   q14	269	310	276	276
   q15	534	491	475	475
   q16	479	520	449	449
   q17	1133	1566	1380	1380
   q18	7665	7519	7525	7519
   q19	806	893	990	893
   q20	1974	2083	1890	1890
   q21	5094	4950	4807	4807
   q22	1082	1059	1010	1010
   Total cold run time: 52400 ms
   Total hot run time: 50464 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] [Enhancement] (fe) duplicated properties of replica checking [doris]

Posted by "chuang-wang-pre (via GitHub)" <gi...@apache.org>.
chuang-wang-pre closed pull request #49856: [Enhancement] (fe) duplicated properties of replica checking
URL: https://github.com/apache/doris/pull/49856


-- 
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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.73 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 d4303e053c66eb3dac9059945a39236a89885806, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.12	0.10	0.12
   query3	0.26	0.19	0.20
   query4	1.59	0.19	0.19
   query5	0.57	0.58	0.58
   query6	1.19	0.71	0.72
   query7	0.02	0.01	0.02
   query8	0.04	0.04	0.04
   query9	0.57	0.52	0.51
   query10	0.57	0.59	0.56
   query11	0.16	0.10	0.11
   query12	0.14	0.11	0.12
   query13	0.61	0.60	0.60
   query14	1.15	1.15	1.18
   query15	0.89	0.87	0.86
   query16	0.40	0.37	0.39
   query17	1.06	1.02	1.04
   query18	0.21	0.19	0.19
   query19	1.91	1.78	1.77
   query20	0.01	0.01	0.02
   query21	15.40	0.89	0.54
   query22	0.75	1.25	0.64
   query23	14.91	1.37	0.61
   query24	7.30	1.48	1.23
   query25	0.46	0.26	0.07
   query26	0.56	0.16	0.13
   query27	0.06	0.05	0.05
   query28	9.51	0.77	0.44
   query29	12.61	3.93	3.27
   query30	0.25	0.08	0.06
   query31	2.82	0.57	0.38
   query32	3.21	0.54	0.46
   query33	2.95	3.03	3.10
   query34	15.67	5.06	4.48
   query35	4.53	4.47	4.44
   query36	0.66	0.50	0.49
   query37	0.09	0.06	0.06
   query38	0.06	0.04	0.04
   query39	0.04	0.03	0.02
   query40	0.16	0.12	0.13
   query41	0.08	0.02	0.02
   query42	0.03	0.02	0.02
   query43	0.04	0.04	0.03
   Total cold run time: 103.66 s
   Total hot run time: 29.73 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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192307 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 2e5957ecb888d523fcf72a052becbc066b6c6b43, data reload: false
   
   query1	1381	1089	1066	1066
   query2	6061	1950	1943	1943
   query3	11027	4560	4426	4426
   query4	52304	25648	22893	22893
   query5	5024	576	436	436
   query6	323	196	190	190
   query7	4878	498	284	284
   query8	322	269	246	246
   query9	5458	2545	2548	2545
   query10	463	317	260	260
   query11	15050	14974	15091	14974
   query12	167	113	110	110
   query13	1043	529	387	387
   query14	9994	6308	6269	6269
   query15	206	209	175	175
   query16	7155	653	487	487
   query17	1108	780	585	585
   query18	1562	424	328	328
   query19	204	198	174	174
   query20	131	129	126	126
   query21	212	138	111	111
   query22	4607	4740	4408	4408
   query23	33959	32976	33064	32976
   query24	7125	2395	2413	2395
   query25	473	460	390	390
   query26	719	272	145	145
   query27	2361	517	343	343
   query28	3337	2481	2404	2404
   query29	613	581	428	428
   query30	286	222	200	200
   query31	890	884	781	781
   query32	77	66	62	62
   query33	443	383	299	299
   query34	772	887	511	511
   query35	810	830	759	759
   query36	973	1019	953	953
   query37	118	96	75	75
   query38	4326	4197	4349	4197
   query39	1496	1422	1431	1422
   query40	209	124	111	111
   query41	54	54	51	51
   query42	121	104	108	104
   query43	506	512	480	480
   query44	1298	780	792	780
   query45	178	170	194	170
   query46	841	1018	636	636
   query47	1885	1916	1786	1786
   query48	390	417	303	303
   query49	695	529	463	463
   query50	666	711	408	408
   query51	4280	4205	4258	4205
   query52	116	103	95	95
   query53	231	261	192	192
   query54	561	576	548	548
   query55	84	84	83	83
   query56	301	305	297	297
   query57	1214	1205	1155	1155
   query58	276	258	250	250
   query59	2709	2939	2929	2929
   query60	325	323	300	300
   query61	130	129	129	129
   query62	725	781	669	669
   query63	228	188	185	185
   query64	2220	1050	716	716
   query65	4456	4328	4236	4236
   query66	795	409	299	299
   query67	15849	15564	15325	15325
   query68	6855	881	505	505
   query69	536	304	267	267
   query70	1225	1098	1107	1098
   query71	496	306	287	287
   query72	5758	4852	4937	4852
   query73	1507	692	354	354
   query74	9293	9141	8622	8622
   query75	4008	3204	2783	2783
   query76	4283	1188	745	745
   query77	719	355	280	280
   query78	9977	9976	9274	9274
   query79	5537	798	546	546
   query80	658	501	439	439
   query81	488	259	225	225
   query82	644	128	93	93
   query83	308	254	243	243
   query84	296	105	85	85
   query85	781	348	323	323
   query86	364	293	301	293
   query87	4347	4620	4324	4324
   query88	3628	2209	2219	2209
   query89	443	322	304	304
   query90	1972	215	215	215
   query91	150	140	113	113
   query92	75	60	61	60
   query93	3150	929	578	578
   query94	664	425	309	309
   query95	373	291	290	290
   query96	498	570	270	270
   query97	3180	3184	3125	3125
   query98	253	212	205	205
   query99	1435	1361	1323	1323
   Total cold run time: 302702 ms
   Total hot run time: 192307 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] [Enhancement] (fe) duplicated properties of replica checking [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.91 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 2e5957ecb888d523fcf72a052becbc066b6c6b43, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.12	0.10	0.10
   query3	0.24	0.20	0.19
   query4	1.59	0.20	0.19
   query5	0.59	0.57	0.59
   query6	1.18	0.71	0.72
   query7	0.03	0.02	0.02
   query8	0.04	0.03	0.03
   query9	0.58	0.52	0.52
   query10	0.57	0.58	0.57
   query11	0.16	0.11	0.11
   query12	0.14	0.11	0.11
   query13	0.61	0.60	0.60
   query14	2.78	2.69	2.81
   query15	0.94	0.87	0.88
   query16	0.39	0.39	0.37
   query17	1.03	1.04	1.04
   query18	0.21	0.20	0.19
   query19	1.92	1.96	1.82
   query20	0.02	0.01	0.01
   query21	15.35	0.90	0.54
   query22	0.74	1.02	0.94
   query23	14.78	1.40	0.61
   query24	7.06	1.23	1.41
   query25	0.48	0.13	0.14
   query26	0.53	0.16	0.14
   query27	0.06	0.04	0.05
   query28	10.21	0.84	0.43
   query29	12.58	4.06	3.33
   query30	0.24	0.09	0.07
   query31	2.82	0.60	0.39
   query32	3.23	0.55	0.47
   query33	3.01	3.08	3.10
   query34	15.80	5.09	4.45
   query35	4.48	4.54	4.53
   query36	0.67	0.49	0.48
   query37	0.09	0.07	0.06
   query38	0.05	0.04	0.03
   query39	0.03	0.03	0.03
   query40	0.18	0.13	0.12
   query41	0.08	0.02	0.02
   query42	0.03	0.03	0.02
   query43	0.03	0.03	0.03
   Total cold run time: 105.71 s
   Total hot run time: 31.91 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] [Enhancement] (fe) duplicated properties of replica checking [doris]

Posted by "chuang-wang-pre (via GitHub)" <gi...@apache.org>.
chuang-wang-pre commented on PR #49856:
URL: https://github.com/apache/doris/pull/49856#issuecomment-2785996992

   run cloud_p0


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