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:16:10 GMT
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