Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-744

Provide option for exporting DATETIME columns as a String

    XMLWordPrintable

Details

    • 0
    • 0% 0%

    Description

      DATETIME columns don't contain TZ information and as such don't represent an exact point on the timeline but rather a logical date and time, such as "2018-01-13 09:48:27". Hence it's questionable to represent such columns as epoch millis, as this requires a time zone for mapping the logical date to such exact point on the time line.

      Currently, UTC is used for this, but this is a rather arbitrary decision and not really transparent to downstream consumers. Therefore, a new mapping mode should be provided, which exports DATETIME columns as strings, keeping their nature of being logical dates and not exact points on the timeline.

      Attachments

        Issue Links

          is related to

          Feature Request - Feature requests from customers and/or users DBZ-335 Serialize TIMESTAMP/DATETIME into String formatted types, using SMT.

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Pull Request Sent

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) DBZ-1373 How to have field type support for date in kafka

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          relates to

          Feature Request - Feature requests from customers and/or users DBZ-1134 Provide SPI to override schema and value conversion for specific columns

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              Unassigned Unassigned
              gunnar.morling Gunnar Morling
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: