metabase-clickhouse-driver

metabase-clickhouse-driver copied to clipboard

Field filter doesnt work when using MaterializedPostgreSQL Engine with materialized_postgresql_tables_list. Example query for creating database:- `CREATE DATABASE db_name ENGINE = MaterializedPostgreSQL('host:5432', 'db_nm, 'user', 'pass') SETTINGS materialized_postgresql_tables_list = 'schema_name.table_name', materialized_postgresql_tables_list_with_schema =...

ghost

Group by datetime field fail

9

when group by datatime field, metabase failed: ``` ClickHouse exception, code: 215, host: xx, port: 8123; Code: 215, e.displayText() = DB::Exception: Received from xx:9000. DB::Exception: Column `first_time` is not under...

mkdym

Broken Enum in Metabase 0.40.3.1

3

In Metabase **0.38.2** all was working excellent. Upgrading has broken display Enum. Other types works. Driver version: **0.7.5** Full trace: ``` [7436e1b1-ee71-43ef-a33d-3514e7e96085] 2021-08-29T21:33:38+03:00 ERROR metabase.sync.analyze.query-results Error generating insights for column:...

grkhr

Additional JDBC options not apply

3

By default, our user costs 10 million lines per read. But for certain groups of users we extend this with the parameter `max_rows_to_read`. Now we use Redash, and it works...

sergeymong

DB::Exception: Key expression contains comparison between inconvertible types: DateTime64(3) and DateTime inside entry_time >= parseDateTimeBestEffort('2021-01-15 00:00:00') (version 20.8.4.11 (official build))

7

when use the DateTime(64) field to filter,it's say between time ,it will trans error . eg 'entry_time ' is DateTime(64) , it will trans to 'entry_time >= parseDateTimeBestEffort('2021-01-15 00:00:00') '....

jjtjiang

Allow blank username

1

Right now metabase will not allow adding a connection with no username but this is a valid config.

eni9889

Connection inside docker network

1

Hello, I am trying to use metabase and clickhouse with the metabase-clickhouse-driver, however, I can't manage to connect to the clickhouse database when using a bridge network. The metabase container...

davidpham87

Support for WITH TOTALS

1

The WITH TOTALS query runs fine but I do not see the totals output anywhere. Is it possible to support this in Metabase?

eni9889

The substring function does not work as expected for custom fields.  In Metabase, the indices seem to be 0-based, whereas ClickHouse [substring function](https://clickhouse.tech/docs/en/sql-reference/functions/string-functions/#substring) expects indices to be 1-based: >...

enqueue

When filtering on a custom field (via expression), the driver uses the human-readable field name instead of the correct alias. ``` SELECT source.warennummerKN8 AS warennummerKN8, source.`sum-where` AS `sum-where`, source.`sum-where_2` AS...

enqueue