sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Vallely (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-1310) Postgres JDBC/direct driver dropping timezone in timestamp with timezone fields
Date Thu, 17 Apr 2014 17:07:14 GMT

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

Scott Vallely updated SQOOP-1310:
---------------------------------

    Summary: Postgres JDBC/direct driver dropping timezone in timestamp with timezone fields
 (was: Postgres JDBC/direct driver (not direct connect) dropping timezone in timestamp with
timezone fields)

> Postgres JDBC/direct driver dropping timezone in timestamp with timezone fields
> -------------------------------------------------------------------------------
>
>                 Key: SQOOP-1310
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1310
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/postgresql, sqoop2-client
>    Affects Versions: 1.4.3
>         Environment: CDH 4.6, Postgres JDBC/direct drivers
>            Reporter: Scott Vallely
>
> When Sqoop importing from Postgres, with both the direct and generic JDBC drivers, a
field of type 'timestamp with timezone' the timezone (the 
> '-04' suffix in the example below) gets dropped and a dot followed by numbers (milliseconds?)
gets appended.
> Example.
> Data in Postgres:
> 142
> 318
> 2
> 2012-10-04
> null
> 2014-04-09 05:30:00-04
> null
> null
> 31
> 2014-04-08 05:30:00-04
> 05:30:00.489898
> Data in HDFS (with unprintable field delimiters):
> 14231822012-10-04null2014-04-09 05:30:00.0nullnull312014-04-08 05:30:00.005:30:00



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message