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()));


Watch product tour

Try AutoOps to find & fix Elasticsearch problems

Analyze Your Cluster
Skip to content