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
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 transfer directly from a Mi

Re: Importing data from SQL Server

2013-03-11 Thread Kevin Burton
gh, you will be able > to get it in a few days. This requires cql 3 btw. > > - Pierre > From: Kevin Burton > Sent: ‎11/‎03/‎2013 15:25 > To: user@cassandra.apache.org > Subject: Importing data from SQL Server > > I have seen numerous posts on transferring data from MySql

RE: Importing data from SQL Server

2013-03-11 Thread Pierre Chalamet
x27;m planning to submit for performing such task. If you are patient enough, you will be able to get it in a few days. This requires cql 3 btw. - Pierre -Original Message- From: "Kevin Burton" Sent: ‎11/‎03/‎2013 15:25 To: "user@cassandra.apache.org" Subject: Importin

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 g

Importing data from SQL Server

2013-03-11 Thread Kevin Burton
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 SQL query. Ideas?