dingxiaobo
dingxiaobo
@dingxiaobo 同步数据到clickhouse的datetime64类型,会丢失精度 sqlserver原表字段类型:datetime(3)  clickhouse字段类型:datetime64  _Originally posted by @MrZhao1024B in https://github.com/alibaba/DataX/issues/1465#issuecomment-1276955878_
solve https://github.com/shyiko/mysql-binlog-connector-java/issues/240
mysql datetime support percision(0-6) since 5.7 https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html test table: ``` CREATE TABLE `table_time` ( `id` bigint(20) NOT NULL, `Column1-time` time DEFAULT NULL, `Column1-timestamp` timestamp(6) NULL DEFAULT NULL, `Column1-date` date DEFAULT...