Joining queries

Performing full SQL-style joins in a distributed system like Elasticsearch is prohibitively expensive. Instead, Elasticsearch offers two forms of join which are designed to scale horizontally.

nested query
Documents may contains fields of type nested. These fields are used to index arrays of objects, where each object can be queried (with the nested query) as an independent document.
has_child and has_parent queries
A parent-child relationship can exist between two document types within a single index. The has_child query returns parent documents whose child documents match the specified query, while the has_parent query returns child documents whose parent document matches the specified query.

Nested Query

See Nested Query

QueryBuilder qb = nestedQuery(
        "obj1",               
        boolQuery()           
                .must(matchQuery("obj1.name", "blue"))
                .must(rangeQuery("obj1.count").gt(5))
    )
    .scoreMode("avg");        

path to nested document

your query. Any fields referenced inside the query must use the complete path (fully qualified).

score mode could be max, total, avg (default) or none

Has Child Query

See Has Child Query

QueryBuilder qb = hasChildQuery(
    "blog_tag",                     
    termQuery("tag","something")    
);

child type to query against

query

Has Parent Query

See Has Parent

QueryBuilder qb = hasParentQuery(
    "blog",                         
    termQuery("tag","something")    
);

parent type to query against

query