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.

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

[BUG] CBO forces joins back onto CPU in some cases #2717

Closed
andygrove opened this issue Jun 15, 2021 · 0 comments · Fixed by #2744
Closed

[BUG] CBO forces joins back onto CPU in some cases #2717

andygrove opened this issue Jun 15, 2021 · 0 comments · Fixed by #2744
Assignees
@andygrove
Labels
bug Something isn't working performance A performance related task/issue
Milestone
June 21 - July 2

Comments

@andygrove
Copy link
Contributor

Describe the bug
With AQE, CBO, and decimal support enabled, NDS queries q24a, q24b, q59, q93 fall back to CPU for a SortMergeJoin that feeds a BroadcastHashJoin.

Here is an example from q24a.

Without CBO

q24a-178

With CBO

q24a-180

Steps/Code to reproduce bug
Enable CBO and decimal support. Run against SF=3k dataset.

Expected behavior
Joins should not fall back to CPU.

Environment details (please complete the following information)
Standalone.

Additional context
Add any other context about the problem here.
@andygrove andygrove added bug Something isn't working ? - Needs Triage Need team to review and classify performance A performance related task/issue labels Jun 15, 2021
@andygrove andygrove added this to the June 7 - June 18 milestone Jun 15, 2021
@andygrove andygrove self-assigned this Jun 15, 2021
@sameerz sameerz removed the ? - Needs Triage Need team to review and classify label Jun 15, 2021
@andygrove andygrove mentioned this issue Jun 18, 2021
Merged
@jlowe jlowe linked a pull request Jun 22, 2021 that will close this issue
Cost-based optimizer: Implement simple cost model that demonstrates benefits with NDS queries #2744
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andygrove andygrove

Labels
bug Something isn't working performance A performance related task/issue
Projects
None yet
Milestone
June 21 - July 2
2 participants
@andygrove @sameerz