Details
Description
When using the Hive JDBC driver, you can execute a Hive query and obtain a HiveResultSet instance that contains the results of the query.
Unfortunately, HiveResultSet can then only fetch a single row of these results from the Hive server at a time. As a consequence, it's extremely slow to fetch a resultset of anything other than a trivial size.
It would be nice for the HiveResultSet to be able to fetch N rows from the server at a time, so that performance is suitable to support applications that provide human interaction.
(From memory, I think it took me around 20 minutes to fetch 4000 rows.)