canal 报错：cannot write xcontent for unknown value of type class java.sql.Timestamp"

全量同步报错

{"succeeded":false,"resultMessage":"导入ES 数据：0 条","errorMessage":"topicanalysismsg etl failed! ==>cannot write xcontent for unknown value of type class java.sql.Timestamp"}

参考文档：https://blog.csdn.net/lizz861109/article/details/113184746

es中字段类型为date，而mysql类型为datetime类型， es客户端不支持对java.sql.Timestamp类型转换为字符串。

 sql: "select id,date_format(createtime,'%Y-%m-%d %H:%I:%S') createtime  from test_user"