Elasticsearch’s searching capabilities extend far beyond simple text searches. Elasticsearch is a powerful analytics engine that can perform complex aggregations, including nested and pipelined aggregations. Using aggregations in Elasticsearch, you can begin to unlock the full potential of Elasticsearch’s analytics capabilities. In this hands-on lab, you will answer series of questions using bucket, metric, and pipeline aggregations.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Create an aggregation to answer question 1.
Use the Kibana console tool to execute the following:
GET bank/_search { "size": 0, "aggs": { "employers": { "cardinality": { "field": "employer.keyword" } } } }- Create an aggregation to answer question 2.
Use the Kibana console tool to execute the following:
GET bank/_search { "size": 0, "aggs": { "state": { "terms": { "field": "state.keyword", "size": 50 } } } }- Create an aggregation to answer question 3.
Use the Kibana console tool to execute the following:
GET bank/_search { "size": 0, "aggs": { "state": { "terms": { "field": "state.keyword", "size": 50 }, "aggs": { "balance": { "avg": { "field": "balance" } } } }, "max_average_balance": { "max_bucket": { "buckets_path": "state>balance" } } } }
