Skip to content

[only test] #28870

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 3 commits into from
Closed

[only test] #28870

Mryange wants to merge 3 commits into from
+6 −2

Conversation

@Mryange
Copy link
Contributor

@Mryange Mryange commented Dec 22, 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 mentioned this pull request Dec 22, 2023
Merged
@Mryange Mryange marked this pull request as draft December 22, 2023 08:08
@Mryange
Copy link
Contributor Author

Mryange commented Dec 22, 2023

run buildall

@github-actions
Copy link
Contributor

github-actions bot commented Dec 22, 2023

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

@doris-robot
Copy link

doris-robot commented Dec 22, 2023

TeamCity be ut coverage result:
Function Coverage: 36.48% (8538/23403)
Line Coverage: 28.59% (69421/242816)
Region Coverage: 27.61% (35919/130112)
Branch Coverage: 24.34% (18357/75408)
Coverage Report: http://coverage.selectdb-in.cc/coverage/cc90734f922f0b5576bc8d45a6ce5cde9ee46610_cc90734f922f0b5576bc8d45a6ce5cde9ee46610/report/index.html

@Mryange
Copy link
Contributor Author

Mryange commented Dec 22, 2023

run buildall

@github-actions
Copy link
Contributor

github-actions bot commented Dec 22, 2023

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

@doris-robot
Copy link

doris-robot commented Dec 22, 2023

TeamCity be ut coverage result:
Function Coverage: 36.48% (8538/23403)
Line Coverage: 28.59% (69421/242816)
Region Coverage: 27.60% (35911/130112)
Branch Coverage: 24.34% (18357/75408)
Coverage Report: http://coverage.selectdb-in.cc/coverage/c7bebd930ee5cdcab8ccfa61e2b389d1be9c3dab_c7bebd930ee5cdcab8ccfa61e2b389d1be9c3dab/report/index.html

@Mryange
Copy link
Contributor Author

Mryange commented Dec 22, 2023

run buildall

@github-actions
Copy link
Contributor

github-actions bot commented Dec 22, 2023

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

@doris-robot
Copy link

doris-robot commented Dec 22, 2023

TeamCity be ut coverage result:
Function Coverage: 36.53% (8539/23373)
Line Coverage: 28.63% (69446/242585)
Region Coverage: 27.64% (35933/129981)
Branch Coverage: 24.37% (18368/75362)
Coverage Report: http://coverage.selectdb-in.cc/coverage/790f20544b07c6225e357c2e8c6f96c42888264e_790f20544b07c6225e357c2e8c6f96c42888264e/report/index.html

@Mryange Mryange force-pushed the pipelineX-global-runtime-filter-test branch from 790f205 to 58edfdd Compare December 22, 2023 14:26
@Mryange
Copy link
Contributor Author

Mryange commented Dec 22, 2023

run buildall

@github-actions
Copy link
Contributor

github-actions bot commented Dec 22, 2023

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

@doris-robot
Copy link

doris-robot commented Dec 22, 2023

TeamCity be ut coverage result:
Function Coverage: 36.53% (8538/23373)
Line Coverage: 28.62% (69435/242593)
Region Coverage: 27.64% (35927/129985)
Branch Coverage: 24.37% (18364/75366)
Coverage Report: http://coverage.selectdb-in.cc/coverage/58edfdd59236aa824e12c290f4c6b37857c93868_58edfdd59236aa824e12c290f4c6b37857c93868/report/index.html

@doris-robot
Copy link

doris-robot commented Dec 22, 2023

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

Tpch sf100 test result on commit 58edfdd59236aa824e12c290f4c6b37857c93868, data reload: false

run tpch-sf100 query with default conf and session variables
q1	4685	4392	4408	4392
q2	362	155	156	155
q3	1456	1231	1208	1208
q4	1111	925	940	925
q5	3164	3146	3158	3146
q6	248	133	133	133
q7	1004	488	488	488
q8	2175	2247	2169	2169
q9	6668	6659	6693	6659
q10	3233	3280	3287	3280
q11	306	180	177	177
q12	353	213	203	203
q13	4546	3794	3818	3794
q14	247	215	211	211
q15	572	521	519	519
q16	446	388	377	377
q17	1010	633	486	486
q18	6981	6896	6902	6896
q19	1506	1418	1466	1418
q20	532	324	307	307
q21	3054	2684	2644	2644
q22	348	282	293	282
Total cold run time: 44007 ms
Total hot run time: 39869 ms

run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1	4324	4334	4321	4321
q2	269	164	167	164
q3	3508	3485	3477	3477
q4	2391	2369	2365	2365
q5	5704	5699	5687	5687
q6	243	125	122	122
q7	2350	1876	1849	1849
q8	3515	3512	3511	3511
q9	8987	8960	8961	8960
q10	3940	4001	4009	4001
q11	483	363	357	357
q12	773	657	603	603
q13	4305	3576	3562	3562
q14	293	250	256	250
q15	572	527	515	515
q16	510	442	460	442
q17	1852	1838	1856	1838
q18	8452	8048	8081	8048
q19	1724	1736	1718	1718
q20	2249	1938	1944	1938
q21	6468	6161	6139	6139
q22	494	434	428	428
Total cold run time: 63406 ms
Total hot run time: 60295 ms

@doris-robot
Copy link

doris-robot commented Dec 22, 2023

(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.31 seconds
stream load tsv: 571 seconds loaded 74807831229 Bytes, about 124 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 29.1 seconds inserted 10000000 Rows, about 343K ops/s
storage size: 17189699008 Bytes

@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