-
Notifications
You must be signed in to change notification settings - Fork 3.5k
[opt](nereids) optimize small sql #43546
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
Conversation
Thank you for your contribution to Apache Doris. Please clearly describe your PR:
|
clang-tidy review says "All clean, LGTM! 👍" |
1 similar comment
clang-tidy review says "All clean, LGTM! 👍" |
run buildall |
clang-tidy review says "All clean, LGTM! 👍" |
TeamCity be ut coverage result: |
run buildal |
run buildall |
clang-tidy review says "All clean, LGTM! 👍" |
TeamCity be ut coverage result: |
run buildall |
clang-tidy review says "All clean, LGTM! 👍" |
run buildall |
run buildall |
4 similar comments
run buildall |
run buildall |
run buildall |
run buildall |
run buildall |
1 similar comment
run buildall |
TPC-H: Total hot run time: 37880 ms
|
TPC-DS: Total hot run time: 133675 ms
|
ClickBench: Total hot run time: 32.24 s
|
run buildall |
TPC-H: Total hot run time: 34016 ms
|
TPC-DS: Total hot run time: 184588 ms
|
ClickBench: Total hot run time: 29.16 s
|
run buildall |
TPC-H: Total hot run time: 33950 ms
|
fe/fe-core/src/main/java/org/apache/doris/nereids/stats/StatsCalculator.java
Show resolved
Hide resolved
TPC-DS: Total hot run time: 185404 ms
|
ClickBench: Total hot run time: 29.58 s
|
FE UT Coverage ReportIncrement line coverage |
run buildall |
TPC-H: Total hot run time: 34114 ms
|
TPC-DS: Total hot run time: 184251 ms
|
ClickBench: Total hot run time: 29.82 s
|
FE UT Coverage ReportIncrement line coverage |
run buildall |
FE UT Coverage ReportIncrement line coverage |
TPC-H: Total hot run time: 33989 ms
|
TPC-DS: Total hot run time: 186103 ms
|
ClickBench: Total hot run time: 29.78 s
|
PR approved by at least one committer and no changes requested. |
PR approved by anyone and no changes requested. |
What problem does this PR solve?
Problem Summary:
this pr improve QPS for small sql, by this points:
Subquery unnesting
topicSet<Slot>
this sql can optimize from 21000 QPS to 32000 QPS
this sql can optimize from 16000 QPS to 23000 QPS
Check List (For Author)
Test
Behavior changed:
Does this need documentation?
Check List (For Reviewer who merge this PR)