创建JDBC Catalog连接另一个Doris集群 中的视图查询报错

Viewed 102

求助求助!使用JDBC Catalog 连接Doris集群遇到下面问题:
Doris2.1.6版本,目标Doris集群2.1.2版本

创建JDBC Catalog连接目标集群,执行select * from table 查询有的表能成功,有的表失败报错信息:

MySQL [(none)]> select * from doris_eosp.eosp.yj_nb_temp_view;
ERROR 1105 (HY000): errCode = 2, detailMessage = [CANCELLED]UdfRuntimeException: jdbc get block address: 
CAUSED BY: NullPointerException: null

或者:

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = ()[CANCELLED]UdfRuntimeException: Initialize datasource failed: 
CAUSED BY: CommunicationsException: Communications link failure

The last packet successfully received from the server was 74,714 milliseconds ago. The last packet sent successfully to the server was 74,715 milliseconds ago.
CAUSED BY: CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 74,714 milliseconds ago. The last packet sent successfully to the server was 74,715 milliseconds ago.
CAUSED BY: EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
1 Answers

换成 mysql8.0.25 以上 的 jdbc driver看下,修复pr,https://github.com/apache/doris/pull/41234 预计合入版本2.1.7