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

Provide default Java type mapping for MS Sql Datetimeoffset type

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.4.4
    • 1.4.4
    • None
    • 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

        1. SQOOP-1031.1.patch
          2 kB
          Shuaishuai Nie

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. SQOOP-3060 Sqoop export to SQL server fails with DateTimeOffset type

          • Major - Major loss of function.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: