Hi Joel, Thanks for responding. For full fledged data analytics powered by solr, group by and aggregations are needed. The basic aggregations are available- but we often have calculated fields like the one I mentioned sum (a)/sum(b). It will be cool to have these in solr. Such calculations cannot be perisisted in raw data because it depends on the filters and first set of aggregations of sum
1. When do you think this support may be available..in 6.x..? 2. As of today what are my options, if I still want to use solr- would using Spark or Zeppelin over Solr help me with this custom calculation? Or perhaps I can use java to retrieve the grouped sums from Solr API and then do the custom calculation on the fly. That may slow it down. Which approach would you recommend. 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/ -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Grouping-Aggregations-and-Custom-Functions-tp4295093p4295181.html Sent from the Solr - User mailing list archive at Nabble.com.
