Re: Importing data from SQL Server

2015-09-14 Thread Sebastian Estevez
If you have a csv, try Brian's cassandra-loader. It is a full featured c* java import program built with all the best practices for data loading and writes. https://github.com/brianmhess/cassandra-loader All the best, [image: datastax_logo.png] Sebastián Estévez Sol

Re: Importing data from SQL Server

2015-09-14 Thread Jason Kushmaul
I had to write my own, but not due to lack of support. I found I needed to preprocess the data before I put it into cassandra, you might find that beneficial. I only had 3 massive tables to worry about so it wasn't that much extra work to code it out - your case might be different if you have 50 t

Re: Importing data from SQL Server

2015-09-14 Thread Raluca Marcu
Kevin Burton charter.net> writes: > > I have seen numerous posts on transferring data from MySql to Cassandra but have yet to find a good way to > transfer directly from a Microsoft SQL Server table to a Cassandra CF. Even better would be a method to take > as input the output of an arbitrary

Re: Importing data from SQL Server

2013-03-11 Thread Lohith Samaga M
Sorry, I was referring to the Talend Open Studio for BigData. Lohith. Sent from my Xperia™ smartphone smartphone Original Message Subject: Re: Importing data from SQL Server From: Kevin Burton To: "user@cassandra.apache.org" CC: Where can I get the 'bigdat

Re: Importing data from SQL Server

2013-03-11 Thread Kevin Burton
Where can I get the 'bigdata package"? On Mar 11, 2013, at 10:01 AM, "Lohith Samaga M" wrote: > Please check the bigdata package. > > Lohith. > > Sent from my Xperia™ smartphone smartphone > > ---- Original Message -------- > Subject: Re:

Re: Importing data from SQL Server

2013-03-11 Thread Lohith Samaga M
Please check the bigdata package. Lohith. Sent from my Xperia™ smartphone smartphone Original Message Subject: Re: Importing data from SQL Server From: Kevin Burton To: "user@cassandra.apache.org" CC: They mention Hadoop, HBase, and Hive. I am assuming that Cassa

Re: Importing data from SQL Server

2013-03-11 Thread Kevin Burton
They mention Hadoop, HBase, and Hive. I am assuming that Cassandra comes under the umbrella of 'NoSql databases'. On Mar 11, 2013, at 9:33 AM, "Lohith Samaga M" wrote: > Hi, > You may try Talend data integration suite. > > Lohith > > Original Message > Subject: Importing da

Re: Importing data from SQL Server

2013-03-11 Thread Kevin Burton
Not familiar with 'dapper' or Cassandra-sharp is there a step by step guide to this process including the install? Thanks for the tip. On Mar 11, 2013, at 9:41 AM, Pierre Chalamet wrote: > You can quickly create a query using dapper and then transfer all your rows > using cassandra-sharp actu

RE: Importing data from SQL Server

2013-03-11 Thread Pierre Chalamet
You can quickly create a query using dapper and then transfer all your rows using cassandra-sharp actually. The only thing you have to do is to create a class to materialize a row and obviously the SQL and CQL statements. I also have a pending change for cassandra-sharp-contrib that I'm plannin

RE: Importing data from SQL Server

2013-03-11 Thread Lohith Samaga M
Hi, You may try Talend data integration suite. Lohith Original Message Subject: Importing data from SQL Server From: Kevin Burton To: "user@cassandra.apache.org" CC: I have seen numerous posts on transferring data from MySql to Cassandra but have yet to find a good way to t