ClickHouse exception, message: Error parsing 'true' as java.lang.Integer; For input string: "true"

[Firm]

Running query against table at clickhouse db ends with error.

Query: select * from hits_v1 where product = 'analytics' Metabase error: ClickHouse exception, message: Error parsing 'true' as java.lang.Integer; For input string: "true"

The same query with clickchouse-client works fine when executed directly to clickhouse.

Metabase version: 0.42.4 ClickHouse driver version: 0.8.1 ClickHouse version: 22.1.3.7

Upd: select count(*) from hits_v1 where product = 'analytics' works fine in Metabase.

[mlazowik]

clickhouse supports Bool (stored as UInt8) since end of 2021: https://github.com/ClickHouse/ClickHouse/pull/31072

this driver does not yet: https://github.com/enqueue/metabase-clickhouse-driver/blob/cda0e7b01e38a1bec38c91e03799c06170fc69f7/src/metabase/driver/clickhouse.clj#L190

[fermuch]

Hello. Has there been any progress on this?

[kharazi]

Any updates?

[Roman2nc]

hello, I am also requesting this correction. Thank you

[kingbabingge]

hello，I have the same problem too。

[slvrtrn]

Should be fixed in the upcoming 0.9.0 release.

[slvrtrn]

Let's keep it open until we publish the actual jar.

[stbeckers]

@slvrtrn thanks for fixing the boolean error. Do you already have a timeline when the 0.9.0 release is planned as we need it for one of our projects? 🙂

[slvrtrn]

@stbeckers 0.9.0 is out. Booleans should be fixed there. Please do not hesitate to open a new issue in case of any new findings.

[stbeckers]

Thank you very much for the quick release 🙂