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 torsteinkrausework@gmail.com
 designates 209.85.210.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=T3gBYwmDGcElNqDCFaJZ/g/qYfw7KvIKF7xlkuhcrQm/Uiv/d2N7i1ffA0fnzqYRh3
         8JD11xu/KrJZpuerfKVsknVPqysKOVLOb+gnoUHAYFQ0H2i+0ck32vSGYWbG4+b8vV5P
         AmkUefFsBd6yHJPsCAsauEGPQh2nTCpykwbng=
Message-ID: <4DEDC36C.5090207@gmail.com>
Date: Tue, 07 Jun 2011 14:21:32 +0800
From: Torstein Krause Johansen <torsteinkrausework@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
 rv:1.9.2.17) Gecko/20110510 Icedove/3.1.10
MIME-Version: 1.0
To: user@couchdb.apache.org
Subject: Re: Complex queries & results
References: <4DDDFD4E.9060701@gmail.com>
	<BANLkTimxsnRiAJh=+c=YWSbYxv1ba51e_w@mail.gmail.com>
	<4DDF164A.7030009@gmail.com>
	<FF823898F63A415F8CCB2EB8D4D2B48D@rgabostyle.com>
	<4DDF6BEE.8070907@gmail.com>	<4DE4F6F4.9000406@couchone.com>
	<4DECC426.9070201@gmail.com>
 <BANLkTimeE_jR0cKaSubn96b64tisq-FB7g@mail.gmail.com>
In-Reply-To: <BANLkTimeE_jR0cKaSubn96b64tisq-FB7g@mail.gmail.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit

Hi Sean,

and thank you so much for your reply.

On 06/06/11 22:09, Sean Copenhaver wrote:

> Anyway, back to what you are trying to accomplish. Honestly it sounds like
> you are trying to get too advanced for the built-in _count or _sum reduce
> functions. Have you tried writing a custom reduce function that does the
> grouping how you want, basically by name alone?
>
> https://gist.github.com/1010318
>
> I tried this out with 10 docs fitting your example structure and with a
> plain query (no grouping, no filtering, reduce on) I get back:
>
> { John: 4, Jane: 6 }

Looks spot on! Thank you _so_ much for doing this.

I'm really curious how this performs, I will be-siege my couch with bulk 
updates, giving it a big-ish data set while simultaneously be-siege it 
with reads GETs querying this map/reduce you've created. Will be very 
interesting.

I'm still puzzled, though. When reading up on reduces, I got put off 
doing anything fancy in the reduce function as the guide on 
http://guide.couchdb.org/draft/views.html#example/3 states:

"A common mistake new CouchDB users make is attempting to construct 
complex aggregate values with a reduce function. Full reductions should 
result in a scalar value, like 5, and not, for instance, a JSON hash 
with a set of unique keys and the count of each."

And from my understanding, this is exactly what I want to do here, but 
perhaps I'm misunderstanding the author's meaning here?

Cheers,

-Torstein