datax从PostgreSQL同步数据到SQLServer,执行发现,日志信息中显示类型为uuid报错,具体解决方式就是对uuid类型的字段进行类型转换 "id::text"。例如:
{
"job": {
"setting": {
"speed": {
"channel": 3,
"byte": 1048576
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "postgresqlreader",
"parameter": {
"username": "JQGQUikw==",
"password": "TGKpc8OHAQ==",
"where": "deleted=false",
"column": [
"id::text",
"tenantid::text",
"type",
"username",
"password",
"name",
"phone",
"email",
"status",
"islock",
"closedtime",
"closedby::text",
"createdtime",
"createdby::text",
"modifiedtime",
"modifiedby::text",
"deleted",
"deletedtime",
"deletedby::text"
],
"splitPk": "",
"connection": [
{
"table": [
"admin.account"
],
"jdbcUrl": [
"jdbc:postgresql://xxxx.xxxx.xxxx.xxxx:xxx/testpostgres"
]
}
]
}
},
"writer": {
"name": "sqlserverwriter",
"parameter": {
"username": "xxxxx",
"password": "xxxxx",
"column": [
"[Id]",
"[TenantId]",
"[Type]",
"[UserName]",
"[Password]",
"[Name]",
"[Phone]",
"[Email]",
"[Status]",
"[IsLock]",
"[ClosedTime]",
"[ClosedBy]",
"[CreatedTime]",
"[CreatedBy]",
"[ModifiedTime]",
"[ModifiedBy]",
"[Deleted]",
"[DeletedTime]",
"[DeletedBy]"
],
"preSql": [
"DELETE FROM Account"
],
"connection": [
{
"table": [
"dbo.Account"
],
"jdbcUrl": "jdbc:sqlserver://xxxx.xxxx.xxxx.xxx:xxxx;DatabaseName=test"
}
]
}
}
}
]
}
}