Professional Level

Searching with Term-Level Queries in Elasticsearch 7.13

1 hour

3 Learning Objectives

About this Hands-on Lab

Elasticsearch offers a variety of different search functions that can be used to perform term-level, non-analyzed searching. In this hands-on lab, you will get to leverage several different term-level search functions in order to ask the data some questions.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Craft a Query That Answers the Question: Who Was the Customer That Placed Order ID 725676?: From the Kibana console, craft a term-level query on the ecommerce dataset that answers the question.
Craft a Query That Answers the Question: From What Cities Did Samir Garza, Selena Gibbs, and Tariq Duncan Place Orders?: From the Kibana console, craft a term-level query on the ecommerce dataset that answers the question.
Craft a Query That Answers the Question: What Orders Were Placed with a Total Taxed Price of 10 to 20 Euro?: From the Kibana console, craft a term-level query on the ecommerce dataset that answers the question.

Contact Sales See Pricing

Additional Resources

Logging In to the Elastic Environment

Open a new browser tab and navigate to the public IP address of the es1 node provided on the lab page (e.g., http://public_ip).
Log in using the username elastic and password elastic_acg.

Lab Scenario

You work as a data analyst for a large online clothing site. There have been a number of orders with reported issues by customers which need to be looked into. For this, the customer service department has asked you to answer the following questions from the ecommerce dataset so they can troubleshoot and follow up accordingly:

Who was the customer that placed order ID 725676?
From what cities did Samir Garza, Selena Gibbs, and Tariq Duncan place orders?
What orders were placed with a total taxed price of 10 to 20 euro?

Your es1 node has a Kibana instance which can be accessed in your local web browser by navigating to the public IP address of the es1 node (example: http://public_ip). To log in, use the elastic user with the password elastic_acg.

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.