couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antony Blakey <antony.bla...@gmail.com>
Subject Re: clustering based on 2 columns
Date Mon, 22 Dec 2008 03:27:04 GMT
If you want to reduce over the appname, then that has to occur after  
the date in the key.

On 22/12/2008, at 1:47 PM, paul jobs wrote:

> *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"
>>>>
>>>>
>>>>
>>>
>>

Antony Blakey
--------------------------
CTO, Linkuistics Pty Ltd
Ph: 0438 840 787

Lack of will power has caused more failure than lack of intelligence  
or ability.
  -- Flower A. Newhouse


Mime
View raw message