Is there a limit on number of fields on which we can aggregate? I could not find any specific info on this. I could find details on # of buckets for a given field, but not for the number of fields itself.
Currently I have only 10-15 fields, but can it go above, say, 200? Would that have a huge impact on performance of overall query?
We haven't upgraded to 8.x yet. Our system fetches related data from multiple sources and each source may have few additional fields on which users want to see aggregation. Each time we add a new source, # of aggregation fields goes up by 5 or so. Thats the reason I was checking this. It's only term count/bucket aggregation, we don't have any metrics/calculations on those.
Number of records would be roughly 5million on which the aggregation has to be done.