Hi Thomas, The idea here is that you'd have two or more views and you'd implement the join or aggregation logic at the client side.
At some level or another that is, in effect, what N1QL would be doing for you. With current GA software, you'll need to implement some of that logic at the client side. It's not too bad. Matt From: Thomas <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Tuesday, December 31, 2013 4:02 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: Distinct, unique count of users with map reduce Hi and sorry for the spam, I have also found this post which says that it is not possible to do a second map/reduce on the results on a first map/reduce? http://www.couchbase.com/communities/q-and-a/mapreduce-chain-couchbase Any ideas of how to implement this Thanks On Friday, 27 December 2013 18:05:48 UTC+2, Thomas wrote: Hi, I was googling around for a solution of a map/reduce where I will be able to perform a distinct/unique count of user ids, but I wasn't able to find a concrete solution/answer to this topic. My case is to count the unique users per day for example as well as other criteria. I have for example the following JSON documents of events: {"user":"user1", "color":"blue"} {"user":"user1", "color":"blue"} {"user":"user1", "color":"red"} {"user":"user2", "color":"blue"} And with my map/reduce view I want to do the following * number of distinct users per color { color: blue, count: 2} { color: red, count: 1} in SQL terms select color, count(distinct user) as users from test group by color Thanks -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- Matt Ingenthron Couchbase, Inc. -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
