Re: Effect of rangequeries with RandomPartitioner

Thanks for the response. Further questions inline.. On Mon, Jul 9, 2012 at 11:50 AM, samal wrote: >> 1. With RandomPartitioner, on a given node, are the keys sorted by >> their hash_values or original/unhashed keys ? > > hash value, 1. Based on the second answer in http://stackoverflow.com/que

Re: bulk load problem

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

Auto backup script

Hi, I have planned to backup of my cassandra 3 node ring database for security. Please let me know that what method i used for backup and if anyone have script, please share with me. -- Thanks & Regards *Adeel**Akbar*

Re: Auto backup script

Hi, I use parallel-ssh within this script : #!/bin/bash parallel-ssh -h hosts.txt -t 3600 "nodetool -h localhost snapshot mykeyspace -t \`date +%Y%m%d\`"; parallel-ssh -h hosts.txt -t 14400 "find /raid0/cassandra/data/mykeyspace/snapshots/\`date +%Y%m%d\` -type f \( -name \*\Data.db -o -name \*\I

Re: Thrift version and OOM errors

Hello, Thanks for the help. There was a problem in the code actually... The connection object was not thread safe. That is why the messages were so big. After fixing that we do not get any errors. The cluster seems stable. Thanks again for all the help. Regards, Vasilis On Thu, Jul 5, 2012

Re: bulk load problem

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

CompositeType support for keynames

Any reason we dont have CompositeType data structure for key_validation_class ( ref: http://www.datastax.com/docs/0.8/configuration/storage_configuration#key-validation-class) ? I would like to create row_names in the form username:mmddhhmm ( e.g. joe:201206092312 ). I can still do that key_va

Setting the Memtable allocator on a per CF basis

Hello Cassandra Devs, We are currently trying to optimize our Cassandra system with different workloads. One of our workload is update heavy (very). Currently we are running with a patch that allows the Live Ratio to go below 1.0 (lower bound set to 0.1 now) which gives us a bit better performanc

Re: bulk load problem

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: cannot build 1.1.2 from source

Thanks for your response. Yes. I do that every time before I build. On Sun, Jul 8, 2012 at 11:51 AM, aaron morton wrote: > Did you try running ant clean first ? > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 8/07/2012, at

Re: bulk load problem

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: Java heap space on Cassandra start up version 1.0.10

That's a good point Tyler. I watched Top during this process and even though the heap dump is small, I can see all of my memory resources consumed while Cassandra tries to start. I have the heap dump and can run the Memory Analyzer Tool in Eclipse on it, but I will confess, I'm not sure what I am l

Re: Composite Slice Query returning non-sliced data

Aaron, Let me start from the beginning. 1- I have a ColumnFamily called Rollup15 with below definition: create column family Rollup15 with comparator = 'CompositeType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8

Re: CompositeType support for keynames

It's certainly possible to have a CompositeType key_validation_class. What made you think that you cannot? On Mon, Jul 9, 2012 at 7:48 AM, prasenjit mukherjee wrote: > Any reason we dont have CompositeType data structure for > key_validation_class ( ref: > > http://www.datastax.com/docs/0.8/conf

Re: Java heap space on Cassandra start up version 1.0.10

You may have a corrupt metadata/statistics sstable component. You can try deleting those and restarting. Cassandra can rebuild that component if it is missing. On Fri, Jul 6, 2012 at 6:00 PM, Jason Hill wrote: > Hello friends, > > I'm getting a: > > ERROR 22:50:29,695 Fatal exception in thread