influxdata / influxdata/docs-v2

InfluxQL Sample not working - exclude null tag values

Open
#3,696 0 comments 0 reactions 1 assignee Claimed by @lwandzura View on GitHub
InfluxQL OSS product:v1
Dominant language
JavaScript
Stars
82
Forks
326
Avg merge
1d 1h
Merged PRs (30d)
82

Description

One of the InfluxQL sample queries is not working
Here is the precise URL:
- https://docs.influxdata.com/influxdb/v1.8/query_language/explore-data/#use-a-regular-expression-to-specify-a-tag-with-no-value-in-the-where-clause
The query is:
```SELECT * FROM "h2o_feet" WHERE "location" !~ /./```
It didn't works.. after some googling and trial and error I got it to work with the following syntax:
```SELECT * FROM "h2o_feet" WHERE "location" !~ /^$/```

##### Relevant URLs
- https://docs.influxdata.com/influxdb/v1.8/query_language/explore-data/
- _Provide other relevant URLs (project issues, community threads, etc.)_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.