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，删除空格重新创建试下
看下我的回复，我的没有空格，也是报错查不到表，但是show table 和 show databases 都正常
