Set up docs MCPHere 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. |