[HIVE-28399] Improve the fetch size in HiveConnection

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0, 4.0.1
• Labels: hive-4.0.1-merged hive-4.0.1-must pull-request-available
• Assignee: Zhihua Deng
• Reporter: Zhihua Deng
• Created: 24/Jul/24 04:11
• Updated: 24/Sep/24 02:15
• Resolved: 21/Aug/24 08:45

Description

If the 4.x Hive Jdbc client connects to an older HS2 or other thrift implementations, it might throw the IllegalStateException: https://github.com/apache/hive/blob/master/jdbc/src/java/org/apache/hive/jdbc/HiveConnection.java#L1253-L1258, as the remote might haven't set the property:  
hive.server2.thrift.resultset.default.fetch.size back to the response of OpenSession request. It also introduces the confusing on what the real fetch size the connection is, as we have both initFetchSize and defaultFetchSize in this HiveConnection, the HiveStatement checks the initFetchSize, defaultFetchSize and 
HIVE_SERVER2_THRIFT_RESULTSET_DEFAULT_FETCH_SIZE.defaultIntVal to obtain the real fetch size, we can make them one in HiveConnection, so every statement created from the connection uses this new fetch size.
 

Issue Links

• links to: GitHub Pull Request #5362