Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-1310

Postgres JDBC/direct driver dropping timezone in 'timestamp with timezone' fields

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.3
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      CDH 4.6, Postgres JDBC/direct drivers

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              svallely Scott Vallely
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: