I'm running into an issue I haven't yet been able to understand yet. I'm trying to reduce the granularity of data in a measurement named 'tablespace_utilization'. I would like the data at a daily interval by using the following continuous query.
CREATE CONTINUOUS QUERY tablespace_utilization_downsample ON telegraf RESAMPLE EVERY 1d FOR 36h BEGIN SELECT max(bytes) AS bytes INTO telegraf.autogen.tablespace_utilization_1d FROM telegraf.autogen.tablespace_utilization GROUP BY time(1d), collection_host, "database", tablespace_name, owner END Unfortunately I'm not seeing any evidence of this query running. In an attempt to troubleshoot I reduced the group by and resample intervals down to an hour. I was very surprised to find that the continuous query is running exactly as I intended. CREATE CONTINUOUS QUERY tablespace_utilization_test_hr ON telegraf RESAMPLE EVERY 1h FOR 2h BEGIN SELECT max(bytes) AS bytes INTO telegraf.autogen.tu_test_hr FROM telegraf.autogen.tablespace_utilization GROUP BY time(1h), collection_host, "database", tablespace_name, owner END Data is being inserted into the 'tablespace_utilization' measurement every 5 minutes. I have verified that data does exist within the time interval, and no evidence of the query running is ever found in the influxdb log. Are there any known issues with resampling periods of over 1 day? I'm stumped and would appreciate any insight someone could provide. Thank you, Ryan -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/437233bb-8292-4ced-896c-bb797bc86fb9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
