Supported write modes
Use the Write mode property to specify the mode used to write rows to the Hive data source
|Insert||The connector attempts to insert records from the input link as rows into the target table.|
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.
- 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.