SQL equivalents

OpenSearch
1

I am relatively new to OpenSearch and an struggling with taking my SQL based queries to an OpenSearch environment. Essentially treating OpenSearch like a database. We do not have the SQL plugins.

I would appreciate help in converting a query like
SELECT F1, F2, F3 FROM TABLE1 WHERE A IN (‘QWERT’,‘UIOPQ’,‘ZXCVB’) AND B=17

I have been trying with BOOL in its various guises and am stymied. I get a variety of “unable to parse” errors. With things like "duplicate match keyword and others that are hard for me to interpret.

Any assistance greatly appreciated.

Describe the issue:

Configuration:

Relevant Logs or Screenshots:

2

Hi @chrisbird

Have you tried to execute your request in the OpenSearch Dashboards?

To check whether _sql plugin was installed, could you please execute the following request in the DevTools?