# SQL Handle for Elastic Search

**URL:** <https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [March 19, 2020, 8:13am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226 "2020-03-19T08:13:00Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Basil\_Paul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/basil_paul/32/62605_2.png) [@Basil\_Paul](https://discuss.elastic.co/u/Basil_Paul)\
**Post date:** [March 19, 2020, 8:13am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/1 "2020-03-19T08:13:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 19, 2020, 8:35am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/2 "2020-03-19T08:35:41Z")

</div>

> [@Basil\_Paul](#):
>
> Iam unable to query data residing in Elastic.

Why?

> [@Basil\_Paul](#):
>
> Elastic search version - 5.3.0

Upgrade. To at least 6.8 or better 7.6

---

<div class="post-metadata">

**Author:** ![Basil\_Paul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/basil_paul/32/62605_2.png) [@Basil\_Paul](https://discuss.elastic.co/u/Basil_Paul)\
**Post date:** [March 19, 2020, 8:36am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/3 "2020-03-19T08:36:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 19, 2020, 9:00am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/4 "2020-03-19T09:00:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Basil\_Paul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/basil_paul/32/62605_2.png) [@Basil\_Paul](https://discuss.elastic.co/u/Basil_Paul)\
**Post date:** [March 19, 2020, 9:11am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/5 "2020-03-19T09:11:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 19, 2020, 9:32am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/6 "2020-03-19T09:32:29Z")

</div>

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

```auto
GET /_search

```

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 19, 2020, 9:33am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/7 "2020-03-19T09:33:33Z")

</div>

BTW I see that we already answered you in [No handler found for uri [/\_sql] and method [POST]](https://discuss.elastic.co/t/no-handler-found-for-uri-sql-and-method-post/219121/7) I think.

---

<div class="post-metadata">

**Author:** ![Basil\_Paul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/basil_paul/32/62605_2.png) [@Basil\_Paul](https://discuss.elastic.co/u/Basil_Paul)\
**Post date:** [April 1, 2020, 5:13am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/8 "2020-04-01T05:13:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 1, 2020, 6:39am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/9 "2020-04-01T06:39:36Z")

</div>

What is the output of:

```
GET /_cat/plugins?v
```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 29, 2020, 6:39am UTC](https://discuss.elastic.co/t/sql-handle-for-elastic-search/224226/10 "2020-04-29T06:39:43Z")

</div>

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