Re: Query over secondary indexes

2012-10-09 Thread Vivek Mishra
user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: Query over secondary indexes 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

Re: Query over secondary indexes

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

Re: Query over secondary indexes

2012-10-09 Thread Hiller, Dean
@cassandra.apache.orgmailto:user@cassandra.apache.org user@cassandra.apache.orgmailto:user@cassandra.apache.org Subject: Re: Query over secondary indexes Thanks . This is what i have tried with cqlsh client. Is there any comparison matrix available with b/w PlayOrm and cqlsh command line client? Interesting to look

Re: Query over secondary indexes

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

Re: Query over secondary indexes

2012-10-08 Thread Vivek Mishra
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 family User which is having a indexed column user_name. My schema is having around 0.1 million

Re: Query over secondary indexes

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

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

Re: Query over secondary indexes

2012-10-05 Thread Vivek Mishra
*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 family User which is having a indexed column user_name. My schema is having around 0.1 million records only