Re: Query over secondary indexes

2012-10-09 Thread Hiller, Dean
>> >Date: Tuesday, October 9, 2012 7:39 AM >To: Nrel mailto:dean.hil...@nrel.gov>>, >"user@cassandra.apache.org<mailto:user@cassandra.apache.org>" >mailto:user@cassandra.apache.org>> >Subject: Re: Query over secondary indexes > >Thanks . This is w

Re: Query over secondary indexes

2012-10-09 Thread Hiller, Dean
a.v...@gmail.com>> Date: Tuesday, October 9, 2012 7:39 AM To: Nrel mailto:dean.hil...@nrel.gov>>, "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: Query over secondary indexes Thanks . This is what i have

Re: Query over secondary indexes

2012-10-09 Thread Vivek Mishra
t; To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" < > user@cassandra.apache.org<mailto:user@cassandra.apache.org>> > Subject: Re: Query over secondary indexes > > I did wait for atleast 5 minutes before terminating it. Also sometimes it > re

Re: Query over secondary indexes

2012-10-08 Thread Vivek Mishra
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 wrote: > It was on 1 node and there is no error in server logs. > > -Vivek > > > On Tue, Oct 9, 201

Re: Query over secondary indexes

2012-10-08 Thread Vivek Mishra
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 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 ther

Re: Query over secondary indexes

2012-10-08 Thread aaron morton
> 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.

Re: Query over secondary indexes

2012-10-05 Thread Vivek Mishra
Thanks Rishabh. But i want to search over duplicate columns only. -Vivek On Fri, Oct 5, 2012 at 2:45 PM, Rishabh Agrawal < rishabh.agra...@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 >

RE: Query over secondary indexes

2012-10-05 Thread Rishabh Agrawal
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.v...@gmail.com] Sent: Friday, October 05, 2012 2:35 PM To: user@cassandra.apache.org Subject: Query over secondary indexes I have a column f