Aggregation Exercise

• Log-in into your ElasticSearch sandbox

• Make sure elastic search is running:

  sudo service elasticsearch restart

• Populate few sample movie data:

  curl https://elasticsearch-courseware.icssolutions.ca/examples/data-sets/movies.txt -o movies.txt
  curl -XPOST 'localhost:9200/_bulk' -H 'content-type: application/json' --data-binary "@movies.txt"

• Confirm there are some records to search on:

  curl 'localhost:9200/movies/movies/_search?pretty=true'

• Let's aggregate on actor name

  curl -XPOST 'localhost:9200/movies/movies/_search?pretty=true' \
  -H 'content-type:application/json' \
  -d '
  {
  "size": 0,
  "aggs": {
    "actor_name": {
      "terms": {
        "field": "Starring.CastCrewName.keyword"
      }
    }
  }
  }'

• What buckets did you get?

• How do I get more than 10 buckets? Check StackOverflow posting!

• What is 'sum_other_doc_count' field?

• Let's find out average movie rating for the actor:

  curl -XPOST 'localhost:9200/movies/movies/_search?pretty=true' \
  -H 'content-type:application/json' \
  -d '
  {
  "size": 0,
  "aggs": {
    "actor_name": {
      "terms": {
        "field": "Starring.CastCrewName.keyword"
      },
      "aggs": {
        "rating": {
          "avg": {
            "field": "StarRating"
          }
        }
      }
    }
  }
  }
  '

• Take a moment to understand the variety of aggregation types

• Pick an aggregation we did not cover in the slides and make it work