Querying with special character in Field key

influxdb

#1

I have a measurement with alot of Field keys, No Tag keys.
One of the field keys is LD.IDEB of type float.
How can I query this?
I allready tried this with no succes.

select ““LD.IDEB”” from blankaart limit 10
ERR: error parsing query: found LD, expected FROM at line 1, char 10
select ‘LD.IDEB’ from blankaart limit 10
ERR: error parsing query: found ., expected identifier, string, number, bool at line 1, char 12
select “‘LD.IDEB’” from blankaart limit 10
ERR: error parsing query: found ., expected identifier, string, number, bool at line 1, char 13

Regards


#2

It is possible that periods are not allowed in field key names. They are not mentioned among the special characters allowed in field key names here: https://docs.influxdata.com/influxdb/v1.7/write_protocols/line_protocol_reference#special-characters

You can try using a \ to escape the special character and see if that works.


#3

I checked with a member of our team and I was mistaken, periods are allowed in the field key names. So perhaps escaping the character will work. Hope this helps!

-Sonia