Saturday , April 27 2024

Search a Keyword in Elasticsearch using Kibana

We mentioned that Elasticsearch is a search engine in the article “What is Elasticsearch“. Searching for a keyword in Elasticsearch is very fast. In this article we will talk about the search types in elasticsearch. You may want to read the following articles before reading this article.

What is Kibana“,

How To Install Elasticsearch On Centos“,

How To Install Kibana On Centos

We’re connecting to Kibana for keyword search and we click on Discover and Relative from Time Range as you see in the screenshot below. If the data you export to elasticsearch has a date column, you will see a screen as follows.

In the following screenshot, we indicate that we will search within the last 15 minutes.

If you click Quick from Time Range, the following options are available.

If you click Absolute from Time Range, you can select the time interval you want to search for from a calendar.

Then, type the keyword you want to search in the marked field in the following screenshot, and press enter. The found keywords will be listed in yellow as below.

Search Types

Search for a keyword in all data

If you type the keyword you’re looking for in the search section, it searches for the relevant keyword in all data.

Search for a keyword in a specific column

If you type column_name: keyword in the search section, it will search only the related keyword in the corresponding column.

Example:

Search With AND && OR Operators

You can use AND and OR operators as follows.

LIKE Usage

You must type the keyword you want to search between two asterisks.

You can also search in a specific column in the following way.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories