For unequal time reporting intervals in Apache IoTDB, how to interpolate and return the data in equal time interval pattern?

Question

I have data with irregular data spacing for time reported, such as 1s, 5s, 11s and so on. I want to return data results at equal intervals of two seconds, and the data that is not reported for this interval needs to be interpolated. Does anyone know which function in IoTDB to use or how to implement it?

Answer 1

You can use group by 2s to get the time interval you want (this will disregard the irregular raw data interval in Apache IoTDB you mentioned). Then, you can use fill(linear) or resample data profiling function in IoTDB to fill the empty data as you want (as a linear line supported by fill, or as the previous/later value supported by resample).