SQL Handle for Elastic Search

Elastic Stack Elasticsearch
1

Hello guys,
Iam unable to query data residing in Elastic. I need to install SQL for querying the data residing in Elastic search. Please let me know whether it is possible to install SQL handle for Kibana or Elastic search.

Below given are the details
Elastic search version - 5.3.0
Kibana version - kibana-5.3.0-linux-x86_64

Please let me know whether I would be able to work with SQL commands with the above given installation.

2

Why?

Upgrade. To at least 6.8 or better 7.6

3

Is it possible to query SQL commands with the current version that is 5.3.0

4

It was added in 6.3 I think.
May be there are 3rd party plugins available for older versions.

But you did not answer my question.

5

Since Iam not familiar with Kibana console Iam unable to query data residing in Elastic search

6

You can go to the Dev Console in Kibana and type:

GET /_search
7

BTW I see that we already answered you in No handler found for uri [/_sql] and method [POST] I think.

8

Apologies for late reply. Since Iam confortable with Mysql commands I was looking forward to work with Mysql commands. @Andrei_Stefan as you had mentioned to use /_xpack/sql. But unfortunately it did not work

9

What is the output of:

GET /_cat/plugins?v
10

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.