Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of tommy.chheng@gmail.com
 designates 209.85.200.168 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:in-reply-to:content-type
         :content-transfer-encoding:mime-version:subject:date:references
         :x-mailer;
        b=o1q7CwEg91Ex+N5pYO9jqONweVPTrMps1NmRI3WOqYozPedi3tgFBhullCFpdV7wdK
         eEz/FQACjjuvz8MFFuPtxSoL1cHQzoXVSW3fmCLgZFiU/XxPaACouB78eij8Th6wGlqY
         1Lq2XalPBRCNj4pSl4eriPlwgO1EeFk3UCQ44=
Message-Id: <B1291763-35E6-4CE5-932E-70BFC4F8F18C@gmail.com>
From: Tommy Chheng <tommy.chheng@gmail.com>
To: user@couchdb.apache.org
In-Reply-To: <e2111bbb0907191916u601fb5eaud8fae9423bd9dcb8@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v935.3)
Subject: Re: multiple key word count query problem
Date: Sun, 19 Jul 2009 20:06:44 -0700
References: <9FAC311C-E0DD-430A-AD3D-406E4716E7D8@gmail.com>
 <e2111bbb0907191916u601fb5eaud8fae9423bd9dcb8@mail.gmail.com>

so for keys with two or more parameters, only the first parameter can  
be used for range selection? the 2nd and remaining keys can only be  
used for grouping/sorting?

the problem with having two views:
If i had two views, one for [word, doc] => count and [doc, word] =>  
count; it would be re-doing the same word counting function twice.

I'm gonna try to compute the docs word counts and store the results in  
database itself.

thanks,
tommy

On Jul 19, 2009, at 7:16 PM, Paul Davis wrote:

> On Sun, Jul 19, 2009 at 9:14 PM, Tommy  
> Chheng<tommy.chheng@gmail.com> wrote:
>> I have a simple word count view defined as:
>> --------
>> function(doc) {
>>  if(doc['couchrest-type'] == 'NsfGrant'){
>>    var words = doc['abstract'].split(/\W+/);
>>    words.forEach(function(word){
>>      if (word.length > 1) emit([word, doc['_id']],1);
>>    });
>>  }
>> }
>>
>> function(keys, values, rereduce) {
>>  return sum(values);
>> }
>> --------
>> where the key's first parameter is the word and the 2nd parameter  
>> is the
>> document_id.
>>
>> so i can do a query like this to get all the documents with the  
>> word "the"
>> correctly.
>> http://localhost:5984/nsf_grants/_design/NsfGrant/_view/by_word_doc_count?startkey= 
>> ["the"]&endkey=["the",{}]&group_level=2
>>
>> I'm having trouble doing queries on the 2nd parameter, how can i  
>> find all
>> the words in a particular document?
>> I tried
>> http://localhost:5984/nsf_grants/_design/NsfGrant/_view/by_word_doc_count?key= 
>> [null,"0808605"]&group_level=2
>> which gives nothing(thinking that null would match all words)
>> and
>> http://localhost:5984/nsf_grants/_design/NsfGrant/_view/by_word_doc_count?startkey= 
>> [null,"0808605"]&endkey=[{},"0808605"]&group_level=2
>> which gives all results. Why is this?
>>
>> Thanks,
>> Tommy
>>
>
> Querying a view is asking for a slice of a sorted list. Start and end
> keys delimit the range of rows returned. The solution to your problem
> is to create a second view so you can query by docid.
>
> Paul Davis