Skip to content
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

[test](regression)Add index compaction exception case #46118

Open
wants to merge 1 commit into
base: master
Choose a base branch
from

Conversation

qidaye
Copy link
Contributor

@qidaye qidaye commented Dec 27, 2024

What problem does this PR solve?

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

@Thearas
Copy link
Contributor

Thearas commented Dec 27, 2024

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?

@qidaye
Copy link
Contributor Author

qidaye commented Dec 27, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17602	6201	6067	6067
q2	2059	299	169	169
q3	10498	1268	720	720
q4	10220	853	438	438
q5	7529	2188	1983	1983
q6	204	187	150	150
q7	889	747	614	614
q8	9233	1318	1167	1167
q9	5190	4943	4860	4860
q10	6762	2304	1858	1858
q11	463	280	262	262
q12	351	359	220	220
q13	17791	3610	3019	3019
q14	227	235	212	212
q15	571	495	503	495
q16	641	626	601	601
q17	590	844	338	338
q18	7105	6526	6380	6380
q19	1407	958	557	557
q20	317	323	191	191
q21	2847	2173	1992	1992
q22	357	326	310	310
Total cold run time: 102853 ms
Total hot run time: 32603 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6299	6280	6226	6226
q2	238	324	229	229
q3	2278	2623	2322	2322
q4	1424	1830	1405	1405
q5	4358	4833	4725	4725
q6	191	181	145	145
q7	2110	1992	1787	1787
q8	2556	2805	2673	2673
q9	7294	7241	7139	7139
q10	3046	3318	2849	2849
q11	583	505	501	501
q12	651	732	586	586
q13	3348	3800	3043	3043
q14	296	308	286	286
q15	586	509	522	509
q16	654	689	643	643
q17	1201	1708	1239	1239
q18	7745	7312	7224	7224
q19	791	1151	1035	1035
q20	1903	1980	1805	1805
q21	5475	5014	5009	5009
q22	610	622	585	585
Total cold run time: 53637 ms
Total hot run time: 51965 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190467 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 7454a75757486167225378b1e68b64c524101f34, data reload: false

query1	971	405	386	386
query2	6520	2317	2276	2276
query3	6717	217	222	217
query4	33783	23721	23827	23721
query5	4357	627	465	465
query6	288	215	195	195
query7	4631	498	312	312
query8	311	250	246	246
query9	9534	2779	2755	2755
query10	472	312	241	241
query11	18044	15203	15334	15203
query12	154	108	103	103
query13	1656	543	427	427
query14	10725	7342	7323	7323
query15	265	185	186	185
query16	8183	581	464	464
query17	1556	735	542	542
query18	2124	389	296	296
query19	193	177	145	145
query20	117	109	111	109
query21	213	120	104	104
query22	4248	4496	4147	4147
query23	34557	33450	33140	33140
query24	6459	2318	2303	2303
query25	524	465	405	405
query26	1204	288	162	162
query27	1989	478	356	356
query28	5308	2483	2460	2460
query29	755	537	422	422
query30	230	181	152	152
query31	991	865	822	822
query32	94	61	58	58
query33	532	343	298	298
query34	750	837	509	509
query35	775	808	714	714
query36	988	1046	954	954
query37	117	97	69	69
query38	4162	4170	4102	4102
query39	1503	1477	1413	1413
query40	210	113	98	98
query41	48	43	43	43
query42	122	103	104	103
query43	531	528	498	498
query44	1348	817	821	817
query45	181	168	169	168
query46	862	1034	649	649
query47	1887	1917	1845	1845
query48	386	425	323	323
query49	768	464	404	404
query50	642	647	395	395
query51	7194	7106	7161	7106
query52	102	110	92	92
query53	226	256	193	193
query54	480	496	404	404
query55	87	81	79	79
query56	261	275	241	241
query57	1198	1158	1108	1108
query58	237	224	242	224
query59	2975	3060	2915	2915
query60	301	294	250	250
query61	114	110	139	110
query62	892	803	746	746
query63	232	196	200	196
query64	4623	986	679	679
query65	3292	3186	3226	3186
query66	1053	428	303	303
query67	15977	15839	15520	15520
query68	8284	769	532	532
query69	461	291	255	255
query70	1208	1164	1081	1081
query71	445	281	262	262
query72	5950	3805	3858	3805
query73	668	749	360	360
query74	9772	9012	9090	9012
query75	3883	3131	2675	2675
query76	3690	1180	786	786
query77	777	362	285	285
query78	10073	10240	9303	9303
query79	3162	905	596	596
query80	618	518	429	429
query81	492	280	236	236
query82	646	163	121	121
query83	170	172	145	145
query84	237	97	81	81
query85	836	443	376	376
query86	356	320	309	309
query87	4403	4408	4401	4401
query88	4966	2216	2199	2199
query89	399	339	303	303
query90	1930	188	188	188
query91	134	132	110	110
query92	71	121	53	53
query93	1617	894	540	540
query94	659	400	290	290
query95	333	261	266	261
query96	488	604	283	283
query97	2729	2804	2664	2664
query98	227	199	203	199
query99	1717	1577	1431	1431
Total cold run time: 293630 ms
Total hot run time: 190467 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 32.14 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7454a75757486167225378b1e68b64c524101f34, 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.61	0.11	0.11
query5	0.44	0.40	0.39
query6	1.14	0.64	0.64
query7	0.02	0.02	0.01
query8	0.05	0.04	0.03
query9	0.57	0.52	0.49
query10	0.54	0.58	0.57
query11	0.16	0.11	0.11
query12	0.15	0.11	0.11
query13	0.61	0.61	0.60
query14	2.73	2.74	2.72
query15	0.89	0.84	0.81
query16	0.38	0.41	0.37
query17	0.99	1.05	1.04
query18	0.22	0.21	0.22
query19	1.93	1.82	1.99
query20	0.02	0.02	0.01
query21	15.37	0.91	0.58
query22	0.75	0.79	0.57
query23	15.37	1.42	0.53
query24	2.94	1.80	1.81
query25	0.22	0.19	0.06
query26	0.22	0.15	0.14
query27	0.07	0.06	0.06
query28	14.50	1.47	1.04
query29	12.57	3.99	3.30
query30	0.24	0.09	0.06
query31	2.84	0.60	0.36
query32	3.23	0.56	0.47
query33	3.11	3.21	3.17
query34	16.91	5.19	4.55
query35	4.54	4.50	4.59
query36	0.66	0.49	0.47
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.03	0.02
query40	0.16	0.15	0.13
query41	0.07	0.02	0.03
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.77 s
Total hot run time: 32.14 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 38.89% (10119/26022)
Line Coverage: 29.88% (85495/286124)
Region Coverage: 29.02% (43694/150572)
Branch Coverage: 25.56% (22292/87220)
Coverage Report: http://coverage.selectdb-in.cc/coverage/7454a75757486167225378b1e68b64c524101f34_7454a75757486167225378b1e68b64c524101f34/report/index.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants