Elasticsearch SQL-Query not possible

Question

I got a ElasticSearch Instance running locally which works fine. Now I want to query an index using SQL. I tried it with the NodeJS-Client (v7) and normally via the REST-Api. Rest call:

POST http://localhost:9200/_sql
{
   "body": {
       "query": "DESCRIBE indexname"
   }
}

And via nodeJS:

elasticClient.sql.query({
    format: "json",
    body: {
        query: "DESCRIBE indexname"
    }
}).then(result => {
    console.log(result);
}).catch(reject => {
    console.log(reject);
});

Both give back the same error:

Incorrect HTTP method for uri [/_sql] and method [POST], allowed: [GET, HEAD, PUT, DELETE] status: 405

Can anyone help? Cheers!

Which version of ES are you using? I suspect you're running the v7 JS client against a v6 cluster — Val, Nov 08 '19 at 08:39
Can you run the same `POST _sql` request with `curl` or something else other than this client code? (asking because that error message is typical for a setup where either **x-pack is not installed**, or **ES-SQL is not enabled**) And it helps to know the exact version of ES server. Also, the body of a `POST` request for `_sql` should be `{"query": "DESCRIBE indexname"}`, not sure why you have `body` in there. — Andrei Stefan, Nov 09 '19 at 14:03
@tiefenb can you elaborate more on the questions asked above? Being interested in a post and, also, offering a bounty for it, but not being ready to help with the investigation is not very productive. — Andrei Stefan, Nov 12 '19 at 22:59

score 0 · Answer 1 · answered Nov 12 '19 at 10:59

0

Try

GET http://localhost:9200/_sql
{
   "body": {
       "query": "DESCRIBE indexname"
   }
}

answered Nov 12 '19 at 10:59

Ryabchenko Alexander

10,057
7
56
88

GET request can't have a body – Hasselbach Apr 10 '20 at 11:47
and yet it is used that way e.g. in `_search` endpoint – Jakub Licznerski Jun 18 '20 at 08:12

score 0 · Answer 2 · answered Nov 14 '19 at 23:44

This issue is normally caused by the incompatibility of your elastic/elasticsearch module. What is your ES version? Try to upgrade your NodeJS version to your ES version.

Check the compatibility here.

https://www.npmjs.com/package/@elastic/elasticsearch

Elasticsearch SQL-Query not possible

2 Answers2