wish of those help I think your connection is got broken after processing some data. I faced such issue once & solved that by using connection pooling. Can you tell me how you are getting the connection in your java code ?
Is there a way to import csv file from Cassandra DevCenter?
I hope this helps you . One way to import csv file is by using copy command in cqlsh. I am wondering is there an effective way to import csv file from DevCenter ? , Sorry, there currently is no way to import from CSV using DevCenter.
Sqoop import into Cassandra fails on cassandra parameters
With these it helps You're on the right path. The only things you need to add, is a file reader (I saved your data as a .csv file and got it to work), a for-loop to iterate through it, and then an import of the datetime package to convert your dates for the prepared statement. This worked for me:
with open("/home/aaron/Documents/stackoverflow/test_NYC_taxi.csv", "r") as fares:
for fare in fares:
#closing the file
#closing Cassandra connection