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

Basil_Paul · February 13, 2020, 5:45am

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]

dadoonet · February 13, 2020, 6:14am

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?

Basil_Paul · February 13, 2020, 9:42am

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

Basil_Paul · February 13, 2020, 10:30am

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

dadoonet · February 14, 2020, 1:59am

Could you share the full elasticsearch logs?

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

Christian_Dahlqvist · February 14, 2020, 6:23am

Which SQL plugin did you install?

Andrei_Stefan · February 14, 2020, 7:29am

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.

system · March 13, 2020, 7:29am

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