metabase-clickhouse-driver

metabase-clickhouse-driver copied to clipboard

driver issue on toDate function inconsistent result with native cli

4

### Describe the bug when using toDate function the result is not the same as not running with toDate or with the result of running on Clickhouse-client ### Steps to...

AfrouzMashayekhi

JSON unfolding / nested objects

7

### Describe the bug Nested JSON object are not rendered / queryable ### Steps to reproduce 1. Load a Clickhouse table containing nested objects 2. See the table / try...

atillier

Add fully fledged time zones support

4

Despite ClickHouse itself featuring great time zone(s) support, these two driver features were _never enabled_: ``` :set-timezone :convert-timezone ``` There was a draft attempt from me recently, with this snippet...

slvrtrn

Fields of AggregateFunction type omitted from preview and erroring in Query Editor

2

### Describe the bug I have a table that is `ReplicatedAggregatingMergeTree`, and several fields that have the type `AggregateFunction(avg, Float64)`. When querying this table via the Clickhouse CLI, I'm able...

wickyvinn

`SET ROLE` statement problem on clustered instances

10

### Describe the bug `SET` statement is not working with clustered instances See https://github.com/ClickHouse/ClickHouse/discussions/40924 ### Steps to reproduce 1. Install the latest version of driver 2. Bring up a clickhouse...

mhkarimi1383

- Check if it works with e.g. BigDecimal properly - Write some additional driver tests

slvrtrn

"Week" aggregation is inconsistent with setting "Start of the week" is set to "Monday"

4

**Describe the bug** Hi! When setting "Start-of-the-week" is set to "Monday" and when we use a query builder then a weekly aggregation query gets wrong result - the first day...

ppavlov39

Missing Metabase features

5

During the last year of releases, we were mainly focused on addressing the breaking changes affecting the driver and fixing bugs. However, we were not as focused on implementing the...

slvrtrn

Seems that doing a self join will build a query that won't work in Clickhouse:  sql:  ``` Code: 352. DB::Exception: Ambiguous column 'ecommerce.ecommerce_sanitized.event_time': While processing ecommerce.ecommerce_sanitized.event_time AS event_time....

paoliniluis

Error in the connection causes Snowflake exception

5

### Describe the bug When there's an error in the connection, the exception thrown is "Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: Connection string is invalid. Unable to parse." ### Steps to reproduce 1)...

paoliniluis