For pivot facets in SolrCloud, see https://issues.apache.org/jira/browse/SOLR-2894
Resolution: Unresolved Fix Version/s 4.8 I am waiting patiently ... On 03/27/2014 05:04 AM, Alvaro Cabrerizo wrote:
I don't think you can do it, as pivot faceting<http://wiki.apache.org/solr/SimpleFacetParameters#Pivot_.28ie_Decision_Tree.29_Faceting> doesn't let you use facet queries. The closer query I can imagine is: - q=sentence:bar OR sentence:foo - facet=true - facet.pivot=media_id,sentence At least the q will make faceting only by those documents containing foo and bar but depending on the size of sentence field you cant get a huge response. Hope it helps. On Wed, Mar 26, 2014 at 11:12 PM, David Larochelle < [email protected]> wrote:I have the following schema <field name="id" type="string" indexed="true" stored="true" required="true" multiValued="false" /> <field name="media_id" type="int" indexed="true" stored="true" required="false" multiValued="false" /> <field name="sentence" type="text_general" indexed="true" stored="true" termVectors="true" termPositions="true" termOffsets="true" /> I'd like to be able to facet by a field and then by queries. i.e. facet_fields": {"media_id": ["1":{ "sentence:foo": 102410, "sentence:bar": 29710}"2": { "sentence:foo": 600, "sentence:bar": 220} "3": { "sentence:foo": 80, "sentence:bar": 2330}]} However, when I try: http://localhost:8983/solr/collection1/select?q=*:*&wt=json&indent=true&facet=true&facet.query=sentence%3A%foo&facet.query=sentence%3Abar&facet.field=media_id the facet counts for the queries and media_id are listed separately rather than hierarchically. I realize that I could use 2 separate requests and programmatically combine the results but would much prefer to use a single Solr request. Is there any way to go this in Solr? Thanks in advance, David
