Unable to run COPY FROM command using Cassandra Python driver

Viewed 24

I am facing an error while copy csv file into cassandra( Datastax Astra) using python3

Code:

ColName={"qty_dot_url": "int","qty_hyphen_url": "int","qty_underline_url": "int","qty_slash_url": "int"}
query = "copy mera_table("
for key in ColName.keys():
    query += "{col}".format(col=key+",") 
query+=")" + " " + "FROM" + " "
query= query  + r'C:\Users\asada\Desktop\python_project\Good_Raw\file1.csv' + " " +"WITH HEADER=FALSE"
for i in query:
    session.execute(i)
print("Insertion Successfull")

Error:

[Syntax error in CQL query] message="line 1:0 no viable alternative at input 'c' ([c])
0 Answers
Related