How to execute raw SQL query in OpenSearch .Net Client

Question

I know that we can write DSL queries to search OpenSearch. But for some reason, I need to execute some raw SQL queries to get the result using the dotNet client. I can execute the raw query on DevTool in the OpenSearch Dashboard but I need to execute this from the .Net Client.

POST _plugins/_sql
{
  "query":"""SELECT * FROM bookmark_questions WHERE studentId = 5"""
}

[Note: This is just a sample query.]

In ElasticSearch, it's possible. Link.

var q = new QuerySqlRequest()
{
   Query = req,
   Format = "json"
};
var resp = await _elasticClient.Sql.QueryAsync(q);

But in Opensearch, I couldn't do that. How can I execute this type of query?

rawberry · Accepted Answer · 2023-07-06 15:29:02Z

0

You probably want to use the low level OpenSearch client to do this, so you can construct the query yourself rather than depending on methods implemented for the high level client.

answered Jul 6, 2023 at 15:29

rawberry

3122 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to execute raw SQL query in OpenSearch .Net Client

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related