Combining results from two indices

Elastic Stack Kibana
1

I have two indices (1) CompanyOrders, (2) CompanyType

For some reason they were stored separately and CompanyOrders contains millions of results.

I need to create a visualisation in Kibana which can aggregate and split CompanyOrders data using CompanyType.

I know its better to have been able to denormalize and put CompanyType inside CompanyOrders, but unfortunately its not the current situation. Also I know we cannot join indices in ElasticSearch, so I am looking to see what is the bet possibility.

I am thinking that it should be possible to create a scripted field in CompanyOrders which can reference CompanyType field, and thus can be used in aggregation?

Is this possible?

2

No, it's not.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.