[Bug] after use Mutil-Catalog JDBC connect to clickhouse, simple select query random report two exception.

[itsallsame]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

doris: 1.2.2 clickhouse: 21.3.6

What's Wrong?

Clickhouse-catalog: CREATE CATALOG clickhouse PROPERTIES ( "type"="jdbc", "user"="someuser", "password"="xxx", "jdbc_url" = "jdbc:clickhouse://clickhouse21:8123/dim", "driver_url" = "clickhouse-jdbc-0.3.2-patch11-all.jar", "driver_class" = "com.clickhouse.jdbc.ClickHouseDriver" );

show catalogs: ;

however, when i use select query, random report two exception:

1. [HY000][1105] errCode = 2, detailMessage = Fail to convert jdbc type of com.clickhouse.data.value.UnsignedInteger to doris type BIGINT on column: uid. You need to check this column type between external table and doris table.
2. [HY000][1105] errCode = 2, detailMessage = NoClassDefFoundError: com/clickhouse/client/ClickHouseClientBuilder$DummyClient

query: select id from table_name limit 1; in clickhouse id's type is UInt32.

What You Expected?

select query run without exception

How to Reproduce?

No response

Anything Else?

i try jdbc driver clickhouse-jdbc-0.4.0-all.jar, but it does not work.

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct