I am fairly new to InfluxDB and I am trying to down sample data that I already have. I have read up on using a continuous query, but I am curious if it is possible to do something like "SELECT temperature FROM generators GROUP BY time(5s) where I can then see the value for “temperature” every 5 seconds (an interval of 5 seconds). I have looked all over the internet and have found nothing quite helpful. Thanks to all of those who reply in advance.
Hi , you will need a function in your continuous query ,
I am sure you will find in th link here what you are looking for
Best regards ,
click here for Continuous queries
I haven’t done this, but I’ve been trying to sort out this same thing for a while.
This is for a production environment where it’s import there’s no data gaps:
- I think that you setup a CQ so that everything new is being down sampled. Save
- Use The Into Clause to backfill the existing data. I think that you should be able to basically reuse the CQ that you created earlier, just with the WHERE clause specified.