You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2025/12/17 02:34:25 UTC

[PR] [only test now] check use count in clear_column_data [doris]

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

   ### What problem does this PR solve?
   
   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. -->
       - [ ] 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] [only test now] check use count in clear_column_data [doris]

Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange closed pull request #59100: [only test now] check use count in clear_column_data
URL: https://github.com/apache/doris/pull/59100


-- 
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] [only test now] check use count in clear_column_data [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 35471 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 a6c0d08e378201798b221858bf335f145a308bfe, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17626	4355	4158	4158
   q2	2038	375	246	246
   q3	10171	1361	785	785
   q4	10238	967	328	328
   q5	7566	2102	1975	1975
   q6	193	179	139	139
   q7	1023	863	712	712
   q8	9352	1414	1157	1157
   q9	6984	5310	5298	5298
   q10	6803	2402	1998	1998
   q11	553	326	302	302
   q12	642	736	597	597
   q13	17783	3670	3071	3071
   q14	311	292	275	275
   q15	590	536	531	531
   q16	688	674	617	617
   q17	686	818	550	550
   q18	7714	7164	7084	7084
   q19	1247	977	621	621
   q20	401	357	255	255
   q21	4275	3895	3820	3820
   q22	1041	1023	952	952
   Total cold run time: 107925 ms
   Total hot run time: 35471 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4132	4083	4158	4083
   q2	344	409	319	319
   q3	2184	2667	2247	2247
   q4	1374	1750	1285	1285
   q5	4243	4770	4643	4643
   q6	232	178	133	133
   q7	2078	1993	1887	1887
   q8	2721	2603	2614	2603
   q9	7782	7299	7390	7299
   q10	3120	3288	2952	2952
   q11	604	529	589	529
   q12	811	745	603	603
   q13	3555	3825	3265	3265
   q14	295	313	299	299
   q15	568	522	522	522
   q16	688	696	634	634
   q17	1283	1467	1412	1412
   q18	8073	7728	7557	7557
   q19	955	891	905	891
   q20	2037	2062	1940	1940
   q21	5034	4653	4480	4480
   q22	1111	1046	988	988
   Total cold run time: 53224 ms
   Total hot run time: 50571 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] [only test now] check use count in clear_column_data [doris]

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

   
   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] [only test now] check use count in clear_column_data [doris]

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

   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] [only test now] check use count in clear_column_data [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 178600 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 a6c0d08e378201798b221858bf335f145a308bfe, data reload: false
   
   query5	4408	586	467	467
   query6	342	239	224	224
   query7	4227	485	283	283
   query8	318	264	257	257
   query9	8753	2558	2571	2558
   query10	497	392	332	332
   query11	15327	15128	14659	14659
   query12	199	118	122	118
   query13	1280	499	401	401
   query14	6246	3164	2741	2741
   query14_1	2757	2679	2724	2679
   query15	213	200	179	179
   query16	768	471	441	441
   query17	1116	704	596	596
   query18	2566	430	331	331
   query19	232	223	201	201
   query20	117	117	111	111
   query21	213	139	114	114
   query22	3868	3879	3932	3879
   query23	16539	16198	15943	15943
   query23_1	16035	16079	15980	15980
   query24	7352	1672	1257	1257
   query24_1	1290	1257	1301	1257
   query25	583	513	470	470
   query26	1246	272	206	206
   query27	2709	482	318	318
   query28	4490	2132	2138	2132
   query29	796	543	442	442
   query30	318	249	213	213
   query31	829	724	617	617
   query32	77	70	67	67
   query33	542	343	294	294
   query34	916	904	565	565
   query35	780	812	765	765
   query36	851	921	830	830
   query37	128	93	91	91
   query38	2848	2900	2866	2866
   query39	750	773	728	728
   query39_1	693	711	695	695
   query40	225	148	134	134
   query41	72	70	63	63
   query42	115	106	112	106
   query43	456	449	417	417
   query44	1377	751	747	747
   query45	195	193	184	184
   query46	904	991	616	616
   query47	1658	1650	1616	1616
   query48	327	347	245	245
   query49	641	447	361	361
   query50	692	307	215	215
   query51	3797	3801	3849	3801
   query52	111	115	108	108
   query53	344	355	295	295
   query54	295	267	251	251
   query55	81	78	71	71
   query56	305	312	297	297
   query57	1142	1147	1096	1096
   query58	269	251	259	251
   query59	2341	2453	2379	2379
   query60	321	321	296	296
   query61	166	167	170	167
   query62	708	676	617	617
   query63	336	308	306	306
   query64	4909	1340	1038	1038
   query65	3983	3982	3977	3977
   query66	1439	439	329	329
   query67	15079	14872	14658	14658
   query68	2760	1066	764	764
   query69	450	365	332	332
   query70	1076	1026	1003	1003
   query71	330	298	281	281
   query72	6238	5177	5103	5103
   query73	520	616	312	312
   query74	8644	8879	8491	8491
   query75	3117	3171	2790	2790
   query76	2835	1171	734	734
   query77	372	386	311	311
   query78	9465	9714	8888	8888
   query79	1079	933	615	615
   query80	732	677	563	563
   query81	511	266	234	234
   query82	1350	141	106	106
   query83	366	271	245	245
   query84	262	129	113	113
   query85	919	537	482	482
   query86	319	303	284	284
   query87	3095	3077	2890	2890
   query88	3264	2276	2257	2257
   query89	471	421	386	386
   query90	1882	162	144	144
   query91	177	169	150	150
   query92	69	74	66	66
   query93	1035	896	561	561
   query94	366	307	287	287
   query95	573	341	309	309
   query96	599	466	216	216
   query97	2274	2302	2237	2237
   query98	203	195	195	195
   query99	1328	1292	1216	1216
   Total cold run time: 251854 ms
   Total hot run time: 178600 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] [only test now] check use count in clear_column_data [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27 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 a6c0d08e378201798b221858bf335f145a308bfe, data reload: false
   
   query1	0.05	0.04	0.05
   query2	0.09	0.05	0.05
   query3	0.26	0.09	0.08
   query4	1.62	0.11	0.11
   query5	0.28	0.27	0.27
   query6	1.17	0.64	0.62
   query7	0.03	0.03	0.02
   query8	0.06	0.04	0.04
   query9	0.58	0.49	0.50
   query10	0.56	0.56	0.54
   query11	0.15	0.10	0.12
   query12	0.14	0.10	0.10
   query13	0.62	0.61	0.59
   query14	1.01	1.00	0.97
   query15	0.81	0.80	0.80
   query16	0.42	0.41	0.39
   query17	1.00	0.98	0.98
   query18	0.24	0.20	0.22
   query19	1.85	1.78	1.80
   query20	0.02	0.01	0.01
   query21	15.43	0.28	0.15
   query22	4.86	0.05	0.05
   query23	16.11	0.29	0.10
   query24	1.01	0.33	0.19
   query25	0.08	0.08	0.06
   query26	0.14	0.13	0.14
   query27	0.08	0.05	0.05
   query28	3.12	1.23	1.02
   query29	12.56	4.01	3.21
   query30	0.28	0.14	0.11
   query31	2.81	0.61	0.38
   query32	3.22	0.55	0.46
   query33	2.97	2.95	3.09
   query34	16.85	5.17	4.56
   query35	4.54	4.57	4.56
   query36	0.66	0.50	0.49
   query37	0.11	0.06	0.06
   query38	0.07	0.04	0.04
   query39	0.04	0.03	0.04
   query40	0.17	0.15	0.13
   query41	0.10	0.03	0.03
   query42	0.04	0.03	0.03
   query43	0.04	0.04	0.03
   Total cold run time: 96.25 s
   Total hot run time: 27 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