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

Order of execution of logical view joins #37

Open
elsdvlee opened this issue Jul 19, 2024 · 1 comment
Open

Order of execution of logical view joins #37

elsdvlee opened this issue Jul 19, 2024 · 1 comment

Comments

@elsdvlee
Copy link
Collaborator

If there is more than one join, what is the order of execution? (Remark of @pmaria moved from spec to issues)

@elsdvlee
Copy link
Collaborator Author

elsdvlee commented Jul 19, 2024

The logical view joins are more limited than SQL joins. The join conditions are linked to one join and only involve an equal condition on references from the child logical view and compared to references from the parent logical view. The child logical view always remains the same and is always are the left side of the join. And only left (outer) joins and inner joins are defined. Therefore I think that execution order doesn't matter.
@pmaria @tirrolo Can you contribute to the solution for this issue?

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

No branches or pull requests

1 participant