incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sávio Teles <savio.te...@lupa.inf.ufg.br>
Subject Re: How to perform range queries efficiently?
Date Wed, 28 Aug 2013 12:19:49 GMT
I can populate again. We are modelling the data yet! Tks.


2013/8/28 Vivek Mishra <mishra.vivs@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.teles@lupa.inf.ufg.br
> > wrote:
>
>> Vivek, using a composite key, how would be the query?
>>
>>
>> 2013/8/27 Vivek Mishra <mishra.vivs@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.teles@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 <rcoli@eventbrite.com>
>>>>
>>>>> On Fri, Aug 23, 2013 at 5:53 AM, Sávio Teles <
>>>>> savio.teles@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

Mime
View raw message