Generic JDBC ClickHouse live model with custom dialect | Help and How-To

bryan · 2024-07-04T14:53:43.512000Z

Hello,I am using a Generic JDBC driver to query our ClickHouse cluster. It works quite well on ElasticCube, except for handling date types and date functions. Therefore, I would like to use a live model with a custom dialect. However, I haven't found any documentation about that. I noticed that the analytical engine is enabled for my connector and that it's based on Apache Calcite. Additionally, I saw that there is a custom dialect for ClickHouse in the Apache Calcite project.https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/dialect/ClickHouseSqlDialect.javaI tried to download the Java file for ClickHouse dialect and upload it, but it doesn't seem to work as expected. Although no errors appeared in the UI, I noticed a 400 error in the network with the following message:"Failed to update dialect with response = ServiceResponse(status=INSTALL_DIALECT_FAILED, value=null, error=Failed to validate Dialect for connector GenericJDBC_clickhouse, statusCode=0), for connector GenericJDBC_clickhouse."Could you help me figure it out?Thanks

MoreDiscussions

Generic JDBC ClickHouse live model with custom dialect | Help and How-To | Sisense Community