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

Optimize min/max queries based on table statistics #640

Closed
Dandandan opened this issue Jun 29, 2021 · 4 comments · Fixed by #719
Closed

Optimize min/max queries based on table statistics #640

Dandandan opened this issue Jun 29, 2021 · 4 comments · Fixed by #719
Assignees
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@Dandandan
Copy link
Contributor

Dandandan commented Jun 29, 2021

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
In #620 a feature has been added to optimize queries like select count(*) from table.
We can do the same with min / max queries (select min(col) from table).

Describe the solution you'd like
Get the table statistics based on the column name from the table provider, add it to AggregateStatistics optimization rule.

Describe alternatives you've considered

Additional context

@Dandandan Dandandan added the enhancement New feature or request label Jun 29, 2021
@alamb alamb added the good first issue Good for newcomers label Jun 29, 2021
@alamb
Copy link
Contributor

alamb commented Jun 29, 2021

Following the example in #620 probably makes this PR fairly approachable to anyone who is interested

@Dandandan
Copy link
Contributor Author

Dandandan commented Jun 29, 2021

For it to work on parquet and in-memory data, a bit of work also has to be done there to summarize / expose those statistics.

see:
#537

@b41sh
Copy link
Contributor

b41sh commented Jun 30, 2021

I'd like to do this.

@alamb
Copy link
Contributor

alamb commented Jun 30, 2021

Assigning to @b41sh per request. Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request good first issue Good for newcomers
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants