how can query on multiple indexes,like we do in sql join ( inner join,left join etc) using DSL in opensearch

[Shivacharangoud]

how can query on multiple indexes,like we do in sql join ( inner join,left join etc) using DSL in opensearch @anirudha @kyleconroy @spk @mattweber

[dblock]

Let's move this to SQL repo.

[Shivacharangoud]

@anirudha @anirudha @kyleconroy @spk @smortex @

[kotwanikunal]

Hey @Shivacharangoud. Can you please give an example/sample request that you run with SQL join?

And just to be clear, SQL here refers to - https://github.com/opensearch-project/sql, right?

(Removing the bug label)

[andrross]

Closing due to no follow up.

@Shivacharangoud feel free to reopen if you still have questions. Please note that the forum is also a great place for general discussion and to seek help about OpenSearch.

[Shivacharangoud]

@kotwanikunal Suppose I run sql request as : POST _plugins/_sql {"query":"SELECT * FROM indexone INNER JOIN indextwo ON indexone.contactid=indextwo.contactid"}

I want to do the same using DSL, how can I do it. Please answer this. @kotwanikunal @andrross

[Shivacharangoud]

Yaa okay but i need answer to this. Can any one respond

[Shivacharangoud]

Answer this please

[Shivacharangoud]

Please answer this

[dai-chen]

@Shivacharangoud DSL query is part of OpenSearch core. AFAIK, there is no join support in DSL. You can take a look at parent-child field and nested field. These may be the only support in OpenSearch: https://opensearch.org/docs/latest/opensearch/supported-field-types/join/

[dai-chen]

I'm transferring this issue back to OpenSearch core repo. Because the ask was "I want to do the same using DSL, how can I do it." @dblock