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

Pushdown MAX_BY and MIN_BY into complex functions #24286

Open
kaikalur opened this issue Dec 19, 2024 · 0 comments
Open

Pushdown MAX_BY and MIN_BY into complex functions #24286

kaikalur opened this issue Dec 19, 2024 · 0 comments
Labels
intermediate-task optimizer

Comments

@kaikalur
Copy link
Contributor

We see things like:

MAX_BY(TRANSFORM(x ,....), y)

used frequently. Here the value of x is chosen based on y so we can simplify this to:

TRANSFORM(MAX_BY(x,y), ...)
@github-project-automation github-project-automation bot moved this to 🆕 Unprioritized in Presto Optimizer Dec 19, 2024
@kaikalur kaikalur changed the title Pushdowon MAX_BY and MIN_BY into complex functions Pushdown MAX_BY and MIN_BY into complex functions Dec 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
intermediate-task optimizer
Projects
Presto Optimizer
Status: 🆕 Unprioritized
Milestone
No milestone
Development

No branches or pull requests
1 participant
@kaikalur