You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Jibing-Li (via GitHub)" <gi...@apache.org> on 2025/05/21 07:47:31 UTC

[PR] [fix](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

Jibing-Li opened a new pull request, #51116:
URL: https://github.com/apache/doris/pull/51116

   ### What problem does this PR solve?
   
   Fix sample analyze agg/mor table doesn't remove new partition flag bug.
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [x] 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:
       - [x] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [x] 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] [fix](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   run 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


Re: [PR] [fix](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34078 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 e7c18b585e936104fde636f05f720488c4ee7937, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26049	5097	5052	5052
   q2	2067	282	184	184
   q3	10441	1258	720	720
   q4	10236	1001	535	535
   q5	7675	2444	2318	2318
   q6	190	174	137	137
   q7	924	759	606	606
   q8	9323	1300	1143	1143
   q9	6792	5149	5116	5116
   q10	6817	2310	1896	1896
   q11	480	293	274	274
   q12	349	353	214	214
   q13	17773	3677	3143	3143
   q14	234	224	213	213
   q15	548	510	506	506
   q16	409	427	365	365
   q17	590	858	361	361
   q18	7831	7183	7087	7087
   q19	1212	930	570	570
   q20	340	329	223	223
   q21	3920	3206	2442	2442
   q22	1062	1022	973	973
   Total cold run time: 115262 ms
   Total hot run time: 34078 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5467	5066	5305	5066
   q2	247	333	228	228
   q3	2186	2646	2264	2264
   q4	1385	1800	1411	1411
   q5	4576	4467	4399	4399
   q6	211	168	129	129
   q7	1966	1894	1743	1743
   q8	2634	2538	2507	2507
   q9	7197	7150	7344	7150
   q10	2980	3191	2750	2750
   q11	594	522	509	509
   q12	697	780	658	658
   q13	3525	3890	3282	3282
   q14	280	301	260	260
   q15	551	483	494	483
   q16	433	479	446	446
   q17	1164	1588	1354	1354
   q18	7590	7605	7559	7559
   q19	799	910	978	910
   q20	1969	2043	1908	1908
   q21	4763	4261	4349	4261
   q22	1088	1023	989	989
   Total cold run time: 52302 ms
   Total hot run time: 50266 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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33699 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 038077918b3d67d39b537d204b0683877bb30bad, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	25991	5020	4945	4945
   q2	2085	297	194	194
   q3	10363	1241	677	677
   q4	10221	1005	534	534
   q5	7557	2410	2271	2271
   q6	182	165	131	131
   q7	931	752	617	617
   q8	9312	1276	1094	1094
   q9	6790	5043	5106	5043
   q10	6811	2292	1910	1910
   q11	480	281	277	277
   q12	353	347	223	223
   q13	17792	3636	3100	3100
   q14	238	234	218	218
   q15	533	486	494	486
   q16	406	441	369	369
   q17	604	842	358	358
   q18	7500	7213	7204	7204
   q19	1255	934	519	519
   q20	340	335	224	224
   q21	3732	2605	2356	2356
   q22	1045	1014	949	949
   Total cold run time: 114521 ms
   Total hot run time: 33699 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5041	5016	5032	5016
   q2	240	331	230	230
   q3	2121	2610	2283	2283
   q4	1367	1753	1379	1379
   q5	4289	4309	4407	4309
   q6	217	173	125	125
   q7	1975	1923	1787	1787
   q8	2586	2648	2568	2568
   q9	7161	7230	7051	7051
   q10	3003	3137	2762	2762
   q11	582	538	495	495
   q12	683	762	620	620
   q13	3476	3857	3233	3233
   q14	272	305	278	278
   q15	511	477	474	474
   q16	459	493	456	456
   q17	1149	1589	1352	1352
   q18	7781	7574	7444	7444
   q19	795	756	937	756
   q20	1967	2038	1896	1896
   q21	4798	4451	4440	4440
   q22	1078	1053	1000	1000
   Total cold run time: 51551 ms
   Total hot run time: 49954 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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.02 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 038077918b3d67d39b537d204b0683877bb30bad, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.13	0.10	0.11
   query3	0.25	0.19	0.20
   query4	1.60	0.20	0.19
   query5	0.48	0.45	0.45
   query6	1.15	0.67	0.66
   query7	0.02	0.02	0.02
   query8	0.04	0.03	0.04
   query9	0.59	0.51	0.52
   query10	0.56	0.58	0.57
   query11	0.16	0.12	0.11
   query12	0.14	0.11	0.11
   query13	0.60	0.60	0.59
   query14	0.79	0.81	0.80
   query15	0.88	0.89	0.85
   query16	0.38	0.41	0.37
   query17	1.06	1.02	1.06
   query18	0.23	0.21	0.21
   query19	1.94	1.83	1.78
   query20	0.01	0.02	0.01
   query21	15.46	0.89	0.54
   query22	0.76	1.31	0.69
   query23	14.76	1.40	0.62
   query24	6.96	1.06	0.77
   query25	0.48	0.09	0.12
   query26	0.64	0.16	0.16
   query27	0.06	0.05	0.05
   query28	9.14	0.94	0.43
   query29	12.56	4.05	3.35
   query30	0.26	0.09	0.06
   query31	2.83	0.58	0.38
   query32	3.23	0.54	0.48
   query33	3.09	3.12	3.04
   query34	15.68	5.09	4.47
   query35	4.51	4.53	4.50
   query36	0.66	0.51	0.48
   query37	0.08	0.06	0.06
   query38	0.05	0.04	0.04
   query39	0.04	0.02	0.03
   query40	0.17	0.13	0.12
   query41	0.09	0.03	0.02
   query42	0.03	0.03	0.02
   query43	0.03	0.03	0.03
   Total cold run time: 102.62 s
   Total hot run time: 29.02 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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   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] [fix](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 193646 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 038077918b3d67d39b537d204b0683877bb30bad, data reload: false
   
   query1	1438	1096	1078	1078
   query2	6201	1818	1827	1818
   query3	10998	4550	4472	4472
   query4	53261	25460	23769	23769
   query5	5255	503	447	447
   query6	335	194	183	183
   query7	4936	512	295	295
   query8	313	246	224	224
   query9	5909	2635	2641	2635
   query10	436	338	269	269
   query11	15087	15044	15062	15044
   query12	166	117	109	109
   query13	1065	523	424	424
   query14	10081	6231	6297	6231
   query15	211	221	199	199
   query16	6996	655	537	537
   query17	1113	731	612	612
   query18	1573	416	328	328
   query19	204	197	194	194
   query20	136	120	115	115
   query21	208	127	117	117
   query22	4485	4455	4374	4374
   query23	34257	33548	33460	33460
   query24	6892	2397	2459	2397
   query25	463	467	418	418
   query26	752	274	161	161
   query27	2451	518	353	353
   query28	3454	2155	2146	2146
   query29	586	554	446	446
   query30	272	216	188	188
   query31	854	880	819	819
   query32	73	65	64	64
   query33	478	374	304	304
   query34	790	846	559	559
   query35	793	856	732	732
   query36	933	992	894	894
   query37	115	98	76	76
   query38	4232	4282	4169	4169
   query39	1636	1454	1461	1454
   query40	214	126	108	108
   query41	56	54	52	52
   query42	127	121	110	110
   query43	506	516	478	478
   query44	1301	849	853	849
   query45	183	178	169	169
   query46	866	1038	672	672
   query47	1845	1861	1814	1814
   query48	398	439	333	333
   query49	708	500	457	457
   query50	652	680	413	413
   query51	4332	4289	4293	4289
   query52	114	111	101	101
   query53	225	261	189	189
   query54	597	591	526	526
   query55	91	85	88	85
   query56	336	294	306	294
   query57	1253	1194	1136	1136
   query58	275	277	260	260
   query59	2714	2788	2605	2605
   query60	345	328	318	318
   query61	140	123	124	123
   query62	737	757	734	734
   query63	223	188	198	188
   query64	2302	1004	723	723
   query65	4323	4246	4234	4234
   query66	753	399	306	306
   query67	15993	15524	15464	15464
   query68	6954	885	513	513
   query69	540	310	266	266
   query70	1137	1121	1108	1108
   query71	491	320	301	301
   query72	5965	4739	4864	4739
   query73	1369	646	361	361
   query74	8894	9147	8983	8983
   query75	3885	3178	2699	2699
   query76	4199	1191	744	744
   query77	613	366	286	286
   query78	10198	10162	9295	9295
   query79	2476	784	584	584
   query80	608	507	499	499
   query81	485	261	230	230
   query82	436	122	99	99
   query83	411	250	234	234
   query84	295	112	83	83
   query85	787	351	314	314
   query86	379	314	286	286
   query87	4417	4511	4307	4307
   query88	3609	2333	2326	2326
   query89	406	326	287	287
   query90	1786	218	210	210
   query91	144	141	117	117
   query92	78	62	57	57
   query93	1898	932	578	578
   query94	667	416	305	305
   query95	377	299	286	286
   query96	518	573	286	286
   query97	2761	2767	2625	2625
   query98	253	220	208	208
   query99	1474	1427	1286	1286
   Total cold run time: 299557 ms
   Total hot run time: 193646 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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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


##########
fe/fe-core/src/main/java/org/apache/doris/statistics/TableStatsMeta.java:
##########
@@ -193,17 +193,23 @@ public void update(AnalysisInfo analyzedJob, TableIf tableIf) {
         jobType = analyzedJob.jobType;
         if (tableIf != null) {
             if (tableIf instanceof OlapTable) {
+                OlapTable olapTable = (OlapTable) tableIf;
                 indexesRowCount.putAll(analyzedJob.indexesRowCount);
-                clearStaleIndexRowCount((OlapTable) tableIf);
+                clearStaleIndexRowCount(olapTable);
+                Set<Pair<String, String>> columnIndexPairs = olapTable.getColumnIndexPairs(

Review Comment:
   why not get below set used in containsAll directly?



-- 
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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on code in PR #51116:
URL: https://github.com/apache/doris/pull/51116#discussion_r2102341922


##########
fe/fe-core/src/main/java/org/apache/doris/statistics/TableStatsMeta.java:
##########
@@ -193,17 +193,23 @@ public void update(AnalysisInfo analyzedJob, TableIf tableIf) {
         jobType = analyzedJob.jobType;
         if (tableIf != null) {
             if (tableIf instanceof OlapTable) {
+                OlapTable olapTable = (OlapTable) tableIf;
                 indexesRowCount.putAll(analyzedJob.indexesRowCount);
-                clearStaleIndexRowCount((OlapTable) tableIf);
+                clearStaleIndexRowCount(olapTable);
+                Set<Pair<String, String>> columnIndexPairs = olapTable.getColumnIndexPairs(

Review Comment:
   fixed



-- 
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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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


-- 
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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 185761 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 e7c18b585e936104fde636f05f720488c4ee7937, data reload: false
   
   query1	1026	474	505	474
   query2	6567	1855	1820	1820
   query3	6738	238	217	217
   query4	26084	23793	23125	23125
   query5	4315	602	472	472
   query6	326	215	197	197
   query7	4624	497	284	284
   query8	293	250	240	240
   query9	8601	2613	2616	2613
   query10	497	323	274	274
   query11	15645	15116	14917	14917
   query12	158	114	108	108
   query13	1664	537	404	404
   query14	9433	6383	6407	6383
   query15	213	190	170	170
   query16	7297	642	467	467
   query17	1191	721	587	587
   query18	1981	396	316	316
   query19	197	192	163	163
   query20	123	123	123	123
   query21	213	126	113	113
   query22	4116	4141	4028	4028
   query23	33896	33065	33075	33065
   query24	8452	2366	2387	2366
   query25	535	483	394	394
   query26	1228	265	150	150
   query27	2747	492	339	339
   query28	4353	2134	2116	2116
   query29	749	544	447	447
   query30	278	219	187	187
   query31	942	866	751	751
   query32	78	67	65	65
   query33	562	406	313	313
   query34	795	851	505	505
   query35	799	815	724	724
   query36	937	976	902	902
   query37	112	102	77	77
   query38	4058	4123	4075	4075
   query39	1458	1407	1421	1407
   query40	211	118	104	104
   query41	59	51	52	51
   query42	122	110	104	104
   query43	494	499	467	467
   query44	1301	809	810	809
   query45	179	174	167	167
   query46	834	1018	653	653
   query47	1761	1808	1731	1731
   query48	394	419	305	305
   query49	754	509	428	428
   query50	654	689	395	395
   query51	4215	4126	4091	4091
   query52	104	106	95	95
   query53	217	251	186	186
   query54	585	567	513	513
   query55	84	80	81	80
   query56	296	298	300	298
   query57	1172	1152	1115	1115
   query58	260	253	248	248
   query59	2622	2714	2622	2622
   query60	329	320	307	307
   query61	125	127	124	124
   query62	805	699	652	652
   query63	225	185	188	185
   query64	4339	996	659	659
   query65	4359	4213	4214	4213
   query66	1137	407	315	315
   query67	15858	15679	15303	15303
   query68	8269	877	515	515
   query69	487	308	264	264
   query70	1242	1147	1066	1066
   query71	494	326	302	302
   query72	5631	4693	4665	4665
   query73	693	593	345	345
   query74	9334	9071	8817	8817
   query75	3927	3188	2686	2686
   query76	3755	1202	739	739
   query77	791	361	286	286
   query78	10004	10099	9297	9297
   query79	2896	819	584	584
   query80	636	519	442	442
   query81	469	263	220	220
   query82	464	127	95	95
   query83	284	249	233	233
   query84	283	105	91	91
   query85	797	354	313	313
   query86	339	319	296	296
   query87	4488	4435	4305	4305
   query88	3258	2381	2315	2315
   query89	419	321	292	292
   query90	1957	229	214	214
   query91	153	137	114	114
   query92	76	62	56	56
   query93	1601	942	581	581
   query94	673	426	306	306
   query95	381	301	286	286
   query96	502	571	287	287
   query97	2704	2762	2656	2656
   query98	230	213	210	210
   query99	1461	1454	1285	1285
   Total cold run time: 275474 ms
   Total hot run time: 185761 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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.56 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 e7c18b585e936104fde636f05f720488c4ee7937, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.12	0.11	0.10
   query3	0.24	0.20	0.19
   query4	1.60	0.18	0.18
   query5	0.51	0.45	0.44
   query6	1.58	0.65	0.66
   query7	0.02	0.02	0.01
   query8	0.04	0.04	0.04
   query9	0.58	0.51	0.50
   query10	0.58	0.56	0.56
   query11	0.15	0.11	0.10
   query12	0.14	0.11	0.11
   query13	0.61	0.60	0.61
   query14	0.79	0.81	0.80
   query15	0.86	0.86	0.85
   query16	0.38	0.38	0.38
   query17	1.00	0.99	1.06
   query18	0.22	0.21	0.20
   query19	1.93	1.81	1.79
   query20	0.01	0.01	0.01
   query21	15.47	0.90	0.54
   query22	0.75	1.06	0.69
   query23	15.04	1.37	0.66
   query24	7.88	0.93	0.30
   query25	0.42	0.15	0.12
   query26	0.64	0.17	0.15
   query27	0.06	0.05	0.04
   query28	9.26	0.92	0.46
   query29	12.57	3.95	3.30
   query30	0.25	0.09	0.07
   query31	2.82	0.60	0.39
   query32	3.23	0.56	0.47
   query33	3.01	3.05	3.11
   query34	15.83	5.03	4.49
   query35	4.47	4.50	4.51
   query36	0.66	0.49	0.47
   query37	0.08	0.06	0.07
   query38	0.05	0.04	0.04
   query39	0.03	0.02	0.02
   query40	0.17	0.15	0.13
   query41	0.08	0.03	0.03
   query42	0.04	0.02	0.02
   query43	0.03	0.03	0.03
   Total cold run time: 104.24 s
   Total hot run time: 28.56 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](statistics)Fix sample analyze agg/mor table doesn't remove new partition flag bug. [doris]

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

   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