3.3.0 catalog问题

3.3.0 创建JDBC-catalog连接2.3.13的starrocks,查询提示表不存在(show tables/databases正常),同样的操作3.2.4可以查询

报错内容:ERROR 5502 (42602): Getting analyzing error. Detail message: Unknown table
语句:CREATE EXTERNAL CATALOG sr_old
PROPERTIES
(
“type”=“jdbc”,
“user”="",
“password”="",
“jdbc_uri”="jdbc:mysql:// ",
“driver_url”=“https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar”,
“driver_class”=“com.mysql.cj.jdbc.Driver”
);

3.2.4 和 3.3.0 创建catalog的命令是一样的么,fe日志里有什么详细的日志信息么

catalog的创建命令是一样的

2024-07-01 20:15:00.560+08:00 INFO (starrocks-mysql-nio-pool-2984|415668) [MetadataMgr$QueryMetadatas.getConnectorMetadata():107] Succeed to register query level connector metadata [catalog:sr_old, queryId: 89f66d8a-37a3-11ef-9e55-8a32d72586a5]
2024-07-01 20:15:00.584+08:00 WARN (starrocks-mysql-nio-pool-2984|415668) [Slf4JLogger.warn():99] Error: 1064-HY000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘UNSIGNED’ at line 1
2024-07-01 20:15:00.584+08:00 WARN (starrocks-mysql-nio-pool-2984|415668) [JDBCMetadata.lambda$getTable$1():211] get table for JDBC catalog fail!
java.sql.SQLException: (conn=39219) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘UNSIGNED’ at line 1

请检查下查询表的语句是不是正确

select * from $tb limit 2;


会和JDK版本有关系吗,我看3.3.0的JDK需要用11 但是3.2.4用的是JDK8

完整的“jdbc_uri”="jdbc:mysql:// ",发一下,ip可以码住

CREATE EXTERNAL CATALOG sr_old
PROPERTIES
(
“type”=“jdbc”,
“user”="",
“password”="",
“jdbc_uri”="jdbc:mysql://$ip:9030 ",
“driver_url”=“https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar”,
“driver_class”=“com.mysql.cj.jdbc.Driver”
);

正式创建时端口后面也有个空格么

嗯对 有的

您删除catalog,删除空格重新创建试下