You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Qingdi <li...@yahoo.com> on 2009/04/28 22:07:19 UTC
facet with group by (or field collapsing)
Hi,
Is it possible to group the search result on certain field and then do facet
counting?
For example, the index is defined with the following fields:
Kid_Id, Family_Id, Age, School, Favorite_Sports (MultiValue Field)
We want to query with Age between 10 yrs to 12 yrs and School in (School_A,
School_B), and do faceting on Favorite_Sports. But instead of showing the
count of kids for each sport, we want to show the count of Families.
Each family can have multiple kids. How to group the search result on
Family_Id, and then do faceting on Favorite_Sports?
Appreciate your help.
Qingdi
--
View this message in context: http://www.nabble.com/facet-with-group-by-%28or-field-collapsing%29-tp23285038p23285038.html
Sent from the Solr - User mailing list archive at Nabble.com.
RE: facet with group by (or field collapsing)
Posted by Qingdi <li...@yahoo.com>.
Hi Tim,
Thanks for your reply. The index structure in my original post is just an
example. We do have many free text fields with different analyzers.
I checked your post "Distinct terms in facet field", but I think the issues
we try to address are different. Yours is to get distinct terms in the facet
field, but what I want is to count the distinct values on the non-facet
field.
Since the facet results are much smaller than the query result, you could
get all the facets and count by yourself. But in my case, if I count by
myself, I have to get all the query results, and then count on distinct
family_id for each facet value.
Thanks.
Qingdi
Harsch, Timothy J. (ARC-SC)[LOCKHEED MARTIN SPACE OPNS] wrote:
>
> I began a similar thread under the subject "Distinct terms in facet
> field".
>
> One thing I noticed though is that your fields seem to have a lot of
> controlled values, or lack free text. Are you sure SOLR is what you
> should be using? Perhaps a traditional RDB would be better and then you
> would have "GROUP BY" and aggregate functions at your disposal...
>
> HTH,
> Tim
>
> -----Original Message-----
> From: Qingdi [mailto:liuqingdi@yahoo.com]
> Sent: Tuesday, April 28, 2009 1:07 PM
> To: solr-user@lucene.apache.org
> Subject: facet with group by (or field collapsing)
>
>
> Hi,
>
> Is it possible to group the search result on certain field and then do
> facet
> counting?
>
> For example, the index is defined with the following fields:
> Kid_Id, Family_Id, Age, School, Favorite_Sports (MultiValue Field)
>
> We want to query with Age between 10 yrs to 12 yrs and School in
> (School_A,
> School_B), and do faceting on Favorite_Sports. But instead of showing the
> count of kids for each sport, we want to show the count of Families.
>
> Each family can have multiple kids. How to group the search result on
> Family_Id, and then do faceting on Favorite_Sports?
>
> Appreciate your help.
>
> Qingdi
>
>
> --
> View this message in context:
> http://www.nabble.com/facet-with-group-by-%28or-field-collapsing%29-tp23285038p23285038.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
>
--
View this message in context: http://www.nabble.com/facet-with-group-by-%28or-field-collapsing%29-tp23285038p23287434.html
Sent from the Solr - User mailing list archive at Nabble.com.
RE: facet with group by (or field collapsing)
Posted by "Harsch, Timothy J. (ARC-SC)[PEROT SYSTEMS]" <ti...@nasa.gov>.
I began a similar thread under the subject "Distinct terms in facet field".
One thing I noticed though is that your fields seem to have a lot of controlled values, or lack free text. Are you sure SOLR is what you should be using? Perhaps a traditional RDB would be better and then you would have "GROUP BY" and aggregate functions at your disposal...
HTH,
Tim
-----Original Message-----
From: Qingdi [mailto:liuqingdi@yahoo.com]
Sent: Tuesday, April 28, 2009 1:07 PM
To: solr-user@lucene.apache.org
Subject: facet with group by (or field collapsing)
Hi,
Is it possible to group the search result on certain field and then do facet
counting?
For example, the index is defined with the following fields:
Kid_Id, Family_Id, Age, School, Favorite_Sports (MultiValue Field)
We want to query with Age between 10 yrs to 12 yrs and School in (School_A,
School_B), and do faceting on Favorite_Sports. But instead of showing the
count of kids for each sport, we want to show the count of Families.
Each family can have multiple kids. How to group the search result on
Family_Id, and then do faceting on Favorite_Sports?
Appreciate your help.
Qingdi
--
View this message in context: http://www.nabble.com/facet-with-group-by-%28or-field-collapsing%29-tp23285038p23285038.html
Sent from the Solr - User mailing list archive at Nabble.com.