I am trying to downsample/rollup data. But I am stuck at the elementary task of grouping the data.
sample data is there
> select host,instance,type,type_instance from "1h"."ceph_value" where type_instance='ThrottleMsgrDispatchThrottlerCluster.val' order by time desc limit 20
name: ceph_value
time host instance type type_instance
---- ---- -------- ---- -------------
2018-12-23T11:35:07.481641609Z c02 osd.10 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:07.476608536Z c02 osd.9 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:07.471543086Z c02 osd.4 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:07.466502956Z c02 osd.1 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.614669505Z c01 osd.19 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.610445551Z c01 osd.17 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.605332069Z c01 osd.22 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.601295275Z c01 osd.8 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.597233546Z c01 osd.7 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.59315197Z c01 osd.6 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.588981428Z c01 osd.3 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:04.584909427Z c01 osd.0 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:03.054239701Z c04 osd.29 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:03.046408639Z c04 osd.25 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:03.038498256Z c04 osd.27 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:03.034461105Z c04 osd.23 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:03.03052819Z c04 osd.30 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:03.026477683Z c04 osd.28 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:00.385181303Z c03 osd.21 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:00.380155713Z c03 osd.16 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
Where is the rest of the data, and why are there empty rows???
> SELECT mean(value) as value, last(host) as host, last(instance) as instance, last(type) as type, last(type_instance) as type_instance FROM "test"."1h"."ceph_value" WHERE type_instance='ThrottleMsgrDispatchThrottlerCluster.val' GROUP BY time(1m),host,instance,type,type_instance
name: ceph_value
tags: host=, instance=, type=, type_instance=
time value host instance type type_instance
---- ----- ---- -------- ---- -------------
2018-12-23T11:30:00Z 0 c02 osd.20 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:31:00Z 0 c02 osd.20 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:32:00Z 0 c02 osd.20 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:33:00Z 0 c02 osd.20 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:34:00Z 0 c02 osd.20 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:35:00Z 0 c02 osd.10 ceph_bytes ThrottleMsgrDispatchThrottlerCluster.val
2018-12-23T11:36:00Z
2018-12-23T11:37:00Z
2018-12-23T11:38:00Z
2018-12-23T11:39:00Z
2018-12-23T11:40:00Z
2018-12-23T11:41:00Z
...
...
...