Support NOT operator

[ashishkf]

Filing this issue based on slack discussion with @Jackie-Jiang.

Pinot does not support REGEXP_NOT_LIKE - w/o NOT operator it is hard to write queries that filter out rows that match a given REGEXP.

[atris]

We should not target specific operators for NOT -- rather, have a generic NOT operator which can apply the inverse predicate.

@Jackie-Jiang Does that make sense?

[Jackie-Jiang]

@atris Yes. I think the purpose of this issue is to add the generic NOT operator (similar to AND/OR). The lack of REGEXP_NOT_LIKE is the trigger of the issue.

[atris]

Ack. Shall I take a shot at this?

[mcvsubbu]

With support for text index, does it make sense for adding more features to the regexp functionality?

[atris]

I don't think this is specific to regexp indices

[mcvsubbu]

I don't think this is specific to regexp indices

Ah ok

[atris]

JFYI, I will be working on this

[ashishkf]

JFYI, I will be working on this

Any timeline for this?

[atris]

#8148