cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: How does Cassandra optimize this query?
Date Mon, 05 Nov 2012 17:24:58 GMT
On Mon, Nov 5, 2012 at 4:12 PM, Edward Capriolo <edlinuxguru@gmail.com>wrote:

> Is this query the equivalent of a full table scan?  Without a starting
> point get_range_slice is just starting at token 0?
>

It is, but that's what you asked for after all. If you want to start at a
given token you can do:
  SELECT * FROM videos WHERE videoname = 'My funny cat' AND token(video) >
'whatevertokenyouwant'
You can even do:
  SELECT * FROM videos WHERE videoname = 'My funny cat' AND token(video) >
token(99051fe9-6a9c-46c2-b949-38ef78858dd0)
if that's simpler for you than computing the token manually. Though that is
mostly for random partitioners. For ordered ones, you can do without the
token() part.

--
Sylvain

Mime
View raw message