https://pinot.apache.org/ logo
#general
Title
# general
m

Milan Bracke

06/16/2021, 7:42 AM
Hi! Is there a way to write a where clause to match entries that do not match a given regular expression? Using
not
just results in an error message.
x

Xiang Fu

06/16/2021, 8:34 AM
I think not regex_match is not supported, current solution is to negate the regex (I know sometimes it’s hard)
We should add NOT support for REGEX_MATCH
can you create a github issue
m

Milan Bracke

06/16/2021, 8:36 AM
OK, thanks.
Isn't this issue similar: https://github.com/apache/incubator-pinot/issues/5797 ? It's on REGEXP_LIKE, but that's what I'm using.
x

Xiang Fu

06/16/2021, 10:21 AM
true, I think we can use same issue