[
https://issues.apache.org/jira/browse/SQOOP-1310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Scott Vallely updated SQOOP-1310:
---------------------------------
Description:
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
(microseconds?) 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
was:
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
> 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
> (microseconds?) 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)
