incubator-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:28:36 GMT
can you give me an example of this query and the corresponding view map
function
or do we need a different reduce function

On Sun, Dec 21, 2008 at 7:27 PM, Antony Blakey <antony.blakey@gmail.com>wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message