flink-cdc icon indicating copy to clipboard operation
flink-cdc copied to clipboard
verified publisher icon apache

SqlServer 的TIMESTAMP类型无法转换为合法的flinkSQL的数据类型

Open Adiao512 opened this issue 3 years ago • 1 comments

The value type of XDBMASK field is TIMESTAMP in SqlServer (this field data is binary in SqlServer), but the value type of XDBMASK field is BIGint in mysql，When data is synchronized from SqlServer to mysql via Flink-CDC, the data is converted to FlinkSQL's data type as a bunch of Java objects (java.nio.heapByteBuffer [pos=0 lim=8 cap=8])，Unable to write to mysql ea8b1f76e95da94d3223e3d0d98c8e1

Adiao512 avatar Aug 18 '22 02:08 Adiao512

Hi @Adiao512 , Can you supply sql script and data to reproduce the issue ?

GOODBOY008 avatar Aug 19 '22 01:08 GOODBOY008

Closing this issue because it was created before version 2.3.0 (2022-11-10). Please try the latest version of Flink CDC to see if the issue has been resolved. If the issue is still valid, kindly report it on Apache Jira under project Flink with component tag Flink CDC. Thank you!

PatrickRen avatar Feb 28 '24 15:02 PatrickRen