Question: How to prevent repeated execution for a wrong query?
alex-bochkov opened this issue · 2 comments
Is there a way to prevent repeated query execution when it fails?
Currently, clickhouse-jdbc-bridge retries the query 10 times before returning the failure to the client.
(sorry, I couldn't find any parameters in the config).
Hi @alex-bochkov, thanks for reporting the issue. I can reproduce the issue using a query like select * from jdbc('mysql1','a1 String', 'select a1'). There's a release planned this weekend(primarily to rename packages to com.clickhouse), let me see if I can get it fixed. Meanwhile, I suspect there's issue in your question - you may remove the second parameter for testing, although it may introduce additional query for type inferring.
Update: I think it's more of a server side issue and created a ticket to track status. A workaround is to use named query like this.
Close as it's not an issue with JDBC bridge.