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 > >> >
