【已解决】关联mysql catalog查询报错

Viewed 43

版本:2.1.0
通过jdbc catalog 建立mysql catalog,mysql驱动mysql-connector-java-5.1.49
多表关联查询报错,信息如下:

ERROR 1105 (HY000): errCode = 2, detailMessage = (10.xxx.xxx.xx)[CANCELLED]UdfRuntimeException: jdbc get block address: 
CAUSED BY: SQLException: Conversion not supported for type java.math.BigInteger

补充下fe.log的报错信息:

2024-03-28 10:15:29,206 WARN (mysql-nio-pool-357|23287) [StmtExecutor.sendResult():1693] cancel fragment query_id:2780723ef41649c9-932e21e7ef5901c5 cause errCode = 2, detailMessage = (10.xxx.xxx.xxx)[CANCELLED]UdfRuntimeException: jdbc get block address: 
CAUSED BY: SQLException: Conversion not supported for type java.math.BigInteger
2024-03-28 10:15:29,206 WARN (mysql-nio-pool-357|23287) [ConnectProcessor.handleQueryException():335] Process one query failed because.
org.apache.doris.common.UserException: errCode = 2, detailMessage = (10.xxx.xxx.xxx)[CANCELLED]UdfRuntimeException: jdbc get block address: 
CAUSED BY: SQLException: Conversion not supported for type java.math.BigInteger
	at org.apache.doris.qe.Coordinator.getNext(Coordinator.java:1362) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:1626) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1556) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.handleQueryWithRetry(StmtExecutor.java:708) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.executeByNereids(StmtExecutor.java:660) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:493) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:472) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:265) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:183) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:176) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:205) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:258) ~[doris-fe.jar:1.2-SNAPSHOT]
	at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352]
	at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352]
1 Answers

换成 mysql8.0.25 以上 的 jdbc driver试试