通过外部表导入mysql数据， JdbcResource cannot be cast OdbcCatalogResource问题

👨🏻‍💻 技术问答 数据导入&导出
1

通过官方文档配置案例CREATE-EXTERNAL-TABLE - Apache Doris

# 先创建Resource
CREATE EXTERNAL RESOURCE "mysql_resource" 
PROPERTIES
(
  "type" = "odbc_catalog",
  "user" = "mysql_user",
  "password" = "mysql_passwd",
  "host" = "127.0.0.1",
   "port" = "8239"          
);

# 再通过Resource创建mysql外部表
CREATE EXTERNAL TABLE example_db.table_mysql
(
    k1 DATE,
    k2 INT,
    k3 SMALLINT,
    k4 VARCHAR(2048),
    k5 DATETIME
)
ENGINE=mysql
PROPERTIES
(
    "odbc_catalog_resource" = "mysql_resource",
    "database" = "mysql_db_test",
    "table" = "mysql_table_test"
)

先创建了一个jdbc Resource，然后创建了一个扩展表。这些都成功了。
但是在查询扩展表时提示Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=98159) ClassCastException, msg: java.lang.ClassCastException: org.apache.doris.catalog.JdbcResource cannot be cast to org.apache.doris.catalog.OdbcCatalogResource