sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Lin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3041) Sqoop import TIMESTAMP(6) field into HDFS will truncate tailing zeros in the millisecond part
Date Fri, 28 Oct 2016 04:58:58 GMT
Eric Lin created SQOOP-3041:
-------------------------------

             Summary: Sqoop import TIMESTAMP(6) field into HDFS will truncate tailing zeros
in the millisecond part
                 Key: SQOOP-3041
                 URL: https://issues.apache.org/jira/browse/SQOOP-3041
             Project: Sqoop
          Issue Type: New Feature
          Components: tools
    Affects Versions: 1.4.6
            Reporter: Eric Lin
            Priority: Trivial


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message