Influxql where regular expression

HI,

I don’t think that will work in the CLI. Perhaps Grafana.

If you queried select * from cq where “query” =~ /1/ that would work, if “query” was a field or tag. I’m guessing you are trying to use /query/ to bring results based on queryFail and queryOk. where the result is greater than 0? I’m not sure that will work so i don’t know what else to suggest. I tried your query and escaping the slashes but it doesn’t like that.

A query like this will work
select * from cq where “hostname” =~ /Influx/

That would bring any results back from cq where the host name matched all or part. As for regexing the tags/fields like that i don’t know if you can. I can’t find anyting in the documentation to suggest otherwise.

Sorry!

1 Like