Influxdb: how to make query where tag value is null?

[airyland]

where somekey !=""
didn't work. So what's the right way?

[beckettsean]

From https://influxdb.com/docs/v0.9/query_language/data_exploration.

"Return data where the tag key location has no tag value:

> SELECT * FROM h2o_feet WHERE location !~ /.*/"

[airyland]

thx. https://influxdb.com/docs/v0.9/query_language/data_exploration.html

[robertsLando]

UPDATE Influx 1.5.

To query values where tag value is null use:

SELECT * FROM "h2o_feet" WHERE "location" !~ /./

Check example here (example 5): https://docs.influxdata.com/influxdb/v1.5/query_language/data_exploration/#examples-14