How to select distinct field values using Solr?

by

Faceting would get you a results set that contains distinct values for a field.

E.g. 

http://localhost:8983/solr/select/?q=*%3A*&rows=0&facet=on&facet.field=txt

You should get something back like this:

<response>
<responseHeader><status>0</status><QTime>2</QTime></responseHeader>
<result numFound="4" start="0"/>
<lst name="facet_counts">
 <lst name="facet_queries"/>
 <lst name="facet_fields">
  <lst name="txt">
        <int name="value">100</int>
        <int name="value1">80</int>
        <int name="value2">5</int>
        <int name="value3">2</int>
        <int name="value4">1</int>
  </lst>
 </lst>
</lst>
</response>

Check out the wiki for more information. Faceting is a really cool part of solr. Enjoy 🙂

http://wiki.apache.org/solr/SimpleFacetParameters#Facet_Fields

Note: Faceting will show the indexed value, I.e. after all the filters have been applied. One way to get around this is to use the copyfield method, so that you can create a facet version of the txt field. THis way your results will show the original value.

Hope that helps.. Lots of documentation on faceting available on the wiki. Or I did write some with screen shots.. which you can check out here:

http://www.craftyfella.com/2010/01/faceting-and-multifaceting-syntax-in.html

More Related Contents:

  1. Why does Future::select choose the future with a longer sleep period first?
  2. How to use ng-class in select with ng-options
  3. Select parent element of known element in Selenium
  4. How does select work when multiple channels are involved?
  5. Select One Element in Each Row of a Numpy Array by Column Indices [duplicate]
  6. MySQL Select all columns from one table and some from another table
  7. Blazor: How to use the onchange event in when using @bind also?
  8. Does a break statement break from a switch/select?
  9. Recreating a query using INNER JOIN? [duplicate]
  10. The order of a SQL Select statement without Order By clause
  11. MySQL Query – Records between Today and Last 30 Days
  12. Ordering by specific field value first
  13. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  14. How to get records randomly from the oracle database?
  15. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  16. How to get values from IGrouping
  17. using OR and NOT in solr query
  18. ruby on rails f.select options with custom attributes
  19. How to select only the first rows for each unique value of a column?
  20. How to get selected value of a dropdown menu in ReactJS
  21. Selecting text on focus using jQuery not working in Safari and Chrome
  22. How to select records without duplicate on just one field in SQL?
  23. Right click to select a row in a Datagridview and show a menu to delete it
  24. MySQL Error: #1142 – SELECT command denied to user
  25. *nix select and exceptfds/errorfds semantics
  26. Setup sunspot solr with rails in production environment
  27. Select all columns after JOIN in LINQ
  28. How to query SOLR for empty fields?
  29. SQL: Two select statements in one query
  30. Unselect what was selected in an input with .select()

Leave a Comment