Practitioner Level

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

Contact Sales See Pricing

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.

Execute CRUD Operations in Elasticsearch

About this Hands-on Lab

Learning Objectives

Additional Resources

What are Hands-on Labs

Newsletter