So that means more than one nodes can be selected to fulfill a range query based on the token, correct?
I was looking at this link: https://www.datastax.com/dev/blog/a-deep-look-to-the-cql-where-clause In the example query, SELECT * FROM numberOfRequests WHERE token(cluster, date) > token('cluster1', '2015-06-03') AND token(cluster, date) <= token('cluster1', '2015-06-05') AND time = '12:00' More than one nodes might get picked for this token based range query. And, then entire partition on each node will be searched based on the clustering key (i.e. "time" in this case). Is my understanding correct? Thanks, Preetika -----Original Message----- From: J. D. Jordan [mailto:[email protected]] Sent: Tuesday, January 30, 2018 10:13 AM To: [email protected] Subject: Re: range queries on partition key supported? A range query can be performed on the token of a partition key, not on the value. -Jeremiah > On Jan 30, 2018, at 12:21 PM, Tyagi, Preetika <[email protected]> > wrote: > > Hi All, > > I have a quick question on Cassandra's behavior in case of partition keys. I > know that range queries are allowed in general, however, is it also allowed > on partition keys as well? The partition key is used as an input to determine > a node in a cluster, so I'm wondering how one can possibly perform range > query on that. > > Thanks, > Preetika > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
