How to import data from an xml file into cassandra directly

Question

I am trying to insert a data from an xml file into Cassandra database directly. It has 1089090 records on it.

I tried to read it pragmatically using java and got this exception after about 77000 records.

java.sql.SqlNontrasientConnectionException: org.apache.thrift.transport.TTTransportException

can u tell me command to export data from mxl file to cassandra? — user3504024, Sep 03 '15 at 10:50

score 2 · Accepted Answer · answered Apr 02 '14 at 11:58

2

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 ?

answered Apr 02 '14 at 11:58

RCS

1,370
11
27

1

i wasn't using connection pooling before and connection pooling did the job for me. – Hasif Subair May 01 '14 at 07:49

How to import data from an xml file into cassandra directly

1 Answers1