Skip to main content
Skip to main content
Edit this page

ClickPipes for MySQL: Supported data types

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

MySQL TypeClickHouse typeNotes
EnumLowCardinality(String)
SetString
DecimalDecimal
TinyIntInt8Supports unsigned.
SmallIntInt16Supports unsigned.
MediumInt, IntInt32Supports unsigned.
BigIntInt64Supports unsigned.
YearInt16
TinyText, Text, MediumText, LongTextString
TinyBlob, Blob, MediumBlob, LongBlobString
Char, VarcharString
Binary, VarBinaryString
TinyInt(1)Bool
JSONStringMySQL only; MariaDB json is just an alias for text with a constraint.
Geometry & Geometry TypesStringWKT (Well-Known Text). WKT may suffer from small precision loss.
VectorArray(Float32)MySQL only; MariaDB is adding support soon.
FloatFloat32Precision on ClickHouse may differ from MySQL during initial load due to text protocol.
DoubleFloat64Precision on ClickHouse may differ from MySQL during initial load due to text protocol.
DateDate3200 day/month mapped to 01.
TimeDateTime64(6)Time offset from unix epoch.
Datetime, TimestampDateTime64(6)00 day/month mapped to 01.