Generating null values when query returns none

Fluxlang
1

Hey,

When I query data from InfluxDB using aggregateWindow, InfluxDB will create the missing values if there is at least one value found from the query period. But if there is no values found, query will return empty.
So is it possible to fill the values even if there is no values found? That would allow me to always return an array of values with timestamps, even though the values will be null.

E.g Query for 24 hour range windowed with 1 hour should return 24 null values, if there is no values on database for that range.

2

Hi @sweng,
Sadly this is not how the storage engine works. Like when you run a query against a standard relational DB you are returning the data that exists within the parameters that you have defined.