异常:
ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 159, host: 10.10.1.11, port: 8123; Read timed out
Caused by: java.net.SocketTimeoutException: Read timed out
解决:
(1)在代码中配置sql执行超时间;经测试这个配置未生效,到30s依然报错
PreparedStatement ps= null; ps= con.prepareStatement(sql); ps.setQueryTimeout(2000);
(2)数据库连接参数配置方式,URL增加?socket_timeout=30000
弊端:不好确定超时时间,sql设置多久可执行完
(3)配置为socket_timeout=0
0:直到sql执行完毕
示例:jdbc:clickhouse://x.x.x.x:port/default?socket_timeout=0