Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-1311

Postgres JDBC/direct driver dropping microseconds from 'time without timezone' fields

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.4.3
    • None
    • None
    • 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 'time without timezone' gets its microseconds dropped.

      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

            Unassigned Unassigned
            svallely Scott Vallely
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: