Attribute

ArrayInsertSize (AIS)

Purpose

Specifies the maximum buffer size, in KB, the driver uses for a packet when executing a multi-row insert. By limiting the packet size, the driver can avoid out of memory errors when executing inserts that require large amounts of memory, while continuing to provide improved performance when executing inserts that are smaller in size.

In most scenarios, the default setting provides the ideal driver behavior; however, you may need to reduce the value specified if you encounter either of the following:

  • Performance or memory issues when inserting larger values.
  • The following error when inserting larger values while using Apache Knox: HTTP/1.1 500 Server Error.

Valid Values

x

where:

x
is a positive integer representing the maximum buffer size in KB.

Notes

  • You can improve performance by increasing the value specified for this option; however, if the value exceeds the available buffer memory for the Apache Hive server, an out of memory error will be returned. If you receive this error, decrease the value specified until fetches are successfully executed.
  • This connection option can affect performance.

Default

16384 (KB)

GUI Tab

Advanced tab