Felix Mueller comments

Results 56 comments of


                                            Felix Mueller

can you support foreign key?

I hope that it works OK for now

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))

Unfortunately, we need to use `parseDateTimeBestEffort` for some queries. Have you asked ClickHouse team if they plan to support comparison between these data types (even for key fields)? [The manual](https://clickhouse.tech/docs/en/sql-reference/data-types/datetime64)...

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))

Thanks @den-crane ! However, we don't know the data type of the column up front. Comparing with `DateTime` just worked fine for `Date` and `DateTime` columns, that's why I used...

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))

Yes, comparing `DateTime64` values against `DateTime64` columns works fine, but comparison with `Date` or `DateTime` (my example from above) columns does not work. I had never heard about the `materialize`...

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))

Good news, @jjtjiang the new driver version should play better with `DateTime64` columns. ```sql CREATE TABLE felix.dt64test ( `myTime` DateTime64(3) DEFAULT now(), `otherCol` String ) ENGINE = Memory ``` ```sql...

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))

Should be fixed

Felix Mueller

can you support foreign key?

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))

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))

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))

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))

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))

Not found column <table_name>._sign in block. (NOT_FOUND_COLUMN_IN_BLOCK)

Support for WITH TOTALS

Request error when filtering by field

Broken Enum in Metabase 0.40.3.1