DTStack / DTStack/chunjun

[Bug][Module Name] Ask for question

Open
#1,713 1 comment 0 reactions 0 assignees View on GitHub
question
Dominant language
Java
Stars
4.1k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [ ] I had searched in the [issues](https://github.com/DTStack/chunjun/issues) and found no similar question.

- [ ] I had googled my question but i didn't get any help.

- [ ] I had read the documentation: [ChunJun doc](https://dtstack.github.io/chunjun) but it didn't help me.

### Description

一、问题:Mysql 同步数据到Oracle数据库中的时候,MySQL(源端) Time 字段类型同步到Oracle(目标端) 字段类型 number产生脏数据。
二、报错:
![image](https://github.com/DTStack/chunjun/assets/101157803/ff43c706-640e-4d86-96bf-050b547061ba)
三、脚本
CREATE TABLE `xd_mysql_sources_table`
(
`BIGINT_COL` STRING,
`CHAR_COL` STRING,
`VARCHAR_COL` STRING,
`TINYTEXT_COL` STRING,
`TEXT_COL` STRING,
`MEDIUMTEXT_COL` STRING,
`LONGTEXT_COL` STRING,
`TINYINT_COL` STRING,
`SMALLINT_COL` STRING,
`MEDIUMINT_COL` STRING,
`INT_COL` STRING,
`INTEGER_COL` STRING,
`FLOAT_COL` STRING,
`DOUBLE_COL` STRING,
`DECIMAL_COL` STRING,
`TIME_COL` STRING,
`YEAR_COL` STRING,
`DATE_COL` STRING,
`DATETIME_COL` STRING,
`TIMESTAMP_COL` STRING,
`JSON_COL` STRING,
`BLOB_COL` STRING,
`LONGBLOB_COL` STRING,
`TINYBLOB_COL` STRING,
`MEDIUMBLOB_COL` STRING,
`BINARY_COL` STRING,
`VARBINARY_COL` STRING,
`BIT_COL` STRING,
`NUMERIC_COL` STRING,
`ENUM_COL` STRING,
`REAL_COL` STRING,
`POLYGON_COL` STRING,
`SET_COL` STRING,
`MULTIPOLYGON_COL` STRING,
`GEOMETRY_COL` STRING,
`GEOMETRYCOLLECTION_COL` STRING,
`POINT_COL` STRING,
`MULTIPOINT_COL` STRING,
`LINESTRING_COL` STRING,
`MULTILINESTRING_COL` STRING
)
WITH (
'table-name' = 'xd_mysql_sources_table',
'connector' = 'mysql-x',
'url' = 'jdbc:mysql://**:**/xd_datatype_maping?serverTimezone=UTC',
'username' = 'root',
'password' = 'mysql@123'
);

CREATE TABLE xd_mysql_to_oracle
(
`BIGINT_COL` STRING,
`CHAR_COL` STRING,
`VARCHAR_COL` STRING,
`TINYTEXT_COL` STRING,
`TEXT_COL` STRING,
`MEDIUMTEXT_COL` STRING,
`LONGTEXT_COL` STRING,
`TINYINT_COL` STRING,
`SMALLINT_COL` STRING,
`MEDIUMINT_COL` STRING,
`INT_COL` STRING,
`INTEGER_COL` STRING,
`FLOAT_COL` STRING,
`DOUBLE_COL` STRING,
`DECIMAL_COL` STRING,
`TIME_COL` STRING,
`YEAR_COL` STRING,
`DATE_COL` STRING,
`DATETIME_COL` STRING,
`TIMESTAMP_COL` STRING,
`JSON_COL` STRING,
`BLOB_COL` STRING,
`LONGBLOB_COL` STRING,
`TINYBLOB_COL` STRING,
`MEDIUMBLOB_COL` STRING,
`BINARY_COL` STRING,
`VARBINARY_COL` STRING,
`BIT_COL` STRING,
`NUMERIC_COL` STRING,
`ENUM_COL` STRING,
`REAL_COL` STRING,
`POLYGON_COL` STRING,
`SET_COL` STRING,
`MULTIPOLYGON_COL` STRING,
`GEOMETRY_COL` STRING,
`GEOMETRYCOLLECTION_COL` STRING,
`POINT_COL` STRING,
`MULTIPOINT_COL` STRING,
`LINESTRING_COL` STRING,
`MULTILINESTRING_COL` STRING
)
WITH (
'connector' = 'oracle-x',
'schema' = 'BI',
'url' = 'jdbc:oracle:thin:@**:**:helowin',
'table-name' = '**',
'username' = '**',
'password' = '**',
'scan.fetch-size' = '2',
'scan.query-timeout' = '10'
);
INSERT INTO xd_mysql_to_oracle
select *
from xd_mysql_sources_table;

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.