[HIVE-12371] Adding a timeout connection parameter for JDBC

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: JDBC
• Labels: pull-request-available
• Target Version/s: 1.3.0
• Assignee: Xi Chen
• Reporter: Nemon Lou
• Created: 09/Nov/15 13:02
• Updated: 09/May/24 00:20
• Resolved: 16/Feb/21 17:55

Description

There are some timeout settings from server side:
HIVE-4766
HIVE-6679
Adding a timeout connection parameter for JDBC is useful in some scenario:
1,beeline (which can not set timeout manually)
2,customize timeout for different connections (among hive or RDBs,which can not be done via DriverManager.setLoginTimeout())
Just like postgresql,

jdbc:postgresql://localhost/test?user=fred&password=secret&ssl=true&connectTimeout=0

or mysql

jdbc:mysql://xxx.xx.xxx.xxx:3306/database?connectTimeout=60000&socketTimeout=60000

Issue Links

• Is contained by: HIVE-26751 Bug Fixes and Improvements for 3.2.0 release
• relates to: HIVE-14517 Hive JDBC driver login timeout used as socket timeout
• links to: GitHub Pull Request #1611
• links to: GitHub Pull Request #4964