This is the conversion (transform) operation information for the SQL query (Spark SQL query) type.
Note
For common syntax and field information on the node source, transform, and target types of Data Flow ETL jobs, see ETLJobNode common.
Syntax
The syntax is as follows:
private List<SourceName> sourceNameList;
private String sql;
Field
The following describes the fields:
| Field | Type | Required | Description |
|---|---|---|---|
sourceNameList[].parentId |
Long | Required | Parent node ID |
sourceNameList[].newName |
String | Required | Table alias |
sql |
String | Required | Spark SQL query |