✅ Unknown database 'default_cluster:undefined'

使用jdbc连接clickhouse或mysql(8)时,创建catalog提示
Execution failed: Error Failed to execute sql: java.sql.SQLSyntaxErrorException: (conn=18) errCode = 2, detailMessage = Unknown database ‘default_cluster:undefined’
异常。

– clickhouse catalog
CREATE CATALOG jdbc_clickhouse PROPERTIES (
“type”=“jdbc”,
“user”=“xx”,
“password”=“xx”,
“jdbc_url” = “jdbc:clickhouse://127.0.0.1:8123/dev_lake@cluster_devlake”,
“driver_url” = “clickhouse-jdbc-0.4.2.jar”,
“driver_class” = “com.clickhouse.jdbc.ClickHouseDriver”
);

– mysql catalog
CREATE CATALOG jdbc_mysql PROPERTIES (
“type”=“jdbc”,
“user”=“xx”,
“password”=“xx”,
“jdbc_url” = “jdbc:mysql://127.0.0.1:3306/lake”,
“driver_url” = “mysql-connector-java-8.0.30.jar”,
“driver_class” = “com.mysql.cj.jdbc.Driver”
);

【组件版本】
doris版本 2.0.1
clickhouse 22.12.6.22
mysql 8.0.26

确认下 数据库所在的网络和 Doris 是否连通,其次,jdbc driver 使用https://github.com/ClickHouse/clickhouse-java/releases/download/v0.4.2/clickhouse-jdbc-0.4.2-all.jar
,如果仍有问题,可以添加我的微信 zyk815574403详细看下