Skip to content

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

[Improve](mtmv) skip the generation of invalid task for refresh mtmv #46280

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 8 commits into from
Jan 3, 2025

Conversation

qzsee
Copy link
Contributor

@qzsee qzsee commented Jan 2, 2025

What problem does this PR solve?

We specified the excluded_trigger_tables = 'a' attribute when creating the materialized view. If table a is updated frequently, many invalid tasks will be generated, and these tasks do not really refresh the mv, which is unreasonable, too many invalid tasks will wash away useful task information

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

  • Test

    • 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
  • Behavior changed:

    • No.
    • Yes.
  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@hello-stephen
Copy link
Contributor

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See 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?

@qzsee qzsee force-pushed the no-generate-task branch from 3451c20 to 3a9d13e Compare January 2, 2025 10:35
@doris-robot
Copy link

TPC-H: Total hot run time: 32659 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 3a9d13e5e0c175a606e06d2f8729219946b944ef, data reload: false

------ Round 1 ----------------------------------
q1	17620	6197	6041	6041
q2	2044	286	167	167
q3	10436	1265	721	721
q4	10212	852	431	431
q5	7530	2154	1936	1936
q6	201	182	145	145
q7	877	774	602	602
q8	9248	1369	1157	1157
q9	5196	4941	4888	4888
q10	6771	2296	1916	1916
q11	469	277	262	262
q12	340	356	225	225
q13	17770	3693	3129	3129
q14	240	230	218	218
q15	574	513	490	490
q16	630	611	597	597
q17	591	838	345	345
q18	7083	6518	6372	6372
q19	1242	975	557	557
q20	310	325	195	195
q21	2824	2124	1949	1949
q22	354	333	316	316
Total cold run time: 102562 ms
Total hot run time: 32659 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6270	6316	6323	6316
q2	235	323	234	234
q3	2211	2640	2328	2328
q4	1388	1854	1402	1402
q5	4330	4770	4758	4758
q6	195	176	147	147
q7	2073	1985	1770	1770
q8	2619	2785	2665	2665
q9	7383	7217	7235	7217
q10	3071	3360	2796	2796
q11	585	528	499	499
q12	661	740	578	578
q13	3481	3859	3206	3206
q14	291	315	275	275
q15	578	524	503	503
q16	634	686	669	669
q17	1206	1741	1229	1229
q18	7678	7576	7122	7122
q19	794	1105	1058	1058
q20	1912	1952	1873	1873
q21	5364	5089	4887	4887
q22	572	581	563	563
Total cold run time: 53531 ms
Total hot run time: 52095 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 191204 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 3a9d13e5e0c175a606e06d2f8729219946b944ef, data reload: false

query1	959	389	358	358
query2	6518	2401	2296	2296
query3	6703	214	219	214
query4	33382	23961	23459	23459
query5	4281	601	459	459
query6	280	204	190	190
query7	4628	490	301	301
query8	303	258	243	243
query9	9563	2655	2640	2640
query10	449	325	258	258
query11	18387	15297	15242	15242
query12	152	107	100	100
query13	1672	529	385	385
query14	9745	8048	7330	7330
query15	240	187	189	187
query16	8266	613	454	454
query17	1567	721	541	541
query18	2139	394	297	297
query19	222	174	149	149
query20	121	121	116	116
query21	209	122	102	102
query22	4468	4323	4293	4293
query23	34255	33848	33532	33532
query24	6549	2265	2253	2253
query25	532	472	399	399
query26	1199	280	157	157
query27	2054	465	340	340
query28	5263	2417	2430	2417
query29	773	567	477	477
query30	229	184	147	147
query31	979	897	814	814
query32	101	58	61	58
query33	503	357	292	292
query34	763	822	498	498
query35	818	804	753	753
query36	1023	1030	983	983
query37	118	100	73	73
query38	4146	4148	4130	4130
query39	1493	1478	1427	1427
query40	214	115	100	100
query41	51	45	44	44
query42	122	154	98	98
query43	524	531	509	509
query44	1320	789	804	789
query45	180	175	186	175
query46	856	1041	643	643
query47	1885	1889	1856	1856
query48	396	398	312	312
query49	799	474	387	387
query50	618	662	381	381
query51	7012	7112	7065	7065
query52	101	99	92	92
query53	229	252	184	184
query54	481	496	405	405
query55	82	79	77	77
query56	250	268	235	235
query57	1204	1198	1153	1153
query58	237	239	260	239
query59	3280	3070	2978	2978
query60	278	260	256	256
query61	122	106	107	106
query62	874	818	742	742
query63	230	185	193	185
query64	4600	976	642	642
query65	3297	3191	3204	3191
query66	1070	416	356	356
query67	16096	15950	15624	15624
query68	8474	702	511	511
query69	464	292	251	251
query70	1240	1140	1071	1071
query71	434	285	258	258
query72	6057	3751	3883	3751
query73	654	742	355	355
query74	10346	9147	9410	9147
query75	3955	3177	2653	2653
query76	3715	1192	763	763
query77	771	372	275	275
query78	9979	10079	9580	9580
query79	3587	815	604	604
query80	714	514	431	431
query81	473	266	229	229
query82	594	151	117	117
query83	196	214	148	148
query84	277	89	66	66
query85	779	365	305	305
query86	360	300	307	300
query87	4636	4478	4689	4478
query88	4272	2187	2157	2157
query89	416	326	352	326
query90	1922	192	185	185
query91	136	136	105	105
query92	69	57	54	54
query93	1182	862	541	541
query94	658	398	283	283
query95	326	271	262	262
query96	480	611	287	287
query97	2927	2976	2867	2867
query98	225	202	194	194
query99	1659	1563	1462	1462
Total cold run time: 293437 ms
Total hot run time: 191204 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 31.97 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 3a9d13e5e0c175a606e06d2f8729219946b944ef, data reload: false

query1	0.04	0.04	0.04
query2	0.07	0.03	0.04
query3	0.23	0.07	0.07
query4	1.61	0.10	0.11
query5	0.44	0.40	0.41
query6	1.17	0.65	0.66
query7	0.02	0.02	0.01
query8	0.04	0.03	0.04
query9	0.59	0.50	0.49
query10	0.55	0.57	0.56
query11	0.14	0.11	0.11
query12	0.14	0.11	0.11
query13	0.61	0.60	0.58
query14	2.70	2.86	2.83
query15	0.90	0.83	0.82
query16	0.39	0.37	0.39
query17	0.96	1.07	1.05
query18	0.22	0.21	0.21
query19	1.92	1.82	1.95
query20	0.01	0.01	0.01
query21	15.36	0.98	0.60
query22	0.74	0.74	0.68
query23	15.31	1.43	0.54
query24	3.26	1.47	1.78
query25	0.12	0.16	0.20
query26	0.27	0.14	0.14
query27	0.06	0.04	0.04
query28	13.94	1.49	1.04
query29	12.54	3.96	3.23
query30	0.25	0.09	0.08
query31	2.83	0.60	0.37
query32	3.23	0.53	0.45
query33	3.03	2.99	3.07
query34	16.80	5.13	4.60
query35	4.48	4.51	4.53
query36	0.81	0.49	0.48
query37	0.10	0.06	0.05
query38	0.04	0.03	0.03
query39	0.03	0.02	0.03
query40	0.16	0.13	0.13
query41	0.08	0.02	0.03
query42	0.03	0.02	0.02
query43	0.03	0.04	0.03
Total cold run time: 106.25 s
Total hot run time: 31.97 s

@dqz123
Copy link

dqz123 commented Jan 2, 2025

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 33106 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f3792f445c544e3d04875ae1722e5e53250e9a17, data reload: false

------ Round 1 ----------------------------------
q1	17581	6238	6112	6112
q2	2051	312	173	173
q3	10412	1306	754	754
q4	10217	880	470	470
q5	7544	2240	2026	2026
q6	211	185	150	150
q7	935	767	613	613
q8	9245	1414	1225	1225
q9	5389	5039	4923	4923
q10	6771	2332	1888	1888
q11	487	291	258	258
q12	356	366	239	239
q13	17778	3781	3118	3118
q14	229	243	215	215
q15	566	536	503	503
q16	653	634	582	582
q17	592	857	353	353
q18	7258	6371	6469	6371
q19	3856	974	561	561
q20	316	321	193	193
q21	2995	2321	2071	2071
q22	359	332	308	308
Total cold run time: 105801 ms
Total hot run time: 33106 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6451	6264	6314	6264
q2	241	333	234	234
q3	2210	2697	2370	2370
q4	1464	1860	1390	1390
q5	4403	4890	5040	4890
q6	191	180	144	144
q7	2146	1984	1865	1865
q8	2675	2831	2680	2680
q9	7286	7232	7313	7232
q10	3087	3348	2790	2790
q11	585	540	506	506
q12	671	742	620	620
q13	3531	3858	3401	3401
q14	288	326	269	269
q15	563	533	513	513
q16	630	687	658	658
q17	1263	1743	1254	1254
q18	7812	7449	6944	6944
q19	839	1158	1052	1052
q20	1965	1954	1843	1843
q21	5541	5080	4902	4902
q22	610	613	580	580
Total cold run time: 54452 ms
Total hot run time: 52401 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190859 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit f3792f445c544e3d04875ae1722e5e53250e9a17, data reload: false

query1	986	365	381	365
query2	6526	2429	2479	2429
query3	6710	219	216	216
query4	34195	23607	23833	23607
query5	4360	623	462	462
query6	292	200	186	186
query7	4624	506	303	303
query8	314	243	228	228
query9	9522	2675	2665	2665
query10	475	320	252	252
query11	17952	15327	15340	15327
query12	161	109	111	109
query13	1688	539	421	421
query14	9888	6964	8152	6964
query15	255	201	194	194
query16	8834	612	481	481
query17	1646	751	582	582
query18	2124	409	335	335
query19	217	171	153	153
query20	118	120	115	115
query21	209	125	105	105
query22	4333	4421	4440	4421
query23	34001	33091	33360	33091
query24	6321	2301	2258	2258
query25	492	458	363	363
query26	763	276	163	163
query27	2021	459	327	327
query28	5114	2422	2407	2407
query29	657	536	417	417
query30	228	189	152	152
query31	970	958	817	817
query32	87	61	56	56
query33	501	353	288	288
query34	774	832	504	504
query35	827	840	741	741
query36	1012	1037	982	982
query37	118	94	78	78
query38	4362	4284	4102	4102
query39	1495	1461	1421	1421
query40	205	119	98	98
query41	46	44	45	44
query42	119	101	101	101
query43	512	541	512	512
query44	1318	802	811	802
query45	181	182	171	171
query46	881	1053	650	650
query47	1944	1938	1898	1898
query48	379	397	326	326
query49	720	474	387	387
query50	656	637	399	399
query51	7165	7149	7188	7149
query52	111	102	91	91
query53	225	250	191	191
query54	485	484	415	415
query55	80	82	84	82
query56	264	263	233	233
query57	1217	1160	1117	1117
query58	246	223	251	223
query59	3162	3247	3055	3055
query60	279	255	263	255
query61	111	106	108	106
query62	951	805	769	769
query63	228	192	197	192
query64	3284	1045	646	646
query65	3303	3238	3287	3238
query66	864	421	322	322
query67	15958	15909	15466	15466
query68	7276	699	515	515
query69	483	297	257	257
query70	1243	1032	1162	1032
query71	448	289	258	258
query72	6244	4030	3825	3825
query73	649	739	363	363
query74	10439	9456	9234	9234
query75	4102	3115	2670	2670
query76	3749	1184	770	770
query77	762	355	281	281
query78	10186	10137	9368	9368
query79	3531	817	636	636
query80	585	521	425	425
query81	507	273	235	235
query82	669	161	125	125
query83	156	162	150	150
query84	244	87	72	72
query85	793	355	301	301
query86	401	313	292	292
query87	4613	4446	4412	4412
query88	4499	2172	2144	2144
query89	416	342	296	296
query90	1853	185	182	182
query91	133	135	105	105
query92	73	60	53	53
query93	1897	862	532	532
query94	659	364	292	292
query95	334	263	248	248
query96	489	600	274	274
query97	2908	3032	2846	2846
query98	231	221	204	204
query99	1525	1553	1437	1437
Total cold run time: 292163 ms
Total hot run time: 190859 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 32 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit f3792f445c544e3d04875ae1722e5e53250e9a17, data reload: false

query1	0.04	0.03	0.02
query2	0.07	0.03	0.04
query3	0.24	0.07	0.06
query4	1.61	0.11	0.10
query5	0.40	0.41	0.40
query6	1.18	0.66	0.65
query7	0.02	0.01	0.01
query8	0.04	0.03	0.02
query9	0.57	0.51	0.50
query10	0.55	0.55	0.56
query11	0.15	0.10	0.10
query12	0.14	0.10	0.11
query13	0.62	0.60	0.60
query14	2.72	2.74	2.82
query15	0.90	0.83	0.83
query16	0.39	0.39	0.38
query17	0.97	0.98	0.97
query18	0.23	0.21	0.21
query19	1.91	1.89	2.01
query20	0.02	0.02	0.01
query21	15.36	0.99	0.59
query22	0.76	0.76	0.58
query23	15.35	1.46	0.53
query24	3.01	1.68	1.87
query25	0.27	0.15	0.11
query26	0.19	0.17	0.12
query27	0.06	0.05	0.06
query28	14.40	1.51	1.04
query29	12.53	3.95	3.28
query30	0.24	0.08	0.06
query31	2.83	0.60	0.37
query32	3.23	0.54	0.45
query33	3.15	3.13	3.24
query34	16.53	5.14	4.57
query35	4.56	4.48	4.56
query36	0.64	0.49	0.48
query37	0.10	0.07	0.06
query38	0.04	0.04	0.03
query39	0.03	0.03	0.02
query40	0.17	0.14	0.12
query41	0.08	0.03	0.03
query42	0.04	0.02	0.03
query43	0.03	0.03	0.03
Total cold run time: 106.37 s
Total hot run time: 32 s

AS select a.sid,b.cid,b.score from ${tblStu} a join ${tblGrade} b on a.sid = b.sid;
"""

sleep(1000)
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

why sleep?

@dqz123
Copy link

dqz123 commented Jan 3, 2025

run buildall

Copy link
Contributor

@zddr zddr left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

Copy link
Contributor

github-actions bot commented Jan 3, 2025

PR approved by anyone and no changes requested.

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Jan 3, 2025
Copy link
Contributor

github-actions bot commented Jan 3, 2025

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

@doris-robot
Copy link

TPC-H: Total hot run time: 32837 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1893624414dae18956c67636e7775aca43e50b2f, data reload: false

------ Round 1 ----------------------------------
q1	17596	6119	6110	6110
q2	2054	295	170	170
q3	10431	1253	729	729
q4	10219	867	431	431
q5	7529	2156	1936	1936
q6	210	181	148	148
q7	873	735	608	608
q8	9242	1346	1135	1135
q9	5152	4943	4931	4931
q10	6755	2311	1840	1840
q11	479	274	268	268
q12	342	364	219	219
q13	17765	3673	3138	3138
q14	240	247	216	216
q15	577	498	505	498
q16	646	632	590	590
q17	583	843	343	343
q18	7090	6541	6472	6472
q19	3889	967	539	539
q20	309	308	186	186
q21	2744	2158	2010	2010
q22	361	334	320	320
Total cold run time: 105086 ms
Total hot run time: 32837 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6419	6211	6286	6211
q2	238	329	227	227
q3	2215	2610	2293	2293
q4	1406	1837	1360	1360
q5	4349	4733	4925	4733
q6	193	180	141	141
q7	2040	1954	1829	1829
q8	2576	2749	2745	2745
q9	7288	7225	7250	7225
q10	3057	3296	2826	2826
q11	605	501	489	489
q12	659	761	602	602
q13	3469	3908	3142	3142
q14	291	312	277	277
q15	570	524	511	511
q16	644	692	631	631
q17	1210	1739	1244	1244
q18	7696	7350	7169	7169
q19	790	1074	1075	1074
q20	1973	1945	1811	1811
q21	5288	5068	4826	4826
q22	594	587	572	572
Total cold run time: 53570 ms
Total hot run time: 51938 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190341 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 1893624414dae18956c67636e7775aca43e50b2f, data reload: false

query1	978	379	388	379
query2	6523	2286	2315	2286
query3	6705	210	215	210
query4	33908	23810	23560	23560
query5	4370	642	458	458
query6	290	205	202	202
query7	4618	495	308	308
query8	298	256	241	241
query9	9534	2655	2626	2626
query10	472	334	248	248
query11	18060	15369	15211	15211
query12	161	115	113	113
query13	1677	543	419	419
query14	10251	7477	7130	7130
query15	268	190	191	190
query16	8289	591	415	415
query17	1558	741	573	573
query18	2116	391	289	289
query19	208	168	148	148
query20	114	111	109	109
query21	207	122	101	101
query22	4286	4409	4355	4355
query23	33952	33375	33650	33375
query24	6386	2253	2222	2222
query25	500	428	380	380
query26	1197	267	148	148
query27	2036	466	331	331
query28	5277	2411	2377	2377
query29	755	527	409	409
query30	227	182	151	151
query31	975	903	820	820
query32	87	56	59	56
query33	497	345	289	289
query34	748	821	498	498
query35	796	806	742	742
query36	988	1047	972	972
query37	118	98	77	77
query38	4049	4133	4085	4085
query39	1495	1485	1519	1485
query40	210	114	98	98
query41	48	48	47	47
query42	129	106	97	97
query43	512	536	487	487
query44	1272	794	811	794
query45	183	177	171	171
query46	872	1037	649	649
query47	1899	1934	1890	1890
query48	396	406	359	359
query49	768	475	389	389
query50	630	637	393	393
query51	7323	7127	7033	7033
query52	105	101	90	90
query53	218	249	188	188
query54	473	503	400	400
query55	76	75	78	75
query56	267	247	232	232
query57	1239	1174	1138	1138
query58	231	225	225	225
query59	3058	3241	2933	2933
query60	271	254	246	246
query61	110	109	105	105
query62	916	802	728	728
query63	229	181	191	181
query64	4545	993	638	638
query65	3288	3217	3251	3217
query66	1102	413	304	304
query67	15921	15862	15565	15565
query68	8062	710	512	512
query69	484	290	251	251
query70	1222	1152	1131	1131
query71	447	281	250	250
query72	6075	3889	3879	3879
query73	645	746	358	358
query74	10274	9290	8774	8774
query75	4013	3150	2657	2657
query76	3743	1170	768	768
query77	777	360	270	270
query78	10211	11458	9717	9717
query79	2744	771	610	610
query80	694	548	418	418
query81	492	265	229	229
query82	261	147	128	128
query83	157	172	152	152
query84	243	95	69	69
query85	736	389	306	306
query86	405	329	310	310
query87	4511	4529	4311	4311
query88	4116	2178	2157	2157
query89	418	319	301	301
query90	1839	186	192	186
query91	132	135	113	113
query92	63	58	55	55
query93	952	771	536	536
query94	659	396	300	300
query95	334	264	259	259
query96	485	599	281	281
query97	2911	2985	2770	2770
query98	240	205	199	199
query99	1672	1592	1424	1424
Total cold run time: 291282 ms
Total hot run time: 190341 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 31.16 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 1893624414dae18956c67636e7775aca43e50b2f, data reload: false

query1	0.03	0.04	0.03
query2	0.07	0.04	0.03
query3	0.23	0.07	0.07
query4	1.61	0.11	0.10
query5	0.41	0.39	0.42
query6	1.15	0.65	0.68
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.60	0.51	0.50
query10	0.56	0.58	0.55
query11	0.14	0.10	0.10
query12	0.14	0.11	0.10
query13	0.60	0.61	0.60
query14	2.78	2.75	2.87
query15	0.92	0.82	0.81
query16	0.40	0.36	0.38
query17	1.05	1.07	1.00
query18	0.24	0.20	0.21
query19	1.90	1.93	1.83
query20	0.02	0.01	0.02
query21	15.36	0.94	0.56
query22	0.74	0.80	0.76
query23	15.22	1.39	0.57
query24	3.02	0.79	1.22
query25	0.14	0.07	0.22
query26	0.37	0.16	0.13
query27	0.07	0.05	0.06
query28	13.23	1.55	1.05
query29	12.54	4.00	3.26
query30	0.25	0.09	0.06
query31	2.83	0.58	0.38
query32	3.24	0.53	0.46
query33	3.04	3.09	3.09
query34	16.68	5.12	4.50
query35	4.60	4.54	4.52
query36	0.64	0.48	0.51
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.17	0.14	0.13
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 105.37 s
Total hot run time: 31.16 s

@morrySnow morrySnow closed this Jan 3, 2025
@morrySnow morrySnow reopened this Jan 3, 2025
@morrySnow morrySnow merged commit 2254956 into apache:master Jan 3, 2025
27 of 29 checks passed
github-actions bot pushed a commit that referenced this pull request Jan 3, 2025
…#46280)

### What problem does this PR solve?

We specified the `excluded_trigger_tables = 'a'` attribute when creating
the materialized view. If table `a` is updated frequently, many invalid
tasks will be generated, and these tasks do not really refresh the mv,
which is unreasonable, too many invalid tasks will wash away useful task
information


Co-authored-by: garenshi <garenshi@tencent.com>
github-actions bot pushed a commit that referenced this pull request Jan 3, 2025
…#46280)

### What problem does this PR solve?

We specified the `excluded_trigger_tables = 'a'` attribute when creating
the materialized view. If table `a` is updated frequently, many invalid
tasks will be generated, and these tasks do not really refresh the mv,
which is unreasonable, too many invalid tasks will wash away useful task
information


Co-authored-by: garenshi <garenshi@tencent.com>
yiguolei pushed a commit that referenced this pull request Jan 4, 2025
…#46280)

### What problem does this PR solve?

We specified the `excluded_trigger_tables = 'a'` attribute when creating
the materialized view. If table `a` is updated frequently, many invalid
tasks will be generated, and these tasks do not really refresh the mv,
which is unreasonable, too many invalid tasks will wash away useful task
information


Co-authored-by: garenshi <garenshi@tencent.com>
yiguolei pushed a commit that referenced this pull request Jan 5, 2025
…efresh mtmv #46280 (#46392)

Cherry-picked from #46280

Co-authored-by: shee <13843187+qzsee@users.noreply.github.com>
Co-authored-by: garenshi <garenshi@tencent.com>
yiguolei pushed a commit that referenced this pull request Jan 5, 2025
…efresh mtmv #46280 (#46391)

Cherry-picked from #46280

Co-authored-by: shee <13843187+qzsee@users.noreply.github.com>
Co-authored-by: garenshi <garenshi@tencent.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
approved Indicates a PR has been approved by one committer. dev/2.1.8-merged dev/3.0.4-merged reviewed
Projects
None yet
Development

Successfully merging this pull request may close these issues.

8 participants
Morty Proxy This is a proxified and sanitized view of the page, visit original site.