With Open Distro for Elasticsearch you can query your data using simple SQL queries instead of dozens of lines of JSON code. You continue to get all the benefits of Elasticsearch's full-text search and scoring capabilities without compromising on performance. You still get all of the benefits of Elasticsearch's full-text search and scoring capabilities.
With support for more than 40 functions, data types, and commands including join support and direct export to CSV, Open Distro for Elasticsearch provides the SQL functionality you need to analyze your data.
Translate SQL statements into Elasticsearch JSON queries with a simple _explain call, enabling you to use SQL to create JSON to configure sophisticated access control policies in Security and monitors in Alerting.
Open Distro for Elasticsearch provides a JDBC driver, allowing you to use a wide variety of business intelligence, analytics, and ETL tools to extract and analyze your Elasticsearch data.