You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "BePPPower (via GitHub)" <gi...@apache.org> on 2025/05/16 14:44:14 UTC

[PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   Problem Summary:
   
   related pr: #48172
   
   This pr had changed the code logical of method `beforeMTMVRefresh`, but this pr added the code back.
   So we delete this code.
   
   ### 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](MTMV) mtmv not refresh cache of external table before run task [doris]

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


-- 
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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186056 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 1f1d5e464975ebfbffdbec90c7ecd168e5db3fc3, data reload: false
   
   query1	1006	475	499	475
   query2	6777	1906	1915	1906
   query3	6750	230	217	217
   query4	26860	23897	23314	23314
   query5	4743	634	472	472
   query6	305	196	190	190
   query7	4627	489	296	296
   query8	301	249	235	235
   query9	8639	2638	2638	2638
   query10	497	344	287	287
   query11	15876	15065	14805	14805
   query12	160	120	108	108
   query13	1662	531	407	407
   query14	9242	6165	6075	6075
   query15	208	202	173	173
   query16	7213	612	476	476
   query17	1169	735	628	628
   query18	1980	402	293	293
   query19	198	210	162	162
   query20	122	118	117	117
   query21	208	128	108	108
   query22	4081	4096	3944	3944
   query23	33918	33096	32970	32970
   query24	8427	2418	2438	2418
   query25	533	473	388	388
   query26	1087	269	151	151
   query27	2732	511	351	351
   query28	4288	2124	2114	2114
   query29	756	583	432	432
   query30	285	219	192	192
   query31	960	881	734	734
   query32	69	66	65	65
   query33	536	365	301	301
   query34	821	856	536	536
   query35	785	813	725	725
   query36	965	1005	896	896
   query37	118	104	75	75
   query38	4113	4046	3983	3983
   query39	1484	1418	1430	1418
   query40	206	116	106	106
   query41	58	54	53	53
   query42	122	121	112	112
   query43	525	510	486	486
   query44	1321	830	846	830
   query45	178	174	168	168
   query46	837	1019	645	645
   query47	1775	1767	1717	1717
   query48	392	421	309	309
   query49	783	503	434	434
   query50	641	678	420	420
   query51	4250	4143	4099	4099
   query52	111	109	97	97
   query53	220	248	185	185
   query54	587	575	501	501
   query55	87	82	84	82
   query56	320	321	307	307
   query57	1144	1159	1075	1075
   query58	271	258	282	258
   query59	2797	2717	2698	2698
   query60	335	340	317	317
   query61	128	121	130	121
   query62	776	725	635	635
   query63	225	189	195	189
   query64	4010	989	644	644
   query65	4309	4234	4236	4234
   query66	1091	421	347	347
   query67	15916	15431	15507	15431
   query68	7957	885	522	522
   query69	479	317	286	286
   query70	1221	1093	1109	1093
   query71	465	333	360	333
   query72	5509	4710	4797	4710
   query73	724	636	363	363
   query74	9358	9139	8805	8805
   query75	3808	3139	2674	2674
   query76	3607	1191	773	773
   query77	790	378	289	289
   query78	9939	10352	9434	9434
   query79	1976	789	596	596
   query80	607	524	469	469
   query81	468	255	216	216
   query82	425	130	97	97
   query83	259	253	290	253
   query84	250	105	85	85
   query85	789	350	306	306
   query86	340	313	278	278
   query87	4371	4399	4494	4399
   query88	3091	2353	2355	2353
   query89	396	320	291	291
   query90	1916	221	212	212
   query91	196	146	109	109
   query92	73	61	56	56
   query93	1072	955	577	577
   query94	664	384	290	290
   query95	381	298	285	285
   query96	512	573	288	288
   query97	2712	2738	2592	2592
   query98	245	209	197	197
   query99	1475	1436	1250	1250
   Total cold run time: 273991 ms
   Total hot run time: 186056 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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33970 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 7aec445c1e52a074ca7b5b8d63ef709cc3112a1a, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26239	5055	5032	5032
   q2	2069	287	185	185
   q3	10486	1268	709	709
   q4	10233	1036	505	505
   q5	7830	2378	2314	2314
   q6	184	166	133	133
   q7	901	728	628	628
   q8	9325	1258	1126	1126
   q9	6860	5165	5069	5069
   q10	6809	2322	1919	1919
   q11	472	293	279	279
   q12	342	352	215	215
   q13	17779	3628	3090	3090
   q14	236	232	217	217
   q15	536	496	479	479
   q16	421	441	368	368
   q17	622	857	370	370
   q18	7620	7224	7235	7224
   q19	1876	964	577	577
   q20	338	329	219	219
   q21	3781	3165	2357	2357
   q22	1025	1015	955	955
   Total cold run time: 115984 ms
   Total hot run time: 33970 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5212	5086	5057	5057
   q2	234	322	226	226
   q3	2172	2766	2288	2288
   q4	1322	1762	1390	1390
   q5	4489	4416	4339	4339
   q6	216	172	133	133
   q7	1977	1972	1764	1764
   q8	2572	2511	2452	2452
   q9	7182	7049	7177	7049
   q10	3036	3148	2792	2792
   q11	563	508	485	485
   q12	661	790	620	620
   q13	3477	3867	3361	3361
   q14	289	305	265	265
   q15	516	486	473	473
   q16	444	489	432	432
   q17	1142	1569	1345	1345
   q18	7714	7433	7346	7346
   q19	793	795	857	795
   q20	1993	2012	1938	1938
   q21	4856	4342	4428	4342
   q22	1062	1022	956	956
   Total cold run time: 51922 ms
   Total hot run time: 49848 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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 33753 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 1f1d5e464975ebfbffdbec90c7ecd168e5db3fc3, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	26204	5063	4974	4974
   q2	2082	292	180	180
   q3	10480	1275	717	717
   q4	10240	1032	537	537
   q5	7635	2354	2348	2348
   q6	178	164	134	134
   q7	925	790	642	642
   q8	9323	1349	1108	1108
   q9	6803	5122	5004	5004
   q10	6830	2323	1909	1909
   q11	508	284	268	268
   q12	352	355	208	208
   q13	17775	3686	3075	3075
   q14	236	222	217	217
   q15	521	479	487	479
   q16	447	427	393	393
   q17	594	877	363	363
   q18	7678	7206	7112	7112
   q19	1394	949	568	568
   q20	332	347	223	223
   q21	3775	3225	2346	2346
   q22	1049	977	948	948
   Total cold run time: 115361 ms
   Total hot run time: 33753 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5074	5240	5063	5063
   q2	246	327	233	233
   q3	2175	2667	2325	2325
   q4	1313	1743	1357	1357
   q5	4619	4469	4457	4457
   q6	222	172	123	123
   q7	1947	1947	1748	1748
   q8	2622	2596	2498	2498
   q9	7172	7095	7184	7095
   q10	3006	3209	2708	2708
   q11	574	513	494	494
   q12	678	736	614	614
   q13	3581	4057	3211	3211
   q14	283	290	266	266
   q15	507	481	478	478
   q16	452	491	430	430
   q17	1172	1549	1417	1417
   q18	7683	7557	7513	7513
   q19	807	871	976	871
   q20	2051	2066	1897	1897
   q21	4765	4340	4217	4217
   q22	1072	966	981	966
   Total cold run time: 52021 ms
   Total hot run time: 49981 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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 28.93 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 1f1d5e464975ebfbffdbec90c7ecd168e5db3fc3, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.12	0.11	0.11
   query3	0.26	0.20	0.18
   query4	1.59	0.20	0.19
   query5	0.45	0.45	0.46
   query6	1.15	0.67	0.67
   query7	0.02	0.01	0.02
   query8	0.04	0.04	0.04
   query9	0.60	0.51	0.51
   query10	0.58	0.58	0.57
   query11	0.15	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.62	0.59	0.59
   query14	0.79	0.81	0.82
   query15	0.88	0.85	0.86
   query16	0.38	0.40	0.39
   query17	1.04	1.04	1.02
   query18	0.22	0.22	0.21
   query19	1.91	1.84	1.89
   query20	0.01	0.01	0.01
   query21	15.41	0.89	0.53
   query22	0.75	1.40	0.72
   query23	14.73	1.40	0.65
   query24	7.32	1.22	0.46
   query25	0.52	0.17	0.08
   query26	0.63	0.18	0.15
   query27	0.05	0.05	0.06
   query28	9.02	0.91	0.43
   query29	12.59	4.07	3.41
   query30	0.24	0.09	0.06
   query31	2.82	0.61	0.39
   query32	3.25	0.54	0.48
   query33	3.04	3.05	3.05
   query34	15.77	5.10	4.48
   query35	4.45	4.50	4.49
   query36	0.66	0.50	0.48
   query37	0.08	0.06	0.06
   query38	0.05	0.04	0.03
   query39	0.04	0.02	0.03
   query40	0.19	0.14	0.13
   query41	0.08	0.02	0.02
   query42	0.03	0.02	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 102.76 s
   Total hot run time: 28.93 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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 185528 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 7aec445c1e52a074ca7b5b8d63ef709cc3112a1a, data reload: false
   
   query1	1034	493	542	493
   query2	6564	1928	1864	1864
   query3	6763	233	218	218
   query4	26107	23805	22873	22873
   query5	4383	630	461	461
   query6	308	211	210	210
   query7	4628	492	290	290
   query8	308	267	249	249
   query9	8580	2600	2610	2600
   query10	493	335	286	286
   query11	15913	15009	14778	14778
   query12	170	110	114	110
   query13	1667	522	429	429
   query14	9587	6205	6125	6125
   query15	221	213	163	163
   query16	7250	605	491	491
   query17	1180	710	570	570
   query18	1968	394	291	291
   query19	194	207	151	151
   query20	131	116	113	113
   query21	210	129	104	104
   query22	3989	4085	4002	4002
   query23	33882	33049	33099	33049
   query24	8425	2403	2396	2396
   query25	534	468	390	390
   query26	1229	270	156	156
   query27	2754	498	340	340
   query28	4300	2107	2096	2096
   query29	762	560	438	438
   query30	277	218	186	186
   query31	988	815	784	784
   query32	71	65	62	62
   query33	549	381	303	303
   query34	802	846	527	527
   query35	774	805	731	731
   query36	951	971	889	889
   query37	117	101	75	75
   query38	4095	4044	4031	4031
   query39	1489	1436	1425	1425
   query40	214	125	114	114
   query41	57	53	54	53
   query42	133	118	108	108
   query43	500	499	487	487
   query44	1310	818	818	818
   query45	183	180	170	170
   query46	847	1039	649	649
   query47	1772	1775	1719	1719
   query48	401	423	326	326
   query49	816	535	459	459
   query50	665	679	413	413
   query51	4194	4149	4042	4042
   query52	147	115	100	100
   query53	222	252	178	178
   query54	595	568	498	498
   query55	83	85	84	84
   query56	305	293	291	291
   query57	1124	1148	1079	1079
   query58	282	268	256	256
   query59	2719	2791	2590	2590
   query60	322	319	318	318
   query61	127	123	123	123
   query62	860	737	658	658
   query63	222	180	185	180
   query64	4348	1027	714	714
   query65	4322	4223	4252	4223
   query66	1144	403	314	314
   query67	15733	15505	15533	15505
   query68	8729	887	531	531
   query69	478	305	269	269
   query70	1233	1060	1125	1060
   query71	482	318	297	297
   query72	5573	4801	4761	4761
   query73	712	607	361	361
   query74	9021	8808	8644	8644
   query75	4062	3187	2700	2700
   query76	3767	1192	752	752
   query77	803	381	289	289
   query78	10133	10036	9296	9296
   query79	2924	832	580	580
   query80	628	506	450	450
   query81	502	254	226	226
   query82	512	122	99	99
   query83	296	262	243	243
   query84	309	109	86	86
   query85	807	365	320	320
   query86	396	295	300	295
   query87	4488	4433	4396	4396
   query88	3603	2329	2319	2319
   query89	412	317	288	288
   query90	1874	215	212	212
   query91	143	194	130	130
   query92	74	62	58	58
   query93	2176	977	579	579
   query94	677	407	306	306
   query95	379	300	290	290
   query96	500	573	287	287
   query97	2783	2739	2667	2667
   query98	239	208	200	200
   query99	1481	1424	1319	1319
   Total cold run time: 277490 ms
   Total hot run time: 185528 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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   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](MTMV) mtmv not refresh cache of external table before run task [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.1 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 7aec445c1e52a074ca7b5b8d63ef709cc3112a1a, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.13	0.10	0.11
   query3	0.26	0.20	0.20
   query4	1.61	0.20	0.19
   query5	0.49	0.45	0.45
   query6	1.16	0.67	0.66
   query7	0.02	0.02	0.02
   query8	0.04	0.04	0.04
   query9	0.60	0.51	0.52
   query10	0.58	0.57	0.57
   query11	0.15	0.11	0.11
   query12	0.15	0.11	0.12
   query13	0.62	0.60	0.59
   query14	0.79	0.78	0.80
   query15	0.87	0.85	0.84
   query16	0.38	0.40	0.38
   query17	1.04	1.04	1.05
   query18	0.22	0.21	0.22
   query19	1.93	1.76	1.80
   query20	0.01	0.02	0.01
   query21	15.41	0.88	0.55
   query22	0.77	1.37	0.66
   query23	14.79	1.37	0.66
   query24	6.87	2.43	0.88
   query25	0.50	0.36	0.09
   query26	0.54	0.15	0.13
   query27	0.06	0.05	0.05
   query28	9.72	0.85	0.44
   query29	12.70	4.04	3.34
   query30	0.25	0.09	0.07
   query31	2.82	0.59	0.39
   query32	3.22	0.55	0.46
   query33	3.03	3.02	3.13
   query34	15.78	5.13	4.47
   query35	4.51	4.50	4.51
   query36	0.67	0.49	0.47
   query37	0.08	0.06	0.06
   query38	0.05	0.04	0.04
   query39	0.03	0.02	0.03
   query40	0.17	0.13	0.12
   query41	0.08	0.03	0.03
   query42	0.04	0.03	0.02
   query43	0.03	0.04	0.03
   Total cold run time: 103.21 s
   Total hot run time: 29.1 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