Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-3041

Sqoop import TIMESTAMP(6) field into HDFS will truncate tailing zeros in the millisecond part

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 1.4.6
    • Fix Version/s: None
    • Component/s: tools
    • Labels:
      None

      Description

      A column defined as TIMESTAMP(6) will lose it's tailing zeros when imported in HDFS:

      Example, the following data with TIMESTAMP(6) data type:

      2009-11-05 19:01:59.120000
      2009-11-05 19:01:59.000000

      will become

      2009-11-05 19:01:59.12
      2009-11-05 19:01:59.0

      respectively.

      I understand that the values are actually the same as before and we just get rid of tailing zeros, however, in some cases we might need to preserve the tailing zeros.

      It would be good that Sqoop can leave the data as it is in the original database after imported in HDFS

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ericlin Eric Lin
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: