This is the first part of an Elasticsearch Comrade introduction series.
Elasticsearch Comrade is a management UI for common operations within elastic products.
In this post, I will cover the SQL Editor feature.

Starting up Comrade server

You can install comrade with pip / docker / source
Follow the installation guide for more details

The SQL UI

Once you configured Comrade and started the server, click on the desired server. Next, open the navbar and click on 🔎SQL nav item

Sending queries and getting results

Now, The SQL editor will show up, and you free to send you queries 🙂

Some things you need to know before running queries:

• SQL is only supported in ES version 7 and above
• The SQL syntax is quite standard except a few changes
• You can refer several indices at once using elasticsearch index expansion syntax, for instance (Notice the second line)

SELECT count(*), source_node.name
FROM ".monitoring-es-*"
WHERE type = 'index_recovery'
GROUP BY source_node.name
LIMIT 100

• You can apply Elasticsearch query function like match, query, and score by using them as a function

SELECT source_node.name, SCORE() -- Add score to selected fields
from ".monitoring-es-7-2019.12.22"
where MATCH('type', 'index_recovery') -- Use match query
order by SCORE() -- order by score
LIMIT 100

Found this post useful? Add a ⭐️ to my Github project nor my twitter profile🙂