Hi All, Could any one help me for a ES query for sum of two nested object fields of a document, for example, "_source": { "Identification": { "PAYL_HDR": { "DUNS_NBR": "212003857", "GEO_REF_ID": "1067", "GSRL_DT": "2017-08-22T15:24:46.000000", "INFO_SRC_CD": 20008, "REC_TYP_CD": 11592 } …

If it works with keyword, it means the field is most likely defined as a keyword in the mapping. You must check your mapping and consider updating these fields to integer or long as you wanted to sum these 2 fields. https://www.elastic.co/guide/en/elasticsearch/reference/current/number.html

Discuss the Elastic Stack

Query for sum of two nested object fields of a document

Elastic Stack Elasticsearch

dadoonet (David Pilato) April 12, 2018, 7:42am 2

See the same topic you already opened:

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.