Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 55974 invoked from network); 2 Mar 2011 15:51:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Mar 2011 15:51:50 -0000 Received: (qmail 12138 invoked by uid 500); 2 Mar 2011 15:51:48 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 11830 invoked by uid 500); 2 Mar 2011 15:51:44 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 11821 invoked by uid 99); 2 Mar 2011 15:51:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2011 15:51:42 +0000 X-ASF-Spam-Status: No, hits=2.9 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL,WEIRD_QUOTING X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [195.238.6.171] (HELO mailrelay005.isp.belgacom.be) (195.238.6.171) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Mar 2011 15:51:36 +0000 X-Belgacom-Dynamic: yes X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnUDAI/0bU1bsiVc/2dsb2JhbAAMC4I3nyaaa6hWhWEEkns Received: from 92.37-178-91.adsl-dyn.isp.belgacom.be (HELO [192.168.1.2]) ([91.178.37.92]) by relay.skynet.be with ESMTP; 02 Mar 2011 16:51:12 +0100 Message-ID: <4D6E676D.5050007@u-mangate.com> Date: Wed, 02 Mar 2011 16:51:09 +0100 From: Eric Charles User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.14) Gecko/20110221 Thunderbird/3.1.8 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: Is it possible to get list of row keys? References: <4D6E13B1.3020205@u-mangate.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------010302080303050408030409" This is a multi-part message in MIME format. --------------010302080303050408030409 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit OK, got it. Tks for the explanation, - Eric On 2/03/2011 14:45, Ching-Cheng Chen wrote: > Stable order mean the keys will return in some kind of ordering (not > alphanumeric, not numeric,), just in certain order. > > For example, if you use setKeys("","") as first batch call and you got > following result. > > keyabc > key456 > keydsg > key8jkg > keyag87 > key45s > ... > > Then if you call with setKeys("keydsg","") again, you will get > following result. > > keydsg > key8jkg > keyag87 > key45s > ... > > Regards, > > Chen > > www.evidentsoftware.com > > On Wed, Mar 2, 2011 at 4:53 AM, Eric Charles > > wrote: > > Hi, > > I'm also facing the need to retrieve all row keys. > > What do you mean with "stable" order? > From this thread, I understand paging method with > RandomPartitioner will return all keys (shuffled, but missing key, > no double key). > This seems to have already told, but I prefer to double-check... > > Tks, > - Eric > > > > On 23/02/2011 15:24, Daniel Lundin wrote: > > They are, however, in *stable* order, which is important. > > On Wed, Feb 23, 2011 at 3:20 PM, Norman > Maurer> wrote: > > yes but be aware that the keys will not in the "right order". > > Bye, > Norman > > 2011/2/23 Roshan Dawrani >: > > On Wed, Feb 23, 2011 at 7:17 PM, Ching-Cheng Chen > > wrote: > > Actually, if you want to get ALL keys, I believe > you can still use > RangeSliceQuery with RP. > Just use setKeys("","") as first batch call. > Then use the last key from previous batch as > startKey for next batch. > Beware that since startKey is inclusive, so you'd > need to ignore first key > from now on. > Keep going until you finish all batches. You will > know you'd need to stop > when setKeys(key_xyz,"") return you only one key. > > This is what I meant to suggest when I earlier said > "So, if you want all, > you will need to keep paging forward and collecting > the keys." :-) > > > --------------010302080303050408030409 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit OK, got it.
Tks for the explanation,
- Eric

On 2/03/2011 14:45, Ching-Cheng Chen wrote:
Stable order mean the keys will return in some kind of ordering (not alphanumeric, not numeric,), just in certain order.

For example, if you use setKeys("","") as first batch call and you got following result.

keyabc
key456
keydsg
key8jkg
keyag87
key45s
...

Then if you call with setKeys("keydsg","") again, you will get following result.

keydsg
key8jkg
keyag87
key45s
...

Regards,

Chen


On Wed, Mar 2, 2011 at 4:53 AM, Eric Charles <eric.charles@u-mangate.com> wrote:
Hi,

I'm also facing the need to retrieve all row keys.

What do you mean with "stable" order?
From this thread, I understand paging method with RandomPartitioner will return all keys (shuffled, but missing key, no double key).
This seems to have already told, but I prefer to double-check...

Tks,
- Eric



On 23/02/2011 15:24, Daniel Lundin wrote:
They are, however, in *stable* order, which is important.

On Wed, Feb 23, 2011 at 3:20 PM, Norman Maurer<norman@apache.org>  wrote:
yes but be aware that the keys will not in the "right order".

Bye,
Norman

2011/2/23 Roshan Dawrani<roshandawrani@gmail.com>:
On Wed, Feb 23, 2011 at 7:17 PM, Ching-Cheng Chen
<cchen@evidentsoftware.com>  wrote:
Actually, if you want to get ALL keys, I believe you can still use
RangeSliceQuery with RP.
Just use setKeys("","") as first batch call.
Then use the last key from previous batch as startKey for next batch.
Beware that since startKey is inclusive, so you'd need to ignore first key
from now on.
Keep going until you finish all batches.  You will know you'd need to stop
when setKeys(key_xyz,"") return you only one key.
This is what I meant to suggest when I earlier said "So, if you want all,
you will need to keep paging forward and collecting the keys." :-)



--------------010302080303050408030409--