v.22.2Experimental Feature
Support SET, YEAR, TIME, and GEOMETRY Data Types in MaterializedMySQL
SupportSET,YEAR,TIMEandGEOMETRYdata types inMaterializedMySQL(experimental feature). Fixes #18091, #21536, #26361. #33429 (zzsmdfj).
Why it matters
This feature extends the MaterializedMySQL engine to support additional MySQL data types:SET, YEAR, TIME, and GEOMETRY. It resolves issues related to the lack of support for these types, improving data compatibility and usability when replicating or synchronizing MySQL tables with ClickHouse.How to use it
Enable the experimental support by using theMaterializedMySQL table engine as usual. The new data types will now be recognized and handled correctly without additional configuration. Since it is experimental, testing in a controlled environment before production use is recommended.