[SQOOP-1310] Postgres JDBC/direct driver dropping timezone in 'timestamp with timezone' fields

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.3
• Component/s: connectors/postgresql, sqoop2-client

Environment

CDH 4.6, Postgres JDBC/direct drivers

• Assignee: Unassigned
• Reporter: Scott Vallely
• Created: 17/Apr/14 15:27
• Updated: 17/Apr/14 17:52

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