cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Santini <nick.sant...@kaseya.com>
Subject Re: Fetch a SuperColumn based on value of column
Date Fri, 03 Dec 2010 00:10:10 GMT
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 <nick.santini@kaseya.com>wrote:

> 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)
>
>
> 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:00 PM, Narendra Sharma <narendra.sharma@gmail.com
> > wrote:
>
>> 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 with current Cassandra APIs? If yes, could you please
>> show with a sample.
>> 2. How would such a query perform if the number of SuperColumns is high (>
>> 10K)?
>>
>> Cassandra version 0.7.
>>
>> Thanks,
>> Naren
>>
>>
>

Mime
View raw message