Re: A proposed use case, any comments and experience is appreciated

2010-10-04 Thread Jonathan Ellis
Expiring columns are 0.7 only. An expired column behaves like a deleted column until it is compacted away. On Mon, Oct 4, 2010 at 8:48 AM, Utku Can Topçu u...@topcu.gen.tr wrote: Hi Jonathan, Thank you for mentioning about the expiring columns issue. I didn't know that it had existed.

Re: A proposed use case, any comments and experience is appreciated

2010-10-04 Thread Jonathan Ellis
A simpler approach might be to insert expiring columns into a 2nd CF with a TTL of one hour. On Mon, Oct 4, 2010 at 5:12 AM, Utku Can Topçu u...@topcu.gen.tr wrote: Hey All, I'm planning to run Map/Reduce on one of the ColumnFamilies. The keys are formed in such a fashion that, they are

Re: A proposed use case, any comments and experience is appreciated

2010-10-04 Thread Utku Can Topçu
What I can understand from behaving like a deleted column is - They'll be there for at most GCGraceSeconds? On Mon, Oct 4, 2010 at 3:51 PM, Jonathan Ellis jbel...@gmail.com wrote: Expiring columns are 0.7 only. An expired column behaves like a deleted column until it is compacted away. On

Re: Dazed and confused with Cassandra on EC2 ...

2010-10-04 Thread Jedd Rashbrooke
Hi Peter, Thanks again for your time and thoughts on this problem. We think we've got a bit ahead of the problem by just scaling back (quite savagely) on the rate that we try to hit the cluster. Previously, with a surplus of optimism, we were throwing very big Hadoop jobs at Cassandra,

Re: Hardware change of a node in the cluster

2010-10-04 Thread Jedd Rashbrooke
On 4 October 2010 10:58, Utku Can Topçu u...@topcu.gen.tr wrote: Recently I've tried to upgrade (hw upgrade) one of the nodes in my cassandra cluster from ec2-small to ec2-large. Something that bit me on this (I've done it with both Cassandra and Hadoop boxes, and some problems might be more

Re: A proposed use case, any comments and experience is appreciated

2010-10-04 Thread Utku Can Topçu
Hi Jonathan, Thank you for mentioning about the expiring columns issue. I didn't know that it had existed. That's really great news. First of all, does the current 0.6 branch support it? If not so, is the patch available for the 0.6.5 somehow? And about the deletion issue, if all the columns in a

Hardware change of a node in the cluster

2010-10-04 Thread Utku Can Topçu
Hey All, Recently I've tried to upgrade (hw upgrade) one of the nodes in my cassandra cluster from ec2-small to ec2-large. However, there were problems and since the IP of the new instance was different from the previous instance. The other nodes didnot recognize it in the ring. So what should

Re: Hardware change of a node in the cluster

2010-10-04 Thread Gary Dusbabek
It should work this way: 1. Move your data to the new node (scp, etc.) 2. Make sure the new node is configured to use the same token as the new node. 3. Stand up the new node. 4. Turn off the old node. If your environment is volatile, it's probably best to run `nodetool repair` on the new node.

Re: 0.7.0 beta1 to beta2 rolling upgrade error

2010-10-04 Thread Jonathan Ellis
from the Upgrading section of NEWS.txt: The Cassandra inter-node protocol is incompatible with 0.6.x releases (and with 0.7 beta1), meaning you will have to bring your cluster down prior to upgrading On Mon, Oct 4, 2010 at 8:53 AM, Ian Rogers ian.rog...@contactclean.com wrote: I've

Re: 0.7.0 beta1 to beta2 rolling upgrade error

2010-10-04 Thread Ian Rogers
Thanks, I just pushed ahead with the rolling upgrade with bootstrap off. This just meant the beta1 cluster got smaller and dissappeared while the beta2 cluster got bigger and took over. This is only a dev system so no writes will/should have been lost. Ian On 04/10/2010 14:55, Jonathan

Re: Sorting by secondary index

2010-10-04 Thread Jonathan Ellis
Yes, but probably not in 0.7.0. On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut petr.o...@gmail.com wrote: Thanks for the info. Will be ever possible to going throught a secondary index (since SI is sorted by default)? My use case is to display newest comments, users, etc. SI from my point of view

Re: Sorting by secondary index

2010-10-04 Thread Petr Odut
partly good news, thanks Petr Odut On Mon, Oct 4, 2010 at 5:40 PM, Jonathan Ellis jbel...@gmail.com wrote: Yes, but probably not in 0.7.0. On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut petr.o...@gmail.com wrote: Thanks for the info. Will be ever possible to going throught a secondary index

first step with Cassandra

2010-10-04 Thread Himanshu Jani
Hello all, I am here with a very basic question. I am very new to Cassandra slowly migrating from RDBMS world. Is there any worked example that I can use it to learn Cassandra? I have lots of documentation around Cassandra but any simple worked example will be of great help in understanding

Re: first step with Cassandra

2010-10-04 Thread Jonathan Ellis
Did you see twissandra linked from http://wiki.apache.org/cassandra/ArticlesAndPresentations ? (Twissandra is targetted at 0.7 now, btw.) On Mon, Oct 4, 2010 at 10:56 AM, Himanshu Jani himanshu.j...@gmail.com wrote: Hello all, I am here with a very basic question. I am very new to Cassandra

Re: first step with Cassandra

2010-10-04 Thread Petr Odut
http://wiki.apache.org/cassandra/UseCases On Mon, Oct 4, 2010 at 5:56 PM, Himanshu Jani himanshu.j...@gmail.comwrote: Hello all, I am here with a very basic question. I am very new to Cassandra slowly migrating from RDBMS world. Is there any worked example that I can use it to learn

Re: first step with Cassandra

2010-10-04 Thread Juho Mäkinen
I posted a real life example how we used cassandra to store data for a facebook chat like application. Check it out at http://www.juhonkoti.net/2010/09/25/example-how-to-model-your-data-into-nosql-with-cassandra - Juho Mäkinen On Mon, Oct 4, 2010 at 7:04 PM, Petr Odut petr.o...@gmail.com wrote: