Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.223.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKkz8Q2i1yxM++y5YOeD6=CoNP11nrF5p05q3tH56TBGjwmC1Q@mail.gmail.com>
References: 
 <CAENxBwzsV3rdeMKutz4SMoD+QLcOEc6JXYt0iWQQ+QhJ2M_6kw@mail.gmail.com>
	<CAKkz8Q2bLcXBZTXz9TVA7uXO4yXf+Q3zPRaN16e93hX6-MQd=A@mail.gmail.com>
	<CAENxBwza=vow0PQN_zqmytSqYxTrGoUiyOHOOMP-KtPSkNyo5g@mail.gmail.com>
	<CAKkz8Q2i1yxM++y5YOeD6=CoNP11nrF5p05q3tH56TBGjwmC1Q@mail.gmail.com>
Date: Mon, 5 Nov 2012 12:55:36 -0500
Message-ID: 
 <CAENxBwwLSn8BP0a4=2ZKWbCUqFfwufd=n+TeUg+QNCTrRKev1A@mail.gmail.com>
Subject: Re: How does Cassandra optimize this query?
From: Edward Capriolo <edlinuxguru@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

I see. It is fairly misleading because it is a query that does not
work at scale. This syntax is only helpful if you have less then a few
thousand rows in Cassandra.

On Mon, Nov 5, 2012 at 12:24 PM, Sylvain Lebresne <sylvain@datastax.com> wrote:
> 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