Skip to content

Support predicate pruning for NOT LIKE expressions #14053

@adriangb

Description

@adriangb

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)

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions