Hi, I’m interested in setting up a a new influx based workflow and was hoping for some assistance due to becoming rather lost in the information that is already available.
Basically I have a dataset which among other things contains a value for a service uptime, 0 = OK and 1 = NOT OK. this value is taken at regular 5 minute intervals.
What I’d like to do is setup a CQ for said data, where any occurence of 1 is retained in a separate table in its entirety, while all occurences of 0 are downsampled (since they’re not really important)
Based on my research so far it seems as if the combination of RP and CQs are the rightway to go, however I haven’t been able to get my head around an actual implementation.
I’d very much appreciate it if anyone would be able to provide any answers or information to the below questions:
- It is possible to downsample data based on a conditional value? in this case the service status (0 or 1)
- I am aware that CQs will only apply to new data - therefore how would one approach the above problem in context of a dataset containing past time-series data?