2023-11-23 01:08:11.996 [0-0-1-reader] ERROR StdoutPluginCollector - 脏数据:
{"record":[{"byteSize":8,"index":0,"rawData":20231122,"type":3},{"byteSize":4,"index":1,"rawData":"WTD1","type":5},{"byteSize":6,"index":2,"rawData":126676,"type":3}],"type":"reader","message":"类型转换错误, 无法将[\\N] 转换为[LONG]"}
如上,数据同步时发现脏数据,报类型转换错误,无法将[\\N] 转换为[LONG],原因是hive中的null值datax无法转为LONG,只需一步,指定空值格式即可。
"nullFormat":"\\\\N",