We only support AVG; MEDIAN and SUM on number based fields – How to solve this Elasticsearch error

Average Read Time

2 Mins

We only support AVG; MEDIAN and SUM on number based fields – 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 ” we only support AVG; MEDIAN and SUM on number based fields ” to appear. To understand the issues related to this log, read the explanation below about the following Elasticsearch concepts: sort and search.

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 “we only support AVG; MEDIAN and SUM on number based fields”classname  is FieldSortBuilder.java We extracted the following from Elasticsearch source code for those seeking an in-depth context :

boolean reverse = order == SortOrder.DESC;
 IndexFieldData fieldData = context.getForField(fieldType);
 if (fieldData instanceof IndexNumericFieldData == false
 && (sortMode == SortMode.SUM || sortMode == SortMode.AVG || sortMode == SortMode.MEDIAN)) {
 throw new QueryShardException(context; "we only support AVG; MEDIAN and SUM on number based fields");
 }
 final SortField field;
 if (numericType != null) {
 if (fieldData instanceof IndexNumericFieldData == false) {
 throw new QueryShardException(context;

 

Watch a demo of the Check-Up:

Analyze your cluster

Skip to content