I have a continuous query running on influx instance but it is not creating any measurements. How can i start debugging it ?..Logs doesn’t throw any errors either.
CREATE CONTINUOUS QUERY cq_fiveMin ON artifactory BEGIN SELECT sum(bytes) AS byte_sum, sum(“duration”) AS duration_sum, count(bytes) AS total_requests, distinct(clientip) AS distinct_clientip INTO test.two_weeks.fiveMin_rollups FROM test.two_weeks.requests GROUP BY repo, method, site, time(5m) fill(0) END.
My gut feeling is something’s not working with the distinct function
- Also query’s work without enclosing field_keys in double-quotes. so what’s the diff between enclosing field_keys in double-quotes and just field_keys?
- I want to find a distinct count of field_key over a period of time and later group it with time or some other field, how is that possible using continuous queries?