Purpose

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.
  • This connection property can affect performance.

Default

multiRowInsert

Data Type

String

See also