Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of paul.joseph.davis@gmail.com
 designates 209.85.198.228 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=to9/WnElGGFRdGOJGcf6W7ZF22Nmp2+C04BeTZVq1Dn80sUquCi6HU2bwrsj+QmJ4T
         xvVOCu7ZfOXjfNRTy57n/5+ITnNWyv+aShyyT1zSZvWVkKLmknkfktEBlbl3AguwA7zD
         /ZMMRh3dHmuVukid3HzjoWOvuWMyxvnKoNum8=
Message-ID: <e2111bbb0812311457k3d894946hcfef368db078a633@mail.gmail.com>
Date: Wed, 31 Dec 2008 17:57:56 -0500
From: "Paul Davis" <paul.joseph.davis@gmail.com>
To: user@couchdb.apache.org
Subject: Re: group_level and intermediate reduce results
In-Reply-To: <905d10ce0812311448p756d8931h8600491f1c847ca7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <905d10ce0812311448p756d8931h8600491f1c847ca7@mail.gmail.com>

On Wed, Dec 31, 2008 at 5:48 PM, Scott Robertson <scott@zeepmobile.com> wrote:
> I think I understand how group_level works. Is there a way to get the
> results of multiple levels with one get?
>
> For example say I'm creating a view that counts how many documents a
> member has created and how many docs all the members of each group has
> created. Using a two part key.
>
> My map would look something like this
>
> function(doc){
>  emit([doc.group, doc.member], 1);
> }
>
> And my reduce sums the values
>
> function(keys, values){
>  return sum(values);
> }
>
> I can get the counts for each member like this
> http://localhost:5984/mydb/_view/sums/all?group_level=2
>
> Which return something like
>
> key                             |  value
> ==================================
> [group1,member1]     |  5
> [group1,member2]     |  3
> [group1,member3]     |  1
> [group2,member4]     |  1
>
> And  I can get the sums for each group
> http://localhost:5984/mydb/_view/sums/all?group_level=1
>
> key                             |  value
> ==================================
> [group1]                     |  9
> [group2]                     |  1
>
> Is there away that I can request those values merged, so that it looks
> like this?
>
> key                             |  value
> ==================================
> [group1]                     |  9
> [group1,member1]     |  5
> [group1,member2]     |  3
> [group1,member3]     |  1
> [group2]                     |  1
> [group2,member4]     |  1
>
> W/o having to make two separate requests?
>

No, not at the moment. The way the group_level is implemented you'd
basically need to fold over the view twice or make that work.