All Products
Search

This Product

    Hologres:Create a query

    Document Center

    Hologres:Create a query

    Last Updated:Mar 26, 2026

    Use the SQL Editor in HoloWeb to write and run interactive SQL queries against your Hologres instances. From the SQL Editor, you can:

    • Create, edit, copy, rename, and delete SQL queries

    • Organize queries into folders

    • Browse tables, views, and other database objects in the current database

    • Run queries, view execution plans and execution analysis, and format SQL

    • Access operational logs and export query results

    Limitations

    • The SQL Editor is designed for interactive, short-running queries. It is not intended for offline batch jobs such as large-scale data imports or exports.

    • SQL execution is limited to 60 minutes. Queries that exceed this limit are automatically cancelled with the message: cancel query due to timeout, queryTimeout setting is: 3600s

    • Setting statement_timeout to a value greater than 60 minutes has no effect on queries run in HoloWeb. To learn about modifying the active query timeout, see Modifying active query timeout.

    Prerequisites

    Before you begin, ensure that you have:

    Open the SQL Editor

    1. Log on to the Hologres Management Console.

    2. In the navigation pane on the left of the top menu bar, select the target region.

    3. Click Go to HoloWeb.

    4. In the top menu bar, click SQL Editor.

    Create an SQL query

    1. In the navigation pane on the left, right-click My SQL Queries and select Create SQL Query. > Tip: Click image to open a temporary SQL query window without saving. After running your SQL, click Save if you want to keep the query.

    2. In the Create SQL Query dialog box, configure the following parameters.

      Parameter Description
      Job Name Name of the SQL query.
      Folder Folder where the query is stored. Defaults to My SQL Queries. Select an existing folder or enter a name in New Folder to create one.
      Instance Name Target Hologres instance.
      Database Name Target database on the selected instance.

    3. Click OK.

    The SQL editor opens. Write standard PostgreSQL-compatible SQL statements in the editor.

    Table and field names are case-insensitive by default. To query a table with an exact case-sensitive name, enclose the name in double quotation marks.

    Manage saved queries

    In the navigation pane on the left, click My SQL Queries to find saved queries. If a query is stored in a folder, enter its name in the Query search box to locate it. Right-click the target query to perform the following operations:

    Operation How
    Edit Double-click the query to open it, then enter or modify SQL in the editor.
    Delete Right-click and select Delete SQL Query Task.
    Copy Right-click and select Copy SQL Query Task, then paste the SQL into another query window.
    Rename Right-click and select Rename, then enter a new name.