Re: Fetch a SuperColumn based on value of column

2010-12-04 Thread Aaron Morton
Ah, sounds like you could change your data model. Perhaps using a Standard CF with and 0.7 secondary indexes would suit you. Or if you code knows the value for both attributes, just use these as a key and get all the data for the row. One simple lookup. It's ok to denormalise your data to supp

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Narendra Sharma
Thanks Aaron! The first request requires you to know the SuperColumn name. In my case I don't know the SuperColumn name cause if I know then I can read the super column. I need to find the SuperColumn that has column with given value for a given column. The usecase is that application allows query

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Aaron Morton
You can use column and super column names with the get_slice() function without 0.7 secondary indexes. I'm assuming that the original query was to test for the existence of a column by name. In the case below, to retrieve the full super column would require to request...First to test the condition.

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Nick Santini
actually, the solution would be something like my last mail, but pointing to the name of the super column and the row key Nicolas Santini Director of Cloud Computing Auckland - New Zealand (64) 09 914 9426 ext 2629 (64) 021 201 3672 On Fri, Dec 3, 2010 at 1:08 PM, Nick Santini wrote: > Hi, >

Re: Fetch a SuperColumn based on value of column

2010-12-02 Thread Nick Santini
Hi, as I got answered on my mail, secondary indexes for super column families is not supported yet, so you have to implement your own easy way: keep another column family where the row key is the value of your field and the columns are the row keys of your super column family (inverted index) N

Fetch a SuperColumn based on value of column

2010-12-02 Thread Narendra Sharma
Hi, My schema has a row that has thousands of Super Columns. The size of each super column is around 500B (20 columns). I need to query 1 SuperColumn based on value of one of its column. Something like SELECT SuperColumn FROM Row WHERE SuperColumn.column="value" Questions: 1. Is this possible wi