All Products
Search
Document Center

:Query syntax

Last Updated:Aug 27, 2024

Turing SQL supports query and kvpair clauses. A query clause is used to write the SQL query statement. A kvpair clause is used to specify the parameters. You can use your own tool to manually construct an HTTP request.

The SQL query path is /sql, but the OpenSearch Vector Search Edition query path is /.

Run queries

If you have the service IP address and port of the OpenSearch Vector Search Edition QRS, you can also run the curl command to manually call a query operation.

curl "ip:port/sql?query=SELECT brand, COUNT(*) FROM phone GROUP BY (brand)&&kvpair=trace:INFO;formatType:json"

Important
  • Spaces are not allowed between kvpair and && or between kvpair clauses. If a space exists between kvpair and && or between kvpair clauses, the query fails to be resolved.