[Bug][Module Name] Ask for 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产生脏数据。
二、报错:

三、脚本
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
Assessment
This issue has not been assessed yet.