Get list of all distinct values in multivalued field in Solr

Question

I have data in Solr that is being imported from a postgres database. The docs look something like this (much simplified):

"docs": [
      {
        "id": "1",
        "strings_ss": [
          "abc",
          "bcd",
          "efg",
        ],
        "_version_": 1546754105942212600
      },
      {
        "id": "2",
        "strings_ss": [
          "abc",
          "hig",
        ],
        "_version_": 1546754105942212600
      },
      {
        "id": "3",
        "strings_ss": [
          "bcd",
          "aaa",
        ],
        "_version_": 1546754105942212600
      }
   ]

I would like like to get a list of unique values in strings_ss

"abc","bcd","efg","hig","aaa"

With a single value field, I'm using grouping. But, that fails for multi valued fields with the error: can not use FieldCache on multivalued field:

What is the best way to get this list from Solr?

score 1 · Accepted Answer · answered Sep 29 '16 at 04:39

You can use solr facet query to get the unique values for the field. It will give you, unique values of the field and frequency (no of documents have that unique value). For more information, please check the links below,

score 1 · Answer 2 · answered Sep 29 '16 at 05:11

1

Try this

http://localhost:8983/solr/core/select?q=*&facet=true&facet.field=strings_ss

answered Sep 29 '16 at 05:11

Sanjay Dutt

2,192
16
16

score 1 · Answer 3 · answered Sep 29 '16 at 16:14

1

Another option in addition to faceting is to use the LukeRequestHandler like this:

http://localhost:8983/solr/core/admin/luke?wt=json&fl=strings_ss&numTerms=....

and read topTerms property

answered Sep 29 '16 at 16:14

Zac

2,180
2
23
36

Get list of all distinct values in multivalued field in Solr

3 Answers3