--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
ota.com]
> Sent: Wednesday, February 17, 2016 4:29 PM
> To: solr-user@lucene.apache.org
> Subject: Hitting complex multilevel pivot queries in solr
>
> Hi,
>
> Is there an efficient way to hit solr for complex time consuming queries?
> I have a requirement where I need to
) [mailto:lewin@toyota.com]
Sent: Wednesday, February 17, 2016 4:29 PM
To: solr-user@lucene.apache.org
Subject: Hitting complex multilevel pivot queries in solr
Hi,
Is there an efficient way to hit solr for complex time consuming queries?
I have a requirement where I need to pivot on 4 fields
Hi,
Is there an efficient way to hit solr for complex time consuming queries?
I have a requirement where I need to pivot on 4 fields. Two fields contain
facet values close to 50. And the other 2 fields have 5000 and 8000 values.
Pivoting on the 4 fields would crash the server.
Is there a better