Execute CRUD Operations in Elasticsearch

1.5 hours
  • 3 Learning Objectives

About this Hands-on Lab

No matter how you intend to use Elasticsearch, understanding how to quickly perform CRUD operations on documents in Elasticsearch is essential. In this hands-on lab, you will be creating, reading, updating, and deleting documents in Elasticsearch.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create account 1000.

Use the Kibana console tool to execute the following:

PUT bank/_doc/1000
  "account_number": 1000,
  "balance": 65536,
  "firstname": "John",
  "lastname": "Doe",
  "age": 23,
  "gender": "M",
  "address": "45 West 27th Street",
  "employer": "Elastic",
  "email": "john@elastic.com",
  "city": "New York",
  "state": "NY"
Update the address for account 100.

Use the Kibana console tool to execute the following:

POST bank/_update/100/
  "doc": {
    "address": "1600 Pennsylvania Ave NW",
    "city": "Washington",
    "state": "DC"
Delete accounts 1 and 10.

Use the Kibana console tool to execute the following:

DELETE bank/_doc/1
DELETE bank/_doc/10

Additional Resources

You work as an Elasticsearch administrator for a banking company. A recent failed deployment and subsequent rollback of your banking software has desynchronized some actions that were taken against a few accounts. To quickly rectify the desynchronization, you are being asked to perform manual CRUD operations to the bank index in Elasticsearch using the Kibana console tool.

An account needs to be added with the following customer data:

  • Account Number: 1000
  • Balance: $65,536
  • Firstname: John
  • Lastname: Doe
  • Age: 23
  • Gender: Male
  • Address: 45 West 27th Street
  • Employer: Elastic
  • Email: john@elastic.com
  • City: New York
  • State: NY

Account 100 has changed addresses and needs the following fields updated:

  • Address: 1600 Pennsylvania Ave NW
  • City: Washington
  • State: DC

Accounts 1 and 10 have been closed by their previous owners and need to be deleted.

NOTE: The document IDs and account numbers of each document in the bank index are the same.

Your master-1 node has an Kibana instance which can be accessed in your local web browser by navigating to the public IP address of the master-1 node over port 8080 (example: http://public_ip:8080). To log in, use the elastic user with the password elastic_566.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?