Support Questions
Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

any NOT RLIKE kind of function for Impala filter in cloudera manager?

New Contributor

this is for searching Impala queries thru cloudera manager UI. 

I use following filter to find all the queries running with user ids starting with zs:

user RLIKE '.*zs.*'


I needed to write another filter which is more like NOT RLIKE  to find those queries for which user does not start with zk.  I tried stuff like below but did not work

user NOT RLIKE '.*zk.*'

user  RLIKE !'.*zk.*'

Search documentation already and did not find any thing like this.