search

ClickHouse / clickhouse-jdbc-bridge

A JDBC proxy from ClickHouse to external databases
Apache License 2.0
167 stars 60 forks source link

Question: How to prevent repeated execution for a wrong query? #147

Closed alex-bochkov closed 2 years ago

alex-bochkov commented 2 years ago

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).

image

zhicwu commented 2 years ago

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.

zhicwu commented 2 years ago

Close as it's not an issue with JDBC bridge.