RE: Hitting complex multilevel pivot queries in solr

2016-02-24 Thread Lewin Joy (TMS)
--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.

Re: Hitting complex multilevel pivot queries in solr

2016-02-19 Thread Alvaro Cabrerizo
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

RE: Hitting complex multilevel pivot queries in solr

2016-02-18 Thread Lewin Joy (TMS)
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

Re: Hitting complex multilevel pivot queries in solr

2016-02-18 Thread Alvaro Cabrerizo
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

RE: Hitting complex multilevel pivot queries in solr

2016-02-18 Thread Lewin Joy (TMS)
) [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

Hitting complex multilevel pivot queries in solr

2016-02-17 Thread Lewin Joy (TMS)
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