Re: wild card on query

2012-08-17 Thread Swathi Vikas
Thank you very much Aaron. Information you provided is very helpful.   Have a great Weekend!!! swat.vikas   From: aaron morton To: user@cassandra.apache.org Sent: Thursday, August 16, 2012 6:29 PM Subject: Re: wild card on query > I want to retrieve all

Re: wild card on query

2012-08-16 Thread aaron morton
> I want to retrieve all the photos from all the users of certain project. My > sql like query will be "select projectid * photos from Users". How can i run > this kind of row key predicate while executing query on cassandra? You cannot / should not do that using the data model you have. (i.e. yo

wild card on query

2012-08-16 Thread Swathi Vikas
Hi, I am trying to run query on cassandra cluster with predicate on row key. I have column family called "Users" and rows with row key like "projectid_userid_photos". Each user within a project can have rows like projectid_userid_blog, projectid_userid_status and so on.  I want to retrieve all