-
Notifications
You must be signed in to change notification settings - Fork 1.1k
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
Support decorrelate_subquery with disjunction #5368
Labels
enhancement
New feature or request
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Support decorrelate_subquery with disjunction.
like TPC-DS 10,35,45 query
Describe the solution you'd like
we can support mark join to support decorrelate_subquery, it's introduced in
HyPer
Describe alternatives you've considered
related paper:
Parameterized Queries and Nesting Equivalencies - C Galindo-Legaria
Unnesting Arbitrary Queries - T Neumann, A Kemper
The Complete Story of Joins (inHyPer) - T Neumann, V Leis, A Kemper
Enhanced Subquery Optimizations in Oracle - S Bellamkonda
Unnesting SQL Queries in the Presence of Disjunction - P. Parízek
Additional context
https://hourim.wordpress.com/2017/08/12/unnesting-of-coalesced-subqueries/
doris
old-planner issue about this. apache/doris#2830sybase https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/CHDIHIIG.htm
The text was updated successfully, but these errors were encountered: