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 can quickly obtain query results without the need to transfer data.
- Go to the DataStudio page.
- Log on to the DataWorks console.
- In the left-side navigation pane, click Workspaces.
- In the top navigation bar, select the region where your workspace resides, find the workspace, and then click Data Analytics in the Actions column.
- Create a workflow. If you have a workflow, skip this step.
- Move the pointer over the icon and select Workflow.
- In the Create Workflow dialog box, specify the Workflow Name parameter.
- Click Create.
- Create a Hologres SQL node.
- Move the pointer over the icon and choose . You can also find the workflow in which you want to create a Hologres SQL node, right-click Hologres, and choose .
- In the Create Node dialog box, set the Node Name and Location parameters. Note The node name must be 1 to 128 characters in length, and can contain letters, digits, underscores (_), and periods (.).
- Click Commit.
- Move the pointer over the icon and choose .
- 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 Hologres SQL syntax. For more information about the Hologres SQL syntax, see SELECT.Note If you query data by executing a
SELECTstatement that does not contain the
LIMITclause, a maximum of 200 records are returned by default. If you want to view more query results, add the
LIMITclause at the end of the
SELECTstatement. A maximum of 10,000 records can be returned.
For example, if you execute the
select col_1,col_2 from your_table_name where pt>0 limit 500;statement, a maximum of 500 records are returned.
- On the node configuration tab, click the Properties tab in the right-side navigation pane. In the Properties panel, configure the scheduling properties for the node. For more information, see Configure basic properties.
- Save and commit the node.Notice You must set the Rerun and Parent Nodes parameters before you can commit the node.
In a workspace in standard mode, you must click Deploy in the upper-right corner after you commit the node. For more information, see Deploy nodes.
- Click the icon in the toolbar to save the node.
- Click the icon in the toolbar.
- In the Commit Node dialog box, enter your comments in the Change description field.
- Click OK.
- Test the node. For more information, see View auto triggered nodes.