Shivacharan Koyyada

Match query is not working in sql dev tools while its working in query workbench in opensearch

7

SELECT * FROM contacts WHERE match(name, 'charan') ; The above query is working in query workbench But if I use the same query in dev tools. Using plugin not working...

Nested() function with sql joins

6

How to use nested() function when using SQL JOIN FOR example: ```sql SELECT * FROM nested_mapping_sql_one WHERE contact_id=1001 AND nested(section_data,(section_data.section_id=66 AND section_data.field_id=288 AND section_data.data='rr') AND (section_data.section_id=99 AND section_data.field_id=122 AND section_data.data='ddd'))...

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

10

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