How to convert SQL to DSL in opensearch. sql,translate, plugins

Open Source Elasticsearch and Kibana
,
1

How to convert this below SQL to DSL

SELECT * FROM contact_names JOIN contacts_profile_data ON contact_names.contact_id = contacts_profile_data.contact_id

When iam using the below approach
POST /_sql/translate
{
“query”:“SELECT * FROM contact_names JOIN contacts_profile_data ON contact_names.contact_id = contacts_profile_data.contact_id;”
}

iam getting this message,
{“Message”:“Your request: ‘/_sql/translate’ is not allowed.”}

How can i resolve it .
please help me out with this.

2

Hi @shivacharan -

I believe you want POST /_plugins/_sql - does that work any better for you?

Nate

3

Hii @ nateynate
It not worked
How can we do multiple index join, like we do in sql (such as inner join left join etc)