Shivacharan Koyyada

Results 13 comments of Shivacharan Koyyada

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

version:OpenSearch 1.2 POST _plugins/_sql?format=json { "query":"SELECT * FROM contacts WHERE match(name, 'charan') ;" } if i run the above script iam getting this error { "error": { "reason": "Invalid SQL...

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

mappings: ``` { "contacts" : { "mappings" : { "properties" : { "age" : { "type" : "integer" }, "name" : { "type" : "text", "fields" : { "keyword" :...

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

i have an question which is not related to this issues. can we add two indices using DSL on common field in opensearch? if yes how we can do it....

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

@anirudha @anirudha @kyleconroy @spk @smortex @

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

@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...

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

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

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

Answer this please

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

Please answer this

Nested() function with sql joins

@acarbonetto here is the details:********************************* @anirudha @macohen @hyandell @seraphjiang @hyandell Index 1 mapping: ```json { "nested_native_mapping" : { "mappings" : { "properties" : { "contact_id" : { "type" : "long"...

Nested() function with sql joins

@acarbonetto please respond