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?