Join two json in elastic search

Elastic Stack Elasticsearch
1

I have a specific requirement where two json files are in elastic and having a common attribute called "code_type". Like in table we do inner join " where a.code_type=b.code_type" is there any way we can achieve that in elastic search and view data in Kibana?

We are using elastic from AWS service and the version present there is 6.0

2

You can't do joins in elasticsearch.

We are using elastic from AWS service and the version present there is 6.0

Did you look at cloud.elastic.co or AWS Marketplace: Elastic Cloud (Elasticsearch Service) ?