Unable to use Xpack SQL Handle

Elastic Stack Elasticsearch
1

I had tried installing xpack. But unfortunately Iam not able to use the same. I have attached the output and command. Please help.

Command
GET /_cat/plugins?v

Output
name component version
Qreda_Dev-1 sql 5.3.0.0
Qreda_Dev-1 x-pack 5.3.0

Command
POST /_sql?format=txt
{
"query":"select * from consumer_tag_store"
}

Output
{
"error": {
"root_cause": [
{
"type": "null_pointer_exception",
"reason": null
}
],
"type": "null_pointer_exception",
"reason": null
},
"status": 500

2

@dadoonet Kindly help

3

It looks like you may be running an old version of Elasticsearch. SQL support was added in version 7.x so you may need to upgrade.

4

Which version do you suggest?

5

7.7.0