I have two instances of queries in grafana that don’t work (but they work directly to InfluxDB using chronograf).
SELECT mean(“latency_average”) FROM “cloudwatch_aws_elb” WHERE (“load_balancer_name” =~ /^.-public-./) AND timeFilter GROUP BY time(__interval), “load_balancer_name” fill(linear)
SELECT mean(“latency_average”) FROM “cloudwatch_aws_elb” WHERE (“load_balancer_name” = ‘sxe-appserver-public-elb-sxe80’) AND $timeFilter GROUP BY time(1m) fill(null)
The similarity is that they both contain the word “public”. When that word (public) is in there, the queries error out. If I change it to ‘publi’ or something that doesn’t actually spell out the word ‘public’, it does work.
Both queries work fine when executing them directly against my InfluxDB using Chronograf. So, seems like Grafana is treating ‘public’ as a reserved word or something.
Grafana 6.2.6, InfluxDB 1.7.7