Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of zachary.zolton@gmail.com
 designates 209.85.210.52 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAGnHtbJLLDQrbPLmSpyeeL10V6dYLV6Ps39U9Yi-Aq3D+gsnOw@mail.gmail.com>
References: <37E896DC-095B-4AAA-AA5C-67AAE7C3B46D@p3k.org>
 <CAGnHtbKVHLc_Mbi4rDDwdpxhzcrj2-oA94Uw-1MH8UmcZF1gPg@mail.gmail.com>
 <BD206006-365F-4F22-8373-3FD14B32FCD2@p3k.org>
 <CAGnHtbJLLDQrbPLmSpyeeL10V6dYLV6Ps39U9Yi-Aq3D+gsnOw@mail.gmail.com>
From: Zachary Zolton <zachary.zolton@gmail.com>
Date: Sat, 7 Jan 2012 21:34:32 -0600
Message-ID: 
 <CAGnHtbLvUrVZ=3YAnK5O+LE6q+2zVSpzYaWrMRCEbKFy9e0z3g@mail.gmail.com>
Subject: Re: Newbie question: How to collate sum() with other properties
To: user@couchdb.apache.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Tobi,

I think it's better to get tricky with the keys emitted, and keep the
reduction using the built-in Erlang implementations. How about this?

map:

function(doc) {
  var key;
  switch (doc.type) {
      case 'poll':
        key =3D [doc._id, 0, doc.title];
      case 'vote':
        key =3D [doc.poll_id, 1, doc.choice];
  }
  emit(key, null);
}

reduce:

_count

Then, and query using group=3Dtrue, and you'll get a result like this:

{"rows":[
{"key":["d193f1137ddb65aa14100a51dc61b17e",0,"What is the
question?"],"value":1},
{"key":["d193f1137ddb65aa14100a51dc61b17e",1,"Choice 1"],"value":1}
]}

Would this suffice, for an all-in-one query?

Cheers,

Zach

On Sat, Jan 7, 2012 at 9:03 PM, Zachary Zolton <zachary.zolton@gmail.com> w=
rote:
> Well, if you know you're not going to keep adding properties, you can
> always set reduce_limit =3D false in your config.
>
> 2012/1/7 Tobi Sch=E4fer <interface@p3k.org>:
>> thanks for your suggestion, zach!
>>
>> i am delighted to hear that issuing two requests is not despised.
>>
>> nevertheless, just for the sake of fully understanding map/reduce in cou=
chdb, i read your reply as although it might be a mess of code and counter-=
intuitive it is possible and it would work=85 is that correct?
>>
>> best regards,
>> tobi
>>
>>
>> On 06.01.2012, at 18:57, Zachary Zolton wrote:
>>
>>> Tobi,
>>>
>>> You probably can somehow cram all that stuff together via the reduce
>>> function, but you miss out on being able to use the built in _count
>>> reduction and it'll take a mess of code.
>>>
>>> I think you're better off trying to retrieve this information in two
>>> queries: first query for the names and IDs of the polls and then do a
>>> second query for the count of choices of those poll IDs.
>>>
>>>
>>> Cheers,
>>>
>>> Zach
>>