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
