Join between two indices is possible in elasticsearch

[Amit_Chauhan]

I want to perform join between two indecis in elasticsearch.

[Christian_Dahlqvist]

Elasticsearch does not support joins. If you can describe your data and the type of queries you need to support someone might be able to suggest workarounds though.

[val (Val Crettaz)]

As a possible workaround, you might be interested to check this other discussion and also this article about the new enrich processor available in ES 7.5.

[Hendrik_Muhs]

in addition to the already given answers, I like to mention another possibility: You could "join" 2 indices using transform and create a new index which has the data of both. Scripting give you a lot of flexibility to do this.

2 related posts:

Is is possible to partially update a dest doc with transforms?

Hi, a transform can have multiple sources and they do not need a common schema as long as the field name of the group_by is compatible. So if you have for example a field "customer_id" in both indices "past_purchases" and "predicted_purchases" you can create a transform that joins over both indices: PUT _transform/prediction_accuracy { "source": { "index": ["past_purchases", "predicted_purchases"] }, "pivot": { "group_by": { "id": {"terms": { "field": "customer_id" …

How to aggregate data on elastic sent by logstash

Hi, you should be able to do this using transform (see https://www.elastic.co/guide/en/elasticsearch/reference/7.4/put-transform.html). The workflow would look like this: you index the data into elasticsearch as single docs, this is the "source" index you create a transform that pulls data from the "source" and aggregates it according to your needs into a "dest" index. In your case you would group by entity Id, firm id, etc. and define aggregations, e.g. lastUpdated would be a max aggregatio…

It depends on what you want to do. We do not have the classical database join but we might be able to solve you usecase in a different way.

Maybe you can describe what you want to do?

[Amit_Chauhan]

Thanks to all for your valuable suggestions. yours answer helps a lot to me. Now we are facing another problem..
Can you please let me know if we can integrate the Kibana in our application in such a way that 1 dashboard is accessed by multiple users but each users can see different different dashboard based on their access of data.