Pinot does not support “NOT” operator and there is no regexp_not_like. So is there any way to do the equivalent of “NOT regexp_like(…,…) at all in Pinot?

Not currently. We should add

NOT

operator support to pinot. Could you please file an issue about this?

Ok, will do