Re: Bulk load in cassandra

2014-08-27 Thread Robert Coli
On Wed, Aug 27, 2014 at 5:13 AM, Malay Nilabh wrote: > I installed Cassandra on one node successfully using CLI I am able to > add a table to the keyspace as well as retrieve the data from the table. > My query is if I have text file on my local file system and I want to load > on Cassandra clu

Re: Bulk load in cassandra

2014-08-27 Thread Mark Reddy
Hi, You can use the COPY command to load in data from a local file, however it needs to be a csv formatted file. For more info see http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/copy_r.html Regards, Mark On 27 August 2014 13:13, Malay Nilabh wrote: > Hi > > I installed Cass

Re: Bulk load in cassandra

2014-08-27 Thread baskar.duraikannu
Please try COPY command via CQL shell if it is delimited file. Regards, Baskar Duraikannu -Original Message- From: Malay Nilabh Date: Wed, 27 Aug 2014 17:43:21 To: user@cassandra.apache.org Reply-To: user@cassandra.apache.org Subject: Bulk load in cassandra Hi I installed Cassandra on

Re: Bulk load in cassandra

2014-08-27 Thread Umang Shah
Hi Malay, Yesterday i answered for your question but you didn't replied back whether it worked for you or not. Anyways you mean by importing text file into cassandra. you can do that by following way. COPY keyspace.columnfamily (column1, column2,...) FROM 'temp.csv' (location of file); for dir

Re: bulk load problem

2012-07-09 Thread Pushpalanka Jayawardhana
Hi, Thanks Brian for your code and Thanks Yuki. Directory structure was a problem and could correct it with Yuki's guidance. Still the error was same and it was due to wrong Thrift rpc address. After correcting it, bulk loading was successful. On Mon, Jul 9, 2012 at 8:13 PM, Yuki Morishita wro

Re: bulk load problem

2012-07-09 Thread Yuki Morishita
Due to the change in directory structure from ver 1.1, you have to create the directory like /path/to/sstables// and put your sstables. In your case, I think it would be "/data/ssTable/tpch/tpch/cf0". And you have to specify that directory as a parameter for sstableloader bin/sstableloader -

Re: bulk load problem

2012-07-09 Thread Brian Jeltema
I couldn't get the same-host sstableloader to work either. But it's easier to use the JMX bulk-load hook that's built into Cassandra anyway. The following is what I implemented to do this: import java.io.IOException; import java.util.HashMap; import java.util.Map; import javax.management.JMX; im

Re: bulk load problem

2012-07-09 Thread Pushpalanka Jayawardhana
Hi all, I am facing the same problem when trying to load Cassandra using sstableloader. I am running a Cassandra instance in my own machine and sstableloader is also called from the same machine. Following are the steps I followed. - get a copy of the running Cassandra instance - set anoth

Re: bulk load glitch

2012-07-02 Thread Brandon Williams
On Mon, Jul 2, 2012 at 10:35 AM, Brian Jeltema wrote: > I can't tell whether the bulk load process recovered from the transient dead > node, or whether I need to start over. > > Does anybody know? You need to start over if the failure detector tripped, but it will retry a few times for regular n

Re: bulk load problem

2012-07-02 Thread aaron morton
Do you have the full stack ? It will include a cause. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/06/2012, at 12:07 PM, James Pirz wrote: > Dear all, > > I am trying to use "sstableloader" in cassandra 1.1.1, to bulk load some data

Re: bulk load problem

2012-06-27 Thread James Pirz
Thank you so much ! The problem was the RPC address, it was different than the listen address. I appreciate your help. Best, James On Wed, Jun 27, 2012 at 1:29 AM, Nury Redjepow wrote: > What is your yaml setting for rpc and listen server on destination node? > > Nury > > > Tue, 26 Jun 2012 17:

Re: bulk load problem

2012-06-27 Thread Nury Redjepow
What is your yaml setting for rpc and listen server on destination node? Nury Tue, 26 Jun 2012 17:07:49 -0700 от James Pirz : Dear all, I am trying to use "sstableloader" in cassandra 1.1.1, to bulk load some data into a single node cluster. I am running the following command: bin/sst

RE: bulk load

2011-06-30 Thread Priyanka
I am working on Cassandra for last 4 weeks and am trying to load large amount of data.I am trying to use the Bulk loading technique but am not clear with the process.Could some explain the process for the bulk load? Also Is the new bulk loading utility discussed in the previous posts available?

Re: bulk load

2011-06-22 Thread Jeremy Hanna
This ticket's outcome replaces what BMT was supposed to do: https://issues.apache.org/jira/browse/CASSANDRA-1278 0.8.1 is being voted on now and will hopefully be out in the next day or two. You can try it out with the 0.8-branch if you want - looking near the bottom of the comments on the ticke

RE: bulk load

2011-06-22 Thread Stephen Pope
Awesome, thanks! -Original Message- From: Jeremy Hanna [mailto:jeremy.hanna1...@gmail.com] Sent: Wednesday, June 22, 2011 3:08 PM To: user@cassandra.apache.org Subject: Re: bulk load This ticket's outcome replaces what BMT was supposed to do: https://issues.apache.org/jira/b