skip to main content
Connection Option Descriptions for Apache Spark SQL : Array Size
  

Try DataDirect Drivers Now

Array Size

Attribute

ArraySize (AS)

Purpose

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 of 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 server, an out of memory error will be returned. If you receive this error, decrease the value specified until fetches are successfully executed.

Default

20000

GUI Tab

Advanced tab

See Also

Performance Considerations