As Paul said, you need to re-build your data in a Cassandra-friendly manner. Reading SQL files does not seem a very efficient way to do that though. Most databases can output in much simpler formats, like CSV. But then, why export at all? If the MySQL instance and the Cassandra instance are both addressable over the same network, you could just write a program that reads data from one, reorganizes it and writes it to the other.
On Thu, Jul 1, 2010 at 1:33 PM, Rana Aich <ranaa...@yahoo.com> wrote: > Hi, > > Can someone please please throw some light how can I import the Data from > mysql into Cassandra cluster. > > - Is there any tool available? > OR > - Do I have to write my own Client using Thrift that will read the export > file (*.sql) and insert the record in the database. > > Thanks > > raich > > >
