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
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

RE: Hitting complex multilevel pivot queries in solr

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