lucene-solr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erick Erickson <erickerick...@gmail.com>
Subject Re: faceting on multiple fields
Date Fri, 05 Mar 2010 13:49:13 GMT
Please post further questions on this topic to the solr
users' list at solr-user@lucene.apache.org. This list is
intended for internal SOLR development discussions.....

Best
Erick

On Thu, Mar 4, 2010 at 9:40 PM, Seffie Schwartz <yschwart@yahoo.com> wrote:

> Hi -
>
> How do I facet on two fields at the same time -  If I were using a data
> base I would say -
>
> select a,b,count(*) from mytable group by a,b order by count(*) desc.
>
> How could I do the same with faceting.  I know that I can facet on a
> separately and b separately but how do
> I do a & b.
>
> Another question -
>
> If I had two tables in my relational data base - For example I have an
> organization and an employee table in my data base.  I join the tables
> and flatten them.  Then I index them into solr.  How could I know if there
> are any organizations without employees in solr?  In a data base I would
> do a left join.
>
> Thanks.  Seffie Schwartz.
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message