bryan
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: Generic JDBC ClickHouse live model with custom dialect
Hi DRay, Thank you for your response. Yes, we would appreciate getting a technical resource involved to help with our project. You can send me a private message if you need more information to contact me. Thank you, Bryan2.1KViews0likes0CommentsRe: Generic JDBC ClickHouse live model with custom dialect
Hi DRay , Thank you for the update. While we wait for the official Clickhouse connector, could you let us know if there is a custom dialect for Clickhouse that your team might have developed internally? It would be incredibly helpful for our current project. Looking forward to your response. Thank you, Bryan2.2KViews0likes0CommentsGeneric JDBC ClickHouse live model with custom dialect
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.java I 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? ThanksSolved2.4KViews0likes9Comments