incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Keith Gable <zi...@ignition-project.com>
Subject Re: Distinct values with range
Date Mon, 15 Apr 2013 14:18:04 GMT
Output keys like so:

[2010, 7, 10, "Australia"]

Reduce function would be _count.

startkey=[year,month,day,null]
endkey=[year,month,day,{}]

---
Keith Gable
A+, Network+, and Storage+ Certified Professional
Apple Certified Technical Coordinator
Mobile Application Developer / Web Developer


On Sun, Apr 14, 2013 at 8:37 PM, Andrey Kuprianov <
andrey.kouprianov@gmail.com> wrote:

> Hi guys,
>
> Just for the sake of a debate. Here's the question. There are transactions.
> Among all other attributes there's timestamp (when transaction was made; in
> seconds) and a country name  (from where the transaction was made). So, for
> instance,
>
> {
>     . . . .
>     "timestamp": 1332806400
>     "country_name": "Australia",
>     . . . .
> }
>
> Question is: how does one get unique / distinct country names in between
> dates? For example, give me all country names in between 10-Jul-2010 and
> 21-Jan-2013.
>
> My solution was to write a custom reduce function and set
> reduce_limit=false, so that i can enumerate all countries without hitting
> the overflow exception. It works great! However, such solutions are frowned
> upon by everyone around. Has anyone a better idea on how to tackle this
> efficiently?
>
>     Andrey
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message