Import Error To Influxdb

Hi team, I am trying to insert a txt file to influxdb with -import command and it is throwing error
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
I have verified the data with the documentation and it seems all correct and i have created the file in Unix using Vi editor. Need help on how to resolve this.

Error:
[ec2-user@ip-172-31-34-148 ~] vi Players.txt [ec2-user@ip-172-31-34-148 ~] influx -import -path=Players.txt -precision=s
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2021/01/27 09:47:50 error: error parsing query: found players1, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1

Source file:
CREATE DATABASE players
players1,name=chittaranjan,comp=techm dept=10,country=“india” 1566009360
players1,name=chirag,comp=techm dept=20,country=“india” 1566002360
players1,name=rajesh,comp=govt dept=30,country=“usa” 1566003360
players1,name=subham,comp=ibm dept=40,country=“can” 1566004360
players1,name=rishabh,comp=tcs dept=50,country=“aus” 1566005360
players1,name=virat,comp=dell dept=40,country=“jpn” 1566007360
players1,name=ajay,comp=wipro dept=70,country=“eng” 1566008360

Solved…Was missing with inital DDl .Thanks

Hello @oom,
I’m happy you solved the problem. :slight_smile: