Re: count(*) equivilent in Solr/Lucene

2010-10-19 Thread Dennis Gearon
, 10/18/10, Chris Hostetter hossman_luc...@fucit.org wrote: From: Chris Hostetter hossman_luc...@fucit.org Subject: Re: count(*) equivilent in Solr/Lucene To: solr-user@lucene.apache.org Date: Monday, October 18, 2010, 10:26 PM : : SELECT :   COUNT(*) : WHERE :   date_column1 :start_date

Re: count(*) equivilent in Solr/Lucene

2010-10-19 Thread Grant Ingersoll
hossman_luc...@fucit.org Subject: Re: count(*) equivilent in Solr/Lucene To: solr-user@lucene.apache.org Date: Monday, October 18, 2010, 10:26 PM : : SELECT : COUNT(*) : WHERE : date_column1 :start_date AND : date_column2 :end_date; q=*:*fq=column1:[start TO *]fq=column2:[end

count(*) equivilent in Solr/Lucene

2010-10-18 Thread Dennis Gearon
Is there something in Solr/Lucene that could give me the equivalent to: SELECT COUNT(*) WHERE date_column1 :start_date AND date_column2 :end_date; Providing I take into account deleted documents, of course (I.E., do some sort of averaging or some tracking function over time.) Dennis

Re: count(*) equivilent in Solr/Lucene

2010-10-18 Thread Chris Hostetter
: : SELECT : COUNT(*) : WHERE : date_column1 :start_date AND : date_column2 :end_date; q=*:*fq=column1:[start TO *]fq=column2:[end TO *]rows=0 ...every result includes a total count. -Hoss