question Solr - avoid 'multi-valued field can't be sorted' issue? in Archives of Support Questions (Read Only)

Solr - avoid 'multi-valued field can't be sorted' issue?

andrewg — Thu, 01 Oct 2015 20:46:09 GMT

Hi All,

The use case is a Banana dashboard working with a SolrCloud instance/cluster. If we follow default steps we end up using the 'data_driven_schema' in Solr, which makes it easy for it to accept any random data and try index it.

However, the problem is down the line. Banana table widget can't sort on many columns as Solr complains about those fields being multi-valued. In fact, they are not, and unique (checked via admin section), but rather declared multi-valued.

What is the approach to address this? Ideally, without having to specify a complete new schema for a Solr index. Can one have a benefit of flexible fields, but default to non-multi-valued maybe?

Re: Solr - avoid 'multi-valued field can't be sorted' issue?

nsabharwal — Sat, 05 Dec 2015 05:02:35 GMT

@Guilherme Braccialli

Re: Solr - avoid 'multi-valued field can't be sorted' issue?

gbraccialli3 — Mon, 19 Aug 2019 13:00:14 GMT

@Andrew Grande are you using field name suffix?

I'm running @Ali Bajwa twitter demo in Solr Cloud mode (hdp search 2.3.2 default rpm), using data_drive_schema and it seems to be working. Please see image below, only "tag_ss" field is multi-valued, other fields are not. I can sort on all the fields except tag_ss.

Can you give some more details about your issue?

Re: Solr - avoid 'multi-valued field can't be sorted' issue?

aervits — Wed, 03 Feb 2016 10:19:48 GMT

@Andrew Grande pinging to close this 🙂