SOLR distinct query

Question

i have to select distinct values from a specific field in solr using Java. I have applied

        SolrQuery solrQuery = new SolrQuery();
        solrQuery.add("q", "*:*");
        solrQuery.setParam("fl", "field_name");
        solrQuery.add("facet", "on");
        solrQuery.add("facet.field_name", "field_name");

And i have tried very diffrent methods but still don't work.

Possible duplicate of [Faceting using SolrJ and Solr4](https://stackoverflow.com/questions/14485031/faceting-using-solrj-and-solr4) — MatsLindh, Mar 12 '18 at 08:22

score 1 · Answer 1 · answered Mar 12 '18 at 13:03

1

"facet.field_name" has to be "facet.field". A little less error prone is

query.setFacet(true);
query.addFacetField("field_name");

answered Mar 12 '18 at 13:03

Holger Thurow

764
4
12

for ngram fields it is returning all the substrings, how to get unique values in that case? – Abhishek Nov 26 '18 at 11:56

score 0 · Answer 2 · answered Mar 12 '18 at 14:44

SolrJ has convinient methods to achieve this.

solrQuery.setQuery("your query field","value");
solrQuery.setFacet(true);
solrQuery.addFacetField("your specific field for distincts");
solrQuery.setRows(0);

Once you hit the server with this request, you can get the unique field values as a List of FacetField objects from the QueryResponse object.

I have set solrQuery.setRows(0); to avoid query responses and make it more efficient. This doesn't affect the facet results.

SOLR distinct query

2 Answers2