Hi! Is there a way to write a where clause to matc...
# generalm
Milan Bracke
06/16/2021, 7:42 AMHi! Is there a way to write a where clause to match entries that do not match a given regular expression? Using
notx
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)
Xiang Fu
06/16/2021, 8:35 AM
We should add NOT support for REGEX_MATCH
Xiang Fu
06/16/2021, 8:35 AM
can you create a github issue
m
Milan Bracke
06/16/2021, 8:36 AMOK, thanks.
Milan Bracke
06/16/2021, 8:37 AMIsn'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