ClickHouse / metabase-clickhouse-driver

ClickHouse database driver for the Metabase business intelligence front-end
Apache License 2.0
461 stars 84 forks source link

Date bucketing fixes #163

Closed slvrtrn closed 1 year ago

slvrtrn commented 1 year ago

Summary

The issue here was mainly in the ResultSet values extraction. After the introduction of the new value wrappers in the JDBC driver, integer types were cast to strings by default, and Metabase UI did not like that. Surprisingly, most of the other stuff was still working as expected.

The charts look better now (my Metabase instance's week starts on Sunday):

image image image image

NB: "53rd" week resets to the "1st" again, and it was reported in the main Metabase repo. That is odd behavior; I wasn't able to figure out a fix on the driver level.

image

Checklist