incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vivek Mishra <mishra.v...@gmail.com>
Subject Re: Query over secondary indexes
Date Tue, 09 Oct 2012 01:37:39 GMT
I did wait for atleast 5 minutes before terminating it. Also sometimes it
results in server crash as well, though data volume is not very huge.

-Vivek

On Tue, Oct 9, 2012 at 7:05 AM, Vivek Mishra <mishra.vivs@gmail.com> wrote:

> It was on 1 node and there is no error in server logs.
>
> -Vivek
>
>
> On Tue, Oct 9, 2012 at 1:21 AM, aaron morton <aaron@thelastpickle.com>wrote:
>
>>   get User where user_name = 'Vivek', it is taking ages to retrieve that
>>> data. Is there anything i am doing wrong?
>>>
>> How long is ages and how many nodes do you have?
>> Are there any errors in server logs ?
>>
>> When you do a get by secondary index at a CL higher than ONE ever RFth
>> node is involved.
>>
>> Cheers
>>
>>
>>   -----------------
>> Aaron Morton
>> Freelance Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 5/10/2012, at 10:20 PM, Vivek Mishra <mishra.vivs@gmail.com> wrote:
>>
>> Thanks Rishabh. But i want to search over duplicate columns only.
>>
>> -Vivek
>>
>> On Fri, Oct 5, 2012 at 2:45 PM, Rishabh Agrawal <
>> rishabh.agrawal@impetus.co.in> wrote:
>>
>>>  Try making *user_name* a primary key in combination with some other
>>> unique column and see if results are improving.
>>>
>>> -Rishabh
>>>
>>> *From:* Vivek Mishra [mailto:mishra.vivs@gmail.com]
>>> *Sent:* Friday, October 05, 2012 2:35 PM
>>> *To:* user@cassandra.apache.org
>>> *Subject:* Query over secondary indexes
>>>
>>>
>>> I have a column family "User" which is having a indexed column
>>> "user_name". My schema is having around 0.1 million records only and
>>> user_name is duplicated  across all rows.
>>>
>>> Now when i am trying to retrieve it as:
>>>
>>> get User where user_name = 'Vivek', it is taking ages to retrieve that
>>> data. Is there anything i am doing wrong?
>>>
>>> Also, i tried get_indexed_slices via Thrift API by setting
>>> IndexClause.setCount(1), still  no luck, it got hang and not even returning
>>> a single result. I believe 0.1 million is not a huge amount of data.
>>>
>>>
>>> Cassandra version : 1.1.2
>>>
>>> Any idea?
>>>
>>>
>>> -Vivek
>>>
>>> ------------------------------
>>>
>>> Impetus Ranked in the Top 50 India’s Best Companies to Work For 2012.
>>>
>>> Impetus webcast ‘Designing a Test Automation Framework for Multi-vendor
>>> Interoperable Systems’ available at http://lf1.me/0E/.
>>>
>>>
>>> NOTE: This message may contain information that is confidential,
>>> proprietary, privileged or otherwise protected by law. The message is
>>> intended solely for the named addressee. If received in error, please
>>> destroy and notify the sender. Any use of this email is prohibited when
>>> received in error. Impetus does not represent, warrant and/or guarantee,
>>> that the integrity of this communication has been maintained nor that the
>>> communication is free of errors, virus, interception or interference.
>>>
>>
>>
>>
>

Mime
View raw message