Determines the mechanism that is used to execute batch operations.
Valid Values
nativeBatch | multiRowInsert
Behavior
If set to nativeBatch, the Hive native batch mechanism is used to execute batch operations, and an insert statement is executed for each row contained in a parameter array.
If set to multiRowInsert, the driver attempts to execute a single insert statement for all the rows contained in a parameter array. If the size of the insert statement exceeds the available buffer memory of the server, the driver executes multiple statements. This behavior provides substantial performance gains for batch inserts.
Notes
Multirow inserts can only be performed on Insert statements that use parameterized arrays.
Batch operations for parameterized arrays are not supported for updates or deletes.
The driver modifies the HQL statement to perform a multirow insert.
Multirow inserts can only be performed on Insert statements that use parameterized arrays.