Advanced Elasticsearch 7.0

children

The purpose of this is to aggregate the child documents with the join data type field:

• Example: The purpose is to obtain the total amount of dividend for each symbol in the cf_etf_dividend_join index:

 "aggs": { "dividends_for_symbol": { "terms": {"field": "symbol"}, "aggs": {"dividend":{ "children": {"type": "dividend" }, "aggs": {"total_dividend":{"sum":{"field":"amount"}}}}}} }

• Resulting buckets: Since we have only one symbol ACWF, the result will show the total dividend of it:

"aggregations": {     "dividends_for_symbol": {         "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0,         "buckets": [ {             "key": "ACWF",             "doc_count": 1,             "dividend": {                 "doc_count": 7,                 "total_dividend": {                     "value": 1.6313300058245659                  } } } ] } }