Err: error parsing query: found name, expected identifier, string

When the query filedkey is name, the following error will appear.  select * from mytable where name=”lisi”
ERR: error parsing query: found NAME, expected identifier, string, number, bool at line 1, char 29

Put name in double quotation marks to solve the problem. select * from mytable where “name”=”lisi”

The reason for the problem may be that name is a keyword in influxdb

 

Read More: