Combining results from two indices

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?

No, it's not.

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