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

Sqoop import converts Microsoft SQL Server bit (1 or 0) data type to true/false

    XMLWordPrintableJSON

Details

    Description

      When moving data between Microsoft SQL Server and Hadoop, a 'bit' data type in SQL Server (a 1 or a 0) is stored as 'true' or 'false' in the generated CSV. This means when an external Hive table is created over this data, the data type has to be set as boolean for this column. If a binary Hive data type is used, weird characters are shown as the underlying data is 'true' or 'false'.

      This can cause issues if the data needs to be moved from Hadoop back into SQL Server as a data type conversion is needed. Therefore, it would be best to implement a 'boolean-true-string' and a 'boolean-false-string' option to override this like what has been done for PostgreSQL. N.B. I'm not using a hive-import and therefore can't override mappings.

      Attachments

        Activity

          People

            Unassigned Unassigned
            MikeEngland Michael England
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: