Support IS NOT NULL predicates in PruningPredicate

[alamb]

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

[guojidan]

take

[guojidan]

Perhaps @appletreeisyellow is more suitable for handling this issue😄

[alamb]

One thing I should have noted in the description here is that I think implementing IS NOT NULL will require a new API to PruningStatistics (the total_row_count) . Conveniently, @appletreeisyellow is adding this API as part of #9171 I think

So in other words, this ticket is likely blocked until #9171 is done

BTW there is a bunch more backstory on #9230

[alamb]

I believe that @Ted-Jiang implemented this in #9989 + #10051 so closing this issue