Supported write modes
Use the Write mode property to specify the mode used to write rows to the Hive data source
Usage
You can set the Write mode property to the values that are listed in the
following table.
Write mode | Desription |
---|---|
Insert | The connector attempts to insert records from the input link as rows into the target table. |
Update | Not supported |
Delete | Not supported |
If the connector generates the INSERT statement at run time, it utilizes all input link columns in the VALUES clause of the statement. The connector runs the statements in batch mode where the statements are run on a batch of records instead of individual records.
The connector runs the statements in batch mode only if the following conditions are met:
- Write mode property is either set to Insert, Update, Delete or Custom
- Batch size property is set to a value that is greater than 1.
- Hive data source supports the batch mode operation.
INSERT INTO TABLE1 VALUES (ORCHESTRATE.C1, ORCHESTRATE.C2) . In this case, the connector binds the statement parameters to input link columns by name. The statement parameter ORCHESTRATE.C1 is mapped to input link column C1 and the statement parameter ORCHESTRATE.C2 is mapped to input link column C2.