Join clause in ES, what's the alternatives

Hi everyone,

I have two types in my index;
Type1 contain two fields: developer—name & project—name
Type2 contain two fields: developer—name & team—name

What I want is to have the team—name field related to the first type with the developer associated to it.
I noticed that the join relation is not an option in ES.

Could some one help me out with this?


In Elasticsearch it's common to denormalize data, basically making one big flat "table" , then you can write the above as a simple query/aggregation.

Elastic is not a relational detabase, and the data model you' re describing is something that works in an SQL database, but not so much in elastic.

There is some (limited) possibilites for relations in elastic (parent/child , nested docs , terms lookup) but i think denormalizing is probably most suitable to what you describe above.

1 Like

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