substrait
substrait copied to clipboard
Add support for NOT IN SUBQUERY
The subquery type InPredicate supports IN but it does not support NOT IN which is used in some anti-join implementations.
Minor nit: I think it's more accurate to say "NOT IN is sometimes implemented by an anti-join". It isn't actually used in an anti-join. NOT IN is a logical query concept that a user typically requests, not an optimization.
Also, I think NOT EXISTS
is missing