Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle Date converter is not available #3673

Closed
2 of 3 tasks
ljs033 opened this issue Jul 27, 2024 · 2 comments
Closed
2 of 3 tasks

Oracle Date converter is not available #3673

ljs033 opened this issue Jul 27, 2024 · 2 comments
Labels
Bug Something isn't working Invalid Invalid Waiting for reply Waiting for reply

Comments

@ljs033
Copy link

ljs033 commented Jul 27, 2024

Search before asking

  • 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 ljs033 added Bug Something isn't working Waiting for reply Waiting for reply labels Jul 27, 2024
@ljs033 ljs033 changed the title [Bug] [Module Name] Bug title Oracle Date converter is not available Jul 27, 2024
@Zzm0809
Copy link
Contributor

Zzm0809 commented Aug 30, 2024

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

@github-actions github-actions bot added the Invalid Invalid label Oct 1, 2024
Copy link

github-actions bot commented Oct 1, 2024

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 天后将关闭,如需回复,可以评论回复。

@Zzm0809 Zzm0809 closed this as completed Nov 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working Invalid Invalid Waiting for reply Waiting for reply
Projects
None yet
Development

No branches or pull requests

2 participants