SQL

Here’s how core SQL concepts map to OpenSearch:

To use the SQL plugin with your own applications, send requests to the endpoint:

You can query multiple indexes by using a comma-separated list:

To run the above query in the command line, use the command:

You can specify the response format as JDBC, standard OpenSearch JSON, CSV, or raw. By default, queries return data in JDBC format. The following query sets the format to JSON: