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.
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.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.