It's the same problem. The "GROUP BY" has to sort the returned rows in order to partition the result docs (and thus do aggregations by group). We kind of skipped explaining that ;)....
Best, Erick On Thu, Sep 8, 2016 at 10:08 AM, Praveen Babu <subramani....@gmail.com> wrote: > Hi Erik/Joel, > > I am not sure , did I confused you guys. > I was talking about "GROUP BY" on multivalued field .Not sorting > > Example : I have 1 TB data , I want to agg a multiValued field using stream > api. > aggmode=map_reduce > > Regards, > S.Praveen > Technical Architech > LinkedIn: > https://www.linkedin.com/in/praveen-babu-73232889?trk=nav_responsive_tab_profile > > > > > On Thu, Sep 8, 2016 at 8:35 PM, Erick Erickson <erickerick...@gmail.com> > wrote: > >> 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 >> >> >>
