2025年sqlldr 导入clob（sqlldr 导入报错）

科技前沿 • 2025-04-21 18:53 • 阅读 52

大家好，我是讯享网，很高兴认识大家。

 <p><p>sqlserver字段属性未自定义类型<img src="https://ucc.alicdn.com/pic/developer-ecology/zvlpmaxayqm7u_6e49622b9cbd34e022b3983.png" alt="image.png" /><img src="https://ucc.alicdn.com/pic/developer-ecology/zvlpmaxayqm7u_ba73a0fdb22c404a951e86c83df2fff3.png" alt="image.png" /></p>

讯享网

在同步到mysql的表中：

讯享网
使用flinksql去创建表同步到库里发现flink不支持这个自定义类型会报错：
Don t support SqlSever type uid_exch yet, jdbcType: -5 .
以下是flink建表同步语句求大佬帮忙看看：
CREATE TABLE CARGO (
CGO_ID BIGINT,
CGO_MBL_NO STRING,
CGO_CN_REAL STRING,
CGO_ETD_POL TIMESTAMP,
CGO_ATD_POL TIMESTAMP,
CGO_ETD_POD TIMESTAMP,
CGO_ATD_POD TIMESTAMP
) WITH (
‘connector’ = ‘sqlserver-cdc’,
‘hostname’ = ‘172.17.xxxx’,
‘port’ = ‘1433’,
‘username’ = ‘xxx’,
‘password’ = ‘xxx’,
‘database-name’ = ‘xx’,
‘table-name’ = ‘dbo.CARGO’
);

CREATE TABLE TMS_CARGO_SINK (
CGO_ID BIGINT,
CGO_MBL_NO STRING,
CGO_CN_REAL STRING,
CGO_ETD_POL TIMESTAMP,
CGO_ATD_POL TIMESTAMP,
CGO_ETD_POD TIMESTAMP,
CGO_ATD_POD TIMESTAMP,
PRIMARY KEY(CGO_ID) NOT ENFORCED
) WITH (
‘connector’ = ‘jdbc’,
‘url’ = ‘jdbc:mysql://xxx’,
‘table-name’ = ‘tms_cargo’,
‘username’ = ‘xx’,
‘password’ = ‘xx’,
‘driver’ = ‘com.mysql.cj.jdbc.Driver’
);

INSERT INTO TMS_CARGO_SINK SELECT * FROM CARGO

2025年sqlldr 导入clob（sqlldr 导入报错）

相关推荐