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 13:39:34 GMT
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 into if it is faster than cql client.

I guess problem is with secondary indexing not the volume, because i don't
want to go for wide row indexing/compount primary key approach.

-Vivek

On Tue, Oct 9, 2012 at 6:20 PM, Hiller, Dean <Dean.Hiller@nrel.gov> wrote:

> Another option may be PlayOrm for you and it's scalable-SQL.  We queried
> one million rows for 100 results in just 60ms.  (and it does joins).  Query
> CL =QUORUM.
>
> Dean
>
> From: Vivek Mishra <mishra.vivs@gmail.com<mailto:mishra.vivs@gmail.com>>
> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <
> user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
> Date: Monday, October 8, 2012 7:37 PM
> 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
> 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
> <mailto: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
> <mailto: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<mailto:
> 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<mailto: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<mailto:
> mishra.vivs@gmail.com>]
> Sent: Friday, October 05, 2012 2:35 PM
> To: user@cassandra.apache.org<mailto: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