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 wrote: > http://wiki.apach

Re: org.apache.cassandra.db.Column cannot be cast to org.apache.cassandra.db.SuperColumn

2010-10-04 Thread Jonathan Ellis
Sure looks like you changed a standard CF definition to super by mistake. On Sun, Oct 3, 2010 at 10:51 PM, Aaron Morton wrote: > I got this error on my 0.7.0beta2 install, upgraded from the 0.70 nightly > 31/08. If you think it's just bad data let me know. > Mu cluster had some tombstone records

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 wrote: > 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

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 wrote: > Hello all, > > I am here with a very basic question. > I am very new to Cassandra slowly migrating fro

Re: Secondary Indexes aren't updated when removing whole row

2010-10-04 Thread Petr Odut
https://issues.apache.org/jira/browse/CASSANDRA-1571 On Fri, Oct 1, 2010 at 3:41 PM, Jonathan Ellis wrote: > Yes, this is a bug. Can you create a ticket? > > On Fri, Oct 1, 2010 at 4:02 AM, Petr Odut wrote: > > Hi, > > I have CF User with secondary index on "email" column. > > When I remove a

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 Cassan

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 wrote: > Yes, but probably not in 0.7.0. > > On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut wrote: > > Thanks for the info. Will be ever possible to going throught a secondary > > index (since SI is sorted by default

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 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 perfectly fits he

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 Ell

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.

A proposed use case, any comments and experience is appreciated

2010-10-04 Thread Utku Can Topçu
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 indexed in descending order by time. So I'll be analyzing the data for every hour iteratively. Since the current Hadoop integration does not support partial columnfamily anal

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 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 Hadoopy related

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, in

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 wrote: > Expiring columns are 0.7 only. > > An expired column behaves like a deleted column until it is compacted away. > > On Mon, Oct 4,

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 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 indexed in descendi

Re: PHP access to get or get_slice

2010-10-04 Thread Kevin Withnall
Thanks guys, In the end I don't know what solved it, I had changed too much code to know for sure and too many other things at the same time. I did however find tcpdump useful as a debug tool as the error messages don't always seem to make it back up the stack into php. I could read them in plain

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 wrote: > > I've tried to do a rolling upg

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 b

user-uc.1286193337.dnpcgeffklpjlbcbjhie -pawel.maziarz=intersim...@cassandra.apache.org

2010-10-04 Thread Paweł Maziarz

0.7.0 beta1 to beta2 rolling upgrade error

2010-10-04 Thread Ian Rogers
I've tried to do a rolling upgrade of a 3-node ring from beta1 to beta2 but got the error below. The new node seems to come up fine - I can connect to it with cassandra-cli and see the keyspaces - but it doesn't join the ring. My method was: - stop old cassandra - mv old cassandra dir to new p

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 wrote: > Hi Jonathan, > > Thank you for mentioning about the expiring columns issue. I didn't know > that it had existed. > That's really grea

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