Hester Tso
Hester Tso

Reputation: 350

How to query interpolation in Apache IoTDB?

Since I need to check the empty value of the time series stored in Apache IoTDB, I would like to ask is there any function for interpolation query when querying data in IoTDB? If there is this kind of function, what should I do to check all these empty fields out?

Upvotes: 0

Views: 30

Answers (1)

HuskyerLv6
HuskyerLv6

Reputation: 411

In Apache IoTDB, you can directly replace the empty fields with the value you want (previous value, linear interpolation of the previous non-null value and the next non-null value, or a certain constant), instead of query them out and then try to replace them. To achieve this, try FILL '(' PREVIOUS | LINEAR | constant ')' command and choose the kind of filling value method you want.

Upvotes: 0

Related Questions