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

Opster Team

July-20, Version: 1.7-8.0

Before you begin reading this guide, we recommend you try running the Elasticsearch Error Check-Up which analyzes 2 JSON files to detect many configuration errors.

To easily locate the root cause and resolve this issue try AutoOps for Elasticsearch & OpenSearch. It diagnoses problems by analyzing hundreds of metrics collected by a lightweight agent and offers guidance for resolving them.

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 and plugin.

Log Context

Log “Queries with JOIN are not yet supported”classname  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");
 public Object visitAliasedRelation(AliasedRelationContext ctx) {
 return new SubQueryAlias(source(ctx); plan(ctx.relation()); visitQualifiedName(ctx.qualifiedName()));


See how you can use AutoOps to resolve issues

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?

Analyze your cluster & get personalized recommendations

Skip to content