From the course: Elasticsearch in Depth
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Using Elastic SQL - Elastic Stack Tutorial
From the course: Elasticsearch in Depth
Using Elastic SQL
- [Instructor] In this section, we are going to use Elastic SQL to query data. Elastic is a document database that stores JSON documents, and it has a Query DSL that actually uses JSON as the primary language of interacting with the database. That being said, SQL is a widely popular declarative language to query databases. Users with SQL experience could leverage Elastic SQL to do many types of queries. Let's get started using a data set of user-generated content for blogs or poetry. We're going to insert two documents. Each has an author, a date, a title, and a package, and we'll let Elastic create the schema dynamically. Now, to search documents, the most common way is to use the Query DSL. We could put together a simple match query looking for some words in the passage, and we could find some matches. Here, we constructed a simple match query that's looking in the passage fields for bowling, dinner, cheer, or award.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.