[
https://issues.apache.org/jira/browse/SOLR-9419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15425086#comment-15425086
]
Praveen commented on SOLR-9419:
-------------------------------
[~erickerickson]
Thank you for your valuable response. I could able to group by Multivalue field
as per your suggestion. I have already using those logic.
But, I am more curious why it is not supporting by "Solr's Parallel SQL
aggmode=map_reduce".
anyway, as per your response I will post my questions in user's list.
Thank you.
> 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]
