Overview

The support feature for SQL was delivered with version 6.3. This was due to the popularity of SQL, while many Elasticsearch users were familiar with SQL syntax and the ability to perform SQL-like queries on indexed data had been a longstanding desire. Elasticsearch SQL is an X-Pack component, where X-Pack is an Elastic Stack extension that provides many features, including monitoring, security, and machine learning. In the default installation, Elasticsearch comes with X-Pack. You will recall from the Mapping concepts across SQL and Elasticsearch section of Chapter 1, Overview of Elasticsearch 7, that we constructed a table that describes the terms between SQL and Elasticsearch, comparing column and field, row and document, table and index, and database and cluster instance. You can think of Elasticsearch SQL as a translator from SQL to Elasticsearch. Nonetheless, all...