OpenSearch Vector Search Edition provides an SQL development feature for developing and testing SQL statements. This feature offers basic IDE functionalities such as syntax highlighting, auto-completion, and parameter settings.
Procedure
-
Log on to the OpenSearch console. In the upper-left corner, switch to OpenSearch Vector Search Edition. On the Instance Management page, find the instance that you want to manage and click Manage in the Actions column.
-
In the navigation pane on the left, choose Extended Features > SQL Development.
-
On the SQL Development tab, there are three panes on the left: SQL instances, Index tables, and Function:
-
SQL instances:
-
You can Create SQL Instance and Create Folder.
-
You can Rename, Copy, or Delete SQL scripts.
-
You can save, run, reload, format, and set parameters for SQL scripts. For more information, see kvpair clause.
-
In a newly created SQL script, you can write, query, and test SQL statements.
-
-
Index tables: Lists the index tables in the current cluster.
-
Function: Lists the available user-defined functions.
-
Create an SQL instance script. Next to SQL instances, click the menu and select Create SQL Instance. In the dialog box, enter a name for the SQL instance.
Click OK. The system automatically generates the SQL instance script.
2.Script editing. In the new SQL instance script, you can edit, format, and run SQL statements.
Results appear in the pane below, where you can view or download them. You can also view the execution logs and the original query statement on their respective tabs.
Query syntax
For more information, see Query statements.