IN query not supported yet – Elasticsearch Error How To Solve Related Issues

IN query not supported yet – Elasticsearch Error How To Solve Related Issues

Opster Team

July-20, Version: 1.7-8.0


Before you read this guide, we recommend you run the Elasticsearch Error Check-Up which detects issues in ES causing log errors (free tool that requires no installation). 

This guide will help you check for common problems that cause the log “IN query not supported yet” to appear. It’s important to understand the issues related to the log, so to get started, read the general overview on common issues and tips related to the Elasticsearch concepts: parser, query, plugin.

Advanced users might want to skip right to the common problems section in each concept or try running the Check-Up which analyses ES to discover the cause of many errors and provides suitable actionable recommendations how to resolve them (join over 700 users who use this free tool).

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


Optimize Elasticsearch Performance

Try The Tool