# Is \_opendistro/\_sql/\_translate supported on OD version 1.6.0.0

**URL:** <https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266>\
**Category:** SQL\
**Tags:** troubleshoot\
**Created:** [April 18, 2022, 3:39pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266 "2022-04-18T15:39:12Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![dinesh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/dinesh/32/3283_2.png) [@dinesh](https://forum.opensearch.org/u/dinesh)\
**Post date:** [April 18, 2022, 3:39pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/1 "2022-04-18T15:39:12Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![daichen](https://avatars.discourse-cdn.com/v4/letter/d/c4cdca/32.png) [@daichen](https://forum.opensearch.org/u/daichen)\
**Post date:** [April 18, 2022, 6:47pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/2 "2022-04-18T18:47:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dinesh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/dinesh/32/3283_2.png) [@dinesh](https://forum.opensearch.org/u/dinesh)\
**Post date:** [April 18, 2022, 6:58pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/3 "2022-04-18T18:58:32Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![daichen](https://avatars.discourse-cdn.com/v4/letter/d/c4cdca/32.png) [@daichen](https://forum.opensearch.org/u/daichen)\
**Post date:** [April 18, 2022, 7:09pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/4 "2022-04-18T19:09:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dinesh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/dinesh/32/3283_2.png) [@dinesh](https://forum.opensearch.org/u/dinesh)\
**Post date:** [April 18, 2022, 7:26pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/5 "2022-04-18T19:26:38Z")

</div>

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

output:

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

---

<div class="post-metadata">

**Author:** ![dinesh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/dinesh/32/3283_2.png) [@dinesh](https://forum.opensearch.org/u/dinesh)\
**Post date:** [April 21, 2022, 3:14pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/6 "2022-04-21T15:14:54Z")

</div>

team , any help here please ?

---

<div class="post-metadata">

**Author:** ![shivacharan](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@shivacharan](https://forum.opensearch.org/u/shivacharan)\
**Post date:** [September 28, 2022, 6:49pm UTC](https://forum.opensearch.org/t/is-opendistro-sql-translate-supported-on-od-version-1-6-0-0/9266/7 "2022-09-28T18:49:11Z")

</div>

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