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

Push down filter through Aggregate #8439

Closed
leiysky opened this issue Oct 25, 2022 · 2 comments · Fixed by #10240
Closed

Push down filter through Aggregate #8439

leiysky opened this issue Oct 25, 2022 · 2 comments · Fixed by #10240
Assignees
Labels
C-feature Category: feature

Comments

@leiysky
Copy link
Contributor

leiysky commented Oct 25, 2022

Some filters can be pushed down through Aggregate operator, for example:

select * from t group by a having a > 1;

Since the HAVING predicate a > 1 is applied on the group item a, it's possible to rewrite the query into select * from t where a > 1 group by a, which is much more efficient.

@leiysky leiysky added the C-feature Category: feature label Oct 25, 2022
@leiysky leiysky moved this to 📒Backlog in Databend Query Planner Oct 25, 2022
@johnhaxx7
Copy link
Contributor

johnhaxx7 commented Feb 21, 2023

Hi @leiysky, is this open for community to take? If so, can you please help evaluate the effort? Something like pingcap/tidb#13106?

@sundy-li
Copy link
Member

Yes, It's ready to have this Transformation.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-feature Category: feature
Projects
Status: 📕Done
Development

Successfully merging a pull request may close this issue.

3 participants