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

Support predicate pruning for NOT LIKE expressions #14053

Open
adriangb opened this issue Jan 9, 2025 · 1 comment
Open

Support predicate pruning for NOT LIKE expressions #14053

adriangb opened this issue Jan 9, 2025 · 1 comment
Assignees

Comments

@adriangb
Copy link
Contributor

adriangb commented Jan 9, 2025

Follow up to #507.

Predicate pruning is a powerful technique to speed up queries by skipping entire files / pieces of work based on summary statistics of the data.

This issue proposes implementing predicate pruning for NOT LIKE expressions.

I'm not sure how much can be done here, I'm guessing not much. The one case I can think of is NOT LIKE 'prefix%' in the case that the min/max stats are prefixa and prefixb respectively or something. In this case we know that every row will match the LIKE expression.

To implement this you'll need to make a PR similar to #12978 and add fuzz tests (see #13253)

@NiwakaDev
Copy link
Contributor

take

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

2 participants