I want to query an elastic index across different clusters in different data centers . I need to query it to generate a consolidated report. I have some questions
1] Will cardinality and nested aggregations give accurate results across different clusters for different DCs ?
2] How good is the perfomance of a cross cluster search with minimum round trips against a single cluster search ?
3] How is Cross Cluster Replication then a Search Versus Cross Cluster Search?
Any other suggestions are welcome .