GROUP BY ALL is not 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 ” GROUP BY ALL is not 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 “GROUP BY ALL is not supported”classname  is We extracted the following from Elasticsearch source code for those seeking an in-depth context :

GroupByContext groupByCtx = ctx.groupBy();
 if (groupByCtx != null) {
 SetQuantifierContext setQualifierContext = groupByCtx.setQuantifier();
 TerminalNode groupByAll = setQualifierContext == null ? null : setQualifierContext.ALL();
 if (groupByAll != null) {
 throw new ParsingException(source(groupByAll); "GROUP BY ALL is not supported");
 List groupingElement = groupByCtx.groupingElement();
 List groupBy = expressions(groupingElement);
 ParserRuleContext endSource = groupingElement.isEmpty() ? groupByCtx : groupingElement.get(groupingElement.size() - 1);
 query = new Aggregate(source(ctx.GROUP(); endSource); query; groupBy; selectTarget);


Watch product tour

Try AutoOps to find & fix Elasticsearch problems

Analyze Your Cluster
Skip to content