All Products
Search
Document Center

DataWorks:Create a Hologres SQL node

Last Updated:Jul 08, 2025

This topic describes how to create a Hologres SQL node. Hologres seamlessly integrates with MaxCompute at the underlying layer. This integration allows you to use standard PostgreSQL statements to query and analyze large amounts of data stored in MaxCompute without transferring data, enabling you to quickly obtain query results.

Prerequisites

You have attached a Hologres computing resource.

Procedure

  1. Go to the DataStudio page.

    Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and O&M > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

  2. Create a Workflow.

    If you have an existing Workflow, skip this step.

    1. Move the pointer over the 新建 icon and select Workflow.

    2. In the Create Workflow dialog box, configure the Workflow Name parameter.

    3. Click Create.

  3. Create a Hologres SQL node.

    1. Move the pointer over the 新建 icon and choose Create Node > Hologres > Hologres SQL.

      You can also find the workflow in which you want to create a Hologres SQL node, right-click Hologres, and choose Create Node > Hologres SQL.

    2. In the Create Node dialog box, configure the Node Name parameter.

      Note

      The node name must be 1 to 128 characters in length and can contain letters, digits, underscores (_), and periods (.).

    3. Click OK.

  4. On the configuration tab of the node, write and run code in the code editor.

    After the Hologres SQL node is created, edit the code in compliance with the Hologres SQL syntax. For more information about the Hologres SQL syntax, see SELECT.

    Note

    When you query data by using a SELECT syntax that does not include a limit clause, only 200 query results are displayed by default. If you need to display more data, you can add a limit clause after the SELECT syntax. The maximum number of query results that can be displayed is 10,000.

    For example, if you execute the select col_1,col_2 from your_table_name where pt>0 limit 500; statement to query data, a maximum of 500 records are returned.

  5. Click Properties on the right side of the node editing area to configure scheduling properties for the node. For more information, see Configure basic properties.
  6. Save and commit the node.
    Important You must configure the Rerun and Parent Nodes parameters before you commit the node.
    1. Click the 保存 icon in the toolbar to save the node.
    2. Click the 提交 icon in the toolbar.
    3. In the Commit Node dialog box, configure the Change Description parameter.
    4. Click OK.
    If the workspace that you use is in standard mode, you must click Deploy in the upper-right corner after you commit the node. For more information, see Deploy nodes.
  7. Perform O&M operations on the node. For more information, see Perform basic O&M operations on auto triggered nodes.