Supported data types

Here is the supported data-type mapping for the MySQL ClickPipe:

MySQL Type	ClickHouse type	Notes
Enum	LowCardinality(String)
Set	String
Decimal	Decimal(76,38)	Values exceeding 38 integer digits are ingested as zero.
Bit	UInt64
TinyInt	Int8	Supports unsigned.
SmallInt	Int16	Supports unsigned.
MediumInt, Int	Int32	Supports unsigned.
BigInt	Int64	Supports unsigned.
Serial	UInt64
Year	Int16
TinyInt(1)	Bool
Float	Float32	Precision on ClickHouse may differ from MySQL during initial load due to text protocol. Float(p) maps to Float32 for p <= 24 and Float64 for p >= 25.
Double	Float64	Precision on ClickHouse may differ from MySQL during initial load due to text protocol.
TinyText, Text, MediumText, LongText	String
TinyBlob, Blob, MediumBlob, LongBlob	String
Char, Varchar	String
Long, Long Varchar	String
Binary, VarBinary	String
Long VarBinary	String
JSON	String	MySQL only; MariaDB json is just an alias for text with a constraint.
Geometry & Geometry Types	String	WKT (Well-Known Text). WKT may suffer from small precision loss.
UUID	UUID	MariaDB only. Columns added during CDC are added as String holding the raw 16 bytes.
INET4, INET6	String	MariaDB only.
Vector	Array(Float32)	MySQL only; MariaDB is adding support soon.
Char Byte, Raw	String	MariaDB/Oracle-mode aliases for binary types.
Clob, Varchar2, XMLType	String	MariaDB/Oracle-mode aliases for text types.
Number	Decimal	MariaDB/Oracle-mode alias for Decimal.
Date	Date32	00 day/month mapped to 01.
Time	DateTime64(6)	Time offset from unix epoch.
Datetime, Timestamp	DateTime64(6)	00 day/month mapped to 01.