Repository navigation
Support IS NOT NULL predicates in PruningPredicate #9231
Description
Is your feature request related to a problem or challenge?
the PruningPredicate currently does not handle IS NOT NULL predicates
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
@appletreeisyellow added an initial implementation in #9208 but I believe it didn't work in all cases, as described in #9230
Activity
guojidan commentedon Feb 18, 2024
take
guojidan commentedon Feb 18, 2024
Perhaps @appletreeisyellow is more suitable for handling this issue😄
alamb commentedon Feb 19, 2024
One thing I should have noted in the description here is that I think implementing
IS NOT NULLwill require a new API toPruningStatistics(thetotal_row_count) . Conveniently, @appletreeisyellow is adding this API as part of #9171 I thinkSo in other words, this ticket is likely blocked until #9171 is done
BTW there is a bunch more backstory on #9230
alamb commentedon Apr 22, 2024
I believe that @Ted-Jiang implemented this in #9989 + #10051 so closing this issue