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

DateTime64 conversion logic #232

Closed
subkanthi opened this issue Apr 28, 2023 · 1 comment
Closed

DateTime64 conversion logic #232

subkanthi opened this issue Apr 28, 2023 · 1 comment
Assignees
Labels
GA-1 All the issues that are issues in release(Scheduled Dec 2023) high-priority qa-verified label to mark issues that were verified by QA

Comments

@subkanthi
Copy link
Collaborator

subkanthi commented Apr 28, 2023

When the new records are inserted,

DATETIME, DATETIME(0), DATETIME(1), DATETIME(2), DATETIME(3) INT64 io.debezium.time.TimestampRepresents the number of milliseconds past the epoch and does not include time zone information.
DATETIME(4), DATETIME(5), DATETIME(6) INT64 io.debezium.time.MicroTimestampRepresents the number of microseconds past the epoch and does not include time zone information.
  • Make sure the data is not lost.(precision)
  • Make sure the limits are set correctly on CH(since MySQL and CH limits are different)
  • timezone is retained correctly.
@subkanthi subkanthi self-assigned this May 2, 2023
@subkanthi subkanthi added the GA-1 All the issues that are issues in release(Scheduled Dec 2023) label Dec 18, 2023
@Selfeer
Copy link
Collaborator

Selfeer commented Feb 26, 2024

The issue was verified by the Altinity QA team and marked as qa-verified.

Build used for testing: altinityinfra/clickhouse-sink-connector:464-c979a8c2583ff701dd5b63efb8f36f7fff8111e7-lt

Automated TestFlows tests were added to the develop branch:
https://github.com/Altinity/clickhouse-sink-connector/blob/develop/sink-connector-lightweight/tests/integration/tests/datatypes.py

Requirements for the ClickHouse Sink Connector Lightweight were updated.

@Selfeer Selfeer added the qa-verified label to mark issues that were verified by QA label Feb 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
GA-1 All the issues that are issues in release(Scheduled Dec 2023) high-priority qa-verified label to mark issues that were verified by QA
Projects
None yet
Development

No branches or pull requests

2 participants