Time Series Downsampling/Upsampling

[Abdel K]

I am trying to downsample and upsample time series data in KairosDB. Time series database systems (TSDS) usually have an option to make the downsampling and upsampling with an operator like SAMPLE BY (1h).

Is there a possibility to downsample time series on KairosDB?

Thanks in advance!

[Rosita Hormann Lobos]

Hello Abdel,

If you look at the query documentation of KairosDB here: https://kairosdb.github.io/docs/restapi/QueryMetrics.html (endpoint api/v1/datapoints/query), you will see that there's an option to add an aggregator to the query. The aggregator should allow you to define the method of aggregation (average, summation, among others) and the sampling time period on which the aggregator is applied, which should allow you to downsample or upsample your data. More information about available aggregators here: https://kairosdb.github.io/docs/restapi/Aggregators.html 

Hope that helps :)

[alexm...@gmail.com]

Worth having a look at the Roll-ups functionality as well.

https://kairosdb.github.io/docs/Roll-ups.html