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