I’ve a problem aggregation data in the Influxdb.
There is a table with massive measurments within a resolution about 5 seconds. And I want to aggregate the data so i will get a resolution of 1 minute.
This is the query:
“SELECT mean(value) AS avg, min(value) AS min, max(value) AS max, count(value) AS count, sum(value) AS sum
WHERE wert_id = ‘2117’
AND time >= ‘2019-02-23 12:00:00’
AND time <= ‘2019-02-23 13:00:00’
GROUP BY time(1m), wert_id
The strange problem ist that if i send the query with the chronograph it works. But if i send it from the python application there is no data in rp_minute.facts. I can see that the query which is send by python arrives at the influxdb (seen with “show queries”) and the syntax is correct.
I’ve checked the database connection twice.
I use the " InfluxDB-Python" Library. On an Ubuntu LTS 18.04.
And at this point i’ve no clue how to debug this problem.
Thank you in advance