I’m currently trying to set up the Database connection between our Clickhouse DB and KNIME but I am unfortunately not able to register the driver via KNIME.
I’ve downloaded the JAR and when registering the driver I can’t click on OK as it’s greyed out.
I am also not able to select a driver class or use the “find the driver class” as it shows as empty.
Assuming that you can get some queries to work without timing out, I’d probably use a working query to test it. Find something that takes maybe 5 seconds to return, and set the value to something really low (zero maybe) and see if it then fails. At least this might give a clue if the parameter is having any effect. If it does, then try setting it really high so that your failing query starts to work.
I’m guessing at the parameter name (based on the stack overflow comment)
By the way, the defaults mentioned on Stack Overflow are according to some 30 seconds, and according to others 300 seconds. I assume the setting is in milliseconds, so the screenshot would set to 300 seconds, or 5 minutes.
I’m getting the timeout after probably 15-30 seconds. To be honest I didn’t really stop the time till now
The connection per se is definitely working as there are indeed smaller tables that are accessible to me. So I hope setting up the timeout works. (It worked in DBeaver at least)
Thanks for your help again! And let’s hope this is going to work. I have to say - I really don’t like Clickhouse haha.
Any custom JDBC connection parameter can be defined under above mentioned JDBC Parameters tab. You just need to write correct parameter name and value which depends on database and driver version you are using. From experience it’s best to have driver documentation close by