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])