I used below command to query data
influx -database “mydb” -precision="rfc3339" -execute "select sum(count) as count, sum(request_sum) / sum(count) as request_avg,sum(total_sum) / sum(count) as total_avg from "atomic_rp"."atomic_detail_for_url" where time > now() - 10s group by domain,url,code slimit 10000" > /tmp/result.txt
As every point’s fields has values, so I expected the sum(count), sum(request_sum) / sum(count), sum(total_sum) / sum(count) also has values. However, the result looks weird. For example
tags: code=200, domain=apihydra.com, url=http://apihydra.com/baseJson/getUserPrivilege
time count request_avg total_avg
---- ----- ----------- ---------
you can see the count and request_avg are empty, sometimes all of the fields are empty.
I can make sure that every point has values for the fields.
So, what could cause the weird result?
My influxdb version is 1.2, and just one instance.
It runs on a Linux server, the server has 32 cores and 64G memory.