[GitHub] [doris] itsallsame opened a new issue, #16912: [Bug] after use Mutil-Catalog JDBC connect to clickhouse, simple select query random report two exception.

[via GitHub]

itsallsame opened a new issue, #16912:
URL: https://github.com/apache/doris/issues/16912

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) 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:
   <img width="626" alt="image" 
src="https://user-images.githubusercontent.com/115528312/219934390-00b82d07-c7f6-41e8-b07c-69edeb87170a.png";>
   ;
   
   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
   
   
   
   ### 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](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org