influxdb

select from InfluxDB where value is null


If my data (conceptually) is:

#  a b c 
  -------
1  1   1
2  1 1 0
3  1 0 1

Then in legacy SQL language, the statement would be:

select * from table where b is null

I cannot find a similar condition within the InfluxDB Query Language documentation.

I am working with data where there is optionally a numeric value in a column, and I want to select records where this column is empty/null. Since these are integers, they appear not to work with the matching regexes at all, so something like where !~ /.*/ is out.


Solution

  • You cannot search for nulls in InfluxDB <0.9. You will not be able to insert nulls in Influx >=0.9