The basic problem is "what does sorting on a multi-valued field mean"? If you have a numeric field with values 1, 5, 7 how should sorting rank that doc? Use 1? 7? the average? Median? Sum?....
There is some limited ability in the rest of Solr to sort by min/max but that's it. Best, Erick On Thu, Sep 8, 2016 at 4:57 AM, Joel Bernstein <joels...@gmail.com> wrote: > Yes, sorting on multi-valued value fields isn't supported with Streaming > Expressions. > > Multi-value fields can be exported but not used for sorting. > > There currently isn't a plan to add sorting on multi-value fields, but if > other areas in Solr are supporting this perhaps we could use the same > technique. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Thu, Sep 8, 2016 at 2:24 AM, Praveen Babu <subramani....@gmail.com> > wrote: > >> Hi , >> >> >> Does parallel sql support Multi valued field? >> >> I am unable to group by on Multi valued field when I choose >> >> /sql?aggregationMode=map_reduce >> >> "can not sort on multivalued field" >> >> >> >> input: >> >> { >> >> id: 1 >> >> field1:[1,2,3], >> >> app.name:[watsapp,facebook,... ] >> >> } >> >> { >> >> id: 2 >> >> field1:[1,2,3], >> >> app.name:[watsapp,facebook,... ] >> >> } >> >> >> >> Expected result : >> >> watsapp: 2 >> >> facebook : 2 >> >> >> I have 2 TB data . I wanted to execute in aggmode=map_reduce. Any >> suggestion? >> >> >> >> Need your valuable suggestion. >> >> >> >> Regards, >> S.Praveen >> Technical Architech >> LinkedIn: >> https://www.linkedin.com/in/praveen-babu-73232889?trk=nav_ >> responsive_tab_profile >>
