Skip to content

[only test] #28622

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
Closed
Mryange wants to merge 2 commits into from
Closed

[only test] #28622

Mryange wants to merge 2 commits into from

Conversation

@Mryange
Copy link
Contributor

@Mryange Mryange commented Dec 19, 2023

Proposed changes

Issue Number: close #xxx

Further comments

If this is a relatively large or complex change, kick off the discussion at dev@doris.apache.org by explaining why you chose the solution you did and what alternatives you considered, etc...

@Mryange Mryange marked this pull request as draft December 19, 2023 06:14
@Mryange
Copy link
Contributor Author

Mryange commented Dec 19, 2023

run buildall

@github-actions
Copy link
Contributor

github-actions bot commented Dec 19, 2023

clang-tidy review says "All clean, LGTM! 👍"

@doris-robot
Copy link

doris-robot commented Dec 19, 2023

TeamCity be ut coverage result:
Function Coverage: 36.49% (8534/23389)
Line Coverage: 28.62% (69353/242345)
Region Coverage: 27.64% (35899/129861)
Branch Coverage: 24.36% (18331/75252)
Coverage Report: http://coverage.selectdb-in.cc/coverage/46cde955406cc610b63bbd175346e758c9ab56ad_46cde955406cc610b63bbd175346e758c9ab56ad/report/index.html

@doris-robot
Copy link

doris-robot commented Dec 19, 2023

(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.95 seconds
stream load tsv: 568 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 29.2 seconds inserted 10000000 Rows, about 342K ops/s
storage size: 17184123422 Bytes

@Mryange Mryange mentioned this pull request Dec 19, 2023
Merged
@doris-robot
Copy link

doris-robot commented Dec 19, 2023

TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Tpch sf100 test result on commit 46cde955406cc610b63bbd175346e758c9ab56ad, data reload: false

run tpch-sf100 query with default conf and session variables
q1	4726	4416	4407	4407
q2	359	167	160	160
q3	1477	1226	1207	1207
q4	1125	937	882	882
q5	3208	3168	3167	3167
q6	243	128	127	127
q7	973	481	477	477
q8	2209	2206	2192	2192
q9	6700	6693	6676	6676
q10	3210	3282	3309	3282
q11	304	186	184	184
q12	347	210	208	208
q13	4579	3854	3819	3819
q14	242	212	211	211
q15	565	533	528	528
q16	442	380	384	380
q17	1010	583	544	544
q18	7219	6899	6932	6899
q19	1506	1368	1445	1368
q20	499	284	279	279
q21	3036	2624	2659	2624
q22	347	276	279	276
Total cold run time: 44326 ms
Total hot run time: 39897 ms

run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1	4351	4322	4317	4317
q2	270	162	174	162
q3	3554	3531	3530	3530
q4	2402	2393	2384	2384
q5	5764	5778	5783	5778
q6	239	120	121	120
q7	2393	1851	1889	1851
q8	3518	3548	3522	3522
q9	9049	9044	9044	9044
q10	3967	3986	4024	3986
q11	493	377	374	374
q12	770	593	607	593
q13	4300	3614	3545	3545
q14	285	263	261	261
q15	576	520	524	520
q16	515	439	460	439
q17	1882	1857	1845	1845
q18	8660	8244	8333	8244
q19	1740	1771	1759	1759
q20	2264	1945	1929	1929
q21	6562	6192	6207	6192
q22	497	420	420	420
Total cold run time: 64051 ms
Total hot run time: 60815 ms

@Mryange Mryange closed this Dec 25, 2023
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.

2 participants

@Mryange @doris-robot