Hi Joel Bernstein, Thanks for the update .If you guys get chance to provide that feature soon, it will be more benefit to the solr users.
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 5:30 PM, Joel Bernstein <joels...@gmail.com> wrote: > Parallel SQL only supports the following functions currently: (SUM, AVG, > MIN, MAX, COUNT). > > More functions and compound functions are on the roadmap. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Thu, Sep 8, 2016 at 12:11 AM, Praveen Babu <subramani....@gmail.com> > wrote: > > > Hi All, > > > > I am also new to Solr and I have gone through Solr document and tested > agg > > using Solr- Prasto ( Parallel sql), Stream. > > > > I am getting very good response using these 2 technologies. But my > worries > > are, unable to Group By Multivalue field which Solr standard api does but > > not latest version of solr-prasto/Stream. > > > > I want to aggregate/Group by "app.name" field using stream/ Parallel > sql. > > Please suggest. > > > > 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? > > > > > > > > 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 6:01 AM, Roshni Rajagopal <roshkne...@gmail.com> > > wrote: > > > > > Hi Solr Gurus, > > > > > > I have these requirements > > > > > > 1. Need to group data in solr on multiple fields and compute > agregations > > > like SUM (field) > > > > > > 2. Need to compute some custom calculations - sum(field1)/sum(field2) > on > > > the grouped data. > > > > > > Options Ive tried > > > > > > 1. Group- this does not allow to group by more than 1 field, and > > > aggregations are not supported > > > > > > 2. Stats - this along with facet.pivot gets results for basic group > > > aggregations like SUM. Custom Calculation is not supported. Also the > > format > > > is messy with stats getting calculated at every level. Cannot paginate. > > > > > > 2. Facet JSON API -gets results for basic group aggregations like SUM. > > > Format is less messy and we can paginate. Custom Calculation like > > > DIV(sum(field1), sum(field2)) is still not supported. > > > > > > So the last resort is /sql handler for parallel queries. Is tested and > > > stable, and will it meet my requirements? Im on solr 6.10. > > > > > > Or would you recommend adding Spark…I would prefer to handle all > > > requirements in solr, as I dont want to maintain another moving part of > > > Spark. > > > > > > Do advise! > > > > > > Regards > > > > > > Roshni > > > > > >
