I am currently testing importing information from a text file to update an existing database called serverstate. I am trying to follow the Influxdb documentation but to no avail as I new to such system. I am trying to do like this( I am not sure whether the retention part is required or not):
USE serverstate
CREATE RETENTION POLICY oneday ON serverstate DURATION 1d Replication 1
ServerState,state=1 value=1
However when trying to import by using the following command:
influx -import -path=ServerInfluxdb.txt -precision=s
I am getting the following error:
2019/02/07 09:57:46 error: error parsing query: found USE, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2019/02/07 09:57:46 error: error parsing query: found ServerState, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
HI, I am also facing same issue now. I changed my text file as you mentioned in the above suggestions , still i am getting the error. Can you please help me in resolving the issue?