v.20.10New Feature

Supporting MySQL decimal and datetime types in ClickHouse

Official CH changelog text
Supporting MySQL types: decimal (as ClickHouse Decimal) and datetime with sub-second precision (as DateTime64). #11512 (Vasily Nemkov).
Support for importing MySQL decimal type as ClickHouse Decimal and MySQL datetime with sub-second precision as ClickHouse DateTime64.

Why it matters

This feature enables accurate and precise data type mapping when replicating or migrating data from MySQL to ClickHouse, preserving decimal precision and sub-second datetime information. It resolves the problem of losing precision or incompatible type conversions, enhancing data fidelity and usability for analytics.

How to use it

When using MySQL data sources or replication tools that connect to MySQL, the decimal and datetime types will be automatically mapped to ClickHouse Decimal and DateTime64 respectively. Users do not need to manually convert these types as the feature supports native handling during data ingestion.

Related resources

PreviousNext