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.sant...@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.sha...@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 >> >> >
