Create a column family of compositeType (or PRIMARY KEY) as (user_id,age, salary).
Then you will be able to query use eq operator over partition key and as well over clustering key: You may also exclude salary as a secondary index rather than part of cluster key(e.g. age,salary) I am sure based on your query usage, you can opt for either a composite key or may mix composite key with secondary index ! Have a look at: http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1 Hope it helps. -Vivek On Wed, Aug 28, 2013 at 5:49 PM, Sávio Teles <savio.te...@lupa.inf.ufg.br>wrote: > I can populate again. We are modelling the data yet! Tks. > > > 2013/8/28 Vivek Mishra <mishra.v...@gmail.com> > >> Just saw that you already have data populated, so i guess modifying for >> composite key may not work for you. >> >> -Vivek >> >> >> On Tue, Aug 27, 2013 at 11:55 PM, Sávio Teles < >> savio.te...@lupa.inf.ufg.br> wrote: >> >>> Vivek, using a composite key, how would be the query? >>> >>> >>> 2013/8/27 Vivek Mishra <mishra.v...@gmail.com> >>> >>>> For such queries, looks like you may create a composite key as >>>> (user_id,age, salary). >>>> >>>> Too much indexing always kills(irrespective of RDBMS or NoSQL). >>>> Remember every search request on secondary indexes will be passed on each >>>> node in ring. >>>> >>>> -Vivek >>>> >>>> >>>> On Tue, Aug 27, 2013 at 11:11 PM, Sávio Teles < >>>> savio.te...@lupa.inf.ufg.br> wrote: >>>> >>>>> Use a database that is designed for efficient range queries? ;D >>>>>> >>>>> >>>>> Is there no way to do this with Cassandra? Like using Hive, Sorl... >>>>> >>>>> >>>>> 2013/8/27 Robert Coli <rc...@eventbrite.com> >>>>> >>>>>> On Fri, Aug 23, 2013 at 5:53 AM, Sávio Teles < >>>>>> savio.te...@lupa.inf.ufg.br> wrote: >>>>>> >>>>>>> I need to perform range query efficiently. >>>>>>> >>>>>> ... >>>>>> >>>>>>> This query takes a long time to run. Any ideas to perform it >>>>>>> efficiently? >>>>>>> >>>>>> >>>>>> Use a database that is designed for efficient range queries? ;D >>>>>> >>>>>> =Rob >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Atenciosamente, >>>>> Sávio S. Teles de Oliveira >>>>> voice: +55 62 9136 6996 >>>>> http://br.linkedin.com/in/savioteles >>>>> Mestrando em Ciências da Computação - UFG >>>>> Arquiteto de Software >>>>> Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG >>>>> >>>> >>>> >>> >>> >>> -- >>> Atenciosamente, >>> Sávio S. Teles de Oliveira >>> voice: +55 62 9136 6996 >>> http://br.linkedin.com/in/savioteles >>> Mestrando em Ciências da Computação - UFG >>> Arquiteto de Software >>> Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG >>> >> >> > > > -- > Atenciosamente, > Sávio S. Teles de Oliveira > voice: +55 62 9136 6996 > http://br.linkedin.com/in/savioteles > Mestrando em Ciências da Computação - UFG > Arquiteto de Software > Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG >
