doris4.0.5 arm版本,通过resource访问2.1.4版本的doris集群报错

Viewed 7

sql语句如下
create resource doris_resource_test properties(
"type"="jdbc",
"user" ="xxxx"
"password" ="xxxxxx"
"jdbc_url"="jdbc:mysql://xxx.xxx.xxx.xxx:9030/test"
"driver_url"="mysql-connector-java-8.2.0.jar",
"driver_class"="com.mysql.cj.jdbc.Driver";

create catalog doris_catalog_test with resource doris_resource_test
fe.log的报错如下
org.apache.doris.common.Nereidsexception:errCode =2,detailMessage=Failed to parse db type from jdbcUrl:
atorg.apache.doris.qe.StmtExecutor.executeBynereids(stmtExecutor.java:713)
atorg.apache.doris.qe.Stmtexecutor.execute(stmtExecutor.java:542)
atorg.apache.doris.qe.Stmtexecutor.queryretrystmtexecutor.java:501)
atorg.apache.doris.qe.stmtexecutor.execute(Stmtexecutor.java:486)
atorg.apache.doris.qe.ConnectProcessor.executeQuery(Connectprocessor.java:312)
atorg.apache.doris.qe.Connectprocessor.handleQuery(Connectprocessor.java:199)
atorg.apache.doris.qe.mysqlconnectprocessor.handleQuerymysqlconnectprocessor.java:231)
atorg.apache.doris.qe.Mysqlconnectprocessor.dispatch(Mysqlconnectprocessor.java:259)
atorg.apache.doris.qe.Mysqlconnectprocessor.processonce(MysqlconnectProcessor.java:403)
atorg.apache.doris.mysql.Readlistener.lambdashandleEvento(Readlistener.java:52)
atjava.base/java.util.concurrent.ThreadpoolExecutor.runworker(ThreadPoolExecutor.java:1136)
atjava.base/java.util.concurrent.ThreadPoolexecutorsworker.run(ThreadPoolexecutor.java:635)
atjava.base/java.lang.Thread.run(Thread.java:833)
Causedby:org.apache.doris.common.Analysisexception:errcode2,detailmessage-Failedtoparsedbtypefromjdbcurl
..13 more
atorg.apache.doris.datasource.jdbc.client.Jdbcclient.createjdbcclient(dbcclient.java:74)
atol
atorg.apache.oris.daaource.jdc.dcxrnalcatalg.sonnectiondxrnalcatalog.java:88
atorg.apache.doris.datasource.jdbc.cextralcatalog.chckwhncreatingdcexternalcatalog.java:333)
atorgcheoris.uce.alocrycatcalgaalacoryjava:130
atorg.apache.doris.datasurce.cataloactory.createfrmcoandataloactoryjava:60)
ao.
atorg.apache.doris.nereids.trees.lans.comands.cratcatalommand.un(createcatalommand.java:91
atorg-apache.doris.qe.Stmtexecutor.executebyereids(Stmtexecutor.java:685)
..12 more
Causedby:org-apache.doris.common.Ddlexception:errCode=2,detailMessageUnsupportedjdbcdatabasetype,pleasecheckjdbcUrl:
atorg.apache.doris.catalog.JdbcResource.parsedbtype(Jdbcresource.java:395)
atorg.apache.doris.datasource.jdbc.client.Jdbcclient.parsedbtype(dbcclient.java:190)
...21 more。
但是直接建catalog就没问题,语句如下
create catalog doris_catalog_test properties(
"type"="jdbc",
"user" ="xxxx"
"password" ="xxxxxx"
"jdbc_url"="jdbc:mysql://xxx.xxx.xxx.xxx:9030/test"
"driver_url"="mysql-connector-java-8.2.0.jar",
"driver_class"="com.mysql.cj.jdbc.Driver")。
直接创建type类型为doris的catalog也没问题,查询数据都正常。
没有更多环境做其它测试,无法确定是否为BUG。

0 Answers