Note: The Array Size option has been renamed Array Fetch Size. The ArraySize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product. If values are specified for both options, the value for Array Fetch Size will take precedent.
The number of cells the driver retrieves from a server for a fetch. When executing a fetch, the driver divides the value specified by the number columns in a particular table to determine the number of rows to retrieve. By determining the fetch size based on the number of cells, the driver can avoid out of memory errors when fetching from tables containing a large number of columns while continuing to provide improved performance when fetching from tables containing a small number of columns.
Valid Values
x
where:
x
is a positive integer specifying the number of cells the driver retrieves for a fetch.
Notes
You can improve performance by increasing the value specified for this option; however, if the number of cells specified 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.
You can improve performance by increasing the value specified for this option; however, if the number of cells specified 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.