Is _opendistro/_sql/_translate supported on OD version 1.6.0.0

Plugins SQL
1

Hi all,
Getting below error when trying to run bellow query:

POST _opendistro/_sql/_translate
{
“query”: “select name,age from test LIMIT 5”
}

{
“error” : {
“root_cause” : [
{
“type” : “security_exception”,
“reason” : “Unexpected exception indices:data/write/index”
}
],
“type” : “security_exception”,
“reason” : “Unexpected exception indices:data/write/index”
},
“status” : 500
}

Any pointers please?

2

Hi @dinesh , from the error, it seems permission issue. Please check if your current user/role has sufficient permission to access the index. Thanks

3

Thanks for replying @daichen
User has write permission . The same api works without _translate .

Not sure if _translate endpoint is supported or it needs some additional permission.

4

I see. I missed that. Please try _opendistro/_sql/_explain.

5

POST _opendistro/_sql/_explain
{
“query”: “select name,age from test LIMIT 5”
}

output:

{
“from” : 0,
“size” : 5,
“_source” : {
“includes” : [
“name”,
“age”
],
“excludes” :
}
}

6

team , any help here please ?

7

Hii dinesh how can we join two indices like we in sql (such as inner join left join)

Can i get your professional contact details like linkedin