Sqoop
  1. Sqoop
  2. SQOOP-1311

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

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major 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 '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

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:

              Development