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] [Updated] (SQOOP-3040) Lost time millisecond precision for Time data type when importing
Date Mon, 16 Jan 2017 05:52:26 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-3040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Eric Lin updated SQOOP-3040:
----------------------------
    Assignee: Eric Lin

> Lost time millisecond precision for Time data type when importing
> -----------------------------------------------------------------
>
>                 Key: SQOOP-3040
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3040
>             Project: Sqoop
>          Issue Type: Bug
>          Components: tools
>    Affects Versions: 1.4.6
>            Reporter: Eric Lin
>            Assignee: Eric Lin
>
> To re-produce, create a MySQL database with time(6) data type:
> {code}
> CREATE TABLE `test` (
>   `a` time(6) DEFAULT NULL
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> INSERT INTO test VALUES ('16:56:53.099999');
> {code}
> Import the data into Sqoop and data will become "16:56:53", the millisecond precision
will be lost.



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

Mime
View raw message