substrait icon indicating copy to clipboard operation
substrait copied to clipboard

Add support for NOT IN SUBQUERY

Open EpsilonPrime opened this issue 1 year ago • 2 comments

The subquery type InPredicate supports IN but it does not support NOT IN which is used in some anti-join implementations.

EpsilonPrime avatar Feb 06 '24 23:02 EpsilonPrime

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.

westonpace avatar Feb 07 '24 16:02 westonpace

Also, I think NOT EXISTS is missing

westonpace avatar Feb 07 '24 16:02 westonpace