MRS Presto SQL

SQL or Script

Yes

You can select SQL statement or SQL script.

• SQL statement

  In the Statements text box, enter the SQL statement to be executed.

• SQL script

  Select a script to be executed. If no script is available, create and develop a script by referring to 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.

Node Status Polling Interval (s)

Yes

How often the system checks completeness of the node task. The value ranges from 1 to 60 seconds.

Max. Node Execution Duration

Yes

Maximum duration of executing a node. When Retry upon Failure is set to Yes for a node, the node can be re-executed for numerous times upon an execution failure within the maximum duration.

Retry upon Failure

Yes

Whether to re-execute a node after the node fails to be executed.

• Yes: The node will be re-executed after it fails to be executed. The following parameters must be configured:
  • Maximum Retries
  • Retry Interval (seconds)
• No: The node will not be re-executed. This is the default setting.

Failure Policy

Yes

Policies to be performed after the node fails to be executed:

• 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.

Dry run

No

If you select this option, the node will not be executed, and a success message will be returned.

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.