Skip to content

Navigation Menu

Sign in
Appearance settings

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

branch-3.0: [fix](cache) fix mtmv cache can not use test #46537 #46555

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.

Sign up for GitHub

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

Jump to bottom
Merged
merged 1 commit into from
Jan 8, 2025
Merged

branch-3.0: [fix](cache) fix mtmv cache can not use test #46537 #46555

merged 1 commit into from
Jan 8, 2025

Conversation

github-actions[bot]
Copy link
Contributor

@github-actions github-actions bot commented Jan 7, 2025

Cherry-picked from #46537

@924060929
[fix](cache) fix mtmv cache can not use test (#46537)
b05f34f 
fix mtmv can not use sql cache, introduced by #46443
@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?

@dataroaring dataroaring closed this Jan 7, 2025
@dataroaring dataroaring reopened this Jan 7, 2025
@hello-stephen
Copy link
Contributor

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17586	7500	7285	7285
q2	2080	177	171	171
q3	10624	1105	1184	1105
q4	10570	797	725	725
q5	7772	2891	2896	2891
q6	236	148	146	146
q7	987	634	610	610
q8	9360	2023	2052	2023
q9	6671	6457	6481	6457
q10	7044	2270	2316	2270
q11	464	257	266	257
q12	406	220	210	210
q13	17794	2986	3037	2986
q14	240	209	197	197
q15	557	528	524	524
q16	694	605	615	605
q17	993	604	539	539
q18	7392	6668	6576	6576
q19	1404	1087	970	970
q20	495	211	196	196
q21	4083	3249	3237	3237
q22	1084	1022	1016	1016
Total cold run time: 108536 ms
Total hot run time: 40996 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7323	7211	7223	7211
q2	333	236	236	236
q3	3001	2976	2992	2976
q4	2061	1823	1852	1823
q5	5754	5747	5758	5747
q6	236	146	145	145
q7	2252	1886	1849	1849
q8	3364	3634	3557	3557
q9	8907	8918	8912	8912
q10	3629	3561	3578	3561
q11	619	493	510	493
q12	858	634	616	616
q13	9702	3171	3179	3171
q14	310	277	282	277
q15	571	539	536	536
q16	732	683	679	679
q17	1854	1650	1614	1614
q18	8316	7719	7622	7622
q19	1677	1700	1577	1577
q20	2159	1909	1873	1873
q21	5510	5339	5377	5339
q22	1167	1059	1046	1046
Total cold run time: 70335 ms
Total hot run time: 60860 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 198373 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 b05f34ff1c630238bbdfc3dbd9016fb8b9626f4c, data reload: false

query1	1286	945	926	926
query2	6221	2114	2053	2053
query3	10947	4370	4210	4210
query4	66732	29096	23668	23668
query5	5096	463	447	447
query6	435	181	178	178
query7	5685	325	311	311
query8	317	232	226	226
query9	9220	2682	2700	2682
query10	480	261	256	256
query11	17782	15387	15761	15387
query12	157	104	115	104
query13	1535	440	431	431
query14	10875	7242	7252	7242
query15	205	175	181	175
query16	7235	507	492	492
query17	1104	602	608	602
query18	1786	344	332	332
query19	232	167	162	162
query20	126	114	113	113
query21	215	109	110	109
query22	4959	4499	4572	4499
query23	34517	34367	34286	34286
query24	6097	2908	2954	2908
query25	558	450	438	438
query26	686	173	175	173
query27	2074	355	357	355
query28	4189	2481	2449	2449
query29	711	448	440	440
query30	238	166	163	163
query31	969	815	845	815
query32	67	53	63	53
query33	403	272	288	272
query34	934	505	541	505
query35	839	721	725	721
query36	1100	977	998	977
query37	122	71	74	71
query38	4053	4039	4012	4012
query39	1514	1474	1502	1474
query40	209	102	110	102
query41	49	48	49	48
query42	117	102	103	102
query43	550	499	501	499
query44	1193	867	843	843
query45	180	165	171	165
query46	1155	727	756	727
query47	2057	1944	1984	1944
query48	480	389	390	389
query49	717	392	395	392
query50	846	415	426	415
query51	7553	7182	7202	7182
query52	98	86	85	85
query53	257	183	179	179
query54	547	447	446	446
query55	75	74	76	74
query56	259	233	250	233
query57	1281	1086	1111	1086
query58	213	199	210	199
query59	3301	2913	2938	2913
query60	280	257	246	246
query61	109	108	102	102
query62	785	670	684	670
query63	213	207	204	204
query64	1373	659	639	639
query65	3314	3212	3199	3199
query66	708	290	301	290
query67	15992	15699	15704	15699
query68	3997	584	580	580
query69	441	271	267	267
query70	1187	1121	1136	1121
query71	345	262	263	262
query72	6420	4018	3927	3927
query73	746	351	357	351
query74	10087	9111	8976	8976
query75	3379	2682	2654	2654
query76	1842	999	1059	999
query77	505	272	267	267
query78	10619	9603	9618	9603
query79	1552	606	599	599
query80	879	429	418	418
query81	528	250	240	240
query82	1267	122	115	115
query83	160	142	144	142
query84	281	86	79	79
query85	869	301	288	288
query86	335	303	301	301
query87	4410	4218	4279	4218
query88	3866	2414	2387	2387
query89	410	291	293	291
query90	1980	186	188	186
query91	179	153	150	150
query92	59	49	52	49
query93	1849	547	546	546
query94	765	304	301	301
query95	363	256	248	248
query96	622	293	282	282
query97	3332	3249	3245	3245
query98	210	199	198	198
query99	1563	1313	1294	1294
Total cold run time: 320659 ms
Total hot run time: 198373 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.06	0.04	0.03
query3	0.23	0.07	0.07
query4	1.62	0.10	0.10
query5	0.52	0.49	0.51
query6	1.14	0.72	0.73
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.56	0.50	0.51
query10	0.56	0.54	0.57
query11	0.14	0.09	0.09
query12	0.13	0.11	0.12
query13	0.60	0.59	0.61
query14	3.03	2.90	2.91
query15	0.90	0.82	0.83
query16	0.39	0.37	0.38
query17	1.04	1.01	1.04
query18	0.23	0.23	0.23
query19	2.00	1.93	2.07
query20	0.02	0.01	0.00
query21	15.35	0.59	0.60
query22	2.52	1.92	2.45
query23	17.13	1.05	0.90
query24	2.94	1.25	1.36
query25	0.35	0.08	0.07
query26	0.49	0.13	0.14
query27	0.04	0.07	0.04
query28	10.16	1.11	1.07
query29	12.59	3.27	3.28
query30	0.25	0.06	0.06
query31	2.86	0.39	0.38
query32	3.28	0.46	0.47
query33	3.04	3.03	3.02
query34	17.21	4.55	4.55
query35	4.54	4.52	4.62
query36	0.66	0.52	0.49
query37	0.10	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.16	0.12	0.12
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 107.15 s
Total hot run time: 33.59 s

@924060929 924060929 merged commit f52b44b into branch-3.0 Jan 8, 2025
21 of 22 checks passed
@github-actions github-actions bot deleted the auto-pick-46537-branch-3.0 branch January 8, 2025 02:54
csun5285 pushed a commit to csun5285/doris that referenced this pull request Mar 28, 2025
@morrySnow
[fix](nereids) fix sql cache bug and some tests apache#46443 apache#4…
900a7e6 
…6537 (apache#3821)

pick from apache doris' branch-3.0

- apache#46506
- apache#46555
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
4 participants
@hello-stephen @doris-robot @924060929 @dataroaring
Morty Proxy This is a proxified and sanitized view of the page, visit original site.