--Original Message-
From: Alvaro Cabrerizo [mailto:topor...@gmail.com]
Sent: Friday, February 19, 2016 1:02 AM
To: solr-user@lucene.apache.org
Subject: Re: Hitting complex multilevel pivot queries in solr
Hi,
The only way I can imagine is to create that auxiliar field for performing the
facet on it.
a Query:
>
> RETURN Results as SELECT Count(1) as "Total" GROUP BY "Country", "State",
> "part_num", "part_code" ORDER BY "Total" desc PAGE(0,100)
>
>
> -Lewin
>
>
> -Original Message-
> From: Alvaro Cabre
tate",
"part_num", "part_code" ORDER BY "Total" desc PAGE(0,100)
-Lewin
-Original Message-
From: Alvaro Cabrerizo [mailto:topor...@gmail.com]
Sent: Thursday, February 18, 2016 3:06 PM
To: solr-user@lucene.apache.org
Subject: Re: Hitting complex multile
Hi,
The idea of copying fields into a new one (or various) during indexing and
then facet the new field (or fields) looks promising. More information
about data will be helpful (for example if the fields:country, state.. are
single or multivalued). For example if all of the fields are single value
Still splitting my head over this one.
Let me know if anyone has any idea I could try.
Or, is there a way to concatenate these 4 fields onto a dynamic field and do a
facet.field on top of this one?
Thanks. Any idea is helpful to try.
-Lewin
-Original Message-
From: Lewin Joy (TMS) [ma