I wish to query a measurement and return results where specified field keys have values.
SELECT * FROM L2
WHERE time<='2018-06-16T12:00:00Z' AND time>='2018-10-14T12:00:00Z'
AND ("P16" =~ /./ OR "P17" =~ /./ OR "P18" =~ /./)
My measurement has about 60 field keys:
> show field keys from L2
name: L2
fieldKey fieldType
-------- ---------
P110 float
P111 float
P16 float
P17 float
P18 float
P31 float
...
P95 float
P98 float
I next verify that my measurement has data:
> SELECT P16, P17, P18 FROM L2 WHERE time>='2018-06-13T12:00:00Z' AND time<='2018-06-13T12:10:00Z'
name: L2
time P16 P17 P18
---- --- --- ---
1528891321000000000 77496.5
1528891322000000000 111810 44267.9
1528891501000000000 77496.8
1528891502000000000 111810 44267.9
1528891681000000000 77497.1
1528891682000000000 111810 44267.9
>
After consulting the documentation as well as various posts on this site, I give it a try:
> SELECT P16, P17, P18 FROM L2 WHERE "P17" =~/./
> SELECT P16, P17, P18 FROM L2 WHERE "P17" =~/.*/
> SELECT P16, P17, P18 FROM L2 WHERE "P17" !=''
> SELECT P16, P17, P18 FROM L2 WHERE "P17" !=""
> SELECT P16, P17, P18 FROM L2 WHERE P17 != null
>
Why are results not returned? Thanks!