Find gap between _time

InfluxDB 2
, ,
1

Hello, I’m new to Influxdb and store data as below

2022-04-08T11:00:00Z    2345.64
2022-04-08T11:01:00Z    2365.3
2022-04-08T11:02:00Z    2124.6
2022-04-08T11:03:00Z    2200.12
2022-04-08T11:04:00Z    2187.65
2022-04-08T11:08:00Z    2130.12
2022-04-08T11:10:00Z    2187.65

All my _time are separate by one minute. I’d like to make a query to find the missing data, a result that could look like

2022-04-08T11:05:00Z
2022-04-08T11:06:00Z 
2022-04-08T11:07:00Z 
2022-04-08T11:09:00Z

Do you know if it’s possible ? I’m using influxdb-client-java

2

@yoobi You could use aggregateWindow() to generate tables for each missing point. This should work if you set the every parameter to the same interval that your data should be coming in. You can then filter those results by rows for which a _value does not exist:

data
    |> aggregateWindow(every: 1m, timeSrc: "_start", createEmpty: true)
    |> filter(fn: (r) => not exists r._value)
3

Thank you for your reply, unfortunately I can’t make it work, aggregateWindow is requiring a fn. I don’t know what to fill in ?

4

Oh, right. Sorry. Just use last.

data
    |> aggregateWindow(every: 1m, fn: last, timeSrc: "_start", createEmpty: true)
    |> filter(fn: (r) => not exists r._value)
1 Like