ClickHouse driver does not work as expected

[nuclon]

With version 0.16.0, when the connection to clickhouse is used, all queries fail with following error:

nc=Errorf msg="Error gathering metrics: [from Gatherer #1] [collector=data_check,query=test] invalid INSERT query: select 1 AS test"

Not sure, why it says "invalid INSERT query", but it seems the problem is somewhere there :)

[burningalchemist]

Hi @nuclon, could you please share your configuration (redacted)?

UPD: sql_exporter doesn't contain any db-specific code, so invalid INSERT query comes from the Clickhouse driver itself, the only occurrence found is here, which is related to the prepared statements (PrepareContext function). This won't work in the case of sql_exporter. So please make sure you use unprepared statements as stated in the docs:

[burningalchemist]

I'll convert it to discussion at the moment, you may also find related Clickhouse discussions here.

[nuclon]

Thanks for pointing to the documentation.
Adding "no_prepared_statement: true" to the metric config helped.