dinky icon indicating copy to clipboard operation
dinky copied to clipboard

Oracle Date converter is not available

Open ljs033 opened this issue 1 year ago • 2 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

What happened

微信图片_20240727094340 使用oracle日期转换器存在许多问题: 1.timestamp类型无法转换成:'yyyy-MM-dd HH:mm:ss.SSS'); 2.date类型在增量写入时候没转换并把转换格式带入:TO_DATE('2025-07-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')

What you expected to happen

在整库同步中使用了日期转换器
'debezium.converters'='dinkyDateConverter', 'debezium.dinkyDateConverter.type'='org.dinky.cdc.debezium.converter.OracleDebeziumConverter', 'debezium.dinkyDateConverter.database.type'='oracle', 'debezium.dinkyDateConverter.format.date'='yyyy-MM-dd', 'debezium.dinkyDateConverter.format.timestamp' = 'yyyy-MM-dd HH:mm:ss.SSS'

How to reproduce

期望CDC获取oracle日期类型,能够将时间戳转换成正确的日期格式

Anything else

No response

Version

dev

Are you willing to submit PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

ljs033 avatar Jul 27 '24 01:07 ljs033

建议看一下 flink 关于数据类型的映射关系

Zzm0809 avatar Aug 30 '24 06:08 Zzm0809

Hello @, this issue has not been active for more than 30 days. This issue will be closed in 7 days if there is no response. If you have any questions, you can comment and reply.

你好 @, 这个 issue 30 天内没有活跃,7 天后将关闭,如需回复,可以评论回复。

github-actions[bot] avatar Oct 01 '24 00:10 github-actions[bot]