[
https://issues.apache.org/jira/browse/SOLR-9419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Erick Erickson resolved SOLR-9419.
----------------------------------
Resolution: Invalid
Please raise issues like this on the user's list first, and if it's a confirmed
code issue _then_ raise a JIRA.
Multivalued fields only sort in special circumstances, and then only on min/max
for numerics and then only on Solr 5.3+. See:
https://lucidworks.com/blog/2015/09/10/minmax-on-multivalued-field/
I'd strongly recommend you try getting the basic query to work outside of
aggregation so you get the syntax right then try the aggregation route. If you
still have problems, please ping the user's list.
> Unable to sort "multivalued field" while choosing aggregationMode=map_reduce
> -----------------------------------------------------------------------------
>
> Key: SOLR-9419
> URL: https://issues.apache.org/jira/browse/SOLR-9419
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Reporter: Praveen
>
> I have a input json like below
> { id:1,pid:73,name:praveen,inf:[1,2,3,4,5,6,7]}
> { id:2,pid:73,name:praveen,inf:[1,2,3,4,5,6,7]}
> { id:3,pid:73,name:praveen,inf:[1,2,3,4,5,6,7]}
> { id:4,pid:83,name:praveen,inf:[1,2,3,4,5,6,7]}
> { id:5,pid:83,name:praveen,inf:[1,2,3,4,5,6,7]}
> { id:6,pid:83,name:praveen,inf:[1,2,3,4,5,6,7]}
> curl --data-urlencode "stmt=select pid,infs,count(*) as count from
> collection where pid=73 GROUP BY pid,infs ORDER BY count(*) desc "
> http://localhost:8983/solr/collection/sql?aggregationMode=map_reduce
> Exception :
> {"result-set":{"docs":[
> {"EXCEPTION":"java.util.concurrent.ExecutionException: java.io.IOException:
> --> http://localhost:8983/solr/collection_shard2_replica1/:can not sort on
> multivalued field: infs","EOF":true,"RESPONSE_TIME":19}]}}
> Could you please on this. How to execute this query using
> aggregationMode=map_reduce?
> infs field is multivalue .. Please help me to sort multivalue field.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
