Open Distro allows users to interact with an ES cluster with SQL and to perform operations for which you would normally have to use the Elasticsearch domain-specific language (DSL). This feature was initially based on the elasticsearch-sql plugin, which is now being gradually phased out or deprecated.
In this tutorial, our focus is on how to query Elasticsearch data using SQL with the help of this open-source tool. We are going to cover:
TOC covered
- Installation and getting started with Open Distro
- Using the REST API to ingest data into our ES cluster
- SQL with Elasticsearch
- Endpoints and operations
- Features and supported protocols
- Exploring additional plugin settings and options
Note: Check the queries directory for all te queries and results used for the different SQL statements, functions, conditions etc