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.
You cannot search for nulls in InfluxDB <0.9. You will not be able to insert nulls in Influx >=0.9