Introduction
The retrieval engine edition provides SQL development capabilities, supporting the compilation, development, and testing of SQL statements, including basic IDE features such as syntax highlighting, auto-completion, and parameter settings.
Usage method
Enter the OpenSearch console, switch to OpenSearch Retrieval Engine Edition in the upper left corner, find the corresponding instance in the instance management page list, and click Manage in the Actions column.
Perform SQL development in Extended Features > SQL Development.
Under the Retrieval Engine Edition-SQL Development tab, there are three list groups, namely SQL Instances, Table Details, and Function.
Create SQL instance script, click the button on the right side of SQL Instances, and select New SQL Instance.
After clicking OK, the system will automatically generate the SQL instance script.
5.Script writing, in the newly created SQL instance script, supports SQL editing, SQL formatting, SQL running, and other functions.
The running results can be viewed or downloaded in the list page below, and you can also view the SQL running logs and query statements:
Query syntax reference
Reference: Notes Query syntax
Notes
SQL Instances support: Create SQL Instance, and Create Folder
Support for SQL script renaming, copying, and deleting functions
Support for SQL script saving, running, reloading, formatting, and setting parameters (related reference: kvpair clause) functions
In the newly created SQL script, you can write, query, and test SQL;
Support New SQL Instance, New Folder functions;
Support for SQL script renaming, copying, and deleting functions
Support for SQL script saving, running, reloading, formatting, and setting parameters (related reference: kvpair clause) functions
In the newly created SQL script, you can write, query, and test SQL.
Table Details: Displays the index table names in the current cluster
Function: Supports the display of usage introduction
Fields of type date, time, and timestamp cannot be retrieved using SELECT SQL statements.