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

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.…

Contents