Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of kowsik@gmail.com designates
 74.125.92.148 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=s/k4LF8GVQYZO0qSc6/rYz7bebWHyFevEyzqVK9iPwp3HzJ3B59VPfRKo6T1Kc4lJy
         Ptfl8Tn7HBTda0oJ09sMCsZ1qnwD3UM7cAiRFRV5VQQmadRH6CQbfp/W8rAk3xgHVZ7q
         zbyoeAVnF5QAVRRVzUFLqJkWouJh8Ay0ZErW8=
Message-ID: <7db9abd30809302015y73b5448bja173913cf40a5d2f@mail.gmail.com>
Date: Tue, 30 Sep 2008 20:15:16 -0700
From: kowsik <kowsik@gmail.com>
To: couchdb-user@incubator.apache.org
Subject: Re: Top 10 sorted by value...
In-Reply-To: <6dfc41e10809301826s2ca56a5dn87bd378cdcb87984@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <7db9abd30809301754t3fce914dr61befd2897170140@mail.gmail.com>
	 <6dfc41e10809301826s2ca56a5dn87bd378cdcb87984@mail.gmail.com>

Going through all responses, so I'm sure there's another answer further down.

Noah, this doesn't work since it sorts by 'key'. I want the top 10
sorted by 'value'. In other words I want the result to be:

{ key: "b", value: 12 },
{ key: "a", value: 10 },
{ key: "c", value: 1 }

and so on.

K.

On Tue, Sep 30, 2008 at 6:26 PM, Noah Tye <noah@tyes.us> wrote:
> On Tue, Sep 30, 2008 at 5:54 PM, kowsik <kowsik@gmail.com> wrote:
>> I have a data set where my map reduce returns data like so:
>>
>> { key: "a", value: 10 },
>> { key: "b", value: 12 },
>> { key: "c", value: 1 },
>> ...
>>
>> Potentially this could be fairly large, even after the reduce. Is
>> there any way to:
>>
>> 1. sort these by descending values? I only want the top 10.
>
> count=10
>
>> 2. page through them in the sorted order?
>
> startkey=<wherever you want to start>
>
> Take a look at <http://wiki.apache.org/couchdb/HttpViewApi>, in the
> section "Querying Options".
>
> --
> ''=~('(?{'.('/))./@'^'_[@@[`').'"'.('./](@{"[^'^'`@<@`/[>|').',$/})')
> noah@tyes.us | http://noah.tyes.us
> "They copied all they could follow, but they couldn't copy my mind,
> And I left 'em sweating and stealing a year and a half behind."
>