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) [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. 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 way to get the data? Example Query Params looks like this: &facet.pivot=country,state,part_num,part_code Thanks, Lewin
