Queries with JOIN are not yet supported – How to solve this Elasticsearch exception

Opster Team

August-23, Version: 6.8-8.9

Briefly, this error occurs when you attempt to perform a JOIN operation in Elasticsearch, which is not supported. Elasticsearch is a NoSQL database and does not support relational database operations like JOIN. To resolve this issue, you can denormalize your data before indexing it into Elasticsearch. Alternatively, you can use the “nested” or “parent-child” relationships feature of Elasticsearch to simulate JOIN-like behavior. However, these methods have their own limitations and should be used judiciously.

This guide will help you check for common problems that cause the log ” Queries with JOIN are not yet supported ” to appear. To understand the issues related to this log, read the explanation below about the following Elasticsearch concepts: parser, plugin.

Log Context

Log “Queries with JOIN are not yet supported” class name is LogicalPlanBuilder.java. We extracted the following from Elasticsearch source code for those seeking an in-depth context :

 throw new UnsupportedOperationException();
 // We would return this if we actually supported JOINs; but we don't yet.
 // new Join(source(ctx); left; plan(ctx.right); type; condition);
 throw new ParsingException(source(ctx); "Queries with JOIN are not yet supported");
 }  @Override
 public Object visitAliasedRelation(AliasedRelationContext ctx) {
 return new SubQueryAlias(source(ctx); plan(ctx.relation()); visitQualifiedName(ctx.qualifiedName()));


How helpful was this guide?

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?