This article explains the basic gap filling and interpolation functionality in Vertica. Vertica was designed for the fast processing and analysis of huge volumes of data and is well suited to IoT applications. One of the challenges in processing IoT data is the fact that the data is almost always incomplete. Sensor data consists of sensor measurements combined with the timestamps of the measure recordings.
Read it here: https://my.vertica.com/blog/using-verti ... nsor-data/