All Products
Search

This Product

    E-MapReduce:SQL editor

    Document Center

    E-MapReduce:SQL editor

    Last Updated:Mar 26, 2025

    SQL editor is an interactive query editor provided by Alibaba Cloud E-MapReduce (EMR) Serverless StarRocks Manager. You can write, run, and manage SQL query statements in the SQL editor of EMR Serverless StarRocks without the need to download or install any on-premises client software. This helps data analysts and developers query and analyze data in real time.

    Prerequisites

    An EMR Serverless StarRocks instance is created. For more information, see Create an instance.

    Go to the SQL editor

    1. Go to the homepage of E-MapReduce (EMR) Serverless StarRocks.

      1. Log on to the EMR console.

      2. In the left-side navigation pane, choose EMR Serverless > StarRocks.

      3. In the top navigation bar, select a region based on your business requirements.

    2. On the Instances tab, find the created instance and click Connect in the Actions column. For more information, see Use EMR StarRocks Manager to connect to an EMR Serverless StarRocks instance.

      You can specify an appropriate user to connect to the StarRocks instance.

    Overall layout of the SQL Editor page

    image

    Area

    Description

    1

    This area displays all files. You can use the out-of-the-box TPC-DS and TPC-H test scripts to perform a test in the SQL editor of StarRocks Manager. For more information, see the topics in the TPC-DS and TPC-H directories.

    2

    You can click the image icon to create an SQL query. The first time you enter the SQL Editor page, you can also click the image icon to create an SQL query.

    3

    You can click Run to run the entire SQL script or execute specific SQL statements in the SQL script.

    To execute specific SQL statements, select the desired SQL statements and click the image icon on the left.

    Note

    This icon is displayed only when you click a line of code.

    4

    You can click Save to save all statements.

    5

    You can click Format to adjust the indentation, line feed, and keyword case.

    6

    This area displays the query results or failure information.

    7

    You can click the image icon to export the query results.

    8

    You can click the image icon to display the query results or failure information in full screen.

    9

    You can click Query Analysis to analyze the query plan. For more information, see Manage and analyze queries.

    References

    For information about how to view and analyze the operations performed on a database, see Audit logs.