...
jdbc:hive2://<host>:<port>/<db>;fetchsize=<value>
Info | ||
---|---|---|
| ||
The Hive JDBC driver will receive a preferred fetch size from the instance of HiveServer2 it has connected to. This value is specified on the server by the hive.server2.thrift.resultset.default.fetch.size configuration. The JDBC fetch size is only a hint and the server will attempt to respect the client's requested fetch size though with some limits. HiveServer2 will cap all requests at a maximum value specified by the hive.server2.thrift.resultset.max.fetch.size configuration value regardless of the client's requested fetch size. While a larger fetch size may limit the number of round-trips between the client and server, it does so at the expense of additional memory requirements on the client and server. The default JDBC fetch size value may be overwritten, per statement, with the JDBC API:
|
...