[jira] [Commented] (SOLR-9419) Unable to sort "multivalued field" while choosing aggregationMode=map_reduce

["Praveen (JIRA)" <ji...@apache.org>]

    [ 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org