Just an arrow in the dark: Doucment "CQL for Cassandra 2.x Documentation" informs that cassandra allows to query on a column when it is indexed.
Regards, Seenu. On Mon, Jan 5, 2015 at 5:14 PM, Nagesh <nageswara.r...@gmail.com> wrote: > Hi All, > > I have designed a column family > > prodgroup text, prodid int, status int, , PRIMARY KEY ((prodgroup), > prodid, status) > > The data model is to cater > > - Get list of products from the product group > - get list of products for a given range of ids > - Get details of a specific product > - Update status of the product acive/inactive > - Get list of products that are active or inactive (select * from > product where prodgroup='xyz' and prodid > 0 and status = 0) > > The design works fine, except for the last query . Cassandra not allowing > to query on status unless I fix the product id. I think defining a super > column family which has the key "PRIMARY KEY((prodgroup), staus, > productid)" should work. Would like to get expert advice on other > alternatives. > -- > Thanks, > Nageswara Rao.V > > *"The LORD reigns"* >
