Does shardingsphere support clickhosue?

[niushaoda]

Does shardingsphere support clickhosue?

[niushaoda]

Caused by: java.lang.UnsupportedOperationException: Unsupported database from url: 'jdbc:clickhouse:

[linghengqian]

• Can you create a git containing minimal reproducible unit tests using testcontainers including clickhouse? The unit tests never tested clickhouse, but the related testcontainers url.

[Afsalmc]

Same experience with Vertica DB. If It has a jdbc driver the support should be there cause shardingsphere jdbc supports jdbc standard right?

[linghengqian]

Same experience with Vertica DB. If It has a jdbc driver the support should be there cause shardingsphere jdbc supports jdbc standard right?

• That's right, as long as a JDBC driver exists, the corresponding data source can be included in ShardingSphere's metadata.

• @Afsalmc Can you provide a git containing unit tests using testcontainers? I need to know exactly what class is causing this type of problem.

[linghengqian]

• While investigating the usability of testcontainers under GraalVM Native Image, I noticed design issues with certain PRs for some related classes. I've opened Parse unadapted Database to SQL92 dialect and add support for JDBC URLs for commonly used testcontainers #29291 .

• The current issue still lacks example git to assist in reproduction.

[linghengqian]

• @Afsalmc I added the description of databases without community LICENSE such as Vertica DB via javadoc in Convert DatabaseTypes for Clickhouse and common testcontainers #29297. In general, you need to implement the Vertica DB dialect yourself, and before implementing it you can manually port it to a known SQL dialect implementation, such as MySQL or SQL92.
• @niushaoda Clickhouse is now parsed through the MySQL dialect, but in order to get rid of the MySQL dialect, the relevant sub-modules of clickhouse need to do more SPI implementation, which requires someone to know the specific content of the Clickhouse dialect.

[linghengqian]

• I checked the PR of the testcontainers community for the Vertica module Proposed Vertica CE module (JDBC, Data Warehouse) - MVP for discussion testcontainers/testcontainers-java#9243, and the Vertica server and client LICENSEs even prevent the use of the Vertica database in unit tests unless the person doing the unit tests has an Express or more expensive LICENSE. The relevant implementation must be implemented by downstream.