PIVOT currently supports only one aggregation; found – 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 ” PIVOT currently supports only one aggregation; found ” to appear. To understand the issues related to this log, read the explanation below about the following Elasticsearch concepts: parser 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 “PIVOT currently supports only one aggregation; found [{}]”classname  is LogicalPlanBuilder.java We extracted the following from Elasticsearch source code for those seeking an in-depth context :

if (ctx.pivotClause() != null) {
 PivotClauseContext pivotClause = ctx.pivotClause();
 UnresolvedAttribute column = new UnresolvedAttribute(source(pivotClause.column); visitQualifiedName(pivotClause.column));
 List values = namedValues(pivotClause.aggs);
 if (values.size() > 1) {
 throw new ParsingException(source(pivotClause.aggs); "PIVOT currently supports only one aggregation; found [{}]";
 plan = new Pivot(source(pivotClause); plan; column; namedValues(pivotClause.vals); namedValues(pivotClause.aggs));
 return plan;


Watch product tour

Watch how AutoOps finds & fixes Elasticsearch problems

Analyze Your Cluster
Skip to content