No handler found for uri [/_sql] and method [POST]

Elastic Stack Elasticsearch
1

Hello,
I had added the plugin for sql in Elastic search. Inspite of adding sql plugin for sql. Iam unable to run sql queries.
Below given is the command:
curl -H "Content-Type: application/json" -XPOST 'http://10.94.1.114:9200/_sql' -d 'SELECT * FROM testing_tagstore1 LIMIT 10'

Error
No handler found for uri [/_sql] and method [POST]

2

Welcome!

Which plugin do you mean? It's now part of the default distribution.
But if you installed a plugin, did you restart the nodes?

3

Yes I have restarted the nodes after plugin installation. But inspite of that it still throws the same error. Iam a beginner. Request you to please help

4

Please note the version of Elastic search that Iam using is elasticsearch-5.3.0

5

Could you share the full elasticsearch logs?

Why are you using a so old version instead of 7.6.0?

6

Which SQL plugin did you install?

7

There is no Elastic SQL plugin for 5.3.0 from what I know. As others suggested, please try a much newer Elasticsearch version. There are many many fixes and features in these versions.

Also, specifically related to your issue, in older Elasticsearch versions the endpoint is /_xpack/sql and not /_sql.

8

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