Down sampling existing data


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 :slight_smile:

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 now() for later. :wink:
  • 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.

Good luck!