PIVOT currently supports only one aggregation; found – Elasticsearch Error How To Solve Related Issues



PIVOT currently supports only one aggregation; found – Elasticsearch Error How To Solve Related Issues

Updated: July-20

Elasticsearch Version: 1.7-8.0

Before you begin reading this guide, we recommend you try running the Elasticsearch Error Check-Up  which can resolve issues causing many errors 

 

This guide will help you check for common problems that cause the log “PIVOT currently supports only one aggregation; found” 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, 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 (free tool that requires no installation). 

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 [{}]";
  values.size());
  }
  plan = new Pivot(source(pivotClause); plan; column; namedValues(pivotClause.vals); namedValues(pivotClause.aggs));
  }
  return plan;

Related issues to this log

We have gathered selected Q&A from the community and issues from Github, that can help fix related issues please review the following for further information :

1 hierarchical faceting with Elasticsearch -views 4,165 ,score 8

Migrate BI from SSAS Olap to the free ElasticSearch -views   71



Find Configuration Errors

Analyze Now