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