Fetch Size

The Simba Amazon Athena JDBC Connector supports a maximum fetch size of 1000 rows. This is consistent with the maximum fetch size that is supported by the Athena service when the result set streaming API is not used (UseResultsetStreaming=0).

If you use the setFetchSize() method from the Statement class to set a fetch size greater than 1000 without using the result set streaming API, the Simba Amazon Athena JDBC Connector limits the value to 1000. When the result set streaming API is used, the connector does not impose a maximum limit on the fetch size.

If the setFetchSize() method is not called on the Statement object, the default fetch size is 0. In this case the fetch size is set using the RowsToFetchPerBlock configuration option. For more information see RowsToFetchPerBlock.

Note: While setting a large fetch size value when using the result set streaming API can give you better fetch performance, it can also result in higher memory usage. This can be mitigated if the JDBC application can retrieve the result set from the connector quickly.