2

I know multivalued field sorting is not supported in Solr . But Is there any way we can sort multivalued field in Solr. I have two documents with field custom_code and values are as below,

Doc 1 : 11, 78, 45, 22

Doc 2 : 56, 74, 62, 10

When I sort it in ascending order the order should be ,

Doc 2 : 56, 74, 62, 10

Doc 1 : 11, 78, 45, 22

Here Doc 2 will come first because it has smallest element 10 (which is greater that 11 of doc 1).

How can we achieve this in Solr. What is the easiest way?

Abhijit Bashetti
  • 8,518
  • 7
  • 35
  • 47
NutchUser
  • 173
  • 2
  • 9
  • There's no way to sort on multi-valued fields in Solr. please refer http://stackoverflow.com/questions/20806935/in-solr-can-i-sort-on-the-matching-value-from-a-multi-valued-field http://stackoverflow.com/questions/8492251/is-there-any-workaround-for-sorting-on-multivalued-field – Abhijit Bashetti May 12 '15 at 06:57

3 Answers3

2

Create a copyfield to copy the content of multivalued data into a sorted concatenated single value without commas and use it for sorting.

For Ex :

Doc 1 :

multiValuedData : 11, 78, 45, 22

sortedConcatenatedSingleValue : 11224578

Doc 2 :

multiValuedData : 56, 74, 62, 10

sortedConcatenatedSingleValue : 10566274

If you cannot create this singlvalue field at the time of generating the data from source then you can use a script transformer (https://wiki.apache.org/solr/DataImportHandler#ScriptTransformer) during the index time to create this sortedConcatenatedSingleValue field using a javascript function.

Prabhu Velayutham
  • 411
  • 3
  • 8
1

if this issue was implemented you could just use that, as in the description of the ticket. But it is not as of yet.

So, one other thing you can do is to index an additional field min_code, non multivalued and put the minimum value of custom_code in there. You can do that in the client side or in Solr in a UpdateRequestProcessor. Then you just sort on min_code

Persimmonium
  • 15,593
  • 11
  • 47
  • 78
  • I need to decide on approach where min value is same in both documents then in that case I need to compare immediate next higher value. I am planning to store all values as single sorted string format in seperate field and while sorting I will use this sorted string field to sort. – NutchUser May 13 '15 at 05:24
1

You can get out of box in 5.3 - https://issues.apache.org/jira/browse/SOLR-2522

A good description is here - https://lucidworks.com/blog/2015/09/10/minmax-on-multivalued-field/

Ravi
  • 92
  • 3