MRS Presto SQL

Functions

The MRS Presto SQL node is used to execute the Presto SQL script predefined in DataArts Factory.

Parameters

Table 1, Table 2, and Table 3 describe the parameters of the MRS Presto SQL node.

Table 1 Property parameters

Parameters	Mandatory	Description
SQL or Script	Yes	You can select SQL statement or SQL script. SQL Statement In the SQL statement text box, enter the SQL statement to be executed. SQL Script Select a script to be executed. If the script is not created, create and develop the script by repeating steps Creating a Script and Developing an SQL Script. Note If you select the SQL statement mode, the DataArts Factory module cannot parse the parameters contained in the SQL statement.
Data Connection	Yes	Data connection that is configured in the SQL script. The value can be changed.
Schema	Yes	Database that is configured in the SQL script. The value can be changed.
Script Parameter	No	If the associated SQL script uses a parameter, the parameter name is displayed. Set the parameter value in the text box next to the parameter name. The parameter value can be an EL expression. If the parameters of the associated SQL script are changed, click to refresh the parameters.
Node Name	Yes	Name of the SQL script. The value can be changed. Node name. It contains 1 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed. Note The node name cannot contain Chinese characters or more than 64 characters. If the node name does not meet requirements, the MRS job will fail to be submitted.

Table 2 Advanced parameters

Parameter	Mandatory	Description
Node Status Polling Interval (s)	Yes	Specifies how often the system check completeness of the node task. The value ranges from 1 to 60 seconds.
Max. Node Execution Duration	Yes	Execution timeout interval for the node. If retry is configured and the execution is not complete within the timeout interval, the node will not be retried and is set to the failed state.
Retry upon Failure	Yes	Indicates whether to re-execute a node task if its execution fails. Possible values: Yes: The node task will be re-executed, and the following parameters must be configured: Maximum Retries Retry Interval (seconds) No: The node task will not be re-executed. This is the default setting. Note If Timeout Interval is configured for the node, the node will not be executed again after the execution times out. Instead, the node is set to the failure state.
Failure Policy	Yes	Operation that will be performed if the node task fails to be executed. Possible values: End the current job execution plan: stops running the current job. The job instance status is Failed. Go to the next node: ignores the execution failure of the current node. The job instance status is Failure ignored. Suspend current job execution plan: suspends running the current job. The job instance status is Waiting. Suspend execution plans of the subsequent nodes: stops running subsequent nodes. The job instance status is Failed.

Table 3 Lineage

Parameter	Description
Input
Add	Click Add. In the Type drop-down list, select the type to be created. The value can be DWS, OBS, CSS, HIVE, DLI, or CUSTOM. DWS Connection Name: Click . In the displayed dialog box, select a DWS data connection. Database: Click . In the displayed dialog box, select a DWS database. Schema: Click . In the displayed dialog box, select a DWS schema. Table Name: Click . In the displayed dialog box, select a DWS table. OBS Path: Click . In the displayed dialog box, select an OBS path. CSS Cluster Name: Click . In the displayed dialog box, select a CSS cluster. Index: Enter a CSS index name. HIVE Connection Name: Click . In the displayed dialog box, select a HIVE data connection. Database: Click . In the displayed dialog box, select a HIVE database. Table Name: Click . In the displayed dialog box, select a HIVE table. CUSTOM Name: Enter a name of the CUSTOM type. Attribute: Enter an attribute of the CUSTOM type. You can add more than one attribute. DLI Connection Name: Click . In the displayed dialog box, select a DLI data connection. Database: Click . In the displayed dialog box, select a DLI database. Table Name: Click . In the displayed dialog box, select a DLI table.
OK	Click OK to save the parameter settings.
Cancel	Click Cancel to cancel the parameter settings.
Modify	Click to modify the parameter settings. After the modification, save the settings.
Delete	Click to delete the parameter settings.
View Details	Click to view details about the table created based on the input lineage.
Output
Add	Click Add. In the Type drop-down list, select the type to be created. The value can be DWS, OBS, CSS, HIVE, DLI, or CUSTOM. DWS Connection Name: Click . In the displayed dialog box, select a DWS data connection. Database: Click . In the displayed dialog box, select a DWS database. Schema: Click . In the displayed dialog box, select a DWS schema. Table Name: Click . In the displayed dialog box, select a DWS table. OBS Path: Click . In the displayed dialog box, select an OBS path. CSS Cluster Name: Click . In the displayed dialog box, select a CSS cluster. Index: Enter a CSS index name. HIVE Connection Name: Click . In the displayed dialog box, select a HIVE data connection. Database: Click . In the displayed dialog box, select a HIVE database. Table Name: Click . In the displayed dialog box, select a HIVE table. CUSTOM Name: Enter a name of the CUSTOM type. Attribute: Enter an attribute of the CUSTOM type. You can add more than one attribute. DLI Connection Name: Click . In the displayed dialog box, select a DLI data connection. Database: Click . In the displayed dialog box, select a DLI database. Table Name: Click . In the displayed dialog box, select a DLI table.
OK	Click OK to save the parameter settings.
Cancel	Click Cancel to cancel the parameter settings.
Modify	Click to modify the parameter settings. After the modification, save the settings.
Delete	Click to delete the parameter settings.
View Details	Click to view details about the table created based on the output lineage.

last updated: 2024-06-29 01:03