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 volumes of data stored in MaxCompute. In this case, you do not need to transfer data. This allows you to quickly obtain query results.

Prerequisites

The Hologres compute engine is bound on the Workspace Management page. This ensures that the Hologres folder is displayed on the page on which you want to create a Hologres SQL node. For more information, see Configure a workspace.

Procedure

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where the target workspace resides. Find the target workspace and click Data Analytics in the Actions column.
  2. Move the pointer over the New icon, and choose Customize > Hologres development. In the New node dialog box, specify parameters and click Submit.
    Alternatively, unfold Business process in the left pane. Right-click a business process and choose New > UserDefined > Hologres development. In the New node dialog box, specify parameters and click Submit.
  3. In the New node dialog box, set the Node name and Destination folder parameters.
    Note The node name must be 1 to 128 characters in length and can contain letters, digits, underscores (_), and periods (.). It is not case-sensitive.
  4. Click Submit.
  5. On the tab that appears, edit and run the code in the code editor.
    After the Hologres SQL node is created, edit the code in compliance with the required SQL syntax. For more information about the SQL syntax, see SELECT.
  6. Save and commit the node.
    Notice You must set the Rerun attribute and Dependent upstream node parameters on the Scheduling configuration tab before you can commit the node.
    1. Click Save icon in the toolbar to save the node.
    2. Click Submit icon in the toolbar to commit the node.
    3. In the Submit New Version dialog box, enter your comments in the Change description field.
    4. Click OK.
    In a workspace in standard mode, you must click Publish in the upper-right corner after you commit the AnalyticDB for MySQL node. For more information, see Deploy a node.
  7. Test the node. For more information, see Auto triggered nodes.