incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hiller, Dean" <Dean.Hil...@nrel.gov>
Subject Re: Data Model and Query
Date Fri, 05 Apr 2013 19:22:45 GMT
I would partition either with cassandra's partitioning or PlayOrm partitioning and query like
so

Where beginOfMonth=xxxxx and startDate>"X" and counter > "Y".  This only returns stuff
after X in that partition though so you may need to run multiple queries like this and if
you have billions of rows it could take some time….instead you may want startData > X
and startDate < Z such that Z and X are in the same month or if they span 2-3 partitions,
then just run the 2-3 queries.  I don't know enough detail on your use case to know if this
works for you though.

Dean

From: aaron morton <aaron@thelastpickle.com<mailto:aaron@thelastpickle.com>>
Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
Date: Friday, April 5, 2013 10:59 AM
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
Subject: Re: Data Model and Query


Whats the recommendation on querying a data model like  StartDate > “X” and counter
> “Y” .

it's not possible.

If you are using secondary indexes you have to have an equals clause in the statement.

Cheers

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 4/04/2013, at 6:53 AM, shubham srivastava <shubham.k@gmail.com<mailto:shubham.k@gmail.com>>
wrote:


Hi,



Whats the recommendation on querying a data model like  StartDate > “X” and counter
> “Y” . Its kind of range queries across multiple columns and key.

I have the flexibility for modelling the data for the above query accordingly.



Regards,

Shubham


Mime
View raw message