datax从PostgreSQL同步数据,类型为uuid报错解决

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"
              }
            ]
          }
        }
      }
    ]
  }
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

M_pengpeng

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值