hive | o.a.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

Question

问题遇到的现象和发生背景

hive on spark
flink任务中使用JDBC连接hive，数据入库，每次都是程序运行大概几个小时会报错误，hiveserver2停止，不知道是做什么原因导致该问题，没有找到相关日志。

问题相关代码，请勿粘贴截图

insert sql语句

运行结果及报错内容

java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
    at org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:334) ~[hive-jdbc-3.1.2.jar:3.1.2]
    at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:265) ~[hive-jdbc-3.1.2.jar:3.1.2]
    at org.apache.hive.jdbc.HiveStatement.executeUpdate(HiveStatement.java:511) ~[hive-jdbc-3.1.2.jar:3.1.2]
    at org.apache.hive.jdbc.HivePreparedStatement.executeUpdate(HivePreparedStatement.java:122) ~[hive-jdbc-3.1.2.jar:3.1.2]
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[HikariCP-java7-2.4.12.jar:?]
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) 

Answer 1

[HIVE-22196] Socket timeouts happen when other drivers set DriverManager.loginTimeout - ASF JIRA
程序中使用的Hutool的Db工具类
使用hive时调用setLoginTimeout，方法以下，是否能彻底解决该问题还需要验证

private static void setLoginTimeout(String groupName) {
        if (DbGroupEnum.HIVE.getName().equals(groupName)) {
            PooledDataSource.getDataSource(groupName).setLoginTimeout(30000);
        }
    }

新问题：https://ask.csdn.net/questions/7605535?spm=1001.2014.3001.5505