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

Provide default Java type mapping for MS Sql Datetimeoffset type

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.4
    • Fix Version/s: 1.4.4
    • Component/s: None
    • Labels:
      None

      Description

      MS SQL database type datetimeoffset causes errors when importing to HDFS. We need to provide a default mapping in SQLServerManager which could still be overriden by users if wanted.
      In order to preserve time zone offset we use String instead of TimeStamp. This would still work when exporting the imported data back to MS SQL Server

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shuainie Shuaishuai Nie
                Reporter:
                shuainie Shuaishuai Nie
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: