Uploaded image for project: 'StreamSets Data Collector'
  1. StreamSets Data Collector
  2. SDC-9019

MongoDB destination writes date in unix epoch instead of date datatype

    Details

    • Type: Bug
    • Status: Open
    • Priority: P3 (Limited Impact)
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Doc Impact:
      No
    • Testing Status:
      Not Required

      Description

      I've created a simple pipeline that takes records from a mongodb collection (but the origin can be anything else) and write them to another one.

      With the mongodb destination, when a datetime field is written to the database, it is saved as a unix time int64 instead of a date object.

      I've attached the pipeline preview and the source and destination collections.

        Attachments

        1. DbDest.png
          DbDest.png
          5 kB
        2. DbSource.png
          DbSource.png
          4 kB
        3. Destination.png
          Destination.png
          23 kB
        4. Source.png
          Source.png
          20 kB

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jognom John Ognom
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: