Is there any way to support the Bit DataType of Mysql ？

[zhaohaoren]

I have a mysql table with a bit column:

and create a mysql engine table in clickhouse:

CREATE TABLE t_xxxx(
is_deleted UInt8
) ENGINE = MySQL

when query the table, reponse the follow error:
[2021-03-10 13:24:11] Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = mysqlxx::CannotParseValue: Cannot parse unsigned integer: �, query: SELECT is_deletedFROMtable (version 20.10.3.30 (official build))

I try to use Int8 and String to map this column, but it doesn‘t work very well，is there any other solutions to deal with this problem?

[filimonov]

#14735

[holadepo]

This workaround should work:

• Create the table using the String data type for the MySQL bit column

CREATE TABLE t_xxxx(
  is_deleted String
) ENGINE = MySQL

• Then use the reinterpretAsUInt8 function to map the column to UInt8 in your select statement.
  SELECT reinterpretAsUInt8(is_deleted) FROM t_xxxx

[tavplubix]

#32900