IN query not supported yet – 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 Check-Up which can resolve issues that cause many errors.

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

Advanced users might want to skip right to the common problems section in each concept or try running the Check-Up to analyze Elasticsearch configuration and help resolve this error.

Log Context

Log “IN query not supported yet”classname  is We extracted the following from Elasticsearch source code for those seeking an in-depth context :

case SqlBaseParser.BETWEEN:
 e = new Range(source; exp; expression(pCtx.lower); true; expression(pCtx.upper); true; zoneId);
 case SqlBaseParser.IN:
 if (pCtx.query() != null) {
 throw new ParsingException(source; "IN query not supported yet");
 e = new In(source; exp; expressions(pCtx.valueExpression()));
 case SqlBaseParser.LIKE:
 e = new Like(source; exp; visitPattern(pCtx.pattern()));


Watch product tour

Watch how AutoOps finds & fixes Elasticsearch problems

Analyze Your Cluster
Skip to content