couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "paul jobs" <webjog...@gmail.com>
Subject Re: clustering based on 2 columns
Date Mon, 22 Dec 2008 03:17:37 GMT
*key=["","2008-12-21"]
*or /invites/_view/invites/appdatecount?count=100&group=true&
key=["","2008-12-21"]

doesnt work either
please point out what i m doing wrong
On Sun, Dec 21, 2008 at 7:16 PM, paul jobs <webjogger@gmail.com> wrote:

> Key
> Value  *["animgifts", "2008-12-20"]*10420*["animgifts", "2008-12-21"]*
> 87781*["anoninbox", "2008-12-20"]*67*["anoninbox", "2008-12-21"]* 31*["areucute",
> "2008-12-20"]*434*["areucute", "2008-12-21"]* 680*["bdayecards",
> "2008-12-20"]*3175*["bdayecards", "2008-12-21"]* 12447*["crushometer",
> "2008-12-20"]*69*["crushometer", "2008-12-21"]* 250*["datevalentine",
> "2008-12-20"]*166*["datevalentine", "2008-12-21"]* 635*["igarden",
> "2008-12-20"]*16*["igarden", "2008-12-21"]* 42*["luvgifts", "2008-12-20"]*
> 72*["luvgifts", "2008-12-21"]* 81*["newstickers", "2008-12-20"]*123*["newstickers",
> "2008-12-21"]* 582*["ownmenow", "2008-12-20"]*37*["ownmenow",
> "2008-12-21"]* 72*["searchsharer", "2008-12-20"]*57*["searchsharer",
> "2008-12-21"]* 336*["searchy", "2008-12-21"]*16*["sendlovely",
> "2008-12-20"]* 239*["sendlovely", "2008-12-21"]*721*["topbffs",
> "2008-12-20"]* 40*["topbffs", "2008-12-21"]*22*["ukissme", "2008-12-20"]*
> 2939*["ukissme", "2008-12-21"]*9484   ← Previous Page | Rows per page: 10
> 25 50 100 | Next Page →
> Showing 1-29 of 29 rows
> *map3*:function(doc) {
>  emit([doc.appname,doc.date], doc.count); }
> *reduce*:function(keys, values) { return sum(values)}
>
> in this
> /invites/_view/invites/appdatecount?count=100&group=true&key="2008-12-21"
>
> or
> /invites/_view/invites/appdatecount?count=100&group=true&key=["2008-12-21"]
>
> or
> /invites/_view/invites/appdatecount?count=100&group=true&key=[,"2008-12-21"]
>
> gives rows=[]
>
> so how 2 query on a particular date
>
>
> On Sun, Dec 21, 2008 at 7:12 PM, paul jobs <webjogger@gmail.com> wrote:
>
>> how to query this for a particular say day?and is it possible to pass key
>> arguments in the futon view interface when we run the view
>>
>>
>> On Sun, Dec 21, 2008 at 4:37 PM, Antony Blakey <antony.blakey@gmail.com>wrote:
>>
>>>
>>> On 22/12/2008, at 9:19 AM, paul jobs wrote:
>>>
>>>  I want to do what map2 does but only for say "2008-12-21" ie today
>>>> how do i get today's statistics?
>>>>
>>>
>>> Split your date into three components and use them as the key e.g.
>>>
>>> [doc.appname, doc.date.year, doc.date.month, doc.date.day]
>>>
>>> This will allow you to get partial reduce results for just one day, or
>>> month, or year.
>>>
>>> Antony Blakey
>>> --------------------------
>>> CTO, Linkuistics Pty Ltd
>>> Ph: 0438 840 787
>>>
>>> Reflecting on W.H. Auden's contemplation of 'necessary murders' in the
>>> Spanish Civil War, George Orwell wrote that such amorality was only really
>>> possible, 'if you are the kind of person who is always somewhere else when
>>> the trigger is pulled'.
>>>  -- John Birmingham, "Appeasing Jakarta"
>>>
>>>
>>>
>>
>

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